QUERY_REWRITE_INTEGRITY

Property	Description
Parameter type	String
Syntax	QUERY_REWRITE_INTEGRITY = { enforced | trusted | stale_tolerated }
Default value	enforced
Modifiable	ALTER SESSION, ALTER SYSTEM
Real Application Clusters	Multiple instances can have different values.

QUERY_REWRITE_INTEGRITY determines the degree to which Oracle must enforce query rewriting. At the safest level, Oracle does not use query rewrite transformations that rely on unenforced relationships.

Values:

· enforced

Oracle enforces and guarantees consistency and integrity.

· trusted

Oracle allows rewrites using relationships that have been declared, but that are not enforced by Oracle.

· stale_tolerated

Oracle allows rewrites using unenforced relationships. Materialized views are eligible for rewrite even if they are known to be inconsistent with the underlying detail data.

Note:

1. Related parameter: QUERY_REWRITE_ENABLED

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘QUERY_REWRITE_INTEGRITY’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE		ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
query_rewrite_integrity	STALE_TOLERATED	FALSE	TRUE	IMMEDIATE	TRUE		FALSE	perform rewrite using materialized views with desired integrity

Oracle initializatoin parameters