Delay Time when executing sql command

[kirubagari]

Attach my sql and i need to put wait for delay command so that the sql will process after 59 second to optimize cpu usage.I dont know how to handle the scenario.
The changes is i want to reduce no. of records per query compared to current one.I might need to put delay
time.The code is error when perform the compiling since im using PRO*c

EXEC SQL EXECUTE 
                    BEGIN 
                       INSERT INTO caruser.fwcarrierhistory_hist
                                  (sysid, carrierid, carriertype, carrierstate, carrierstatus,
                                    componentqty, lotid, LOCATION, activity, txntime, txncomment,
                                    cleancount, usedcount, lastcleandate, grouphistkey, txnkey,
                                    username)
                          SELECT sysid, carrierid, carriertype, carrierstate, carrierstatus,
                                 componentqty, lotid, LOCATION, activity, txntime, txncomment,
                                 cleancount, usedcount, lastcleandate, grouphistkey, txnkey,
                                 username
                            FROM caruser.fwcarrierhistory
                           WHERE sysid = :sysId; 
                       DELETE FROM caruser.fwcarrierhistory
                             WHERE sysid = :sysId;
                             WAITFOR DELAY '00:00:59';
                       INSERT INTO caruser.fwcarrierhistory_pn2m_hist 
                                   (fromid, linkname, SEQUENCE, valtype, valdata, keytype,
                                    keydata)
                          SELECT fromid, linkname, SEQUENCE, valtype, valdata, keytype, keydata
                            FROM caruser.fwcarrierhistory_pn2m 
                          WHERE fromid = :sysId; 
                       DELETE FROM caruser.fwcarrierhistory_pn2m 
                             WHERE fromid = :sysId;
                             WAITFOR DELAY '00:00:59';                       INSERT INTO caruser.fwcarriercomment_hist 
                                   (sysid, commentcode, briefdescription, detaildescription)
                          SELECT sysid, commentcode, briefdescription, detaildescription
                            FROM caruser.fwcarriercomment 
                          WHERE sysid = :txnComment; 
                        DELETE FROM caruser.fwcarriercomment 
                            WHERE sysid = :txnComment;
                        COMMIT;
                    END; 
        END-EXEC; 

[rski]

To delay use sleep function

exec dbms_lock.sleep(59);