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

Hi, Maria,

What's pctincrease of your temp tablespace? Set it to 0 if not so. What's large_pool_size and what's large pool free memory in v$sgastat? Parallel executions need it. Also, you may want to consider matching extent size with sort_area_size possibly by creating another temp tablespace and assign this user to it. But your temp space usage is due to parallel execution, not sorting.

Tempfile-based temp tablespace is better than datafile-based. Why not use it?

Yong Huang

"Maria.Teresa Molina" <MariaTeresa.Molina_at_oracle.com> wrote in message news:<3E2F0409.A7530D6C_at_oracle.com>...
> 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.
Received on Thu Jan 23 2003 - 14:03:48 CST