Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

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 hundredths of a second)

CONVERT_COUNT

NUMBER

Number of operations