Home About Us Meeting Schedule Membership Member Area Key Links
 


2014 Meetings


April 17, 2014 Monthly Meeting.

Date:
Thursday April 17, 2014
Time:
7:00 PM
Speaker:
Bobby Curtis; Senior Technical Consultant, Enkitec Topic:  Golden Gate Monitoring

During this session, we will take a look at the different number of techniques available for monitoring Oracle Golden Gate 12c while keeping operational awareness as the main focus.  Reviewing the different use cases, the complexity of monitoring for these environments increase and lead to different monitoring approaches.  By taking a look at different monitoring techniques, manual, scripting, and graphical user interfaces (GUI), we can identify scalable monitoring solutions for any environment. By the end of the session, we should have an understanding of different monitoring approaches and when it is best to use different approaches to ensure success of Oracle Golden Gate 12c implementations and data quality.

NOTE: New Meeting location for our April 2014 meeting!  Our meeting will be at:

Atlanta City Hall
55 Trinity Ave SW
Atlanta, GA.


March 13, 2014 Monthly Meeting.


Date:
Thursday Mar. 13, 2014
Time:
7:00 PM
Speaker:
Maaz Anjum, Solution Architect, Architecture Services; BIAS Corp.

Topic:  Capacity Planning: How to Leverage OEM12c for Engineered Systems

The question of current capacity utilization is important to organizations undergoing a consolidation effort. We often receive customers request for capacity planning reports on Exa Appliances that we manage. If one were you use Oracle’s On-Demand services, this information might be easily available. On the other hand, those who intend to and trend on captured metrics by Oracle’s Enterprise Manager 12c Cloud Control platform, there are a number of useful features and tricks to extract the information. OEM views, Chargeback capabilities and, BI Reports tool are leveraged to extract – with a hierarchical overview – past and future trends for capacity and resource planning efforts on several targets especially for an Exa Appliance. The information would be particularly useful for business owners to decide on additional hardware purchases.

February 13, 2014 Monthly Meeting.  Cancelled due to Weather

Date: Thursday Feb. 13, 2014
Time:
7:00 PM
Speaker:
Jay Williams, Solution Architect Engineered Systems; BIAS

Topic:  Oracle 12c RAC New Features

January 9, 2014 Monthly Meeting.


Date: Thursday Jan. 9, 2014
Time:
7:00 PM
Speaker:
David Scott; Technical Director, Government Solutions, CSG International
Topic: 
How to Make Your Data Look Really Ugly - or NOT
  
This informal talk will help the listener identify report and charting characteristics that improve communication and clarity. Certain information design 'mistakes' will also be surfaced and tips for improvement will be discussed. Bring your questions about data display design!

2013 Meetings

December 12, 2013 Monthly Meeting.

Date: Thursday Dec. 12, 2013
Time:
7:00 PM
Speaker:
Maaz Anjum, Solution Architect, BIAS Corp.
Topic: 
Database Provisioning in OEM12c: Provision me a Database Now!

How many times have we heard this story. An IT Manager is unable to confirm with assurance that all his newly built environments conform to the exact same standards? Of course there will be a few one-offs, but to be able to accomplish that successfully without a lot of
manual effort is a great feat. With this session, we will explore the story of just such an IT Manager (Mr. Green), who faced numerous challenges within his infrastructure and Database Administration teams. My experience with OEM12c's Provisioning framework (part of the Lifecycle Management feature) allowed for rapid and repeatable deployments adhering to Mr. Green's organizational standards with ease. Starting with Grid Infrastructure software, RDBMS software, ASM Instances, and eventually Database creation, Software
Library Components and Directives we will explore the subtle nuances that allow an organization become effective at deployments.

Objective #1: Understand clearly the challenges faces by IT Managers (like Mr. Green), who finds it challenging to offer consistent builds of a database server from environment to environment.
Objective #2: Combine the various pieces in OEM12c's Provisioning framework to create profiles, golden images, provisioning procedures, software library components and directives etc.
Objective #3: Learn to solve the IT problem of consistent deployments across environments. Support multiple requests for new oracle database software installations, and database create requests.          


