TY  - BOOK
AU  - Farooq,Tariq
TI  - Oracle database problem solving and troubleshooting handbook
SN  - 9780134429205
U1  - REF 005.7565 FAR 23
PY  - 2016///]
CY  - Boston
PB  - Addison-Wesley
KW  - Oracle (Computer file)
KW  - fast
KW  - Relational databases
KW  - SQL (Computer program language)
KW  - Bases de donn�ees relationnelles
KW  - SQL (Langage de programmation)
KW  - sears
N1  - 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
N2  - 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
ER  -