Use this simple SQL script–lay.sql–to generate the layout for the spooled file. Run the script before spooling the table to get the layout
Generating Spool File Layout
Previous post: Things to do if your query is slow
Next post: Restrict User From Entering More Than 100 Records