Author Archive: Alfredo

ODC Appreciation Day 2017: Crash Recovery

ODC Appreciation Day 2017: Crash Recovery Today this blog post will be my contribution to Oracle Developer Community ODC Appreciation Day (#ThanksODC). This is an idea that started in 2016 by Tim Hall (aka oracle-base).  More information about it can be found on his blog.  Last year it was using the old OTN name but as you can see that name has changed now to ODC.  You can read my 2016 contribution here. The one feature that I feel that all DBAs, Developers, etc should be grateful for but we probably take for granted in the Oracle database is Crash Recovery.  When…
Read more

Chicago Oracle Users Group Meeting September 26th 2017 – Recap

Our Chicago Oracle Users Group meeting on September 26th marked our fourth meeting of 2017.  We had two Oracle ACEs and one Oracle ACE Director.  Thank you Craig Shallahamer, Francis Mignault, and Jorge Rimblas for bringing us five outstanding presentations! Agenda We held the meeting at my old employer, The Pampered Chef, which is located in the suburb city of Addison.  Pampered Chef’s auditorium is an awesome meeting space!  The same location was used in for one of our 2016 meetings as well (recap here).  The meeting had five presentations, lunch, raffles, and a whole lot of networking! Presentations A lot of…
Read more

Chicago Oracle Users Group Meeting August 8th 2017 – Recap

Our recent Chicago Oracle Users Group meeting on August 8th marked our third meeting of 2017.  We had not one but two Oracle ACE Directors!  Nitin Vengurlekar and Richard Niemiec brought us a total of five feature packed presentations! Agenda The day went by very quickly.  The location of the meeting was the Prairie Center for the Arts in Schaumburg.  This was our first meeting at this location and we used the lecture hall.  I loved this space as it had good acoustics and plenty of seating.  We did something special and live streamed the sessions with the help of ProHuddle….
Read more

Chicago Oracle Users Group Meeting June 22nd 2017 – Recap

We had our second Chicago Oracle Users Group meeting of 2017 on June 22nd.  We were fortunate to get Willie Hardie, Vice President, Oracle Database Product Management and Oracle ACE Director, Jim Czuprynski. What’s New in Oracle Database 12c Release 2 First, Willie presented an awesome talk on What’s New in Oracle Database 12c Release 2.  This included but was not limited to some cool new features in the areas of: Enhancements on In-Memory Online Tablespace encryption PDB Hot Clone Oracle Sharding Big Data – Partitioned External Tables Enhancements in Approximate Query Processing You can learn about these features and many more in detail…
Read more

Purging Oracle EBS Integrated SOA Gateway Tables

If you happen to be using Oracle E-Business Suite Integrated SOA Gateway (ISG) you may at some point find yourself retaining way too much data.  Did you know that there is a seeded purge program available that will delete data from the underlying tables?  This is helpful to maintain the data at a reasonable size to help performance and minimize the storage footprint.   Observations My SOA purging journey began due to a performance related issue.  This occurred when I navigated to the Integrated SOA Gateway responsibility > SOA Monitor, it was taking upwards of 5 minutes to pull up that web page.  When I…
Read more

Collaborate 2017 Recap

Collaborate 2017 Recap Well another Collaborate conference has come and gone.  I cannot even believe how fast it went!  This year marked my 3rd year at Collaborate.  Initially as an attendee registered under IOUG but a few weeks before the conference I was asked by OAUG to present my session from last summer’s Apps Tech virtual conference.  I was more than happy to help and very excited to be presenting again! My goals of the conference were: Attend as many E-Business Suite, Cloud, Big Data, and personal development sessions as possible Inspire some new folks, through my presentation, to extend…
Read more

Chicago Oracle Users Group Meeting February 23rd 2017 – Recap

We kicked off 2017 with an awesome Chicago Oracle Users Group meeting on February 23rd. We had excellent presentations by Moizuddin Mohamed and Oracle Ace Director, Jim Czuprynski! Moizuddin was our COUG “Show and Tell” and provided us with a presentation on GoldenGate High Availability Using DBFS in an Exadata/RAC environment. He demonstrated a use case where he has a DBFS instance at a primary site but uses GoldenGate to replicate the DBFS instance to a disaster recovery site as well.  Giving the ability to easily start the instance at either site for both planned and unplanned outages with minimal…
Read more

Chicago Oracle Users Group – Cloud Experience Workshop Recap

You really can’t go anywhere these days without hearing about the “cloud”.  If you’re an Oracle technologist you should be well aware of all the Oracle Cloud offerings that are available.  If you’re a DBA then it’s critical to understand the role of the Oracle Cloud in your day to day decisions for current and upcoming IT projects. The COUG had an awesome Cloud Experience workshop at the end of October where we were able to experience building a database (single instance or even RAC) in the Oracle Public Cloud. Our workshop was led by Oracle Ace, Erik Benner.  Erik started…
Read more

OTN Appreciation Day: Oracle RMAN

My favorite feature to date has to be Oracle RMAN (Recovery Manager).  Why?  Well I really believe that at the end of the day the most important job of the DBA (and there are many!) is to ensure that the data is protected.  If you lose an organization’s data not only will you most likely lose your job but you could potentially cause some serious financial issues (not to mention bad reputation) for that organization. I may have a different appreciation for RMAN than those who may have not had an opportunity to work with the Oracle database prior to…
Read more

Chicago Oracle Users Group Meeting August 26th 2016 – Recap

We had another awesome COUG meeting on August 26th. We held the meeting at my old stomping ground, The Pampered Chef located in the suburb city of Addison. They provided us with a roomy space, free giveaways (The Pampered Chef Water Infuser), and held an appetizer/cocktail hour afterwards for us. Oracle Ace Director, Rich Niemiec, lead off the morning with a presentation on Innovation, Big Data, Oracle Cloud, IOT and the Future. This presentation was packed with information and left you with a lot of things to contemplate on the future of Oracle and overall technology as a whole. After a…
Read more