Many entries in dba_subscr_registrations
Hi,
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?
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?
0