Wednesday, December 3, 2008

Dynamic Performance View V$LOCK_TYPE

Hi Friends,

Here is one more new thing that I found tonight. There is a new dynamic performance view named V$LOCK_TYPE from Oracle 10g Release 1. Here are some of the views differenciated by Oracle version release. I think this is a good information for all the DBA's and hope you will enjoy!!! 

-     Oracle 10g Rel 1 came with 138 Lock type

-     Oracle 10g Rel 2 came with another 17 lock type

-     Oracle 11g Rel 1 came with another 32 lock type but non of them is removed.

Name

Description

Version From

AD

ASM Disk AU Lock

10g Rel 1

AF

Advisor Framework

10g Rel 1

AG

Analytic Workspace Generation

10g Rel 1

AK

GES Deadlock Test

10g Rel 1

AO

MultiWriter Object Access

10g Rel 1

AS

Service Operations

10g Rel 1

AT

Alter Tablespace

10g Rel 1

AW

Analytic Workspace

10g Rel 1

BR

Backup/Restore

10g Rel 1

CF

Controlfile Transaction

10g Rel 1

CI

Cross-Instance Call Invocation

10g Rel 1

CL

Label Security cache

10g Rel 1

CM

ASM Instance Enqueue

10g Rel 1

CT

Block Change Tracking

10g Rel 1

CU

Cursor

10g Rel 1

DB

DbsDriver

10g Rel 1

DD

ASM Local Disk Group

10g Rel 1

DF

Datafile Online in RAC

10g Rel 1

DG

ASM Disk Group Modification

10g Rel 1

DI

GES Internal

10g Rel 1

DL

Direct Loader Index Creation

10g Rel 1

DM

Database Mount/Open

10g Rel 1

DN

Diskgroup number generator

10g Rel 1

DP

LDAP Parameter

10g Rel 1

DQ

ASM RBAL doorbell

10g Rel 1

DR

Distributed Recovery

10g Rel 1

DS

Database Suspend

10g Rel 1

DT

Default Temporary Tablespace

10g Rel 1

DV

Diana Versioning

10g Rel 1

DX

Distributed Transaction

10g Rel 1

E

Library Cache Lock 2

10g Rel 1

FA

ASM File Access Lock

10g Rel 1

FB

Format Block

10g Rel 1

FC

Disk Group Chunk Mount

10g Rel 1

FD

Flashback Database

10g Rel 1

FG

ACD Relocation Gate Enqueue

10g Rel 1

FL

Flashback database log

10g Rel 1

FM

File Mapping

10g Rel 1

FR

Disk Group Recovery

10g Rel 1

FS

File Set / Dictionary Check

10g Rel 1

FT

Disk Group Redo Generation

10g Rel 1

FU

DBFUS

10g Rel 1

G

Library Cache Pin 2

10g Rel 1

HD

ASM Disk Header

10g Rel 1

HP

Queue Page

10g Rel 1

HQ

Hash Queue

10g Rel 1

HV

Direct Loader High Water Mark

10g Rel 1

HW

Segment High Water Mark

10g Rel 1

IA

Internal

10g Rel 1

ID

NID

10g Rel 1

IL

Label Security

10g Rel 1

IM

Kti blr lock

10g Rel 1

IR

Instance Recovery

10g Rel 1

IS

Instance State

10g Rel 1

IT

In-Mem Temp Table Meta Creation

10g Rel 1

IV

Library Cache Invalidation

10g Rel 1

IZ

INSTANCE LOCK

10g Rel 1

JD

Job Queue Date

10g Rel 1

JI

Materialized View

10g Rel 1

JQ

Job Queue

10g Rel 1

JS

Job Scheduler

10g Rel 1

KK

Kick Instance to Switch Logs

10g Rel 1

KM

Scheduler

10g Rel 1

KP

Kupp Process Startup

10g Rel 1

KT

Scheduler Plan

10g Rel 1

L

Library Cache Lock 1

10g Rel 1

MD

Materialized View Log DDL

10g Rel 1

MH

AQ Notification Mail Host

10g Rel 1

ML

AQ Notification Mail Port

10g Rel 1

MN

LogMiner

10g Rel 1

MR

Media Recovery

10g Rel 1

MS

Materialized View Refresh Log

10g Rel 1

MW

MWIN Schedule

10g Rel 1

N

Library Cache Pin 1

10g Rel 1

OC

Outline Cache

10g Rel 1

OL

Outline Name

10g Rel 1

OQ

OLAPI Histories

10g Rel 1

PD

Property Lock

10g Rel 1

PE

Parameter

10g Rel 1

PF

Password File

10g Rel 1

PG

Global Parameter

10g Rel 1

PH

AQ Notification Proxy

10g Rel 1

PI

Remote PX Process Spawn Status

10g Rel 1

PL

Transportable Tablespace

10g Rel 1

PM

ASM PST Signalling

10g Rel 1

PR

Process Startup

10g Rel 1

PS

PX Process Reservation

10g Rel 1

PT

ASM Partnership and Status Table

10g Rel 1

PV

KSV slave startup

10g Rel 1

PW

Buffer Cache PreWarm

10g Rel 1

Q

Row Cache

10g Rel 1

RB

ASM Rollback Recovery

10g Rel 1

RF

Data Guard Broker

10g Rel 1

RM

GES Resource Remastering

