-
Title
Upgraded from 8.x to 9.x and the information displayed in the Explain Plan is different -
Description
I just upgraded from 8.x to 9.x and want to change the way my explain plan is displayed.
I want to view it as closely as possible to what it looked like in 8.x i.e.
Rows | Bytes | Cost | Object Node | In/out | Pstart | Pstop -
Cause
The Explain Plan module was redesigned in 9.0
-
Resolution
To change the way the explain plan is displayed:
1. In the Explain Plan pane <right-click> | Select 'Tree' Mode
2. <right-click> Adjust Content
3. Rows - is now 'Cardinality' - check 'Visible' and 'As Column'
4. Bytes - check 'Visible' and 'As Column'
5. Cost - check 'Visible' and 'As Column'
6. Object Node - is now REMOTE - check 'Visible' and 'As Column' .
** NoteObject Node is used when there are db links (it tells which database the object_name is on). If you have v9.0 - v9.5, you will have to edit
ExplainPlanColumnDefs to make it appear. Follow the link for details:
http://www.nabble.com/object_node-in-explain-plan-td11952517.html
7. In/Out - is now 'Other' - check 'Visible' and 'As Column'
8. Pstart and Pstop is now 'Partitions' - check 'Visible' and 'As Column'