Take the 2-minute tour ×

Currently i am running multiple queries which spool the output to a file this can be a lengthy process, below are my current settings in sqlplus.

set feedback off
set heading off
set echo off
set termout OFF
set linesize 150
set long 1999999
set longchunk 1999999
set pagesize 0
spool results.sql
spool off
set termout on
set echo on
set heading on
set feedback on

I was wondering if there is any way i can speed up this process? Or is there a faster way of sending output of the queries to a file using sqlplus?


share|improve this question
It's probably not the outputting of the results that is the problem but the queries being performed. You would need to improve the performance of the SQL. –  Ciarán Feb 14 '13 at 9:26
@Ciarán i'm running very simple select queries e.g.Select id,name,address from person; that is as complicated the queries get. –  JCS Feb 14 '13 at 9:39
You can try to increase the arraysize to something like 500. If the bottleneck is the network from the database to your client, it'll speed up a bit. –  Plouf Feb 14 '13 at 10:06

Your Answer



Browse other questions tagged or ask your own question.