"Global Cache Blocks Lost" is at XX
Hi,
We have 3 instance RAC managed by another infrastructure provider. For the past few days I am noticing the following alert on my EM database control :
"Global Cache Blocks Lost" is at XX
where XX varies from 4 to 12 ( I know critical threshold for this is 3 so it 12 is way beyond 3).
My investigations/web-reserch says that this 'block transfer lost' is most probably caused by unstable network or interconnect and so I run the following queries to investigate more.
I run the following query to find out , which instance has the problem :
SELECT
A.VALUE "GCB LOST 1",
B.VALUE "GCB CORRUPT 1",
We have 3 instance RAC managed by another infrastructure provider. For the past few days I am noticing the following alert on my EM database control :
"Global Cache Blocks Lost" is at XX
where XX varies from 4 to 12 ( I know critical threshold for this is 3 so it 12 is way beyond 3).
My investigations/web-reserch says that this 'block transfer lost' is most probably caused by unstable network or interconnect and so I run the following queries to investigate more.
I run the following query to find out , which instance has the problem :
SELECT
A.VALUE "GCB LOST 1",
B.VALUE "GCB CORRUPT 1",
4