Re: Using Explain PLan+ System global area

arunbhat01_at_yahoo.com (Arun) wrote in message news:<127e8357.0108201449.6aff549f_at_posting.google.com>...
> I'm an ORacle newbie.
> 1:>I want to know the location of the UTLXPLAN.SQL ,UTLXPLS.SQL
> ,UTLXPLP.SQL sql scripts in the Windows operating system.In the
> oracle documentation the location is mentioned for the Unix operating
> system.
> These scripts are useful when using the explain plan option.
> Do i have to create these scripts?
> If i have to manually create the plan table, where should i place
> it?(in the Windows OS)?
>
> 2:>I have tables which are 350 MB in size and often need to perform
> updates using joins.Presently my system global area is about 50 MB
> which causes the queries to be rather slow.
> What would be a good size for the SGA?
>
> -Thanx
> -arun

1 scripts are located in %ORACLE_HOME%\rdbms\admin or %ORACLE_HOME%\rdbms<xx>\admin before 8i where xx is the two digit version number.
Obviously, you create a table in the database, not in the OS 2 I would rather concentrate on optimizing the statements. Due to the nature of the buffer mechanism, you will never be capable of caching them in memory. I wouldn't enlarge the cache, or suggest you to read up in the performance tuning manual how you can determine it's efficiency.
As the question to this answer is version specific and you don't mention which version you are using I will leave it at this. Can't outline the procedures for various different versions in an Usenet post.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Tue Aug 21 2001 - 09:21:12 CEST