Oracle Database Discussions

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 response is very slow or run forever

2922227Jun 23 2016 — edited Jun 24 2016

Hi everyone,

oracle 12c linux64bits

Do you have experience this. when truncate a small table which record only has 200row of records but truncate statement like run forever. after restart the DB, truncate statement only take 1second..

may i know what setting caused this problem?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2016

Added on Jun 23 2016

#general-database-discussions

15 comments

6,171 views