RAC Cache Fusion
456624Aug 28 2007 — edited Sep 7 2011Hi,
I wanted to view the cache fusion happening in the RAC cluster.
The steps I am following are:
1) first instance (orcl1), user a -->
select count(*) from table1 where object_type='VIEW';
--->This count is returned as 1,83,950 --> So I expect that this is a good amount of data returned.
After the count is given I am firing the same query in the other instance (orcl2) with same user a.
2) I have a script running this whole time during the query fired in orcl1 and orcl2 which contains the following :
SELECT FILE#,BLOCK#,CLASS#,STATUS,XNC FROM GV\$CACHE_TRANSFER WHERE NAME ='table1';
But this table's output is constantly giving me no rows selected. I was hoping to see some rows confirming that cache fusion is taking place here.
Am I assuming something wrong. Please can someone suggest the right way.
Also if anybody can direct me to a query which can say solve my purpose of testing cache fusion happening, it would really be great.