November 14, 2013 Monthly Meeting.

Date: Thursday Nov. 14, 2013
Time:
7:00 PM
Speaker:
Ken Ellis, Principal Sales Consultant, Oracle Corporation
Topic: 
Update on Oracle Linux and Oracle Virtual Machine  for Oracle Users

This event will include a quick update on both OL and OVM, along with examples of how Application Aware Virtualization can benefit the enterprise.   There will be a demonstration of technologies reviewed and time for questions at the end.    
Click here for Ken's presentation.    

October 17, 2013 Monthly Meeting.

Date: Thursday Oct. 17, 2013
Time:
7:00 PM
Speaker:
Bill Busch,  SSA | Enterprise Information Solutions CWP with Perficient Topic:  Enabling Business Agility: Building the Next-Generation of BI Systems

The challenge with traditional business intelligence (BI) environments is that they have been slow to change and have forced users to operate within a set of rigid capabilities. However, in the last few years a new set of technologies and methods have been developed that have resulted in BI systems that are flexible and easily changed.  In short, BI systems can now support the speed of business.  This presentation will look at how BI organizations are deploying this new generation of BI capabilities to create flexible, high-value solutions for their enterprises. 


September 12, 2013 Monthly Meeting.

Date: Thursday Sept. 12, 2013
Time:
7:00 PM
Speaker:
Kris Cook, President GOUser Oracle User Group and Sr. Manager Database Services, SITA
Topic: 
Creating your own rpm
             Creating a lab for subversion server
             Creating a lab for hadoop

click here for Create an RPM Package
click here for Create an RPM Script Package
click here for Sample RPM Package Config File
click here for SVN Lab
click here for Hadoop Sandbox HowTo

No August 8, 2013 Monthly Meeting.
No August Meeting.

July 11, 2013 Monthly Meeting.

Date: Thursday July 11, 2013
Time:
7:00 PM
Speaker:
Jim Hannan, House of Brick, Principal Architect

Topic:  Virtualizing Business Critical Oracle Workloads

A look at techniques, trends, and tools  used to successfully virtualize Oracle workloads. This presentation will explore operationalizing Oracle workloads after virtualizing, and we will examine some customer success stories. Click here for Jim's presentation.


June 13, 2013 Monthly Meeting.

Date: Thursday June 13, 2013
Time: 7:00 PM
Speaker: Roddy Rodstein, Mokum Solutions
Topic:  Rethink Your Oracle Database Cloud Strategies

Challenge your existing Oracle Database strategy and look to the clouds!  This one hour session will challenge your existing Oracle Database Strategies and demonstrate the value of Oracle's Cloud Control DaaS.

May 9, 2013 Monthly Meeting.


Date: Thursday May 9, 2013
Time:
7:00 PM
Speaker:
Bobby Curtis, Solution Architect,; BIAS

Topic:  An introduction to database 12c (cloud)

Don't believe what you read on the internet.  Database 12c is coming but what will be included?  Come take a look at a few of the new features in database 12c and see what exciting things await you in this new release.


No April 11, 2013 Monthly Meeting.
Spring Break. No April Meeting.

March 14, 2013 Monthly Meeting.

Date: Thursday Mar. 14, 2013
Time:
7:00 PM
Speaker:
Michael R. Ault Oracle Guru, Texas Memory Systems

Topic:  Oracle - Need for Speed, Using Flash with Oracle

In this presentation Mike will discuss where Oracle needs speed and how flash technology answers this need. Mike also discuss Flash benchmarks with Oracle and an architecture that enhances existing SAN environments.

Mike Ault is the author or co-author of more than 24 Oracle books and hundreds of articles in national publications. Mike is a frequent presenter at Oracle related conferences at the international, national and regional levels.

Mike's presentation

February 21, 2013 Monthly Meeting.


Date: Thursday Feb. 21, 2013
Time:
7:00 PM
Speaker:
Shiva Mathur, Database Practice Director, Rolta

Topic:  Oracle Database Security

