Home » RDBMS Server » Server Administration » CPU TIME (WINDOWS 2003 SERVER)
CPU TIME [message #333045] Thu, 10 July 2008 06:35 Go to next message
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
Michel Cadot
Messages: 64145
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
Previous Topic: DBMS Package
Next Topic: Oracle Relink - Advice required (merged)
Goto Forum:
  


Current Time: Fri Dec 09 11:41:30 CST 2016

Total time taken to generate the page: 0.08192 seconds