Classic Oracle Book:
Oracle High Performance Tuning for 9i and 10g
By Gavin Powell
Book DescriptionThere are three parts to tuning an Oracle database:... Data modeling, SQL code tuning and physical database configuration 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.
Paperback: 544 pages; Dimensions (in inches): 1.38 x 9.22 x 7.08 Publisher: Digital Press; (December 8, 2003) ISBN: 1555583059 Average Customer Review: Based on 4 reviews 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 * Emphases Developments Offment As Opposed to Operating System Per Spective I am offering download: Local download
Oracle Essentials, 3e: Oracle Database 10g By
Rick Greenwald, Robert Stackowiak, Jonathan SternBook DescriptionThe new edition of this classic book, Oracle Essentials, 3rd Edition:. Oracle Database 10g, distills a vast amount of knowledge into an easy-to-read volume covering every aspect of the Oracle database Readers of all levels will learn about Oracle's features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning, and much more. Featuring focused text, abundant illustrations, and helpful hints, the new edition offers a valuable overview of Oracle's Database 10g --The Industry's First Database to Support Grid Computing.
Paperback: 400 pages; Dimensions (in inches): 0.98 x 9.18 x 7.08 Publisher: O'Reilly; 1 edition (February 11, 2004) ISBN:. 0596005857 Average Customer Review: Based on 2 reviews Recent releases such as Oracle 9i and 8i are also covered. More comprehensible than a large reference, and more detailed than mot primers, this book covers all the information you'll need to install and run the Oracle databases, as well as the conceptual background you'll want to understand how they Work. if you're new to oracle or Upgrading to Oracle 10g, You'll Find this all-in-one guide essential. Provides download: Local Download
Oracle9i: The Complete Reference By
Kevin Loney, George Koch
From Oracle8 to Oracle9i, this book has been a good one Desk Reference beginners. Book DescriptionMaster 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.
Paperback: 1256 pages; Dimensions (in inches): 2.42 x 9.10 x 7.34 Publisher: McGraw-Hill Osborne Media; 1 edition (August 16, 2002) ISBN: 0072225211 Average Customer Review: Based on 7 reviews I am available for download here: Local download Oracle9i DBA JumpStart
By Bob Bryla
Book DescriptionInterested in a career as an Oracle database professional but do not 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.
Paperback: 400 Pages; Dimensions: 0.78 x 9.16 x 7.40 Publisher: Sybex Books; 1 Edition (March 4, 2003) ISBN: 0782141897 I am available here: Local Download
