Arup Nanda’s Oracle Magazine Columns

 

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 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.