High activity on OWBSYS"."WB_RT_NOTIFY_QUEUE_TAB"
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 )