kyle HaileyNov 18, 20091 minOracle’s Cardinality Hint, Profiles, Outlines and SQL BaselinesThis is more of a bookmark for a future blog post on using the Cardinality hint. This post by Greg Rahn give some example and I posted in...
kyle HaileyNov 17, 20091 minExplain Plan vs Real Plan on OracleA good part of my presentation Friday at NoCOUG was on explain plan command being an estimate of the actual execution plan. Now on the...
kyle HaileyNov 12, 20091 minReal Time SQL Monitoringhere is a feature that I’m excited about: Real Time SQL Monitoring http://askdba.org/weblog/2009/09/11gr2-monitoring-real-time-sql-plan-e...
kyle HaileyOct 22, 20091 minOracle DBA Views !Ever wonder why some of those DBA_ views take so long to execute? here is the view expansion of a query from SYS.DBA_ALL_TABLES joined...