Oracle 11g Articles

 

Oracle Database 11g: New Features For Administrators OCP Exam Articles

The articles in this section are specifically targeted at the 1Z0_050 Oracle Database 11g: New Features for Administrators OCP upgrade exam.

Adaptive Cursor Sharing in Oracle Database 11g Release 1
Overcome the problems associated with using bind variables against indexed columns containing skewed data.

Automated Database Maintenance Task Management in Oracle Database 11g Release 1
Reduce the impact of automated maintenance tasks on your system by controlling how and when they run.

Automatic Diagnostic Repository (ADR) in Oracle Database 11g Release 1
Learn how to manage database diagnostic information from Oracle 11g onward.

Automatic Memory Management in Oracle Database 11g Release 1
Oracle 11g takes the next step down the road to making manual memory management a thing of the past.

Automatic SQL Tuning in Oracle Database 11g Release 1
Take advantage of the Automatic SQL Tuning features of Oracle 11g Release 1.

Automatic Storage Manager (ASM) Enhancements in Oracle Database 11g Release 1
This article provides an overview of the main Automatic Storage Manager (ASM) enhancements in Oracle Database 11g Release 1.

AWR Baseline Enhancements in Oracle Database 11g Release 1
Oracle 11g has extended the AWR baseline functionality and made alert threshold creation more flexible.

Case Sensitive Passwords in Oracle Database 11g Release 1
Understand the implications and administration of this new security feature in Oracle 11g.

Cross-Session PL/SQL Function Result Cache in Oracle Database 11g Release 1
Improve the performance of PL/SQL functions across the whole database instance by caching return values.

Database Replay in Oracle Database 11g Release 1
Capture workloads on a production system and replay them exactly as they happened on a test system.

Database Resident Connection Pool (DRCP) in Oracle Database 11g Release 1
Use the database resident connection pool to reduce the resource requirements of applications that do not support connection pooling.

Data Recovery Advisor in Oracle Database 11g Release 1
Automatically identify, diagnose and repair corruption or loss of persistent data on disk using this new feature.

DDL With the WAIT Option (DDL_LOCK_TIMEOUT)
Avoid unnecessary “ORA-00054: resource busy” errors in 11g.

Fine-Grained Access to Network Services in Oracle Database 11g Release 1
Take control of the external services accessed by the UTL_TCP, UTL_INADDR, UTL_HTTP, UTL_SMTP, and UTL_MAIL packages.

Finer Grained Dependency Management in Oracle Database 11g Release 1
See how finer grained dependency management in 11g reduces the extent of invalidations associated with schema changes.

Flashback and LogMiner Enhancements in Oracle Database 11g Release 1
See how Oracle 11g Release 1 makes tracking data changes and recovering from logical errors easier because of enhancements to Flashback and LogMiner.

Invisible Indexes in Oracle Database 11g Release 1
Take control of the indexes available to the optimizer by using invisible indexes in 11g.

Miscellaneous New Features in Oracle Database 11g Release 1
A collection of new features and enhancements listed in the miscellaneous section of “Oracle Database 11G: New Features for Administrators” OCP syllabus.

Online Table Redefinition (DBMS_REDEFINITION) Enhancements in Oracle Database 11g Release 1
Take advantage of the reduced invalidations associated with online table redefintions in 11g.

Partitioning Enhancements in Oracle Database 11g Release 1
An introduction to the partitioning enhancements in Oracle 11g Release 1.

Query Result Cache in Oracle Database 11g Release 1
Improve the performance of SQL across the whole database instance by caching query results.

Read-Only Tables in Oracle Database 11g Release 1
Protect data in static tables using the read-only table feature in Oracle 11g Release 1.

Resource Manager Enhancements in Oracle Database 11g Release 1
An overview of the resource manager enhancements in Oracle Database 11g Release 1.

RMAN Enhancements in Oracle Database 11g Release 1
An overview of all the RMAN enhancements in Oracle Database 11g Release 1.

Scheduler Enhancements in Oracle Database 11g Release 1
Oracle 11g adds more functionality to the Oracle scheduler.

SecureFiles in Oracle Database 11g Release 1
Compress, deduplicate and encrypt LOBs using the new LOB functionality in Oracle 11g.

SQL Access Advisor in Oracle Database 11g Release 1
Use this advisor to get suggestions for indexes, materialized views and partitioning schemes to improve system performance.

