OraFAQ Forum: Server Administration » System tablespace resize

Home » RDBMS Server » Server Administration » System tablespace resize (Oracle 11.2.0.3.0, Red hat linux 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

System tablespace resize [message #573192]

Sun, 23 December 2012 23:51

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

My system tablespace size is 800mb and it sends an alert saying that it has exceeded 80% of its usage.
However its total max size is 30gb.

FYI
Its autoextensible is set to 'YES'.
2 Node RAC database.
File system is ASM

My question here is... is it advicable to resize a system tablespace to some size when autoextensible is set to 'YES'
or genrally can we resize a system tablespace when autoextensible is set to 'No' ?

SQL> col FILE_NAME format a40
SQL> /

FILE_NAME                                BYTES/1024/1024 AUT MAXBYTES/1024/1024
---------------------------------------- --------------- --- ------------------
+DATA/ge01114/datafile/system.556.2254454     800        YES  30000.9844

Regards,
jack

[Updated on: Sun, 23 December 2012 23:53]

Report message to a moderator

Re: System tablespace resize [message #573203 is a reply to message #573192]

Mon, 24 December 2012 02:28

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I think "it" (who is "it"?) means that 80% of you current 800M are used by objects.
You have to read the documentation of the tool you use, ALWAYS.

Regards
Michel

Report message to a moderator

Re: System tablespace resize [message #574913 is a reply to message #573203]

Wed, 16 January 2013 13:45

alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California

Senior Member

You can resize an ASM system datafile with

ENDOCS1S > alter database datafile '+NDOC_DATA_01/ndocs/datafile/system.256.782407183' resize 1000m;

Database altered.

Report message to a moderator

Re: System tablespace resize [message #574918 is a reply to message #574913]

Wed, 16 January 2013 13:54

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Like non-ASM datafile?

Regards
Michel

Report message to a moderator

Re: System tablespace resize [message #574925 is a reply to message #574918]

Wed, 16 January 2013 14:10

alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California

Senior Member

Yes ASM and non ASM datafiles can be resized with the exact same command.

Report message to a moderator

Previous Topic:	Find current shared pool usage of my program
Next Topic:	ORA-00054: drop MATERIALIZED view log

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 06:11:18 CST 2025