Not able to retrieve RAC specific statistics from GV$SYSTATS
II am not getting values of all cache statistics on my setup from 'GV$SYSTATS'
From documentation it appears that 'GV$SYSTATS should return following counters. I should be able to retrieve name of any counter by :-
"select * from select value from GV$SYSSTATS where name='xyz' where xyz is one of the following:-
According to documentation these should be available:-
global cache blocks corruptglobal cache prepare failuresglobal cache getsglobal cache get timeglobal cache freelist waitsglobal cache defersglobal cache cr timeoutsglobal cache cr requests blockedglobal cache cr blocks servedglobal cache cr blocks receivedglobal cache cr block serve timeglobal cache cr block send timeglobal cache cr block receive timeglobal cache cr block log flush timeglobal cache cr block log flushesglobal cache convertsglobal cache convert timeoutsglobal cache convert time