Vi ste ovdje
Oracle Database 11g Release 2: SQL Monitoring and Performance Enhancements
Overview/Description
Oracle Database 11g Release 2 offers improvements and new features to provide DBAs a better way to monitor SQL commands in real-time and to allow the database to automatically manage its own memory and gather optimizer statistics. These features enable the DBA to ensure the optimal memory sizes are being used for the database using Automatic Memory Management, and that SQL statements are running properly by monitoring them in real-time using Enterprise Manager. It also offers a new feature to conceptually extend the buffer cache by using DB Smart Flash. This course demonstrates how to monitor SQL commands in real-time using SQL Monitoring, use Automatic Database Diagnostic Monitoring (ADDM), DB Smart Cache, gather and view different statistics for partitioned tables, hash-based sampling, multicolumn, and expressions, and use deferred statistics. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAâs considering upgrading their systems to 11g
Expected Duration (hours)
1.0
Lesson Objectivesmonitor the performance of SQL statements in real time
use Automatic Database Diagnostic Monitoring
use Automatic Memory Management
improve database performance by using DB Smart Flash Cache
use Optimizer Statistics
identify Oracle Database 11g R2s locking enhancements
utilize the Oracle Database 11g Release 2 performance enhancements and monitor SQL
Oracle Database 11g Release 2 offers improvements and new features to provide DBAs a better way to monitor SQL commands in real-time and to allow the database to automatically manage its own memory and gather optimizer statistics. These features enable the DBA to ensure the optimal memory sizes are being used for the database using Automatic Memory Management, and that SQL statements are running properly by monitoring them in real-time using Enterprise Manager. It also offers a new feature to conceptually extend the buffer cache by using DB Smart Flash. This course demonstrates how to monitor SQL commands in real-time using SQL Monitoring, use Automatic Database Diagnostic Monitoring (ADDM), DB Smart Cache, gather and view different statistics for partitioned tables, hash-based sampling, multicolumn, and expressions, and use deferred statistics. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAâs considering upgrading their systems to 11g
Expected Duration (hours)
1.0
Lesson Objectives
Oracle Database 11g Release 2: SQL Monitoring and Performance Enhancements
Trajanje:
1 h
Šifra:
od_onft_a07_it_enus
Katalog: