Skip to Content
avatar image
Former Member

Table name or groth

Dear All,

My System Ecc6.0,with Oracle10g,I requard Table Information all tables name , data size groth and most use table nname pls help...

Regard's

vinod

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 30, 2009 at 09:20 AM

    Vinod,

    You can check the table size by using tcode DB02OLD in 10g. DB02OLD >Detail analysis >Object name=-->Tablespace= >Object Type >table*

    This wil show all the table. You can sort it to check all table which are large in size. Similary you can find Indexes as well & if you find Index size larger than table size you can rebuild those indexes to make some free space.

    Also check below link.It may help you

    is-it-possible-to-see-decrease-of-table-size-size

    Thanks

    Sushil

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 30, 2009 at 08:02 AM

    Hi Vinod

    Check transaction ST10 and explore lots of information available there.

    To see the table growth for a particular table go to tcode db02 or db02old and in the click on "detailed analysis" enter the table name in the Object field ( 'table_name") . You can see table and index stats for that table, Click on table name and then on history tab.

    Thanks and Regards

    Anindya

    Edited by: Anindya Bose on Jun 30, 2009 1:35 PM

    Add comment
    10|10000 characters needed characters exceeded