Database - RAC/Scalability (MOSC)

MOSC Banner

materialized views fast refresh jobs are running from which instance of the the RAC

edited Apr 15, 2012 2:54AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered
Hi,

We had several read-only materialized views on a database named MV_DB. These materialized views are fast refreshing from a database named MASTER_DB.

Both these databases were 10.2.0.4 single-instance databases.

We just convert these databases into 2 nodes RAC. So now we have MV_DB1, MV_DB2 and MASTER_DB1 , MASTER_DB2.

My quesiton is:

How can we know the materialized views are now fast refreshing from which instances MV_DB1 or MV_DB2.

In other words, which instance is firing the fast refresh jobs . I have tried to identify with :

select sid,job,instance from  dba_jobs_running.

But the column instance always returned 0.

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