| cpu usage-oracle.exe shoots up to 80%-90% [message #56122] |
Thu, 06 March 2003 23:06  |
kareka
Messages: 18
Registered: January 2003
|
Junior Member |
|
|
hi all,
i am running a database that is capturing data online from a production process....the oracle exe process memory usage shoots up to above 80% at times....where should the problem detection effort start from........any quick suggestions will be appreciated...
thanks
|
|
|
|
|
|
| Re: cpu usage-oracle.exe shoots up to 80%-90% [message #56129 is a reply to message #56122] |
Fri, 07 March 2003 03:09  |
kareka
Messages: 18
Registered: January 2003
|
Junior Member |
|
|
in fact the
select * from v$sga;
fixed size 282616
varaiable size 83886080
database buffers 41943040
redo buffers 532480
and the buffer hit ratio is around 70%....i can increase the size but first i wanted to know if the problem is due to some other issue....at the moment cpu usage is around 20%.......5 machines are accessing the database and 16 sessions are concurrently holding the db.....can locking contention result in high cpu usage...........what else to check in case of such a problem again cropping up......
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
