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.
Getting the Most Out of Oracle’s Active
SessionHistory,
Time Model, and Wait Events
This
1-day seminar is for developers and DBAs who want to become more
systematic in their performance diagnosis work and can use Oracle's
Active Session History (part of Diagnostics Pack) for that. It provides
a quick and efficient overview of the superb performance analysis
capabilities of ASH in just a day. In addition to the slides, demos and
Q&A, you will see Tanel's ASH scripts and troubleshooting techniques in
action and will learn how the ASH data can provide the answer to most of
the common performance diagnosis questions out there.
This session is
designed as an introduction to Application Express.Attendees will learn the basics of ApEx which include working
with the SQL Workshop and Application Builder. The former allows users
to navigate through database schemas and do basic DBA operations. The
latter is where the “magic” of ApEx happens. Attendees will learn to
create an application and add content such as forms, reports, graphs,
lists, buttons, and other display items. In addition, attendees will
understand how to add their own code to enhance the out-of-the-box
abilities of ApEx.
In 2012, the Oracle PL/SQL language will celebrate its 23rd
birthday. Not bad for a language that initially found its application
inside SQL*Forms V3 and is now widely regarded as the most powerful,
flexible and well-structured relational database programming language.
Twenty-three years also has provided Oracle with lots of opportunity to
enhance PL/SQL, which makes it ever more challenging for programmers to
keep up with all the enhancements.
This one-day training covers the most critical
features you need to know about if you are going to write PL/SQL
programs that fully utilize the capabilities of modern PL/SQL in the 21st
century, including the most important enhancements of Oracle Database
11g.
The day will finish with a quiz on the topics
covered, and prizes awarded to the top 5 scorers. Winners will be
announced at the PL/SQL Challenge website, where thousands of Oracle
technologists play daily, weekly and monthly quizzes on PL/SQL, SQL and
APEX.
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.
