» Database Journal Home

» Database Articles

» Database Tutorials

MS SQL

Oracle

DB2

MS Access

MySQL

» RESOURCES

SQL Scripts & Samples

Tips

» Database Forum

» Slideshows

Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Advertiser Disclosure

Featured Database Articles

Posted Mar 22, 2006

Oracle Series

By DatabaseJournal.com Staff

The Database Journal Series index is a listing of articles, which contain more than three installments. It is categorized by database, author name, series title and article title.

Dave Aldridge

A Practical Guide to Data Warehousing in Oracle

A Practical Guide to Data Warehousing in Oracle, Part 6
A Practical Guide to Data Warehousing in Oracle, Part 5
A Practical Guide to Data Warehousing in Oracle, Part 4
A Practical Guide to Data Warehousing in Oracle - Part 3
A Practical Guide to Data Warehousing in Oracle, Part 2
A Practical Guide to Data Warehousing in Oracle, Part I
A Practical Guide to Data Warehousing in Oracle: Series Introduction

Steve Callan

Comparing SQL Server and Oracle Database Features

SQL Server Management Features vs Oracle Database Management Features
Mapping SQL Server Management Features to Oracle Database
Mapping SQL Server Features to Oracle Database
Oracle Database to SQL Server Comparisons

Hands-on Oracle: Backup and Recovery Games

Hands-on Oracle: Backup and Recovery Games - Creating Datafiles
Recovering from Loss of All Control Files
Hands-on Oracle: Backup & Recovery Games

Oracle DBA in an Oracle Applications World

Oracle Applications Reference Books
Oracle DBA in an Oracle Applications World - Part 2
Oracle DBA in an Oracle Applications World

Database Migration - A Planned Approach

Trees and Hierarchies in Oracle
Database Migration - It's More than Running exp and imp
Database Migration - A Planned Approach

Database Security and Patches

Database Security and Patches - Part 5
Database Security and Oracle Patches - Part 4
Database Security and Patches - Part 3
Database Security and Patches - Part 2
Database Security and Patches - Part 1

Oracle Performance Tuning

Oracle Performance Tuning - Part 3
Oracle Performance Tuning - Part 2
Oracle Performance Tuning - Part 1

Oracle on the Web

Oracle on the Web Part 5 - More on HTML DB
Oracle on the Web, Part 4 - Upgrading HTML DB
Oracle on the Web - Part 3 - Using Applications in HTML DB
Oracle on the Web, Part 2 - Oracle 10g's HTTP Server and HTML DB
Oracle on the Web Part 1 - Exploring Oracle's HTTP Server

Oracle Migration Workbench

Oracle Migration Workbench - Part 5
Oracle Migration Workbench - Part 4
Oracle Migration Workbench - Part Three
Oracle Migration Workbench - Part Two
Oracle Migration Workbench - Part 1

Oracle on Windows

Oracle on Windows Part 3 - The Registry
Oracle on Windows - Part 2
Oracle on Windows

Installation Cookbooks

Installation Cookbooks: Deploying Reports on the Web
Installation Cookbooks: Deploying Forms on the Web
Installation Cookbooks: Installing Oracle9i Developer Suite
Installation Cookbook: Installing Oracle Application Server 10g (9.0.4)Forms and Reports Services
Installation Cookbooks: Installing Oracle Forms & Reports 6i
Installation Cookbooks: Installing Oracle9i

Trigger-Happy DBA

The Trigger-Happy DBA - System Triggers
The Trigger-Happy DBA - Part 2
The Trigger-Happy DBA

Connecting with Oracle

Connecting with Oracle - Ensuring Sufficient Privileges
Connecting with Oracle: The Password Game
Connecting with Oracle: Accessing Oracle via Access and Excel
Connecting with Oracle: Oracle Ports
Connecting with Oracle: Finding and Setting a Configuration File Location
Connecting with Oracle

Jim Czuprynski

