cancel
Showing results for 
Search instead for 
Did you mean: 

auto extend off of system table space

Former Member
0 Kudos

Hi experts,

System tablespace have 2 datafiles which has autoexted on.can i autoexted off??

and why in system's tablespace datafile ONLINE_STATUS shows "system" in dba_data_files.

and rest of files staus "online".

oracle 10g

ECC 6.0

Regards,

Edited by: vivek pokhariyal on Jan 28, 2012 10:14 AM

Accepted Solutions (1)

Accepted Solutions (1)

former_member199632
Participant
0 Kudos

Hello vivek,

No need to turn off auto-extend option.

It hardly not filling with data.All sap data and indexes resides in SAPSR3 & SAPSR3700

You can turned off autoextend on all data files for more control of space.

But make sure to keep eye on the growth.

The SYSTEM Tablespace datafile will always have the status 'SYSTEM' in the V$DATAFILE view or in dba_data_files.

This is the case with all your databases -- including the Primary for this Standby.

The reason why SYSTEM is status 'SYSTEM' while others can be 'ONLINE' or 'OFFLINE' is that the SYSTEM tablespace can never be 'OFFLINE'. It cannot be manually taken Offline or brought Online.

hope this helps

regards,

zerandib

Answers (3)

Answers (3)

Former Member
0 Kudos

done

former_member213250
Active Participant
0 Kudos

Hello Vivek

Inorder to avoid tablespace overflows and manual extensions of datafiles, you need to consider activating AUTOEXTEND ON, so that Oracle automatically extends an existing data file if necessary (provided there is sufficient space in the file system):

Hope it helps

BR

Venkat

nicholas_chang
Active Contributor
0 Kudos

Hi vivek,

It highly depends on you either you turn auto extend on or off, it doesnt really matter.

Since system tablespace is more stagnant, you cant turn auto-extend off by allocate sufficient space for it to growth at least 2 months.

Cheers,

Nicholas Chang