Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Question Unanswered: How can we get informations about executions SQL queries

    Hi everybody !!!

    I just wanted to know how we can get informations from V$xx views in Oracle Databases like in accounting in DB2 Databases !!

    I want to know the CPU , the Elasped times used by user ,the number of inserts , updates, deletes, selects by user a day !!!!

    Thanks for your reply.

  2. #2
    Join Date
    Feb 2004
    Dublin, Ireland
    I don't think there's something like users activity history stored in system tables. You'll probably need some tool like this:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts