Re: ORA-1575 timeout waiting for space management resource and tempfiles

Sorry,

    Itīs a oracle 8.1.7.4 64 bits database on a hp 11.0 machine.     The queries are very similar to datawarehouse queries, the tables are accesed by parallel processes and sessions have a sort_area_size equal to 8M:

    Thanks

dias wrote:

> Hi,
>
> DB version, OS, ...o
> Do you perform a heavy operation when you get this error ?
>
> "Maria.Teresa Molina" <MariaTeresa.Molina_at_oracle.com> wrote in message news:<3E2DC6FC.79251880_at_oracle.com>...
> > Hi,
> >
> > We have a temporary tablespace with datafiles and we can habitually
> > observe this kind of errors:
> >
> > From smon trace --> ORA-1575 timeout waiting for space management
> > resource .
> >
> > I would like to know if temporary tablespaces witn tempfiles instead
> > of temporary tablespaces with datafiles can help to solve this type of
> > errors.
> >
> > Thankīs a lot
> >
> > --