Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    8

    Unanswered: how to log executed queries

    Hi,

    I need to log all the queries executed in a database. I know that oracle uses some views (v$sql, v$sqlarea...) to cache the latest queries executed.
    But is it any way of logging all the executed queries? Does oracle use a special table for that?

    Thanks in advance,

    browser

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Database auditing is all you need for that.

Posting Permissions

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