Online Dynamic Performance Views eLearning

Oracle Database 11g Performance Tuning Methodology Tools ...gnose performance issues, and discusses using the various dynamic performance views (V$ views) to perform statistical analysis when diagnosing problems. The use of alert logs, user trace files, and wait events analysis are also explored in this introduction to performance tuning. This course helps to prepare you for the Oracle Database 11g: Performance Tuning exam which counts towards the  more...

Oracle Database 11g Execution Plans and Star Transformations Oracle Database 11g: Execution Plans and Star Transformations Oracle An execution plan is the output of the optimizer and is presented to the execution engine for implementation. The execution plan instructs the execution engine about the operations it must perform for retrieving the data required by a query most efficiently. This course explores gathering, displaying, and interpreting  more...

Oracle Database 11g Configuring for Backups To identify the steps for preparing a database for backup and then for performing various types of RMAN backups and monitoring them using reports and dynamic performance views, and also for performing user-managed backups and recoveries.  more...

Oracle8 Database Administration - Manage an Instance ...ch stage of instance shutdown. Identify the features of dynamic performance views. Specify the associated dynamic performance view parameter for a given description. Display the current parameter values by using the V$PARAMETER dynamic performance view. Modify a dynamic initialization parameter by using the Oracle Instance Manager. Set up a restricted session to a database by using  more...

Oracle8 Database Administration - Create Databases ...s of information stored in a control file. Identify the dynamic performance views and the information they contain about the control files. Multiplex a control file. Identify the uses of redo log groups. Identify the features of redo log members in a group. Match the parameters that limit the number of online redo log files with what they determine. Identify the situations in which  more...

Oracle8 Performance Tuning Strategies and Techniques ...ssion level tracing. Define wait events. Describe the dynamic performance views used to identify wait events and statistics associated with wait events. Describe the OEM event management system. Set events through OEM to be alerted about predefined situations. Resolve problems detected by an event. Unit 3: Utilities and Dynamic Performance Views Duration: 1 - 2 Hour(s)  more...

Oracle8i Performance Tuning Architecture Strategy ...tatistics found in event views. Unit 3: Utilities and Dynamic Performance Views Duration: 1 - 2 Hour(s) Identify the functions of the DBA views used to provide data storage statistics. Match the dynamic performance views with the statistics they provide. Match the V$ views used to collect system-wide statistics with their functions. Match the session-related views with the  more...

Oracle8i Performance Tuning Managing Memory Disk I O Course Overview This course is the second in a three-part Oracle8i Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...

Oracle9i Database Admin Manage an Instance ...t down an instance. This course also explains the various dynamic performance views and initialization parameters and the globalization support that is provided. Learn To • Identify the memory structures of the SGA and the information stored in the database and nondatabase files. • Identify the connection procedures and the processes generated during database connection.  more...

Oracle9i Performance Tuning Architecture Strategy ...ws used to provide data storage statistics. o Match the dynamic performance views with the statistics they provide. o Match the V$ views used to collect system-wide statistics with their functions. o Identify the factors taken into consideration in selecting the physical structure for data. o Match the index types with their benefits. o Identify the key usage of index organized  more...

Oracle8 Backup and Recovery - Strategies and Backups Course Overview This is the first course in a two-part series that will introduce participants to the critical task of planning and implementing database backup strategies. In this course, users will be introduced to backup concepts and the Oracle architecture. They will learn how to change the archive mode of a database and configure a database for archive processing. Additionally, users will  more...

Oracle8 Backup and Recovery - Troubleshooting and Recovery ...nd. Locate the data files needing recovery by using the dynamic performance views. Recover from an open database failure. Recover tablespace syntax. Identify the use of the v$datafile view. Recover a database from loss of data file that does not have a backup. Recover a failed database that had a file in hot backup mode. Identify the use of the v$backup view Recover from the  more...