Oracle Database 11g Release 2: Database Diagnostics and Flashback Technologies
Administering an Oracle database requires monitoring and diagnosing data failures and recovering from them. Oracle Database 11g Release 2 provides the Data Recovery Advisor which eases this task by ...
Oracle Database 11g Release 2: Diagnosability Enhancements
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 ...
Oracle Database 11g Release 2: Installation and Oracle Restart
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 ...
Oracle Database 11g Release 2: Intelligent Infrastructure Enhancements
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 ...
Oracle Database 11g Release 2: Managing Concurrency, Undo, and Auditing
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 ...
Oracle Database 11g Release 2: Managing Database Maintenance and Performance
General database maintenance and performance monitoring are important Oracle DBA tasks. Proactive and reactive database maintenance is made easy by the sophisticated infrastructure of Oracle Database ...
Oracle Database 11g Release 2: Managing Database Memory and Performance
Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must ...
Oracle Database 11g Release 2: Managing Database Resources and the Scheduler
By using the Database Resource Manager, you have more control over the allocation of machine resources than is normally possible through operating system resource management alone. Many tasks in the ...
Oracle Database 11g Release 2: Managing Database Space and Duplication
To effectively manage space, you can configure automatic management by the Oracle database server. This allows you to generate alerts about potential problems and recommend possible solutions. This ...
Oracle Database 11g Release 2: Moving Data and Oracle Support
From time 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 ...