Re: How to tune for "too many" users ?

Hi,
here some ideas:
- check memory (avoid heavy memory management) and cpu usage on OS level.

• check for disk io
• optimizer mode = choose. Did you generate statistics on tables / indexes?
• did you use CBO with 8.0, too?
• check for most expensive statements in terms of diskreads and buffergets (v$sql). Tune them!

Regards
Stephan Received on Wed Apr 30 2003 - 03:21:29 CDT