Database - RAC/Scalability (MOSC)

MOSC Banner

How to check the number of DMLs performed by the refresh in oracle RAC database

edited Aug 9, 2011 2:49AM in Database - RAC/Scalability (MOSC) 5 commentsAnswered
We always use table X$KNSTMVR to check the number of DMLs performed by the refresh in oracle database .

But in the RAC enviornment, the data on  X$KNSTMVR only have the data for it's own instance.

How can I check the golbal information of  X$KNSTMVR ?

Another question is for view GV$MVREFRESH, when I query GV$MVREFRESH on one instance, it will show the data for all the instance. but when I run the query on VIEW_DEFINITION for this view, it only show the data for current instance. Why?

SQL> select * from gv$mvrefresh;

   INST_ID        SID    SERIAL# CURRMVOWNER                     CURRMVNAME

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center