Current Position:Home > Many entries in DBA_SUBSCR_REGISTRATIONS

Many entries in DBA_SUBSCR_REGISTRATIONS

Update:11-30Source: network consolidation
Advertisement
We use Advanced Queueing-Feature for Forms "External Events". We use RDBMS 11.2.0.2 EE-RAC.
During the last days we had increasing problems with the performance of the database.
We try to assess, whehter AQ was the reason for the problem.
We had a lot of Session waits "library cache lock". We saw a lot of Statements for reg$-table.
In the table DBA_SUBSCR_REGISTRATIONS were 114000 entries.
Is it posible that the performance degrades when a lot of queue-registrations are available (a lot of enries in DBA_SUBSCR_REGISTRATIONS)?
Is it possible to clear (remove all at once) the registrations without restarting the instance?

The Best Answer

Advertisement
We use Advanced Queueing-Feature for Forms "External Events". We use RDBMS 11.2.0.2 EE-RAC.
During the last days we had increasing problems with the performance of the database.
We try to assess, whehter AQ was the reason for the problem.
We had a lot of Session waits "library cache lock". We saw a lot of Statements for reg$-table.
In the table DBA_SUBSCR_REGISTRATIONS were 114000 entries.
Is it posible that the performance degrades when a lot of queue-registrations are available (a lot of enries in DBA_SUBSCR_REGISTRATIONS)?
Is it possible to clear (remove all at once) the registrations without restarting the instance?