Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RAC Cache Fusion

456624Aug 28 2007 — edited Sep 7 2011
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2011
Added on Aug 28 2007
12 comments
2,712 views