Using Explain PLan+ System global area

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
Received on Tue Aug 21 2001 - 00:49:59 CEST