Re: Oracle7.1 space management problem.

From: Denny Koovakattu <denny_vk_at_my-dejanews.com>
Date: Thu, 25 Mar 1999 16:44:29 GMT
Message-ID: <7ddp5a$mct$1@nnrp1.dejanews.com>

Piero,

This usually happens under heavy load. SMON raises this error when it cannot obtain the ST lock for space management. You could try setting PCTINCREASE to 0 on the TEMP tablespace and if possible on the other tablespaces to prevent SMON from coalesing extents. HTH.

Denny

In article <36FA1E23.6882A9F1_at_eu.pnu.com>, piero stanchi <piero.stanchi_at_eu.pnu.com> wrote:
> Hi everybody.
> I have an oracle 7.1.6 on HPUX B.10.01. I found in smon log files the
> following error:
> ORA-01575: timeout for space management resource
> I do not know what to start with: recreate tables, indexes, change
> storage clauses... Can it be a problem with HPUX?
> Thank you for any help.
> Piero
>
> --
> Piero Stanchi
> Voice: +39 2 48384265 - Email: piero.stanchi_at_eu.pnu.com
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 25 1999 - 10:44:29 CST