Welcome to the home of one of Cincinnati's premier professional organizations, the Greater Cincinnati Oracle User Group (GCOUG). ABOUT US...

Sponsor GCOUG

DOWNLOAD SPONSORSHIP BROCHURE

Big Thanks to our Meeting Sponsors!

 

Hotsos               Blue Ash YMCA

 

Vendor Sponsors Links

 

Ensure that a devoted audience of Oracle users sees your products via website advertising on the homepage of www.gcoug.org. This highly visible promotional vehicle enables your message to achieve a solid ROI for your campaign. Lean more by downloading the sponsorship brochure above.

Upcoming Meeting

JOIN US AT A GCOUG MEETING

GCOUG 4th Quarter Meeting

Tuesday, December 4th 2018, 9:00-3:30:

                                 GREATER CINCINNATI ORACLE USERS GROUP

                                                      December 4th, 2018

                                                             Location: 

                                                        Blue Ash YMCA

                                                       5000 YMCA Drive

                                                     Cincinnati, OH 45242

 

Have you ever heard of Oracle SQL Developer? Is it Free? Can I use it as a DBA or Developer?

How can I use SQL Developer to investigate Performance Issues?

Even Wondered how Oracle Stores its Data?

What is the best method(s) to Optimize my Oracle SQL code?

 

Please welcome Oracle Ace Ric Van Dyke who will present and discuss these topics on December 4th.

BIO:
Ric is an Oracle Ace with over 35 years of experience in the IT industry. Coming from a 3GL programing back ground he started working with Oracle Version 6 as a developer with Forms 2.3 and became a DBA at Ford Motor Credit.  He then worked at a variety of companies as an independent consultant.  Ric worked for Oracle Corporation for 10 years, starting as a core database instructor where he taught and developed several courses.  He became the Education Manager of the North Central Region.  Ric then served in the Advanced Technologies Services consulting group as a Technical Manager where he worked with several clients doing RAC installs and performance engagements.  Since 2005 Ric has worked at Hotsos Enterprises as a trainer and consultant.  Currently he is the Education Director at Hotsos where he coordinates training activities.  He also teaches both in-person and on-line training.  Ric frequently speaks at user group meetings and gives on-line webinars.

Meeting Agenda

08:30a - 09:00a               Meeting Registration/Check-in

09:00a - 10:30a               Using SQL Developer

10:30a – 10:45a               Break

10:45a – 12:15a               Journey to the center of the Cloud: A look at Oracle Data Blocks

12:15p – 01:00p               Lunch

01:00p – 02:00p               SQL Optimization – Part 1

02:00p – 02:15p               Break

02:15p – 03:15p               SQL Optimization – Part 2

03:15p – 03:30p               Q&A, Announcements, Gift Drawing

Abstracts:

Using SQL Developer:  As a DBA and a performance specialist having the right tools is key to success.  This presentation with show some basics about using SQL Developer to do both basic DBA tasks and help with performance optimization of SQL statements in particular.

Journey to the center of the Cloud: A look at Oracle Data Blocks:  This presentation will dive deep in to the core of the Oracle database, the Data Block.  Right down to how columns are stored and the overall block structure.   Also discussed will be what happens to rows as they are updated and if different block sizes really make a difference. 

SQL Optimization:  For the rest of the day the presentation will focus on how to go about optimization SQL selects.  The select statement is the core of any application and optimization really is about how to make statements do the least amount of work to get the results needed. Topics to be covered: Logical IOs, Reading Execution Plans, Indexing, Access Methods, and Joins.

Registration has changed. You now create an account on our website (www.gcoug.org) and then register for your meeting.

DIRECTIONS TO BLUE ASH YMCA:

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.

Take I-71 North RIGHT AFTER the bridge.

Continue I-71 North to exit 14 (Ronald Regan Highway).

Turn left onto Ronald Regan Highway (HW 126).

Stay in far-right lane.

Take the First exit to Kenwood Road (Blue Ash) and Turn Right.

Turn Right at the Next road, Kenwood Road .

Turn Left at the Next road, YMCA Drive.

Turn Left at the end of the road into the Main Parking Lot.

From Dayton, OH:

Take I-75 South to East I-275.

Take the I-71 South to Cincinnati ramp.

Continue I-71 North to exit 14 (Ronald Regan Highway).

Stay in far-Right lane to Stop Sign and Turn Right.

Take the First exit to Kenwood Road (Blue Ash) and Turn Right.

Turn Right at the Next road, Kenwood Road .

Turn Left at the Next road, YMCA Drive.

Turn Left at the end of the road into the Main Parking Lot

From Columbus, OH:

Take I-71 South to Cincinnati.

Go under I-275 and continue I-71 South to exit 14 (Ronald Regan Highway).

Stay in far-Right lane to Stop Sign and Turn Right.

Take the First exit to Kenwood Road (Blue Ash) and Turn Right.

Turn Right at the Next road, Kenwood Road .

Turn Left at the Next road, YMCA Drive.

Turn Left at the end of the road into the Main Parking Lot

Click here for more info...

From the Blog

Ask Tom

  • IN (vs) EXISTS and NOT IN (vs) NOT EXISTS

    Hi Tom, Can you pls explain the diff between IN and EXISTS and NOT IN and NOT EXISTS. Because I have read that EXISTS will work better than IN and NOT EXISTS will work better than NOT IN (read this is Oracle server tunning). Regard...

  • ORA-12560: TNS:protocol adapter error

    i'm running oracle on standalone computer at home.it used to work properly but from couple of days i'm getting error stating ORA-12560: TNS:protocol adapter error what should i do? please help.. ...

  • Converting CLOBS TO VARCHAR

    Can you give me a solution for converting CLOBS datatype to VARCHAR datatypes, all the documents I refer to talk about converting BLOBS to VARCHAR and when I try and apply the examples to CLOBS, get errors

  • How to connect SQLPlus without tnsnames.ora

    Hi I am trying to use SQLPlus to connect to database directly using just the connect string (ie without referencing to tnsnames.ora) I have this in my tnsnames.ora POD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(H...

  • How To FULL DB EXPORT/IMPORT

    Hello Tom, How to do a Full DB exp and Import. I do say exp systemmanager@xyz FULL=Y FILE=FULL.DMP Then If I want to do a full Import to a new freshly created DB which only has the default schemas sys , system , etc. 1) Please...

ONT Security Alerts