Sometimes you have to run a query that takes FOREVER, and you want to go home with your laptop. If you have access to a server with SQL*Plus, you can run the query there in the background. Here’s how:
nohup sqlplus /as sysba @file.sql &
tail -123f nohup.out
have a good day.