Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary Tablespaces
krishnanand_at_hotmail.com wrote:
>
> Hi,
>
> A few questions on TEMP tablespaces: ( Oracle 7.3.2.1 )
>
(snip)
>
> (2) In the ALERT_SID.LOG , I keep seeing the message
>
> " ORA-01575: timeout waiting for space management resource "
>
> What should I do ?
>
(snip)
>
> Thanx.
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
This informative error is usually (but not always) associated with a
high volume of disk sorts. If possible, try adjusting the init.ora
sort_area_size so that more sorts are performed in memory.
-- Kelly Young Database Administrator Maricopa Community Colleges young_at_maricopa.eduReceived on Wed Nov 26 1997 - 00:00:00 CST