Feb 05, 2012

 

Welcome to the home of one of Cincinnati's premier professional organizations, the Greater Cincinnati Oracle User Group (GCOUG). Our group is a network of hundreds of information systems professionals from Southwest Ohio, Northern Kentucky and Southeast Indiana. You will find loads of interesting technical information here! Technology is always changing, so bookmark us and check back often!

 

 

Fred Lewis’s Oracle Wiki site tailored for GCOUG.

 

http://wiki.oracle.com/page/Cincinnati+User+Group

 

Visit explore and use for collaboration.

 

 

 

 

The logo are links to the sponsors websites.

 

Location: Oracle Corp., 9987 Carver Road, Suite 250, Blue Ash, Ohio 45242, (513) 826-6000

    [Note:  The location may change depending on the number of attendees who register for this meeting.]

Meetings Sponsors:

 

 

 

 

 

Meeting Sponsors: Oracle Corporation (www.oracle.com), TPSi (www.tpsinc.com), TOAD by Quest Software (www.quest.com/database-management) , Confio (www.confio.com)

                                                                                                                                               

 

January 23, 2012  --- AGENDA

 

“Tom Kyte Day”

 

 

08:00 AM – 08:30 AM         Meeting Registration / Door Prize Raffle Registration

08:30 AM – 10:00 AM         SQL Techniques (Tom Kyte, Oracle Corp.)

10:00 AM – 10:15 AM         Break

10:15 AM – 11:45 AM         Read and Write Consistency (Tom Kyte, Oracle Corp.)

11:45 AM – 11:50 AM         Sponsors Overview, Announcements (Attendees)

11:50 AM – 12:30 PM         Buffet Luncheon

12:30 PM – 01:25 PM         Versioning Of Data (Tom Kyte, Oracle Corp.)

01:30 PM – 01:45 PM         Break

01:45 PM – 02:45 PM         What Else Can I Do With System and Session Performance Data(Tom Kyte, Oracle Corp.)

02:45 PM – 03:15 PM         Maximize Code Quality in PL/SQL Applications (Kuljit Sangha, TOAD by Quest Software) -  abstract

03:15 PM – 03:20 PM       Announcements / Raffle

 

Annual Membership (Calendar Year Basis) is $50, Non-members pay $25, Unemployed individuals & Students are “FREE” to attend the meeting (cash or check payable to GCOUG or credit card via PayPal).  GCOUG is now setup to receive credit cards as payment for membership or meeting attendance via the iPhone Square app and/or via PayPal.  The PayPal process goes as follows :

  • Send me (bstoneman@sma-llc.com) your email address.
  • Identify - Annual Membership ($50) or Attend a Meeting only ($25 for Non-Members).
  • I will send you an e-mail via Paypal that will allow you to pay via credit card.

 

Please RSVP to http://apex.oracle.com/pls/otn/f?p=60184:2:663211225354558 to register for this meeting.

 

To receive a “Meeting” announcement e-mail, visit the GCOUG website at http://www.gcoug.org, click on “E-Mail List” and add your E-mail and Name, then click on the SUBSCRIBE button.  You can also add yourself to the “Job” e-mail list.

 

Below are the tentative GCOUG 2012 Meeting Dates:

* January 23, 2012 (Mon) – Tom Kyte Day                         * May 23, 2012 (Wed) – TBD          * October 17, 2012 (Wed) – TBD

 

DIRECTIONS TO ORACLE CORP. - BLUE ASH

 

From Greater Cincinnati/Northern Kentucky Airport:

  • As you are leaving the airport, follow the signs to East I-275.
  • Merge onto I-75 North via Exit 84 toward Cincinnati.
  • Stay on I-75 crossing over the Ohio River into Ohio.
  • Merge onto Ronald Reagan/Cross County Highway via Exit 10A.
  • Take the Plainfield Road exit toward Hunt Road.
  • Turn left onto Plainfield Road.
  • Plainfield Road turns into Reed Hartman Highway. Stay on Reed Hartman Highway until you reach Malsbary Road.
  • Turn left onto Malsbary Road.
  • Turn right onto Carver Road.
  • Oracle is at 9987 Carver Road, on the left. Suite 250 is on the 2nd Floor.

