Introduction |
|
xv | |
Assessment Test |
|
xxiv | |
|
Installing and Upgrading to Oracle 10g |
|
|
1 | (54) |
|
|
2 | (11) |
|
Using the Oracle Universal Installer |
|
|
3 | (3) |
|
Examining the OUI Support for New Features |
|
|
6 | (4) |
|
Introducing Installation Enhancements |
|
|
10 | (3) |
|
|
13 | (13) |
|
Examining DBCA Enhancements |
|
|
14 | (1) |
|
Using the DBCA to Clone a Database |
|
|
14 | (3) |
|
Simplifying Instance Configuration |
|
|
17 | (1) |
|
Using the Enterprise Manager |
|
|
18 | (5) |
|
|
23 | (3) |
|
|
26 | (20) |
|
Introducing Upgrade-Supported Releases |
|
|
27 | (1) |
|
Validating the Database Before Upgrade |
|
|
28 | (7) |
|
|
35 | (11) |
|
|
46 | (1) |
|
|
47 | (2) |
|
|
49 | (4) |
|
Answers to Review Questions |
|
|
53 | (2) |
|
Moving Data and Managing the Scheduler |
|
|
55 | (78) |
|
|
56 | (30) |
|
Introducing the Architecture of Data Pump |
|
|
57 | (2) |
|
Introducing Data Access Methods |
|
|
59 | (1) |
|
Exploring the Advantages of Data Pump |
|
|
60 | (1) |
|
|
61 | (22) |
|
Using the Data Pump Wizard |
|
|
83 | (3) |
|
Making Data Movement Enhancements |
|
|
86 | (9) |
|
Using Cross-Platform Transportable Tablespaces |
|
|
87 | (3) |
|
Writing and Projecting External Tables |
|
|
90 | (5) |
|
|
95 | (28) |
|
Understanding Scheduler Concepts |
|
|
96 | (1) |
|
Creating Basic Scheduler Components |
|
|
97 | (10) |
|
|
107 | (7) |
|
Managing Advanced Scheduler Components |
|
|
114 | (7) |
|
Querying the Data Dictionary |
|
|
121 | (2) |
|
|
123 | (2) |
|
|
125 | (1) |
|
|
126 | (4) |
|
Answers to Review Questions |
|
|
130 | (3) |
|
|
133 | (62) |
|
Collecting Performance Statistics |
|
|
134 | (12) |
|
Using the Automatic Workload Repository |
|
|
135 | (3) |
|
Working with Automatic Workload Repository |
|
|
138 | (7) |
|
Base Statistics and Metrics |
|
|
145 | (1) |
|
Diagnosing Performance Statistics |
|
|
146 | (11) |
|
Using the Automatic Database Diagnostic Monitor |
|
|
147 | (4) |
|
Using Server-Generated Alerts |
|
|
151 | (5) |
|
Building Your Own Alert Mechanism |
|
|
156 | (1) |
|
Automating Database Management |
|
|
157 | (22) |
|
Using Automatic Shared Memory Management (ASMM) |
|
|
157 | (3) |
|
Tuning Automatic Undo Retention |
|
|
160 | (3) |
|
Tuning the Automatic Checkpoint |
|
|
163 | (1) |
|
Collecting Automatic Optimizer Statistics |
|
|
164 | (7) |
|
Identifying the Advisory Framework |
|
|
171 | (8) |
|
|
179 | (1) |
|
Resource Manager Enhancements |
|
|
179 | (6) |
|
Automatic Session Switchback |
|
|
180 | (1) |
|
|
181 | (1) |
|
|
181 | (4) |
|
Changes to Resource Allocation Method |
|
|
185 | (1) |
|
|
185 | (1) |
|
|
186 | (2) |
|
|
188 | (4) |
|
Answers to Review Questions |
|
|
192 | (3) |
|
General Storage Management |
|
|
195 | (48) |
|
|
196 | (23) |
|
|
197 | (7) |
|
|
204 | (6) |
|
Temporary Tablespace Groups |
|
|
210 | (3) |
|
Other Tablespace Enhancements |
|
|
213 | (6) |
|
Making Partitioning Enhancements |
|
|
219 | (5) |
|
Partition Maintenance Using EM Database Control |
|
|
219 | (1) |
|
Partitioned Index Organized Tables (IOTs) |
|
|
220 | (2) |
|
Local-Partitioned Index Enhancements |
|
|
222 | (2) |
|
Leveraging Index Enhancements |
|
|
224 | (6) |
|
Skipping Unusable Indexes |
|
|
224 | (1) |
|
Maintaining Index Partition Storage Characteristics |
|
|
224 | (6) |
|
Bitmap Index Storage Enhancements |
|
|
230 | (1) |
|
|
230 | (2) |
|
|
232 | (2) |
|
|
234 | (6) |
|
Answers to Review Questions |
|
|
240 | (3) |
|
Automated Storage Management |
|
|
243 | (74) |
|
Enhancing Space Management |
|
|
245 | (39) |
|
Proactive Tablespace Monitoring |
|
|
245 | (12) |
|
|
257 | (22) |
|
Miscellaneous Space Management Features |
|
|
279 | (5) |
|
Automatic Storage Management |
|
|
284 | (22) |
|
|
284 | (2) |
|
|
286 | (2) |
|
ASM Instance Characteristics |
|
|
288 | (2) |
|
ASM Dynamic Performance Views |
|
|
290 | (1) |
|
|
291 | (2) |
|
ASM File Types and Templates |
|
|
293 | (3) |
|
Administering ASM Disk Groups |
|
|
296 | (10) |
|
|
306 | (1) |
|
|
307 | (1) |
|
|
308 | (7) |
|
Answers to Review Questions |
|
|
315 | (2) |
|
Performance and Application Tuning |
|
|
317 | (34) |
|
Managing Optimizer Statistics |
|
|
318 | (6) |
|
Gathering Automatic Statistics |
|
|
319 | (1) |
|
Leveraging Enhanced Query Optimization |
|
|
320 | (2) |
|
Gathering Data Dictionary Statistics |
|
|
322 | (1) |
|
|
323 | (1) |
|
Understanding Rule-Based Optimizer Desupport |
|
|
324 | (1) |
|
Understanding the SQL Tuning Advisor |
|
|
324 | (10) |
|
Introducing the SQL Tuning Advisor |
|
|
325 | (3) |
|
|
328 | (6) |
|
Understanding the SQL Access Advisor |
|
|
334 | (5) |
|
Introducing the SQL Access Advisor |
|
|
334 | (1) |
|
Using the SQL Access Advisor |
|
|
335 | (4) |
|
Accessing the Database Control Performance Pages |
|
|
339 | (3) |
|
|
342 | (1) |
|
|
342 | (2) |
|
|
344 | (5) |
|
Answers to Review Questions |
|
|
349 | (2) |
|
Backup, Recovery, and High Availability |
|
|
351 | (58) |
|
Leveraging the Flash Recovery Area |
|
|
353 | (8) |
|
Flash Recovery Area Occupants |
|
|
353 | (1) |
|
Flash Recovery Area and SQL Commands |
|
|
354 | (1) |
|
Flash Recovery Area and the EM Database Control |
|
|
355 | (1) |
|
Flash Recovery Area Management |
|
|
356 | (1) |
|
Flash Recovery Directory Structure |
|
|
356 | (2) |
|
Backing Up the Flash Recovery Area |
|
|
358 | (1) |
|
Flash Recovery Area Data Dictionary Views |
|
|
358 | (3) |
|
Flash Recovery Area Best Practices |
|
|
361 | (1) |
|
Performing Incremental and Incrementally Updated Backups |
|
|
361 | (5) |
|
Recovery with Incrementally Updated Backups |
|
|
361 | (2) |
|
|
363 | (3) |
|
Using Miscellaneous Backup Features |
|
|
366 | (9) |
|
|
366 | (2) |
|
|
368 | (1) |
|
Backing Up Different Object Types with RMAN |
|
|
369 | (4) |
|
|
373 | (2) |
|
Introducing Miscellaneous Recovery Features |
|
|
375 | (1) |
|
Fast Recovery Using Switch Database |
|
|
376 | (1) |
|
|
376 | (1) |
|
Flashing Back Any Logical Error |
|
|
376 | (22) |
|
|
377 | (6) |
|
|
383 | (7) |
|
|
390 | (5) |
|
|
395 | (2) |
|
Guaranteed Undo Retention |
|
|
397 | (1) |
|
SCN and Time Mapping Enhancements |
|
|
397 | (1) |
|
|
398 | (1) |
|
|
398 | (1) |
|
|
399 | (1) |
|
|
400 | (6) |
|
Answers to Review Questions |
|
|
406 | (3) |
|
Security and SQL Enhancements |
|
|
409 | (76) |
|
|
411 | (15) |
|
Leveraging Virtual Private Database |
|
|
411 | (7) |
|
|
418 | (8) |
|
Introducing SQL New Features |
|
|
426 | (32) |
|
|
426 | (7) |
|
|
433 | (5) |
|
Spreadsheet Computations Using the MODEL Clause |
|
|
438 | (10) |
|
|
448 | (5) |
|
|
453 | (3) |
|
Case- and Accent-Insensitive Queries |
|
|
456 | (1) |
|
|
457 | (1) |
|
Introducing Miscellaneous Database Enhancements |
|
|
458 | (16) |
|
|
458 | (1) |
|
Flushing the Buffer Cache |
|
|
459 | (1) |
|
Resumable Space Allocation |
|
|
459 | (1) |
|
Materialized View Enhancements |
|
|
460 | (4) |
|
Database Connectivity Improvements |
|
|
464 | (2) |
|
|
466 | (1) |
|
Transaction Rollback Monitoring |
|
|
466 | (1) |
|
|
467 | (7) |
|
|
474 | (2) |
|
|
476 | (1) |
|
|
477 | (5) |
|
Answers to Review Questions |
|
|
482 | (3) |
|
Appendix A SQL*Plus Enhancements |
|
|
485 | (6) |
|
Enhancements to the DESCRIBE Command |
|
|
486 | (1) |
|
Changes to Profile File Calls |
|
|
487 | (1) |
|
Supporting Whitespace in Filenames |
|
|
487 | (1) |
|
Changes to the SPOOL Command |
|
|
487 | (1) |
|
Introducing New Predefined Variables |
|
|
488 | (1) |
|
Changes to the SHOW Command |
|
|
489 | (1) |
|
|
489 | (2) |
|
Appendix B New and Obsolete Initialization Parameters |
|
|
491 | (6) |
|
|
492 | (1) |
|
|
493 | (2) |
|
|
495 | (2) |
|
Appendix C PL/SQL Enhancements and New Packages |
|
|
497 | (6) |
|
Enhancements to the PL/SQL Compiler |
|
|
498 | (1) |
|
|
499 | (1) |
|
|
500 | (3) |
Glossary |
|
503 | (12) |
Index |
|
515 | |