OCA: Oracle 10g administration I study guide 1Z0.042

Team DDU......Page 1
Contents......Page 12
Introduction......Page 18
Assessment Test......Page 31
1 Oracle Database 10g Components and Architecture......Page 42
The Oracle Product Family......Page 43
Oracle 10g......Page 44
Oracle Developer Suite......Page 45
Oracle Services......Page 46
Relational Database Concepts......Page 47
Rows, Columns, Tables, and Databases......Page 48
Relationships and Constraints......Page 52
Other Segment Types......Page 58
Interacting with Segments......Page 60
The Oracle Architecture......Page 66
User Processes......Page 67
The Oracle Instance......Page 69
The Oracle Database......Page 79
Review the System Requirements......Page 89
Plan Your Install......Page 90
Using the Oracle Universal Installer......Page 97
Summary......Page 106
Exam Essentials......Page 107
Review Questions......Page 109
Answers to Review Questions......Page 113
2 Creating and Controlling a Database......Page 116
The Oracle Enterprise Management Framework......Page 117
Starting and Stopping the Oracle Management Agent......Page 119
Using iSQL*Plus......Page 121
Creating an Oracle Database Using the DBCA......Page 125
Deleting an Oracle Database Using DBCA......Page 147
Managing Database Templates Using DBCA......Page 148
Managing Parameter Initialization Files......Page 150
Oracle 10g Database Startup......Page 152
Shutting Down an Oracle 10g Database......Page 158
Shutting Down Oracle Using EM Database Control......Page 159
Monitoring the Database Alert Log......Page 163
Summary......Page 166
Exam Essentials......Page 168
Review Questions......Page 170
Answers to Review Questions......Page 174
3 Database Storage and Schema Objects......Page 176
Managing Tablespaces......Page 177
Identifying Default Tablespaces......Page 178
Creating and Maintaining Tablespaces......Page 179
Obtaining Tablespace Information......Page 186
Managing Datafiles......Page 192
Specifying Datatypes......Page 193
Creating Tables......Page 199
Working with Constraints......Page 206
Working with Indexes......Page 213
Working with Views......Page 215
Working with Sequences......Page 216
Exam Essentials......Page 217
Review Questions......Page 219
Answers to Review Questions......Page 223
4 Oracle Net Services......Page 226
Network Complexity Issues......Page 227
Network Security Issues......Page 228
Network Responsibilities for the DBA......Page 229
Single-Tier Architecture......Page 230
N-Tier Architecture......Page 231
An Overview of Oracle Net Features......Page 232
Connectivity......Page 233
Manageability......Page 234
Scalability......Page 235
Security......Page 237
Accessibility......Page 238
Configuring Oracle Net on the Server......Page 239
Understanding the Oracle Listener......Page 240
Managing Oracle Listeners......Page 244
Dynamically Registering Services......Page 265
Additional Configurations When Using Multiple Listeners......Page 266
Troubleshooting Server-Side Connection Problems......Page 268
Oracle Net Logging and Tracing on the Server......Page 274
Client-Side Names Resolution Options......Page 279
The Hostnaming Method......Page 280
The Oracle Easy Connect Naming Method......Page 285
The Localnaming Method......Page 287
Troubleshooting Client-Side Connection Problems......Page 295
Summary......Page 300
Exam Essentials......Page 301
Review Questions......Page 304
Answers to Review Questions......Page 308
5 Oracle Shared Server......Page 310
An Overview of Oracle Shared Server......Page 311
Dedicated Server versus Shared Server......Page 312
Advantages and Disadvantages of Shared Server......Page 314
PGA and SGA Changes When Using Oracle Shared Server......Page 315
Configuring the Oracle Shared Server......Page 317
Defining the Shared Server Parameters......Page 318
Configuring Shared Server at Database Creation......Page 324
Configuring Shared Server Using Enterprise Manager......Page 326
Displaying Information about Shared Server Connections Using the Listener Utility......Page 329
Using Dynamic Performance Views for Shared Server......Page 330
Requesting a Dedicated Connection in a Shared Server Environment......Page 335
Tuning the Shared Server Option......Page 336
Sizing the Large Pool......Page 337
Determining Whether You Have Enough Dispatchers......Page 338
Measuring How Long Users Are Waiting for Dispatchers......Page 339
Determining Whether You Have Enough Shared Servers......Page 340
Summary......Page 341
Exam Essentials......Page 342
Review Questions......Page 343
Answers to Review Questions......Page 347
6 User Administration and Security......Page 350
Configuring Authentication......Page 351
Assigning a Temporary Tablespace......Page 353
Assigning a Profile to a User......Page 354
Granting Object Privileges......Page 355
Granting System Privileges......Page 359
Role Privileges......Page 365
Controlling Resource Usage by Users......Page 368
Assigning Resource Limits with a Profile......Page 369
Applying the Principle of Least Privilege......Page 372
Managing Default User Accounts......Page 374
Implementing Standard Password Security Features......Page 375
Auditing Database Activity......Page 377
Managing Statement Auditing......Page 379
Managing Privilege Auditing......Page 384
Managing Object Auditing......Page 385
Purging the Audit Trail......Page 386
Managing Fine-Grained Auditing......Page 387
Exam Essentials......Page 390
Review Questions......Page 392
Answers to Review Questions......Page 396
7 Managing Data with SQL, PL/SQL, and Utilities......Page 398
Using INSERT Statements......Page 399
Using UPDATE Statements......Page 402
Using DELETE Statements......Page 403
Working with Functions......Page 404
Working with Packages......Page 406
Working with Triggering Events and Managing Triggers......Page 408
Using and Administering PL/SQL Programs......Page 412
Configuring PL/SQL for Better Performance......Page 414
Data Pump Overview......Page 415
Using Data Pump to Export Data......Page 416
Using Data Pump to Import Data......Page 422
Loading Data with SQL*Loader......Page 429
Specifying SQL*Loader Command-Line Parameters......Page 430
Specifying Control File Options......Page 431
Summary......Page 434
Exam Essentials......Page 435
Review Questions......Page 436
Answers to Review Questions......Page 440
8 Managing Consistency and Concurrency......Page 442
Leveraging Undo Management......Page 443
Understanding Undo Segments......Page 444
Using Undo Data......Page 446
Monitoring, Configuring, and Administering Undo......Page 448
Understanding Locks and Transactions......Page 457
Maximizing Data Concurrency......Page 458
Detecting and Resolving Lock Conflicts......Page 460
Summary......Page 463
Exam Essentials......Page 464
Review Questions......Page 465
Answers to Review Questions......Page 470
9 Proactive Database Maintenance and Performance Monitoring......Page 472
Automatic Workload Repository......Page 473
Automatic Database Diagnostic Monitoring......Page 476
ADDM Diagnostic Advisors......Page 486
ADDM Alerts......Page 504
Sources of Tuning Information......Page 512
Storing Database Statistics in the Data Dictionary......Page 521
Important Performance Metrics......Page 526
Summary......Page 530
Exam Essentials......Page 532
Review Questions......Page 533
Answers to Review Questions......Page 538
10 Implementing Database Backups......Page 540
Control Files......Page 542
Understanding Checkpoints......Page 546
Redo Log Files......Page 547
Archived Redo Log Files......Page 555
The Flash Recovery Area......Page 559
Understanding Backup Terminology......Page 562
Backing Up the Control File......Page 563
Using RMAN to Create Backups......Page 566
Catalog Maintenance......Page 571
Monitoring the Flash Recovery Area......Page 572
Automating Backups......Page 573
Exam Essentials......Page 575
Review Questions......Page 577
Answers to Review Questions......Page 581
11 Implementing Database Recovery......Page 584
Understanding Database Failure Types......Page 585
User Process Failures......Page 586
User Error Failures......Page 587
Media Failures......Page 588
Understanding Instance Startup......Page 589
Recovering from Instance Failure......Page 591
Tuning Instance Recovery......Page 592
Recovering from User Errors......Page 593
Recovering from Loss of a Control File......Page 605
Recovering from Loss of a Redo Log File......Page 607
Recovering from Loss of a System-Critical Datafile......Page 610
Recovering from Loss of a Non–System-Critical Datafile......Page 614
Exam Essentials......Page 619
Review Questions......Page 621
Answers to Review Questions......Page 626
Glossary......Page 628
Index......Page 646