This presentation will address Oracle database security.  Topics included will features and techniques within the database that DBAs can leverage to make their environment more secure and in line with compliance requirements.


January 10, 2013 Monthly Meeting.


Date: Thursday Jan. 10, 2013
Time:
7:00 PM
Speaker:
Ben Boise, Dell/Quest

Topic:  Beyond TOAD

We find that most Toad users utilize only 20% of the product, when they could be getting so much more out of it. This session will introduce you to some of the most effective tips for getting the most out of your Toad investment. We will show you how to boost productivity, significantly improve your organization's code quality, optimize database performance and reduce risks associated with database changes. Plus, we will give you unique insight into the newest Toad release, including remote access and execution of Toad scripts from a web-browser or mobile device. And, storage of Toad scripts and settings online – even synchronize them across multiple computers. Join us for this informative session.

 
2012 Meetings


December 13, 2012 Monthly Meeting.

Date: Thursday Dec. 13, 2012
Time:
7:00 PM
Speaker:
Brian McGraw Principal Sales Consultant, Oracle Corporation

Topic:  Oracle Exadata Technical Overview

“You have probably heard the buzz about Oracle’s Exadata.  This Engineered System delivers extreme performance for all types of workloads.  But how does the latest incarnation, announced at Oracle OpenWorld,  continue to deliver performance gains for customers?  This session will provide a technical overview of the Exadata X3, showing how Oracle has engineered hardware and software to work together.”

November 8, 2012 Monthly Meeting.

Date: Thursday Nov. 8, 2012
Time:
7:00 PM
Speaker:Bobby Curtis, Senior Engineer, BIAS
Topic:
Streamlining Operations For Oracle Business Applications Using Enterprise Manager 12c


October 11, 2012 Monthly Meeting.


Date: Thursday Oct. 11, 2012
Time:
7:00 PM
Speaker:
Delphix

Topic: By virtualizing the Oracle Database, DBA Management Time can be reduced by 75%.
This presentation will address techniques to provision, manage, and refresh databases for business-critical applications in a way that can reduce the time, cost, and risk of application rollouts

September 13 2012 Monthly Meeting.


Date: Thursday Sept. 13, 2012
Time:
7:00 PM
Speaker:
Raj Ramani, Manhattan Associates

Topic: Data Guard - Physical Standby on ASM, Data Guard Broker Configuration, Failover & Switchover Tests
Raj's presentation Sept. 2012


No August 2012 Monthly Meeting.

Summer Break, No August Meeting!.


July 2012 Monthly Meeting.


Date: Thursday July 12, 2012
Time:
7:00 PM
Speaker:
Micheal Doherty, Netapp

Topic: Empowering the DBA through agility

Join us for our July meeting. Micheal will be discussing:
1. Database Storage Performance 101.
2. Database Efficiencies driven from the big 3 - SnapShots, SnapRestores & FlexClones
4. Live Demo.

For those that had questions for Mike:

   Mike Doherty
   Consulting System Engineer – Oracle Solutions
   NetApp Inc.
   Michael.Doherty@netapp.com
   Cell: 678-637-4118
   780 Johnson Ferry Road, Suite 100
   Atlanta, GA 30342

June 2012 Monthly Meeting.


Date: Thursday June 14, 2012
Time:
7:00 PM
Speaker:
Krishan Chawla, UPS

Topic: Transaction Concurrency Management Features in Oracle

This presentation will discuss various approaches to leverage Oracle’s scalability features.
We will cover the concepts and dictionary related to transactions and various concurrency controls. We will discuss how Oracle achieves concurrency using multi-versioning transaction model.
We will review 11g scalability features like Mutex implementation, fine grained dependency management, adaptive cursor sharing , server result cache, and partitioning enhancement.
Oracle is designed to be a scalable database but certain application design and programming practices can cause significant locking and inhibit scalability.
With the knowledge of oracle’s internal mechanism of concurrency controls we should be able to avoid the performance issues related to scalability and avoid many data integrity and consistency issues related to deadlocks and lost updates.


May 2012 Monthly Meeting.


