Re: How to make the SQL to run longer?

"Raj" <jkamaraj_at_gmail.com> wrote in message news:1182969005.484285.53600_at_q69g2000hsb.googlegroups.com...
> 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
>

For Oracle, you could consider the following from my blog

    http://jonathanlewis.wordpress.com/2007/05/15/slow-code/

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html