Dynamic Performance (V$) Views, 46 of 179

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