tags:

views:

122

answers:

0
Q: 

How to get Toad to send out daily SQL pool executed in Tools|SGA Trace/optimization.

Anyone knows how to do that? I can currently go to Tools|SGA Trace/optimization. to check the currently executed SQL. But i want toad to be able to send me daily. I think can use windows schedule task to achieve that . But how exactly to go about that anyone knows?

Will be good if anyone can also suggest if it is possible to also have a tuned SQL report churned out beside this SQL pool thing.

Thanks

related questions

Toad 'insert record' button disabled.
Query Optimization - Why does this speed up the Query?
Oracle Query Help - Using TOAD
"no descriptor for this position" Oracle error
SQL and toad
Advice from Toad for Oracle Formatter
Cannot Connect with TOAD but Can with Other Tools/Apps
Alternative to SQL Tools and Toad IDEs for Oracle query development
Is there anything as good as TOAD for Postgres (Windows)?
What tool do you use for developing and administrating your database?
Two Identical tables in Oracle
How do I set a field to null in Quest Toad "Browse Database Objects" view?
TOAD "Credential retrieval failed" error
TOAD vs AquaFold - Connecting to Oracle
Oracle sql query, concatenate fileds with CASE section
Monitoring a database instance
Monitor SQL currently in shared pool using Toad
How to check the overall health of database using Toad?
Tabbed VS Tree for navigaion. Which is the preferred approach?
How to pass an array parameter in TOAD
Toad unicode input problem
Where can I get Toad syntax coloring schemes?
What do you use to write and edit stored procedures in Oracle?
SQL/Query tools?