Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is lock type 'KO' in v$lock table?
Bart the bear wrote:
> Charles Hooper wrote:
> > Bart the bear wrote:
> > > Does anyboy know?
> >
> > Try here for an answer:
> > http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/enqueues.htm
> >
> > Maybe this SQL statement will help:
> > SELECT
> > *
> > FROM
> > V$LOCKED_OBJECT;
>
> It doesn't tell me anything. What the heck is "multiple objects
> checkpoint"?
A search of Metalink and other documentation fails to provide a definition of "multiple object checkpoint", as does a Google search. Given the amount of information that you have provided, the only suggestion that I can offer is to interpret the phase literally - there are more than one table, index, or other object that is waiting for a checkpoint to complete.
Are you using RAC? Are you trying to determine how fast the database instance can recover from a SHUTDOWN ABORT? Does the server have 256MB of memory, while you have allocated 1.5GB to the database buffer cache, you have redo logs set at 5MB each, and are trying to perform a full table scan on a table that is 2GB in size?
What is happening in the system before you see the lock type "KO" in the V$LOCK view? Have you checked the alert log, or looked for bdump or udump logs?
Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.
Received on Fri Sep 22 2006 - 19:10:00 CDT
![]() |
![]() |