Hint Specifying Not to Use Global Plan Cache

Function

When global plan cache is enabled, you can use the no_gpc hint to force a single query statement not to share the plan cache globally. Only the plan cache within the current session lifecycle is retained.

Syntax

no_gpc

NOTE: This parameter takes effect only for statements executed by PBE when enable_global_plancache is set to on.

Example

No result exists in the dbe_perf.global_plancache_status view, that is, no plan is cached globally.