Home » RDBMS Server » Performance Tuning » Reading DBMS_XPLAN output
Reading DBMS_XPLAN output [message #274488] Tue, 16 October 2007 04:03 Go to next message
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 Go to previous messageGo to next message
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

Re: Reading DBMS_XPLAN output [message #274497 is a reply to message #274488] Tue, 16 October 2007 04:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Performance Tuning Guide
Chapter 19 Using EXPLAIN PLAN

Regards
Michel
Re: Reading DBMS_XPLAN output [message #274501 is a reply to message #274497] Tue, 16 October 2007 04:35 Go to previous messageGo to next message
emreb
Messages: 5
Registered: September 2007
Junior Member
I read this document but It is detailed only 2 row output
I need to detailed explanation about 5-6 or more rows output
Re: Reading DBMS_XPLAN output [message #274510 is a reply to message #274501] Tue, 16 October 2007 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
2 rows output?
Read again the chapter there are many plans with much more than 5-6 rows.

Regards
Michel
Re: Reading DBMS_XPLAN output [message #274527 is a reply to message #274510] Tue, 16 October 2007 05:22 Go to previous message
emreb
Messages: 5
Registered: September 2007
Junior Member
Thats more about parallel execution
Previous Topic: parallel query
Next Topic: sql performance issue.
Goto Forum:
  


Current Time: Sat Dec 03 05:44:54 CST 2016

Total time taken to generate the page: 0.04854 seconds