Database Tuning (MOSC)

MOSC Banner

Oracle optimizer env

There are three views v$ses_optimizer_env, v$sys_optimizer_env and v$sql_optimizer_env. By default in my 19c database they show 70 total rows. From what I understand these are parameters which can influence the optimizer's decision making. They are used to determine why child cursors are being generated for the same sql statement, etc. If I set a session parameter and run a query then that parameter change will be noted in the view. I get that part. What I'm confused about is why there are 70 or only 70? Why are these listed by default? There are many more parameters which influence the

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