Modelling Parallel Oracle for Performance Prediction
Distributed and Parallel Databases
On the Importance of Tuning in Incremental View Maintenance: An Experience Case Study
DaWaK 2000 Proceedings of the Second International Conference on Data Warehousing and Knowledge Discovery
| Hi-index | 0.00 |
From the Publisher: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. O'Reilly is the alternative for Oracle people who need to solve problems -- and solve them now.Performance tuning is crucial in any modern relational databasemanagement system. Too many organizations respond to Oracleperformance problems by throwing money at these problems -- bybuying larger and more expensive computers or by hiring expertconsultants. But there's a lot you can do on your own to increasedramatically the performance of your existing system. Whateverversion of Oracle you're running -- from Version 6 to Oracle8,proper tuning can save your organization a huge amount of money in additional equipment, extra memory, and hardware upgrades.The first edition of Oracle Performance Tuning became aclassic for programmers, managers, database administrators, system administrators, and anyone who cares about improving the performance of an Oracle system. This second edition contains 400 pages of updatedmaterial updating on Oracle features, incorporating advice about disk striping and mirroring, RAID, client-server, distributed databases, MPPS, SMPs, and other architectures. It also includes chapters on parallel server, parallel query, backup and recovery, the Oracle Performance Pack, and more.The book comes with a PC diskette containing all of the SQL and shell scripts described in the book, as well as additional tuning scripts that can help monitor and improve performance at your site.