Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.2 Supported Optimizer Environment

In Oracle 10.1 there were 25 parameters in the supported optimizer environment; in Oracle 10.2 there are also 25 parameters in the supported optimizer environment.

In Oracle 10.2, one optimizer parameter was added and another parameter was removed.

The following table shows the only optimizer parameter that was added to the V$SYS_OPTIMIZER_ENV family of views in Oracle 10.2

Name
optimizer_secure_view_merging

The following table shows the only optimizer parameter that was removed from the V$SYS_OPTIMIZER_ENV family of views in Oracle 10.2

Name
db_file_multiblock_read_count