Arup Nanda ( has been an Oracle DBA since 1993, handling all aspects of database administration, from performance tuning to security and disaster recovery. He was Oracle Magazine‘s DBA of the Year in 2003 and received an Oracle Excellence Award for Technologist of the Year in 2012.


Pub Date



January/February 2014

Hide from Prying Eyes

Use Data Redaction in Oracle Database 12c to hide sensitive data automatically. 

November/December 2013

Automatic Data Optimization

Learn how to enable information lifecycle management to automatically move data to lower-cost storage tiers and compress it. 

September/October 2013

Many in One

Create many databases in one database instance with the Oracle Database 12c multitenant architecture. 

January/February 2013

Beginning Performance Tuning: Active Session History

Identify the root cause of performance issues at a precise point in the past. 

November/December 2012

Beginning Performance Tuning: Diagnose the Past

Take the next step in diagnosing Oracle Database performance issues.

July/August 2012

Beginning Performance Tuning

Resolve session performance issues in Oracle Database.

May/June 2011

Smart Scans Meet Storage Indexes

Understand how Oracle Exadata uses storage indexes to speed I/O.

March/April 2011

Preprocess External Tables

Use inline preprocessing on external tables to simplify extract, transform, and load operations. 

January/February 2011

Simulation Demonstrates Performance

Use Oracle Exadata simulation in SQL Performance Analyzer to help predict how your application will perform on Oracle Exadata. 

November/December 2010

Managing Audit Trails

Relocate the audit trail to a different tablespace and set up an automatic purge process to keep its size under control. 

September/October 2010

Building on Storage

Create sophisticated, feature-rich clustered file systems on Oracle Automatic Storage Management disk groups. 

July/August 2010

Automating Parallelism

Take the guesswork out of setting the degree of parallelism for queries.

March/April 2010

Partition Virtually

Save space by deactivating index partitions, and use virtual columns to partition more logically.

January/February 2010

Compressing Columns

Compress more with Oracle Exadata Hybrid Columnar Compression.

September/October 2009

Scripting Oracle RMAN Commands

Learn how to create and automate scripts to execute common recovery tasks.

July/August 2009

A Refreshing Move

Encrypt, compress, mask, and deliver information with Oracle Data Pump.

March/April 2009

Baselines and Better Plans

Use SQL plan management in Oracle Database 11gto optimize execution plans. 

January/February 2009

Encrypting Tablespaces

Encrypt tablespaces transparently—without affecting performance.

November/December 2008

Keeping Active

Use Oracle Active Data Guard to set up a physical standby database for reporting and recovery. 

July/August 2008

Compress to Impress

Use Oracle Advanced Compression to conserve resources and improve performance.

March/April 2008

Performing Through Changes

Measure the impact of changes on SQL workload with SQL performance analyzer.

January/February 2008

Better Workload, Better Testing

Use database replay to record and replay database activities for better testing.

September/October 2007

More Partitioning Choices

Learn when and how to use new partitioning schemes in Oracle Database 11g

January/February 2007

Recover in a Flash

Reduce database recovery time, using the Oracle flash recovery area.

November/December 2006

Restore to the Point

Use named points in time to roll your database back by using flashback technology

September/October 2006

Partition Decisions

Understand your partition choices, and choose the best partition and key for your data.

July/August 2006

Archiving Data Using XML

Build a powerful, flexible data archive.

March/April 2006

Commanding ASM

Access, transfer, and administer ASM files without SQL commands.

January/February 2006

Auditing in XML

Create database audit trails in XML.

September/October 2005

Transparent Data Encryption

Encrypt sensitive data transparently without writing a single line of code.

July/August 2005

Mining for Clues

Use Oracle LogMiner to recreate transactions and undo damage.

March/April 2005

Room with a Better View

Get a good, fast look at your data with materialized views.

January/February 2005

Encrypt Your Data Assets

Build a flexible infrastructure to protect sensitive data.