发现一个比较有意思的网站，http://www.oracle-base.com/articles/11g/articles-11g.php
Oracle 11g Articles
 |
Oracle Database 11g: New Features For Administrators OCP Exam Articles
The articles in this section are specifically targeted at the Oracle Database 11g: New Features for Administrators OCP upgrade exam.
- Overcome the problems associated with using bind variables against indexed columns containing skewed data.
- Reduce the impact of automated maintenance tasks on your system by controlling how and when they run.
- Learn how to manage database diagnostic information from Oracle 11g onward.
- Oracle 11g takes the next step down the road to making manual memory management a thing of the past.
- Take advantage of the Automatic SQL Tuning features of Oracle 11g Release 1.
- This article provides an overview of the main Automatic Storage Manager (ASM) enhancements in Oracle Database 11g Release 1.
- Oracle 11g has extended the AWR baseline functionality and made alert threshold creation more flexible.
- Understand the implications and administration of this new security feature in Oracle 11g.
- Improve the performance of PL/SQL functions across the whole database instance by caching return values.
- Capture workloads on a production system and replay them exactly as they happened on a test system.
- Use the database resident connection pool to reduce the resource requirements of applications that do not support connection pooling.
- Automatically identify, diagnose and repair corruption or loss of persistent data on disk using this new feature.
- Avoid unnecessary "ORA-00054: resource busy" errors in 11g.
- Take control of the external services accessed by the UTL_TCP, UTL_INADDR, UTL_HTTP, UTL_SMTP, and UTL_MAIL packages.
- See how finer grained dependency management in 11g reduces the extent of invalidations associated with schema changes.
- See how Oracle 11g Release 1 makes tracking data changes and recovering from logical errors easier because of enhancements to Flashback and LogMiner.
- Take control of the indexes available to the optimizer by using invisible indexes in 11g.
- A collection of new features and enhancements listed in the miscellaneous section of "Oracle Database 11G: New Features for Administrators" OCP syllabus.
- Take advantage of the reduced invalidations associated with online table redefintions in 11g.
- An introduction to the partitioning enhancements in Oracle 11g Release 1.
- Improve the performance of SQL across the whole database instance by caching query results.
- Protect data in static tables using the read-only table feature in Oracle 11g Release 1.
- An overview of the resource manager enhancements in Oracle Database 11g Release 1.
- An overview of all the RMAN enhancements in Oracle Database 11g Release 1.
- Oracle 11g adds more functionality to the Oracle scheduler.
- Compress, deduplicate and encrypt LOBs using the new LOB functionality in Oracle 11g.
- Use this advisor to get suggestions for indexes, materialized views and partitioning schemes to improve system performance.
- Compare the performance of the statements in an SQL tuning set before and after database changes.
- Maintain consistent SQL performance regardless of changes in optimizer version, optimizer statistics, schema changes, system settings and SQL profile creation.
- Provide the optimizer with additional selectivity information and avoid new statistics adversely affecting performance.
- Save space and improve performance of OLTP systems using the enhanced table compression in 11g.
- Simplify the administration of transparent data encryption (TDE) using tablespace encryption.
- Take advantage of better visibility and management of temporary tablespaces usage in 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 OCP upgrade exam.
- This article provides an overview of the main Data Pump enhancements in Oracle Database 11g Release 1.
- Process a single transaction across multiple sessions using the DBMS_XA package.
- Present your exisitng PL/SQL procedures and functions as web services using XML DB in Oracle 11g.
- Learn how to use the new PIVOT and UNPIVOT operators 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.
- Get to grips with the new features and enhancements to PL/SQL in Oracle 11g Release 1.
- Monitor the performance of SQL queries while the are running.
- An overview of the SQL Repair Advisor, introduced in Oracle 11g.
- Learn about the enhancements to triggers 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
- Use the APPEND_VALUES hint to perform direct-path inserts when using the FORALL statement.
- This article describes the amendments to Automatic SQL Tuning features of Oracle 11g Release 2.
- This article describes three ways to create an ASM Cluster File System in an Oracle 11G Release 2 RAC database.
- Oracle 11gR2 allows better management of the audit trail using the DBMS_AUDIT_MGMT package.
- Use the DBMS_PARALLEL_EXECUTE package to break down large workloads into manageable chunks that can be run in parallel.
- Use this new DNFS feature of patchset 11.2.0.2 to clone databases from backups quicker than you ever have before.
- This article contains an example of setting up a physical standby database for Oracle 11gR2.
- This article summarizes the process of duplicating a database using the RMAN DUPLICATE command.
- Upgrade database components online using this new feature or Oracle Database 11g Release 2.
- Control CPU usage when consolidating multiple databases on to a single server.
- This article provides an overview of the Oracle Database File System (DBFS) introduced in Oracle Database 11g Release 2.
- This article provides an overview of the Oracle Database File System (DBFS) PL/SQL APIs introduced in Oracle Database 11g Release 2.
- This article describes the creation of a standby database using Oracle Database 11g Release 2 and the Oracle Grid Control.
- An overview of the installation of the Remote Scheduler Agent for Oracle 11g Release 2.
- Save space when creating new tables containing no rows in Oracle Database 11g Release 2.
- Oracle 11gR2 adds more functionality to the Oracle scheduler.
- Use the UTL_MATCH package to determine the similarity between two strings.
| |
Oracle Database 11g Release 1 Installations
- A brief guide to installing Oracle Database 11g Release 1 (11.1) on Oracle Linux 4 and 5.
- A brief guide to installing Oracle Database 11g Release 1 (11.1) on Fedora 7.
- A brief guide to installing Oracle Database 11g Release 1 (11.1) on Fedora 8.
- A brief guide to installing Oracle Database 11g Release 1 (11.1) on Fedora 9.
- A brief guide to installing Oracle Database 11g Release 1 (11.1) on Fedora 10.
- A brief guide to installing Oracle Database 11g Release 1 (11.1) on Fedora 11.
- 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.
- 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.
- 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.
- 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.
- 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
- A basic description of the DNS configuration required for the SCAN associated with an Oracle RAC database in 11g Release 2.
- 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.
- A brief guide to installing Oracle Database 11g Release 2 (11.2) on Oracle Linux 5.
- A brief guide to installing Oracle Database 11g Release 2 (11.2) on Oracle Linux 6.
- A brief guide to installing Oracle Database 11g Release 2 (11.2) on Oracle Linux 7.
- A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 12 (F12).
- A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 13 (F13).
- A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 14 (F14).
- A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 15 (F15).
- A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 16 (F16).
- A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 17 (F17).
- A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 18 (F18).
- A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 19 (F19).
- A brief guide to installing Oracle Database 11g Release 2 (11.2) on Fedora 20 (F20).
- A brief guide to installing Oracle 11g Release 2 (11.2.0.2) on Solaris 10 (x86-64).
- 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.
- 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.
- 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.
- 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
- Learn how to install OEM Grid Control 11gR1 on Oracle Linux 5.5 (64-bit).
- This article describes the changes necessary to install a Grid Control 11g agent on a HP Service Guard package.
| |
WebLogic Server 11g
- An overview of WebLogic Server for beginners, especially DBA's, who are new to middle tier administration.
- This article describes the installation of Oracle WebLogic Server (WLS) 11gR1 (10.3.5 and 10.3.6) on Oracle Linux 5 and 6.
- An overview of the installation of Oracle Forms and Reports 11gR2 on Oracle Linux 5.
- An overview of the installation of Oracle Forms and Reports 11gR2 on Oracle Linux 6.
- This article is a collection of useful notes on a variety of topics related to configuration of Oracle Forms and Reports Services 11gR2.
- An overview of the installation of Oracle WebLogic Server 11gR1 (10.3.5) on Windows (32-bit).
- An overview of the installation of Oracle Forms and Reports 11gR2 on Windows (32-bit).
- This article describes the steps necessary to upgrade the ADF Application Development Runtime of a WebLogic Server 11g.
- A quick overview of managing domains in WebLogic Server 11g and 12cR1.
- Create clustered domains using Oracle WebLogic Server 11g and 12cR1.
- 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.
- Notes on how to create self-signed SSL certificates using a variety of methods.
- This article descries how to configure SSL for WebLogic managed servers.
- Use Active Directory (AD) for your application authentication in WebLogic Server 11g and 12c.
- A brief note to explain how to modify managed server start arguments on WebLogic Server 11g and 12c.
| |