Technical Articles for DBAs and Sysadmins (2006 and newer)

 

 Data Warehousing & Integration
 Linux, RAC and Grid
 Enterprise Management and Manageability
 Performance & Availability
 Security
 SQL
 Content Management

 

See articles published in 2005 and older | Back to Articles home

 

Data Warehousing & Integration


A Refreshing Move [01-June-2009]
by Arup Nanda
Encrypt, compress, mask, and deliver information with Oracle Data Pump.

Accelerating Data Warehousing [01-May-2008]
by Dan Vlamis
Oracle OLAP 11g brings high-performance data warehouse features to Oracle Database 11g.



Intelligence and Identity [01-Jan-2008]
by Mark Rittman and Joel Crisp
Integrating Oracle Business Intelligence and Oracle Identity Management.



Reporting with the Familiar [21-June-2007]
by Mark Rittman
Create reports with familiar desktop tools and Oracle enterprise datasources.

Building a Hybrid Data Warehouse Model [9-Apr-2007]
by James Madison
As suggested by this reference implementation, in some cases blending the relational and dimensional models may be the right approach to data warehouse design.

Managing Data Quality [26-Oct-2006]
by Ron Hardman
Oracle Warehouse Builder 10g handles the truth.

 

Back to Top

Linux, RAC and Grid

Build Your Own Oracle RAC 11g Cluster on Oracle Enterprise Linux and iSCSI - updated for Release 2 [9-Dec-2009]
by Jeffrey Hunter
Learn how to set up and configure an Oracle RAC 11g development cluster on Oracle Enterprise Linux for less than US$2,700.

Guide to Advanced Linux Command Mastery, Part 5 - Managing the Linux Environment, Continued [31-July-2009]
by Arup Nanda
In this fifth and final installment of the series, we will focus on more commands and techniques for managing a Linux environment – including a virtualized one.

Installing Oracle Enterprise Manager 10g Rel 5 on Oracle Database 11g and Linux [9-July-2009]
by Mike Revitt
Install Oracle Enterprise Manager 10g Grid Control Rel 5 against an existing Oracle 11g database on Oracle Enterprise Linux version 5, step by step.

High Performance and Availability with Oracle RAC and PHP [16-June-2009]
by John Lim
Review real-world experiences in deploying a business-critical PHP app over Oracle Real Application Clusters.

Open Source Contributions [01-June-2009]
by Rich Schwerin
Oracle investments in Linux yield substantial returns.

Guide to Advanced Linux Command Mastery, Part 4 - Managing the Linux Environment [8-May-2009]
by Arup Nanda
In this installment, learn how to manage the Linux environment effectively through these commonly used commands.

Oracle Enterprise Manager Grid Control Architecture for Very Large Sites [March 2009]
by Porus Havewala
Need to guarantee high scalability for Enterprise Manager Grid Control? This architecture, described by Oracle ACE Director Porus Homi Havewala based on real-world experiences, may be for you.

Guide to Advanced Linux Command Mastery, Part 3: Resource Management [January 2009]
by Arup Nanda
In this installment, learn advanced Linux commands for monitoring physical components.

Build Your Own Oracle Extended RAC Cluster on Oracle VM and Oracle Enterprise Linux [28-Oct-2008]
by Jakub Wartak
Learn how to create a cheap but fully functional Oracle Extended RAC implementation in a virtualized environment. For educational purposes only, not validated or supported by Oracle!

Guide to Linux Find Command Mastery [29-July-2008]
by Sheryl Calish
A quick introduction to the most powerful—as well as confusing—aspects of this ubiquitous command.

More Support for the Kernel [23-June-2008]
by Rich Schwerin
Oracle developers continue their contributions to the Linux kernel.

Guide to Advanced Linux Command Mastery, Part 2 [21-Feb-2007]
by Arup Nanda
Oracle ACE Arup Nanda offers a tour of slightly more advanced Linux commands useful for Oracle users, whether developers or DBAs.

Committed to Code [21-June-2006]
by Rich Schwerin
Oracle's kernel contributions benefit anyone using Linux.

Adding New Nodes to Your Oracle RAC 10g Cluster on Linux [2-Oct-2006]
by Murali Vallath
Follow this step-by-step guide to add a new node to an existing Oracle RAC 10g Release 2 cluster.

