iv
Practice 5-3: Materialized Views.........................................................................................................55
Practice 6-1: Installing Statspack.........................................................................................................57
Practice 6-2: Creating Statspack Snapshots.........................................................................................58
Practice 6-3: Generating Statspack Reports.........................................................................................59
Practice 6-4: Managing Storage...........................................................................................................60
Practice 6-5: Monitoring and Managing Memory ...............................................................................62
Practice 6-6: Automatic Performance Management............................................................................64
Practice 6-7: Managing Resources.......................................................................................................66
Practice 6-8: Tuning PGA_AGGREGATE_TARGET............................................................................68
Practice 6-9: EXPLAIN PLAN and SQL*Plus AUTOTRACE.............................................................69
Practice 6-10: Gathering Optimizer Statistics......................................................................................70
Practice 6-11: SQL Trace and TKPROF ...........................................................................................72
Practice 6-12: Access Paths .................................................................................................................74
Practice 6-13: SQL Tuning Advisor ....................................................................................................75
Practice 6-14: SQL Access Advisor ....................................................................................................76
Practice 7-1: Configuring Your Primary Database..............................................................................77
Practice 7-2: Creating a Physical Standby Database ...........................................................................78
Practice 7-3: Configuring Data Protection Modes and Redo Transport Services ...............................79
Practice 7-4: Performing Switchover and Failover..............................................................................80
Practice 7-5: Creating a Logical Standby Database.............................................................................81
Practice 8-1: Create Two Databases for Oracle Streams....................................................................82
Practice 8-2: Database Configuration of the Source Site....................................................................83
Practice 8-3: Database Configuration of the Destination Site .............................................................84
Practice 8-4: Creating the Streams Administrator Users .....................................................................85
Practice 8-5: Configuring for Streams in Both Databases...................................................................86
Practice 8-6: Configuring Replication for Tablespaces.......................................................................87
Practice 8-7: Configuring Replication Between Two Databases.........................................................88
Command-Line Solutions for Practice 1-1: Configuring the Initial Oracle Network
Environment.........................................................................................................................................89
Command-Line Solutions for Practice 1-2: Creating an Oracle Database ..........................................91
Command-Line Solutions for Practice 1-3: Managing the Oracle Instance........................................95
Command-Line Solutions for Practice 1-4: Managing Undo Data .....................................................97
Your Tasks...........................................................................................................................................97
Command-Line Solutions for Practice 1-5: Managing Database Storage Structures..........................98
Command-Line Solutions for Practice 1-6: Configuring the Oracle Network Environment ............103
Command-Line Solutions for Practice 1-7: Oracle Shared Server....................................................106
Command-Line Solutions for Practice 3-1: Create the Recovery Catalog and Register the
Database.............................................................................................................................................110
Command-Line Solutions for Practice 3-2: Configure Your Database.............................................113
Command-Line Solutions for Practice 3-3: Use RMAN to Create and Manage Backups................116
Command-Line Solutions for Practice 3-4: Use RMAN to Recover a Data File..............................121
Command-Line Solutions for Practice 3-5: Recover Control Files...................................................124
Command-Line Solutions for Practice 3-6: Enable Flashback Database ..........................................130
Command-Line Solutions for Practice 3-7: Use Flashback Database...............................................132
Command-Line Solutions for Practice 4-1: Implement Fine-Grained Auditing ...............................135
Command-Line Solutions for Practice 4-2: Implement Secure Application Role ............................144
5星 · 超过95%的资源 需积分: 9 113 浏览量
2013-11-13
18:24:25
上传
评论 2
收藏 15.61MB PDF 举报 
yhj200411280012014-04-05不错，值得下载，对备考OCM有用
