Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!canoe.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: sroesch3@attbi.com (Steve)
Newsgroups: comp.databases.oracle.server
Subject: Re: Why event "global cache lock open x " wait forever?
Date: 10 Oct 2002 18:17:49 -0700
Organization: http://groups.google.com/
Lines: 43
Message-ID: <efc3f20b.0210101717.6c09aa29@posting.google.com>
References: <92A2664ABmelocy21cncom@130.133.1.4>
NNTP-Posting-Host: 148.87.1.170
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1034299069 10101 127.0.0.1 (11 Oct 2002 01:17:49 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 11 Oct 2002 01:17:49 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163807
X-Received-Date: Thu, 10 Oct 2002 18:17:44 MST (news.easynews.com)

Advice so far doesn't make a lot sense for me.

Version 8.05 isn't supported now for a very long time. Think about
upgrading to a supported release.

First thing is to figure out if it is slow or actually hanging.
To check that enable event 10046 level 8 and look in the trace 
file if it is stuck or simply slow.

The wait event global cache open x means that we are trying to 
open a new lock in exclusive mode. Unfortunately you didn't
mention p1 and p2 which is the fileno and the block no.

Next step is to figure out which kind of class the object belongs 
to and how many locks/resources are configured for that file. This also
depends on what kind of locking you are using (hash or dba locking)

You might check the parameter gc_file_to_locks


Regards
Steve




melocy@21cn.com (melocy) wrote in message news:<92A2664ABmelocy21cncom@130.133.1.4>...
> Evironment:2 * RS6000 AIX4.3.2 Oracle805 OPS(db1,db2)
> on db2,one transaction is that:
> 
> set transaction use rollback segment rbig;
> delete from aaa.t1;
> insert into aaa.t1 select * from bbb.t1; 
> commit;
> 
> WHEN execute statement "Insert into ....",
> process hang.
> query v$session_wait,event is "global cache lock open x "
> query v$session_event,event "global cache lock open x" 
> total_waits is adding continually and total_timeouts is adding too.
> 
> Help me ,Pls. 
> Thx.