Checking the Business Event System Setup
Use the Check Setup web page to verify that the required parameters and components have been set up to enable message propagation for the Business Event System.
To Check the Business Event System Setup
Attention: This URL accesses a secured page, so if you have not yet logged on as valid user in the current web session, you will be prompted to do so before the page appears. You must have workflow administrator privileges to access the Event Manager web pages.
Note: You can also access the Check Setup web page from the Oracle Workflow home page. See: Accessing the Oracle Workflow Home Page.
2. The Check Setup page appears, displaying the propagation settings and components for your local system.
To modify any of these parameters when using Oracle8i, change the settings in the init.ora file for your database. Then you must restart your database to make the changes effective.
If you are using Oracle 9i, you can either modify the parameters in the init.ora file and restart the database, or you can use the ALTER SYSTEM statement to dynamically modify the values for AQ_TM_PROCESSES and JOB_QUEUE_PROCESSES for the duration of the instance.
- AQ_TM_PROCESSES--This parameter enables the time manager process in Oracle Advanced Queuing (AQ). The time manager process is required by Oracle Workflow to monitor delay events in queues, as in the case of the Oracle Workflow standard Wait activity. The minimum recommended number of time manager processes for Oracle Workflow is one.
- JOB_QUEUE_INTERVAL--If you are using Oracle8i, specify the job queue interval to determine how frequently each SNP job queue process in your instance wakes up. Oracle Workflow requires the job queue interval to be less than or equal to the latency parameter defined for your AQ propagation schedules, to allow queues to be rechecked for messages with the specified latency. The recommended job queue interval for Oracle Workflow is five seconds.
Note: Because the JOB_QUEUE_INTERVAL parameter is desupported in Oracle9i, the Check Setup page does not display this parameter if you are using Oracle9i, and you do not need to set a value for it.
- JOB_QUEUE_PROCESSES--This parameter defines the number of SNP job queue processes for your instance. Oracle Workflow requires job queue processes to handle propagation of Business Event System event messages by AQ queues. You must start at least one job queue process to enable message propagation. The minimum recommended number of processes for Oracle Workflow is two.
Note: You can use another initialization parameter, EVENT, for detailed database level tracing of issues related to AQ. Add the following line to your init.ora file:
event = "24040 trace name context forever, level 10"
Then restart your database to make this change effective. Be aware that using this parameter may generate large trace files.
Note: Ensure that the database link names used in your agents' addresses are exactly the same as the database link names specified when the database links were created.
Oracle Application Developer's Guide - Advanced Queuing