CPU TIME [message #333045] |
Thu, 10 July 2008 06:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
srini_thiru
Messages: 133 Registered: May 2008
|
Senior Member |
|
|
Hi,
I have generated statspack report from my production database and in Top 5 Timed Events CPU TIME has an total call time of 53.1%.
What i have to do to decrease this. Whether i have to increase the CPU_COUNT or not.
Details of my Production Database is:
CPU_COUNT=16
RAM=8GB
DB_CACHE_SIZE=1GB
DB_BLOCK_SIZE=8192
pga_aggregate_target = 1.41GB
shared_pool_size = 200MB
Thanks in Advance,
Seenu
|
|
|
Re: CPU TIME [message #333057 is a reply to message #333045] |
Thu, 10 July 2008 07:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68667 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You must NEVER touch CPU_COUNT unless Oracle support asks you to do so.
Regards
Michel
|
|
|