Using Oracle Alerts
We take a look at some of the alerting concepts and settings available within Oracle Database 11g.
Learning Oracle GoldenGate
Steve Callan takes a look at configuring Oracle GoldenGate and discusses what takes place within Oracle GoldenGate in terms of how data gets from the source database to the target database.
Three Steps to Configuring Oracle for Automatic Database Monitoring
The homegrown automatic monitoring of an Oracle database often results in time consuming, resource intensive tactics, in terms of DBA hours and development costs. A more elegant way to monitor database performance automatically is Oracle's Automatic Database Diagnostic Monitor (ADDM). James Koopmann gets you started by showing you how to configure ADDM.
A Guide to 4KB Sector Support for Oracle Files
DBAs must decide what the standard database block size should be when they first creat a new Oracle database. It is virtually impossible to change the standard block size once the database is created, without recreating the entire database. Karen Reliford explains how to create tablespaces with different block sizes.
The Top 5 Changes in Oracle Database 11g R2 RAC
Five main changes have been incorporated into Oracle Database 11g RAC with the introduction of the Oracle Grid Infrastructure product. These changes include installing and working with Grid Infrastructure, Single Client Access Names (SCAN), RAC One Node, Automatic Workload Balancing and the ASM Cluster File System (ACFS). Read on to learn more.
Monitoring an Oracle Database Automatically
Automatic monitoring of an Oracle database often results in time consuming, resource intensive tactic, in terms of DBA hours. A more elegant way to monitor database performance automatically is Oracle's Automatic Database Diagnostic Monitor (ADDM). ADDM captures and analyzes statistical data in the Automatic Workload Repository to determine if potential performance related database issues exist.
Oracle GoldenGate Fundamentals
Oracle Corp. has acquired so many companies of late that it's getting to be a job to keep up with things. GoldenGate is one of the products you'll want to stay on top of. It's still kind of under the radar, but it's going to be big. Really big.
Using the Oracle Performance Method
Statistics are at the core of determining whether your performance tuning efforts are working or not. James Koopmann dives into performance methodologies, specifically Oracle's performance method, to give us a better understanding of how to tune a database with statistics.
Performance Tuning Oracle Database: Identifying and Evaluating I/O Bottlenecks
This article illustrates the wealth of I/O performance tuning information that Oracle 11gR2s Automatic Workload Repository (AWR) reports provide, 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 databases underlying input/output (I/O) subsystem.
Top 5 Technologies for the Oracle DBA
A DBA is expected to know the basics of database administration, but to be successful, proficiency in more advanced database administration is required. Read on to learn the top 5 skill areas for the advanced DBA.
Methods of Oracle Database Performance Tuning
Some good to great database products exist to help you tune your database, while others are not so good; but regardless of the tool, it is imperative that you understand some form of tuning methodology first.
Getting Ready to Tune Your Oracle Database
A DBA's role often revolves around tuning the database. This in itself can be a very daunting task. A checklist of DBA tasks can be quite handy. James Koopmann shares some performance tuning activities that a DBA needs to know and that will often be part of a solution to remedy a database performance problem.
Intra-Database Performance Testing With Benchmark Factory
Even though Oracle 11g Release 2 makes it easy to identify potential root causes of poor I/O performance, most DBAs have found that tuning the I/O performance of an Oracle database is still just as much art as science. Learn how to use Quests Benchmark Factory to construct and execute TPC-E and TPC-H workloads against an Oracle database, and how isolate the sources of I/O performance bottlenecks.
Installing Oracle Enterprise Manager (WebLogic Server Component)
Two major prerequisites for installing Oracle Enterprise Manager (OEM) are having an existing, certified Oracle Database and an installation of Oracle WebLogic Server. Steve Callan shows you the steps performed for database preparation and for installation of Oracle WebLogic Server.
Authenticating Users in Oracle Database 11g Using Proxy Authentication Methods
Oracle DBAs are responsible and accountable for many different areas of the database that they maintain. These areas include availability, recoverability, performance monitoring, accessibility and security. This poses a challenge for the DBAs since many applications use middle tier connections that make it difficult to access the end user information. To address these challenges, Oracle offers proxy authentication.
Oracle Database I/O Performance Tuning: Generating Intra-Database Workloads
While Oracle Database 11gR2 provides some excellent tools to drill down to the potential root causes of poor I/O performance, generating a standard, consistent, and repeatable I/O workload is crucial for fair comparisons. This article discusses which Transaction Processing Council (TPC) sample schema(s) are available, and which one(s) are most appropriate for evaluation of a database systems underlying input/output (I/O) subsystem.
Database Management 
