Oracle database problem solving and troubleshooting handbook /
Farooq, Tariq,
Oracle database problem solving and troubleshooting handbook / Tariq Farooq [and 6 others]. - xxx, 481 pages : illustrations ; 23 cm
Includes index.
Troubleshooting and tuning LOB segment performance -- Overcoming UNDO tablespace corruption -- Handling GC buffer busy wait events -- Adaptive cursor sharing -- Stabilizing query response time using SQL plan management -- DDL optimization tips, techniques, and tricks -- Managing, optimizing, and tuning VLDBs -- Best practices for backup and recovery with recovery manager -- Database forensics and tuning using AWR analysis -- part I -- Database forensics and tuning using AWR analysis -- part II -- Troubleshooting problematic scenarios in RAC -- Leveraging SQL advisors to analyze and fix SQL problems -- Extending data pump for data and object migration -- Strategies for migrating data quickly between databases -- Diagnosing and recovering from TEMPFILE I/O issues -- Dealing with Latch and Mutex contention -- Using SSDs to solve IO bottlenecks -- Designing and monitoring indexes for optimal performance -- Using SQLT to boost query performance -- Dealing with XA distributed transaction issues.
Oracle Database Problem Solving and Troubleshooting Handbook delivers comprehensive, practical, and up-to-date advice for running the Oracle Database reliably and efficiently in complex production environments. Seven leading Oracle experts have brought together an unmatched collection of proven solutions, hands-on examples, and step-by-step tips for Oracle Database 12c, 11g, and other recent versions of Oracle Database. Every solution is crafted to help experienced Oracle DBAs and DMAs understand and fix serious problems as rapidly as possible. The authors cover LOB segments, UNDO tablespaces, high GC buffer wait events, poor query response times, latch contention, indexing, XA distributed transactions, RMAN backup/recovery, and much more. They also offer in-depth coverage of a wide range of topics, including DDL optimization, VLDB tuning, database forensics, adaptive cursor sharing, data pumps, data migration, SSDs, indexes, and how to go about fixing Oracle RAC problems. -- Provided by publisher.
9780134429205 0134429206
Prentice Hall, C/O Pearson Education Order Dept 135 S Mount Zion rd, Lebanon, IN, USA, 46052 SAN 200-2175
2016005438
GBB644712 bnb
017793282 Uk
Oracle (Computer file)
Oracle (Computer file)
Relational databases.
SQL (Computer program language)
Bases de donn�ees relationnelles.
SQL (Langage de programmation)
Relational databases.
SQL (Computer program language)
Oracle (Computer file)
REF 005.7565 FAR
Oracle database problem solving and troubleshooting handbook / Tariq Farooq [and 6 others]. - xxx, 481 pages : illustrations ; 23 cm
Includes index.
Troubleshooting and tuning LOB segment performance -- Overcoming UNDO tablespace corruption -- Handling GC buffer busy wait events -- Adaptive cursor sharing -- Stabilizing query response time using SQL plan management -- DDL optimization tips, techniques, and tricks -- Managing, optimizing, and tuning VLDBs -- Best practices for backup and recovery with recovery manager -- Database forensics and tuning using AWR analysis -- part I -- Database forensics and tuning using AWR analysis -- part II -- Troubleshooting problematic scenarios in RAC -- Leveraging SQL advisors to analyze and fix SQL problems -- Extending data pump for data and object migration -- Strategies for migrating data quickly between databases -- Diagnosing and recovering from TEMPFILE I/O issues -- Dealing with Latch and Mutex contention -- Using SSDs to solve IO bottlenecks -- Designing and monitoring indexes for optimal performance -- Using SQLT to boost query performance -- Dealing with XA distributed transaction issues.
Oracle Database Problem Solving and Troubleshooting Handbook delivers comprehensive, practical, and up-to-date advice for running the Oracle Database reliably and efficiently in complex production environments. Seven leading Oracle experts have brought together an unmatched collection of proven solutions, hands-on examples, and step-by-step tips for Oracle Database 12c, 11g, and other recent versions of Oracle Database. Every solution is crafted to help experienced Oracle DBAs and DMAs understand and fix serious problems as rapidly as possible. The authors cover LOB segments, UNDO tablespaces, high GC buffer wait events, poor query response times, latch contention, indexing, XA distributed transactions, RMAN backup/recovery, and much more. They also offer in-depth coverage of a wide range of topics, including DDL optimization, VLDB tuning, database forensics, adaptive cursor sharing, data pumps, data migration, SSDs, indexes, and how to go about fixing Oracle RAC problems. -- Provided by publisher.
9780134429205 0134429206
Prentice Hall, C/O Pearson Education Order Dept 135 S Mount Zion rd, Lebanon, IN, USA, 46052 SAN 200-2175
2016005438
GBB644712 bnb
017793282 Uk
Oracle (Computer file)
Oracle (Computer file)
Relational databases.
SQL (Computer program language)
Bases de donn�ees relationnelles.
SQL (Langage de programmation)
Relational databases.
SQL (Computer program language)
Oracle (Computer file)
REF 005.7565 FAR