Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to make the SQL to run longer?
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
Raj wrote:
Raj 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
>
> 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 ;