|
| |
| | Events |
| |
06/22/12
(Fri) | 06:30PM - 09:30PM TOPIC: 10 Things You Probably Did Not Know?
Speaker: Tom Kyte
DATE: June 22, 2012 (Friday) between 6:30 to 9:30 PM.
TOPIC: 10 Things You Probably Did Not Know?
Five Things You Probably Didn't Know about SQL:
|  |
SQL is an extremely powerful language these days. It offers set-based processing, iteration, and recursion. In short, it has many of the qualities of a procedural language and a declarative language. This session explores five things you probably didn't know about SQL.
Five Things You Probably Didn't Know About PL/SQL:
PL/SQL turns 23 years old this year. It was first introduced in 1988 with Oracle6 Database. This session looks at five technical things about PL/SQL you probably did not know: under-the-covers features that make PL/SQL quite simply the most efficient language with which to process data in the database.
BIO
Tom Kyte is a Senior Technical Architect in Oracle’s Server Technology Division. Tom Kyte is the Tom behind the AskTom column in Oracle Magazine, answering people's questions about the Oracle database and its tools (http://asktom.oracle.com/). He is also the author of Expert Oracle Database Architecture, Expert One on One Oracle, Beginning Oracle Programming, and Effective Oracle by Design.
NOUG membership is required to attend this meeting.
If you would like to
join NOUG, please visit our website at www.noug.com. Please RSVP to
treasurer@noug.com or lysonludvic@yahoo.com if you plan to attend the
meeting or have any membership questions.
Venue: Doubletree by Hilton
5400 Computer Drive
Westborough, MA 01581 |
|
06/28/12
(Thu) | Dallas Oracle Users Group (DOUG)
The DOUG (DALLAS ORACLE USERS GROUP) has invited SpeakTech to return to Dallas, and they’re bringing Jonathan Lewis!
Date and Venue
The event will be June 28-29, 2012 at SMU-in-Legacy in Plano, TX.
Training Topics
Beating the Oracle Optimizer – June 28, 2012
Trouble-Shooting & Tuning – June 29, 2012
Pricing
The non-DOUG member price is $350 for each day, or $600 for both. DOUG members receive a 15% discount, so they would pay $297.50 each day or $510 for both.
To register for this event using your DOUG current-member discount, contact the DOUG membership administrator atdougadministrative@gmail.com and she will get you instructions on how to obtain the discount rate.
To register for this event on a full-price basis, click on http://www.eventbrite.com/event/3082448687.
More Details
Each attendee will receive a free copy of Jonathan’s latest book
“Oracle Core: Essential Internals for DBAs and Developers", a $31.91 value, or a $31.91 Amazon gift card, or a free one-month subscription to Safari Books Online, a $42.99 value.
Check-in and a complimentary breakfast will be held each day from 8:00 to 8:30 and the seminar will run from 8:30 to 4:00. Lunch will be provided each day.
Beating the Oracle Optimizer
This tutorial has two targets. First: how do you improve the performance of a production system by attacking inefficient SQL; secondly: how do you design a system so that you can get data into and out of it efficiently.
For most people, the design has already happened, nevertheless you need to be aware that the two targets overlap significantly. As you struggle to address a particularly inefficient piece of SQL you need to be aware that there are structural features of the database that may help you find a cost effective solution despite the problems imposed by the SQL itself.
The course will focus on the SQL – falling back to structural issues as an aid to improving the mechanical efficiency of the SQL solution – and will spend some time explaining the pros and cons of various structural options as they become relevant to the SQL.
The course will cover methods of reviewing data distribution patterns, use of indexes and views (stored and inline), analytic functions, subquery factoring, and a brief review on hints and execution plans.
Trouble-Shooting & Tuning
The users are complaining right now! How do I find the problem – what’s the short term fix – what’s the long term fix?
The overnight batch ran on until 9:30 this morning when it’s supposed to complete at 5:00 a.m. – what went wrong?
Good performance starts with good design – which means you have to know how much data you have, where to put it, and how you’re going to use it. Working out the best strategies is called tuning. After go-live you don’t do tuning, you do trouble-shooting, and the strategies have to change to suit the circumstances.
In this one-day course, we learn how to think around design issues (the tuning) as well as looking at strategies – and some fixes – for addressing implementation problems (the trouble-shooting). The final session of the course examines some of the dynamic performance views, what you can do with them, and how their contents are reported in the Statspack and AWR reports.
Mary Elizabeth McNeely
DOUG President and Oracle Database Forum Chair |
|
|
|
| |
|
You are visitor #55705 (this site was last updated 05/10/12 11:12PM) |
|
|
| | |
|
Login
