Description: Oracle Database 11g Release 2 offers improvements to Oracle Scheduler that increases efficiency and usability. These include allowing users to get specific email notifications about job activities, triggering jobs to automatically execute when the specified file is received, enabling jobs to run on multiple nodes while managing it from a central location, and running PL/SQL on a remote database as a job. Oracle Database 11g Release 2 also offers backup to Amazon S3 through the Oracle Secure Backup module, this offers a low-cost database backup Web services storage option rather than maintaining a local backup infrastructure. This course demonstrates how to use Oracle Schedule to create email notifications, create file watchers and create and manage remote database and multiple destination jobs. It also discusses the Oracle Secure Backup Cloud module.
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
Duration: 01:00
Description: Oracle Database 11g Release 2 offers improved and new features to provide better application performance. It offers online table redefinition, which allows tables to be modified without affecting the availability of the table to users and does not affect any of its dependencies. This allows for easier application changes and improved query and DML performance. Application performance in Oracle Database 11g Release 2 is also improved by the use of adaptive cursor sharing, which allows for intelligent cursor sharing and the use of invisible indexes. It provides two different caches. The first cache includes SQL Query Result Cache used to cache query results or query blocks for future use, which reduces memory use and provides scalability. The second cache is the PL/SQL cross-section function result caching mechanism, which provides a language-supported and system-managed 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.
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; DBAs considering upgrading their systems to 11g
Duration: 01:00