Oracle WebCenter Content (MOSC)

MOSC Banner

optimizer_mode change from default value from database ?

edited Oct 21, 2013 5:20AM in Oracle WebCenter Content (MOSC) 6 commentsAnswered ✓
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

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