Online Sga eLearning

Oracle Database 11g R2 Managing Database Memory Performance ...atabase's memory structures, focusing on how to configure SGA parameters and how to implement Automatic Memory Management and Automatic Shared Memory Management, and how to configure automatic PGA memory management. This course also explains how to monitor the performance of sessions and services, including how the Automatic Workload Repository (AWR) works, and how to use the SQL Tuning Advisor  more...

Oracle Database 11g Tuning PGA Temporary Space AMM Oracle Database 11g: Tuning PGA, Temporary Space & AMM Oracle Oracle Database 11g provides various methods for tuning, monitoring and managing memory and temporary tablespaces. Automatic Program Global Area (PGA) memory management adapts the SQL memory allocation based on PGA memory available, SQL operator needs, and system workload. A temporary tablespace is used to store transient data  more...

Oracle Database 11g R2 Application Performance Enhancements ... means for storing the results of PL/SQL functions in the SGA, so that they are available to all the application sessions that are running. This course identifies the new online redefinition enhancements for tables, invisible indexes, adaptive cursor sharing, and using SQL Query Result, Client Query, and PL/SQL Function Caches. This course is one of a series in the SkillSoft learning path that  more...

Oracle Database 11g R2 The ASM Instance Network Connectivity ...also used. The ASM instance allocates memory and uses the SGA differently than in a database instance. This course describes the ASM instance and how it works, and demonstrates how to manage it with various utilities. It discusses the ASM disk groups and how to create, extend, and drop them. This course also identifies how to configure the Oracle network environment which includes configuring  more...

Oracle8 Database Administration - Manage an Instance ... Match the memory structures of the System Global Area (SGA) with the information stored by them. Match the mandatory background processes with their functions. Match the different types of files existing in a database with the information stored in them. Match the non-database files with the information stored in them. Sequence the stages in processing a query. Identify the  more...

Oracle8i Performance Tuning Managing Memory Disk I O ...oals for tuning the library cache. View the sizes of all SGA structures by using the V$SGASTAT view. Determine the percentage of parse calls that find a cursor to share by using the GETHITRATIO column of the V$LIBRARYCACHE view. Determine the reloads-to-pins ratio by using the V$LIBRARYCACHE view. Compute the amount of sharable memory that has been used by using the V$SQLAREA view. Keep a  more...

Oracle9i Database Admin Manage an Instance ... 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. • Identify the stages in processing a query and the memory structures used in query processing. • Identify the steps of DML processing and the memory  more...

Oracle 9i New Features Database Administration ... Identify the benefits of the dynamic SGA feature. Identify the characteristics of the dynamic SGA components. Match the database parameters with their buffer cache sizing attributes. Identify the features of Oracle Managed Files. Identify the operational considerations of  more...

Oracle8 Backup and Recovery - Strategies and Backups ...racle memory structures. Identify the components of the SGA. Identify the functions of the key Oracle background processes. Match the key Oracle file structures with their characteristics. Unit 2: Database Archiving Duration: 1 - 2 Hour(s) Identify the implications of operating an Oracle database in Noarchivelog mode. Identify the characteristics of running a database in  more...

Oracle8i Database Admin Manage an Instance .... Match the memory structures of the System Global Area (SGA) with the information stored by them. Match the mandatory background processes with their functions. Match the different types of files existing in a database with the information stored in them. Match the non-database files with the information stored in them. Sequence the stages in processing a query. Identify the combinations  more...