Home » SQL & PL/SQL » SQL & PL/SQL » Tunning a SQL statement
Tunning a SQL statement [message #2315] Fri, 05 July 2002 05:39 Go to next message
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 Go to previous message
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
Previous Topic: like queries
Next Topic: appending table data
Goto Forum:
  


Current Time: Thu Mar 28 04:39:11 CDT 2024