9i OCM Exam Topics   online 1 online 2 general

Overall Practicum Objectives [  ] Configure an Oracle9i database environment by creating the logical and physical structures required to support optimal performance. [  ] Configure an Oracle9i network environment to support a variety of connection scenarios. [  ] Install, configure, and use Oracle database management, tuning, and diagnostic tools. [  ] Use Oracle9i enhanced data management features to support advanced replication, partitioning, and parallel operations. [  ] Use Oracle9i tools to backup data while providing uninterrupted database availability. [  ] Use Oracle9i tools to perform restore and complete recovery operations from any failure scenario. [  ] Perform troubleshooting, analysis, and problem resolution to enhance database and instance performance. Database Configuration [  ] Determine and set sizing parameters for database segments. [  ] Create and manage temporary, permanent and undo tablespaces. [  ] Stripe data files across multiple physical devices and locations. [  ] Configure the database environment to support optimal data access performance. [  ] Protect the database from loss of data from any failure scenario. [  ] Create and manage database configuration files. Oracle Network Configuration [  ] Create and manage multiple network configuration files. [  ] Configure the database instance to support shared server connections. [  ] Setup network tracing. [  ] Configure the network environment to efficiently manage user connections. [  ] Manage Oracle network processes. [  ] Configure the network environment to allow connections to multiple databases. Database Availability [  ] Create a recovery catalog using Recovery Manager. [  ] Use Recovery Manager to perform database backups. [  ] Use Recovery Manager to perform a complete database restore and recovery. [  ] Configure the TNSNAMES.ORA file to support remote connections to a catalog database using TCP. [  ] Perform a complete recovery from any database or instance failure scenario. Data Management [  ] Create and manage tablespaces to support database access activities. [  ] Manage partitioning within a database environment. [  ] Configure auditing within the database. [  ] Provide users with access to data. [  ] Provide access to data using flashback. Database Management [  ] Implement fine-grained security. [  ] Generate table, index, column, and system statistics. [  ] Manage the SGA. [  ] Manage new users. [  ] Implement Replication. Performance Management [  ] Collect instance and database statistics using STATSPACK, USTAT/UTLESTAT, and OEM Packs. [  ] Analyze statistics and modify parameters to enhance performance. [  ] Configure Resource Manager and use it to manage queries. [  ] Create and manage objects to accommodate different data access methods. [  ] Analyze and tune query performance. Standby Databases and Data Guard [  ] Create and utilize a standby database. [  ] Add data to the primary database in preparation for transfer to a standby database. [  ] Setup the standby database to use the log writer process to transfer the log stream to the standby database. [  ] Configure the network environment to allow communication between the standby database and the primary database. [  ] Open the standby database in a "Read-Only" state. Oracle Enterprise Manager Setup and Configuration [  ] Configure Oracle Enterprise Manager. [  ] Create an OEM Repository [  ] Use OEM to modify a database configuration. [  ] Configure OEM to manage database availability. 10g OCM Exam Topics   online 1 general all doc Server Configuration [  ] Create the database [  ] Determine and set sizing parameters for database structures [  ] Create and manage temporary, permanent, and undo tablespaces [  ] Stripe data files across multiple physical devices and locations [  ] Configure the database environment to support optimal data access performance [  ] Create and manage database configuration files [  ] Create and manage bigfile tablespaces [  ] Create and manage multiple network configuration files [  ] Create and configure a listener [  ] Configure the database instance to support shared server connections [  ] Set up network tracing [  ] Manage Oracle network processes (the Listener Control utility) [  ] Configure the network environment to allow connections to multiple databases [  ] Use configurationless connections Enterprise Manager Grid Control [  ] Install the Enterprise Manager Grid Control software [  ] Configure the Enterprise Manager repository [  ] Create Enterprise Manager Grid Control users [  ] Use Enterprise Manager to modify a database configuration [  ] Configure Enterprise Manager to modify a database availability [  ] Create and manage jobs [  ] Create and monitor alerts [  ] Create notifications [  ] Implement Grid Control and Database Control [  ] Choose the appropriate tablespace type for the intended use [  ] Create Scheduler jobs [  ] Create schedules [  ] Assign jobs to windows [  ] Create programs [  ] Create job classes [  ] Install the Enterprise Manager Grid Control infrastructure [  ] Deploy Enterprise Manager Grid Control agents [  ] Configure Grid Control for business requirements Managing Database Availability [  ] Create a recovery catalog database [  ] Configure Recovery Manager [  ] Use Recovery Manager to perform database backups [  ] Use Recover Manager to perform complete database restore and recovery operations [  ] Set Flashback Database parameters [  ] Monitor Flashback Database logs and statistics [  ] Perform a Flashback Database operation [  ] Configure a flash recovery area Data Management [  ] Implement fine-grained auditing [  ] Create a secure application role [  ] Grant specific privileges for a Flashback Query [  ] Set parameters for retaining undo [  ] Implement fine-grained access control [  ] Create and manage contexts [  ] Use SQL*Loader [  ] Implement transportable tablespaces between homogeneous and heterogeneous systems (using different methods of moving files) [  ] Choose the appropriate partition method (range, hash, list, and composite) [  ] Choose the appropriate partition key [  ] Choose appropriate indexing methods (local, global, prefixed, and nonprefixed) [  ] Perform partition maintenance operations [  ] Maintain indexes on a partitioned table [  ] Create and manage LOB segments [  ] Apply parallelism appropriately [  ] Tune memory for parallel operations [  ] Set parallel parameters Data Warehouse Management [  ] Create external tables (Data Loader and Data Pump drivers) [  ] Implement Data Pump export and import jobs for data transfer [  ] Implement Data Pump to and from remote databases [  ] Implement Replication/Streams [  ] Configure and manage master replication [  ] Configure and manage distributed materialized views [  ] Configure and manage Streams for replication Performance Management [  ] Install Statspack [  ] Adjust the default interval for statistics collection [  ] Customize the events that are monitored [  ] Use ADDM to analyze statistics and to identify performance bottlenecks and fix them [  ] Implement automatic shared memory management [  ] Tune memory using manual memory management [  ] Monitor and tune SGA areas that are not automatically tuned [  ] Implement automatic SQL execution memory management [  ] Tune the PGA using work area size parameters [  ] Use the PGA Advisor [  ] Create a Database Resource Manager plan with directives (active session count, max execution time) [  ] Create consumer groups [  ] Configure consumer group mappings [  ] Manage Services (Oracle Database 10g Release 2) [  ] Create and manage objects to accommodate different data access methods (schema tuning) [  ] Use the SQL Tuning Advisor [  ] Use the SQL Access Advisor [  ] Gather Optimizer statistics [  ] Interpret execution plan [  ] Use SQL tuning tools and features Real Application Clusters [  ] Install Cluster Ready Services [  ] Install the Oracle Database 10g software [  ] Implement ASM failure groups [  ] Create and manage as ASM instance [  ] Create and manage ASM disk groups [  ] Configure ASM for the shared disks, and create a clustered database [  ] Configure archiving [  ] Configure Services with a primary instance and an available instance Data Guard [  ] Use Data Guard Manager and DGMGRL [  ] Create and utilize a physical standby database [  ] Create and utilize a logical standby database [  ] Set up log transport services for various levels or protection [  ] Configure the network environment to allow communication between the standby database and the primary database [  ] Open the physical standby database in a "ready-only" state [  ] Perform a switchover operation and a failover operation [  ] Implement Data Guard   back to start   home <xmp>