Oracle Database 11g Release 1: Miscellaneous Articles
The articles in this section are about new features that are NOT included in the 1Z0_050 OCP upgrade exam.
Data Pump Enhancements in Oracle Database 11g Release 1 - This article provides an overview of the main Data Pump enhancements in Oracle Database 11g Release 1.
DBMS_XA - Process a single transaction across multiple sessions using the DBMS_XA package.
Native Oracle XML DB Web Services in Oracle 11g Release 1 - Present your exisitng PL/SQL procedures and functions as web services using XML DB in Oracle 11g.
PIVOT and UNPIVOT Operators in Oracle Database 11g Release 1 - Learn how to use the new PIVOT and UNPIVOT operators in Oracle Database 11g Release 1.
PL/SQL Hierarchical Profiler in Oracle Database 11g Release 1 - Use the DBMS_HPROF package and the plshprof utility to generate and analyze hierarchical profiler data for PL/SQL programs.
PL/SQL New Features and Enhancements in Oracle Database 11g Release 1 - Get to grips with the new features and enhancements to PL/SQL in Oracle 11g Release 1.
Real-Time SQL Monitoring using DBMS_SQLTUNE (REPORT_SQL_MONITOR, REPORT_SQL_MONITOR_LIST and REPORT_SQL_DETAIL) - Monitor the performance of SQL queries while the are running.
SQL Repair Advisor in Oracle 11g - An overview of the SQL Repair Advisor, introduced in Oracle 11g.
Trigger Enhancements in Oracle Database 11g Release 1 - Learn about the enhancements to triggers in Oracle Database 11g Release 1.
Virtual Columns in Oracle Database 11g Release 1 - Use virtual columns to make derived data appear as columns in your tables in Oracle 11g Release 1.
Feature List:
| Automatic Subprogram InliningCompiler WarningCONTINUEDBMS_XAData Pump EnhancementsDynamic SQLGeneralized InvocationHierarchical Profiler | Native CompilationNative XML DB Web ServicesNotationPIVOTPL/ScopeReal-Time SQL MonitoringRegular ExpressionsSequences | SIMPLE_INTEGERSnapshot StandbySQL Repair AdvisorTriggersUNPIVOTVirtual Columns |
Oracle Database 11g Release 2: Miscellaneous Articles
APPEND_VALUES Hint in Oracle Database 11g Release 2 - Use the APPEND_VALUES hint to perform direct-path inserts when using the FORALL statement.
Automatic SQL Tuning in Oracle Database 11g Release 2 (DBMS_AUTO_SQLTUNE) - This article describes the amendments to Automatic SQL Tuning features of Oracle 11g Release 2.
Oracle ASM Cluster File Systems (ACFS) in Oracle Database 11g Release 2 - This article describes three ways to create an ASM Cluster File System in an Oracle 11G Release 2 RAC database.
Auditing Enhancements (DBMS_AUDIT_MGMT) in Oracle Database 11g Release 2 - Oracle 11gR2 allows better management of the audit trail using the DBMS_AUDIT_MGMT package.
DBMS_PARALLEL_EXECUTE - Use the DBMS_PARALLEL_EXECUTE package to break down large workloads into manageable chunks that can be run in parallel.
Direct NFS (DNFS) CloneDB in Oracle Database 11g Release 2 (Patchset 11.2.0.2) - Use this new DNFS feature of patchset 11.2.0.2 to clone databases from backups quicker than you ever have before.
Data Guard Physical Standby Setup in Oracle Database 11g Release 2 - This article contains an example of setting up a physical standby database for Oracle 11gR2.
Duplicate a Database Using RMAN in Oracle Database 11g Release 2 - This article summarizes the process of duplicating a database using the RMAN DUPLICATE command.
Edition Based Re