Site icon Database Tutorials

Who is Running the Queries in Your Database On Oracle

 

You can find the queries that are run in the database from v$sql, v$sql_text views, and who are running from sys.all_users.

You can create queries by associating v$sql, v$sql_text views and sys.all_users. The sample query is as follows.

Exit mobile version