Oracle SQL Tuning & CBO Internals

Oracle SQL Tuning & CBO Internals

4.11 - 1251 ratings - Source



As Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time, this booka€™s timing is critical as tuning Oracle SQL has become the single most important skill of the Oracle professional. While not appropriate for the beginner, this book allows senior Oracle professionals to explore important internal mechanisms within Oracle and the powerful and complex internals of Oracle SQL execution. Topics include the internals of Oracle cost-based SQL optimizer, SQL execution internals within the library cache, Oracle SQL coding and optimization techniques, and Oracle index internals. Also included is a ready-to-use code depot full of working SQL tuning scripts, which allow for quick optimization of the SQL and indexes inside the Oracle database.DBAs who become familiar with these new views can greatly increase their SQL troubleshooting abilities and accelerate the process of making things right in their database. But, what can you do from the perspective of the code? Once youanbsp;...


Title:Oracle SQL Tuning & CBO Internals
Author: Kimberly Floss
Publisher:Rampant TechPress - 2004
ISBN-13:

You must register with us as either a Registered User before you can Download this Book. You'll be greeted by a simple sign-up page.

Once you have finished the sign-up process, you will be redirected to your download Book page.

How it works:
  • 1. Register a free 1 month Trial Account.
  • 2. Download as many books as you like (Personal use)
  • 3. Cancel the membership at any time if not satisfied.


Click button below to register and download Ebook
Privacy Policy | Contact | DMCA