Re: tunning help needed...

Hi.

1. It looks like you have a lot of non-reusable SQL statements (may be your applications is using hard-coded values instead of bind variables). > % SQL with executions>1: 15.21 14.83
   > % Memory for SQL w/exec>1: 24.97 23.97
   
2. You have a lot of "db file scattered read" operations that means FULL table scans. Look for un-tuned SQL statements.
3. Set timed_statistics = true in INIT.ORA otherwise all time-related values of STATSPACK are set to 0.
4. IMHO there is no need to increase sort_area_size (In-memory Sort %: 99.41).
5. Look for PL/SQL procedures/functions/packages you may pin into shared pool.

HTH. Michael Received on Mon Mar 25 2002 - 01:35:47 CST