Online Sga eLearning - Training Resources
Sga Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From 123-CBT Computer Based Training
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...
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...
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...
...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...
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...
.... 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...
Oracle8 Backup and Recovery - Strategies and Backups
...Oracle 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...
...Oracle 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...
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 combinations
more...
....
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...
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...
... 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...
From Serebra Learning Corporation
Manageability Enhancements in Oracle9i
To describe the manageability enhancements of an Oracle9i database Oracle database administrators; developers interested in the technical aspects of Oracle9i database
more...
To describe the manageability enhancements of an Oracle9i database Oracle database administrators; developers interested in the technical aspects of Oracle9i database
more...
Oracle Database 10g Performance Tuning Instance Tuning
This course covers the concepts related to tuning the shared pool and the buffer cache. This course also covers the concepts related to the System Global Area (SGA), Automatic Shared Memory Management (ASMM), the Program Global Area (PGA), and the PGA Target Advice. This course is designed for DBAs, database architects, support engineers, and technical consultants.
more...
This course covers the concepts related to tuning the shared pool and the buffer cache. This course also covers the concepts related to the System Global Area (SGA), Automatic Shared Memory Management (ASMM), the Program Global Area (PGA), and the PGA Target Advice. This course is designed for DBAs, database architects, support engineers, and technical consultants.
more...
Oracle 8i DBA - Oracle Server and Database Architecture
...ill introduce you to the concepts of Oracle instances and SGA components. You will learn to identify the memory structures and processes involved with an Oracle instance. You will be introduced to the Oracle Universal Installer and be able to explain the Optimal Flexible Architecture. This course will introduce you to the necessary components needed to implement a database server including user
more...
...ill introduce you to the concepts of Oracle instances and SGA components. You will learn to identify the memory structures and processes involved with an Oracle instance. You will be introduced to the Oracle Universal Installer and be able to explain the Optimal Flexible Architecture. This course will introduce you to the necessary components needed to implement a database server including user
more...
Oracle9i Performance Tuning: Managing Memory and Disk I/O
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database.
more...
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database.
more...
From Software Training Academy, Inc
Oracle 10g Administration
...ajor architectural components of Oracle10g, including the SGA, background processes and files that make up the physical database.
Use the Oracle data dictionary to to determine the structure and status of the database. This includes gaining a solid understanding of the purpose and content of many V$ and DBA-level views.
Create administrative users, including granting and using the
more...
...ajor architectural components of Oracle10g, including the SGA, background processes and files that make up the physical database.
Use the Oracle data dictionary to to determine the structure and status of the database. This includes gaining a solid understanding of the purpose and content of many V$ and DBA-level views.
Create administrative users, including granting and using the
more...
From JED New Media inc.
Modes de transmission de la formation
Ce JEDlet pr sente les diff rents modes de transmission de la formation afin de vous aider a trouver la combinaison gagnante dans la situation d apprentissage qui vous occupe. Il vous montrera que ce sont vos besoins de formation qui vous conduisent vers une solution technologique et non le contraire.
more...
Ce JEDlet pr sente les diff rents modes de transmission de la formation afin de vous aider a trouver la combinaison gagnante dans la situation d apprentissage qui vous occupe. Il vous montrera que ce sont vos besoins de formation qui vous conduisent vers une solution technologique et non le contraire.
more...
