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.

Load and Buffer Fast Enough for IoT

Ingesting large volumes of data from IoT devices? Learn how to make inserts and queries blazing fast in Oracle Database 19c with Memoptimized Rowstore. By Arup...

Autonomous Indexing

The new Automatic Indexing feature in Oracle Database 19c detects the need for indexes, creates them, and drops them automatically—without DBA intervention. By...

Using Oracle Machine Learning Notebooks

Set up and run machine learning in Oracle Autonomous Data Warehouse. By Arup Nanda May/June 2019 Acme Corp., a leading seller of high-end merchandise on the...

Automatic and Easy

Oracle Database 12c Release 2 delivers better automatic, multicolumn, and read-only partitions. By Arup Nanda September/October 2017 Partitioning has been a...

JSON in Motion

Create JSON documents by using plain SQL, text indexes for fuzzy searches, and relational views. By Arup Nanda November/December 2016 “You’re a victim of your own...

Big Table Caching

Cache large tables in the buffer cache and improve performance without expensive storage. By Arup Nanda July/August 2016 John, the lead DBA at Acme Bank, puts...

Lock It Down

Limit authorization to only those who need it, and remove all-powerful superuser roles with Oracle Database Vault. By Arup NandaMarch/April 2016 John, the...

Unify Auditing

Combine disparate audit trails to a secure, high-performance single view. By Arup NandaSeptember/October 2015 Database auditing involves systematically recording u...

Beginning Performance Tuning: Trace Your Steps

Trace sessions to document activity details and identify bottlenecks. By Arup Nanda July/August 2015 In 2012 and 2013, I wrote three articles for Oracle Magazine o...