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.

Many in One

Create many databases in one database instance with the Oracle Database 12c multitenant architecture. By Arup Nanda September/October 2013 John, the lead database...

Beginning Performance Tuning: Active Session History

Identify the root cause of performance issues at a precise point in the past—even when the sessions have disconnected. By Arup Nanda January/February 2013 In my...

Beginning Performance Tuning: Diagnose the Past

Take the next step in diagnosing Oracle Database performance issues. By Arup Nanda November/December 2012 In “Beginning Performance Tuning,” in the July/August...

Beginning Performance Tuning

Resolve session performance issues in Oracle Database. By Arup Nanda July/August 2012 It’s the middle of the night, and you get a frantic call from someone...

Smart Scans Meet Storage Indexes

Understand how Oracle Exadata uses storage indexes to speed I/O. By Arup Nanda May/June 2011 The Oracle Exadata Database Machine brings database performance to a...

Smart Scans Meet Storage Indexes

Photography by Dmitri Popov, Unsplash Understand how Oracle Exadata uses storage indexes to speed I/O. By Arup Nanda May/June 2011 The Oracle Exadata Database...

Preprocess External Tables

Use inline preprocessing on external tables to simplify extract, transform, and load operations. By Arup Nanda March/April 2011 External tables, available since...

Simulation Demonstrates Performance

Use Oracle Exadata simulation in SQL Performance Analyzer to help predict how your application will perform on Oracle Exadata. By Arup Nanda January/February 2011 T...

Managing Audit Trails

Relocate the audit trail to a different tablespace and set up an automatic purge process to keep its size under control. By Arup Nanda November/December 2010 One...