Home » RDBMS Server » Server Administration » System tablespace resize (Oracle 11.2.0.3.0, Red hat linux 4)
System tablespace resize [message #573192] Sun, 23 December 2012 23:51 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: System tablespace resize [message #574913 is a reply to message #573203] Wed, 16 January 2013 13:45 Go to previous messageGo to next message
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.
Re: System tablespace resize [message #574918 is a reply to message #574913] Wed, 16 January 2013 13:54 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Like non-ASM datafile?

Regards
Michel
Re: System tablespace resize [message #574925 is a reply to message #574918] Wed, 16 January 2013 14:10 Go to previous message
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.
Previous Topic: Find current shared pool usage of my program
Next Topic: ORA-00054: drop MATERIALIZED view log
Goto Forum:
  


Current Time: Mon Sep 01 15:04:24 CDT 2014

Total time taken to generate the page: 0.10162 seconds