SQL Performance Analyzer in Oracle Database 11g Release 1
Compare the performance of the statements in a SQL tuning set before and after database changes.

SQL Plan Management in Oracle Database 11g Release 1
Maintain consistent SQL performance regardless of changes in optimizer version, optimizer statistics, schema changes, system settings and SQL profile creation.

Statistics Collection Enhancements in Oracle Database 11g Release 1
Provide the optimizer with additional selectivity information and avoid new statistics adversely affecting performance.

Table Compression Enhancements in Oracle Database 11g Release 1
Save space and improve performance of OLTP systems using the enhanced table compression in 11g.

Tablespace Encryption in Oracle Database 11g Release 1
Simplify the administration of transparent data encryption (TDE) using tablespace encryption.

Temporary Tablespace Enhancements in Oracle Database 11g Release 1
Take advantage of better visibility and management of temporary tablespaces usage in 11g.

Upgrading to Oracle Database 11g
This article provides a brief overview of the areas involved in upgrading existing databases to Oracle 11g.

Feature List:

 

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.

Automatic Database Diagnostic Monitor (ADDM) Enhancements in Oracle Database 11g Release 1
Management and reporting of ADDM tasks has been simplified in Oracle Database 11g with the introduction of the DBMS_ADDM package.

Automatic Subprogram Inlining in Oracle Database 11g Release 1
Automatic subprogram inlining can reduce the overheads associated with calling subprograms, whilst leaving your original source code in its normal modular state.

CONTINUE Statement in Oracle Database 11g Release 1
The CONTINUE statement has finally been added to PL/SQL in Oracle 11g, allowing you to jump out of the current iteration of a loop.

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:

 

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_COMPRESSION : Estimate the Potential Benefits of Table Compression
Use the DBMS_COMPRESSION package to estimate the benefits of table compression.

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.

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 11g Release 2
This article contains an example of setting up a physical standby database for Oracle 11gR2 using the Data Guard Broker.

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 Redefinition in Oracle Database 11g Release 2
Upgrade database components online using this new feature or Oracle Database 11g Release 2.

Extended Statistics Enhancements in Oracle Database 11g Release 2
Gathering extended statistics for column groups is now easier in Oracle Database 11g Release 2.

Instance Caging to Manage CPU Usage in Oracle Database 11g Release 2
Control CPU usage when consolidating multiple databases on to a single server.

Oracle Database File System (DBFS) in Oracle Database 11g Release 2
This article provides an overview of the Oracle Database File System (DBFS) introduced in Oracle Database 11g Release 2.

Oracle Database File System (DBFS) PL/SQL APIs
This article provides an overview of the Oracle Database File System (DBFS) PL/SQL APIs introduced in Oracle Database 11g Release 2.

Oracle Database 11g Release 2 Data Guard Setup using Oracle Grid Control
This article describes the creation of a standby database using Oracle Database 11g Release 2 and the Oracle Grid Control.

Recursive Subquery Factoring : Hierarchical Queries Using Recursive WITH Clauses
This articles gives an overview of how to query hierarchical data in Oracle databases using recursive subquery factoring.

Remote Scheduler Agent Installation for Oracle 11g Release 2
An overview of the installation of the Remote Scheduler Agent for Oracle 11g Release 2.

Segment Creation on Demand (Deferred Segment Creation) in Oracle Database 11g Release 2
Save space when creating new tables containing no rows in Oracle Database 11g Release 2.

Scheduler Enhancements in Oracle Database 11g Release 2
Oracle 11gR2 adds more functionality to the Oracle scheduler.

UTL_MATCH : String Matching by Testing Levels of Similarity/Difference
Use the UTL_MATCH package to determine the similarity between two strings.

 

Oracle Database 11g Release 1 Installations

Oracle Database 11g Release 1 (11.1) Installation On Oracle Linux 4 and 5
A brief guide to installing Oracle Database 11g Release 1 (11.1) on Oracle Linux 4 and 5.

Oracle Database 11g Release 1 (11.1) Installation On Fedora 7
A brief guide to installing Oracle Database 11g Release 1 (11.1) on Fedora 7.

Oracle Database 11g Release 1 (11.1) Installation On Fedora 8
A brief guide to installing Oracle Database 11g Release 1 (11.1) on Fedora 8.

