-
How about putting a trigger on the table? I know there is no trigger for SELECT, but then what are the odds that the app does a SELECT but never an insert, update or delete?
make your trigger do this
if :new.column_of_interest <> :old.column_of_interest then
insert a row into some table for monitoring;
end if;
-
If you are going for the all the user tables in the database then you are in for Trouble.
But for a specfic table means you can try by
1.sql_trace on
2.sql_text ananlysis
3.Try using the New Monitoring option for tables.
Identify the columns that you want to eleiminate.create a view on all the columns that you need .Test your application .
Then drop all the columns .This is going to be a pain.
Radhakrishnan.M
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|