If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
| Programing Book book office, office xp book, book systems, books systems, databases books, c++ study guide, c# certification, ... |
![]() |
|
||||
![]() Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase. Gavin Powell shows that the central theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit applications; tune SQL code according to both the data model and the application in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results. * Fully updated for version 10gR2 and provides all necessary transition material from version 9i * Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning * Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective http://rapidshare.com/files/45315203...n.Sep.2006.rar or http://www.megaupload.com/?d=K8QDO7X5
__________________
Manufactured Home Refinance | Download Free DVD Movies | Free Ebook Download | Progressive insurance |
![]() |
| Bookmarks |
| Tags |
| 10gr2, edition, oracle, performance, tuning |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| VTC - Oracle: Performance Tuning (1Z0-033) | camorani | Video Training | 0 | 07-18-2009 10:55 PM |
| [Rapidshare.com] High Performance Oracle Database Automation: Creating Oracle Applications with SQL and PL/SQL | FED | Technical Book | 0 | 04-15-2009 03:41 PM |
| Oracle Data Warehouse Tuning for 10g | FED | Technical Book | 0 | 01-17-2009 11:02 AM |
| Oracle Database 10g Performance Tuning Tips & Techniques | FED | Technical Book | 2 | 09-23-2008 09:54 AM |
| Oracle High Performance Tuning for 9i & 10g | abb | Programing Book | 0 | 06-04-2007 08:37 AM |