Arup Nanda's Oracle Magazine Columns

nanda-headshot-2015 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



November/December 2016 JSON in Motion Create JSON documents by using plain SQL, text indexes for fuzzy searches, and relational views.
July/August 2016 Big Table Caching Cache large tables in the buffer cache and improve performance without expensive storage.
March/April 2016 Lock It Down Limit authorization to only those who need it, and remove all-powerful superuser roles with Oracle Database Vault.
September/October 2015 Unify Auditing Unify auditing to a secure, high-performance single view in Oracle Database 12c.
July/August 2015 Beginning Performance Tuning: Trace Your Steps Trace sessions to document activity details and identify bottlenecks.
January/February 2015 Recover One Recover one table from a database backup with Oracle Recovery Manager in Oracle Database 12c.
January/February 2015 Run with JSON Store JSON natively in Oracle Database 12c, and access it via SQL.
November/December 2014 A Perfect Plan Learn how adaptive plans in Oracle Database 12c compute the perfect plan—even when statistics are imperfect.
September/October 2014 It’s All In Leverage the in-memory column store in Oracle Database In-Memory to supercharge database performance–without changing application code.
July/August 2014 Managing Expressly Manage Oracle Database 12c with Oracle Enterprise Manager Database Express, a built-in browser-based graphical tool.
May/June 2014 Nonstop Partition Operations Oracle Partitioning delivers online partition moves, selective indexes on partitions, and asynchronously maintained global indexes to Oracle Database 12c.
March/April 2014 Playing Nice Together Use the Consolidated Database Replay feature of Oracle Real Application Testing in Oracle Database 12c to gauge the impact of consolidating workloads.
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 11g to 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.