Access time of a table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Access time of a table

  1. #1
    Join Date
    Jun 2000
    Posts
    315
    Hi, everyone:

    Does Oracle database track the last time a table was accessed? And what dictionary table or view I can use to find this information?

    Thanks in advance!


  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    sys.aud$ but you have to set up auditing first.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Jun 2000
    Posts
    315
    Thanks, Julian!

Posting Permissions

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



Click Here to Expand Forum to Full Width