The books in O'Reilly's Oracle series are authoritative -- they tell the whole story about complex topics, ranging from performance tuning to the use of packages in PL/SQL to new technologies like Power Objects. And they're independent; they're alternatives for readers who need to know how products and features really work. They're packed with real-world advice and techniques from practitioners in the field, and they come with disks containing code you can use immediately in your own applications.
Oracle Disk I/O Tuning: Disk I/O Performance & Optimization for Oracle Databases (Oracle In-Focus series)
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.
Your Oracle career starts here! Ideal for those new to Oracle technology, this officially authorized guide teaches new DBAs the essentials of keeping an Oracle database running at top performance. You’ll get coverage of application, instance, database, I/O, OS, and contention tuning.
Exclusively from Oracle Press
The definitive guide to Oracle performance tuning has been fully expanded to cover every aspect of Oracle Database 10g. This comprehensive resource contains everything database administrators and developers need to know to keep Oracle Database 10g performing at its peak. Real-world case studies and in-depth examples illustrate best practices and highlight the latest tuning options.