Subscribe

Author Profile

Arup Nanda

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.

Building on Storage

Photography by Meric Dagli, Unsplash Create sophisticated, feature-rich clustered file systems on Oracle Automatic Storage Management disk groups. By Arup Nanda Se...

Automating Parallelism

Take the guesswork out of setting the degree of parallelism for queries. By Arup Nanda July/August 2010 Parallel query, the essence of the “divide and...

Compressing Columns

Compress more with Oracle Exadata Hybrid Columnar Compression. By Arup Nanda January/February 2010 Organizations are storing increasingly large amounts of data in...

Scripting Oracle RMAN Commands

Learn how to create and automate scripts to execute common recovery tasks. By Arup Nanda September/October 2009 Many DBAs have discovered how Oracle Recovery...

A Refreshing Move

Encrypt, compress, mask, and deliver information with Oracle Data Pump. By Arup Nanda July/August 2009 John the DBA at Acme Bank had some special visitors: a...

Baselines and Better Plans

Use SQL plan management in Oracle Database 11g to optimize execution plans. By Arup Nanda March/April 2009 Have you ever been in a situation in which some database...

Encrypting Tablespaces

Encrypt tablespaces transparently—without affecting performance. By Arup Nanda January/February 2009 In an era when data security is critical in almost every type...

Compress to Impress

Use Oracle Advanced Compression to conserve resources and improve performance. By Arup NandaJuly/August 2008 John the DBA at Acme Bank is looking at charts and...

Performing Through Changes

Measure the impact of changes on SQL workload with SQL performance analyzer. By Arup Nanda March/April 2008 Here is a not-so-uncommon scenario: a query is running...