Oracle-L: RE: DB freezes ... no indications of any kind

From: Arun Chakrapani <ArunC_at_1800FLOWERS.com>
Date: Mon, 11 Mar 2002 15:14:17 -0800
Message-ID: <F001.00425125.20020311151417@fatcity.com>

like put a cron job which keeps connecting to the database if there a probs by any chance a freeze see to that in the script it runs ORADEBUG COMMAND WHICH WILL TAKE A DATABASE SYSTEM DUMP
I have a feeling u know the command for ora debug If not please use the following script
I use the below said script to monitor whenever the database freezes it takes snapshot of the database using system state dump. There are other commands also but i am not able to remember them I will post u once i get those scripts

#!/bin/ksh
get_pmon=`ps -ef |grep pmon_800P|grep -v grep`

. /opt/app/oracle/oracle_env
svrmgrl <<EOF
connect internal
oradebug setospid $get_pmon
oradebug unlimit
oradebug dump systemstate 10
exit
EOF -----Original Message-----
Sent: Monday, March 11, 2002 5:34 PM
To: Multiple recipients of list ORACLE-L

Can you please elaborate on that?

Raj

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Monday, March 11, 2002 5:13 PM
To: Multiple recipients of list ORACLE-L

Why dont you sent an event which monitors the database and takes a system state dump during the freeze thro ORADEBUG
>From that I hope u can find out where it is bombing

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arun Chakrapani
  INET: ArunC_at_1800FLOWERS.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).

Received on Mon Mar 11 2002 - 17:14:17 CST