SQL Performance (MOSC)

MOSC Banner

SQL baseline is not used for one child cursor

edited Oct 27, 2019 5:07AM in SQL Performance (MOSC) 2 commentsAnswered

Hi,

we had select with nested table with many child cursors and one cursor used a full scans. So we rewrite the query to use CAST not nested table and then we created the baseline. But the baseline still doesn't work. There's still one child cursor without baseline and full scans.

Do you have any idea why is it so?

DB i EE version 11.2.0.4

show parameter optimizer_use_sql_plan_baselines

NAME                                 TYPE                              VALUE

------------------------------------ --------------------------------- ------------------------------

optimizer_use_sql_plan_baselines     boolean                           TRUE

Thank for yours advices.

Thx,

Jana

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