Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: no exec
Hi Jonathan
In Oracle to see execution plan of SQL query, we've complete tuning utilities is available called EXPLAIN PLAN. You may read extensively Oracle8i Performance Tuning Manual or any book regarding Oracle Performance Tuning.
For this the least you can do is
CONNECT SYSTEM/MANAGER_at_DB
@C:\ORANT\RDBMS80\ADMIN\utlxplan.sql;
@C:\ORANT\RDBMS80\ADMIN\PLUSTRCE.SQL;
GRANT plustrace to SCOTT; CONNECT SCOTT/TIGER_at_DB SET TRACE TRACEONLY; then you test your queries.
Chirag Shah
Oracle Administrator Received on Tue Jun 05 2001 - 04:53:26 CDT