Oracle 11g database articles, tutorials and training for Database Administrators (DBAs)
Oracle 11g Development
Development Languages, Tables, Globalization, Ordering Events, SQL, SQL*Plus.
VMware and Oracle Setup Examples – Part 2
:
This installment of " VMware and Oracle Setup Examples" covers installing Oracle Enterprise Linux, connecting Windows to Windows and connections in general.
VMware and Oracle Setup Examples
:
With VMware at your
disposal, there is practically no reason you cannot gain experience on all of
the major operating systems supported by Oracle.
So what is an Oracle Nested Table?
:
James Koopmann takes some of the confusion out of Oracle nested tables with this step by step approach to create a table with a nested table.
Oracle 11g Data Guard: Grid Control Management
:
Oracle Database 11g offers several enhancements to the Oracle Data Guard feature set that helps an Oracle DBA to manage a complex, multi-database disaster recovery environment. This article explores how to set up Data Guard Broker for simpler configuration, monitoring and maintenance of Oracle 11g primary and standby databases.
Configuring Data Guard Broker
:
Oracle Database 11g offers several enhancements to the Oracle Data Guard feature set that helps an Oracle DBA to manage a complex, multi-database disaster recovery environment. This article explores how to set up Data Guard Broker for simpler configuration, monitoring and maintenance of Oracle 11g primary and standby databases.
Oracle 11g Data Guard: Building a Physical Standby Database
:
Oracle Database 11g expands disaster recovery features dramatically to include the capability to keep a standby database open for read-only queries
while still accepting change vectors from the primary database. Jim Czuprynski explains how to set up a standby database environment using Oracle 11g's new Recovery Manager features.
What’s in an Oracle Schema?
:
A fairly common question on Oracle Q&A forums is how to identify schemas within a database. Many times, a quite misleading answer is to query owner names from DBA_TABLES. This answer is only correct for those schemas (owners) who own tables.
Changing the Word Size in Oracle
:
Changing the word size in Oracle appears to be pretty simple, but this is one of those situations where doing some additional digging into support notes can alleviate to outright prevent some problems down the road. Read on to learn more...
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.
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
ADDM Enhancements in Oracle Database 11g
:
This article illustrates how Oracle Database 11gR1
has expanded ADDM to encompass Real Application Clusters (RAC) database tuning
at the global level and provided the ability to filter out previously
identified performance issues from any ADDM analysis report.
Intro to Oracle's Automatic Workload Repository (AWR)
:
Oracle's Automatic Workload Repository improves quite a lot on the previous statspack;
it installs automatically, has some fairly reasonable default settings, and brings us
Active Session History as well. Read on to learn more...
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’s Flashback Query – TIMESTAMP or SCN?
:
Oracle’s
Flashback Query(SQL-driven) makes use of both TIMESTAMP and SCN--but which
should you use? It just may be a matter of preference but requires some
thoughtful considerations.
Oracle’s Flashback Query – Should you unset _in_memory_undo?
:
The benefits of Oracle's Flashback Query are well documented--but with minor nuances of parameters such as _in_memory_undo, how much should you really buy into them? James Koopmann takes a deeper look at the _in_memory_undo parameter and how it effects flashback query.
Oracle 11g's Transparent Data Encryption Security Feature
:
A crucial reason for upgrading the storage capabilities of Large Objects (LOBs) is the ever-expanding requirements for data security within an Oracle 11g database. This article - the last in this three-part series - investigates how to extend Transparent Data Encryption (TDE) security features to LOBs and tablespaces to secure data, and explains how these features enable improved security...
How to Migrate from BasicFiles to SecureFiles Storage
:
This article - second in a three-part series - explores how to migrate most efficiently from BasicFiles to SecureFiles storage, how to measure the relative storage efficiency of SecureFile vs. BasicFile LOBs, and how to utilize the different compression and deduplication options for SecureFile LOBs.
SecureFiles in Oracle Database 11g
:
With the introduction of SecureFiles, Oracle Database 11g dramatically expands
the storage capabilities for Large Objects (LOBs) within an Oracle database. This
article – the first in a two-part series – discusses how LOBs have expanded
their domain within databases over the past decade, looks at several potential
future uses for LOBs, and introduces the new SecureFile LOB object model.
Oracle Database 11g: Flashback Transaction Backout
:
Oracle Database 10g offered two new Flashback features that allowed an authorized user to see all versions of any changes made to one or more rows in a table. Database 11gR1 provides the ability to back out one or more independent or dependent transactions with Flashback Transaction Backout.
Oracle Database 11g: Flashback Data Archives
:
Oracle Database 11gR1 offers an intriguing new Flashback feature - Flashback Data Archives - that allows an Oracle DBA to preserve a record of all changes to any table for a definite period of time.
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.
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.
