Oracle Database Troubleshooting
Oracle DatabaseProblem Solving andTroubleshootingHandbook
This page intentionally left blank
Oracle DatabaseProblem Solving andTroubleshootingHandbookTariq FarooqMike AultPaulo PortugalMohamed HouriSyed Jaffar HussainJim CzuprynskiGuy HarrisonBoston Columbus Indianapolis New York San Francisco Amsterdam Cape TownDubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico CitySão Paulo Sidney Hong Kong Seoul Singapore Taipei Tokyo
Many of the designations used by manufacturers and sellers to distinguish their products are claimed astrademarks. Where those designations appear in this book, and the publisher was aware of a trademark claim,the designations have been printed with initial capital letters or in all capitals.The authors and publisher have taken care in the preparation of this book, but make no expressed or impliedwarranty of any kind and assume no responsibility for errors or omissions. No liability is assumed for incidental or consequential damages in connection with or arising out of the use of the information or programscontained herein.For information about buying this title in bulk quantities, or for special sales opportunities (which may includeelectronic versions; custom cover designs; and content particular to your business, training goals, marketingfocus, or branding interests), please contact our corporate sales department at corpsales@pearsoned.com or(800) 382-3419.For government sales inquiries, please contact governmentsales@pearsoned.com.For questions about sales outside the U.S., please contact intlcs@pearson.com.Visit us on the Web: informit.com/awLibrary of Congress Cataloging-in-Publication DataNames: Farooq, Tariq, author.Title: Oracle database problem solving and troubleshooting handbook / TariqFarooq [and 6 others].Description: Boston : Addison-Wesley, [2016] Includes indexes.Identifiers: LCCN 2016005438 ISBN 9780134429205 (pbk. : alk. paper)Subjects: LCSH: Oracle (Computer file) Relational databases. SQL(Computer program language)Classification: LCC QA76.9.D3 F358 2016 DDC 005.75/65—dc23LC record available at http://lccn.loc.gov/2016005438Copyright 2016 Pearson Education, Inc.All rights reserved. Printed in the United States of America. This publication is protected by copyright, andpermission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrievalsystem, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise.For information regarding permissions, request forms and the appropriate contacts within the Pearson EducationGlobal Rights & Permissions Department, please visit www.pearsoned.com/permissions/.Figures 15.1, 15.2, 15.3, 15.4, 15.5, 15.6, 15.7, 15.14, 15.17, 16.1, 16.2, 16.6, and 16.7 from Farooq, Tariq; Kim,Charles; Vengurlekar, Nitin; Avantsa, Sridhar; Harrison, Guy; Hussain, Syed Jaffar; Oracle Exadata Expert’sHandbook, 1st Ed., 2016. Reprinted and electronically reproduced by permission of Pearson Education, Inc.,New York, NY.Various screen shots and illustrations of Oracle products are used with permission. Copyright 1995–2015Oracle and/or its affiliates. All rights reserved.ISBN-13: 978-0-13-442920-5ISBN-10: 0-13-442920-6Text printed in the United States on recycled paper at RR Donnelley in Crawfordsville, Indiana.First printing, April 2016
ContentsPrefacexixAcknowledgmentsxxiAbout the AuthorsxxvAbout the Technical Reviewers and ContributorsxxixChapter 1Troubleshooting and Tuning LOB Segment Performance1Introduction to the LOB Datatype1Fixing a LOB Problem: A Real-World Example2Another Real-World Example: HW Resolution4BASICFILE LOB Issues: Toward a More Perfect Fix8BASICFILE versus SECUREFILE LOBsLOB New and Old Type DifferencesMigrating BASICFILE LOBs to SECUREFILE LOBs8912The Impact of PCTFREE on LOBs14Overcoming Poor INSERT Performance17Summary17v
viChapter 2ContentsOvercoming Undo Tablespace Corruption19Overview of Undo Management19The Importance of UNDO RETENTION20Tuning UNDO RETENTION21DTP, XA, and Rollback SegmentsOther Unusual Rollback and Undo Segment IssuesRecovering from Undo Tablespace CorruptionChapter 32424Preventing, Detecting, and Repairing Corruption24Handling Memory Corruption26Handling Logical Corruption28Overcoming Media Corruption29Summary32Handling GC Buffer Busy Wait Events35Overview of Buffer Busy Wait Events35Leveraging the ORAchk Utility36Installing ORAchk37Results of ORAchk Execution: Sample Output38Isolating GC Buffer Busy Waits40Using ADDM to Find Event Information41Using AWR to Find Event Information41Using ASH to Find Event Information43Isolating GC Buffer Busy Wait Event IssuesChapter 42245Using ASH Views to Find Waiting Sessions45Quickly Isolating Performance Bottlenecks47Fixes for GC Buffer Busy Waits49Summary50Adaptive Cursor Sharing51ACS Working Algorithm52Bind Sensitiveness with Range Predicate52Bind Sensitiveness with Equality Predicate and Histogram55Bind Sensitiveness with Partition Keys56ACS in Action58
ContentsviiACS Bind-Awareness MonitoringChapter 5BUCKET ID and COUNT Relationship62Marking Cursors Bind Aware66The Bind-Aware Cursor73A Practical Case76Summary81Stabilizing Query Response Time Using SQLPlan Management83Getting Started83Creating a SQL Plan Baseline87Capturing Plans Automatically87Loading Plans from the Cursor Cache90Faking Baselines92Oracle Optimizer and SPM Interaction96When the CBO Plan Matches the SQL Plan Baseline96When the CBO Plan Doesn’t Match the SQL Plan Baseline99When SQL Plan Baseline Is Not ReproducibleSQL Plan Baseline ReproducibilityChapter 661104108Renaming the Index109Changing the Index Type111Adding Trailing Columns to the Index112Reversing the Index113NLS SORT and SQL Plan Baseline Reproducibility114ALL ROWS versus FIRST ROWS117Adaptive Cursor Sharing and SPM122ACS and SPM in Oracle 11g Release 11.2.0.3.0123ACS and SPM in Oracle Database 12c Release 12.1.0.1.0128Summary131DDL Optimization Tips, Techniques, and Tricks133DLL Optimization Concept133The DDL Optimization Mechanism136Table Cardinality Estimation137
viiiChapter 7ContentsC DDL Column in a Virtual Column139C DDL Column in a Column Group Extension140When the Default Value of C DDL Changes142C DDL Column and Indexes145DDL Optimization for NULL Columns147Summary152Managing, Optimizing, and Tuning VLDBs153Overview of Very Large Databases153Optimal Basic Configuration154Data Warehouse Template154Optimal Data Block Size155Bigfile Tablespaces156Adequate SGA and PGA157Temporary Tablespace Groups158Data Partitioning158Index Partitioning: Local versus Global159Data Compression159Table Compression160Heat Map and Automatic Data Optimization160Advanced Index Partition Compression162VLDB Performance Tuning Principles162Real-World Scenario162Limiting the Impact of Indexes on Data Loading164Maximizing Resource Utilization165Gathering Optimizer Statistics166Incremental Statistics Synopsis166Gathering Statistics Concurrently168Setting the ESTIMATE PERCENT Value170Backup and Recovery Best Practices170Exadata Solutions171Utilizing a Data Guard Environment172Summary172
ContentsChapter 8ixBest Practices for Backup and Recovery withRecovery Manager173A Perfect Backup and Recovery Plan173An Overview of RMAN174Tips for Database Backup Strategies175Full Backups and Incremental Backups176Compressed Backups176Incremental Backups177Faster Incremental Backups177Rewinding in Oracle Flashback Technology178Disk-Based Backup Solutions179Recover Forward Forever180Validating RMAN Backups186Backup Optimization and Tuning187Tuning Disk-Based Backup PerformanceChapter 9189Using RMAN for RAC Databases189Retaining Data in a Recovery Catalog191Having a Robust Recovery Strategy192Leveraging the Data Recovery Advisor193Summary194Database Forensics and Tuning Using AWR Analysis: Part I197What Is AWR?197Knowing What to Look For199Header Section199Load Profile201Instance Efficiencies202Shared Pool Memory203Wait Events203Load Average206Instance CPU207Memory Statistics207RAC-Specific PagesRAC Statistics (CPU)208208
xContentsGlobal Cache Load Statistics209Global Cache and Enqueue Services209Cluster Interconnects210Time Model Statistics211Operating System Statistics212Foreground Wait Events213Background Wait Events214Wait Event Histograms215Service-Related Statistics216The SQL Sections217Total Elapsed Time218Total CPU Time218Total Buffer Gets218Total Disk Reads219Total Executions219Parse Calls219Shareable Memory220Version Count220Cluster Wait Time220Instance Activity Statistics221Consistent Get Statistics224DB Block Get Statistics224Dirty Block Statistics224Enqueue Statistics224Execution Count225Free Buffer Statistics225Global Cache (GC) Statistics225Index Scan Statistics226Leaf Node Statistics226Open Cursors226Parse Statistics226Physical Read and Write Statistics227Recursive Statistics229
ContentsxiRedo-Related Statistics229Session Cursor Statistic229Sort Statistics230Summed Dirty Queue Length230Table Fetch Statistics230Transaction Rollback231Undo Change Vector Statistic231User Statistics232Work Area Statistics232Instance Activity Statistics—Absolute Values232Instance Activity Statistics—Thread Activity233SummaryChapter 10 Database Forensics and Tuning Using AWR Analysis: Part II233235Tablespace I/O Statistics235Buffer Pool Statistics237Buffer Pool Statistics238Instance Recovery Statistics239Buffer Pool Advisory Section239PGA Statistics240PGA Aggregate Summary241PGA Aggregate Target Statistics242PGA Aggregate Target Histogram242PGA Memory Advisor243Shared Pool Statistics244Other Advisories245SGA Target Advisory246Streams Pool Advisory246Java Pool Advisory247Buffer Waits Statistics247Enqueue Statistics248Undo Segment Statistics250Latch Statistics251Latch Activity253
xiiContentsLatch Sleep Breakdown253Latches and Spin Count254Latch Miss Sources254Mutex Sleep Summary255Parent and Child Latches255Segment Access Areas255Library Cache Activity Sections257Dynamic Memory Components Sections260Process Memory Sections262Process Memory Summary263SGA Memory Summary264SGA Breakdown Difference264Streams Component Sections264Resource Limits Statistics266Initialization Parameter Changes267Global Enqueue and Other RAC Sections268Global Enqueue Statistics271Global CR Served Statistics271Global Current Served Statistics271Global Cache Transfer Statistics271Global Cache Transfer Times272Global Cache Transfer (Immediate)272Global Cache Times (Immediate)272Interconnect Ping Latency Statistics272Interconnect Throughput by Client273Interconnect Device Statistics273SummaryChapter 11 Troubleshooting Problematic Scenarios in RACTroubleshooting and Tuning RAC273275276Start with ORAchk276Employ the TFA Collector Utility276Utilize the Automatic Diagnostic Repository276Check the Alert and Trace Log Files277
ContentsxiiiEmploy the Three A’s277Check the Private Cluster Interconnect277Enable Tracing and Inspect the Trace Logs278Utilize the Cluster Health Monitor278Miscellaneous Tools and Utilities278Useful My Oracle Support Resources278A Well-Oiled RAC Ecosystem279Maximum Availability Architecture279Optimal and Efficient Databases in RAC280Troubleshooting RAC with OEM 12c282Utilities and Commands for Troubleshooting283Summary288Chapter 12 Leveraging SQL Advisors to Analyze and Fix SQL Problems289OEM 12c—SQL Advisors Home290SQL Tuning Advisor290Running SQL Tuning Advisor in OEM 12c291Running SQL Tuning Advisor Manually in SQL*Plus294SQL Access Advisor295Running SQL Access Advisor in OEM 12c295Running SQL Access Advisor Manually in SQL*Plus298SQL Repair Advisor300SQL Performance Analyzer301Summary302Chapter 13 Extending Data Pump for Data and Object MigrationUsing Data Pump303303Copying Objects304Data Pump Modes305Working with Private and Public Objects306Saving and Restoring Database Links307Exporting Public Database Links and Synonyms307Verifying Content of the Export Dump File308Finding Valid INCLUDE and EXCLUDE Values309
xivContentsExporting Subsets of Data310Changing Object Properties313Importing Partitioned Tables as Nonpartitioned313Importing Table Partitions as Individual Tables313Masking Data314Renaming Tables or Different Tablespaces314Using Default Storage Parameters314Resizing Tablespaces during Import315Consolidating Multiple Tablespaces315Using PL/SQL API with Data Pump317Monitoring and Altering Resources319Improving Performance320Upgrading Databases321Summary322Chapter 14 Strategies for Migrating Data Quickly between Databases323Why Bother Migrating?324Determining the Best Strategy324Real-Time versus Near Real-Time Migration325Read-Only Tolerance325Reversibility325Considering What Data to Migrate326Data Migration Methods327Transactional Capture Migration Methods327Nontransactional Migration Methods330Piecemeal Migration Methods345SummaryChapter 15 Diagnosing and Recovering from TEMPFILE I/O IssuesOverview of Temporary Tablespaces352353353Read-Only Databases354Locally Managed Temporary Tablespaces354Temporary Tablespace Groups355Global Temporary Tables356
ContentsxvCorrecting TEMPFILE I/O Waits359Undersized PGA359Inappropriate TEMPFILE Extent Sizing364Inappropriate Use of GTTs364SummaryChapter 16 Dealing with Latch and Mutex ContentionOverview of Latch and Mutex Architecture365367367What Are Latches?368What Are Mutexes?370Latch and Mutex Internals370Measuring Latch and Mutex Contention371Identifying Individual Latches372Drilling into Segments and SQLs373Latch and Mutex Scenarios375Library Cache Mutex Waits375Library Cache Pin378Shared Pool Latch378Cache Buffers Chains Latch379Other Latch Scenarios381Intractable Latch Contention383Fine Tuning Latch AlgorithmsSummaryChapter 17 Using SSDs to Solve I/O BottlenecksDisk Technologies: SSD versus HDD383385387388The Rise of Solid-State Flash Disks389Flash SSD Latency389Economics of SSD390SLC, MLC, and TLC Disks391Write Performance and Endurance392Garbage Collection and Wear Leveling393SATA versus PCIe SSD395Using SSD Devices in an Oracle Database395
xviContentsThe Oracle Database Flash Cache395Free Buffer Waits396Configuring and Monitoring DBFC398Using the FLASH CACHE Clause399Flash Cache Performance Statistics400Comparing SSD Options402Indexed Reads403OLTP Read/Write Workload403Full Table Scan Performance404SSD Native Caches and Full Table Scans405Disk Sort and Hash Operations406Redo Log Optimization409Storage TieringUsing Partitions to Tier DataFlash and ExadataCreating Flash-Backed ASM Disk Groups on ExadataSummaryChapter 18 Designing and Monitoring Indexes forOptimal PerformanceTypes of Indexes410410414416418421421B-Tree Indexes422Bitmap Indexes425Partitioned Indexes427Other Index Types430Multiple Indexes on Identical Columns431Index Performance Issues432Index Statistics432The Impact of a Low Clustering Factor435Operational Considerations for Indexes436Hiding Unselective Indexes439Index Performance Issues in RAC Databases441Summary442
ContentsxviiChapter 19 Using SQLT to Boost Query Performance445Installing SQLT446Using the XTRACT Method447Using the XECUTE Method448Leveraging Other SQLT Methods451A Real-World Example452Summary453Chapter 20 Dealing with XA Distributed Transaction IssuesIndex455Repairing Common Distributed Transaction Issues456Repairing Ghost Distributed Transactions457Information Exists, but Transaction Missing457ORA-1591 Has No Corresponding Information458Transaction Hangs after COMMIT or ROLLBACK460Monitoring Distributed Transactions462Summary464465
This page intentionally left blank
PrefaceDatabase administrators’ lives are becoming more and more challenging, and arduous work conditions are fast becoming the norm. DBAs face problems that in somecases could lead organizations and entities to potentially lose millions of dollars perminute or, in worst-case scenarios, could bring a company’s database infrastructure to a grinding halt. Yes, such cases are unlikely to happen, but to avoid andavert them, DBAs had best be prepared.The guiding principle of this book is to show you how to fix, as rapidly as possible, serious database problems that can potentially impact the production-levelenvironment. It guides readers through the steps necessary to fix the problem athand by examining real-life examples that could happen any day at any time in anyOracle database.Instead of losing time trying to find the solution for a problem that is taking yourdatabase down or has already put it down, you can turn to this book for solutions tosome of the biggest problems you might face. Even if you do not find the solution foryour current problem here, you will learn how to quickly search for solutions on theInternet to solve your problem.The basic idea behind this book is to offer you light in the dark when you haveserious Oracle database problems in production environments. Along with generalbest practices, this book explores some of the top Oracle database problems andtheir rapid-fire solutions, explained in a simple and easy format.Targeted for Oracle DBAs and database machine administrators (DMAs),Oracle Database Problem Solving and Troubleshooting Handbook will serve as axix
xxPrefacepractical technical guide for performing day-to-day troubleshooting, tuning, andproblem-solving of administration operations and tasks within the Oracle DatabaseServer family.Authored by a world-renowned, veteran-author team of Oracle ACEs, ACE Directors,and Experts, this book is intended to be a problem-solving handbook with a blendof real-world, hands-on examples and troubleshooting of complex Oracle databasescenarios. This book shows you how to Choose the quickest path to solve large-impact problems Make your day more productive with reliable working techniques learnedfrom real field experts Construct your own 911 plan Perform routine proactive maintenance to ensure stability of yourenvironment Use industry standard best-practice tools and scripts to find the best andfastest solutionsIn this technical, everyday, hands-on, step-by-step book, the authors aim foran audience of intermediate-level, power, and expert users of the Oracle DatabaseServer family of products. This book covers both Oracle Database 11g and OracleDatabase 12c versions of the underlying Oracle database software.
AcknowledgmentsTariq FarooqI would like to express boundless thanks for all good things in my life to theAlmighty ALLAH, the lord of the worlds, the most gracious, the most merciful.I dedicate this book to my parents, Mr. and Mrs. Abdullah Farooq; my wonderfulwife, Ambreen; my awesome kids, Sumaiya, Hafsa, Fatima, and Muhammad-Talha;and my nephews Muhammad-Hamza, Muhammad-Saad, Muhammed-Muaz,Abdul-Karim, and Ibrahim, without whose perpetual support this book would nothave come to fruition. My endless gratitude to them as I dedicated almost two yearsof my spare time to this book, most of which was on airplanes and in late nightsand weekends at home.My heartfelt gratitude to my friends at the Oracle Technology Network (OTN),colleagues in the Oracle ACE fellowship, my coworkers, and everyone else in theOracle community, as well as in my workplace for standing behind me in my questto bring this project to completion, especially Dave Vitalo.I had been thinking about writing on the Oracle troubleshooting and problemsolving subject area for quite a while. The project was finally kick-started whenI met Paulo Portugal in San Francisco at Oracle Open World 2013. The one thingthat I am very proud of is the amazing ensemble of some of the best minds in theindustry, including Oracle ACEs, ACE directors, and Ph.D.s coauthoring and technically reviewing this book from start to finish.xxi
xxiiAcknowledgmentsFrom inception to writing to technical review to production, authoring a book isa complex, labor-intensive, lengthy, and at times painful process; this book wouldnot have been possible without the endless help and guidance of the awesome AddisonWesley team. A very special thanks goes out to Greg Doench, executive editor, andall the other folks at Addison-Wesley, who stood like a rock behind this project.Kudos to the technical reviewers, book reviewers, and editorial teams at AddisonWesley for a great job on this book.Many appreciative thanks to my buddies, coauthors, and technical reviewers—Paulo Portugal, Mohamed Houri, Mike Ault, Jim Czuprynski, Syed Jaffar Hussain,Kamran Agayev, Anju Garg, Bert Scalzo, and Guy Harrison—for the amazing teameffort that allowed us to bring this book to you, my dear reader. A special thanks tomy friend and fellow Oracle ACE Director Biju Thomas for authoring Chapter 13.Finally, I thank you, my dear reader, for joining us on this knowledge-ladenjourney—my sincerest hope is that you will learn from this book and that you willenjoy reading it as much as we did researching and authoring it.Mike AultI would like to acknowledge Texas Memory Systems (TMS) and IBM for allowingme the freedoms to continue writing and researching Oracle-related topics.Paulo PortugalI devoted a lot of time working on this book, and at that time my little princess wastoo young to understand my preoccupation with this project. I dedicate this book toher and to my lovely wife, who has always supported me at all times and occasions.Mohamed HouriThis book is dedicated to my parents; to my lovely daughters, Imane Sonia, Yasmine,and Selma; and to my family and friends.Syed Jaffar HussainI am thankful for everything in my life to the Almighty ALLAH, the lord of theworlds, the most gracious, the most merciful. I dedicate this book to my parents,Mr. and Mrs. Saifulla; my amazing wife, Ayesha; my wonderful children, Ashfaq,
AcknowledgmentsxxiiiArfan, and Aahil; my brothers Sadak, Sabdar, and Noor; and my friends and colleagues. A bundle of thanks to the Addison-Wesley team for their endless help andguidance on the book. Many appreciative thanks to my coauthors and technicalreviewers, Paulo Portugal, Mohamed Houri, Mike Ault, Jim Czuprynski, KamranAgayev, Anju Garg, Bert Scalzo, and Guy Harrison, for the amazing team effortthat allowed us to bring this book to you, my dear reader. A special thanks to myfriend and brother Tariq Farooq for inviting me to participate in this great project.Jim CzuprynskiI dedicate my part of this book to my dearest wife, Ruth—my helpmate, best friend,and companion for nearly four decades. Without her careful, loving guidance, proofreading skills, and infinite patience during my long nights of writing, editing, andmuttered expletives as I struggled to meet deadlines, it would have simply beenimpossible to complete my assignments.Guy HarrisonThanks to Tariq for giving me the opportunity to work with such a great groupof technical authors, thanks to Anju for providing excellent technical editing, andthanks to everyone at Addison-Wesley who worked on this project. Thanks as alwaysto my family for their love and support.Biju ThomasI am very honored and humbled to have been invited by Tariq to be part of thisoutstanding project along with highly respected and sought-after authors. My sincere thanks to Tariq and to all coauthors of this book. Thanks to Kamran for allthe valuable technical edits and suggestions. I appreciate all efforts by the AddisonWesley team to make sure the book maintains its quality in content, formatting, andappearance. I am grateful to the Oracle Technology Network (OTN) and OracleACE program for all the support. Last but not least, thanks to my family for alwaysstanding behind me with steadfast support and encouragement.
This page intentionally left blank
About the AuthorsTariq Farooq is an Oracle technologist, architect, and problemsolver and has been working with various Oracle technologies formore than 24 years in very complex environments at some of theworld’s largest organizations. Having presented at almost everymajor Oracle conference/event all over the world, Tariq is anaward-winning speaker, community leader/organizer, author, forumcontributor, and tech blogger. He is the founding president of theIOUG Virtualization & Cloud Computing Special Interest Group and the BrainSurface social network for the various Oracle communities. Tariq founded, organized,and chaired various Oracle conferences, including, among others, the OTN MiddleEast and North Africa (MENA) Tour, VirtaThon (the largest online-only conferencefor the various Oracle domains), the CloudaThon & RACaThon series of conferences,and the first-ever Oracle-centric conference at the Massachusetts Institute of Technology in 2011. He was the founder and anchor/show host of the VirtaThon InternetRadio series program. Tariq is an Oracle RAC Certified Expert and holds a total of 14professional Oracle certifications. Having authored more than one hundred articles,whitepapers, and other publications, Tariq is the coauthor of the Expert Oracle RAC 12c(Apress, 2013), Oracle Exadata Expert’s Handbook (Addison-Wesley, 2015), andBuilding Database Clouds in Oracle 12c (Addison-Wesley, forthcoming in 2016)Oracle books. Tariq has been awarded the Oracle ACE and ACE Director awards.xxv
xxviAbout the AuthorsMike Ault began working with computers in 1980—following a sixyear Navy enlistment in the Nuclear Navy riding submarines—programming in Basic and Fortran IV on the PDP-11 architecturein the nuclear industry. During Mike’s nuclear years, he workedwith PDP, IBM-PC, Osborne, and later VAX-VMS and HP architectures, as well as with the Informix and Ingres databases. Followingthe downturn in the nuclear industry, Mike began working withOracle as the only DBA at the Luka, Mississippi–based Advanced Solid RocketMotor (ASRM) project for NASA in 1990. Since 1990, Mike has worked with a varietyof industries using Oracle both in-house and as a consulting talent. Mike got extensiveFlash experience as the Oracle Guru for Texas Memory Systems. Mike transitionedto IBM as the Oracle Guru for the STG Flash group when IBM purchased TMS in2012. Mike has published over two dozen Oracle-related books, including the 7.0,8.0, 8i and 9i versions of his Oracle Administration and Management with Wiley,the “Oracle8 Black Book” and “Oracle DBA OCP Exam Cram” series (for versions 8and 8i) with Coriolis, and multiple titles including Oracle9i RAC and Oracle10gGrid & Real ApplicationClusters with Rampant Technical Press. Mike has writtenarticles for Oracle, Select, DBMS, Oracle Internals, and several other databaserelated magazines. Mike is also a highly sought-after keynote speaker and expertinstructor for local, regional, and international Oracle conferences, such as GOUSERS,SEOUG, RMOUG, NYOUG, NCOUG, IOUG, OOW, ODTUG, UKOUG, and EOUG.Paulo Portugal has more than fifteen years of IT experience asan Oracle DBA. He is an Oracle Certified Master 11g; an OracleCertified Professional (9i, 10g, 11g, and 12c); an Oracle RAC 10gand 11g Certified Specialist; an Oracle DBA 10g Certified LinuxAdministrator; Oracle Exadata Implementation Certified; IBMDB2 Certified (8 and 9 “Viper”); an Oracle GoldenGate 10 CertifiedImplementation Specialist; an Oracle Enterprise Manager CertifiedImplementation Specialist; and an Oracle 11i Applications Database AdministratorCertified Professional. Paulo is the author of the Rampant “Advanced DBMS Packages”and many articles in blogs and some magazines and websites. Paulo has maintained a regular presence on the Oracle conference and speaking circuit: OracleOpen World—San Francisco (2005, 2006, 2011, and 2013), IBM Information onDemand—Los Angeles (2006), Burleson Oracle RAC Cruise (2009), and OracleTraining in Reading—United Kingdom (2011). Currently, Paulo works as an Oraclesales consultant for Oracle Brazil. Paulo has participated in the Oracle Beta Test11i project using Data Guard and is a specialist in high availability tools such asOracle Data Guard, Oracle Streams, Oracle GoldenGate, and Oracle RAC.
About the AuthorsxxviiMohamed Houri has a Ph.D. in fluid mechanics (scientific computing) from the University of Aix–Marseille II, preceded by an engineerdiploma in aeronautics. He has been working around the Oracledatabase for more than fourteen years for different European customers as an independent Oracle consultant specializing in tuningand troubleshooting Oracle performance problems. Mohamed hasalso worked with the Naval Architect Society of Japan on the analysis of tsunamis and breaking waves using a powerful signal analysis called WaveletTransform. He maintains an Oracle blog and is active in the Oracle Worldwide forumand in the French equivalent. He tweets about Oracle topics at @MohamedHouri.Syed Jaffar Hussain is an Oracle Database expert with morethan twenty years of IT experience. He has been involved with several local and large-scale international banks where he designed,implemented, and managed highly complex cluster and Exadataenvironments with hundreds of business-critical databases. Oracleawarded him the prestigious Best DBA of the Year and Oracle ACEDirector status in 2011. He also acquired industry-best Oracle credentials, Oracle Certified Master (OCM), Oracle RAC Expert, OCP DBA 8i, 9i, 10g,and 11g, in addition to ITIL expertise. Syed is an active Oracle speaker who regularly presents technical sessions and webinars at many Oracle events. You can visithis technical blog at http://jaffardba.blogspot.com. In addition to being part of thecore technical review committee for Oracle technology–oriented books, he coauthoredOracle 11g R1/R2 Real Application Clusters Essentials (Packt Publishing, 2011),Expert Oracle RAC 12c (Apress, 2013), and Oracle Exadata Expert’s Handbook(Addison-Wesley, 2015).Jim Czuprynski is an Oracle ACE Director with more than thirtyfive years of experience in information technology, serving diverseroles at several Fortune 1000 companies in those three-plus decades—mainframe programmer, applications developer, business analyst,and project manager—before becoming an Oracle DBA in 2001.In his current role as a strategic solutions consultant for OnXEnterprise Solutions, he focuses on providing his expertise to
Recovery Manager 173 A Perfect Backup and Recovery Plan 173 An Overview of RMAN 174 Tips for Database Backup Strategies 175 Full Backups and Incremental Backups 176 Compressed Backups 176 Incremental Backups 177 Faster Incremental Backups 177 Rewinding in Oracle Flashback Technology 178 Disk-Based
viii Related Documentation The platform-specific documentation for Oracle Database 10g products includes the following manuals: Oracle Database - Oracle Database Release Notes for Linux Itanium - Oracle Database Installation Guide for Linux Itanium - Oracle Database Quick Installation Guide for Linux Itanium - Oracle Database Oracle Clusterware and Oracle Real Application Clusters
Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,
Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,
2 Installing Oracle Database and Creating a Database 2.1 Overview of Installing Oracle Database Software and Creating a Database 2-1 2.1.1 Checking Oracle Database Installation Prerequisites 2-2 2.1.2 Deciding on Oracle Database Installation Choices 2-3 2.1.2.1 Install Option for Oracle Database 2-3 2.1.2.2 Installation Class for Oracle .
Getting Started with Database Classic Cloud Service. About Oracle Database Classic Cloud Service1-1. About Database Classic Cloud Service Database Deployments1-2. Oracle Database Software Release1-3. Oracle Database Software Edition1-3. Oracle Database Type1-4. Computing Power1-5. Database Storage1-5. Automatic Backup Configuration1-6
Oracle Database using Oracle Real Application Clusters (Oracle RAC) and Oracle Resource Management provided the first consolidation platform optimized for Oracle Database and is the MAA best practice for Oracle Database 11g. Oracle RAC enables multiple Oracle databases to be easily consolidated onto a single Oracle RAC cluster.
Special-Use Licensing Oracle Audit Vault and Database Firewall is a stacked software application containing embedded components. Oracle Linux and Oracle Database 19c (19.0.0.0.0) . ODBEE is restricted to the following components: Oracle Database Partitioning, Oracle Advanced Security, Oracle Advanced 2. Compression, Oracle Database Vault, and .
For more information, see these Oracle resources: Oracle Database Backup and Recovery User's Guide Oracle Database Reference Oracle Database Utilities Many of the examples in this book use the sample schemas of the seed database, which is installed by default when you install Oracle. Refer to Oracle Database Sample Schemas
