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.

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

One comment

Leave a Reply

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