Arup Nanda's Oracle Magazine Columns


Arup Nanda Headshot Arup Nanda (arup@proligence.com) 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

Title

Description

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.