Monthly Archive: July 2015

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 ( 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 In his presentation he mentioned a really cool data mocking site called Mockaroo. I’ll have to keep that in…
Read more