Oracle High Performance Tuning for 9i and 10g by Gavin Powell
A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.
Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside independent blocks within applications or stored procedures.
Physical database tuning involves hardware resource usage, networking and various other Oracle things such as configuration and file distribution. Physical configuration is often a culprit of poor performance where Oracle is installed with defaults, and never altered by an expert.
*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
我在这里提供下载: 本地下载
Book Description
提供下载:
本地下载Book Description
Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. This is a must-have reference for all Oracle professionals.
我在这里提供下载:
本地下载Book Description
Interested in a career as an Oracle database professional but don't know where to begin? The Oracle9i OCA and OCP certifications are two of the hottest IT certifications around, and the Oracle9i DBA JumpStart from Sybex can provide you with the solid foundation in database administration and programming basics you'll need before embarking on a comprehensive study program. The JumpStart series was developed in response to requests from technical trainers seeking to ensure a level starting point for students in their classrooms. The author is an experienced Oracle instructor who provides simple, tangible explanations to make the world of databases accessible to newcomers to the IT field. You'll learn about relational database concepts, SQL*Plus or iSQL*Plus commands, sorting and reporting techniques, security, and much more. When you're done with this book, you'll be ready to face the challenges of Oracle9i certification preparation.
我在这里提供下载:
本地下载本文地址:http://com.8s8s.com/it/it20180.htm