SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Truncate but still have table fragmentation?

Amethyst QinJul 21 2015 — edited Jul 27 2015

Hi,

We just resolved a performance issue, I guess it's due to table fragmentation, but not sure how the fragmentation happened as the table is always truncated and reloaded.

I thought the TRUNCATE would always reset the HWM and the fragmentation wouldn't happen. Is there any other possibilities?

The job has always been running less than 30 mins. Recently nothing is changed to any procedures, tables etc - not confirmed with DBA DB maintenance. Then the job runs up to 11 hrs. By recreating the table, the job runs from 11 hrs to 25mins. Note the job and tables are old for years.

What could be the reason behind this please, any ideas

Thanks

Amy

This post has been answered by Amethyst Qin on Jul 27 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2015

Added on Jul 21 2015

18 comments

4,622 views