Skip to Content
author's profile photo Former Member
Former Member

datafile autoextent

Hi,

How can I check if the autoextend feature of the datafile is working.Is there any SQL command we can use to compare the actual datafile size and the incremented datafile size.

We have 6 datafile each of 2 GB in PSAPDAT tablespace with utoextend on next 20M maxsize 10G.

Does it mean that that tablespace can grow upto 60G. How can I check this. The issue is that I see the datafile in dba_data_files of the same size (i.e 2G).

Regards

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 05, 2008 at 08:06 AM

    Hello Mohammed,

    at first just a suggestion:

    > We have 6 datafile each of 2 GB in PSAPDAT tablespace with utoextend on next 20M maxsize 10G.

    Please increase the AUTOEXTEND size up to 1 or 2 GB. Your actual autoextend size is too small to handle a "big" database object extent in a LMT tablespace with one extent. In a DMT tablespace it can be much more worse.

    > Does it mean that that tablespace can grow upto 60G

    Yes, your tablespace can grow to 6 * 10 GB = 60 GB

    > Is there any SQL command we can use to compare the actual datafile size and the incremented datafile size.

    You can query DBA_DATA_FILES to get these actual size and the max size, but you can not "check" the AUTOEXTEND feature - the datafiles are extended if needed.

    >SQL> SELECT FILE_NAME, BYTES, MAXBYTES FROM DBA_DATA_FILES;

    But you can check the initial datafile size after the creation and the actual size:

    > SQL> SELECT NAME, BYTES, CREATE_BYTES FROM V$DATAFILE;

    Regards

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.