Auto extend is not working

[Former Member]

Dear All ,

PSAPSR3 is auto extended as well as we have more space in file system level,even though PSAPSR3 is not autoextended.

let me know how can i resolve my problem.

PSAPSR3 249,520.00 10,190.38 96 YES 250,000.00 10,670.38 96 25 157,305 229,300 ONLINE PERMANENT

used % 96 and total used also 96%

Kindly suggets.

Edited by: satheesh0812 on Jan 7, 2011 5:04 PM

Edited by: satheesh0812 on Jan 7, 2011 5:05 PM

[volker_borowski2]

Hi,

a datafile can do a maximum autoextend up to 32 G.

The standard installation sets the upper limit to 10000M.

Obviously you have 25 datafiles that can grow up to 10000M and the actual size is already 249520M.

So no real potential to grow any more (just 480M left).

So either

a) add three new datafiles of size 2000M that can also grow up to 10000M

or

b) set your existing datafiles to an upper limit of i.e. 12000M (with brtools -> turn on and maintain autoextend for each datafile).

Now lets check the maths

a) would set the total size to 249520M + 6000M and the total autoextensible size to 250000+30000M

and that would mean 93,5% real and ~85,5% autoextend utilization.

Doing this would require potentially 30G freespace in your filesystem

b) Would leave the total size untouched for now and set the autoextensible size to 25*12000M

bumping down the autoextend utilisation to 75%. This would require potentially 50G freespace in your filesystem.

Best regards

Volker

[Former Member]

For temp , i will close my thread..

[Former Member]

What do you mean by auto extend on?

Just compare the total size of tablespace/datafile with old/new output, It can tell you how auto extend on is working.

It cannot show you the way in a graphical picture, how it works.

Regards,

Nick Loy

[Former Member]

Hi Sateesh,

Autoextend seems enable for datafiles of tablespace.(the data files are autoextendable. Tablespaces are logical entity)

However, extend is added automatically only when tablesapce needs space to grow. For eg, when it is 99 % full.

Currently, it is 96% full. Hence, you can not see autoextend feature.

Hope this is helpful.

Regards,

Nirav Shah.

[Former Member]

First of all, you have to find why is not extended automatically although the settings are enabled.

Possible reason are, you have a space in file system, but the ora user do not have a permission to create one more data file or extend the size of data file.

Try manually.