Home » Other » General » SYSAUX Tablespace (Oracle 10g, Win XP)
SYSAUX Tablespace [message #507080] Thu, 12 May 2011 07:19 Go to next message
gxeon
Messages: 53
Registered: January 2011
Location: Mumbai
Member
Hello

I am new to DBA...in my production database the free space of SYSAUX tablespace is very less now...how can i increase it? what will the impact on Database performance after increasing the size of SYSAUX Tablespace.


GG

[Updated on: Thu, 12 May 2011 07:21]

Report message to a moderator

Re: SYSAUX Tablespace [message #507084 is a reply to message #507080] Thu, 12 May 2011 07:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
how can i increase it?

Yes.

Quote:
what will the impact on Database performance after increasing the size of SYSAUX Tablespace.

Nothing.

Regards
Michel
Re: SYSAUX Tablespace [message #507087 is a reply to message #507080] Thu, 12 May 2011 07:34 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
ind> desc v$sysaux_occupants
 Name                                           
 --------------------------------------------
 OCCUPANT_NAME                                  
 OCCUPANT_DESC                                  
 SCHEMA_NAME                                    
 MOVE_PROCEDURE                                 
 MOVE_PROCEDURE_DESC                            
 SPACE_USAGE_KBYTES    


Check it.first

No issues.You can resize or add datafile.
Re: SYSAUX Tablespace [message #507205 is a reply to message #507087] Fri, 13 May 2011 02:38 Go to previous messageGo to next message
gxeon
Messages: 53
Registered: January 2011
Location: Mumbai
Member
Sir

one confusion..as you said i can increase the sysaux datafile size. No issues. but when i checked, my datafile is AUTOEXTENSIBLE...whether in this case also i need to manually resize the datafile. will it not be autoextend by default?

GG
Re: SYSAUX Tablespace [message #507212 is a reply to message #507205] Fri, 13 May 2011 03:20 Go to previous message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Depending on the other parameters (next, maxsize) it can or not autoextend.

Regards
Michel
Previous Topic: SQL Statement into Diagram
Next Topic: Error accessing package dbms_application_info
Goto Forum:
  


Current Time: Sat Nov 27 23:45:39 CST 2021