Oracle Database 11gR2 I/O Performance Tuning:

Oracle Database I/O Performance Tuning Using Benchmark Factory
Oracle Database I/O Performance Tuning: Capturing Extra-Database I/O Performance Metrics
I/O Performance Tuning Tools for Oracle Database 11gR2
Oracle Database 11gR2 I/O Performance Tuning: A Primer

Oracle Database 11g: Data Guard

Leveraging ACFS Snapshots and Cluster Infrastructure in Oracle Database 11gR2
Leveraging Logical Standby Databases in Oracle 11g Data Guard
Fast-Start Failover in Oracle 11g Data Guard
Performing Database Failover with Oracle 11g Data Guard
Using Oracle 11g's Active Data Guard and Snapshot Standby Features
Leveraging Oracle 11g Data Guard for Database Backup and Recovery
Oracle 11g Data Guard: Grid Control Management
Configuring Data Guard Broker
Oracle 11g Data Guard: Building a Physical Standby Database

Oracle Database 11g: Secure Files

Oracle 11g's Transparent Data Encryption Security Feature
How to Migrate from BasicFiles to SecureFiles Storage
SecureFiles in Oracle Database 11g

Oracle Database 11g: Database Replay

Oracle Database 11g: Database Replay, Part 3
Oracle Database 11g: Database Replay, Part 2
Oracle Database 11g: Database Replay, Part 1

Oracle Database 11g: SQL Plan Management

Oracle Database 11g: SQL Plan Management, Part 3
Oracle Database 11g: SQL Plan Management, Part 2
Oracle Database 11g: SQL Plan Management, Part 1

Oracle Database 11g: SQL Performance Analyzer

Oracle Database 11g: SQL Performance Analyzer, Part 3
Oracle Database 11g: SQL Performance Analyzer, Part 2
Oracle Database 11g: SQL Performance Analyzer, Part 1

Oracle 10g Secure Backup

Oracle Secure Backup, Part 3: Conclusion
Oracle Secure Backup, Part 2: A Sample Implementation
Oracle 10g Secure Backup, Part 1: Concepts

Oracle 10gR2 Security

Oracle 10gR2 Security, Part 4: Securing Data Extracts, Exports and Recovery Files
Oracle 10gR2 Security, Part 3: Transparent Data Encryption
Oracle 10g Security, Part 2: Virtual Private Database
Oracle 10g Security, Part 1: Fine-Grained Auditing

Oracle 10g Scheduler Enhancements

Oracle 10g Scheduler Enhancements, Part 2: Job Chains
Oracle 10g Scheduler Enhancements, Part 1

Oracle 10g Automatic Storage Management

Oracle 10g Automatic Storage Management (ASM), Part 3: Advanced Features
Oracle 10g Automatic Storage Management (ASM), Part 2: Sample Implementation
Oracle 10g Automatic Storage Management, Part 1: Overview

Oracle 10g Availability Enhancements

Oracle 10g Availability Enhancements, Part 4: LogMiner and Data Guard
Oracle 10g Availability Enhancements, Part 3: FLASHBACK Enhancements
Oracle 10g Availability Enhancements, Part 2: Flashback Database
Oracle 10g Availability Enhancements, Part 1: Backup and Recovery Improvements

The Oracle 10g Scheduler

The Oracle 10g Scheduler, Part 3: Advanced Features
The Oracle 10g Scheduler, Part 2: Implementation
The Oracle 10g Scheduler, Part 1: Overview

Oracle 10g SQL Enhancements

Playing With MODELs: Oracle 10g SQL Enhancements, Part 3
Data Densification, Demystified: Oracle 10g SQL Enhancements, Part 2
Strong SQL Made Even Stronger: Oracle 10g SQL Enhancements, Part 1

Oracle Database Resource Manager

Oracle Database Resource Manager, Part 3: Conclusion
Oracle Database Resource Manager, Part 2: Resource Plan Management
Oracle Database Resource Manager, Part 1:Overview

