Database DataWarehousing (MOSC)

MOSC Banner

High activity on OWBSYS"."WB_RT_NOTIFY_QUEUE_TAB"

edited Jan 28, 2016 10:05AM in Database DataWarehousing (MOSC) 4 commentsAnswered

On our production datawarehoue,we got very high activity  on OWBSYS"."WB_RT_NOTIFY_QUEUE_TAB" table.

Strangely on the test environment We did not see any high activity. The only difference between those is that the production database is stopped daily to make a cold backup.

The test is not stopped for making  a backup.

Does anyone know what is causing this high activity on the above mentioned table. The datawarehouse load is running out of time and should be run faster. So to get rid of that query on OWBSYS"."WB_RT_NOTIFY_QUEUE_TAB" could help??

(Oracle version 11.1.07 and running on sun solaris 64 bit )

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