This discussion is archived
2 Replies Latest reply: Feb 7, 2013 9:43 PM by Nikolay Savvinov RSS

Oracle dictionary view 2 find the queries run and it's execution time

989498 Newbie
Currently Being Moderated
Hi All,
I s there any oracle dictionary view which captures the queries being run by users on the database and time taken to execute those queries?
We need to find out the OS user not the database user since we have to identify the users who are executing long running queries.
We require this basically to monitor the long running queries on the database.

Thanks in Advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points