Tuning Oracle
Once the system has been appropriately configured (see Chapters 13 through 17, and especially the data layout recommendations in Chapter 17), it is appropriate to find out if Oracle is properly configured. Oracle tuning is carried out with init.ora parameters, of which there are many; we focus on the most important parameters.
Tuning init.ora
When Oracle is installed, the init.ora file assumes a “small model” with just 400 Kbytes set aside for database buffers. For many end-user sites, several init.ora parameters will need to be changed in order for Oracle to work effectively.
A number of general tunable parameters unrelated to performance need to be assigned values large enough to support the required number of users and transactions: ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
