Re: OERR 1575

From: Detlev Goebel <detlev.goebel_at_gzs.de>
Date: Fri, 12 Mar 1999 09:12:49 +0100
Message-ID: <7calrg$aok$1@news4.muc.eurocyber.net>

Thanks for your hints.
I got this message during DB - reorganization - so I think there is nothing to change.

regards

Detlev Goebel

bchorng_at_my-dejanews.com schrieb in Nachricht <7c9dsq$pvq$1_at_nnrp1.dejanews.com>...
>
>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 Fri Mar 12 1999 - 02:12:49 CST