cancel
Showing results for 
Search instead for 
Did you mean: 

SYSAUX tablespace

Former Member
0 Kudos

Hi,

I have a doubt.

Is it mandatory to have SYSAUX tablespace in autoextend mode?

The autoextend size is 33GB.

This is the only tablespace in autoextend mode.

If i need to change the mode, what should i do and what is the command to change it.

Regards,

Siddhartha

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

First read following SAP Note

Note 872851 - Oracle Database 10g: SYSAUX Tablespace

Note 969674 - Oracle Database 10g: Default Permanent Tablespace PSAPSAUX

regards,

kaushal

Former Member
0 Kudos

Hi Kaushal,

Thanks for the reply.

Referring the note 872851

I understand that the property of the SYSAUX tablespace is "Segment Space Management Auto".

I need to change the AutoExt (kb).

Currently it displays 33gb.

Regards,

Siddhartha.

Former Member
0 Kudos

Hi,

use ALTER TABLESPACE <tablespace> SET AUTOEXTEND OFF

regards,

kaushal

Former Member
0 Kudos

Can this tablespace be turned off?

because the note says that we should not change the propertied of this tablespace.

Regards,

siddhartha.

Former Member
0 Kudos

Hi,

It does not make tablespace turned off.

you can only change the properties for Path, SIZE and AUTOEXTEND for the datafile for tablespace SYSAUX

regards,

kaushal

Former Member
0 Kudos

Hi Kaushal,

sorry. i meant if the AUTOEXTEND can be turned off?

Regards

siddhartha

former_member204746
Active Contributor
0 Kudos

yes, turn if off... or use a smaller maximum value. 33GB is probably too much. mine is set as a max of 4GB.

Former Member
0 Kudos

Hi Eric,

Thanks for the reply.

I tried doin it to the tablespace and it was not possible.

i Got ora - 32773 error.

Now i should try to switch the autoextend off to the datafile.

Please tell me the way how to reduce it to 4GB or so.

Thanks.

Siddhartha,

former_member204746
Active Contributor
0 Kudos

read http://oraclequirks.blogspot.com/2007/06/ora-32773-and-autoextend-onoff.html

or, just leave autoextend on but change maximum size to a smaller value:

brspace -c -u / -f dfalter

option 3

Former Member
0 Kudos

Hi Siddartha,

Changing tablespace datafile autoextend value can be done using brtools where you can set max file size value to 4GB.

Brtools -> Space management -> Alter datafile

Specify datafilename ->

Alter datafile action - Autoext

In further screen

specify maximum filesize value and continue..........

SAP recommends to use brtools for SAP database operation.

Regards,

Ganesh