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