Sample Header Ad - 728x90

Truncate table takes too long waiting db file async i/o submit

0 votes
0 answers
367 views
I've got Oracle 12c data warehouse database on oracle Linux 7.3, and there's job that truncating one table. Table has size of 5GB And always truncate takes about hour with waiting for "db file async i/o submit". Filesystemio and disk_asynch_io are set to asynch already. What can I do here? Thanks in advance.
Asked by Sebastian (1 rep)
Nov 29, 2022, 10:59 AM