GCS Stat Summary Interval (PI_PIGC)
- Organization of this page
Function
GCS Stat Summary Interval (PI_PIGC) record stores performance data, taken at specific intervals, about the Global Cache Service (GCS). This record is for Oracle Real Application Clusters.
Default and changeable values
|
Item |
Default value |
Changeable |
|---|---|---|
|
Collection Interval |
60 |
Y |
|
Collection Offset |
0 |
Y |
|
Log |
No |
Y |
|
LOGIF |
(Blank) |
Y |
|
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
None
Lifetime
From the creation to the deletion of an Oracle Real Application Clusters instance
Record size
-
Fixed part: 874 bytes
-
Variable part: 0 bytes
Fields
|
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
|---|---|---|---|---|---|---|
|
GC Blocks Corrupt (GLOBAL_CACHE_BLOCKS_CORRUPT) |
Number of blocks that resulted in some damage or checksum error during interconnection#2 |
AVG |
ulong |
Yes |
All |
GV$SYSSTAT.VALUE WHERE NAME= 'gc blocks corrupt' GROUP BY INST_ID |
|
GC Blocks Lost (GLOBAL_CACHE_BLOCKS_LOST) |
Number of times a global cache request resulted in a timeout due to damage or checksum errors during interconnection#2 |
AVG |
double |
Yes |
All |
GV$SYSSTAT.VALUE WHERE NAME= 'gc blocks lost' GROUP BY INST_ID |
|
GC CRBlock Rec Per MilliSec (GLOBAL_CACHE_CRBLOCK_RECEIVE_PER_MILLISEC) |
Length of time that the foreground process waited for each CR block that was sent via an interconnection (in milliseconds) #2 |
AVG |
double |
No |
All |
(GLOBAL_CACHE_CRBLOCK_RECEIVE_TIME * 10) / GLOBAL_CACHE_CRBLOCKS_RECEIVED GROUP BY INST_ID |
|
GC CRBlock Receive Time (GLOBAL_CACHE_CRBLOCK_RECEIVE_TIME) |
Total length of time the foreground process waited for a CR block that was sent via an interconnection#2 |
AVG |
double |
Yes |
All |
GV$SYSSTAT.VALUE WHERE NAME= 'gc cr block receive time' GROUP BY INST_ID |
|
GC CRBlocks Received (GLOBAL_CACHE_CRBLOCKS_RECEIVED) |
Total number of blocks received#2 |
AVG |
double |
Yes |
All |
GV$SYSSTAT.VALUE WHERE NAME= gc cr blocks received' 'GROUP BY INST_ID |
|
GC Convert Time (GLOBAL_CACHE_CONVERT_TIME) |
Total time that elapsed during lock conversion#2 |
AVG |
double |
Yes |
All |
GV$SYSSTAT.VALUE WHERE NAME = 'global cache convert time' GROUP BY INST_ID |
|
GC Converts (GLOBAL_CACHE_CONVERTS) |
Number of lock conversions in the global cache#2 |
AVG |
double |
Yes |
All |
GV$SYSSTAT.VALUE WHERE NAME = 'global cache convert' GROUP BY INST_ID |
|
GC Get Per MilliSec (GLOBAL_CACHE_GET_PER_MILLISEC) |
Wait time per request (in milliseconds) #2 |
AVG |
double |
No |
All |
(GLOBAL_CACHE_GET_TIME * 10) / GLOBAL_CACHE_GETS GROUP BY INST_ID |
|
GC Get Time (GLOBAL_CACHE_GET_TIME) |
Total wait time#2 |
AVG |
double |
Yes |
All |
GV$SYSSTAT.VALUE WHERE NAME = 'global cache get time' GROUP BY INST_ID |
|
GC Gets (GLOBAL_CACHE_GETS) |
Number of locks obtained#2 |
AVG |
double |
Yes |
All |
GV$SYSSTAT.VALUE WHERE NAME = 'global cache gets' GROUP BY INST_ID |
|
Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record#1 |
COPY |
time_t |
No |
All |
Agent Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record name (always PIGC)#1 |
COPY |
string(4) |
No |
All |
Agent Collector |
|
Start Time (START_TIME) |
Collection start time for the performance data stored in the record#1 |
COPY |
time_t |
No |
All |
Agent Collector |