Re: How to make the SQL to run longer?

On Jun 27, 11: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

What platform is your database on? If unix, you can do things like renice the user process to have a very low priority.

You might also lock table in exclusive mode from another process, make it as long as you want, if your sql is trying to write to a table rather than just querying. If it is just a query, maybe you can wrap the query into an insert into a dummy table? Oh yeah, is there an index you can disable or a hint you can give to make the optimizer do the wrong thing? Are there foreign keys involved in the query, can you modify their index definitions?

Then there's always the brute force method of having a lot of sessions pound on the table with batch jobs until everybody slows down. Or if your database is remote, pound on the network - some linux have options on ping that are basically a denial of service attack.

It may not be all that difficult to simply make a large amount of data, you know your table constraints, can you use Oracle's random function or sequences to generate lots of rows? Or even use Brian's all_objects example on your own table?

jg

--
@home.com is bogus.
That darn Internet, interfering with the legal system again:
http://www.signonsandiego.com/uniontrib/20070627/news_1b27prgn.html