Below are observations of database slowness
1. Database server CPU usage is 95%97% at any point in time.
2. Concurrency is about 320 users at time.
3. Inadequate SGA sizing which is capped to 20GB however in system there is 143 GB memory available.
4. Auto Optimizer Stats/Space Advisor/Tuning Advisor is enabled.
5. Frequent ORA4031 “unable to allocate x bytes of shared memory” observed.
6. Auto extend is enabled on the tablespace.
7. Redo Switches are quite high (2530per hour).
No comments:
Post a Comment