When the buffer is clean it forces physical reads which impacts the performance.
When you say 90% of CPU, do you mean to say that in TOPAS command you were able to see the CPU consumption like this :
Name PID CPU% PgSp Owner
oracle 1111111 90.0 109.2 orasid
2-: The OS is AIX5.3. Currently the CPU has dropped already after we update the stats but prior to that, the rough average CPU utilization is 2% for Oracle processes which in total is 90%++. We are running in IBM Pseries box, Its actually a Portal system DB, so we dont actually expect that it would be really using much resources, our application is in another server (Windows) so its pure DB running on this server. Memory is 15GB, CPU is 1.8x2 2GHz.
3-: If it is AIX or any other UNIX systems what is consuming more CPU in topas or top command ? What box is that ?
what is the configuration - Memory, CPU.
How much memory have you assigned for SGA, PGA and also the memory used by the processes ?
No comments:
Post a Comment
your comment will be visible after administrator approval