Global Cache Stats
ReposApr 27 2009 — edited Apr 27 2009In our 4 node rac running on linux x86-64 bit with Oracle 10 g release 2 , i am getting critical warning in my
enterprise manage page
Database InstanceGlobal Cache StatisticsGlobal Cache Blocks LostMetrics "Global Cache Blocks Lost" is at 6Apr 27, 2009 8:06:20 PM
Database InstanceGlobal Cache StatisticsGlobal Cache Blocks LostMetrics "Global Cache Blocks Lost" is at 5
In the awr report the following are the top 5 events
-------------------------------------------------------------------------------------------------------------------------------
Top 5 Timed Events
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time 7 43.8
gc cr block busy 233 6 25 36.4 Cluster
control file sequential read 10,487 3 0 18.6 System I/O
gc current block busy 224 3 13 18.1 Cluster
control file parallel write 1,203 2 1 10.6 System I/O
-------------------------------------------------------------------------------------------------------------------------------
which one is giving the critical warning
rds
Edited by: user1000000 on Apr 27, 2009 6:11 AM
Edited by: user1000000 on Apr 27, 2009 6:11 AM