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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: "CI" locks

Re: "CI" locks

From: Christian Trassens <ctrassens_at_yahoo.com>
Date: Thu, 04 Oct 2001 02:43:50 -0700
Message-ID: <F001.003A192F.20011004015023@fatcity.com>

It's a kind of lock that appears on Parallel Server. However, it happens without it when buffers are flushed for reuse. F.e., during a truncate table.

Also with applications that uses dbms_pipe this contention could be usual, because of the processes queue up for blocks on buffers.

It is recommeded to increase the shared pool. However, if it is sporadic and "nobody" is hurt, I won't change it. Are you using Applications ?.

Regards.


Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062

Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: ctrassens_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Oct 04 2001 - 04:43:50 CDT

Original text of this message

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