Oracle Label Security

Oracle Label Security, Part 4: Conclusion
Oracle Label Security, Part 3: Administration
Oracle Label Security, Part 2: Implementation
Oracle Label Security, Part 1: Overview

James Koopmann

PL/SQL Job Interview

Top 5 Query Tactics Questions for the PL/SQL Developer Job Interview
Top 7 User Defined Encryption Questions for Your Next PL/SQL Job Interview
Top 6 Security Questions for a PL/SQL Developer Job Interview
Oracle Developer Job Interview: Top 10 PL/SQL Performance Questions
Procedures, Functions, and Packages: Acing that PL/SQL Developer Job Interview
Top 5 Oracle Database PL/SQL Job Interview Questions
Top 9 Database Object Tips You Need to Know for Your Next PLSQL Job Interview
Top 5 Basic Concept Job Interview Questions for Oracle Database PL/SQL Developers

Oracle Database's ADRCI Utility

Little Known Uses for Oracle Database's Error Tool
Oracle Database's ADRCI: the Extended Commands
Oracle Database's ADRCI : Reading the Old Alert Log and Listener Log
Purging Oracle Database's Alert Log with ADRCI - Usage and Warning
Rotating Oracle Database's Alert Log with ADRCI
Alert Log Scraping with Oracle's ADRCI Utility

Oracle 11g Security

Oracle 11g Security - Guidelines for Auditing
Creating a standard audit trail in Oracle Database 11g
Setting default auditing as recommended by Oracle
Getting started with standard auditing in Oracle Database 11g
Secure Sockets Layer and Oracle 11g Security
Securing Client Connections: OS Authentication
Securing Oracle Database Client Connections
Explicit GRANTs and ROLES in Oracle Database 11g
Oracle 11g Object privileges and synonym usage
Oracle 11g Security - The Power of PROFILES
Oracle 11g Security - Those Pesky Predefined Accounts
Oracle 11g Security - Securing the Data Dictionary
Oracle 11g Security - Enabling default security settings

Oracle�s ADR Command Interpreter (ADRCI)

Oracle Health Checks with Health Monitor; Using PL/SQL or ADR
Oracle's ADR Command Interpreter (ADRCI) - Part 3
Oracle's ADR Command Interpreter (ADRCI) - Part 2
Oracle's ADR Command Interpreter - Part 1

Oracle��s ADR Command Interpreter (ADRCI)

Oracleӳ ADR Command Interpreter (ADRCI)

Measuring Disk I/O

Measuring Disk I/O--Oracle's ORION Tool
Measuring Disk I/O—A Vendor View
Measuring Disk I/O

Just SQL

Just SQL Part VII - Hierarchical Queries
Just SQL Part VI - Two Famous Pseudocolumns
Just SQL Part V - Counting with SQL
Just SQL Part IV - Joining Tables
Just SQL Part III - Where is it?
Just SQL Part II - The Simple SELECT
Just SQL Part I

The Globalization of Language in Oracle

The Globalization of Language in Oracle - Index Requirements
The Globalization of Language in Oracle - And Case-Insensitivity
The Globalization of Language in Oracle - The NLS_LANG variable
The Globalization of Language in Oracle - The NLS_COMP and NLS_SORT variables
The Globalization of Language in Oracle - National Language Support

Oracle Session Tracing

The Globalization of Language in Oracle - Terminology
Oracle Session Tracing Part VI
Oracle Session Tracing Part V
Oracle Session Tracing Part IV
Oracle Session Tracing Part III

Working with VARRAYs in Oracle

Working with VARRAYs in Oracle Part III
Working with VARRAYs in Oracle - Part II
Working with VARRAYs in Oracle Part I

Oracle Technical Interview

Oracle Technical Interview Questions Answered - Part2
Oracle Technical Interview Questions Answered - Part1
Oracle Technical Interview

Nandeep Nagarkar

