optimizer_mode change from default value from database ?
Hi
I am working as a DBA and i have found a query that getting wrong plan because Webcenter Content server change it db sessions to use optimizer_mode first_row.
My question is where can can i change that ?
The database is set to pure Cost Base (optimizer_mode = all_rows).
Goal is to configure WebCenter Contenten Server to use all_rows as database is configure for or first_rows_xx and NOT just first_row that is obsolete.
There is no logon triggers that change the sessions optimizer_mode ..
Kind Regards
Björn
I am working as a DBA and i have found a query that getting wrong plan because Webcenter Content server change it db sessions to use optimizer_mode first_row.
My question is where can can i change that ?
The database is set to pure Cost Base (optimizer_mode = all_rows).
Goal is to configure WebCenter Contenten Server to use all_rows as database is configure for or first_rows_xx and NOT just first_row that is obsolete.
There is no logon triggers that change the sessions optimizer_mode ..
Kind Regards
Björn
0