Oracle High Performance Tuning for 9i and 10g by Gavin JT Powell

By Gavin JT Powell

There are 3 elements to tuning an Oracle database: information modeling, SQL code tuning and actual database configuration. a knowledge version comprises tables and relationships among tables. Tuning a knowledge version contains normalization and de-normalization. diversified ways are required reckoning on the applying, equivalent to OLTP or a knowledge Warehouse. beside the point database layout could make SQL code most unlikely to song. negative facts modeling may have a so much profound impression on database functionality considering that all SQL code is made out of the knowledge version. Poorly written SQL code is usually a perpetrator of functionality difficulties and is dear to rectify. besides the fact that, tuning of SQL code is mostly more affordable than altering the information version. SQL code has a tendency to be contained inside of self sustaining blocks inside of functions or saved methods. actual database tuning consists of source utilization, networking and numerous different Oracle issues comparable to configuration and dossier distribution. actual configuration is usually a wrongdoer of negative functionality the place Oracle is put in with defaults, and not altered by way of knowledgeable. *Includes all 3 points of Oracle database tuning: information version tuning, SQL & PL/SQL code tuning, actual plus configuration tuning *Contains skilled information and real-world examples utilizing huge datasets *Emphasizes improvement in preference to working procedure viewpoint

Show description

Read or Download Oracle High Performance Tuning for 9i and 10g PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication permit real-time details entry and information sharing throughout your allotted framework utilizing the specialist info during this Oracle Press advisor. Oracle Streams 11g info Replication explains tips to manage and administer a unified firm info sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle software convey four Recipes presents an example-based method of studying software exhibit - the ground-breaking, fast program improvement platform incorporated with each Oracle Database license. The recipes structure is perfect for the quick-study who simply desires an outstanding instance or to kick commence their considering and get pointed within the correct course.

Additional resources for Oracle High Performance Tuning for 9i and 10g

Sample text

PL/SQL can be used to store database SQL code in one place. This has the effect of only allowing people with PL/SQL and Oracle database administration skills to build and change that code. However, since PL/SQL is essentially primitive as a programming language and developers make better programmers than database administrators, there is a strong case for minimizing use of PL/SQL. Do not write your entire system using PL/SQL. When using PL/SQL to create database access SQL code think rather in terms of granularity, simple maintenance, and central control as good reasons for using PL/SQL.

It can sometimes be better to resolve these joins in the application to improve database performance, and not create new entities at all. 5: 3rd Normal Form Tip Be very careful using 3rd Normal Form and beyond. 6. Notice how the containment of both students within courses and courses within students is provided by the application of 3rd Normal Form. The question you should ask yourself when using 3rd Normal Forms is this: Does your application need both these one-to-many relationships? If not then do not create the new entity because more entities lead to more complex joins and thus slower SQL statements.

Day Day Up > < Day Day Up > Chapter 2: Tuning the Relational Database Model So how do we go about tuning a relational database model? 1 Normalization and Tuning What does Normalization have to do with tuning? There are a few simple guidelines to follow and things to watch out for: Too little Normalization leads to too much duplication of data and thus your database will get too big. Too much data will lead to slow access times due to having too much disk space to search through. Incorrect Normalization should be obvious: convoluted and complex application code with nowhere to go but a rewrite or the garbage pile, the final resting place of many failed commercial applications.

Download PDF sample

Rated 4.12 of 5 – based on 37 votes