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.

Better Workload, Better Testing

Use database replay to record and replay database activities for better testing. By Arup Nanda January/February 2008 One of the most important processes for...

More Partitioning Choices

Learn when and how to use new partitioning schemes in Oracle Database 11g. By Arup Nanda September/October 2007 The September/October 2006 issue of Oracle Magazine in...

Recover in a Flash

Reduce database recovery time, using the Oracle flash recovery area. By Arup Nanda January/February 2007 If you are using Oracle Recovery Manager (RMAN) as...

Restore to the Point

Use named points in time to roll your database back by using flashback technology By Arup Nanda November/December 2006 Jane, the lead DBA at Acme Bank, has three...

Partition Decisions

Understand your partition choices, and choose the best partition and key for your data. By Arup Nanda September/October 2006 The partitioning feature of Oracle...

Archiving Data Using XML

  Build a powerful, flexible data archive. By Arup Nanda July/August 2006   Acme Insurance Company is ready to archive data more than three years old to tape and to...

Commanding ASM

  Access, transfer, and administer ASM files without SQL commands. By Arup Nanda March/April 2006   Oracle Database 10g Release 1 introduced Automatic Storage...

Auditing in XML

Create database audit trails in XML. By Arup Nanda January/February 2006 One of the cornerstones of the security infrastructure in Oracle Database is...

Transparent Data Encryption

Encrypt sensitive data transparently without writing a single line of code. By Arup Nanda September/October 2005 It's your organization's worst nightmare: Someone...