Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...

-- This script calls the SP_WhoIsActive stored procedure 10 times in a loop with a 5-sec delay, storing the result set in a temp table -- and then displaying the results in descending order of ...

for this script utl_file is no longer being used. The problem is that some SQL is over 2499 characters in length, and it may be stored as one line in the data dictionary SQLPlus cannot execute lines ...