User`s guide

Chapter 14: Database Administration 227
• Advanced Configuration (reference)
14.5.9 Extended Information
Figure 104: Extended information
Extended information can be viewed if the option Enable advanced options in
extended info
is enabled.
CAUTION! The different actions in these views could potentially stop the schema
from working if an error occurs while running the scripts.
All information tabs have the option to refresh the database information result b
clicking the
Refresh button. The following information and options are available:
• List all tables with counts: Lists all tables in the schema and the number of
rows in each.
• AQ Subscribers: Shows a list of the message queue (AQ) Subscribers currently
registered.
• AQ & Purge Job: Lists the status of and allows the user to activate/deactivate
the AQ Triggers and the Purge Job. This view also has an option to recreate the
AQ tables, which is done by deleting and recreating the tables.
• Deact. and Act. AQ Triggers: Disables and enables the AQ system if this is
working properly (see, Message Queue).
• Deact. and Act. Purge Job: Disables and enables a scheduled job on the
database that purges old messages from the AQ system to avoid these
tables clogging the database with obsolete data. (see, Purge Expired
Messages).
• Recreate AQ Tables: Deletes all AQ tables and all data in them, and then
creates new tables and register these with Oracle’s AQ system. This option
will delete all messages not received in the AQ tables, and if any errors
occur the AQ system will not work afterwards. This option should therefore