Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ST-enqueue problem

Re: ST-enqueue problem

From: <markp7832_at_my-deja.com>
Date: Tue, 16 Nov 1999 14:24:34 GMT
Message-ID: <80rpes$vt1$1@nnrp1.deja.com>


In article <80r8tj$6tf$2_at_news2.kornet.net>,   "Cho, Hyon-Hyok" <cho2h_at_kt.co.kr> wrote:
> Hi !!
> I am running oracle8.0.1 OPS on IBM SP Machine...
> On my system, st-enqueue problem is very serious.
> so I'm very careful whenver I create any objects.
> I can bear it, too small initial or next size can cause
> st-enqueue contention.
>
> But I can't understand why st-enqueue arose when
> I rebuild index!!!!(alter index ~ rebuild ;)
> My index-rebuild script performe rebulding across the
> whole nodes, and each node performe rebulding
> on its own tablespaces.
> But when I start rebulding, I found that every command
> running across all nodes got a contentition problem.
>
> Is there any parameter that can avoid st-enqueue
> contention problem?
>
> Thanks, have a good time!!!!
>
> ===================================================
> At the edge of the chaos, You will find the new rule.....
>

One of the things that can cause an ST lock problem is having a non- temporary temp tablespace.

You can also run into ST enqueues when you have an environment where a lot of extent allocation (and deallocation) takes place because these operations contend on sys.uet$ and fet$ which are the real tables under sys.dba_extents and dba_free_space.

You should verify that you have enough enqueue resources to support your environment. Oracle calculates this number but at least in ver 7.3 and below you could need more than it calculated. See init.ora parameter enqueue_resources.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 16 1999 - 08:24:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US