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