NYOUG does not share its email list with any vendors or other organizations. You
may opt out of receiving our email blasts at any time by sending an email to
info@nyoug.org with "Remove" in the subject line.
There are several surprising ideas floating
around the Internet about how Oracle indexes work. Sometimes these ideas
are irrelevant and have no use or impact. Sometimes they have a serious
impact on your effectiveness. They may make you do work that need not,
or should not, be done. They may introduce down-time that you do not
need. They may make you avoid a feature that is really the perfect
feature for your application. This session reviews some of the commonly
repeated misconceptions about indexes. We all know that indexes are
supposed to make things go faster - but sometimes we forget that they
have maintenance costs - of two types.
How do you identify the optimal set of indexes for your
application?
How do you identify redundant indexes?
How do you check whether or not an index has become inefficient
and needs to be rebuilt - and how do you rebuild it most
cost-effectively?
This session discusses strategies for ensuring that you don't waste
effort supporting indexes that shouldn't exist, and don't waste valuable
batch time rebuilding indexes that don't need it.
This intensive training is designed to
jumpstart your learning in RAC, Clusterware and ASM and to show you the
ropes so that you can start learning the advanced concepts on your own.
It is intended to teach you just enough for you to understand and be
immediately effective on RAC in the minimum possible time – just one
day. This includes 11g Release 2.
A quick review of use of indexes, including some of the less
common uses and common errors in index design.
An introduction to the essential strategy for writing SQL that
gets its result by doing the minimum work, and a model for
investigating and re-engineering badly performing statements.
A brief discussion of the mechanics (and costing) of nested loop
and hash joins, and why it’s so easy it is for the optimizer to pick
the wrong option.
Fixing the code without touching the code – the latest options,
including the ways in which you can use OEM to assist with tuning.
Problems and options with knowing internal mechanisms and taking
advantage of them.
A look at a couple of popular requirements, and strategies for
addressing them as efficiently as possible.
A look at the threats of hints and how to use them properly.
Jonathan Lewis is a well-known name in the Oracle world. Currently an
Oracle ACE, and chosen as the Oracle Author of the Year 2006 for his
book Cost Based Oracle – Fundamentals (Apress, 2005). Jonathan has been
using the Oracle database software for nearly 19 years. Jonathan spends
a large fraction of his time trouble shooting high-performance systems -
a job that often requires a very detailed investigation of some of the
internal mechanisms. The time he doesn't spend on trouble-shooting is
then devoted to further investigation, writing, and teaching on the way
that Oracle works.
Scripts and Tools for Oracle Troubleshooting and Advanced Performance
Analysis
The aim of this training day is to make everyday Oracle
troubleshooting and performance analysis work easier, by providing the
right tools for the right problems. It is not simply necessary to
optimize databases and SQL statements, but also your time. Using the
right tools for the right problem allows you to perform your existing
tasks faster and focus more on proactive work. This session will
demonstrate the main scripts and tools that Tanel uses in his everyday
work to facilitate troubleshooting and performance analysis quickly and
accurately. A systematic approach for diagnosing different types of
performance problems will be used throughout all the demos. The training
day content will be roughly split into two focus areas:
How to make your everyday troubleshooting and DBA work easier
How to collect and analyze relevant performance data
Tanel Poder has over 12 years of experience managing and improving
Oracle-based database and application environments, troubleshooting,
tuning, and delivering training classes for Oracle Education and
partners. Currently, he is particularly focused researching Oracle 11g
internals and its touch point with Unix/Windows for gaining fast and
accurate troubleshooting skills. He hosts an Oracle performance tuning
blog at http://blog.tanelpoder.com.
Advanced Oracle Troubleshooting for DBAs and Performance Engineers
This expert-level seminar is concentrated entirely on Oracle
troubleshooting. Participants will learn how to systematically find the
reasons for crashes, hangs, and poor performance. The seminar explains
the full lifecycle of a database request, from client libraries and the
network to the Oracle database kernel and underlying OS. Topics covered
during the two days of intensive learning include: reading dumps, stack
traces, network packet captures and Oracle SGA. Attendees will learn
about debuggers and custom tools for real-time and post-mortem
diagnosis. Since this seminar discusses Oracle internals in detail,
attendees should already have a good understanding of Oracle concepts
and DBA tools in order to get most out of the training days.
Tanel Poder has over 12 years of experience managing and improving
Oracle-based database and application environments, troubleshooting,
tuning, and delivering training classes for Oracle Education and
partners. Currently, he is particularly focused researching Oracle 11g
internals and its touch point with Unix/Windows for gaining fast and
accurate troubleshooting skills. He hosts an Oracle performance tuning
blog at http://blog.tanelpoder.com.
Over its lifetime, PL/SQL has grown increasingly robust and complex.
Many programmers are barely aware of the new capabilities of PL/SQL,
much less fully understand the implications for their programs.
Virtually all PL/SQL developers are too pressured by deadlines to have
the time to think through the best way to apply PL/SQL's many features.
“Best of Oracle PL/SQL” offers a rapid-fire, one-day review of the most
critical new features of the PL/SQL language, focusing on the major
advances in Oracle Database 10g and Oracle Database 11g. Steven then
takes you beyond the basics to show you how to apply these features in
the context of best practices, so that you write highly optimized and
easily maintained and enhanced applications.
Steven Feuerstein, one of the world's leading experts in the Oracle
PL/SQL language, has studied PL/SQL for over 15 years and serves as
PL/SQL Evangelist for Quest Software.
Understanding and Assisting the Cost-Based Optimizer
Is there a go_faster parameter ? Which parameters affect the cost
based optimizer most? Just how does Oracle decide whether or not to use
an index? Why does Oracle do a hash join instead of a nested loop? Why
is Oracle ignoring my hints? All these, and many other questions about
the working of the Cost Based Optimizer will be answered by this
training seminar.
Jonathan Lewis is a well-known name in the Oracle world. Currently an
Oracle ACE, and chosen as the Oracle Author of the Year 2006 for his
book Cost Based Oracle – Fundamentals (Apress, 2005). Jonathan has been
using the Oracle database software for nearly 19 years. Jonathan spends
a large fraction of his time trouble shooting high-performance systems -
a job that often requires a very detailed investigation of some of the
internal mechanisms. The time he doesn't spend on trouble-shooting is
then devoted to further investigation, writing, and teaching on the way
that Oracle works.
This session was first presented at Oracle OpenWorld 2006 and was
extremely popular, with attendees spilling out into the hallway. In this
seminar you will learn about Oracle10g Streams architecture,
configuration, administration and monitoring. A supporting demonstration
will also show you the working of Oracle10g Streams.
Kirtikumar Deshpande has over 26 years of IT experience in various
capacities, including over 12 years as an Oracle DBA. He co-authored the
Oracle Press books Oracle Wait Interface – A Practical Guide to
Performance Diagnostics & Tuning published in June 2004 and Oracle
Performance Tuning 101 published in May 2001. He has presented a number
of technical papers in various Oracle User Group conferences and
meetings in the USA and abroad.
Best Practice PL/SQL with Steven Feuerstein is a
one-day whirlwind guide to the best that PL/SQL has to offer and the
best practices for writing faster, more modular and eminently
maintainable applications.
This
training session explores the alternative technologies you can use for
moving applications to the Web in an Oracle environment. It discusses
the terminology and language concepts of Java and describes how Oracle
JDeveloper 10g can help you build and deploy a complete web
application.
Carefully
chosen set of recommendations and key features to present in order to
have the greatest impact possible on your programming habits and your
overall effectiveness as a PL/SQL developer.
