Why does my iSQL*Plus Dynamic Report timeout?
If your network connection is slow or your report takes a long time to process, your browser may timeout the connection before any results are returned. It may be necessary to reduce the time that the script takes to execute, or for it to return output data sooner. Using SQL optimizer hints like FIRST_ROWS may help.