Oracle Database 11g Release 1 (11.1) Installation On Fedora 9
A brief guide to installing Oracle Database 11g Release 1 (11.1) on Fedora 9.

Oracle Database 11g Release 1 (11.1) Installation On Fedora 10
A brief guide to installing Oracle Database 11g Release 1 (11.1) on Fedora 10.

Oracle Database 11g Release 1 (11.1) Installation On Fedora 11
A brief guide to installing Oracle Database 11g Release 1 (11.1) on Fedora 11.

Oracle Database 11g Release 1 RAC On Linux Using NFS
This article describes the installation of Oracle Database 11g release 1 (11.1) RAC on Linux (Oracle Linux 5) using NFS to provide the shared storage.

Oracle Database 11g Release 1 RAC On RHEL5 Linux Using VMware ESX Server and NFS
This article describes the installation of Oracle Database 11g release 1 (11.1) RAC on Red Hat Enterprise Linux 5 using VMware ESX Server and NFS for shared storage.

Oracle Database 11g Release 1 RAC On Linux Using VMware Server 1.x
This article describes the installation of Oracle Database 11g release 1 (11.1) RAC on Linux (Oracle Linux 5) using VMware Server 1.x with no additional shared disk devices.

Oracle Database 11g Release 1 RAC On Linux Using VMware Server 2
This article describes the installation of Oracle Database 11g release 1 (11.1) RAC on Linux (Oracle Linux 5) using VMware Server 2 with no additional shared disk devices.

Oracle Database 11g RAC On Windows 2003 Using VMware Server
This article describes the installation of Oracle Database 11g release 1 (11.1) RAC on Windows 2003 Server Standard Edition using VMware Server with no additional shared disk devices.

 

Oracle Database 11g Release 2 Installations


DNS Configuration for the SCAN used with Oracle RAC Database 11g Release 2
A basic description of the DNS configuration required for the SCAN associated with an Oracle RAC database in 11g Release 2.

Oracle Database 11g Release 2 RAC On Linux Using NFS
This article describes the installation of Oracle Database 11g Release 2 (11.2) RAC on Linux (Oracle Linux 5) using NFS to provide the shared storage.

Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 5
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Oracle Linux 5.

Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Oracle Linux 6.

Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 7
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Oracle Linux 7.

Oracle Database 11g Release 2 (11.2) Installation On Fedora 12 (F12)
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 12 (F12).

Oracle Database 11g Release 2 (11.2) Installation On Fedora 13 (F13)
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 13 (F13).

Oracle Database 11g Release 2 (11.2) Installation On Fedora 14 (F14)
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 14 (F14).

Oracle Database 11g Release 2 (11.2) Installation On Fedora 15 (F15)
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 15 (F15).

Oracle Database 11g Release 2 (11.2) Installation On Fedora 16 (F16)
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 16 (F16).

Oracle Database 11g Release 2 (11.2) Installation On Fedora 17 (F17)
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 17 (F17).

Oracle Database 11g Release 2 (11.2) Installation On Fedora 18 (F18)
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 18 (F18).

Oracle Database 11g Release 2 (11.2) Installation On Fedora 19 (F19)
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 19 (F19).

Oracle Database 11g Release 2 (11.2) Installation On Fedora 20 (F20)
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 20 (F20).

Oracle Database 11g Release 2 (11.2) Installation On Fedora 21 (F21)
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 21 (F21).

Oracle Database 11g Release 2 (11.2) Installation On Fedora 22 (F22)
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 22 (F22).

Oracle Database 11g Release 2 (11.2) Installation On Fedora 23 (F23)
A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 23 (F23).

Oracle Database 11g Release 2 (11.2.0.2) Installation On Solaris 10 (x86-64)
A brief guide to installing Oracle 11g Release 2 (11.2.0.2) on Solaris 10 (x86-64).

Oracle Database 11g Release 2 RAC On Oracle Linux 5.8 using VirtualBox
This article describes the installation of Oracle Database 11g Release 2 (11.2) RAC on Oracle Linux 5.8 using VirtualBox with no additional shared disk devices.

Oracle Database 11g Release 2 (11.2.0.3.0) RAC On Oracle Linux 6.3 using VirtualBox
This article describes the installation of Oracle Database 11g Release 2 (11.2.0.3) RAC on Oracle Linux 6.3 using VirtualBox with no additional shared disk devices.

