process ora_snp0 using High CPU

From: eliot06 <p.hirth_at_gmail.com>
Date: Mon, 8 Sep 2008 01:13:40 -0700 (PDT)
Message-ID: <071dda74-6e06-43cf-84dd-9688f8507d14@w7g2000hsa.googlegroups.com>

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 Received on Mon Sep 08 2008 - 03:13:40 CDT

This message: [ Message body ]
Next message: Mladen Gogala: "Tora compilation problem"
Previous message: Michael Austin: "Re: How a row is physical stored in Oracle"
Next in thread: sybrandb_at_hccnet.nl: "Re: process ora_snp0 using High CPU"
Reply: sybrandb_at_hccnet.nl: "Re: process ora_snp0 using High CPU"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message