Karl Arao

@karlarao

Sr. Technical Consultant at Enkitec, Oracle ACE, OCP-DBA, RHCE, OakTable --- http://karlarao.wordpress.com http://karlarao.tiddlyspot.com

Photos and Videos by @karlarao

  • Timeline
  • Gallery

Yes, the AAS CPU graph on the OEM is correlated (R2 of .80) with the CPU core usage (CPU_COUNT=24 for Exadata X2)

  • 864 days ago via site
  • 111

& this viz is useful for finding bad SQLs doing inefficient offloading across 30+ instances on Exadata

  • 887 days ago via site
  • 88

TopSQLx data points to be added to the AWR Tableau Toolkit with dimensions (module, sql_id, command_type,& TIME)

  • 887 days ago via site
  • 189

Cary being interviewed by Kerry on his perspective on Exadata #E4

Enkitec Extreme Exadata Expo (E4) is in two weeks! it will be lots of good schtuff ;)

  • 914 days ago via site
  • 87

whoshaa! finally got my awesome RHCE jacket ;) that's a thumbs up BTW!

Output of awr_iowl/awr_iowlexa.sql(exadata) mentioned on blog http://goo.gl/I3fjn, get here http://goo.gl/eq9Sn

  • 944 days ago via site
  • 89

oh yeah! successfully forecasted the CPU utilization of a RAC downsize migration (4->2nodes) from Itanium to x86

  • 955 days ago via site
  • 337

yes, a pure OLTP workload is pretty much 70%reads 30%writes.. 5months workload, 700+ AWR data points

  • 958 days ago via site
  • 87

batch SQL from 10hours to 5secs... sweeeet! #SqltxplainAwesomeSQLTroubleshootingTool #Exadata #Peoplesoft

  • 968 days ago via site
  • 127

protip: play w/ kernel profiling tools on d VMguest,it won't hurt crashing it.DesktopServer host uptime back to 0!

  • 969 days ago via site
  • 66

SLOB zeroWriters-128Readers run on my R&Dserver - 2ndGenSandyBridge,16GBram,8shortstrokedHDs http://goo.gl/nKYOS

  • 971 days ago via site
  • 74

AWR Tableau and R visualization examples http://goo.gl/lp5rB #Exadata will also upload his R viz!

  • 978 days ago via site
  • 112

DOUG #exadata meetup

smartscanloop of IOsaturationtoolkit-v2 now contains Hierarchy of Exadata IO http://goo.gl/eq9Sn goo.gl/YYlhI

  • 993 days ago via site
  • 76

IOsaturationtoolkit-v2 now contains SECTION 2 for Exadata IORM test cases and AWESOME graphs http://goo.gl/eq9Sn

  • 994 days ago via site
  • 87

1st -> 2nd quarter CPU cores utilization on multi-tenant Peoplesoft/BIEE on half rack Exadata #Tableau #Exadata

  • 1003 days ago via site
  • 215

WorkloadGrowthAskingMoreCPUcores,spread across 3nodes for BetterUtilization.EasyCapacityPlanning #Tableau #Exadata

  • 1004 days ago via site
  • 128

100days of DesktopServer uptime, this calls for blogging the build HOWTO and the overall configuration :)

  • 1040 days ago via site
  • 44

AAS and CPU% motion chart per Exadata compute node

  • 1040 days ago via site
  • 96