kyle Hailey
Outlines from DBMS_XPLAN
dbms_xplan.display_cursor will output the hints for a plan. These hints can then be taken and used in an outline for plan stability:...
top of page
Success is about Imagination
Ignite Your Passion
kyle Hailey
Sep 4, 20091 min read
dbms_xplan.display_cursor – what are all those arguments?
Nice table on http://www.psoug.org/reference/dbms_xplan.html and some more discussion on http://jonathanlewis.wordpress.com/2008/03/06/db...
14 views0 comments
kyle Hailey
Sep 4, 20091 min read
Diff’ing Explain Plans
Diff’ing explain plans is difficult and tedious.>Here is a new package function from Oracle for diff’ing explain plans...
9 views0 comments
kyle Hailey
Sep 3, 20091 min read
plan stability and predicate evaluation order and more
Here’s some nice code for looking at multiple child cursors with the same plan hash and evaluating through hashing other parameters to...
0 views0 comments
kyle Hailey
Sep 3, 20091 min read
Statistics on function in predicates for CBO
ASSOCIATE STATISTICS WITH FUNCTIONS my_function DEFAULT SELECTIVITY 0.1; ASSOCIATE STATISTICS WITH FUNCTIONS my_function DEFAULT COST...
3 views0 comments
kyle Hailey
Sep 3, 20091 min read
Explain Plans
Explain Plans can be had via Explain Plan (version ? ancient) Trace Files (starting 7.3) Autotrace (starting 8.1.7) V$SQL_PLAN (starting...
2 views0 comments
kyle Hailey
Sep 3, 20091 min read
Latch: Cache Buffers Chains
Check out Tanel’s analysis and scripts for cache buffer chains latch contention analysis. Solid stuff: http://blog.tanelpoder.com/2009/08...
12 views0 comments
kyle Hailey
Sep 3, 20091 min read
Alberto Dell’Era’s XPLAN
Check out Alberto Dell’Era’s SQL query analyzer – lots of good info like this compact table of indexes availble on the query:...
18 views0 comments
kyle Hailey
Jun 26, 20091 min read
SQL Joins
Growing up on Ansi 89 and working at Oracle for 10 years, some of the the cleaner SQL join notation seems new to me. Here is a great...
18 views0 comments
kyle Hailey
Jun 10, 20091 min read
SQL Videos
More videos from Stéphane Faroult I have yet to go through these videos but based on the previous two I posted from Stephane, these...
3 views0 comments
kyle Hailey
Jun 5, 20091 min read
Finding the problem is the hard part
Interesting blog on how finding performance problems takes 80% of the mean time to resolution. Sybase ASE Performance and Tuning This is...
22 views0 comments
kyle Hailey
Jun 4, 20091 min read
Types of subqueries
Types of subqueries (today I couldn’t think of the term “inline view”) subquery ( subselect used in where clause) correlated subquery...
3 views0 comments
kyle Hailey
Jun 4, 20091 min read
Stephen Faroult on Tuning SQL
One of the main things I do to tune SQL is to encourage the optimizer to take path. I often take the most important steps to do first and...
7 views0 comments
kyle Hailey
Jun 1, 20091 min read
Correlating SQL to Procedures
Starting in Oracle 10.2.0.3 (ie not 10.2.0.2 and below) it’s easy to track what package and/or procedure a SQL execution came from using...
9 views0 comments
kyle Hailey
Jun 1, 20091 min read
Stephan Faroult’s Videos
I love this video on “getting dreadful database performance” by Stephan Faroult. The video is hilarious and infomative:...
9 views0 comments
kyle Hailey
May 15, 20091 min read
"kksfbc child completion"
I’ve run into the wait “kksfbc child completion” a few times over the past but found very little written about it. I don’t have an...
13 views0 comments
kyle Hailey
May 12, 20091 min read
Concurrency Testing
One complaint I’ve heard of a number times is how code gets tested with one user and it runs fine and then gets put into production and...
9 views0 comments
kyle Hailey
May 11, 20091 min read
To Pie Chart or not to Pie Chart
I’ve always had a natural aversion to pie charts. Pie charts seem all the less apealing when compared to bar charts. I’ve wondered if it...
4 views0 comments
kyle Hailey
May 8, 20091 min read
SQL*Net break/reset to client
Another problematic wait event in Oracle is “SQL*Net break/reset to client”. This wait event typically happens when there is something...
54 views0 comments
kyle Hailey
Apr 30, 20092 min read
Lock Waits: Finding the blocking SQL on Oracle
One of my pet peeves on Oracle is the inability to find out what SQL took out a lock that another user is waiting. It’s easy to find the...
19 views0 comments
bottom of page