question

BI DWH BALA avatar image
BI DWH BALA asked

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

Hi,

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

Thank you,

Regards

BI DWH BALA

sessions
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Andrew Mobbs avatar image
Andrew Mobbs answered
SELECT * from v$session
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Andrew, this are all sessions. I active sessions means "session doing something" then add **STATUS = 'ACTIVE' to your query.
1 Like 1 ·
Thank you Andrew!
0 Likes 0 ·
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 :-) )
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.