Guide to Advanced Linux Command Mastery, Part 1 [11-Aug-2006]
by Arup Nanda
In this four-part series from Oracle ACE Arup Nanda, you will learn some not-so-well-known tricks for various routine Linux commands, as well as use cases for more sophisticated commands.

Learning Oracle RAC with the NetApp Simulator [30-Mar-2006]
by Sachin Garg
With the help of Net Appliance's Data ONTAP Simulator, DBAs and Linux enthusiasts can evaluate Oracle Real Application Clusters (RAC) on Linux with no up-front hardware investment.

Back to Top

Enterprise Management

Easy Disaster Proof Production [8-Jan-2010]
by Porus Havewala
Using Oracle Enterprise Manager Grid Control for Data Guard setup, management (including switchover or failover), and monitoring can save a lot of time and resources.

Patch a Thousand Databases, Using Oracle Enterprise Manager Grid Control [3-Sept-2009]
by Porus Havewala
Get a tour of the automated patching capabilities now available to Oracle DBAs.

Scripting Oracle RMAN Commands [19-Aug-2009]
by Arup Nanda
Learn how to create and automate scripts to execute common recovery tasks.

Installing Oracle Enterprise Manager 10g Rel 5 on Oracle Database 11g and Linux [9-July-2009]
by Mike Revitt
Install Oracle Enterprise Manager 10g Grid Control Rel 5 against an existing Oracle 11g database on Oracle Enterprise Linux version 5, step by step..

Oracle RMAN Backups: Pushing the "Easy" Button [April 2009]
by Porus Havewala
How to redesign the setup and scheduling of Oracle RMAN backups the "easy" way, using Oracle Enterprise Manager

Oracle Enterprise Manager Grid Control Architecture for Very Large Sites [March 2009]
by Porus Havewala
Need to guarantee high scalability for Enterprise Manager Grid Control? This architecture, described by Oracle ACE Director Porus Homi Havewala based on real-world experiences, may be for you.

Encrypting Tablespaces [18-Dec-2008]
by Arup Nanda
Encrypt tablespaces transparently—without affecting performance.

More Ways to Flash Back [01-Sep-2008]
by Sushma Jagannath
Query history and recover from corruptions with Oracle Flashback technology.

Document, Monitor, and Manage [01-Sep-2008]
by Sue Harper
Take advantage of new features in Oracle SQL Developer 1.5.

Using Database Advisors [23-June-2008]
by Sushma Jagannath
Get advice on key management challenges and improve performance in Oracle Database 11g.

Managing History [23-June-2008]
by Jonathan Gennick
Oracle Total Recall enables users to find, track, and use past and present information

Back Up and Recover [01-May-2008]
by Sushma Jagannath
New backup and recovery features in Oracle Database 11g save time and data.

Visualize Your Oracle Database Data with JChart [02-Nov-2007]
by Dustin Marx and Michael G. Martin
Use the open-source JFreeChart tool to easily plot your Oracle database data in a wide selection of high-quality chart types.

More Partitioning Choices [17-Aug-2007]
by Arup Nanda
Learn when and how to use new partitioning schemes in Oracle Database 11g.

Embedded Java Persistence [17-Mar-2007]
by Jonathan Gennick
Oracle Berkeley DB Java Edition provides painless persistence to Java objects.

Recover in a Flash [17-Jan-2007]
by Arup Nanda
Reduce database recovery time, using the Oracle flash recovery area.

When Microseconds Count [26-Oct-2006]
by Jonathan Gennick
The Oracle TimesTen in-memory database is always ready.

Restore to the Point [26-Oct-2006]
by Arup Nanda
Use named points in time to roll your database back by using flashback query.

Become a Master [28-Aug-2006]
by Aradhana Puri
Step up from Oracle Certified Professional to Oracle Certified Master.

Secure Search Returns Best Results [28-Aug-2006]
by Ron Hardman
Oracle Secure Enterprise Search provides the right intranet search.

Using Oracle Grid Control with Filer Snapshotting [July 2006]
by Porus Havewala

Commanding ASM [01-Mar-2006]
by Arup Nanda
Access, transfer, and administer ASM files without SQL commands.

Faster Batch Processing [01-Mar-2006]
by Mark Rittman
LOG ERRORS handles errors quickly and simplifies batch loading.

Auditing in XML [01-Jan-2006]
by Arup Nanda
Create database audit trails in XML.

