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
CHAPTER
4
Tuning the Database with Initialization Parameters (DBA)
image
The Oracle initialization files (SPFILE or a PFILE such as initSID.ora) determine many Oracle operating system environment attributes, such as memory allocated for data, memory allocated for statements, resources allocated for I/O, and other crucial performance-related parameters. Each version of Oracle continues to add to the total number of initialization parameters. Oracle 11g Release 2 now has 2394 (341 documented and 2053 hidden) initialization parameters (these numbers vary ...

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