DBA Data[Home] [Help]

VIEW: SYS.DBA_HIST_ROWCACHE_SUMMARY

Source

View Text - Preformatted

select "SNAP_ID","DBID","INSTANCE_NUMBER","PARAMETER","TOTAL_USAGE","USAGE","GETS","GETMISSES","SCANS","SCANMISSES","SCANCOMPLETES","MODIFICATIONS","FLUSHES","DLM_REQUESTS","DLM_CONFLICTS","DLM_RELEASES","CON_DBID","CON_ID" from INT$DBA_HIST_ROWCACHE_SUMMARY
View Text - HTML Formatted

SELECT "SNAP_ID"
, "DBID"
, "INSTANCE_NUMBER"
, "PARAMETER"
, "TOTAL_USAGE"
, "USAGE"
, "GETS"
, "GETMISSES"
, "SCANS"
, "SCANMISSES"
, "SCANCOMPLETES"
, "MODIFICATIONS"
, "FLUSHES"
, "DLM_REQUESTS"
, "DLM_CONFLICTS"
, "DLM_RELEASES"
, "CON_DBID"
, "CON_ID"
FROM INT$DBA_HIST_ROWCACHE_SUMMARY