Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 








Oracle RMOUG conference attracts top Oracle sessions

The Rocky Mountain User Groups Training Days (RMOUG) has published their list of abstracts, with a virtual who's-who of the world's top Oracle experts.

RMOUG Training Days 2007 is held in Denver Colorado on February 14th-15th, a perfect change to enjoy some of the world's best Oracle information and the world's best skiing. 

Here is a small sample of some of the not-to-miss RMOUG presentations:

Application Development:

Advanced Oracle Application Express (formerly HTMLDB) Tips and Techniques - Brad Brown

Application Express is a powerful and comprehensive tool. Numerous advanced tips and techniques will be covered in this presentation. These topics include pop-up windows, complex searches, document management, indexing and searching,"tool tip" or hints, e-mail links, page 0, help text, background jobs,"add to my calendar" feature, saving contacts (VCF), sending mass e-mails, and more.

Hypercharge your Oracle SQL - Donald K. Burleson

This dynamic and in-depth presentation will focus on real-world techniques for improving the speed of SQL queries with a focus on the new Oracle 10g features. The topics will include the new Oracle parameters that affect SQL performance, the use of hints to change SQL execution plans, re-writing SQL queries in more efficient forms and the use of advanced techniques such as Materialized Views, replacing SQL with PL/SQL, the new automated CBO statistics collection, and using the new Oracle 10g CPU costing approach. This presentation will show actual case studies to illustrate the performance differences with these approaches to SQL tuning. Best of all, the presenter will share his proven SQL tuning secrets that ensure optimal SQL execution.

Insider Tips for Oracle Application Express (formerly HTMLDB) - Steve Karam

ApEx (HTMLDB) has become a wildly popular system development platform and Oracle has always emphasized how HTMLDB can be used to quickly create working applications. However, ApEx can be extended easily into a fully robust tool that can be used to deploy super sophisticated systems. This presentation will show little-known techniques for performing complex screen interfaces and leveraging Java, and special techniques for large scale systems development. Topics will include cascading menus, dynamic included content, updateable repeating display and much more.

Screen Ergonomics for Oracle Developers - Janet Burleson

Most Oracle professionals understand the technical mechanisms of Oracle tools such as SQL*Forms, HTMLDB and JDeveloper to write applications, but many are not aware of the rules of ergonomics. When online screens are used by thousands of people everyday, the Oracle application must optimize the interaction and allow the end user to complete their task with a minimum amount of work. This presentation will show real-world examples of Oracle ergonomic design, illustrate techniques for improving end user satisfaction and improving productivity. We will show time-saving techniques, best practices for screen design and how to minimize typing and maximize throughput. This session is ideal for system development managers and Oracle developers who want to understand how to deliver robust, easy-to-use applications.

Being Regular with Regular Expressions - John Garmany

This presentation will explain the why and how of using regular expression with Oracle. Unix SAs know the power of matching with regular expression and now the Oracle DBA and Developer can put that power to use. But regular expressions are not the only or even the best answer in all situations. We will cover your regular expression options in the SQL, PL/SQL and Java. While most DBAs do not use Java, it does provide a rich and powerful regular expressions capabilities that SQL and PL/SQL do not have. Similarly, improper use of regular expression can have a large negative impact on database performance. The presentation will explain the pros and cons of each method and when they can best be utilized to provide you with high performance matching capability.

Putting the Express Back Into Oracle Application Express with Ajax - Steve Karam

When Oracle changed the name of HTMLDB to Oracle Application Express (ApEx), many people wondered just where the "express" came from. Sure, it's easy to make quick and dirty applications that handle large amounts of data, but it's just so bulky for the end user! This presentation will show how to use emerging Asynchronous Javascript and XML (Ajax) technology to make your ApEx applications lightning fast for your users. We will examine the use of Ajax in submitting forms and retrieving data, both as single fields and even in complex reports. By pairing Ajax with DHTML, we can build advanced screens that retrieve data on the fly without a single page refresh.

"Futurecast" with SQL Model - John King

Today the ability to project future data plays a large part in management planning. Oracle 10g added the SQL Model clause making complex "projection" calculations easier to create and use. Model is an extension to the SQL Select statement defining a multidimensional array by mapping query columns into three groups: partition, dimension, and measure columns. This presentation demonstrates the creation and use of "future" values via SQL using the Model clause.

