My Oracle Support Banner

Spooling Records From SQL*Plus Appears To Be Hung, But Actually Taking Too Long (Doc ID 781447.1)

Last updated on MAY 27, 2023

Applies to:

SQL*Plus - Version to [Release Oracle10g]
Information in this document applies to any platform.


When spooling a table to an ascii file, it takes a long time to complete. This is noticed when SPOOL command is used together with TRIMSPOOL and LINESIZE parameters.

For example, consider this script which is used to spool data from SQL*Plus:

Once script is executed, it is observed that the spool file (count.log) gets created far earlier than the
script execution time (out.log). There is a considerable time difference between spool completion and script completion.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.