Home » RDBMS Server » Server Administration » How to know the current sessions in Oracle..
How to know the current sessions in Oracle.. [message #179743] Wed, 28 June 2006 09:51 Go to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Hi all

How to know the current sessions in Oracle..

thanks
Re: How to know the current sessions in Oracle.. [message #179745 is a reply to message #179743] Wed, 28 June 2006 09:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
look into v$session?
Re: How to know the current sessions in Oracle.. [message #179816 is a reply to message #179743] Wed, 28 June 2006 22:11 Go to previous message
voca79
Messages: 4
Registered: June 2006
Location: VietNam
Junior Member
select name, status from v$session;
Previous Topic: question about /var/lock/subsys/dbora
Next Topic: Locally Manged Tablespaces
Goto Forum:
  


Current Time: Sat Jan 25 13:49:30 CST 2025