Online Database 11g Release eLearning

Oracle Database 11g R2 Database Diagnostics Flashsback Technologies ...diagnosing data failures and recovering from them. Oracle Database 11g Release 2 provides the Data Recovery Advisor which eases this task by automatically detecting errors when they occur and providing repair advice. The use of the Automatic Diagnostic Repository can also be used, which holds diagnostic information about critical error events. Flashback technology can be used when a logical  more...

Oracle Database 11g R2 Installation Oracle Restart ...11g R2: Installation & Oracle Restart Oracle Oracle Database 11g Release 2 offers a unique scale-out technology with a single database instance, lower server and storage costs, and increased availability and scalability. It also provides customers with improved user service levels, reduced down-time, and more efficient use of IT resources as well as an increased level of performance and  more...

Oracle Database 11g R2 ASM Storage Partitioning Enhancements ..., Storage & Partitioning Enhancements Oracle Oracle Database 11g Release 2 provides many improvements from its previous releases. This includes enhancements to ASM and storage to improve performance and to reduce server maintenance down time. This course identifies the enhancements in each of these areas. It also demonstrates how to use ASM fast mirror resync, manage ASM users, disk  more...

Oracle Database 11g R2 Oracle Partioning Security Features ...Oracle Partioning & Security Features Oracle Oracle Database 11g Release 2 offers more advanced data warehouse, partitioning, security and network feature enhancements to allow the DBA to provide a more efficient way for users to access data in a secure environment. This course covers the enhanced data warehouse and partition enhancements, which includes support for loading data stored in  more...

Oracle Database 11g R2 Using Change Management Solutions ...R2: Using Change Management Solutions Oracle Oracle Database 11g Release 2 is designed for data center environments that are rapidly evolving and changing to keep up with business demands, enabling DBAs to manage change effectively and efficiently. Oracle Database 11g Release 2 offers significant advances in the areas of automatic diagnostics, supportability, and change management. It can  more...

Oracle Database 11g R2 Intelligent Infrastructure Enhancements ...telligent Infrastructure Enhancements Oracle Oracle Database 11g Release 2 offers new intelligent infrastructure features to aid DBAs by automatically gathering performance metrics for problem detection and self-tuning purposes. The information gathered can be viewed by the DBA using either reports or views, as well as the alert log. Oracle Database 11g has expanded features for automatic  more...

Oracle Database 11g R2 Diagnosability Enhancements ...e 11g R2: Diagnosability Enhancements Oracle Oracle Database 11g Release 2 offers new diagnosability enhancements to help DBAs in diagnosing, resolving, and preventing problems. These new features include enhancements to problem and incident identification, running health checks, and performing repairs on SQL statements. These features enables the DBA to quickly and efficiently diagnose  more...

Oracle Database 11g R2 SQL Monitoring Performance Enhancements ...Monitoring & Performance Enhancements Oracle 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  more...

Oracle Database 11g R2 Application Performance Enhancements ... Application Performance Enhancements Oracle 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  more...

Oracle Database 11g R2 Backup Recover Archive Repair Data ...ackup, Recover, Archive & Repair Data Oracle Oracle Database 11g Release 2 offers new and improved features to ensure for continuous data access, even during unplanned failures and scheduled maintenance tasks. New RMAN features make it easier to backup, recover and duplicate databases in a timely manner while minimizing data loss. It also offers Flashback technology, giving DBAs  more...

Oracle Database 11g R2 Oracle Scheduler Secure Backup ... R2: Oracle Scheduler & Secure Backup Oracle 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  more...

Oracle Database 11g R2 Database Architecture Installation ...entifies the major architectural components of the Oracle Database 11g Release 2, explains memory structures, describes background processes, and explores the logical and physical storage structures. In addition, this course describes the role of a database administrator (DBA) and the tasks and tools required for this role. This course also covers how to plan for the Oracle Grid Infrastructure  more...

Oracle Database 11g R2 Database Creation Instance Management Oracle Database 11g R2: Database Creation & Instance Management Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 As an Oracle Database administrator, it is important to plan the database to ensure that the database software is installed properly. Planning involves the logical storage structure, the overall design,  more...

Oracle Database 11g R2 The ASM Instance Network Connectivity ...ase 11g: Administration Workshop I Release 2 Oracle Database 11g Release 2 offers Automatic Storage Management (ASM), which eliminates the need for many tasks that are required on a non-ASM storage environment by the DBA. Some of these tasks include I/O performance tuning, file system, cluster file system, and raw device management, and data file movements and reorganizations. When ASM is  more...

Oracle Database 11g R2 Storage Structures User Security Oracle Database 11g R2: Storage Structures & User Security Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 An Oracle database is divided into logical storage units called tablespaces. Oracle also provides Oracle-Managed Files (OMF), which eliminate the need for the DBA to directly manage the operating system files  more...

Oracle Database 11g R2 Managing Concurrency Undo Auditing ...ase 11g: Administration Workshop I Release 2 Oracle Database 11g Release 2 is designed to prevent multiple users from changing the same data at the same time by implementing locks. These locks are used to manage data concurrency and are implemented automatically, which can sometimes cause lock conflicts. Lock conflicts can be detected and managed through Enterprise Manager or SQL  more...

Oracle Database 11g R2 Managing Database Maintenance Performance ...s made easy by the sophisticated infrastructure of Oracle Database 11g Release 2, including elements such as Automatic Workload Repository (AWR) and database health checkers. DBAs must make sure that databases are open and available to users when they need it and that it is working without bottlenecks by gathering performance metrics. This course explores how to specify, review, and maintain  more...

Oracle Database 11g R2 Backup Recovery Oracle Database 11g R2: Backup & Recovery Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 Preparing for and performing data recovery and completing database backups are expected job duties of an Oracle Database 11g Database Administrator (DBA) to ensure that the database is available for users when they require it.  more...

Oracle Database 11g R2 Moving Data Oracle Support ...ime to time Oracle DBAs are required to move data. Oracle Database 11g Release 2 offers various ways to complete this task, including Oracle Data Pump, SQL*Loader, and the use of external tables. DBAs are also required to ensure that the database is up-to-date with the latest patches and that critical errors are resolved, which includes contacting Oracle for support. This course explores how to  more...

1Z0-052 ORACLE DATABASE 11G ADMINISTRATION WORKSHOP I R2 1Z0-052 ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP I R2 Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2  more...