Oracle Database 11g Release 2: Oracle Partitioning and Security Features
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 ...
Oracle Database 11g Release 2: Oracle Scheduler and Secure Backup
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, ...
Oracle Database 11g Release 2: Performing Restore and Recovery Tasks
As a database administrator it is very important to understand how to restore and recover your database in the event of a loss of a file due to media, hardware, or user error. The restoration process ...
Oracle Database 11g Release 2: SQL Monitoring and Performance Enhancements
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 ...
Oracle Database 11g Release 2: Storage Structures and User Security
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 ...
Oracle Database 11g Release 2: The ASM Instance and Network Connectivity
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 ...
Oracle Database 11g Release 2: The RMAN Catalog and Creating Backups
RMAN uses a recovery catalog to store metadata about Oracle databases, and allows stored scripts to be used to run sequences of RMAN commands stored in the catalog. When administering an Oracle ...
Oracle Database 11g Release 2: Using Change Management Solutions
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 ...
Oracle Database 11g Release 2: Using, Monitoring and Tuning RMAN
Reconstructing the contents of all or part of a database from a backup typically involves two phases. The first phase is the retrieval of a copy of the data file from the backups. The second involves ...
Oracle Database 11g: Application Tracing and Automatic SQL Tuning
Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session ...