Oracle Database 11g: Diagnosing the Database and Managing Memory
To identify the steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and also for enabling ...
Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor
recognize the steps for detecting, diagnosing, and repairing critical errors and data failures in Oracle Database 11g, using its enhanced, proactive, diagnostic tools, such as Automatic Diagnostic ...
Oracle Database 11g: Encryption Concepts
All encryption has two parts: an algorithm, which is a procedure or a method of manipulating data, and a key or a secret that allows data to be decrypted. This course discusses the issues and ...
Oracle Database 11g: Enterprise User Security and Proxy Authentication
Enterprise User Security addresses the user, the administrative, and the security challenges by centralizing storage and management of user-related information in a Lightweight Directory Access ...
Oracle Database 11g: Execution Plans and Star Transformations
An execution plan is the output of the optimizer and is presented to the execution engine for implementation. The execution plan instructs the execution engine about the operations it must perform ...
Oracle Database 11g: Firewalls, Oracle Connection Manager, and SQL*Plus Security
There is no single best architecture for accommodating Internet requests requiring access to corporate intranets. Instead, trade-offs must be made between two competing goals – ...
Oracle Database 11g: Getting Started With PL/SQL
To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and ...
Oracle Database 11g: Globalization
To recognize the steps for utilizing Oracle Database 11g's globalization support features to ensure that information and data is displayed in a user's native language, and that territory and ...
Oracle Database 11g: High Availability in RAC
In Oracle Database 11g, RAC and Data Guard together provide the benefits of system-level, site-level, and data-level protection, resulting in high levels of availability and disaster recovery without ...
Oracle Database 11g: Indexes, Access Paths, and Join Operations
Access paths are the ways in which data is retrieved from the database, and there are a number of different access paths which can be used for tables and indexes. This course explores the access ...