Date: Thursday May 10, 2012
Time:
7:00 PM
Speaker:
Jeff Surretsky, Quest Software

Topic: Planned Migrations, Upgrades, and Data Replication

This presentation discusses near-zero downtime database migration in a 24x7 environment.  Topics covered will include tools and techniques that can be used to maximize the benefit  and minimize the costs compared to traditional Oracle migrations.
Jeff's presentation May 2012

April 2012 Monthly Meeting.


Date: Thursday April 12, 2012
Time:
7:00 PM
Speaker:
Iftequar Mohammed, User Group Member

Topic: Implementing High Availability using Oracle Clusterware

This will be a practical technical presentation in which we will see how we can use Oracle Clusterware to make applications (database and otherwise) highly available.

March 2012 Monthly Meeting.


Date: Thursday March 8, 2012
Time:
7:00 PM
Speaker:
David Scott, Principal Consultant, Government Solutions for CSG International and also Past GOuser President

Topic: Scalability: Super-Heroes and Super-Villains

Oracle 11g databases can scale to handle tremendous volumes of data, but some effort is involved to avoid the dastardly villians that would sabotage your success. This presentation will help DBAs avoid the villainous techniques and pitfalls in code and schema designs, as well as summon the super-heroes that can assist you in creating super-scaled data applications.

David's presentation March 2012


February 2012 Monthly Meeting.


Date: Thursday February 9, 2012
Time:
7:00 PM
Speaker:
Dan Garnett, Principal Sales Consultant, Oracle

Topic: Oracle Database Appliance

There are many types of computer appliances in the market today -- storage, network, anti-spam, virtual machine, mobile (iPhone), etc., all with the goal to provide unique capabilities and features by tightly integrating hardware, software and firmware. Over the last 4 years, Oracle has produced a series of engineered systems that cover databases, middleware and analytics. In 2008, Oracle launched Exadata, its first database machine for data warehouses. A year later, Oracle released Exadata Version 2 which was the first OLTP database machine. And just recently (Sep 2011), it has introduced the Oracle Database Appliance (ODA), an affordable, reliable and easy-to-use engineered system targeted for partners, small and medium sized businesses (SMBs) and departments of large companies. This presentation will address the following questions: what is ODA, what unique capabilities does it possess, what value does it offer an IT organization and ISV and what use cases does it cover. The database environment deployment and database creation steps will be covered to show how a high availability database can be stood up in less than 2 hours. Through this presentation, you should gain a deeper understanding of the benefits and trade-offs associated with a database appliance.

January Monthly Meeting

Date: Thursday January 19th 2012
Time: 7:00 PM
Speaker: Bill Kendall  (William.Kendall@biascorp.com)
Topic: GoldenGate.

This presentation will progress from the traditional GoldenGate use cases into a deep dive of the auditing capabilities of Oracle GoldenGate. We will cover capturing before and after images of each record through the entire transaction lifecycle, along with recording critical information about the change to the record. This change capture information can include the time the record was changed, the user who changed the record, the operation that was performed against the record, and many other variables that can provide deep insight through detailed audit reports and portals. These capabilities have allowed many of the top financial services and healthcare companies to rapidly and accurately respond to the increased demand for detailed auditing information without highly modifying or swapping out their current infrastructure. This functionality and flexibility provided by Oracle GoldenGate has directly translated into a competitive advantage for these firms.
Click Here to see PDF presentation


2011 Meetings

** NO December Monthly Meeting   **
** NO November Monthly Meeting   **
** NO October Monthly Meeting   **


September Monthly Meeting

Date: Thursday September 8th 2011
Time:
7:00 PM
Speaker:
None

Topic: Open questions to the group

One last meeting at our old location.

August Monthly Meeting

Date: Thursday August 12th 2010
Time:
7:00 PM
Speaker:
Tianhua Wu, Sr. DBA at Mirant Corp.
Topic: Introduction To Oracle Applications

This presentation will give an overview of the the Oracle Applications

** NO July Monthly Meeting   **

June Monthly Meeting

