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