Published Articles & Presentations


Here are all the articles and presentations authored by Proligence professionals.

 

Please note : these articles and presentations are available here without charge and are for research and knowledge sharing purpose only. Please use these at your own risk. The authors, Proligence and its associate will not be liable for any damage as a direct or indirect result of the use of this articles. Your downloading is a consent to acceptance of these terms. 

You will need Adobe Acrobat reader to view the articles.

If any article or presentation is updated after the original publication date, it is indicated in the Support column. Please check the Publication Support in that case or click on Yes.

Print and Online Publications

Title

Publication

Date

Support

Load Balancing and Fail Over in Oracle Parallel Server

Learn how to achieve failover and load balancing in Oracle Parallel Server using nothing more than Net 8.

 

SELECT - The Journal of International Oracle User Group (www.selectonline.org)

Quarter 3 2002

 

Oracle Trace: The Swiss Army Knife of Diagnostic Tools

Learn to harness the power of Oracle Trace, different from sql trace, to resolve performance problems. This article is not the original version that appeared in the magazine.

 

SQLUPDATE - The journal of the Rocky Mountain Oracle User Group (www.rmoug.org)

Fall 2002

 

Digging at the Segment Level : Performance Diagnosis Reaches A Deeper Level

Oracle 9i Release 2 provides a very useful way to find out performance metrics at the segment level, hitherto impossible, enabling DBAs to pin point problems to a specific segment.

 

DBAZine online Magazine for DBAs. Check it out at http://www.dbazine.com/nanda1.html

November 2002

Yes

Partitioning Demystified

Here is the first article under the new column DBA Corner where I discuss partitioning issues and solutions. This is the first part of the two part article discussing only tables. The next one will address the same in indexes area.

 

TechJournal - the Journal of New York Oracle User Group (www.nyoug.org) under the regular column called DBA Corner which I write every issue.

December 2002

Yes

Digging at the Segment Level : Performance Diagnosis Reaches A Deeper Level

Oracle 9i Release 2 provides a very useful way to find out performance metrics at the segment level, hitherto impossible, enabling DBAs to pin point problems to a specific segment.

 

Oracle Scene - the Publication of United Kingdom Oracle User Group (www.ukoug.org).

Issue 12 Dec 2002

 Yes

Altering the Master Table in a Snapshot Replication Environment without Recreating the Snapshot

Learn how to eliminate the biggest problem of the read only snapshot replication - altering master table. Typically your would have to drop and recreate the snapshot when the master is altered; but using this method, you save more than 95% savings in time and efforts.

 

DBAZine online Magazine for DBAs. Check it out at http://www.dbazine.com/nanda2.html

February 2003

 

An Alternative Approach to Summary Table Management Using Advanced Queues

This article presents a rather unconventional approach to dealing with the challenges of maintaining summary tables using Advanced Queues. The article covers the basics of Advanced Queues and explains with an example how there are used to maintain a real time data warehouse summary table where the complexity didn't allow for materialized view fast refreshes.
 

SELECT - The Journal of International Oracle User Group (www.selectonline.org)

Quarter 1 2003

Yes

Interested Transaction List (ITL) Waits Demystified 

Ever wondered how Oracle handles locking? This paper introduces to the reader the concept of Interested Transaction Lists (ITL), a little understood but greatly influential topic in Oracle transaction management. It explains how transactions wait for a slot in the ITL and how to reduce them for better performance.

 

DBAZine online Magazine for DBAs. Check it out at http://www.dbazine.com/nanda3.html

March 2003

 

Perils and Pitfalls in Partitioning — Part 1

Partitioning is a favorite topic for authors, presenters, and general DBA community, but most of the papers dwell on the basics and fundamental concepts behind partitioning. The invariable action of most DBAs, after learning the ropes, is to jump into their databases with partitioning in mind. This article describes some of the potential problems — little or non-documented features that may create unanticipated (and unwanted) situations to which you should be alert, and how to resolve them. Understanding these potential problems will go a long way in designing a proper partitioning scheme for your database. Caution: to get the most from this article, you should already have basic knowledge about partitioning; t his article is not a primer on that subject.

 

DBAZine online Magazine for DBAs. Check it out at http://www.dbazine.com/nanda4.shtml

