SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK OCP ORACLE DATABASE 10G NEW FEATURES FOR ADMINISTRATORS 2004
SUMMARY
-
Items Found: 218
- Chapter 1
- Installing and Upgrading to Oracle 10g 1
- Chapter 2
- Moving Data and Managing the Scheduler 55
- Chapter 3
- Automating Management 133
- Chapter 4
- General Storage Management 195
- Chapter 5
- Automated Storage Management 243
- Chapter 6
- Performance and Application Tuning 317
- Chapter 7
- Backup,Recovery,and High Availability 351
- Chapter 8
- Security and SQL Enhancements 409
- Appendix A
- SQL*Plus Enhancements 485
- Appendix B
- New and Obsolete Initialization Parameters 491
- Appendix C
- PL/SQL Enhancements and New Packages 497
- Chapter 1 Installing and Upgrading to Oracle 10g 1
- Installing Oracle 10g 2
- Using the Oracle Universal Installer 3
- Examining the OUI Support for New Features 6
- Introducing Installation Enhancements 10
- Configuring Oracle 10g 13
- Examining DBCA Enhancements 14
- Using the DBCA to Clone a Database 14
- Simplifying Instance Configuration 17
- Using the Enterprise Manager 18
- Viewing Database Usage 23
- Upgrading the Database 26
- Introducing Upgrade-Supported Releases 27
- Validating the Database Before Upgrade 28
- Performing the Upgrade 35
- Summary 46
- Exam Essentials 47
- Review Questions 49
- Answers to Review Questions 53
- Chapter 2 Moving Data and Managing the Scheduler 55
- Introducing Data Pump 56
- Introducing the Architecture of Data Pump 57
- Introducing Data Access Methods 59
- Exploring the Advantages of Data Pump 60
- Using Data Pump Clients 61
- Using the Data Pump Wizard 83
- Making Data Movement Enhancements 86
- Using Cross-Platform Transportable Tablespaces 87
- Writing and Projecting External Tables 90
- Managing the Scheduler 95
- Understanding Scheduler Concepts 96
- Creating Basic Scheduler Components 97
- Using the Scheduler 107
- Managing Advanced Scheduler Components 114
- Querying the Data Dictionary 121
- Summary 123
- Exam Essentials 125
- Review Questions 126
- Answers to Review Questions 130
- Chapter 3 Automating Management 133
- Collecting Performance Statistics 134
- Using the Automatic Workload Repository 135
- Working with Automatic Workload Repository 138
- Base Statistics and Metrics 145
- Diagnosing Performance Statistics 146
- Using the Automatic Database Diagnostic Monitor 147
- Using Server-Generated Alerts 151
- Building Your Own Alert Mechanism 156
- Automating Database Management 157
- Using Automatic Shared Memory Management (ASMM) 157
- Tuning Automatic Undo Retention 160
- Tuning the Automatic Checkpoint 163
- Collecting Automatic Optimizer Statistics 164
- Identifying the Advisory Framework 171
- Automating Tasks 179
- Resource Manager Enhancements 179
- Automatic Session Switchback 180
- Setting Idle Timeout 181
- Creating a Mapping 181
- Changes to Resource Allocation Method 185
- Summary 185
- Exam Essentials 186
- Review Questions 188
- Answers to Review Questions 192
- Chapter 4 General Storage Management 195
- Managing Tablespaces 196
- The SYSAUX Tablespace 197
- Bigfile Tablespaces 204
- Temporary Tablespace Groups 210
- Other Tablespace Enhancements 213
- Making Partitioning Enhancements 219
- Partition Maintenance Using EM Database Control 219
- Partitioned Index Organized Tables (IOTs) 220
- Local-Partitioned Index Enhancements 222
- Leveraging Index Enhancements 224
- Skipping Unusable Indexes 224
- Maintaining Index Partition Storage Characteristics 224
- Bitmap Index Storage Enhancements 230
- Summary 230
- Exam Essentials 232
- Review Questions 234
- Answers to Review Questions 240
- Chapter 5 Automated Storage Management 243
- Enhancing Space Management 245
- Proactive Tablespace Monitoring 245
- Segment Management 257
- Miscellaneous Space Management Features 279
- Automatic Storage Management 284
- ASM Architecture 284
- Creating an ASM Instance 286
- ASM Instance Characteristics 288
- ASM Dynamic Performance Views 290
- ASM Filenames 291
- ASM File Types and Templates 293
- Administering ASM Disk Groups 296
- Summary 306
- Exam Essentials 307
- Review Questions 308
- Answers to Review Questions 315
- Chapter 6 Performance and Application Tuning 317
- Managing Optimizer Statistics 318
- Gathering Automatic Statistics 319
- Leveraging Enhanced Query Optimization 320
- Gathering Data Dictionary Statistics 322
- Monitoring DML Tables 323
- Understanding Rule-Based Optimizer Desupport 324
- Understanding the SQL Tuning Advisor 324
- Introducing the SQL Tuning Advisor 325
- Using SQL Tuning Advisor 328
- Understanding the SQL Access Advisor 334
- Introducing the SQL Access Advisor 334
- Using the SQL Access Advisor 335
- Accessing the Database Control Performance Pages 339
- Summary 342
- Exam Essentials 342
- Review Questions 344
- Answers to Review Questions 349
- Chapter 7 Backup,Recovery,and High Availability 351
- Leveraging the Flash Recovery Area 353
- Flash Recovery Area Occupants 353
- Flash Recovery Area and SQL Commands 354
- Flash Recovery Area and the EM Database Control 355
- Flash Recovery Area Management 356
- Flash Recovery Directory Structure 356
- Backing Up the Flash Recovery Area 358
- Flash Recovery Area Data Dictionary Views 358
- Flash Recovery Area Best Practices 361
- Performing Incremental and Incrementally Updated Backups 361
- Recovery with Incrementally Updated Backups 361
- Fast Incremental Backups 363
- Using Miscellaneous Backup Features 366
- RMAN Command Changes 366
- Online Backup Mode 368
- Backing Up Different Object Types with RMAN 369
- Compressed Backups 373
- Introducing Miscellaneous Recovery Features 375
- Fast Recovery Using SWITCH DATABASE 376
- Recovery Using RESETLOGS 376
- Flashing Back Any Logical Error 376
- Flashback Database 377
- Flashback Drop 383
- Flashback Query 390
- Flashback Table 395
- Guaranteed Undo Retention 397
- SCN and Time Mapping Enhancements 397
- Flashback Privileges 398
- Summary 398
- Exam Essentials 399
- Review Questions 400
- Answers to Review Questions 406
- Chapter 8 Security and SQL Enhancements 409
- Securing Data 411
- Leveraging Virtual Private Database 411
- Auditing Enhancements 418
- Introducing SQL New Features 426
- MERGE Improvements 426
- Partitioned Outer Join 433
- Spreadsheet Computations Using the MODEL Clause 438
- Regular Expressions 448
- Data Type Enhancements 453
- Case- and Accent-Insensitive Queries 456
- Quote Operator 457
- Introducing Miscellaneous Database Enhancements 458
- MAXTRANS Ignored 458
- Flushing the Buffer Cache 459
- Resumable Space Allocation 459
- Materialized View Enhancements 460
- Database Connectivity Improvements 464
- LogMiner Enhancements 466
- Transaction Rollback Monitoring 466
- Tracing Enhancements 467
- Summary 474
- Exam Essentials 476
- Review Questions 477
- Answers to Review Questions 482
- Appendix A
- SQL*Plus Enhancements 485
- Enhancements to the DESCRIBE Command 486
- Changes to Profile File Calls 487
- Supporting Whitespace in Filenames 487
- Changes to the SPOOL
- Command 487
- Introducing New Predefined Variables 488
- Changes to the SHOW
- Command 489
- Invoking SQL*Plus 489
- Appendix B
- New and Obsolete Initialization Parameters 491
- New Parameters 492
- Obsolete Parameters 493
- Deprecated Parameters 495
- Appendix C
- PL/SQL Enhancements and New Packages 497
- Enhancements to the PL/SQL Compiler 498
- Enhancements to PL/SQL 499
- New Packages in PL/SQL 500
