| |
2009 Meetings
August
Monthly Meeting
Date: Monday
August 17th
Time:
7:00 PM
Topic: 2
Presentations (see descriptions below)
Speaker: Craig Shallahamer, OraPub founder and
President
Craig is a researcher, writer, and teacher for thousands of DBAs. He
began his string of publishing more than twenty-three technical papers
and authored the book Forecasting Oracle Performance. He is the author
and creator of the popular Oracle Performance Firefighting and Oracle
Forecasting & Predictive Analysis courses. After nine years with
Oracle Corporation during which he co-founded the Core Technologies and
the System Performance Groups, in 1998 he left Oracle to start OraPub.
He is a passionate educator, a pinnacle of Oracle knowledge, and an
engaging instructor. His entertaining presentation style combines with
his depth of Oracle experiences to make each class unique. He has
taught thousands of DBAs on six continents in twenty-tree countries!
Presentations:
Serialization
Control; The lock, latch, & mutex
For
a high performing Oracle system, serialization is death. That's why
understanding, detecting, and resolving serialization issues are
extremely
important. Many DBAs feel there is little you can do when
serialization
issues raise their ugly head. Not true! I have found once one
understands the
general latch and mutex algorithms and equipped with Oracle's memory
architectures and internals, latch/mutex contention solutions become
very
apparent. This presentation provides an in-depth look into memory
serialization
control, how Oracle's algorithms ensure the necessary serialization,
and how we
can get involved to ensure serialization issues do not remain a problem.
Introduction
to Applied Response Time Analysis
All
performance analysis begins with
a solid understanding of response time analysis; its components,
sources of
data, and mathematics. This presentation will introduce you to how
response
time analysis provides the performance analyst with a very comfortable
and
confident way to communicate the current and future performance
situation. A
template and an interactive response time graph will be used to help
understand
how we, as performance analysts, can represent and influence the
performance
situation in our favor.
Also,
Craig will be giving away two
of my new books, Oracle Performance Firefighting. And I'll provide
every
attendee with a 25% discount coupon if they order the book on-line.
Thanks for attending Craig
Shallahamer's presentation to
the user group on the 17th. We had 51 members attending - that was
great! Craig
has a link for the presentation at http://resources.orapub.com/product_p/South2009.html.
OraPub (Craig's company) is
offering our user group
members a 15% discount on their registration fees on either of OraPub's
courses
in October. Craig will be returning to Atlanta to teach his 3 day
Oracle
Performance Firefighting (October 19 - 21) as well as a brand new
two-day
course Advanced Oracle Performance Analysis (October 22-23). Details
including
the course syllabus for both classes as well as online registration are
available at www.training.orapub.com.
To access the GOuser registration
discount, enter the
discount code GEORG15.
July
Monthly Meeting
Date:
Thursday
July 9th
Time:
7:00 PM
Topic: Bi-Directional
Data Replication Using Oracle
Streams
Speaker: Iftequar F Mohammed
Database Administrator
Global Reservation and Guest Technology (RGT)
IHG - InterContinental Hotels Group
Click
Here for Iftequar Mohammed's (zip file) presenation
May
Monthly Meeting.
Date:
Thursday
May. 14th
Time:
7:00 PM
Topic: "Life Cycle of a Cursor"
Shareable cursors(Parent and child cursors), How parsing works, Bind
variables, bind variable graduation and bind peeking and best practices
related to bind variables.
Speaker: Sameer Malik,
Sameer has a Master in computer applications(MCA), Oracle 9i certified
OCP and Oracle 10g certified OCP, IOUG and GOuser member and having ~6
years of working experience as a production DBA with primary focus area
in sql tuning and Database tuning. Sameer is currently working as a DBA
at
Equifax.
Click
Here for Sameer Maliks Powerpoint presenation
Un-Conference'
Event
Speaker: Tom
Kyte, VP, Oracle Corporation
Date:
March 24, 2009
Time:
11:00am to3:00pm (doors open at 10:30am)
Costs:
$20 (Includes lunch)
Click
here on how to reserve your spot.
Topics:
Database Worst
Practices: This presentation turns that around and takes a look
at some "worst practices," the top things you can do to ensure failure,
delays, and poor performance in your database applications. Instead of
focusing on things to do in your database applications, the
presentation looks at things you should never do.
The Best Way: Today
there are many ways to do the same thing—sometimes it seems there are
an infinite number of ways to accomplish something via software.
Oracle's "Ask Tom" technology expert, columnist, and author takes a
look at best practices, rules of thumb, and frameworks and discusses
their promise and their shortcomings. Gain insights on what developers
have done in the past and how that forms the basis for how they will do
things going forward—which is both good and bad.
Date: Thursday
Feb. 12th
Time:
7:00 PM
Topic: Can You Function?
Speaker: David Scott
David is a
Principal
Database Consultant, Intec Government Solutions and the President,
GOusers
This
introductory session will explore:
- Use of
functions in SQL statements
- Lesser-known
built-in SQL functions
- Introduction
to analytic functions
- Creating
your own custom functions
- Performance
issues related to custom functions
Date:
Thursday
Jan. 8th
Time:
7:00 PM
Topic: Latency
Speaker: Mike Ault
Click
Here for Mike Ault's Powerpoint presenation
Date:
Thursday
Dec. 11th
Time:
7:00 PM
Topic: Grid Control in the Real World.
Speaker: Kay Malcolm, Oracle Corporation
Kay
had a great presentation in Grid Control. Here is the link to the
GOuser Portal at Oracle.
http://launch.oracle.com/?goug
Come
listen and learn some best practices around
implementing Grid Control in your environment. Learn what
everyday tasks
can be replaced with Grid Control and ways to speed resolution of
your to
do list. The end goal for this session is to help administrators
and
developers go from being reactive to proactive.
Date:
Thursday
Nov. 13th
Time:
7:00 PM
Topic: Introduction to Oracle Stream
Speaker: Waleed Ahmed, Oracle
Corporation
Click
Here for Waleed Ahmed's presenation
Date:
Thursday
Oct. 9th
Time:
7:00 PM
Topic: Data Guard - Logical Standby Database
Speaker: Bill Sutton
In
this presentation,
attendees will learn how to
leverage Oracle Data Guard's Logical Standby Database to provide
protection
against unplanned downtime, while simultaneously supporting real-time
reporting
requirements.
Attendees
will be introduced to the fundamentals of
Data Guard:
- configurations (Primary, Standby)
- services (Redo Transport, Log Apply, SQL Apply, Role Transitions)
- protection modes (Maximum Protection, Maximum Availability, Maximum
Performance)
...
along with
the following aspects of a Logical Standby Database:
- benefits
- components
- implementation
- features
Click
Here for Bill Sutton's presenation
Date:
September 11, 2008
Topic:
How to
setup 11g CRS and ASM with 10gR2
RAC database with ASO and Database Vault.
Speaker: Marvin Vinson,
Enterprise Architect Oracle Corporation
Detail
session on how to setup 11g CRS and ASM with a 10gR2 RAC database with
ASO and
Database Vault. It will include many tips and workarounds. Here
is a copy of his presentation.
Click Here for his Presentation
Date:
Thursday August14
No August meeting
Date:
Thursday July 10
Time:
7:00 PM
Topic: Introduction
to Service Oriented Architecture
Speaker: Hasan Zaidi
Mr. Zaidi is
the
Director of Integration BIAS Corporation and is responsible for all
Oracle
Fusion Middleware solutions including SOA, Business Process Automation,
Portal,
Web center and Custom J2EE development. Prior to joining BIAS, Mr.
Zaidi spent
seven years with Oracle Corporation in leadership positions with
consulting,
R&D and strategic accounts management. In his tenure at Oracle, Mr.
Zaidi
was responsible for solution delivery for clients such as Department of
Defense, Accredo Health Group (Medco Health) and Bell South
Click Here for his Presentation
Date:
Thursday June 12
Time:
7:00 PM
Topic: What I
learned as an Oracle Consultant
Speaker: Tim Jacobs, Intec
Tim
will relate some of his experiences and lessons learned while employed
as a consultant for Oracle Corporation.
Speaker: Dan Easley, IBM
Dan
will discuss database resouces.
Click
here do download Presentation (ppt)
Date: Thursday
May 8
Time:
7:00
PM
Topic:
BI
and Data Warehousing Fundamentals
Speaker:
Paul Mitchel, Emory University
Paul
will be discussing the basics of Business Intelligence and Data
Warehousing; including topics such as data movement, marts vs.
warehouses, and some of the differences between relational and data
warehouse designs from a DBA perspective.
Paul Mitchell manages DBAs and Business Intelligence resources for
Emory University's Enterprise Data Services group. He's been in IT for
25 plus years, and has been using Oracle for at least 10. Once away
from the computers, he likes to work in the yard and travel around the
world.
Date/Time:
Thursday April 10, 2008 7-9
PM
Topic:
Table and Index Types and
Their Uses
Speaker: Cory Brooks, TSYS
Date:
March 24-26, 2008
Topic:
GA Oracle User Conference
Click Here to download zip file of presentations (39MB)
Click
Here for Conference Details
Date/Time:
Thursday February 7, 7-9 PM
Topic: Trivial Pursuit:
Grid Control Edition
Speaker: Kenny Smith, Cnetics
Oracle
Enterprise Manager Grid Control offers plenty of functionality for
Oracle administrators. Many times the functionality is there but
finding how to accomplish the task is a real brain teaser. During this
meeting, attendees become “contestants” in a trivia game where they
test their Grid Control knowledge on a live Grid Control training
environment. Test your skill to see if you can: add permissions to a
user, check for locked sessions and compile invalid packages, and more
– while the room looks on!
Date/Time:
Thursday January 10, 7-9 PM
Topic: 11g New Features
Speaker: David Scott;
President, GOUSERS
2007 Meetings
Date/Time:
Thursday December 13, 7-9 PM
Topic: AJAX & PL/SQL Development
Speakers: Perry Schwartz
and Ben Hubbard
Date/Time:
Thursday November 8, 7-9 PM
Topic:
Job
Market Panel Discussion
Panel:
Ari Waller, Thompson Technology
Jason
Singer, Matrix
David Hallid, Staffing Technologies
Date/Time:
Thursday October 11, 7-9 PM
Speaker:
Mike Ault
Date/Time:
Thursday September 13, 7-9
PM
Topic:
Best Practices in Application Data
Masking for Oracle E-Business Suite
Speaker:
Paul Capobianco , Sr. SE
with Applimation, Inc
Abstract:
This
presentation will take a closer look at the challenges of protecting
private data in non-production environments. It will also discuss how
enterprises should protect data to meet various federal and state
compliance requirements and leverage advanced security measures such as
data masking. Various real-world case studies and best practices will
also be discussed.
Click
here do download Presentation (ppt)
Date/Time:
Thursday August 9,
7-9 PM
Topic: Oracle BI Publisher
Speaker:
Mark Pare'
Click
here to
download presentation (ppt)
Date/Time:
Thursday July 12, 7-9
PM
Topic: Open Source Databases
Speaker:
Brent Laminack
Download Brent's presentation from his web site www.laminack.com
Date/Time:
Thursday June 14, 7-9 PM
Topic:
ZFS - Open Source File
System
Speaker:
Mike Sweeney, Sun
Click here to
download presentation (pdf)
Date:
Thursday May 10, 2007
Time: 7:00 - 9:00 PM
Topic: Multiple Hat
Survival Guide
Speaker: Karen
Langley, SAIC
How
many hats do you wear? In your career as you move from an individual
contributor to a manager, you gain more and more hats. Leadership
requires that you do many things well as you keep adding hats to your
collection. This presentation will provide insight into the three
levels of 'hat wearing' and how to survive all those hats as a
mid-level manager. The multiple-hat wearing speaker will provide some
practical advice to help you if you are also wearing multiple hats.
Click here to
download Multiple Hat presentation (PowerPoint)
Click here to
download IOUG Overview (PowerPoint)
Date:
Thursday April 12, 2007
Time:
7:00 - 9:00 PM
Topic:
Scaling to 100 Million Rows - Per
Day!
Speaker:
David Scott, Intec Telecom
Have you ever heard that
scaling an application is not simply a matter of adding more CPU, RAM,
and disk storage? That is absolutely true. This presentation will share
insights gained while expanding the processing capacity of an existing
application to 100 million rows per day. Yes, it can be done!
OBJECTIVES
. Relate the experiences gained during scalability and performance
testing of an application.
. Identify technical challenges associated with scaling
applications.
. Identify chosen solutions to scalability challenges.
Click here to
download presentation (PowerPoint)
Click here to
download whitepaper (MS Word)
Date:
Thursday Feb 8, 2007
Time: 7:00
PM - 9:00 PM
Topic:
Memory
Management in Oracle 10g
Speaker:
Mike
Ault, Quest
Click
here to download presentation (PowerPoint)
Click
here to download whitepaper (MS Word)
Date:
Thursday Jan 11, 2007
Time: 7:00
PM - 9:00 PM
Topic:
Oracle Database
Vault and other product Q&A
Speaker:
John
Anderson, Oracle
2006 Meetings
Date: Thursday Dec 14
Time: 7:00 PM - 9:00 PM
Topic:
Toad Tips &
Tricks
Speaker:
Jeff Smith;
Quest Software
Date: Thursday Nov 9
Time: 7:00 PM - 9:00 PM
Topic: Oracle SQL Developer
Speaker: Dan Looby; Ga Tech
Oracle
SQL Developer is a free new graphical tool for
database development. And it is free . With
SQL Developer you can browse database objects, run SQL statements and
SQL scripts, and edit and debug PL/SQL statements. And it is free
. You can also run any number of provided reports,
as well as create and save your own. SQL Developer enhances
productivity and simplifies your database development tasks.
During the presentation we will take a tour through the product and
debug a PL/SQL procedure. And did I mention that it is free
?
Date: Thursday Oct 26
Time: 9:00 AM - 3:00 PM
Topic:
Half day seminar on the cost based
optimizer
Speaker:
Jonathan Lewis
Cost:
Free to GOUSER members
Jonathan Lewis, Oracle Author of the Year 2006, stopped in Atlanta on
his return to the United Kingdom from the Oracle OpenWorld Conference.
Mr. Lewis presented a half-day version of his fascinating and
insightful material on working with various versions of the Oracle
optimizer. Over 50 participants enjoyed a free catered breakfast and
lunch while listening to useful information about how to make SQL
perform better and work faster.
Mr. Lewis explained how to experiment with the optimizer, understand
what it is doing, and most importantly how to work with it to maximize
system response times and throughput. "You must tell the Oracle
Optimizer, the truth, the whole truth and a little bit more than the
truth" said Lewis. This tip and many more provided attendees with an
entertaining and beneficial look at an important tool for the database
administrator and developer. In addition to the free food and lecture,
ten lucky attendees received a free copy of his latest book.
http://www.oraclemagazine-digital.com/oraclemagazine/20061112/?pg=54&pm=1
A review of Lewis' book Cost-Based Oracle Fundamentals
can be found at http://www.dbazine.com/oracle/or-articles/foot14/
Date: Thursday Oct 12
Time: 7:00 PM
Topic:
Database Q&A Challenge
Facilitator:
David Scott
Date: Thursday
Sep 14
Time:
7:00 PM
Facilitator: Kenny Smith
Topic:
Database Security Roundtable
Date: Thursday
July 13
Time:
7:00 PM
Speaker: Matthew Zito; Chief Scientist,
GridApp Systems
Topic:
Strategies &
Tools for Centralizing and Automating Database Management
Join us Thursday
July 13 to hear Matthew Zito discuss strategies and tools for
centralizing and automating database management that will save time and
make the DBA's life easier
Presentation download not available
Date:
Thursday June 8
Time: 7:00 PM
Title:
Welcome
to My Nightmare: Common Performance Errors in Oracle Databases
Presenter:
Michael Ault; Senior Consultant, Burleson Consulting
Click
here to download presentation
Date:
Thursday May 11
Time: 7:00 PM
Topic:
60
Security Tips in 60 Minutes
Presenter:
Kenny Smith, Cnetics Technologies
Over the last several years
for working with customers on database security, Kenny Smith and others
have compiled a list of good ideas or important things to know about
deploying a secure and/or regulatory compliant Oracle database. This
presentation will provide a sampling of lessons learned about Oracle
database security setting, features, configuration and techniques.
Click
here to download presentation
Click
here to download security pop-quiz
Date: Thursday Apr 13, 2006
Time: 7:00 PM
Topic: Holistic Performance Tuning: Tools
to simultaneously analyze multiple performance dimensions
Presentor: Mike Wade; Adjunct Professor,
Southern Polytechnic State University, and IT Consultant
Join us Thursday April 13 as
Mike explores tools and techniques useful for evaluating relationships
between numerous performance measures, and determining which may drive
the greatest performance gains if given adjusted resources.
Mathematical techniques such as Statistical Process Control and
Designed Experiments or Factorial Analysis will be examined as means to
quickly uncover potential root causes of performance problems in n-tier
application architectures.
Date: March 20 - 22, 2006
Topic: 2006 GOUSER Conference
Click
here to download session presentations
Date: Thursday Feb 9, 2006
Time: 7:00 PM
Topics: tour of the ETC lab, a RAC/Grid
presentation, and a look at 'Oracle Directions'
Presentor: Jim Olsen, Oracle
Location: Oracle building on Abernathy Road
Map to Oracle's office
Date:
Thursday, Jan 12, 2006
Time: 7:00 PM - 8:30
Topic: HTML DB
Presenter: Mike Smith, Oracle
Download Mike's Presentation
2005
Meetings
Date: Thursday, Dec 8, 2005
Time: 7:00 PM - 8:30
Topic: Why Your DB Performance is a Dog
Presenter: David Scott, Intec Telecom
Date: Thursday, Nov 10, 2005
Time: 7:00 PM - 8:30
Topic: Oracle 10g Tuning Secrets
Presenter: Don Burleson, Burleson
Consulting
This presentation will focus on real-world techniques for improving the
speed of SQL queries with a focus on the new Oracle10g features. Topics
will include new Oracle parameters that affect SQL performance, 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 Oracle10g CPU costing approach.
Date: Thursday, October 13, 2005
Time: 7:00 PM - 8:30
Topic: Transparent Data Encryption
Presenter: Marvin Vinson, Oracle
Download
GoUserMap.pdf
Date:
Thursday, July 14, 2005
Time: 7:00 PM - 8:30
Topic1: Oracle Licensing
Presenter: Steve Moroski, Oracle
Corporation
Topic2: Business Continuity/Disaster
Recovery
Presenter: Mike Wade, Platinum Circle
Technologies
Join
us at the GOUSER July meeting for 2 topics:
First, Steve Moroski will cover Oracle's basic licensing policies and
give attendees a chance to ask questions about purchasing Oracle
products.
Next, Mike Wade will outline a best practices project to produce a
basic DR plan. Discussion will include going beyond every day DR plans
to understand the place the DR plan holds in overall organizational BC
preparedness as well as some strategies to get the management
visibility you will need to obtain funding to mitigate your identified
problem areas. Your take-away will be a better understanding of BC and
DR, and a DR Plan template you will be able to down load from the
GOUSER Web Site that should get you going.
Download
Steve's presentation
Download
Mike's presentation
Date:
June 9, 2005
Time: 7:00 PM - 8:30
Topic: Tuning Accelerator
Speaker: David Scott, Intec Telecom Systems
This
session will help you get started with tuning the Oracle database.
We'll cover the basic methods, tools, and techniques used to diagnose
and improve server response and provide a list of resources that can
help improve your tuning skills.
Download the presentation
Date:
April 4-5, 2005
Topic: 2005 Georgia Oracle Users Group
Conference
Location: Kennesaw State University
Date:
Thursday, March 10, 2005
Time: 7:00 PM - 8:30
Topic: Multi-platform database shops:
Issues, Practices, and Organization
Location: Georgia Pacific
Directions:
Georgia Pacific Building
133 Peachtree St. NE, Atlanta, GA 30303
Corner of John Wesley Dodds and Peachtree Street in downtown Atlanta.
Parking in GP Center is $9.
There is free parking in AAA parking lot after hours
on the corner of Peachtree Center and John Wesley Dodds.
Date:
Thursday, February 10, 2005
Time: 7:00 PM - 8:30
Topic: Oracle Technologies (part 2)
Presenter: Marvin Vinson, Oracle
Date:
Thursday, January 13, 2005
Time: 7:00 PM - 8:30
Topic: Oracle Technologies Review
Presenter: Marvin Vinson, Oracle
January's
meeting was held at the Oracle building.
Download
the presentation
Map
to Oracle's office
2004
Meetings
Date: Thursday, December 9, 2004
Time: 7:00 PM - ??
Social gathering at U.S. Play in Marietta
Date:
Thursday, November 11, 2004
Time: 7:00 PM - 8:30 PM
Presentation #1: 10g RAC - Live demo with
on-site hardware
Presenter: Kenny Smith, Inplexus
Kenny will roll in a 10g RAC on Linux cluster, join us on Thursday!
Download the
demo specs
Download the
presentation
Date:
Thursday, October 21, 2004
Time: 1:00 PM - 5:00 PM
Topic: Database security roundtable
discussion
Facilatators:
Kenny Smith, Inplexus
David Scott, Intec
Kris Cook, Mirant
Amy Wilson, Devry
A roundtable discussion on database security
Click here for
agenda
Download Meeting
Minutes
Date:
Thursday, October 14, 2004
Time: 7:00 PM - 8:30 PM
Presentation #1: PL/SQL 101
Presenters:
David Scott, Intec
Amy Wilson, Devry
If you're interested in PL/SQL, join us on Thursday!
Date:
Thursday, September 9, 2004
Time: 7:00 PM - 8:30 PM
Presentation #1: Intro to OCI Programming
Presenter: Mike Chartier, InTec
Presentation #2: DBCare - Day to Day
Monitoring of Your Oracle Database
Presenter: Paul Dessources, Pinnacle Data
Technologies, Inc.
If you're interested in programming or monitoring your databases, join
us on Thursday!
Date:
Thursday, August 12, 2004
Time: 7:00 PM - 8:30 PM
Presentation #1: Oracle Jeopardy!
Presenter: Dan Looby, Georgia Tech
Presentation #2: Essential Tools for the
Frugal DBA
Presenter: David Scott, Intec Telecom
Systems
Come test your knowledge of the world of Oracle, and save a few bucks
along the way!
Date:
Thursday, July 8, 2004
Time: 7:00 PM - 8:30 PM
Presentation: SANs for DBAs
Presenter: Dennis Freeman, Technical
Center Program Manager, XIOtech
Learn about Storage Area Networks and how they benefit the Oracle
environment.
Date:
Thursday, May 13, 2004
Time: 7:00 PM - 8:30 PM
Presentation: TOAD and other Quest Software
Presenter: Quest Software
Quest will present some TOAD tips and provide an introduction to their
other software products.
Date:
Thursday, April 8, 2004
Time: 7:00 PM - 8:30 PM
Presentation: Introduction To Virtual
Private Databases
Presenter: Dan Looby, Georgia Institute of
Technology and GOuser Member
Dan will present an introduction to Virtual Private Databases (VPDs)
using Oracle 9i Release 2. For a real-world example, we'll look at
using VPDs to restrict which users can update information in a Schedule
of Classes, including meeting times and instructors.
Date:
Thursday, Feb. 12, 2004
Time: 7:30 PM - 9:00 PM
Presentation: Utilities for Oracle DBAs
Presenter: Ken Williams, Computer
Associates Tech. Services Group
|
|