high cpu activity on sun [message #149821] |
Mon, 05 December 2005 03:07 |
maoro
Messages: 312 Registered: May 2005
|
Senior Member |
|
|
hello
i need help over this plz
i have an oracle9i server on a sun solaris , even with one connection to the database there is more than 60% activity on cpu ,even its a dula cpu and the SGA is BIG enough & statistics shows eveything is fine ????
thanks in advance
|
|
|
|
Re: high cpu activity on sun [message #149925 is a reply to message #149821] |
Mon, 05 December 2005 13:44 |
nmacdannald
Messages: 460 Registered: July 2005 Location: Stockton, California - US...
|
Senior Member |
|
|
Use 'top' (as root) to see which process is taking that much CPU. Then post the results to this forum.
Do not give Oracle so much SGA and PGA that it exceeds (physical RAM - other memory requirements like O/S) or it will swap, using CPU.
|
|
|