Re: Double database load.

I would increase sga and buffer size.
I would get statpacks reports to see how things are working now (level 7 if
possible, b ut include execution paths), then after the increase, you could
have something to compare with.

Personally I'll wait to that moment, run statpacks as soon as possible,
I will stay all the night in the office optimizing and fix what is wrong.

One of my application said that the load on the database will double in =
the month of September. They will be rolling out the app. to lot more =
people.
What are the precautions I need to take besides space?
How do I know if the SGA is enough? It is a datawarehouse.
Any suggestions are appreciated.

Thanks

Chaya Patamalla=20
I/T Database Administrator=20
=A0=A0=A0=A0=20
--"The opinions expressed herein are solely the author's and are not =
necessarily the opinion of USAA."=A0--=A0=A0=A0=A0=A0=A0=A0=A0=A0=20

> Leroy,
>=20
> If you could include row source cardinality information it will help =

to identify areas for improvement using the throw-away
> methodology. From my perspective, it is also hard to read the output =
and understand the order of execution. Using the indentation
> method found in oracle doc (or including all the STAT lines as they =
are output) would be helpful.
>=20
> Don't give up hope, we're happy to help, we just need to have the =
information to assist.