Skip Headers
Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer
11g Release 1 (11.1.1)

Part Number B32519-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

Database Storage Properties dialog: Materialized Views tab

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:

"Managing Summary Folders"

"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.


Use this property to enable or disable database logging.


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.

Refresh Mode

Use this property to specify whether the summary folder Refresh Mode is On demand or On commit.

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.


This read-only property indicates whether the detail tables have changed since the last summary folder refresh.