Set Up Considerations

There are certain topics you should consider before setting up the scheduler.

Table Space Requirements

The database containing the Oracle Business Intelligence Scheduler database tables requires minimum disk space.

Minimum disk space requirements include:

  • 500MB on Oracle and Microsoft SQL Server databases for standalone and Business Intelligence applications and deployments.

  • 500MB on IBM DB2 databases for standalone deployments.

For report storage, you must calculate the appropriate amount of space based on your company's usage. If you generate and archive multiple large reports, for example if your company generates an average of 2GB total file size of reports per month, and you also store the XML data for a period of one year, then the requirement will be (2 GB x 2 x 12 = 48 GB) on disk. Note that the size of the BLOB and CLOB may not be the same in the database as in the file system, but this calculation can provide approximate requirements.

Choosing JNDI or JDBC Connection

By default, the BI Platform installer configures the WebLogic JNDI connection URL.

JDBC is not recommended for production use. JDBC should only be used for low volume local testing.

Supported JMS Providers

When you install BI Publisher, the scheduler is automatically configured to use WebLogic JMS.

To configure BI Publisher to use ActiveMQ instead, see Configuring BI Publisher for ActiveMQ.