Materialized View Logs Editor (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Editors

The Materialized View Logs Editor lets you view replication log table details, and manage space, storage, and performance details for a materialized view log.

To edit a materialized view log

  1. Open an editor on the materialized view log. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Displays information on the log table used for replication.


Lets you work with settings in the following categories:

Data Block Storage

Lets you view the associated Tablespace and Initial Transactions value, and modify the Percent Free, Percent Used, and Max Transactions values.


Lets you view Initial Extent, Next Extent, Minimum Extents, Maximum Extents, and Percent Increase values.

Column Filtering

Lets you select the filter columns to be recorded in the materialized view log. You can specify only one primary key, one ROWID and one filter column list per materialized view log. The ROWID is a globally unique identifier for a row in a database. It is created at the time the row is inserted into a table, and destroyed when it is removed from a table.


Lets you work with settings in the following categories:

Parallel Query Option

The Parallel server query option lets you process queries using many query server processes running against multiple CPUs. This option provides substantial performance gains such as reduction of the query completion time. Degrees - Lets you type a value indicating the number of query server processes that should be used in the operation. Instances - Lets you type a value indicating how you want the parallel query partitioned between the Parallel Servers.


Select Logging to create a log for all Materialized View updates.


Select Cache if you want Oracle to put data you access frequently at the most recently used end of the list in the buffer cache when a full table scan is performed. This option is useful for small lookup tables.


For details on using this tab, see Working with Object Dependencies.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.