| CPU TIME [message #333045] |
Thu, 10 July 2008 06:35  |
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
You must NEVER touch CPU_COUNT unless Oracle support asks you to do so.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
