神马文学网[Laskey99] Section 3.2. Achieving Maximum Performance
来源：百度文库 编辑：神马文学网 时间：2024/04/27 23:01:51
3.2.
Achieving maximum performance for your Oracle database doesn'tjust happen—it is usually the result of a lot of hard work,thought, and planning. The rewards, however, are well worth theeffort expended: your database runs at peak efficiency, your usersare happy, and you look good!
Our approach to maximizing performance is hierarchical in nature.Three distinct areas must be addressed, and they should be addressedin order. These areas are:
-
Operating system configuration
-
Oracle resource configuration
-
Object creation and SQL execution
These areas are not necessarily independent; in fact, significantchanges in one area are likely to require another look at the otherareas. They are, however, sequence dependent. That is, you cannothope to get good performance out of Oracle unless and until you haveproperly configured and tuned your operating system. Likewise, goodquery execution depends on a properly configured Oracle environment.
Every Oracle database is different, so we cannot tell you exactly howto accomplish your configuration and tuning goals, or even what thosegoals should be. What we can do is provide you with an approachwe've found to be successful.