Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to make the SQL to run longer?

Re: How to make the SQL to run longer?

From: <a.quick.email_at_gmail.com>
Date: Thu, 28 Jun 2007 04:28:58 -0000
Message-ID: <1183004938.542843.219230@i13g2000prf.googlegroups.com>


On Jun 28, 4:30 am, Raj <jkama..._at_gmail.com> wrote:
> Hell All,
> To reproduce one of our cusotmer's probem, I need to make the SQL to
> run for more than a minutes before it returns the result set. I do
> not
> have large amount of data in the database to simulate the dealy.
>
> Is there a way in SQL to cause the delay while returning the result
> set
>
> Thanks for the help.
> Regards
> Raj

grant execute on dbms_lock to the_user ;

create or replace function the_user.sleep_for ( sleep_time in integer )

        return integer is
begin

	DBMS_LOCK.SLEEP(sleep_time) ;
	return sleep_time ;

end;
/ Received on Wed Jun 27 2007 - 23:28:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US