OraFAQ Forum: General » SYSAUX Tablespace

Home » Other » General » SYSAUX Tablespace (Oracle 10g, Win XP)

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

SYSAUX Tablespace [message #507080]

Thu, 12 May 2011 07:19

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

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

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

Report message to a moderator

Re: SYSAUX Tablespace [message #507087 is a reply to message #507080]

Thu, 12 May 2011 07:34

ramoradba
Messages: 2457
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.

Report message to a moderator

Re: SYSAUX Tablespace [message #507205 is a reply to message #507087]

Fri, 13 May 2011 02:38

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

Report message to a moderator

Re: SYSAUX Tablespace [message #507212 is a reply to message #507205]

Fri, 13 May 2011 03:20

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

Senior Member
Account Moderator

Depending on the other parameters (next, maxsize) it can or not autoextend.

Regards
Michel

Report message to a moderator

Previous Topic:	SQL Statement into Diagram
Next Topic:	Error accessing package dbms_application_info

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 16:13:21 CST 2024