How do I find active queries in my Oracle database?

Share

Tweet

Share

Share

Email

Comments

To find active queries in your Oracle database, you can use the following command:

SELECT SID, Serial#, UserName, Status, SchemaName, Logon_Time
FROM V$Session
WHERE
Status=‘ACTIVE’ AND
UserName IS NOT NULL;