New Features for Oracle8i OCPs [01-Jan-2006]
by Aradhana Puri
Upgrade from Oracle8i OCP to Oracle Database 10g OCP in one exam.

Back to Top

Performance & Availability


Click here for High Availability Tech Tips

Compressing Columns [01-Jan-2010]
by Arup Nanda
Compress more with Oracle Exadata Hybrid Columnar Compression.

On Constraints, Metadata, and Truth [01-May-2009]
by Tom Kyte
Our technologist uses constraints to improve query performance.

More New PL/SQL Features [01-May-2009]
by Sushma Jagannath
Improve performance in Oracle Database 11g with new PL/SQL features.

Guide to Oracle Data Guard Fast-Start Failover [March 2009]
by John Smiley
This document will guide you through configuring Oracle Data Guard Fast-Start Failover (FSFO) using a physical standby database. FSFO can provide substantial gains in high availability and disaster recovery preparedness for all environments, from inexpensive Cloud-based systems to global distributed data centers.

Improving Application Performance [2-Mar-2009]
by Sue Harper
Manage and tune Oracle Application Express applications with Oracle SQL Developer.

Baselines and Better Plans [2-Mar-2009]
by Arup Nanda
Use SQL plan management in Oracle Database 11g to optimize execution plans.

On Dynamic Sampling [18-Dec-2008]
by Tom Kyte
Our technologist samples dynamically, considers usage, and sets levels.

Managing Database Resources [18-Dec-2008]
by Sushma Jagannath
New features in Oracle Database 11g help you assess performance and limit I/O usage.

Encrypting Tablespaces [18-Dec-2008]
by Arup Nanda
Encrypt tablespaces transparently—without affecting performance.

New Ways to Flash Back [01-Nov-2008]
by Sushma Jagannath
Reverse transactions and track historical changes in Oracle Database 11g.

Keeping Active [01-Nov-2008]
by Arup Nanda
Use Oracle Active Data Guard to set up a physical standby database for reporting and recovery.

More Ways to Flash Back [01-Sep-2008]
by Sushma Jagannath
Query history and recover from corruptions with Oracle Flashback technology.

Using Database Advisors [23-June-2008]
by Sushma Jagannath
Get advice on key management challenges and improve performance in Oracle Database 11g.

Managing History [23-June-2008]
by Jonathan Gennick
Oracle Total Recall enables users to find, track, and use past and present information.

Compress to Impress [23-June-2008]
by Arup Nanda
Use Oracle Advanced Compression to conserve resources and improve performance.

Back Up and Recover [01-May-2008]
by Sushma Jagannath
New backup and recovery features in Oracle Database 11g save time and data.

Oracle Database 11g Redux [11-Feb-2008]
by Tom Kyte
Our technologist continues to explore Oracle Database 11g features.

Performing Through Changes [11-Feb-2008]
by Arup Nanda
Measure the impact of changes on SQL workload with SQL performance analyzer.

On Tuning by Tracing [01-Jan-2008]
by Tom Kyte
Our technologist does a tune-up with SQL_TRACE.

Better Workload, Better Testing [01-Jan-2008]
by Arup Nanda
Use database replay to record and replay database activities for better testing.

Faster, Safer, and Smaller LOBs [17-Aug-2007]
by Jonathan Gennick
Oracle SecureFiles provides increased performance, better security, and reduced disk usage.

More Partitioning Choices [17-Aug-2007]
by Arup Nanda
Learn when and how to use new partitioning schemes in Oracle Database 11g.

Recover in a Flash [17-Jan-2007]
by Arup Nanda
Reduce database recovery time, using the Oracle flash recovery area.

When Microseconds Count [26-Oct-2006]
by Jonathan Gennick
The Oracle TimesTen in-memory database is always ready.

Restore to the Point [26-Oct-2006]
by Arup Nanda
Use named points in time to roll your database back by using flashback query.

Become a Master [28-Aug-2006]
by Aradhana Puri
Step up from Oracle Certified Professional to Oracle Certified Master.

Partition Decisions [01-Mar-2006]
by Arup Nanda
Understand your partition choices, and choose the best partition and key for your data.

Faster Batch Processing [01-Mar-2006]
by Mark Rittman
LOG ERRORS handles errors quickly and simplifies batch loading.

New Features for Oracle8i OCPs [01-Jan-2006]
by Aradhana Puri
Upgrade from Oracle8i OCP to Oracle Database 10g OCP in one exam.

