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

CHAPTER

4

Tuning the Database with Initialization Parameters (DBA)

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 has added to the total number of initialization parameters, and Oracle 12c is no exception, having added many new parameters, especially related to the In-Memory Database. Oracle 12c Release 2 now has 4649 initialization parameters (412 documented and 4237 hidden). Note that these ...

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