Database Tuning (MOSC)

MOSC Banner

Parsing times of Oracle 12.2. depending largely on OPTIMIZER_FEATURES_ENABLE

edited Jan 30, 2018 4:20AM in Database Tuning (MOSC) 7 commentsAnswered

Currently I make our internal certification of our programs with Oracle 12.2.0.1 Standard Edition on Windows.

When comparing with Oracle 12.1.0.2 I have seen that the parsing times of the statements are much longer. For a mix of some statements with repeated executions the executions are 15 to 30 % longer.

What is strange is the dependency on the switch OPTIMIZER_FEATURES_ENABLE.

Using an ALTER session SET OPTIMIZER_FEATURES_ENABLE = with values of 12.1.0.2, 12.1.0.1, 11.2.0.3 returns to execution times similar to the edition 12.1.0.2.

Using statements that are already parsed give similar execution times for both Oracle versions. The test statements I use is a mix of different selects (simple, complex) and procedures that contain simple and complex select statements.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center