Re: OERR 1575

From: <bchorng_at_my-dejanews.com>
Date: Thu, 11 Mar 1999 21:51:26 GMT
Message-ID: <7c9dsq$pvq$1@nnrp1.dejanews.com>

In article <7c82q5$c50$1_at_news4.muc.eurocyber.net>, "Detlev Goebel" <detlev.goebel_at_gzs.de> wrote:
> Hi,
>
> I got the error message : ORA-01575: timeout waiting for space management
> resource.
>
> Does anybody know which dependencies raise this error message ?
>
> Thanks in advance
>
> Detlev Goebel
>
>

Most of this is caused by SMON busy allocating temporary segments for a sort. If this shows occasionally, it's not a problem. If its more than occasional, tune your temporary tablespace to have larger default extents and pctincrease to 0. You should also increase minextents to 20 to minimize re-allocating extents. One other way is to increase sort_area_size to reduce sort on disks.

On a busy system with intensive query/sorts, I would size 2m for initial and next and minextents 40, and of course 0 for pctincrease.

Regards,

-Bass Chorng
DBA, Lucent Technologies

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 11 1999 - 15:51:26 CST