Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Calling in the Cavalry - Hanging 8i database
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
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