Database Reference
In-Depth Information
Conclusion
In this chapter, we discussed the basic elements of tuning a SQL query. Query optimization is very critical for the
optimal performance of the database. There was one incident when a customer decided to move his database to a
RAC configuration because his single-instance Oracle database was maxed out on CPU every time. The customer
expected that moving to a two-node RAC solution would buy him twice the amount of CPUs; unfortunately, it was a
few SQL statements that were very poorly written that always caused the server to be consuming high CPU resources.
In fact, moving to the RAC cluster made the situation even worse: all servers in his cluster maxed out on CPU
resources. The end result was to tune the SQL queries to allow the application scale.
Writing efficient SQL statements and tuning the inefficient SQL statements using several of the methods
discussed in this chapter is critical for the optimal performance of the RAC environment. No amount of resources can
help do the magic to fix inefficient SQL statements.
Search WWH ::
Custom Search