Some default options for Oracle tablespace data file self-growth

Source: Internet
Author: User

Yesterday, a colleague asked some questions about Oracle Tablespace data file Self-growth, in the process of the way to organize, and other colleagues have the same questions can be directly consulted.

Experimental content:

    1. Creates a mytest table space that does not turn on self-growth by default.
    2. Add a data file to the MyTest table space, open self-growth, but do not set the size to grow from.
    3. Add a data file to the MyTest table space, turn on self-growth, and specify the size from which to grow.

The procedure is logged as follows: (the excess results have been filtered)

[Email protected]>CREATE tablespace MYTEST datafile '/ocp_data02/datafiles/mytest01. DBF ' SIZE 10M autoextend OFF;

Tablespace created.

[Email protected]>Select file_name,tablespace_name,bytes,autoextensible,increment_by from Dba_data_files;

file_name tablespace_name BYTES AUT increment_by

--------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------- ----------------------------------

/ocp_data02/datafiles/mytest01. DBF MYTEST 10485760 NO 0

[Email protected]>ALTER tablespace MYTEST ADD datafile '/ocp_data02/datafiles/mytest02. DBF ' SIZE 10M autoextend on;

Tablespace altered.

[Email protected]>ALTER tablespace MYTEST ADD datafile '/ocp_data02/datafiles/mytest03. DBF ' SIZE 10M autoextend on NEXT 10M;

Tablespace altered.

[Email protected]>Select file_name,tablespace_name,bytes,autoextensible,increment_by from Dba_data_files;

file_name tablespace_name BYTES AUT increment_by

--------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------- -----------------------------------

/ocp_data02/datafiles/mytest01. DBF MYTEST 10485760 NO 0

/ocp_data02/datafiles/mytest02. DBF MYTEST 10485760 YES 1

/ocp_data02/datafiles/mytest03. DBF MYTEST 10485760 YES 1280

?

Conclusion:

    1. The increment_by is 0 when it does not turn on self-growth.
    2. Turn on self-growth, do not set the growth size of the case, the increment_by system default to 1 block size, that is: 8k*1block=8k
    3. Turn on self-growth, set the growth SIZE of the case, Increment_by is size/block_size, that is: 1024k*10m/8k=1280.

Some default options for Oracle tablespace data file self-growth

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.