From Dayton, OH:

  • Take I-75 South to Glendale Milford Road, Exit 14.
  • Take the 1st ramp toward Woodlawn/Evendale.
  • Turn right onto Glendale Milford Road.
  • Turn right onto Reed Hartman Highway.
  • Turn right onto Carver Road.
  • Oracle is at 9987 Carver Road, on the right. Suite 250 is on the 2nd Floor.

From Columbus, OH:

  • Take I-71 South to Pfeiffer Road, Exit 15.
  • Turn Right onto Pfeiffer Road.
  • Pfeiffer Road becomes Glendale Milford Road.
  • Turn left onto Reed Hartman Highway.
  • Turn right onto Carver Road.
  • Oracle is at 9987 Carver Road, on the right. Suite 250 is on the 2nd Floor.

 

 

Bio

Tom Kyte is a Senior Technical Architect in Oracle’s Server Technology Division. Before starting at Oracle, Kyte worked as a systems integrator building large-scale, heterogeneous databases and applications, mostly for military and government customers. Kyte spends a great deal of time working with the Oracle database and, more specifically, working with people who are working with the Oracle database. In addition, 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/). Kyte is also the author of Expert Oracle Database Architecture (Apress, 2005), Expert One on One Oracle(Wrox Press, 2001/Apress 2004), Beginning Oracle Programing (Wrox press, 2002/Apress 2004), and Effective Oracle by Design (Oracle Press, 2003). These are books about the general use of the database and how to develop successful Oracle applications.

 

SQL Techniques 1 to 1.5 hours

The presenter will describe common SQL techniques he has encountered and utilizes day to day to tune query performance. Features such as scalar subqueries, using rownum (yes, to 'tune'), analytics, some hints and more will be demonstrated. Emphasis will be on when they work (where the 'trick' applies) as well as when they don't workwhere they do not apply. Care will be taken to show these not as a "top 10 things to do" but rather techniques to keep in mind when looking at problems in general.

 

Read and write consistency 1.5 hours

Oracle's multiversioning model is by far it's most striking core RDBMS feature. We'll explore this often misunderstood database feature, both from a "read" perspective as well as some nuances you probably are not aware of in a multi-user environment. This session is probably an eye-opening experience, even for people that have been using Oracle for many many years.

 

Versioning of data 1 hour

A common requirement today is to maintain a complete history of data: every change made to a row over time, for all rows in a table or set of tables. This session explores the methods available to do this, from "do it yourself" versioning (via triggers/application code) to letting the database do it for you with workspace management. Key focuses of this session are time to develop, performance, and implementation.

 

What Else Can I Do with System and Session Performance Data – 1 hour

So you have access to information via Oracle Enterprise Manager and the management packs, but what else can you do with this data, beyond what is already exposed? You have a wealth of information in there—you just need to look at it, as you'll learn in this session.

Best Practices for Maximizing Code Quality in PL/SQL Applications

This presentation by Quest Software’s system consultant Kuljit Sangha will take you through database development best practices that empower you to write better-performing, higher-quality code with fewer bugs. He will do this by covering key functional areas that help you guarantee application success. This is includes giving you the ability to work smarter through collaboration and standardization across your development team. Kuljit will also share how, through this best practices approach, your organization can greatly reduce risks associated with bugs, performance validation, inconsistent coding standards, dispersed teams with varying skill levels, and more.

 

Quest Software

Best Practices for Maximizing Code Quality in PL/SQL Applications

This presentation by Quest Software’s system consultant Kuljit Sangha will take you through database development best practices that empower you to write better-performing, higher-quality code with fewer bugs. He will do this by covering key functional areas that help you guarantee application success. This is includes giving you the ability to work smarter through collaboration and standardization across your development team. Kuljit will also share how, through this best practices approach, your organization can greatly reduce risks associated with bugs, performance validation, inconsistent coding standards, dispersed teams with varying skill levels, and more.