DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: how to find unused tables...

  1. #11
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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
    Posts
    642
    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
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool


    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