Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-01
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, 70 of 237


V$GES_CONVERT_REMOTE

V$GES_CONVERT_REMOTE displays average convert time, count information, and timed statistics for remote GES enqueue operations.

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, 2002 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