Ruby on Rails Revisited - Dustin Marx

Ruby on Rails is a framework intended for rapid Web application development. This presentation is based on the presentation "Riding Rails to Ruby and Riches" that was presented at RMOUG Training Days 2006, but adds significant code examples and demonstration of rapid development with Rails. Topics discussed during the course of the presentation include using convention rather than configuration, overriding Rails' conventions for use with legacy database schemas, using and overriding Rails' scaffolding, Rails' support for easier use of XMLHttpRequest (often called Ajax or Asynchronous JavaScript and XML), and three approaches to accessing Oracle stored procedures from Rails.


DBA Sessions:

Intrusion Detection in Oracle - Arup Nanda

Using concrete scripts and examples, this session will explore, with concrete scripts and examples, different methods to identify intrusion detection in an Oracle database to satisfy most security and privacy regulations and mandates. Attendees will learn the different types of intrusion and the sources of information to detect them. Topics will include: hacking attacks against the listener—denial of service, buffer overflow, etc.; attacks against the database—malicious entry, unauthorized access and denial of service attacks; mining information from listener log to know about listener attacks; simple and advanced Oracle auditing; and many more. All topics will be shown with live working demonstrations.


Oracle Tuning sessions:

Linux 2.6 I/O Schedulers and Data Warehousing - David Aldridge

The Linux 2.6 kernel allows the choice of four different i/o schedulers, which give priority to reads and writes in different ways. Conventional wisdom is that the CFQ scheduler represents the best compromise choice for many application types, but the anticipatory scheduler is in fact superior for systems characterized by multiple large sequential read requests of contiguous data—in other words, Oracle data warehouses. This presentation explains the scheduler types available, demonstrates how they react to a parallel query environment, and how the read bandwidth of devices varies with increasing degree of parallelism.

Average Active Sessions—The Magic Metric? - John Beresniewicz

The Oracle 10g RDBMS exposes a conceptual, architectural and user-interface framework for identifying and diagnosing performance problems that uses database time as the core measure of performance impact. The wait-model performance analysis approach now in wide use by experienced DBAs has been formally embedded into Oracle 10g. One key new concept introduced is that of the time-normalized DB time, referred to formally as Average Active Sessions. This presentation will discuss the origin and meaning of Average Active Sessions and its visibility and usage in Oracle 10g, including ASH, AWR, V$ tables, sysmetrics and server alerts, and Enterprise Manager. We will focus on both theoretical and practical aspects of this important number.

Inside Oracle: Using Diagnostic Events - Randy Cunningham

This presentation provides practical, useful information focused on the productive use of Oracle diagnostic events. In addition to gaining an overview of what diagnostic events are, participants will gain practical, immediately usable information on how to enable and disable events for the current session, another session and for a database instance. Syntax, locating event trace files, troubleshooting database errors, event codes, and tools for analyzing and formatting trace output will be discussed. Best practices for using events, including situations where events should never be used. Properly used, Oracle diagnostic events can help to increase productivity, system availability and service levels.

The Power of Indexing - John Garmany

Indexes are the easiest way to get great performance gains. However, indexing pitfalls are many. This presentation will cover indexes in the Oracle database, focusing on when and how to add indexes, the different types of indexes and when to use each type. It will also cover common indexing errors found in many database configurations. It includes a discussion of tools that will allow you to determine if your index is used correctly by the SQL that needs it. Lastly it will demonstrate using the Oracle 10g Automatic Workload repository to monitor and diagnose indexing problems.

Wait Events and the Geeks Who Love Them - Kyle Hailey

The wait interface method for tuning Oracle databases has become well known. Unfortunately the exact meaning of the wait events themselves is still shrouded in mystery. Now for the first time, each of the top 30 wait events will be explained in detail and examples of typical causes and solutions given. The top 30 wait events represent 99.9 percent of the wait time reported in Oracle customer databases. Note: the lecture is aimed at version 7 through 9, though some version 10 wait events will be discussed. Lecture excludes RAC and OPS wait events.

Wait-Time Based Oracle Performance Management - Dean Richards

