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

EDITOR PICKS

POPULAR POSTS

Hello world!

New Features For Administrators OCP Exam Articles

Miscellaneous Articles

POPULAR CATEGORY

©