Oracle Database 11g Release 2 RAC On Windows 2008 Using VirtualBox
This article describes the installation of Oracle Database 11g Release 2 (11.2) RAC on Windows 2008 Server Standard Edition using VirtualBox with no additional shared disk devices.

Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2
This article describes the installation of Oracle Database 11g release 2 (11.2) RAC on Linux (Oracle Enterprise Linux 5.4) using VMware Server 2 with no additional shared disk devices.

 

Oracle Grid Control 11g

OEM Grid Control 11gR1 Installation on Oracle Linux 5.5 (64-bit)
Learn how to install OEM Grid Control 11gR1 on Oracle Linux 5.5 (64-bit).

Grid Control 11g Agent Installation on HP Service Guard
This article describes the changes necessary to install a Grid Control 11g agent on a HP Service Guard package.

 

WebLogic Server 11g

An Oracle DBA’s Guide to WebLogic Server
An overview of WebLogic Server for beginners, especially DBA’s, who are new to middle tier administration.

Oracle WebLogic Server (WLS) 11gR1 (10.3.5 and 10.3.6) Installation on Oracle Linux 5 and 6
This article describes the installation of Oracle WebLogic Server (WLS) 11gR1 (10.3.5 and 10.3.6) on Oracle Linux 5 and 6.

WebLogic 11g Silent Installation
This article demonstrates how to perform a silent installation of WebLogic Server 11g on Oracle Linux.

Oracle Forms and Reports 11gR2 Installation on Oracle Linux 5
An overview of the installation of Oracle Forms and Reports 11gR2 on Oracle Linux 5.

Oracle Forms and Reports 11gR2 Installation on Oracle Linux 6
An overview of the installation of Oracle Forms and Reports 11gR2 on Oracle Linux 6.

Oracle Forms and Reports 11gR2 Silent Installation on Oracle Linux 6
An overview of the silent installation of Oracle Forms and Reports 11gR2 on Oracle Linux 6.

Oracle Forms and Reports Services 11gR2 Configuration Notes
This article is a collection of useful notes on a variety of topics related to configuration of Oracle Forms and Reports Services 11gR2.

Oracle WebLogic Server 11gR1 (10.3.5) Installation on Windows (32-bit)
An overview of the installation of Oracle WebLogic Server 11gR1 (10.3.5) on Windows (32-bit).

Oracle Forms and Reports 11gR2 Installation on Windows (32-bit)
An overview of the installation of Oracle Forms and Reports 11gR2 on Windows (32-bit).

Oracle WebLogic Server 11gR1 (10.3.6) Installation on Windows (64-bit)
An overview of the installation of Oracle WebLogic Server 11gR1 (10.3.6) on Windows (64-bit).

Oracle Forms and Reports 11gR2 Installation on Windows (64-bit)
An overview of the installation of Oracle Forms and Reports 11gR2 on Windows (64-bit).

WebLogic Server 11g : ADF Application Development Runtime Upgrade on Oracle Linux
This article describes the steps necessary to upgrade the ADF Application Development Runtime of a WebLogic Server 11g.

ADF 11g Silent Installation
This article demonstrates how to perform a silent installation of ADF 11g on Oracle Linux.

WebLogic Server 11g and 12cR1 : Create, Extend and Remove Domains
A quick overview of managing domains in WebLogic Server 11g and 12cR1.

WebLogic Server 11g and 12cR1 : Clustered Domains
Create clustered domains using Oracle WebLogic Server 11g and 12cR1.

Reset the AdminServer Password in WebLogic 11g and 12c
If you have forgotten the AdminServer password for your WebLogic 11g or 12c domain, you can reset it from the command line using the following process.

Create Self-Signed SSL Certificates
Notes on how to create self-signed SSL certificates using a variety of methods.

WebLogic Server 11g and 12c : Configure SSL for a Managed Server
This article descries how to configure SSL for WebLogic managed servers.

WebLogic Server 11g and 12c : Configure Active Directory Authentication
Use Active Directory (AD) for your application authentication in WebLogic Server 11g and 12c.

WebLogic Server 11g and 12c : Changing Heap Size and other Managed Server Start Arguments
A brief note to explain how to modify managed server start arguments on WebLogic Server 11g and 12c.

WebLogic : Database Access Descriptor (DAD) Configuration
Learn how to create a Database Access Descriptor (DAD) with the WebLogic Web Tier.

 

External 11g Links

Configuring HugePages on RHEL/Oracle Linux