Database Storage Properties dialog: 8i Properties tab

Use this dialog to view and set database storage properties that are specific to Oracle 8.1.7 databases and later.

For more information, see:

"About folders and summary folders in Discoverer"

"What is manual summary folder creation?"

The following chart lists the fields and their default values. When you select a field, the panel at the bottom of the dialog displays a message relating the purpose of the field and the data type it will accept.

Property	Datatype	Default Value	Range	Create/Edit
Parallel Inserts	boolean	No	Yes/No/Default	yes
No. of Processes	integer	1		yes, if parallel = yes
Logging	boolean	Same as user's tablespace	Yes/No	yes
Cache	boolean	No	Yes/No	yes, if logging = yes
Refresh Type		Complete	Complete/Fast	yes
Refresh		On Demand	On Demand/On Commit
Last Refresh				read only
Incremental Load				read only
Stale	boolean	No		read only

Refresh Type

• Incremental

  Incremental refresh; only rows that have changed in the master tables will be applied to the summary tables. This is equivalent to the FORCE option where fast refresh is performed if possible.

  For further information on the conditions required for incremental refresh, please see Oracle9i Data Warehousing Guide.

• Full

  The summary is entirely recalculated from the detail tables.

Refresh Mode

• On Demand

  Refresh is carried out manually or through scheduled refreshes.

• On Commit

  Refresh occurs every time detail tables are updated. There is no need to schedule refreshes and the scheduling option of the Summary Wizard is not enabled.

  Restrictions apply as to when you can perform a Refresh On Commit. Please see Oracle9i Data Warehousing Guide for a complete description.

Incremental Load

This read only property provides you with an indication as to the types of inserts to the detail/fact table that are available for incremental refresh support

• NO

  The materialized view is not 'fast refreshable', and hence is complex

• Direct Load

  Only direct loads will be handled

• DML

  Only DMLs will be handled

• Direct Load and DML

  Both direct loads and DML will be handled

• Direct Load and limited DML

  Direct loads and a subset of DML will be handled

Parellelism

Allows a degree of parallelism to be chosen for the refresh option.

Notes

• This tab is visible when running against Oracle 8.1.7+ databases only.