How can we get list of all active sessions in oracle?

Question

Hi,

Is there any way, we can get list of all active sesions?

Thank you,

Regards

BI DWH BALA

Answer 1

0

SELECT * from v$session

answered Dec 03 '09 at 02:10 PM

Andrew Mobbs
1.5k ● 1 ● 3

Thank you Andrew!

Dec 03 '09 at 05:24 PM BI DWH BALA

Andrew, this are all sessions. I active sessions means "session doing something" then add **STATUS = 'ACTIVE' to your query.

Dec 04 '09 at 05:59 AM Christian13467

Ah, thanks, I read the question too quickly. (To be pedantic, my query does give all active sessions, it just gives the others as well :-) )

Dec 04 '09 at 12:46 PM Andrew Mobbs

(comments are locked)