Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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 7-5
  • 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