Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: no exec
So... do you understand that explanation Jonathan? Maybe you could include it in your next book? ;-) George Barbour/
"Chirag" <shahcm_at_yahoo.com> wrote in message
news:732c49b9.0106050153.f66b44d_at_posting.google.com...
> 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
>
> 1. For EXPLAIN PLAN, we've to create table called PLAN_TABLE in
> SYSTEM schema. Script for creating this table is available in your
> Oracle Home directory (find out) with the name as utlxplan.sql.
> 2. Then you've to create plustrace role using PLUSTRCE.SQL file. It
> is also available in Oracle Home dir (pl. find )
> 3. Then grant plustrace role to your database schema(user). e.g
> login to sql*plus
>
> 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 - 09:47:25 CDT