Database - RAC/Scalability (MOSC)

MOSC Banner

Not able to retrieve RAC specific statistics from GV$SYSTATS

edited Jan 29, 2014 4:15AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered
Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center