Re: process ora_snp0 using High CPU

On Mon, 8 Sep 2008 01:13:40 -0700 (PDT), eliot06 <p.hirth_at_gmail.com> wrote:

>Someone could tel me why a process ora_snp0 is using high cpu (20 %
>with Topas into AIX) and create lost of Defunct :
>
><JDEPROD> /home/oracle#ps -ef | grep -i 249866
> oracle 21148 249866 0 0:00 <defunct>
> oracle 26018 249866 0 0:00 <defunct>
> oracle 38936 249866 0 0:00 <defunct>
> oracle 44238 249866 0 0:00 <defunct>
> oracle 45256 249866 0 0:00 <defunct>
> oracle 46770 249866 0 0:00 <defunct>
> oracle 54250 249866 0 0:00 <defunct>
> oracle 57880 249866 1 0:00 <defunct>
> oracle 103878 249866 0 0:00 <defunct>
> oracle 109504 249866 0 0:00 <defunct>
> oracle 112312 249866 0 0:00 <defunct>
> oracle 113330 249866 0 0:00 <defunct>
> oracle 118020 249866 1 0:00 <defunct>
> oracle 120122 249866 0 0:00 <defunct>
> oracle 124640 249866 0 0:00 <defunct>
> oracle 129494 249866 0 0:00 <defunct>
> oracle 132206 249866 0 0:00 <defunct>
> oracle 144640 249866 0 0:00 <defunct>
> oracle 147946 249866 0 0:00 <defunct>
> oracle 148262 249866 0 0:00 <defunct>
> oracle 150406 249866 0 0:00 <defunct>
> oracle 161438 249866 0 0:00 <defunct>
> oracle 166776 249866 0 0:00 <defunct>
> oracle 167984 249866 0 0:00 <defunct>
> oracle 169768 249866 0 0:00 <defunct>
> oracle 174060 249866 1 0:00 <defunct>
> oracle 176736 249866 0 0:00 <defunct>
> oracle 181828 249866 0 0:00 <defunct>
> oracle 185724 249866 0 0:00 <defunct>
> oracle 190038 249866 0 0:00 <defunct>
> oracle 230222 249866 0 0:00 <defunct>
> oracle 231294 249866 0 0:00 <defunct>
> oracle 240232 249866 0 0:00 <defunct>
> oracle 240948 249866 0 0:00 <defunct>
> oracle 241580 249866 0 0:00 <defunct>
> oracle 242824 249866 0 0:00 <defunct>
> oracle 246250 249866 1 0:00 <defunct>
> oracle 249064 249866 0 0:00 <defunct>
> oracle 249866 1 71 Jul 24 - 1885:33 ora_snp0_OWPROD
> oracle 251258 249866 0 0:00 <defunct>
> oracle 256308 249866 0 0:00 <defunct>
> oracle 258390 249866 0 0:00 <defunct>
> oracle 264498 249866 0 0:00 <defunct>
> oracle 272988 152236 1 10:07:44 pts/4 0:00 grep -i 249866
> oracle 273948 249866 0 0:00 <defunct>
> oracle 278118 249866 0 0:00 <defunct>
> oracle 287898 249866 0 0:00 <defunct>
><JDEPROD> /home/oracle#
>
>
>thank's

snp<x> is in some versions of Oracle the process responsible for running jobs and replication tasks.
Replication tasks have been implemented using jobs.

querying dba_jobs_running will allow you to troubleshoot this further.

Please always include the exact version of Oracle and the exact platform and version of your OS.

-- 
Sybrand Bakker
Senior Oracle DBA