Back to Top

Security


Intelligence and Identity [01-Jan-2008]
by Mark Rittman and Joel Crisp
Integrating Oracle Business Intelligence and Oracle Identity Management.

Faster, Safer, and Smaller LOBs [17-Aug-2007]
by Jonathan Gennick
Oracle SecureFiles provides increased performance, better security, and reduced disk usage.

Implementing Row-Level Security in Java Applications [9-July-2007]
by Lonneke Dikmans, Oracle Fusion Middleware Regional Director
Learn how to enforce row-level security across your JEE application, from database to cache.

Testing Database Security [26-Oct-2006]
by Aradhana Puri
Questions and answers on securing your Oracle database by using FGA and VPD

Secure Search Returns Best Results [28-Aug-2006]
by Ron Hardman
Oracle Secure Enterprise Search provides the right intranet search.

New Technical Article Series: Project Lockdown [22-May-2006]
by Arup Nanda
Learn a practical, phased approach to securing your database infrastructure using built-in Oracle Database security features—over one day, week, month, and quarter.

Back to Top

SQL


A Closer Look at the New Edition [01-Jan-2010]
by Tom Kyte
Our technologist redefines and defers with Oracle Database 11g Release 2.

Looking at the New Edition [14-Oct-2009]
by Tom Kyte
Our technologist takes a first look at Oracle Database 11g Release 2.

Tune It Up [14-Oct-2009]
by Sushma Jagannath
New features in Oracle Database 11g improve and speed SQL tuning.

On DBMS_ROWID, Parsing, and Sizing [19-Aug-2009]
by Tom Kyte
Our technologist identifies rows, analyzes ratios, and fills space.

On Popularity and Natural Selection [01-June-2009]
by Tom Kyte
Our technologist optimizes away binds and promotes more-selective queries.

On Constraints, Metadata, and Truth [01-May-2009]
by Tom Kyte
Our technologist uses constraints to improve query performance.

On Wrong and Right [2-Mar-2009]
by Tom Kyte
Our technologist checks the documentation and tests the answers.

Improving Application Performance [2-Mar-2009]
by Sue Harper
Manage and tune Oracle Application Express applications with Oracle SQL Developer.

Baselines and Better Plans [2-Mar-2009]
by Arup Nanda
Use SQL plan management in Oracle Database 11g to optimize execution plans.

On Dynamic Sampling [18-Dec-2008]
by Tom Kyte
Our technologist samples dynamically, considers usage, and sets levels.

Managing Database Resources [18-Dec-2008]
by Sushma Jagannath
New features in Oracle Database 11g help you assess performance and limit I/O usage.

Encrypting Tablespaces [18-Dec-2008]
by Arup Nanda
Encrypt tablespaces transparently—without affecting performance.

On Separation and Counting [01-Nov-2008]
by Tom Kyte
Our technologist promotes more than one schema, counts partitions, and uses TKPROF.

New Ways to Flash Back [01-Nov-2008]
by Sushma Jagannath
Reverse transactions and track historical changes in Oracle Database 11g.

Programming Productively [01-Nov-2008]
by Sue Harper
Use Oracle SQL Developer to work efficiently with PL/SQL constructs.

The Trouble with Triggers [01-Sep-2008]
by Tom Kyte
Our technologist looks at trigger maintenance and implementation challenges.

Document, Monitor, and Manage [01-Sep-2008]
by Sue Harper
Take advantage of new features in Oracle SQL Developer 1.5.

On Redefinition, Nature, and Triggers [23-June-2008]
by Tom Kyte
Our technologist redefines tables, compares keys, and warns about DDL in triggers.

Managing File Versions [23-June-2008]
by Sue Harper
Edit files and use version control in Oracle SQL Developer 1.5.

The Power of Two [01-May-2008]
by David Peake
Use Oracle SQL Developer to aid Oracle Application Express development.

On Seeing Double in V$SQL [01-May-2008]
by Tom Kyte
Our technologist looks at SQL repetition in V$SQL and differences in cardinality.

Back Up and Recover [01-May-2008]
by Sushma Jagannath
New backup and recovery features in Oracle Database 11g save time and data.

Making Database Connections [01-May-2008]
by Sue Harper
Connect to Oracle and third-party databases from Oracle SQL Developer.

