Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer 11g Release 1 (11.1.1) Part Number B32519-01 |
|
|
View PDF |
Use this tab to view and set database storage properties that are specific to Oracle9i (or later) Enterprise Edition databases.
Note: Database storage properties do not apply to summary folders based on external summary tables.
For more information, see:
"What are materialized views?"
"Creating Summary Folders Manually"
"How to edit database storage properties of summary combinations for a summary folder"
The following table lists the properties and their default values, where appropriate. When you select a property, the panel at the bottom of the dialog displays a description of the purpose of the property.
Property | Default Value | Range | Create/Edit |
---|---|---|---|
Parallel Inserts | No | Yes/No/Default | yes |
No. of Processes | 1 | yes, if Parallel Inserts set to yes | |
Logging | Same as user's tablespace | Yes/No | yes |
Cache | No | Yes/No | yes, if Logging set to yes |
Refresh Type | Full | Full/Incremental | yes |
Refresh | On demand | On demand/On commit | yes |
Last Refresh | no | ||
Incremental Load | no | ||
Stale | no |
Parallel Inserts
Use this property to choose whether to use parallel inserts when refreshing summary folders.
No. of processes
Use this property (if Parallel Inserts is set to Yes) to set the number of parallel processes used when refreshing summary folders.
Logging
Use this property to enable or disable database logging.
Cache
Use this property to enable or disable database caching.
Refresh Type
Use this property to specify whether the summary folder Refresh Type is Incremental or Full.
Incremental
Only rows that have changed in the detail tables will be applied to the summary folder.
For more information on the conditions required for incremental refresh, see the Oracle Database Data Warehousing Guide.
Full
The summary folder is entirely rebuilt from the detail tables.
Refresh Mode
Use this property to specify whether the summary folder Refresh Mode is On demand or On commit.
On demand
Select this option to refresh manually or through scheduled refreshes.
On commit
Select this option to refresh every time the detail tables are updated. There is no need to schedule refreshes, and the scheduling option of the Summary Wizard is not enabled.
Restrictions apply for when you can perform a refresh On commit. For more information, see the Oracle Database Data Warehousing Guide.
Last Refresh
This read-only property indicates the date when the last summary folder was refreshed.
Incremental Load
This read-only property indicates the types of inserts to the detail/fact table that can be incrementally refreshed.
None
The materialized view cannot be incrementally refreshed.
Direct Load
Only direct loads can be handled.
DML
Only DML (data manipulation language) statements can be handled.
Direct Load and DML
Both direct loads and DML can be handled.
Direct Load and limited DML
Direct loads and a subset of DML will be handled (for more information, see the Oracle Database documentation)
Stale
This read-only property indicates whether the detail tables have changed since the last summary folder refresh.