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

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

1 Answer

·
Andrew Mobbs avatar image
Andrew Mobbs answered
SELECT * from v$session
3 comments
10 |1200

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

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