Book Description
There 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.

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 Info
Text covers the three parts of tuning an Oracle database: data modeling, SQL code tuning, and physical database configuration. Softcover.

add to del.icio.us                 Digg Freebookzone.com!

You may use anyone of the download options

eBook Version	Buy this book from Amazon

Missing Link?, Report It and you may wish to  Buy  this book from amazon



Similar Book titles in DB -> Oracle section:
High Performance Oracle Database Applications
Teach Yourself Oracle 8 In 21 Days
Oracle Unleashed
Oracle Performance Tuning and Optimization
Using Oracle8
Oracle8 SQL reference: Release 8.0
Oracle8 Replication Release 8.0
Oracle8 Tuning Release 8.0
Oracle8 Backup and Recovery Guide
Oracle8 Administrator's Guide Release 8.0
Oracle8 Distributed Database Systems Release 8.0
Working with Oracle Cartridges
Special Edition Using Oracle Web Application Server 3
Oracle Programming with Visual Basic
Oracle Data Warehousing Unleashed
Oracle Database Construction Kit
Oracle8 How-To: The Definitive Oracle8 Problem-Solver
Oracle 8 Server Unleashed
Oracle8 Black Book: The Oracle Professional's Guide to Implementing the Object-Oriented Features of Oracle8
High Performance Oracle Database Automation: Creating Oracle Applications with SQL and PL/SQL
Developing Client/Server Applications With Oracle Developer/2000
Developing Personal Oracle 7 for Windows 95 Applications
Oracle PL/SQL CD Bookshelf
Oracle PL/SQL Programming, 2nd Edition
Oracle PL/SQL Programming: Guide to Oracle8i Features
Advanced Oracle PL/SQL Programming with Packages (Nutshell Handbook)
Oracle Web Applications : PL/SQL Developer's Intro
Oracle PL/SQL Built-ins Pocket Reference
Oracle Database 10g - DBA
Oracle Database 10g New Features
Oreilly Oracle Essentials Oracle Database 10g 3rd Edition
Oracle Database 10g OCP Certification All-In-One Exam Guide
OCA: Oracle 10g Administration Study Guide


Similar Book titles in Other sections:

Section: CS -> Theory
Quantitative System Performance - Computer System Analysis Using Queueing Network Models


Section: DB -> DB / 2
Oracle to DB2 UDB Conversion Guide
DB2 UDB/WebSphere Performance Tuning Guide


Section: DB -> Others
Database Performance Tuning on AIX
SQL Server 2000 High Availability


Section: Logic Design and Architecture
High Voltage Solid-State Circuits for Tube Guitar Amplifiers


Section: Microprocessor
A DSP Architecture for Power-Efficient Performance


Section: Peripherals
8237A High Performance Programmable DMA Controller


Section: Internet
Web Performance Tuning


Section: Advanced Java
Java Platform Performance: Strategies and Tactics


Section: Mathematics
High-Fidelity Multichannel Audio Coding


Section: Sales, Marketing & Trading
Successful Marketing Strategy for High Tech Firms


Section: Networking
Traffic Management for High-Speed Networks
High-Performance Networking Unleashed


Section: Novels
The 7 Seven Habits of Highly Effective People


Section: Physics
Frontiers in High Energy Density Physics: The X-Games of Contemporary Science


Section: Assembly Language
High Level Assembly Language (HLA)
Art of Assembly language (High Level Assembler)


Section: Other Programming
GNU Octave: A high-level interactive language for numerical computations


Section: Redbooks Draft
Using DCSS/XIP with Oracle 10g on Linux for System z
A Deep Blue View of DB2 Performance: IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS
WebSphere Replication Server Using Q Replication: High Availability Scenarios for the AIX Platform
SQL Performance Diagnosis on DB2 UDB for iSeries
Monitoring WebSphere Application Performance on z/OS
Show all..


Section: Redbooks
DS4000 Best Practices and Performance Tuning Guide
Architecting High Availability Using WebSphere V6 on z/OS
DB2 Performance Expert for Multiplatforms V2.2
SQL Performance Diagnosis on IBM DB2 Universal Database for iSeries
WebSphere Replication Server Using Q Replication High Availability Scenarios for the AIX Platform
Show all..


Section: IBM Technotes
Content Manager Server Log Utilities for Performance-Related Troubleshooting and Analysis


Section: Redpapers
Veritas Storage Foundation for Oracle 9i RAC and DB2 UDB V8 on IBM eServer pSeries
HMC High Availability for i5 and p5 Servers
How does the MIDAW facility improve the performance of FICON channels using DB2 and other workloads?
Domino 7 Performance Tuning Best Practices to Get the Most Out of Your Domino Infrastructure
WebSphere Business Integration V6 Performance Tuning
Show all..


Section: Redpapers Draft
Domino 7 Performance Tuning - Best Practices to Get the Most Out of Your Domino Infrastructure
Veritas Storage Foundation for Oracle 9i RAC and DB2 UDB V8 on IBM pSeries
WebSphere Process Server V6 Performance Tuning
Domino 7 on Linux for IBM System z: Capacity Planning and Performance Updates
Configuring WebSphere Process Server 6.1 with an Oracle Database
Show all..


Section: Software Engineering
Professional Software Development: Shorter Schedules, Higher Quality Products, More Successful Projects, Enhanced Careers
Free For All: How Linux and the Free Software Movement Undercut the High-Tech Titans
Improving .NET Application Performance and Scalability


Similar Books from Amazon :