Or
Set autotrace traceonly exp
<run your query>
There are other options to autotrace (such as statistics etc.)
-----Original Message-----
From: Hudspith Adam
[mailto:oracledba-ezmlmshield-x6438823.[Email address protected]
Sent: Thursday, November 02, 2006 7:27 AM
To: LazyDBA Discussion
Subject: RE: procedure for explains
Make sure you have a PLAN_TABLE (run
$ORACLE_HOME/rdbms/admin/utlxplan.sql
if needed)
Explain your query ...
explain plan for select * from dual;
Select from the plan in a readable format;
select
substr (lpad(' ', level-1) || operation || ' (' || options || ')',1,30
)
"Operation",
object_name
"Object"
from
plan_table
start with id = 0
connect by prior id=parent_id;
Operation Object
------------------------------ ------------------------------
SELECT STATEMENT ()
TABLE ACCESS (FULL) DUAL
Adam
-----Original Message-----
From: quigleyd
[mailto:oracledba-ezmlmshield-x9317052.[Email address protected]
Sent: 02 November 2006 13:06
To: LazyDBA Discussion
Subject: procedure for explains
Does anybody have a step by step procedure for creating an explain plan,
I
have
seen bits and peices and this is one area I need help.
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
************************************************************************
****
****
IMPORTANT NOTICE
House of Fraser (Stores) Limited
Registered office: Granite House, 31 Stockwell Street, Glasgow G1 4RZ
Company Number: 10677
If you have received this e-mail in error, please notify the sender and
delete the e-mail and attachments immediately. This e-mail (including
any
attachments) may contain confidential and/or privileged information. If
you
are not the intended recipient, any reliance on, use, disclosure,
dissemination, distribution or copying of the e-mail or attachments is
strictly prohibited.
We have checked for viruses but the content of an attachment may still
contain software viruses, which could damage your computer system. We do
not
accept liability for any damage you sustain as a result of a virus
introduced by this e-mail or attachment and you are advised to use
up-to-date virus checking software. E-mail transmission cannot be
guaranteed
to be secure or error free.
This e-mail is not intended nor should it be taken to create any legal
relations, contractual or otherwise.
To view our latest in-store news click on:
http://www.houseoffraser.co.uk
************************************************************************
****
****
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page