[14.0.2] Command Window Slow and Waste Memory

[D.Wenzel]

Ahoj,

i have a SQL-File - 30 MBytes, inside are anonymus PL/SQL Block with 7.500 Lines with Api Calles

1st

in SQL* Plus each Block needs seconds

09:27:11   Start Insert
09:27:12   Temp-Recordcount:7500
09:27:12   Temp-Recordcount:15000
09:27:14   Temp-Recordcount:22500
09:27:15   Temp-Recordcount:30000
09:27:16   Temp-Recordcount:37500
09:27:17   Temp-Recordcount:45000
09:27:18   Temp-Recordcount:52500
09:27:19   Temp-Recordcount:60000
09:27:20   Temp-Recordcount:67500
09:27:20   Temp-Recordcount:75000
09:27:21   Temp-Recordcount:82500
09:27:24   Temp-Recordcount:90000
09:27:24   Temp-Recordcount:97500
09:27:25   Temp-Recordcount:105000
09:27:26   Temp-Recordcount:112500
09:27:30   Temp-Recordcount:120000
09:27:31   Temp-Recordcount:127500
09:27:32   Temp-Recordcount:135000
09:27:33   Temp-Recordcount:142500
09:27:38   Temp-Recordcount:150000
09:27:39   Temp-Recordcount:157500
09:27:40   Ende Insert

in the command window it need minutes - same database - no other workload, no blocking Sessions, the database do nothing, the Oracle Client is the same 19c

ECHO is OFF

09:33:15   Start Insert
09:35:57   Temp-Recordcount:7500
09:38:14   Temp-Recordcount:15000
....

2nd if i open the file the memory consumption added with 300 Mbytes

Question: it is possible do disable the coloring in command windows and make the Processing faster?

 

[Marco Kalter]

This is currently not possible. I have added this to the list of enhancement requests.

 

[D.Wenzel]

Dankeschön