Tunning a SQL statement [message #2315] |
Fri, 05 July 2002 05:39 |
Lee
Messages: 56 Registered: May 1999
|
Member |
|
|
Hello,
Is there a command or set of commands that I may issue to Oracle that would analyze/tune a large SQL statement? If so, does the user have to have certain rights to issue the command?
Thanks
|
|
|
Re: Tunning a SQL statement [message #2322 is a reply to message #2315] |
Sat, 06 July 2002 00:58 |
K.SREENIVASAN
Messages: 110 Registered: January 2001 Location: banglore
|
Senior Member |
|
|
SIR,
IF YOU WANT TO TUNE THE SQL STATEMENTS,THEN FIRST YOU SHOULD RUN A SCRIPT CALLED UTXPLAN.SQL .IT IS IN THE ORACLE_PATHREDBMS80 DIRECTORY.THEN YOU SHOULD RUN THE SCRIPT IN YOUR CURRENT USER AND IT WILL CREATE PLAN_TABLE WHICH STORES THE TUNNING DETAILS.
THEN GIVE THE COMMAND
SQL>SET AUTOTRACE ON
THEN YOU CAN RUN THE SQL QUERY.IT WILL GIVE RESULTS AND ALL THE TRACING MESSAGES TO YOU.
IF YOU WANT TO ANALYSE THE TABLE, THEN USE ANALYSE COMMAND AND DBA_TABLES.
K.SREENIVASAN
|
|
|