Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

What to do if edb360 takes long to run

with 4 comments

Every once in a while it comes to my attention that edb360 takes several hours to run. What can be done? My advice is to let it run for several hours if possible. In most environment it completes in less that 1 hour, but I have seen cases where it may take 5 or 6. The reason is simple: too many SQL statements to execute. And some of those queries are executed on top of large historical sets. The good news is that edb360, as it executes each script, it compresses the output and catalogues it inside the main output ZIP file. So, even if you have to stop edb360 after hours of execution, the output is useful. On top of that, the least relevant collection happens at the end, so within the first hour or so you most probably have the essence of your system. Then, if you find yourself in a situation where edb360 has been in execution for several hours and you decide to kill it, please still use the output ZIP file. Also, within that file there are a couple of logs that can help to determine where exactly it got “stuck” (meaning which query is taking longer in your system). Since we don’t know in advance if edb360 will take more than 1hr to run, the best time to start its execution is at the end of a normal work day, or during the weekend.

Advertisements

Written by Carlos Sierra

October 15, 2014 at 6:08 pm

Posted in edb360

4 Responses

Subscribe to comments with RSS.

  1. Just had my longest running edb360 for a problem client called Worldwide Express. As you advised, I ran late in the day, it’s a Friday. It eventually finished after 3+ hours. Hopefully the output may explain the long run time. I might share it with you, if you’d like?

    Michael Fontana

    October 17, 2014 at 7:59 pm

  2. I will reply privately with the location where it may be picked up, as it is rather large. This client apparently has turned on an option to automatically capture sql plan baselines, and there are over 6 million. I was wondering if that might have something to do with this?

    Michael Fontana

    October 20, 2014 at 9:44 am

  3. […] What to do if edb360 takes long to run […]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: