Thread: utlxplan.sql
View Single Post

   
  #4 (permalink)  
Old 02-22-2008, 05:39 PM
Telemachus
 
Posts: n/a
Default Re: utlxplan.sql

But if someone has removed it it won't be there.

you will find it on the JARs on the install CD. you will also find a desc.
of it in the tuning guide.
"michael ngong" <mngong@yahoo.com> wrote in message
news:ecf365d5.0307011047.3c038bbe@posting.google.c om...
> edreyes77@hotmail.com (Ed) wrote in message

news:<5bb04c8c.0307010658.5f228546@posting.google. com>...
> > Does anyone have the utlxplan.sql script to create a plan_table for
> > our latest oracle 9i installation?
> > If so please send to me.
> >
> >
> > Thanks In Advance,
> > Ed Reyes

>
>
> utlxplan script is found in oracle home /rdbms/admin directory
>
> ............................8.1.7/rdbms/admin >ll | grep utlx
> -rw-r--r-- 1 oracle dba 1715 Oct 22 1999 utlxplan.sql
> -rw-r--r-- 1 oracle dba 4660 Jan 21 2000 utlxplp.sql
> -rw-r--r-- 1 oracle dba 3682 Jan 21 2000 utlxpls.sql
>
>
>
> Michael Tubuo Ngong



Reply With Quote