How to Enable AUTOTRACE
Enable AUTOTRACE To get full AUTOTRACE feature in your session, you should take the following steps. Need PLAN_TABLE table to be accessed in user's schema.… Read More »How to Enable AUTOTRACE
PLAN_TABLE
How to Install PLAN_TABLE Table
To enable AUTOTRACE feature in your session, you not only need PLUSTRACE role to be installed, but also need to create PLAN_TABLE table, which is… Read More »How to Install PLAN_TABLE Table
How to Get the Execution Plan of a Specific Statement
Sometime, there is no OEM around to check the explain plan of a specific statement. We need a bare way to do the job. Here… Read More »How to Get the Execution Plan of a Specific Statement