DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2000

    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.


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


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.