RE: Oracle process causes High CPU

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Tue, 29 Jan 2002 10:42:14 -0800
Message-ID: <F001.003FF1A5.20020129095028@fatcity.com>

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: david.m.nguyen_at_xo.com

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: ListGuru_at_fatcity.com (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: MohanR_at_STARS-SMI.com

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