Skip to Content
avatar image
Former Member

Tablespace autoextend Total Size

Hello people,

I´ve oracle 10g with the autoextend mode On in the tablespace. My doubt is about the options that I can to choose for resizing the tablespace size.

The TOTAL SIZE is 200GB and there are 15GB Free, the growing medium is over 20GB per month. Which is the correct procedure?

Add more datafiles or resizing the tablespace?

More thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 09, 2012 at 03:02 PM

    Hi Sergio,

    There is no an exact procedure about the case. But, I recommend you create 1 Gb datafiles and set the max file size to 16 Gb for each datafile. Please note that try to keep datafile size, homogeneous, for each datafile.

    Best regards,

    Orkun Gedik

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 10, 2012 at 06:08 AM

    I agree with Orkun. Try to keep your datafile size settings equal for each datafile

    Regards

    Roman

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You can also change datafile parameters to change maxsize allowed. Then you don't need to create additional datafiles.

      Regards

      Roman