Ideal for Oracle database programmers and administrators using the UNIX platform.
Shows readers how to optimize the performance of an Oracle8i database (the latest version of Oracle's world-leading database) running on any UNIX system. It focuses on real world problems encountered by database administrators and shows them how to optimize performance for OLTP and DSS applications. Most importantly, the book not only covers the traditional client/server issues relating to performance tuning, but also the new Internet focus of the latest release of the database.
Achieve breakthrough Oracle 8/8i performance!
- Optimize Web-centered enterprise applications
- Maximize OLTP and OLAP/DSS performance and scalability
- Tune UNIX, eliminate SQL bottlenecks, and master Oracle 8/8i's latest performance enhancements
Maximize performance: Tune Oracle8i and UNIX together!
Now, the #1 guide to Oracle tuning on UNIX platforms has been thoroughly updated for Oracle 8i! Oracle Senior Performance Engineer Ahmed Alomari covers every relevant optimization technique for every leading application and approach, including Web-centered development, OLTP, OLAP/DSS, and object-relational database systems.
Alomari covers the entire system lifecycle, showing how to achieve breakthrough performance by tuning both Oracle 8i and your underlying UNIX platform. Coverage includes:
- Choosing Oracle 8/8i and UNIX installation options that maximize performance
- Optimizing the UNIX kernel, memory, processors and I/O for your application
- Partitioning, star queries, and parallel DML
- Connection Manager, connection pooling, and multiple buffer pools
- Parallel query enhancements, I/O slaves, and multiple DBWR processes
- Oracle 8/8i optimizer and PRO*C enhancements
- Expert techniques for eliminating SQL bottlenecks
- State-of-the-art database performance benchmarking
- Specific solutions for Solaris, HP-UX, and Sequent
No matter how long you've been running Oracle and UNIX, you'll run them faster―and smarter―with Oracle8i & UNIX Performance Tuning!