Re: process ora_snp0 using High CPU
Date: Mon, 8 Sep 2008 07:43:55 -0700 (PDT)
Message-ID: <f11ac603-5411-41b9-a541-6b1d27753410@k7g2000hsd.googlegroups.com>
On 8 sep, 16:26, sybra..._at_hccnet.nl wrote:
> On Mon, 8 Sep 2008 01:13:40 -0700 (PDT), eliot06 <p.hi..._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
oracle 8.1.7 onto AIX 4.3.3 Received on Mon Sep 08 2008 - 09:43:55 CDT