Re: Oracle hangs while shutdown immediate

From: aspeda.com <support_at_aspeda.com>
Date: 4 Jun 2003 10:58:04 -0700
Message-ID: <32263608.0306040958.2c9c8b9b@posting.google.com>

Anton Dischner <nospam_at_nospam.org> wrote in message news:<040620031030490269%nospam_at_nospam.org>...
> Hi,
> Vitaly:
>
> How do you do the 'dump state of all sessions' ?
>

I have few sql scripts that I call from a shell script. Here's partial shell script that calls them:

---------------- start -----------------------

HOSTNAME=`hostname`
DATE=`date +%m%d%y`
FILE="$ORACLE_BASE/admin/scripts/log/"`basename $0`".${HOSTNAME}.${ORACLE_SID}.${DATE}.log"

sqlplus /nolog <<EOF
connect / as sysdba
set lines 3000
set trims on
spool $FILE
select * from v\$instance;
select * from v\$process;

@$ORACLE_BASE/admin/scripts/sql/s_db_sorts.sql
@$ORACLE_BASE/admin/scripts/sql/s_rbs.sql
@$ORACLE_BASE/admin/scripts/sql/c_user_rbs.sql
@$ORACLE_BASE/admin/scripts/sql/s_user_ses_cnt.sql
@$ORACLE_BASE/admin/scripts/sql/c_user_ses_2.sql

spool off
exit
EOF

---------------- end ----------------------

Make sure ORACLE_SID, ORACLE_BASE, ORACLE_HOME are set.

I uploaded scripts to my site:

http://www.dbatoolz.com/SCRIPT_17.HTM (s_db_sorts.sql)
http://www.dbatoolz.com/SCRIPT_11.HTM (s_rbs.sql, c_user_rbs.sql)
http://www.dbatoolz.com/SCRIPT_16.HTM (s_user_ses_cnt.sql,

c_user_ses_2.sql)

Regards,
Vitaliy
DBAToolZ.com (free sql scripts + SQLDIR parser) Aspeda.com (free Oracle monitoring tool) Received on Wed Jun 04 2003 - 12:58:04 CDT