Toad World® Forums

Automation - Several SQL Queries

I have five Oracle Select SQL Queries I need to run in Toad or use a scheduler for automation. Some of the select queries have different fields and I need to pull the results into some kind of table for reporting/analysis. Some of these queries run very slow. Anyway to speed-up? How do I accomplish this using Toad or task scheduler or PL/SQL, etc. I do not have access to server, just the client machine with read only priveleges.

Paul

Hi Paul,

The questions you posted are a bit general and there a probably a million different ways to do what you want. I’ll try to address some - probably not the
answers you were looking for, but without specifics, it’s nearly impossible to help too much - sorry.

Some of these queries run very slow. Anyway to speed-up?

I’m sure there are many ways to speed up the queries, but it’s impossible to tell since we don’t have the queries. I would ask your DBA or an advanced developer to help you
here, if you’re not familiar with tuning Oracle queries. In Toad, if you go to Database > Optimize, you’ll find several different ways to possibly help with this (depending on your Toad version of course).

How do I accomplish this using Toad or task scheduler or PL/SQL

If you want to automate a process, I would recommend using Toad’s Automation Designer. There is a lot of material on how to use this in the Help, as well as, a ton of stuff
on Toad World (articles, blogs, wikis, etc.). I would recommend reviewing that material if you want to automate any processes. The way you go about doing what you want, is completely dependent on your knowledge and experience with the tools and Oracle.

There was a similar thread awhile ago that might help a little.

http://www.toadworld.com/products/toad-for-oracle/f/10/p/19972/40644.aspx#40644

Thanks,

Dennis