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).
