cancel
Showing results for 
Search instead for 
Did you mean: 

Tablespace Autoextend and Data file Autoextensible

former_member199632
Participant
0 Kudos

Hello,

When i checked using DBA cockpit , it shows

PSAPSR3700 Auto Extended = NO

but, for the data files of PSAPSR3700 tablespace it shows AutoExtensible = YES

So here, when it finishes the allocated amount , will that automatically grows the datafile to its MAXSIZE.

(Here Max Size is specified as 10000 MB)

why the tablespace PSAPSR3700 marked as auto-extend NO !!!

im confusing this.

Pl, help me to resolve this

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

PSAPSR3700 Auto Extended = NO

but, for the data files of PSAPSR3700 tablespace it shows AutoExtensible = YES

So here, when it finishes the allocated amount , will that automatically grows the datafile to its MAXSIZE.

(Here Max Size is specified as 10000 MB)

This could be because all the datafiles might have reached the maxsize. Check the size of all the datafiles, if the sizes are same as that of the maxsize then ur tablespace will show "No" to autoextend.

You can test this by adding a new datafile of size smaller than maxsize with Autoextend "ON" to the tablespace and then refresh the DB02 display. After doing the above procedure, u can see the tablespace changed to Autoextendible "YES".

Hope this clarifies.

Regards,

Varadharajan M

former_member199632
Participant
0 Kudos

Hi,

This could be because all the datafiles might have reached the maxsize.

Yes , I have check the SIZE and MAXSIZE of the datafiles.

It is SAME - Sizes are same as that of the maxsize. Okay now i got the point .... indicate as AUTOEXTEND = NO

But having little bit of more confusion!

In the same Tablespace (PSAPSR3700) , it show

PSAPSR3700

Size: 86,864 MB

Free: 11,092 MB

Used: 87%

AutoExtend: NO

Total Size: 86,864 MB

Total Used: 87

Here, since SIZE and TOTAL SIZE are same,

and

in all datafiles of this Tablespace SIZE reached to MAXSIZE limit,

How it shows the FREE amount as 11092 MB

Regards,

Zerandib

Former Member
0 Kudos

Hi,

The total size is the sum of the size occupied by data in the datafile + free space in eache datafile. Eventhough the size and total size there will be some free space and in ur case the available freespace in the datafiles in 11092 MB.

Regards,

Varadharajan M

former_member204746
Active Contributor
0 Kudos

Hi, datafile is occupying all the space on disk, but there is free space inside that datafile.

a datafile is a container that is not filled, but this container still use space on the bigger container: the disk

former_member199632
Participant
0 Kudos

If ,

Size of the new file == Maximum file size

then it occupies the Full space.

ex: Size of the new file (10 GB) == Maximum file size (10 GB)

then this file gets 10 GB space. But within the file .... free space is there... Oracle will manage this space efficiently.

If ;

Size of the new file (2 GB) == Maximum file size (10 GB) ..... where auto extended is ON on datafile,

then it obtain only 2 GB space.... (in DB02 statistics). Afterward , when ever necessary it will increase the file using auto-extend.

Since all datafiles created according to Size of the new file == Maximum file size, then it shows as,

size == total size.

nevertheless , It correctly shows the free space also.

regards,

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

Hi,

the following link explains why: