Re: Resize SYSAUX datafile

  • From: Dennis Williams <oracledba.williams@xxxxxxxxx>
  • To: grzegorzof@xxxxxxxxxx
  • Date: Wed, 6 Apr 2011 13:40:21 -0500

Richard,

Do you want to increase the size of the SYSAUX datafile or reduce it?

Dennis Williams

On Wed, Apr 6, 2011 at 12:49 PM, Grzegorz Goryszewski <grzegorzof@xxxxxxxxxx
> wrote:

>  On 2011-04-06 19:25, Ricard Martínez wrote:
> > Hi
> > Im trying to do a resize of SYSAUX datafile, but all the info and
> metalink
> > notes im reading, make me think it is impossible for the moment. That the
> > only real options is
> > to clean space and put tablespace in autoextend off.
> > Anyone have been able to do it? Or really isnt allowed atm?
> > Thanks
> >
> Hi,
>  that's strange . There is nothing special about SYSAUX , You can check
> what  made it big via
> |select * from V$SYSAUX_OCCUPANTS and do some cleanups.
> Can u share ORA- You are hitting ?
> Regards.
> GregG
>
>  |
>
> ----------------------------------------------------------------
> Najwiekszy wybor samochodow nowych i uzywanych!
> Sprawdz >> http://linkint.pl/f2970
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: