Oracle database management, tutorials, scripts, coding, programming and tips for database administrators

Oracle

PGA and Memory Management in Oracle 09/26

Oracle has evolved over the years to make PGA and memory management easier for DBAs.

Monitoring Index Usage in Oracle Databases 08/22

Oracle can help you determine which indexes are not being used to help boost application and database performance.

Oracle Database Buyer's Guide 07/19

Rob Gravelle writes: 'Oracle is the BMW of the database server world. Everyone tries to beat them, but then they raise the bar with each successive release.'

Extending Applications with Oracle Database Replication 04/19

In an Oracle database, database replication is the process of duplicating objects and moving them out to multiple databases so users have continuous access to shared data even in the event of a disaster.

Oracle Coherence Adds Flash to In-Memory Database 04/18
Oracle's in-memory database update provides new elasticity to help scalability.

Oracle 11gR2 I/O Performance Tuning: Implementing I/O Performance Improvements 04/05
Oracle 11g Release 2 (11gR2) makes it easier than ever to isolate and identify potential root causes of poor I/O performance.

Oracle Database Security and Regulatory Compliance - What's a DBA to Do? 03/31

The best way to meet regulatory and privacy mandates is to emphasize proper configuration and hardening of all your technology components.

Adding a Node to Oracle RAC 11g Release 2 03/30
Learn how to add a node to Oracle RAC 11g on Oracle Enterprise Linux 5.

Top 10 New Features for Oracle 11g Data Guard - Part One 03/24
Disaster recovery is an ongoing concern for Oracle database administrators. Data Guard is one of your best options for creating a "hot" standby database.

Creating Dump Files in Oracle GoldenGate 02/28
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.

Oracle Enterprise Manger and Real-Time Database Performance 02/17
Oracle Enterprise Manger (OEM) is a great tool for dealing with database performance issues in real time, according to an article by James Koopmann.

Oracle Debuts Database Firewall 02/14
Oracle pulls the wraps off new technology that secures databases against SQL injection.

Getting Started with Oracle GoldenGate 02/09
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 02/02
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 02/02
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.