Implement Proven Database Optimization Solutions Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 11g Release 2 Performance Tuning Tips a Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to find and fix bottlenecks, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide. Properly index and partition Oracle Database 11g Release 2 Work with Oracle Exadata and Oracle Exalogic Elastic Cloud Efficiently manage disk drives, RAID arrays, and memory Tune queries with Oracle SQL hints and the TRACE utility Troubleshoot databases using V$ views and X$ tables Distribute workload using Oracle Real Application Testing Generate reports using Oracle's Statspack and Automatic Workload Repository tools Use sar, vmstat, and iostat to monitor system statistics aThis is a timely update of Richas classic book on Oracle Database performance tuning to cover hot new topics like Oracle Database 11g Release 2 and Oracle Exadata. This is a must-have for DBAs moving to these new products.a --Andrew Mendelsohn, Senior Vice President, Oracle Database Server TechnologiesIn Oracle Database 11g, RMAN offers another algorithm, ZLIB, in addition to the previously available BZIP2. ... has added a great capability to duplicate a database without using or having to use an existing RMAN backup or manual file copy.
|Title||:||Oracle Database 11g Release 2 Performance Tuning Tips & Techniques|
|Publisher||:||McGraw Hill Professional - 2012-03-22|