Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Creating PLAN TABLE

448776Aug 22 2005 — edited Sep 5 2010

Hi,
I am Rajkumar.I faced some interview questions in TKPROF and EXPLAIN PLAN.I am a fresher in Oracle DBA.Could any one explain me about Creating PLAN TABLE.
1)Where to create the PLAN TABLE?
2)How to Create the table.?
I 've tried to create plan table as per documentation

SQL>connect hr/pwd
SQL>******path for utlxplan.sql******.
It's not working
3)How to execute the script.?
4)Where to execute the script?

Thanks in Advance

Raaj

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 3 2010

Added on Aug 22 2005

#general-database-discussions

14 comments

30,710 views