O'Reilly logo

Oracle Database 11g 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

image
APPENDIX
A
Key Initialization Parameters (DBA)
image
Oracle 11g Release 2 (11gR2) has 341 different documented and 2053 different undocumented initialization (init.ora/spfile.ora) parameters. This means you have a total of 2394 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 ...

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