10g Rel 1

RN

Redo Log Nab Computation

10g Rel 1

RO

Multiple Object Reuse

10g Rel 1

RP

Resilver / Repair

10g Rel 1

RS

Reclaimable Space

10g Rel 1

RT

Redo Thread

10g Rel 1

SB

LogicalStandby

10g Rel 1

SC

System Change Number

10g Rel 1

SF

AQ Notification Sender

10g Rel 1

SH

Active Session History Flushing

10g Rel 1

SI

Streams Table Instantiation

10g Rel 1

SK

Shrink Segment

10g Rel 1

SM

SMON Serialization

10g Rel 1

SQ

Sequence Cache

10g Rel 1

SR

Synchronized Replication

10g Rel 1

SS

Sort Segment

10g Rel 1

ST

Space Transaction

10g Rel 1

SU

SaveUndo Segment

10g Rel 1

SV

Sequence Ordering

10g Rel 1

SW

Suspend Writes

10g Rel 1

TA

Instance Undo

10g Rel 1

TB

SQL Tuning Base Existence Cache

10g Rel 1

TC

Tablespace Checkpoint

10g Rel 1

TD

KTF map table enqueue

10g Rel 1

TE

KTF broadcast

10g Rel 1

TF

Temporary File

10g Rel 1

TL

Log Lock

10g Rel 1

TM

DML

10g Rel 1

TO

Temp Object

10g Rel 1

TQ

Queue table enqueue

10g Rel 1

TS

Temporary Segment

10g Rel 1

TT

Tablespace

10g Rel 1

TW

Cross-Instance Transaction

10g Rel 1

TX

Transaction

10g Rel 1

UL

User-defined

10g Rel 1

UN

User Name

10g Rel 1

US

Undo Segment

10g Rel 1

WA

AQ Notification Watermark

10g Rel 1

WF

AWR Flush

10g Rel 1

WL

Being Written Redo Log

10g Rel 1

WP

AWR Purge

10g Rel 1

WS

LogWriter Standby

10g Rel 1

XH

AQ Notification No-Proxy

10g Rel 1

XR

Quiesce / Force Logging

10g Rel 1

XY

Internal Test

10g Rel 1

AM

ASM Enqueue

New in 10g Rel 2

AU

Audit Index File

New in 10g Rel 2

BF

Bloom Filter

New in 10g Rel 2

CN

LTCN REG enquere

New in 10g Rel 2

FP

File Object

New in 10g Rel 2

FW

Flashback Writer

New in 10g Rel 2

KO

Multiple Object Checkpoint

New in 10g Rel 2

MK

Master Key

New in 10g Rel 2

OW

Encryption Wallet

New in 10g Rel 2

RU

Rolling Upgrade

New in 10g Rel 2

RW

Materialized View Flags

New in 10g Rel 2

SE

Session Migration

New in 10g Rel 2

V

Library Cache Lock 3

New in 10g Rel 2

WR

LNS archiving log

New in 10g Rel 2

XQ

ASM Extent Relocation Enqueue

New in 10g Rel 2

Y

Library Cache Pin 3

New in 10g Rel 2

ZG

File Group

New in 10g Rel 2

AE

Edition Lock

New in 11g Rel 1

AR

ASM Relocation Lock

New in 11g Rel 1

AV

AVD DG Number Lock

New in 11g Rel 1

AY

KSXA Test Affinity Dictionary

New in 11g Rel 1

BB

Global Transaction Branch

New in 11g Rel 1

CA

Calibration

New in 11g Rel 1

CO

KTUCLO Master Slave enqueue

New in 11g Rel 1

CQ

Cleanup querycache registrations

New in 11g Rel 1

DO

ASM Disk Online Lock

New in 11g Rel 1

DW

In memory Dispenser

New in 11g Rel 1

FE

KTFA Recovery

New in 11g Rel 1

FX

ACD Extent Info CIC

New in 11g Rel 1

FZ

ASM Freezing Cache Lock

New in 11g Rel 1

KE

ASM Cached Attributes

New in 11g Rel 1

KL

LOB KSI Lock

New in 11g Rel 1

KQ

ASM Attributes Enqueue

New in 11g Rel 1

MO

MMON restricted session

New in 11g Rel 1

MX

ksz synch

New in 11g Rel 1

OD

Online DDLs

New in 11g Rel 1

RC

Result Cache: Enqueue

New in 11g Rel 1

RE

Block Repair/Resilvering

New in 11g Rel 1

RR

Workload Capture and Replay

New in 11g Rel 1

RX

ASM Extent Relocation Lock

New in 11g Rel 1

SJ

KTSJ Slave Task Cancel

New in 11g Rel 1

SL

Serialize Lock request

New in 11g Rel 1

SO

Shared Object

New in 11g Rel 1

TH

Threshold Chain

New in 11g Rel 1

TK

Auto Task Serialization

New in 11g Rel 1

WG

Write gather local enqueue

New in 11g Rel 1

WM

WLM Plan Operations

New in 11g Rel 1

XB

ASM Group Block Lock

New in 11g Rel 1

XL

ASM Extent Fault Lock

New in 11g Rel 1

 

1 comment:

  1. THANKS TO IMERGE FOR POSTING THIS GOOD INFORMATION...

    I REALLY APPRECIATE!!!!

    ReplyDelete