Managed Services Subject Matter Expert (CA) Next Step Systems US-CA-San Ramon Post A Job | Post A Resume

11g Central

Oracle 11g database articles, tutorials and training for Database Administrators (DBAs)

Oracle 11g Administration

Database administration, Materialized Views, Database Migration, Replication, Automatic Storage Management (ASM)

Oracle's ADR Command Interpreter (ADRCI) – Part 3 : Oracle's new ADR with command interface shows promise for DBAs to quickly investigate diagnostic information.

Oracle's ADR Command Interpreter (ADRCI) – Part 2 : Oracle's new ADR with command interface shows promise for DBAs to quickly investigate diagnostic information.

Oracle’s ADR Command Interpreter – Part I : Oracle’s new ADR with command interface shows promise as a way for DBAs to quickly investigate diagnostic information.

Looking at Memory Usage for Oracle Processes : When an Oracle instance starts, or an application uses the Oracle database, the associated Oracle processes are allocated and consume memory. Learn how to use the V$PROCESS view and V$PROCESS_MEMORY to look at this memory usage.

Oracle Database 11g – Common Background Processes : To understand Oracle background processes is to understand how Oracle works--offering opportunity to tune effectively. Learn about the processes that are typically running after a fresh, common, and basic installation.

Oracle Indexing - What, Where, When? : If you are new to databases, or perhaps new to Oracle, you may find the discussion on indexes and indexing strategy complicated. Don't fret. To get started it's fairly straightforward, and as long as you pay attention to the options relevant to day-to-day DBA needs, it should remain fairly simple.

Oracle 11g Real Application Clusters (RAC)

Oracle RAC 64 bit for Windows: Preparing the Virtual environment : Part 4 of this series covers installing Oracle 11g RAC on a 64 bit Windows system using Windows 2003 Service Pack 2.

Open Source Virtualization: Oracle VM Manager Installation : Part three of this series covers how to install the Oracle VM Manager on your Workstation skeleton.

Open Source Virtualization: Oracle VM enters the Virtualization arena : Part 2 of this series covers downloading Oracle VMServer, VM Manager and VM Source Files, converting the Oracle VM files into ISO files, creating an ESX compatible skeleton and installing the Oracle VM.

Installing Oracle 11g RAC on VMware ESX 3i - Part1 : This article covers installing Oracle 11g RAC on the VMware workstation in ESX 3.x compatibility mode, in anticipation of the release of ESX 3i.

Using Orion Calibration to check I/O numbers : Orion is an I/O metrics testing tool, designed specifically to simulate the I/O workload before installing Oracle RAC on the hardware. It is ideal for capacity planning and checking DAS, SAN or NAS storage. Read on to learn more.

Oracle 11g Performance Features

Oracle Database 11g: Adaptive Cursor Sharing : This article discusses a new Oracle Database 11gR1 feature - Adaptive Cursor Sharing - and illustrates how to use it in practical situations to limit hard parsing of SQL statements with bind variables while increasing the relative execution efficiency of those statements.

Oracle Database 11g: PLSQL and OCI Result Set Caching : Oracle Database 11gR1 offers several new performance enhancements that limit "round trips" between database server, application servers, and applications when the identical data is required. The final article in this series explores how the latest release of Oracle extends the ability to cache result sets to applications and PL/SQL functions.

Oracle Database 11g: SQL Query Result Set Caching : This article - the first in this series - delves into how the result set from a SQL query result set can be retained in the database's Shared Pool for later access by a similar or identical query in the immediate future.

Oracle Database 11g: Database Replay, Part 3 : The final article in this series illustrates how to use Oracle Database 11gR1's new Database Replay (DBR) features to capture and prepare a workload from a current Oracle 10gR2 single-instance database environment and then replay that identical workload in an Oracle 11gR1 Real Application Clusters (RAC) testing environment.

Oracle Database 11g: Database Replay, Part 2 : Part 2 of this series - demonstrates how Oracle 11g Database Replay can be used to capture and prepare a workload from a current Oracle 11g production database environment (P+0) and then replay that identical workload in an Oracle 11g testing environment that represents the next iteration (P+1) of the database system.

Oracle Database 11g: Database Replay, Part 1 : This article provides a primer for using Oracle 11g Database Replay to effectively predict the performance of rapidly changing applications within increasingly fluid database environments.

Oracle Database 11g: SQL Plan Management, Part 3 : The final article in this series illustrates how to use SPM to limit unexpected regression of existing SQL statement performance before those statements first encounter Oracle 11g’s cost-based optimizer.

Oracle Database 11g: SQL Plan Management, Part 2 : Part 2 of this series explains how SQL Plan Management can be used during the upgrade of an existing Oracle 10gR2 database to an Oracle 11g environment, as well as during the deployment of brand new application code, to effectively limit unexpected regression of SQL statement performance.

Oracle Database 11g: SQL Plan Management, Part 1 : This article - the first in this series - provides a primer to SQL Plan Management principles and offers a simple demonstration of its performance tuning capabilities.

Oracle Database 11g: SQL Performance Analyzer, Part 3 : This article - the final one in this series- explores how the SQL Performance Analyzer can effectively analyze changes in SQL statement performance due to modified database initialization parameters.

Oracle Database 11g: SQL Performance Analyzer, Part 2 : This article - the next in a series on new Oracle Database 11g SQL performance improvement features - discusses how to use the SQL Performance Analyzer to evaluate a SQL workload generated from an Oracle 10gR2 database to detect potential performance issues for that workload if it were executed within an Oracle 11g database system.

Oracle Database 11g: SQL Performance Analyzer, Part 1 : This article – the first in a series on new Oracle Database 11g SQL performance improvement features – reviews how to set up and utilize these features and provides a simple simulation of how SQL Performance Analyzer can detect changes to an Oracle 11g database system.

Oracle 11g Tools, Features and Enhancements

New tools, features and enhancements in Oracle 11g.

Oracle Database 11g: Automatic SQL Tuning : This article delves into a new Oracle Database 11g feature that significantly extends this powerful 10g feature by providing the ability to implement improved execution plans automatically within DBA-specified boundaries.

Oracle Database 11g Release 1 New Features Summary, Part 2 : Oracle Database 11g Release 1 was launched in mid-July 2007. This second article in a two-part series takes some tantalizing glimpses into the upcoming improvements to database performance and database management that expand even further the revolutionary concepts introduced in Oracle Database 10g.

Oracle Database 11g Release 1 New Features Summary, Part 1 : Oracle Database 11g Release 1 (11gR1) is due to be released in July 2007. Although not all new features have been fully documented yet, this article - the first in this series - takes some tantalizing glimpses into the upcoming improvements to database performance and management.

Previous versions of Oracle Database:
10g Central
9i Central
8i Central

If you have an interesting column / article / short note etc., that you would like to share with the rest of the DBA world, please send it to webmaster@dbasupport.com.

Back to DBAsupport.com