OraFAQ Forum: Server Administration » how can i find hanged session

Home » RDBMS Server » Server Administration » how can i find hanged session

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how can i find hanged session [message #61839]

Fri, 04 June 2004 04:46

ashokmote
Messages: 56
Registered: December 2003

Member

i have 10 sessions .how can now which one is hanged.

Report message to a moderator

Re: how can i find hanged session [message #61840 is a reply to message #61839]

Fri, 04 June 2004 07:40

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

if you doubt that a session hangs, start another sqlplus session and query v$session_wait. Check these things:
1 Is event changing for the hang session?
2 If event is not changing, is seq# changing for the hang session?
3 If both are not changing, what's the event name? the issue might be with that event..

depending on these...you get some idea.

and other method in unix ( may not be much effective for sqlplus sessions and internal database activities..but very useful in other scenarious ) is to use truss command.

Report message to a moderator

Re: how can i find hanged session [message #61845 is a reply to message #61839]

Sun, 06 June 2004 21:34

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

See oracle utility oradebug documentation. This utility starts:
SQL>oradebug
To see some description try
SQL>oradebug help

Report message to a moderator

Previous Topic:	about sequence
Next Topic:	Urgent please

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:33:10 CDT 2024