RE: Oracle process causes High CPU

2002-01-29 Thread Mohan, Ross

What job(s) are you running?

and if you strings core | head -40, what do you get?


Inquiring Minds want to know, 

etc. 

-Original Message-
Sent: Tuesday, January 29, 2002 12:06 PM
To: Multiple recipients of list ORACLE-L


We have problem with oracle process "ora_snp0" that causes high CPU and core
files on our system.  Does someone have idea how to fix it?  Please help.

Below is information captured from a trace file:

Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_snp0_16657.trc
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production
ORACLE_HOME = /export/home/oracle/product/8.0.5
System name:SunOS
Node name:  pbna1
Release:5.6
Version:Generic_105181-26
Machine:sun4u
Instance name: SSDB
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 16657, image: ora_snp0_SSDB

*** 2002.01.29.03.13.33.000
*** SESSION ID:(7.11) 2002.01.29.03.13.32.000
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x
5f4c6000
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x
7f6c7d78
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x
7f6c7d78Background_Core_Dump = FULL


Thanks,
David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, David M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Oracle process causes High CPU

2002-01-29 Thread Nguyen, David M

We have problem with oracle process "ora_snp0" that causes high CPU and core
files on our system.  Does someone have idea how to fix it?  Please help.

Below is information captured from a trace file:

Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_snp0_16657.trc
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production
ORACLE_HOME = /export/home/oracle/product/8.0.5
System name:SunOS
Node name:  pbna1
Release:5.6
Version:Generic_105181-26
Machine:sun4u
Instance name: SSDB
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 16657, image: ora_snp0_SSDB

*** 2002.01.29.03.13.33.000
*** SESSION ID:(7.11) 2002.01.29.03.13.32.000
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x
5f4c6000
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x
7f6c7d78
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x
7f6c7d78Background_Core_Dump = FULL


Thanks,
David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, David M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).