Date: Thursday June 9th 2011
Time:
7:00 PM
Speaker:
David Scott, Principal Database Consultant, Intec and past president of GOusers

Topic: SQL Injection

SQL and PL/SQL are great tools, but can easily be misused to create a dangerous security risk. This presentation will familiarize you with the problem and show how it can be avoided.

May Monthly Meeting

Date: Thursday May 12th 2011
Time:
7:00 PM
Speaker:
Amy Wilson, President GOuser  Group

Topic: Beyond Oracle. There's a World of Security

An introduction to information security concepts: why they're important and how we can implement them in Oracle.

April Monthly Meeting

Date: Thursday April 14th 2011
Time:
7:00 PM
Speaker:
Michael Knam,  District Manager, Delphix and Samir Malik, Principal Solution Architect, InfoSapient

Topic: Oracle Database Virtualization

A range of technologies have been virtualized in the data center- servers, storage, applications, routers and I/O, providing huge improvements in administration. Continuing the virtualization trend, you will learn how Delphix virtualizes the non-production database infrastructure to provide complete, fully functional databases that operate in 1/10th the space. DBAs can use a self-service model through a web browser to create and provision databases in minutes. Please join us to learn about the innovative technology changing the landscape of database management.

March Monthly Meeting

Date: Thursday March 10th 2011
Time:
7:00 PM
Speaker:
Evan Ehrenhalt,  Sr. Database Administrator University Technology Services, Emory University and a GOuser Member.

Topic: 11G Grid Install with Load Balancing

 Evan will be sharing his experiences with setting up OMS/Grid using a 2 node cluster, load balancing using F5 big IP and ACFS for a shared file system loader. The environment is as follows: Red Hat 5 x86_64, database 11.2.0.2, OEM 11.1.0.1.0. Evan is using agent deploy from OEM to send out agents. This material may not work on other UNIX environments and Windows will not be addressed at all.

Click Here for Evan Ehrenhalt's (zip file) presenation

January Monthly Meeting

Date: Thursday January 13th 2011
Time: 7:00 PM
Speaker: Waleed Ahmed, Oracle Corporation
Topic: Real Application Testing.



2010 Meetings


December Monthly Meeting
Date: Thursday December 9th 2010
Time: 7:00 PM
Speaker: Robyn Sands, DBA and GOuser member.
Topic: Measuring for Robust Performance.

What is variance and why is it important to an Oracle DBA? Statistically, variance is the square of the standard deviation. Conceptually, variance is the 'difference between what is expected and what actually occurs'. For the DBA, variance causes a user to complain that a report was running 'fast', but now it's 'too slow'. In production systems, variance can be a tool to locate problems and verify resolution. When used in the design phase, identifying and reducing variance results in a robust, optimized product more capable of meeting user demands.
 

This session presents basic statistical concepts of variance and related statistical measures. The audience will learn about options to capture and analyze performance data, using existing data sources and application instrumentation, as well as the role of StatsPack and ASH data in a robust system.


November Monthly Meeting

Date: Thursday November 11th 2010
Time:
7:00 PM
Speaker:
David Scott, President Georgia Oracle User Group
Topic: Open topics. Q&A from the group..

October Monthly Meeting

Date: Thursday October 14th 2010
Time:
7:00 PM
Speaker:
Andrew Batichchev
Topic: Oracle Messaging


Andrew is Sr.
Database Developer at IntercontinentalExchange (ICE) and  will be presenting on Oracle Messaging Gateway and it's integration with MQ.

September Monthly Meeting

Date: Thursday September 9th 2010
Time:
7:00 PM
Speaker:
The User Group
Topic: Q&A and Networking. Bring your questions and let's see if we can help you out!


August Monthly Meeting

Date: Thursday August 12th 2010
Time:
7:00 PM
Speaker:
Tianhua Wu, Sr. DBA at Mirant Corp.
Topic: Introduction To Oracle Applications

This presentation will give an overview of the the Oracle Applications

July Monthly Meeting

Date: Thursday July 8th 2010
Time:
7:00 PM
Speaker:
Iftequar Mohammed
Topic: Parallel Processing in Oracle