There are many ways to use Oracle wait events for performance tuning of an Oracle database, but often there is confusion on exactly what the data means. The issue typically centers around the fact the wait event data is analyzed at the wrong level or the collected wait event data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using wait event data to solve the most difficult performance-related issues.

CBO's Costing Of PL/SQL Functions - Joze Senegacnik

The CBO calculates the cardinality of a row source (i.e. table, result of previous operations) from the base cardinality of the row source and the estimated selectivity of predicates. The cardinality is then used for subsequent calculation of the cost of the execution plan which is used as an internal measure to select the optimal execution plan. CBO cannot determine the selectivity of predicates containing user-defined functions implemented usually in PL/SQL without the additional information. The process of defining their selectivity and cost is usually overlooked, although the extensible optimizer contains such mechanisms. When CBO is armed with these important details it can define the proper order of execution of different row source operations. The second part of the presentation will cover creation of statistic types for more complex functions where one can define his own selectivity and cost calculation functions which are called by CBO while the SQL statement is parsed.

ASHPROF? A TKPROF Replacement? - Graham Wood

The data sampled in the Oracle 10g Active Session History can be used in many ways. This session will look at how ASH data can be used to get the equivalent of TKPROF, but without all the issues of having to enable SQL*Trace and then find the trace. It might not get you everything available in TKPROF but it is available, cheap and easy to use.


RAC Sessions:

Why Does Oracle Have a Third Party Clusterware Validation Program for Linux, and Why Should I Care? - Kevin Closson

Oracle Real Application Clusters has shipped with Oracle-provided "clusterware" on Linux and Windows since the initial release of 9i RAC. While the name has changed from OCMS to CRS, and then Clusterware, few people actually know what it does or how it is implemented. RAC has been available for more than five years and it is as easy as ever to become confused where clusterware is concerned. All legacy RISC platforms support integrated Vendor clusterware packages along with Oracle Clusterware, and now Oracle has a Third Party Clusterware Validation Program for Linux. Why? This session introduces the new third party clusterware validation program, why you should care, and such important RAC-related concepts as fencing, node-membership services and high-speed interconnects.

Introducing the Flexible Database Cluster Architecture for Server Consolidation - Kevin Closson

The datacenter trend towards server consolidation is occurring at a rapid pace. The motivating factors behind server consolidation include agility, availability, security and regulatory compliance. But risk avoidance is important since applications don't always coexist. Choosing an architecture for consolidation that offers manageability, flexibility, and application isolation is essential. Modern commodity Linux-based clustered systems can be a powerful and effective architecture for consolidation. This presentation covers a Proof of Concept by consolidating 60 Oracle 10g databases into a manageable 14-node Linux-based cluster. Focusing on architecture, deployment techniques, monitoring, SLAs, and low-impact server repurposing makes this presentation a must-see for any IT organization planning a server consolidation effort.

To RAC or not to RAC? A Manager's View - Steve Karam

To a DBA, RAC is very tempting; you will get scalability, high availability, and performance load balancing, not to mention a great mark on your resume, all in one fell swoop. However, going to RAC can be costly. In order to attain the money, man-hours, and training necessary to implement RAC in your environment, you will most likely need manager approval. This presentation targets the manager of a database shop where RAC may be under consideration. We will discuss costs, pros and cons, and the full impact it will have on your staff, training, data center, and company.

Oracle Clusterware: Beyond Real Application Clusters - Marshall Presser

Those familiar with Oracle 10g Real Application Clusters are aware of the role the Oracle Clusterware plays. But Oracle Clusterware can be used to provide High Availability for more than just RAC. In this session, we'll discuss the basics of Oracle Clusterware and see how it works with some real world examples, such as the Oracle Application Server and perhaps even an Oracle 10g Single Instance database. No knowledge of clustering or RAC is required. This session would be of interest to DBAs, SAs, and data center managers.

Proactive Load Balancing in Oracle 10gR2 RAC - Murali Vallah

All versions prior to Oracle 10g Release 2, load balancing was more of a reactive nature, meaning that unless the session established a connection to the server, the session was not aware of the load. In Oracle 10gR2, this is gone. It is all proactive now. Before the session attaches to the database, the database will inform the client of its current state. Isn't this interesting? This presentation will discuss this concept, its architecture, its implementation and monitoring.




Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational