| ora_snp running.why? [message #63328] |
Mon, 27 September 2004 13:22  |
jimbob
Messages: 20
Registered: April 2004
|
Junior Member |
|
|
I am running oracle 8.1.7 on solaris. I am NOT running snapshots or materialized views. I am seeing the ora_snp processes (ora_snp0-ora_snp3) running with one of them taking over 90% of cpu. I don't see any options in the init.ora that have snapshot running, nor are there any jobs in the queue that are attempting to do so? Any ideas how snapshot thinks it is running? or how to disable?
jb
|
|
|
|
| Re: ora_snp running.why? [message #63332 is a reply to message #63328] |
Mon, 27 September 2004 20:13  |
TANMAIYEE
Messages: 5
Registered: September 2004
|
Junior Member |
|
|
|
please check you job-queue-interval and job-queue-process init parameters. These might have changed.. or someone scheduled few dbms_jobs... with broken/failed jobs with small intervals running continuously... work on these areas should help.
|
|
|
|
| Re: ora_snp running.why? [message #63345 is a reply to message #63332] |
Tue, 28 September 2004 07:50 |
jimbob
Messages: 20
Registered: April 2004
|
Junior Member |
|
|
Tanmaiyee,
That was it! Thank you...I forgot that the snp process are used for jobs in the queue. One of my jobs was running away...I couldn't find the associated process in the v$session table, so I just killed the job at the os level. > kill -9 pid
Cool thing was that oracle saw that I killed the ora_snp0 process and restarted it. Thanks again.
jb
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
