What is the simplest (preferably without any new table creation) way of running a database query which takes long time (at least several minutes) in Oracle DB?

Consider using DBMS_LOCK.SLEEP(300), where parameter - number of seconds to wait.

Simulation of long-running Oracle DB query

Consider using DBMS_LOCK.SLEEP(300), where parameter - number of seconds to wait.

132

answered Oct 29 '22 18:10

DBMS_LOCK.sleep

(http://www.oracle-base.com/articles/9i/UsefulProceduresAndFunctions9i.php)

answered Oct 29 '22 18:10

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!