RDBMS Server

Oracle RDBMS Server Articles

Natalka Roshak's picture

RAC Filesystem Options

articles: 

DBAs wanting to create a 10g Real Applications Cluster face many configuration decisions. One of the more potentially confusing decisions involves the choice of filesystems. Gone are the days when DBAs simply had to choose between "raw" and "cooked". DBAs setting up a 10g RAC can still choose raw devices, but they also have several filesystem options, and these options vary considerably from platform to platform. Further, some storage options cannot be used for all the files in the RAC setup. This article gives an overview of the RAC storage options available.

Burton King's picture

Not using RMAN? You may be missing out on one of Oracle's best features!

articles: 

When Oracle released RMAN (Recovery Manager) in Oracle 8 they changed the way databases can be backed up and recovered in the event of disaster. Unfortunately, Oracle shops have been slow to embrace RMAN often times because the change required a leap of faith into the new backup / recovery process as well changes to scripts, procedures, etc. This article will introduce the reader to RMAN and explain why every DBA should use it.

James Koopmann's picture

Oracle Data Pump - Part I

articles: 

The last couple articles I have written focused on meta-data or DDL extraction for Oracle. The search for a part III to those articles lead me to Oracle's Data Pump utility. Not necessarily for the data movement piece but because it has an API for meta-data. Well even though I have been using 10g for quite some time, I have yet to use Data Pump. I thought this would be a great way to introduce myself, and possibly you the reader, to this new utility. This article will serve as a basic introduction to Data Pump and then in subsequent articles we will walk through the new command line options for Data Pump's export and import (expdp & impdp), and look at the PL/SQL packages DBMS_DATAPUMP and DBMS_METADATA.

Shouvik Basu's picture

UNDO behavior in Oracle 9i and 10g under microscope

articles: 

This article is the result of observations of the UNDO tablespace of Oracle 9i and Oracle 10g in various situations. We start with a simple query showing how to monitor the amount of undo generated in a session for a specific time. We investigate the creation, expansion, and resize of UNDO tablespace, and the issues that guide the reuse of UNDO segments. The impact of parameters like UNDO_RETENTION in Oracle 9i and UNDO_RETENTION and the GUARANTEE clause in CREATE UNDO statements is discussed using simple reproducible examples.

James Koopmann's picture

Tapping into Oracle's Metadata - Part 2

articles: 

In this article James continues to explore the Oracle's Metadata API and provides a powerful function to compare objects and schemas and print the DDL required to bring them in sync.

Connecting Oracle with MS-Access

articles: 

This article shows how Oracle's Heterogeneous Services can be configured to allow a database to connect to a Microsoft Access database using standard databases links. The method described can be used to connect to MS-Access from about any platform - Unix/ Linux or Windows.

James Koopmann's picture

Tapping into Oracle's Metadata - Part I

articles: 

In this article James explores the Oracle's Metadata API (DBMS_METADATA) and shows how database users can extract object definitions (DDL statements) from an Oracle database without having to go through a stack of dictionary views.

Jared Still's picture

Protect Your Passwords

articles: 

Jared explains how Oracle manages passwords and how "thinking like a hacker" can help you to better protect your databases from potential password theft.

Donald K. Burleson's picture

Can you have too much cache?

articles: 

There is a great debate about the rapidly-falling costs of RAM and the performance benefits of full caching of Oracle databases. Let's take a closer look at the issues over large RAM data buffers, tuning by adjusting system parameters and using fast hardware to correct sub-optimal Oracle code:

Donald K. Burleson's picture

Oracle first_rows optimization improvements

articles: 

Prior to Oracle9i, the only two cost-based optimizer modes were all_rows and first_rows optimization. One of the shortcomings of traditional first_rows SQL optimization was that the first_rows goal did not know the scope of the query and generally favored index access over full-table scans.

Pages

Subscribe to RSS - RDBMS Server