Hello guys,
I have 50% of tables in a database NOT SET UP in auditing, so I cannot get the information about if they are currently used by any app or if any of them are read by some SELECT statement.
Like with the All_Tab_Modifications table where I can get Inserts, deletes, and updates.....
my question is : Is there any way how can I get the tables no currently read in my database by a SELECT and when was the last time?
Thanks in advance for any suggestion
GonFer
I have 50% of tables in a database NOT SET UP in auditing, so I cannot get the information about if they are currently used by any app or if any of them are read by some SELECT statement.
Like with the All_Tab_Modifications table where I can get Inserts, deletes, and updates.....
my question is : Is there any way how can I get the tables no currently read in my database by a SELECT and when was the last time?
Thanks in advance for any suggestion
GonFer