| Author |
Message |
Mike King
*nix forums beginner
Joined: 03 Jan 2006
Posts: 5
|
 Posted: Wed Jul 12, 2006 8:19 pm Post subject:
Enabling the PLAN_EXPLAIN table
|
|
|
I'm having query performance problems, so I want to run "EXPLAIN PLAN" but I
don't have access to the PLAN_EXPLAIN table. I have told my DBA that I
would like the able to use the "EXPLAIN PLAN" feature but she said she would
have to reseach how to. What does she need to know to enable the "EXPLAIN
PLAN" feature for me? |
|
| Back to top |
|
 |
psoug
*nix forums Guru
Joined: 15 May 2005
Posts: 3492
|
| Posted: Wed Jul 12, 2006 8:31 pm Post subject:
Re: Enabling the PLAN_EXPLAIN table
|
|
|
Mike King wrote:
| Quote: | I'm having query performance problems, so I want to run "EXPLAIN PLAN" but I
don't have access to the PLAN_EXPLAIN table. I have told my DBA that I
would like the able to use the "EXPLAIN PLAN" feature but she said she would
have to reseach how to. What does she need to know to enable the "EXPLAIN
PLAN" feature for me?
|
Your DBA should be replaced by management.
That said if you have Oracle 9i or before have your DBA run
the following script:
utlxplan.sql
If 10g then catplan.sql
Both scripts are located at $ORACLE_HOME/rdbms/admin
Your DBA can email me directly if they have any questions such
as where to find training. ;-)
Syntax and Explain Plan demos can be found in Morgan's Library
at www.psoug.org under Explain Plan. Use DBMS_XPLAN to display
explain plan results using one of the following scripts (located
in the same directory):
utlxplp.sql (parallel)
utlxpls.sql (serial)
utlxmv.sql & utlxrw.sql (materialized views)
Your DBA should send you these files if you can't access them.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org |
|
| Back to top |
|
|
Sybrand Bakker
*nix forums Guru
Joined: 03 Apr 2005
Posts: 1766
|
| Posted: Wed Jul 12, 2006 8:31 pm Post subject:
Re: Enabling the PLAN_EXPLAIN table
|
|
|
On Wed, 12 Jul 2006 16:19:37 -0400, "Mike King" <emailMK@excite.com>
wrote:
| Quote: | I'm having query performance problems, so I want to run "EXPLAIN PLAN" but I
don't have access to the PLAN_EXPLAIN table. I have told my DBA that I
would like the able to use the "EXPLAIN PLAN" feature but she said she would
have to reseach how to. What does she need to know to enable the "EXPLAIN
PLAN" feature for me?
|
Run the most recent UTLPLAN script in $ORACLE_HOME/rdbms/admin
as (preferably0 SYSTEM.
Grant SELECT, INSERT, DELETE privilege on the PLAN_TABLE to PUBLIC.
Create a public synonym for the PLAN_TABLE.
Dead easy and can be retrieved from http://tahiti.oracle.com by
searching for EXPLAIN PLAN.
Please avoid asking questions you could answer yourself faster than
this newsgroup.
--
Sybrand Bakker, Senior Oracle DBA |
|
| Back to top |
|
|
Mike King
*nix forums beginner
Joined: 03 Jan 2006
Posts: 5
|
| Posted: Wed Jul 12, 2006 8:41 pm Post subject:
Re: Enabling the PLAN_EXPLAIN table
|
|
|
| Quote: | Please avoid asking questions you could answer yourself faster than
this newsgroup.
|
My company has implemented Websense (Internet usage control software) which
currently is blocking access to Google groups, so I cannot perform a search
but I post using Outlook Express. What's funny is IT doesn't have access to
Google groups as well. It stupid, I know. |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Tools
