question

Cee avatar image
Cee asked

How do you determine what sessions are connected and what resources they are using

How do you determine what sessions are connected and what resources they are using?

sessionsresources
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

·
Tariq Rahiman avatar image
Tariq Rahiman answered

SELECT USER#, CASE WHEN USERNAME IS NULL THEN 'BACKGROUND' ELSE USERNAME END AS USERNAME, STATUS,TYPE, PROGRAM,MACHINE,OSUSER,SERVER,SID FROM V$SESSION ORDER BY USERNAME

1 comment
10 |1200

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

HillbillyToad avatar image HillbillyToad commented ·
Tons of tools out there that do this, including OEM Grid. V$SESSION is a good place to start.
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.