Farooq, Tariq <br/><br/>
Oracle database problem solving and troubleshooting handbook 
Tariq Farooq... [et.al]. 
 - Boston :  Addison-Wesley,  c2016. 
 - xxx, 481 p. :  ill. ;  23 cm. 
<br/><br/> Includes indexes. 
<br/><br/>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. 
<br/><br/><label>ISBN: </label>9780134429205 
<br/><br/><label>Subjects--Topical Terms: </label><br/>Relational databases<br/>SQL (Computer program language)<br/>Oracle (Computer file)
<br/><br/><label>Dewey Class. No.: </label>005.75/65