Oracle Database 10g Performance Tuning Tips & Techniques

APPENDIX AKey Initialization Parameters (DBA)

There are 257 different documented and 1124 different undocumented initialization (init.ora/spfile.ora) parameters in Oracle 10g Release 2 (10gR2). This means there are a total of 1381 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 will give 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 several of the parameters that I call documented (no "_" in front of them, but ...