generate a load on oracle database
June 5th, 2015
Sometimes you're doing a test of Oracle database, but the DB load is not high but you want the load go high to facilitate your testing. Here's the way:
DECLARE N NUMBER; BEGIN FOR I IN 1..100000 LOOP SELECT /*+ ORDERED USE_NL(C) FULL(C) FULL(S)*/ COUNT(*) INTO N FROM SH.SALES S, SH.CUSTOMERS C WHERE C.CUST_ID = S.CUST_ID AND CUST_FIRST_NAME='Sarah' ORDER BY TIME_ID; DBMS_LOCK.SLEEP(1); END LOOP; END; /
You can press Ctrl+C to cancel it.