Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 51 of 211


V$DLM_CONVERT_REMOTE

V$DLM_CONVERT_REMOTE displays the elapsed time for the remote lock conversion operation.

Column  Datatype  Description 

INST_ID  

NUMBER 

ID of the instance 

CONVERT_TYPE  

VARCHAR2(64) 

Conversion types are listed in Table 3-3 

 

 

  • NULL -> SS: NULL mode to subshared mode

  • NULL -> SX: NULL mode to shared exclusive mode

  • NULL -> S: NULL mode to shared mode

  • NULL -> SSX: NULL mode to subshared exclusive mode

  • NULL -> X: NULL mode to exclusive mode

  • SS -> SX: subshared mode to shared exclusive mode

  • SS -> S: subshared mode to shared mode

  • SS -> SSX: subshared mode to subshared exclusive mode

  • SS -> X: subshared mode to exclusive mode

  • SX -> S: shared exclusive mode to shared mode

  • SX -> SSX: shared exclusive mode to subshared exclusive mode

  • SX -> X: shared exclusive mode to exclusive mode

  • S -> SX: shared mode to shared exclusive mode

  • S -> SSX: shared mode to subshared exclusive mode

  • S -> X: shared mode to exclusive mode

  • SSX -> X: sub-shared exclusive mode to exclusive mode

 

AVERAGE_CONVERT_TIME  

NUMBER 

Average conversion time for each type of lock operation (in 100th of a second) 

CONVERT_COUNT  

NUMBER 

The number of operations 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback