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

    Cleanup Prod Schema dilemma

      Hi All,



      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,


        1 2 3 Previous Next