Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Calling in the Cavalry - Hanging 8i database

Re: Calling in the Cavalry - Hanging 8i database

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Mon, 16 May 2005 15:04:55 GMT
Message-ID: <4288b539.258220968@localhost>


Try the following

at the time of the hang, check what oracle is doing, e.g. check active sessions:

set linesize 120
column sidc format a10
column event format a36 truncate
column username format a30 truncate
column secs format 999
select s.sid||','||serial#
sidc,username||'@'||machine||'('||osuser||'|'||program||')' username, event||' '||p1||','||p2||','||p3 event, seconds_in_wait secs, sql_hash_value sqlhashval /*row_wait_obj#*/ from v$session s, v$session_wait sw
where

        status='ACTIVE'
        and s.sid=sw.sid
        and username is not null

order by sqlhashval;

If you're running MTS (Shared Server), and it seems like you're, you simply might have all servers busy, which would explain 'hanging', e.g. no new connections could be made, and even some old ones can't issue SQL statements:
select name "NAME", paddr,requests,
 (busy/(busy + idle)) * 100 "%TIME BUSY",status from v$shared_server;

this could be verified from OS:
ps -ef|grep ora_s0
if more than 3 processes show up (you have 3 i think as default # of servers)

If above doesn't help..

Verify what part of the listener is really hung. a) can you tnsping?
b) can you telnet to the listener port from local machine?

-A

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Mon May 16 2005 - 10:04:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US