DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12
  1. #11
    Join Date
    Nov 2000
    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;

  2. #12
    Join Date
    Sep 2000
    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.

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

By using this site, you agree to the Privacy Policy