O'Reilly logo

Oracle Database 12c Release 2 Performance Tuning Tips & Techniques by Richard Niemiec

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Images

APPENDIX

A

Key Initialization Parameters (DBA)

Oracle 12c Release 2 has 412 different documented and 4237 different undocumented initialization (init.ora/spfile.ora) parameters. This means you have a total of 4649 initialization parameters to play with; you can do a count(*) of X$KSPPI for the total number of parameters both documented and undocumented (you need to be SYS to access the X$ tables). A count of V$PARAMETER gives you a count of only the documented parameters. When I refer to the undocumented parameters, I am referring to parameters that start with an underscore (_), although some of them are actually even documented. There are also ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required