Re: ORA-01575: timeout waiting for space management resource

Ok,

The most common reason for this is too many sorts. What you do is the following: 1) pctincrease = 0 for the tablespace that you use for sorting 2) initial and next extent should be the same size (and make it a decent size, not 10-100K, but larger).
3) You could try to increase the sort_area_size 4) increase sort_read_fac to the same value as db_file_multiblock_read_count (32 or 16
depending on your db_block_size)

These suggestions will improve overall performance on your system quite a bit and the 1575 should dissapear may be alltogether.

Anjo Kolk

Catcox wrote:

> For some periods during the day I get a lot of the following message.
>
> ORA-01575: timeout waiting for space management resource
>
> During this time performance is very bad.
>
> The error manual says, "System timed out before it could acquire the necessary
> resouces to do space management." and simply suggests waiting and trying the
> same operation later.
>
> Can somebody tell me what sort of space managment this refers too? I am not
> sure where to start looking for problems first.
>
> The temporary tablespace is supposedly very fragmented and I have posted a
> separate question on this.
>
> We are using Oracle7 Server Release 7.2.3.0.0 on HP UNIX.
>
> Thank you very much,
>
> Catherine Cox
> catcox_at_aol.com
Received on Sun Feb 08 1998 - 00:00:00 CST