DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14
  1. #11
    Join Date
    Sep 2002
    well they only change if you analyze them, and that value could change even if you dont use it

  2. #12
    Join Date
    Jan 2001
    also what if you just update the table records..the number doesn't grow..but the table is still used.
    There is always a better way to do the things.

  3. #13
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    The whole thing seems rather silly to me. Before we discuss it any further, I think the original poster should first prowide a very concise definition of what "tables that are not used" actualy means.

    For me, a table on which an application merely performs SELECTs is no less used as the table in which application performs INSERTS/UPDATES/DELETES. And as allready said, if SELECTS on a table count as "table is used", then forget about triggers. In fact, forget about anything, except auditing. Audit trail is the only way to get that information from.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #14
    Join Date
    Jul 2002
    Lake Worth, FL


    You can also collect and manage user-defined statistics for tables and domain indexes using thie DBMS_STATS package.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.