x

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

more ▼

asked Dec 03 '09 at 01:30 PM in Default

BI DWH BALA gravatar image

BI DWH BALA
606 40 56 62

(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest
SELECT * from v$session 
more ▼

answered Dec 03 '09 at 02:10 PM

Andrew Mobbs gravatar image

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)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x4

asked: Dec 03 '09 at 01:30 PM

Seen: 605 times

Last Updated: Dec 03 '09 at 01:30 PM