Home » RDBMS Server » Server Administration » snp process taking lot of cpu usage
snp process taking lot of cpu usage [message #153822] Wed, 04 January 2006 04:55 Go to next message
kirdha1
Messages: 18
Registered: July 2005
Junior Member
I have oracle 9.2.0.5 database on AIx 5.2 server. I have 3 instance on it. one of the instacne has snp0 process runing for last 3 days and consumming lot of cpu usage about 73%. Even after shuting down the database snp0 process was on. and is still running. Can I kill the porcess? As it is job queue process how can I know what opreation is taking place?

wating for your replies.

Thankyou

Report message to a moderator

Re: snp process taking lot of cpu usage [message #153839 is a reply to message #153822] Wed, 04 January 2006 06:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Is that a broken job or what?
>>Even after shuting down the database snp0 process was on.
Must have become a zombie.
Talk to your sysadmin. Try to manually kill the process. Else reboot the machine.

Report message to a moderator

Re: snp process taking lot of cpu usage [message #154281 is a reply to message #153839] Fri, 06 January 2006 10:20 Go to previous message
kirdha1
Messages: 18
Registered: July 2005
Junior Member
thanks of your reply
I have checked and killed the process manually.

thank you very much
Cool

Report message to a moderator

Previous Topic: Oracle Installation Problem(9.2.0) on linux
Next Topic: can oracle9i run under 64 bit cpu ??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 15:39:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.