0 What is the Size Limit for the Oracle Spool File

        The limit in Oracle for spool file is 2 GB. And there will be a performance impact on the machine where you generate the spool file if the file is large because of frequent IO operations.So, spooling in a client machine will affect its performance only and hence the DB Server will not have any performance impact.

        The limit above mentioned is true for 32-bit version. You can generate a much larger file using 64-bit versions. Spooling can affect the I/O operations on the server though it is a pure client thing. The arraysize parameter can affect the I/O (logical mostly).

Make sure you set the correct arraysize parameter while you extract.