Author Archive: Alfredo

XLA_GLT Tables Not Being Dropped in EBS 12.1.3

The Problem Recently I was going through a list of our top largest tables in our E-Business Suite (12.1.3) database (11.2.0.3) and found many tables in the GL schema that began with XLA_GLT_*.  Looking into this further I found over 300 of these tables (which also had indexes and synonyms) consuming over 30 Gigs of space.     Research After doing some research on My Oracle Support I found several articles that helped explain what we are seeing.  One of them in particular was a direct match to our problem, “SLA: Temporary Tables XLA_GLT_ % Are no Longer Dropped (Doc…
Read more

Chicago Oracle Users Group Meeting July 23rd 2015 – Recap

We had another great user group meeting this past Thursday! We had two excellent presentations by two very well known speakers! Our 1st presentation was by Oracle Ace, Biju Thomas. He did a great job going over a lot of cool new features available in 12c especially for those of us that are still 11g DBAs. Our 2nd presentation was by Oracle Ace Director, Jim Czuprynski. He provided a great presentation on the JSON features available in the Oracle Database 12.1.0.2. In his presentation he mentioned a really cool data mocking site called Mockaroo. I’ll have to keep that in…
Read more

12c New Feature – Online Statistics Gathering for Bulk Loads

How many times have we had to execute a CREATE TABLE AS SELECT or INSERT INTO…SELECT that involved a large amount of data then wondered why queries against this table are slow? Did we forget to gather statistics after the fact perhaps? Well in Oracle Database 12c there is a new feature that will gather online statistics for you when performing bulk loads when using either one of two bulk loading methods: 1) CREATE TABLE AS SELECT 2) INSERT INTO … SELECT into an empty table using a direct path insert   Example – Default Behavior (CREATE TABLE AS SELECT)…
Read more

Chicago Oracle Users Group Meeting May 13th 2015 – Recap

We had another great user group meeting this past Wednesday! We had 2 excellent presentations. Our 1st presentation was by Oracle Principal Sales Consultant Omar Amad on Oracle Linux, Oracle VM and Oracle Cloud.  This also included a live demo of Oracle Ksplice and why not installing the latest security patches can leave us open to vulnerabilities. Our 2nd presentation was by Oracle Ace Director, Michelle Malcher, on Oracle Database 12c Security. She provided a very informative overview of security improvements in 12c which gives us yet another reason why we should be moving towards this version. Our meeting was…
Read more

RMAN Duplicate Error with ASM and 4k Sector Size Disk

The Problem I recently ran into an issue when performing a RMAN duplicate on a server with a fresh installation of OEL 6.4 x86-64 using a brand new SAN (NetApp Data ONTAP 8.2).  The database version is Enterprise Edition 11.2.0.3. The datafiles restored without an issue but when we got to those archived redo logs I hit an ORA-00600.  Specifically it was this error. At first I chalked it up as a fluke, so I tried the RMAN duplicate again.  Well the datafiles restored just fine but once again when I got to the archived redo logs I hit the ORA-00600…
Read more

Chicago Oracle Users Group (COUG)

As of February 2014, I feel fortunate and honored to be put in charge of running the Chicago Oracle Users Group (COUG). I really feel like I’m doing our user community a great service by coordinating these periodic meetings to allow all of us to continue to get educated on the latest Oracle technologies as well as provide beneficial networking opportunities. Last year we were able to hold 5 meetings including one large meeting with Tom Kyte. This year we are off to a good start with a meeting in Feburary and another one coming up in May. If you…
Read more

COLLABORATE15 – First Time Attendee

After years of working with Oracle technologies I finally made it to one of the big conferences.  Last week I attended Collaborate 2015 in Las Vegas.  I was very excited to attend and there were so many presentations that I was interested in seeing that for some time slots I was quadruple booked! One of the last sessions I attended on my last day there was one titled ‘Nothing to BLOG About – Think Again’.  This was led by the well known Micheal Abbey with a panel consisting of Ludovico Caldera, Michael Dinh, Bobby Curtis and Michelle Malcher.  Blogging has…
Read more