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 NOVEMBER 03, 2021

Applies to:

SQL*Plus - Version 10.2.0.2 to 10.2.0.4 [Release Oracle10g]
Information in this document applies to any platform.
*** Checked for relevance on 25-Feb-2019 ****

Symptoms

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:

spool_file.sh
 


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.

Cause

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
Symptoms
Cause
Solution
References

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