Toad World® Forums

SQL*Optimizer

All

As far as I know, when evaluating various versions of a SQL statement within SQLOptimizer, you need to leave your computer running. What would be awesome would be if there was a way for SQLOptimizer to submit the optimizing task to Oracle instance as a job, and record the results in a TOAD table of some sort that the client could read back the results of later. Is this possible?

Mike

Hi Mike,

SQL Optimizer’s optimization engine is a client-side process and so
wouldn’t be able to run on the server. This also applies to the Batch SQL
operations. A simple solution would be to run SQL Optimizer directly on the
Oracle server and use Scan SQL to identify the SQL prior to optimization.

However, I will take your suggestion to the SQL Optimizer development team and
see if this is feasible.

Thanks you.

John
image002.jpeg

Hi Mike,

SQL Optimizer’s optimization engine is a client-side process and so
wouldn’t be able to run on the server. This also applies to the Batch SQL
operations. A simple solution would be to run SQL Optimizer directly on the
Oracle server and use Scan SQL to identify the SQL prior to optimization.

However, I will take your suggestion to the SQL Optimizer development team and
see if this is feasible.

Thanks you.

John
image001.jpeg

John

I hear what you’re saying. Just so I clarify what I’m getting at here, I’m
fine with the client coming up with all the alternatives on my machine. It’s
just running all the alternatives sometimes takes a while. What I’m
proposing is offloading the portion of the evaluation which runs the
alternatives to something that operates purely on the server.

I do understand we can load the tool directly on the server. Unfortunately,
that’s not something that we’re allowed to do in the security environment I
work in.

Regards,

Mike McAllister
Principal Systems Engineer
Decypher
DSN: 487-3751
Commercial: (210) 652-3751
Cell: (512) 423-7447
Email: michael.mcallister.2.ctr.au@us.af.mil
smime.p7s (5.59 KB)