Materialized View Logs Editor (Oracle)

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
Information	Displays information on the log table used for replication.
Storage	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.
	Extents	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.
Performance	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.
	Logging	Select Logging to create a log for all Materialized View updates.
	Cache	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.
Dependencies	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.