| Reading DBMS_XPLAN output [message #274488] |
Tue, 16 October 2007 04:03  |
emreb
Messages: 5
Registered: September 2007
|
Junior Member |
|
|
Hii All..
How can I reading succesfully dbms_xplan output ?
I must follow the id column from bottom to top? or follow parent child relation ? or another
After did that How can I check I am wrong or success ? is there any tool for that ?
|
|
|
|
| Re: Reading DBMS_XPLAN output [message #274494 is a reply to message #274488] |
Tue, 16 October 2007 04:20  |
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
|
Senior Member |
|
|
If I were you, I will first read the oracle documentation. It has information about how to understand the plan. If that is not enough try to read the books written by Thomas Kyte (asktom.oracle.com). He talks in detail word by word how to interpret the plan output and the raw trace file produced from TKPROF.
Hope that helps
Regards
Raj
P.S : Typo
[Updated on: Tue, 16 October 2007 04:21] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
