|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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
|
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 – |
Oct 11, 2007 |
|
|
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, |
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.
|
Oct 11, 2002 |
||
|
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.
|
Dec 12, 2002 |
||
|
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.
|
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.
|
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.
|
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. |
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