Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Are any other Compose users experiencing significant table fragmentation in their data mart (TDMA) tables? For example, one of our data warehouse tables is 31.7 gb and its data mart equivalent table is 129gb. The data and rowcounts in each table is the same. If we move the table to another tablespace and then move it back, the size of the table goes back to normal and the wasted space is gone. This workaround is far from ideal. Does anyone have any suggestions?
We are on Oracle 12.1.
I wanted to provide an update on this. The TDWH table is still 31.7 GB but the TDMA table has grown in size to 153 GB. Again, same data and rowcounts in both. Is there any configuration that would help prevent such extreme table fragmentation?