Sumário Itens Encontrados: 274Summary 422Detecting and Resolving Lock Conflicts 419Maximizing Data Concurrency 417Understanding Locks and Transactions 416Monitoring Locking and Resolving Lock Conflicts 416Monitoring,Configuring,and Administering Undo 407Using Undo Data 405Understanding Undo Segments 403Leveraging Undo Management 402Chapter 8 Managing Consistency and Concurrency 401Answers to Review Questions 399Review Questions 395Exam Essentials 394Summary 393Specifying Control File Options 390Specifying SQL*Loader Command-Line Parameters 389Loading Data with SQL*Loader 388Monitoring the Progress of a Data Pump Job 388Using Data Pump to Import Data 381Using Data Pump to Export Data 375Data Pump Overview 374Creating Directory Objects 374Configuring PL/SQL for Better Performance 373Using and Administering PL/SQL Programs 371Working with Triggering Events and Managing Triggers 367Working with Packages 365Working with Procedures 365Working with Functions 363Identifying PL/SQL Objects 363Statements 362DELETEUsingStatements 361UPDATEStatements 358INSERTManipulating Data through SQL 358Chapter 7 Managing Data with SQL,PL/SQL,and Utilities 357Answers to Review Questions 355Review Questions 351Exam Essentials 349Summary 349Managing Fine-Grained Auditing 346Purging the Audit Trail 345Managing Object Auditing 344Managing Privilege Auditing 343Managing Statement Auditing 338Auditing Database Activity 336Implementing Standard Password Security Features 334Managing Default User Accounts 333Applying the Principle of Least Privilege 331Assigning Resource Limits with a Profile 328Assigning Tablespace Quotas 328Controlling Resource Usage by Users 327Role Privileges 324Granting System Privileges 318Granting Object Privileges 314Granting and Revoking Privileges 314Removing a User from the Database 314Assigning a Profile to a User 313Assigning a Temporary Tablespace 312Assigning a Default Tablespace 312Configuring Authentication 310Creating and Managing User Accounts 310Chapter 6 User Administration and Security 309Answers to Review Questions 306Review Questions 302Exam Essentials 301Summary 300Determining Whether You Have Enough Shared Servers 299Measuring How Long Users Are Waiting for Dispatchers 298Determining Whether You Have Enough Dispatchers 297Sizing the Large Pool 296Configuring the Large Pool 296Tuning the Shared Server Option 295Shared Server Environment 294Requesting a Dedicated Connection in aUsing Dynamic Performance Views for Shared Server 289Connections Using the Listener Utility 288Displaying Information about Shared ServerManaging Shared Server 288Configuring Shared Server Using Enterprise Manager 285Configuring Shared Server at Database Creation 283Defining the Shared Server Parameters 277Configuring the Oracle Shared Server 276Server Environment 276The Role of the Listener in an Oracle SharedShared Server 274PGA and SGA Changes When Using OracleOracle Shared Server Infrastructure 274Advantages and Disadvantages of Shared Server 273Dedicated Server versus Shared Server 271An Overview of Oracle Shared Server 270Chapter 5 Oracle Shared Server 269Answers to Review Questions 267Review Questions 263Exam Essentials 260Summary 259Troubleshooting Client-Side Connection Problems 254The Localnaming Method 246The Oracle Easy Connect Naming Method 244The Hostnaming Method 239Client-Side Names Resolution Options 238Configuring Oracle Net for the Client 238Oracle Net Logging and Tracing on the Server 233Troubleshooting Server-Side Connection Problems 227Additional Configurations When Using Multiple Listeners 225Dynamically Registering Services 224Managing Oracle Listeners 203Understanding the Oracle Listener 199Configuring Oracle Net on the Server 198Accessibility 197Security 196Scalability 194Manageability 193Connectivity 192An Overview of Oracle Net Features 191N-Tier Architecture 190Two-Tier Architecture 190Single-Tier Architecture 189Network Configurations 189Network Responsibilities for the DBA 188Interfacing Existing Systems with New Systems 188Network Security Issues 187Network Complexity Issues 186Network Design Considerations 186Chapter 4 Oracle Net Services 185Answers to Review Questions 182Review Questions 178Exam Essentials 176Summary 176Working with Sequences 175Working with Views 174Working with Indexes 172Working with Constraints 165Creating Tables 158Specifying Datatypes 152Working with Schema Objects 152Managing Datafiles 151Obtaining Tablespace Information 145Creating and Maintaining Tablespaces 138Identifying Default Tablespaces 137Managing Tablespaces 136Identifying Segments,Extents,and Data Blocks 136Chapter 3 Database Storage and Schema Objects 135Answers to Review Questions 133Review Questions 129Exam Essentials 127Summary 125Monitoring the Database Alert Log 122Shutting Down Oracle Using SQL*Plus 122Shutting Down Oracle Using EM Database Control 118Database 117Shutting Down an Oracle 10 gDatabase Startup 111Oracle 10 gStarting Up and Shutting Down an Oracle Database 111Managing Parameter Initialization Files 109Managing Database Templates Using DBCA 107Deleting an Oracle Database Using DBCA 106Configuring an Oracle Database Using DBCA 106Creating an Oracle Database Using the DBCA 84Using the Oracle Database Configuration Assistant 84Using SQL*Plus 80Accessing a Database Using the Database Control 80Starting and Stopping the Oracle Management Agent 78The Oracle Enterprise Management Framework 76Chapter 2 Creating and Controlling a Database 75Answers to Review Questions 72Review Questions 68Exam Essentials 66Summary 65Using the Oracle Universal Installer 56Plan Your Install 49Review the System Requirements 48Review the Documentation 48Installing Oracle 10g 48The Oracle Database 38The Oracle Instance 28User Processes 26The Oracle Architecture 25Interacting with Segments 19Other Segment Types 17Relationships and Constraints 11Rows,Columns,Tables,and Databases 7Relational Database Concepts 6Oracle Services 5Oracle Collaboration Suite 5Oracle Applications 11i 5Oracle Developer Suite 4Oracle Application Server 10g 4Oracle 10g 3The Oracle Product Family 2Components and Architecture 1Chapter 1 Oracle Database 10gIndex 605Glossary 87Implementing Database Recovery 543Chapter 11Implementing Database Backups 499Chapter 10Performance Monitoring 431Proactive Database Maintenance andChapter 9Managing Consistency and Concurrency 401Chapter 8Managing Data With SQL,PL/SQL,and Utilities 357Chapter 7User Administration and Security 309Chapter 6Oracle Shared Server 269Chapter 5Oracle Net Services 185Chapter 4Database Storage and Schema Objects 135Chapter 3Creating and Controlling a Database 75Chapter 2Chapter 1Oracle Database 10gExam Essentials 423Review Questions 424Answers to Review Questions 429Chapter 9 Proactive Database Maintenance andProactive Database Maintenance 432Automatic Workload Repository 432Automatic Database Diagnostic Monitoring 435ADDM Diagnostic Advisors 445ADDM Alerts 463Performance Monitoring 471Sources of Tuning Information 471Storing Database Statistics in the Data Dictionary 480Important Performance Metrics 485Summary 489Exam Essentials 491Review Questions 492Answers to Review Questions 497Chapter 10 Implementing Database Backups 499Understanding and Configuring Recovery Components 501Control Files 501Understanding Checkpoints 505Redo Log Files 506Archived Redo Log Files 514The Flash Recovery Area 518Performing Backups 521Understanding Backup Terminology 521Backing Up the Control File 522Using RMAN to Create Backups 525Managing Backups 530Catalog Maintenance 530Monitoring the Flash Recovery Area 531Automating Backups 532Summary 534Exam Essentials 534Review Questions 536Answers to Review Questions 540Chapter 11 Implementing Database Recovery 543Understanding Database Failure Types 544Statement Failures 545User Process Failures 545Network Failures 546User Error Failures 546Instance Failures 547Media Failures 547Performing Recovery Operations 548Understanding Instance Startup 548Keeping an Instance from Failing 550Recovering from Instance Failure 550Tuning Instance Recovery 551Recovering from User Errors 552Recovering from Loss of a Control File 564Recovering from Loss of a Redo Log File 566Recovering from Loss of a System-Critical Datafile 569Recovering from Loss of a NonâSystem-Critical Datafile 573