1 2 3 Previous Next 33 Replies Latest reply: Mar 24, 2014 9:21 AM by BluShadow RSS

    Cleanup Prod Schema dilemma

      Hi All,

       

      11.2.0.1

       

      This is still my long pending dilemma How do I know if a certain table is being accessed or not witihn 24 hours,without using auditing?

      I am cleaning up unused tables in our PROD schema. There are hundreds of tables which where used and where not cleaned-up.

      I am thinking if I  can used data-mining to check which  tables are being accessed in the past 24 hrs?

      Or can I extract all SQLTEXT in SQLAREA every hour to check which tables are being accessed within 24 hour period?

       

      Your comments are highly appreciated.

       

      Thanks all,

      pK

        1 2 3 Previous Next