June 2003

 

Perils and Pitfalls in Partitioning — Part 2

Continuation of the above topic.

 

DBAZine online Magazine for DBAs. Check it out at http://www.dbazine.com/nanda5.shtml

July 2003

 

Rediscovering SQL*Plus

Learn a few tricks for this grand daddy of the Oracle tools - format the output into html; allow trying for login only once; restrict certain commands and more, with working examples.

 

Oracle Scene - the Publication of United Kingdom Oracle User Group (www.ukoug.org).

Issue 15, 2003

 Yes

New Tool on the Block - Segment Level Statistics

Learn how to use a very powerful and useful tool to diagnose some perennial database problems easily and quickly. The article explains the new views v$segstat, how to populate them and use them to resolve problems.

 

SELECT - The Journal of International Oracle User Group (www.selectonline.org)

Quarter 3, 2003

 

Journey Into Partitioning - Same Goal Many Paths - Part 1

After you have decided to move to partitioning, what's the best method to convert the existing tables? Arup Nanda highlights the various options and their relative merits and drawbacks so that you can decide on their suitability for your needs. 

 

DBAZine online Magazine for DBAs. Check it out at http://www.dbazine.com/nanda6.shtml

September 2003

 

Journey Into Partitioning - Same Goal Many Paths - Part 2

Part 2 of the above article. 

 

DBAZine online Magazine for DBAs. Check it out at http://www.dbazine.com/nanda7.shtml

October 2003

 

Fine-Grained Auditing in the Real World

How difficult is to understand and implement Oracle Fine Grained Auditing? Too tough? Certainly not; but too easy? Probably not while navigating through the maze of documentation.  Instead, use this handy article to learn this with step by step tutorials and real world examples from one of the world's top Oracle security experts. This is a three-part article series. Read the first part. Learn how to use the Oracle Database's fine-grained auditing feature to track read-only accesses to specific rows of tables—and much more

 

Oracle Technology Network (or Oracle Magazine Online).

December 2003

Yes

Diagnosis of Interested Transaction List Waits

Get an insight into the way Oracle handles locks, a relatively lesser known Oracle internal feature - ITLs and how to resolve them.

 

Oracle Scene - the Publication of United Kingdom Oracle User Group (www.ukoug.org).

Issue 16, Winter 2003

 

Fine-Grained Auditing in the Real World Part 2

How difficult is to understand and implement Oracle Fine Grained Auditing? Too tough? Certainly not; but too easy? Probably not while navigating through the maze of documentation.  Instead, use this handy article to learn this with step by step tutorials and real world examples from one of the world's top Oracle security experts. This is a three-part article series. Read the second  part. After mastering the basics, learn the advanced concepts in Fine-Grained Auditing and resolve issues with the application user model.

 

Oracle Technology Network (or Oracle Magazine Online).

January 2004

 

Oracle Database 10g: The Top 20 Features for DBAs
Join Oracle Magazine's 2003 "DBA of the Year" Arup Nanda over the next 20 weeks as he presents his list of the top Oracle Database 10g features for database administrators Join the exciting journey on exploring the Oracle 10g new features.

 

Oracle Technology Network (or Oracle Magazine Online).

January 2004

 

Presentations

Title

Venue

Date

Support

Real World RAC Performance Tuning

How do you decipher the mysteries and information behind all that gc_* waits? This presentation offers a practical, real world analysis of a RAC database performance.

 

New York Oracle User Group (NYOUG) DBA SIG – Manhattan

Oct 11, 2007

 

Real World DBA Best Practices

There are several ”best practices” proliferated by articles, books, presentation and words of mouth. Learn the best practices as applicable in the real world as proposed by a veteran DBA of 13 year.

 

New York Metro Area Oracle Technology Day organized by New York Oracle User Group (NYOUG)

Oct 2, 2007

 

Intrusion Detection in Oracle Scripts

Learn how to detect various types of intrusion in Oracle; how to devise tools and techniques to detect intrusion using the tools available everyday, e.g. SQL*Plus and PL/SQL. Make sure you download the scripts as well as the powerpoint,

 

Rocky Mountain Oracle User Group (RMOUG) Training Days 2007

Feb 15, 2007

 

Digging Deeper - Segment Level Statistics in Oracle 9i R2

