2 Replies Latest reply: Feb 7, 2013 11:43 PM by Nikolay Savvinov RSS

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

    989498
      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