Database Reference
In-Depth Information
Script: MVRACPDnTap_convert_local.sql
SELECT inst_id INT,
convert_type CT,
average_convert_time ACT,
convert_count CC
FROM gv$ges_convert_local
WHERE average_convert_time > 0
ORDER BY inst_id;
Cur Average
Inst Convert Type Convert Time Convert Count
---- ---------------- ------------ -------------
1 NULL -> SS 1 187
NULL -> SX 1 8
NULL -> S 1 83295
NULL -> SSX 9 28359
NULL -> X 4 7155
S -> X 1 3453
SSX -> X 3 2198
GV$GES_CONVERT_REMOTE
These are display values for remote GES enqueue operations. This view records average convert times, count
information, and timed statistics for global enqueue requests for CURRENT blocks. It is a useful view to determine the
type of locks conversions that did not occur locally on the instance and had happened on one of the remote instances
in the cluster. This view is also useful to determine the amount of cluster overhead from moving from a single-instance
configuration to a clustered RAC database configuration.
Note
the various types of conversions are illustrated in table 13-3 .
Script: MVRACPDnTap_convert_remote.sql
SELECT inst_id INT,
convert_type CT,
average_convert_time ACT,
convert_count CC
FROM gv$ges_convert_remote
WHERE average_convert_time > 0
ORDER BY inst_id;
Cur Average
Inst Convert Type Convert Time Convert Count
---- ---------------- ------------ -------------
1 NULL -> SS 1 4715
NULL -> SX 2 181
NULL -> S 1 756076
NULL -> SSX 6 606
NULL -> X 5 29425
S -> X 1 2990
SSX -> X 9 695
 
 
Search WWH ::




Custom Search