Oracle - truncating a global temporary table

Question

I process a large amount of data in iterations, each and iterations process about 10-50 000 records. Due to such a large number of records, I first insert them into the global temporary table and then process it. Usually each iteration takes 5-10 seconds.

Would it be wise to trim the global temporary table after each iteration so that each iteration starts with an empty table? There are about 5,000 iterations.

Answer 1

No! The whole idea of ​​a global temporary table is that data automatically disappears when you no longer need it.

, , , COMMIT, ON COMMIT DELETE ROWS .

, TRUNCATE - COMMIT, .

Answer 2

5000 50000 ? , , . .

, temp, , .

. "" , . , .