Oracle database problem solving and troubleshooting handbook
By: Farooq, Tariq
Title By: Ault, Mike | Portugal, Paulo | Houri, Mohamed | Hussain, Syed Jaffar | Czuprynski, Jim | Harrison, Guy
Material type: BookPublisher: Boston : Addison-Wesley, c2016.Description: xxx, 481 p. : ill. ; 23 cm.ISBN: 9780134429205Subject(s): Relational databases | SQL (Computer program language) | Oracle (Computer file)DDC classification: 005.75/65 Online resources: Location MapItem type | Home library | Call number | Status | Date due | Barcode | Item holds |
---|---|---|---|---|---|---|
REGULAR | University of Wollongong in Dubai Main Collection | 005.7565 FA OR (Browse shelf) | Available | T0036400 |
, Shelving location: Main Collection Close shelf browser
005.7565 BE MY MySQL high availability | 005.7565 DA MY MySQL stored routines : | 005.7565 DU FI FileMaker API for PHP 12 : | 005.7565 FA OR Oracle database problem solving and troubleshooting handbook | 005.7565 FE BE Beginning Oracle Database 11g administration : | 005.7565 HA OR Oracle application express for mobile web applications / | 005.7565 JE MI Microsoft Access 2010 in depth / |
Includes indexes.
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.