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.
|
