Creating Dump Files in Oracle GoldenGate
In addition to performing replication, Oracle GoldenGate can also be used to dump the contents of a table into a formatted file, according to this DBA Support article.
Getting Started with Oracle GoldenGate
Steve Callan looks at the four steps involved in configuring Oracle GoldenGate and talks about what transpires within Oracle GoldenGate in terms of how data gets from the source database to the target database.
Understanding 4KB Sector Support for Oracle Files
An important decision that DBAs make when they are first creating a new Oracle database is what the standard database block size should be. Once the database is created, it is virtually impossible to change the standard block size without recreating the entire database. Read on to learn how to create tablespaces with different block sizes.
Configuring Oracle for Automatic Database Monitoring in 3 Easy Steps
The homegrown automatic monitoring of an Oracle Database can result in lost DBA hours and increased development costs. Oracle's Automatic Database Diagnostic Monitor (ADDM) is a more elegant way to monitor database performance automatically. This article will get you started by showing you how to configure ADDM.
Oracle Database 11g R2 RAC - The top 5 changes
The introduction of the Oracle Grid Infrastructure product essentially combines Automatic Storage Management (ASM) and Oracle Clusterware into the same oracle home and product. With this new configuration, five main changes have been incorporated into Oracle Database 11g RAC. Read on to learn more.
How to Monitor an Oracle Database Automatically
In the past, automatic monitoring of an Oracle database often resulted in DBAs developing a variety of scripts, scheduled to run against the database. Oracle's Automatic Database Diagnostic Monitor (ADDM) provides a more elegant way to monitor database performance automatically.
Fundamentals of Oracle GoldenGate
With all of the companies that Oracle Corp. has acquired of late, it’s getting to be a job to keep up with things. That being said, GoldenGate, is one of the products you’ll definitely want to be familiar with; it's still kind of under the radar, but it’s going to be big. Really big.
Finding performance problems using statistics
Statistics are at the core of determining whether your tuning efforts are working or if you still have a system that is suffering from performance problems. This article focuses on Oracle's performance method to give us a better understanding of how to tune a database with statistics.
Identifying and Evaluating I/O Bottlenecks in Oracle Database
Discover the wealth of I/O performance tuning information that Oracle 11gR2’s Automatic Workload Repository (AWR) reports provide, and learn how to use that information to determine if any I/O performance bottlenecks actually exist, and how to form initial hypotheses to resolve those bottlenecks within the database's underlying input/output (I/O) subsystem.
Oracle DBA: 5 Technologies You Can't do Without
Become complacent at your job and your job could be at risk. These days, an Oracle DBA needs to be adept in one or more areas of advanced database administration. Steve Callan discusses the top 5 skill areas for the advanced DBA.
Single Client Access Name (SCAN) for Oracle Database 11g RAC
One of the maintenance challenges with RAC is maintaining all of the client connection files (TNSNAMES.ora) every time a change is made to a cluster database configuration. A new feature of Oracle Database 11g RAC databases, and a primary benefit, is the Single Client Access Name (SCAN). Read on to learn more...
14 Useful DBA Tasks for Solving Database Performance Problems
A checklist of DBA tasks involved with keeping an Oracle Database running smoothly can be quite handy. This 14 point checklist, while not actual performance tuning activities are tasks that a DBA needs to know and they will often be part of a solution to remedy a database performance problem.
Generate TPC Workloads For Oracle Databases Using Benchmark Factory
Most Oracle DBAs have found that tuning the I/O performance of an Oracle Database (11gR2) is as much art as science. Jim Czuprynski explains how to use Quest’s Benchmark Factory tool to construct and execute TPC-E and TPC-H workloads against an Oracle Database and how to isolate the sources of I/O performance bottlenecks.
Oracle 