Automating ETL using Oracle warehouse Builder

ETL Prototype using Oracle Warehouse Builder - Part 3
Automating ETL using Oracle warehouse Builder - Part 2: OWB architecture
Automating ETL Using Oracle Warehouse Builder - Part 1

Change data capture implementation in Oracle Data warehouses

Change data capture implementation in Oracle Data warehouses - Part 3
Change data capture implementation in Oracle Data warehouses - Part 2 - Oracle Streams implementation
Change Data Capture Implementation in Oracle Data Warehouses - Part 1

David Nishimoto

Listen Software

Amar Kumar Padhi

Oracle Optimizer

Oracle Optimizer: Moving to and working with CBO - Part 7
Oracle Optimizer: Moving to and working with CBO - Part 6
Oracle Optimizer: Moving to and working with CBO - Part 5
Oracle Optimizer: Moving to and working with CBO - Part 4
Oracle Optimizer: Moving to and working with CBO: Part 3
Oracle Optimizer: Moving to and working with CBO - Part 2
Oracle Optimizer: Moving to and working with CBO

Tarry Singh

Virtualization and Oracle 11g RAC

Oracle RAC 64 bit for Windows: Preparing the Virtual environment
Open Source Virtualization: Oracle VM Manager Installation
Open Source Virtualization: Oracle VM enters the Virtualization arena
Installing Oracle 11g RAC on VMware ESX 3i - Part1

Oracle RAC: How shared storage works on VMware

Clustering Oracle RAC Virtual Machines across physical and ESX hosts
Oracle RAC: How shared storage works on VMware - Part 3
Oracle RAC: How shared storage works on VMware - Part 2
Oracle RAC: How shared storage works on VMware - Part 1

Oracle RAC Administration

Monitoring Oracle 10g RAC with Quest Spotlight on RAC

Monitoring Oracle 10g RAC with Quest Spotlight on RAC - Part III
Monitoring Oracle 10g RAC with Quest Spotlight on RAC - Part II
Monitoring Oracle 10g RAC with Quest Spotlight on RAC - Part I

RACing ahead with Oracle on VMware Series

Installation gotchas for Oracle Linux , Oracle RAC 10gR2 and VMware ESX 3.0.1
Part 15: Creating database using DBCA on Redhat 4.2 Advanced Server
Installing 10gR2 Database Software
Installing 10gR2 Clusterware on Redhat 4.2 Advanced Server
Setting up ASM on Oracle 10g
Final Checks and OCFS2 Setup
Securing Remote Access and Copy with SSH and SCP
Configuring RHEL/Centos 4.2 Server for Oracle RAC 10g R2 Readiness
Configuring RHEL/Centos 4.2 Server for Oracle RAC 10g R2 Readiness
RACing ahead with Oracle on VMware Series - Part 7
RACing ahead with Oracle on VMware - Part 6
RACing ahead with Oracle on VMware - Part 5: The powerful SRVCTL Utility
RACing ahead with Oracle on VMware - Part 4: Installing RAC Database with ASM Option
RACing ahead with Oracle on VMware - Part 3: Installing Oracle 10g Release 2 Clusterware on a 2-node Windows 2003 Enterprise Edition Server
RACing ahead with Oracle on VMware - Part 2: Oracle RAC and RAW disk setup on Windows 2003 Enterprise Server
RACing ahead with Oracle on VMware - Part 1: Setting up VMware for Oracle/Intro to Virtualization/Server Consolidation

Latest Forum Threads
DB2 Forum
Topic	By	Replies	Updated
tables get lock during backup in db2 v9.5	Hamsoo	0	May 8th, 01:03 AM
Query to Pull Last 7 days records from a table	vgoushik	0	March 20th, 06:05 PM
DB2 Visual studio addin: ANSI/Unicode problem	10Pints	0	October 5th, 02:08 AM
Things that are everbodys labor day ideas?	Lipsett197	0	September 1st, 09:42 AM