identify tables using V$SQLAREA
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: identify tables using V$SQLAREA

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    identify tables using V$SQLAREA

    Hi Friends,

    It is possible to list all the tables being accessed in the last 24hrs where the owner of the table is "PROD" using the data dict V$SQLAREA or others.

    Thanks a lot
    Behind The Success And Failure Of A Man Is A Woman

  2. #2
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    You can find the table names from v$sqlarea/v$sql , but being accessed within last 24 hours. I do not think that condition will be fulfilled by any of these views.
    http://www.perf-engg.com
    A performance engineering forum

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you have to set up auditing to do 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
  •  



Click Here to Expand Forum to Full Width