Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYSAUX tablespace
Ravi via DBMonster.com wrote:
> Hi,
>
> The sysaux tablespace is growing pretty faster than other tables in my DB.
> I'm using 10g RAC.
> Obviously all db related and grid agents details get stored there. Is this is
> the usual character of this tablespace.
>
> Already this tablespace has allocated with 9 datafiles still its 91% occupied.
> By increasing the space with adding datafiles also increasing the maintenace
> part.
>
> Is there any recommendations to handle this.
>
> Thank You.
>
Have a look at the V$SYSAUX_OCCUPANTS view. It will show you who is using what kind of space. Querying this view over time will give you an idea of where your space is growing. You can also query DBA_SEGMENTS too.
You may or may not need this much space. It depends on who is hogging this space and how much space that really is.
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown -- Posted via a free Usenet account from http://www.teranews.comReceived on Thu Sep 20 2007 - 08:51:32 CDT