B
Frequently Asked Questions

A text file containing a list of frequently asked questions is available online after installing Oracle9iAS Syndication Server.

This text file can be found at:

On UNIX systems:

$ORACLE_HOME/syndication/doc/FAQ.txt

On Windows systems:

$ORACLE_HOME\syndication\doc\FAQ.txt

B.1 Managing Job Queues

Refer to the Managing Job Queues chapter in Oracle9i Database Administrator's Guide to make sure that you have enabled processes for executing jobs. The two issues to be concerned about are:

• The value for the dynamic initialization parameter, JOB_QUEUE_PROCESSES. For example,

  sqlplus "sys/change_on_install as sysdba"
  ALTER SYSTEM SET JOB_QUEUE_PROCESSES=20
  

• Disabling a restricted session in an Oracle9i instance using the initialization parameter, DISABLE RESTRICTED SESSION. For example,

  sqlplus "sys/change_on_install as sysdba"
  ALTER SYSTEM DISABLE RESTRICTED SESSION
  

Because both of these initialization parameters are dynamic, any changes you make will take effect immediately without having to stop and restart the database instance.