Current Trends/Use Cases for Oracle Golden Gate, Feb 23rd
DOUG Events
Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments, connecting Oracle with SQL Server, mySQL, or other databases. In this session, Ramkumar Rajagopal will dive into how companies are using GoldenGate and what the trends are for the product.
Spring Mixer Set for March 23rd
General
DOUG will hold its 2017 spring mixer at the Maggiano's in North Park. The event will be on March 23rd and will run from 5pm to 9pm. There will be great food and drinks, along with over $1000 in prizes. We will also be announcing the winner of the DOUGie of the year award from 2016. For all registered members, the events is free and each registered member can bring a guest. This is a great opportunity to show how much fun we can have.
Oracle Database Security Test Drive on February 7th
Oracle Events
The Oracle Database Security Test Drive is a one-day hands-on session for IT Managers, IT Security Architects, Developers and Oracle DBAs considering solutions to address information protection, privacy, and accountability challenges within their Oracle database environment. At the end of the test drive, attendees will understand basic concepts for and be provided hands-on exposure to:   Transparent Data Encryption Redaction Key Vault Database Vault Audit Vault and Firewall Subsetting and Data Masking   All material is appropriate for both 11gR2 and 12c databases. The first 90 minutes of the test drive will be dedicated entirely to concepts for all technologies …
Cary Millsap Talks Oracle Performance
DOUG Events
Event is free to the public.   Presentation Overview “Cary Millsap Talks Oracle Performance,” presented by Cary Millsap, Method R. Presenter Bio Cary Millsap is a writer, teacher, designer, developer, consultant, and software performance specialist. He has presented at hundreds of events around the world, and his blog is read by thousands of people each month. He is the author of The Method R Guide to Mastering Oracle Trace Data and the lead designer of the Method R Workbench software suite. He wrote the bookOptimizing Oracle Performance, for which he and co-author Jeff Holt were named Oracle Magazine’s 2004 Authors of the …
DOUG Board Announces Officers for 2017-18 Term
General
The 2017-18 DOUG board met for the first time in-person this evening and started laying out the first steps of the upcoming term.  Our officer appointments are: Keith Wilcox  –  President Mahesh Bhagavatula  –  Vice President Chris Frost  –  Secretary Susan Behn  –  Treasurer Bert Scalzo  –  Member-at-Large
Back to Basics: The Art of Conversation
Articles
Written by Patrick Donlin   Introduction In a digital age, social and business networking sites, job boards, tweeting, blogging etc., provide untold volumes of information that must be sifted, sorted and assessed before becoming usable in a meaningful way.  Engaging your network through personal face-to-face conversations is a dying art, and one that is unmatched in the quality of information gained, plus it’s a lot more fun!   Today’s World Today we seem to be inundated with technology that facilitates constant communication with our friends, colleagues and clients.  There is no doubt that Blackberries, iPhones, iPads, laptops, and the like …
Collections in PL/SQL: An Introduction
Articles
Written by Bob Watkins, Managing Partner of B. Watkins Collections are an essential tool in PL/SQL programming. In this article, we’ll take a look at what collections are, why they’re important, and how to declare and use them. What are collections? Collections are datatypes that you use to declare variables in your PL/SQL program. Unlike built-in datatypes like NUMBER and VARCHAR2, collection datatypes are user-defined: you must first declare them, give them a name, and decide how they are structured.  Then you can declare variables based upon the new datatypes. Oracle defines a collection as: “an ordered group of elements, …
Data Guard for Dummies
Articles
Written by Charles Kim,  Oracle ACE and an Oracle Certified DBA Data Guard provides a simple solution to protect your data.  Data Guard maintains standby databases as transactionally consistent copies of the production database. These standby databases can be located at remote disaster recovery sites thousands of miles away from the production data center, or they may be located in the same city, same campus, or even in the same building. If the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch any standby database to the production role, thus minimizing the downtime …
Holiday Xmas Wishes
Articles
Written by Mary Elizabeth McNeely, DOUG President An Oracle Christmas Song Sung to the tune of “The Twelve Days of Christmas” On the first day of Christmas, My true love sent to me An index that’s a b-tree. On the second day of Christmas, My true love sent to me Two raw devices, And an index that’s a b-tree. On the third day of Christmas, My true love sent to me Three corrupt blocks, Two raw devices, And an index that’s a b-tree. On the fourth day of Christmas, My true love sent to me Four TKPROFs, Three corrupt blocks, …
Application Express: The Power of APEX Interactive Reports
Articles
Written by Ricky Burke, Oracle Architect and Instructor Oracle Application Express (APEX) is a free development tool for the Oracle database.  Using only a web browser and limited programming experience, you can rapidly develop and deploy professional, scalable and secure web-based applications. APEX is easy to use, flexible and highly productivity.  No client-side software installation is necessary, and when configured with the XML DB HTTP server built into the Oracle database, there is no need for a separate web server. One of the best features of Application Express is the new Interactive Report.  This article starts by covering the complete …