Huy, February 16, 2016 - 6:07 pm UTC
As you mentioned that:
"So fragmentation is not a problem, it can only be the *cause* of problem, eg, it was fragmentation that *caused* the slowness etc. "
I wonder how can table fragmentation that caused the slowness be proactively prevented from happening?
Thanks,
February 17, 2016 - 12:41 am UTC
With regard to
"I wonder how can table fragmentation that caused the slowness be proactively prevented from happening?"
the first this I'd want to see is evidence that correlates the two
Fragmentation issue
Raj, April 08, 2024 - 3:08 am UTC
Tom,
I have a table with 250 Columns with 17 CLOB columns. Data is injected deleting all data(Instead of Truncate) and loaded from Flat file again. We are using Delete and Insert in one single transaction to retain old data in case of process failure. Code is written in Java. We found this issue as eventually querying this table is slow and table size is accumulating space to Huge 100+G.
I am facing Fragmentation issues, every time we run the load process table size is increasing. Options that we are choosing to resolve is to Truncate once and reload or export and import again.
But, what is actually happening? Why fragmentation is happening? Is there any settings or options that we can give, so Fragmentation can be resolved in first place.
Appreciate your help and thanks in advance.
April 08, 2024 - 6:38 am UTC
Can you use DBMS_METADATA to post the entire DDL for the table here please.
Fragmentation Issue
Raj, April 08, 2024 - 1:29 pm UTC
I will try to use Metadata to see what information it gives and what I can share and what I cann't