Vancouver Oracle Users Group



 



VanOUG would like to thank our Corporate Sponsors for their contributions

The Oracle JOBS List is now active! 

Click Here to join the VanOUG events and jobs email lists!

 

What We Do   Support the community by organizing:
  • Education Seminars
  • Technical Presentations
  • Case Studies
  • Hands-on Workshops
  • Best Practice Symposiums
  • Special Guest Lectures
  • Networking Opportunities
  • Social Events
 Our Next Event

 

Bill Brunt, 

Database Systems Consultant

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Caleb Small,

Senior Curmudgeon DBA

  Vancouver Oracle Users Group Meeting Announcement

 

Wednesday, April 23, 2014

5:00 - 8:00pm

BC Liquor Distribution Branch 

3200 East Broadway, 

Vancouver, BC 

Light Dinner Included

Advance registration is required for security

Please thank our meeting sponsor Dell

Database Replication, Bill Brunt

Database replication as an architectural strategy moved into mainstream several years ago. Today, all the major players including IBM, Oracle and Dell offer high speed, log based, fault tolerant, asynchronous streaming replication solutions. This presentation will first cover the fundamentals of replication and then quickly dive into specific implementation considerations for several use cases including disaster recovery, load isolation, auditing and more.

About Bill

Bill Brunt started working with Oracle in 1988, presenting 4 previous times at OOW and its predecessor. He has worked with SharePlex for both Dell and as a customer. He has helped hundreds of customers increase the availability and deploy scalable infrastructures. His experience with Oracle includes database administration, architecture, data warehousing, Oracle EBS and application development. Hands on experience with replication technology includes change data capture, messaging queues, block level disk writes, enterprise application integration, extract transformation and load.

Poor Man's Auditing with Log Miner, Caleb Small

The need for database auditing is a topic that most DBAs have heard loud and clear. Oracle offers many auditing solutions including the standard audit trail, trigger based auditing, Total Recall and Audit Vault.  The specific requirements of each individual application must be assessed before choosing the appropriate strategy.

One of the simplest, yet most powerful solutions is the time tested LogMiner. Oracle LogMiner allows reconstruction of past SQL statements with values from the on-line and archived redo logs, provided that some simple configuration requirements are met. While there is some additional overhead imposed on the database, for the most part all the necessary mechanisms are already in place and no additional audit trails or log files need to be maintained. 

This presentation steps through the decision criteria for selecting this option, and the actual database implementation steps.

About Caleb

Caleb is a senior consulting Oracle DBA with decades of experience in IT, and specifically with Oracle high availability installations since version 7. He has deployed dozens of production systems on both scratch built and engineered systems including the the Oracle Database Appliance. This, in combination with his experience as a professional instructor, and featured speaker for user groups around North America makes his presentations both informative and entertaining.

 

Registration

Advance registration is required for security.

To register, please send an email with you name and business contact information to:

 

register@vanoug.org

 

 
Who We Are   We are an independent, not for profit, organization created by users of Oracle software (DBAs, Developers, Analysts, and IT management) to enhance our knowledge and our community.
 
Special Offer for our Members  
 
Contact Us   Email Us : With questions and suggestions.

Click Here to join the VanOUG events email list

Our Sponsors