Hint Specifying Not to Use Global Plan Cache

Description

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

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

Example

Click to enlarge

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

Parent topic: Hint-based Tuning

Previous topic: Hint Specifying Not to Expand Subqueries

Next topic: Hint of Parameterized Paths at the Same Level

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel