Recommendations for the portal content store with an Oracle database

This topic provides the recommendations for setting up an Oracle database server for the portal content store.

The IBM Cognos portal instance memory space requirements vary based on its usage.

In general, the portal content store has limited space requirements because it is mainly used to store Cognos metadata about reports. If you use the database to store saved reports with output, the space requirements are greater because actual data is being stored.

The portal content store should meet the following minimum requirements:

• SGA: 500 MB
• PGA: 500 MB

If you plan to use the portal content store to store saved reports with output, ensure that it meets the following requirements:

• SGA: 1000 MB
• PGA: 1000 MB

The create_portal_content_oracle_tablespaces_and_users.sql script, which is supplied with the product database scripts, sets the tablespace to auto-extend in increments of 1000 MB up to a maximum of 20,000 MB. You can change the maximum size to a smaller value if needed; however, you should set the maximum size to at least 5000 MB.