Learn how to resolve storage related database performance problems using the new segment level statistics features of Oracle 9i Release 2. The download contains the presentation and all the supporting files used for the demonstration.

 

Virginia Oracle Training Conference, Richmond

Oct 11, 2002

Yes

Profile and Tune Using Oracle Trace

Oracle Trace, different from sql trace, a powerful and versatile tool for resolving a variety of performance problems and profiling canned applications, without using any other tool. Learn how to use this tool to diagnose problems impossible otherwise.

I am extremely sorry for the lack of sufficient handouts at the meet. The AOTC organizers, not me, distributed the handouts and obviously they did not expect the 100+ turnout! Please download the presentation as well as the article on Oracle Trace above for a more complete discussion. This download also contains all the scripts I used during the live case study.

 

Atlantic Oracle Training Conference, Washington, DC

 

 

Nov 1, 2002

 

Digging Deeper - Segment Level Statistics in Oracle 9i Release 2

Oracle 9i Release 2 provides a very useful way to find out performance metrics at the segment level, hitherto impossible, enabling DBAs to pin point problems to a specific segment.

 

New York Oracle User Group, New York, NY

Dec 12, 2002

Yes

Partitioning Demystified: Presentation Article

Beyond the basics - this presentation explores the advanced concepts in partitioning and the little or non documented tips and tricks to achieve a well designed system in partitioning and potential problems and how to avoid them. Be sure to download the paper, which is written in a more explanatory manner. The presentation is in form of a PowerPoint Show.

 

Oracle Technology Symposium, Stamford, CT

March 27-28, 2003

 

Summary Management Using Advanced Queues Presentation Whitepaper

Advanced Queues are not just for developers - it could be an extremely valuable tool for real time data warehouses, maintaining flattened denormalized tables and simplifying OLTP complex queries. This session describes the problem of maintaining summary tables using usual triggers approach and how to resolve it it using Advanced Queues. It also describes in detail how to set up an AQ system with code samples. A prior knowledge of AQ is not necessary.

 

International Oracle User Group (IOUG Live! 2003), Orlando, FL

May 1st, 2003

 

Painless Master Table Alter Presentation Whitepaper

Read Only Snapshots provide some of the most valuable and convenient tools to provide a replication solution for reporting; but there is a potentially expensive operation involved when the master table is altered. The Oracle recommended approach is to drop the snapshot and recreate it. However, in case of a large table, this operation is quite resource consuming. This session presents an alternative unconventional way to achieve the same without dropping the snapshot, thereby saving 99% of time and efforts.

 

International Oracle User Group (IOUG Live! 2003), Orlando, FL

May 1st, 2003

 

A Multisource Time-Variant Data Warehouse Case Study Presentation Whitepaper

Is creating a DW difficult? This presentation proposes a radical new approach to designing and developing a datawarehouse using only Oracle tools, with the aid of an example case study. Oracle 10g new features for DW are also covered.

 

OracleWorld 2003, San Francisco, CA

Sep 11th, 2003

 

Fine Grained Access Control and Oracle 10g Enhancements : Paper | Presentation | SQL Scripts

Learn the soup to nuts of creating a FGAC setup, aka Virtual Private Database (VPD) step-by-step and the exciting new features in Oracle 10g related to these. Be sure to download both the presentation and paper; the latter has the scripts required for the setup.

 

New York Oracle User Group, New York, NY

Dec 11th, 2003

 

Datawarehouse From Beginner to Advanced in Two Hours : Paper | Presentation

You can do it, that is creating a full fledged data warehouse with complexity and sophistication to boot. This presentation covers the tools and techniques built exclusively with Oracle provided tools such as PL/SQL and SQL Plus. Make sure you download the paper for a detailed discussion on the techniques, not just the presentation. 

 

North East Oracle User Group - Boston DBA SIG Meeting. Burlington, MA 

Feb 10th, 2004

 

 

All materials copyrighted. Use of these articles in a non-profit making initiative is accepted, provided the reference to the author and Proligence made clearly. No changes to these articles are allowed. The authors, Proligence or its affiliates are not responsible for any kind of damages as a result of the use of these articles.

 

© 2002, Proligence. Oracle is a registered trademark of Oracle Corporation