database

How do I find active queries in my Oracle database?

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;

Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

To Top