Caculating table size growth and resizing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Caculating table size growth and resizing

  1. #1
    Join Date
    Oct 2000
    Posts
    90

    Red face

    Hello Guys,
    I am running 8i on UNIX platform. I have a table that I think has been growing.
    1.How do I monitor it to find out how much it grows and how do I forecast it's growth (say for ten months from now).
    2. what will be the best way to resize it in order to take care of the growth.

    thanks,
    dorothy

  2. #2
    Join Date
    Sep 2000
    Posts
    384
    Analyze the table with compute statistics .
    From dba_tables you can get the average row length.

    average row length *no of rows will be the segment size.


    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
  •  



Click Here to Expand Forum to Full Width