Oracle Database 11g Redux [11-Feb-2008]
by Tom Kyte
Our technologist continues to explore Oracle Database 11g features.

Building Queries Visually [11-Feb-2008]
by Sue Harper
Use point-and-click, drag-and-drop, and query builder in Oracle SQL Developer.

Performing Through Changes [11-Feb-2008]
by Arup Nanda
Measure the impact of changes on SQL workload with SQL performance analyzer.

On Tuning by Tracing [01-Jan-2008]
by Tom Kyte
Our technologist does a tune-up with SQL_TRACE.

More on Oracle Database 11g [18-Oct-2007]
by Tom Kyte
Our technologist takes another look at Oracle Database 11g.

Working with PL/SQL [18-Oct-2007]
by Sue Harper
Edit, compile, run, and debug PL/SQL code easily with Oracle SQL Developer.

Guide to Oracle Berkeley DB for SQL Developers [24-Sept-2007]
by Margo Seltzer
Get an introduction to using common SQL functions in Oracle Berkeley DB, from one of its inventors.

On Oracle Database 11g [17-Aug-2007]
by Tom Kyte
Our technologist takes a look at the server results and PL/SQL function caches.

Moving to an Oracle Database [17-Aug-2007]
by Sue Harper
Use Oracle Migration Workbench to migrate third-party schema objects to an Oracle database.

On Ignoring, Locking, and Parsing [21-June-2007]
by Tom Kyte
Our technologist looks out for WHEN OTHERS, locks, cascades, and parses.

Extending Oracle SQL Developer [21-June-2007]
by Sue Harper
Build extensions for Oracle SQL Developer with SQL and XML.

On Loading and Extents [11-May-2007]
by Sue Harper
Build chart, drill-down, and master/detail reports with Oracle SQL Developer.

Now Reporting [11-May-2007]
by Tom Kyte
Our technologist follows the direct path and optimizes extent usage.

On Cursors, SQL, and Analytics [11-Mar-2007]
by Tom Kyte
Our technologist referees between cursors, SQL statements, analytics, and aggregates.

On Top- n and Pagination Queries [17-Jan-2007]
by Tom Kyte
Our technologist gets more results using ROW_NUMBER, RANK, and DENSE_RANK.

Testing Database Security [26-Oct-2006]
by Aradhana Puri
Questions and answers on securing your Oracle database by using FGA and VPD

On Rescue Analytics and Popularity [26-Oct-2006]
by Tom Kyte
Our technologist explains the saving power of analytics and shares popularity.

On ROWNUM and Limiting Results [28-Aug-2006]
by Tom Kyte
Our technologist explains how ROWNUM works and how to make it work for you.

On Speeding, Dating, and Spelling [01-Jul-2006]
by Tom Kyte
Our technologist finds the OS, makes things appear faster, dates clients, and spells out numbers.

Build Custom Aggregate Functions [01-Jul-2006]
by Jonathan Gennick
Summarize data in new ways by writing your own aggregate functions.

Oracle SQL Developer Soars [01-May-2006]
by Jonathan Gennick
Bring the power of a GUI-based workbench to SQL and PL/SQL.

On Joins and Query Plans [01-May-2006]
by Tom Kyte
Our technologist optimizes joins and explains changing plans.

On Deduping and Ordering [01-Jan-2006]
by Tom Kyte
Our technologist deletes duplicates, gives trigger orders, and explains how SELECT locks.

SQL Tools Make Fast Work [01-Jan-2006]
by Jonathan Gennick
Different SQL tools run code, return results, and offer helpful differences.

Auditing in XML [01-Jan-2006]
by Arup Nanda
Create database audit trails in XML.

On Sharing, Splitting, and Deleting [01-Jan-2006]
by Tom Kyte
Our technologist shares cursors, splits large tables, and deletes securely.

Back to Top

Content Management


Manage Complex XML Data in Oracle XML DB 11g [18-Dec-2007]
by V.J. Jain
Learn how to manage complex XML with Oracle XML DB 11g, including how to change schema online using the new inPlaceEvolve procedure.

Extending Oracle SQL Developer [21-June-2007]
by Sue Harper
Build extensions for Oracle SQL Developer with SQL and XML.

Archiving Data Using XML [01-Jul-2006]
by Arup Nanda
Build a powerful, flexible data archive.

Auditing in XML [01-Jan-2006]
by Arup Nanda
Create database audit trails in XML.

Back to Top