vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| |||
| On 1 Jul 2003 07:58:12 -0700, Ed wrote: > 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 It should be in $ORACLE_HOME/rdbms/admin |
| |||
| 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 |
| ||||
| 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 |