This technical presentation will try to answer the following questions: (but may raise many more instead!)
What is parallel processing?
Where can it be used?
How does it work?
How do we configure it?
How do we implement it?
How to monitor it?
and few more...

Come and share the excitement!

June Monthly Meeting

Date: Thursday June, 10th 2010
Time:
7:00 PM
Speaker:
David Scott (GOusers) and Alisha Spence, Native Texan Investments
Topic: From Soup to Nuts: Developing an Online Application

This presentation covers the development of a web-enabled real estate analysis program based on the Oracle database and Application Express. We'll compare the original idea to the actual online program and cover many of the technology choices that were necessary to make the program available, such as database design, programming environment, and vendor selections. Come and see what a real ApEx program looks like!


May Monthly Meeting

Date: Thursday May, 13th 2010
Time: 7:00 PM
Speaker: Dan Davis, dbMaestro
Topic: Change Management Tool comparison

Dan's presentation on will compare the current tools available to facilitate database change management with a new generation of tools that provide the same functional capabilities available to application developers. The first software tool to deliver this capability, Teamwork from dbMaestro,  will be reviewed.

TeamWork from dbMaestro is a database change management solution that helps organizations truly take control of the database development process, reducing costs by improving process driven automation, visibility and quality over the database change management process. TeamWork helps you achieve regulatory compliance by controlling and tracking changes—from the time the change is requested through its automated and process-disciplined deployment to production

May presentation

April Monthly Meeting

Date: Thursday April, 8th 2010
Time: 7:00 PM
Speaker: Justin Liu
Topic: Data Guard Fast-Start-Failover Configuration

This presentation will be a case study.  Justin will demonstrate the procedure that we are using internally at Turner to achieve database high availability.

1) List all required parameters in both primary and standby side
2) Illustrate step by step of how to configure DG fast-start-failover
3) Connect-Time Failover setup
4) Application (oci or jdbc) automatic failover demonstration.

April Presentation - Data Guard


March Monthly Meeting

February Monthly Meeting

Date: Thursday February, 11th 2010
Time: 7:00 PM
Speaker: David Scott
Topic: Data Quality For Experts

If you're NOT a data quality expert, this presentation will help you understand and get started with this critical issue.

If you ARE a data quality expert, please come and share your secrets!

We are back at our usual meeting location.


January Monthly Meeting

Date: Thursday January, 14th 2010
Time: 7:00 PM
Topic:
Oracle 11g R2.

The January meeting will be held at the Oracle Office. We will be reviewing Oracle 11gR2.

Be sure to RSVP as we need an accurate count!

Speaker: John Anderson

Note: Not at our usual location.
This months meeting will be held at the Oracle Atlanta Office.

Oracle Corporation
Building 500
1100 Abernathy Road
Atlanta, GA 30328

2009 Meetings

December Monthly Meeting Cancelled

Friends,

Due to some unforseen circumstances, we need to postpone our December meeting. We're working on rescheduling this meeting in the January timeframe after the holidays, most probably at our regular meeting time.

I apologize for the late notice; have a great holiday season nonetheless!

Best wishes,

David Scott


November Monthly Meeting

Date: Thursday November 12th
Time: 7:00 PM
Topic:
Dynamic Data Masking, The New Frontier.

Data Masking is part of the overall Data Security Strategy. This presentation will present a short historical view of the evolution of the Data Security and Data Masking, including the “good”, the “bad” and the “ugly” right up to the state of the art. We will take a look at some of the various techniques from a process perspective and discuss the pros and cons of each of them.

Speaker: Tony Cannizzo Tony is a GOuser member and president of Silos-Connect (www.silos-connect.com), a database tools vendor.


October Monthly Meeting

Date: Thursday October 8th
Time: 7:00 PM
Topic:
Optimizer 's CPU costing model and DBMS_STATS( 9i/10g and 11g way).
Speaker: Sameer Malik

September Monthly Meeting



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



 


Copyright Georgia Oracle Users Group 2004-2014.
All Rights Reserved.