RE: SQL*Optimizer

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: 		[email protected]


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of John
Pocknell
Sent: Friday, February 10, 2012 12:05 AM
To: [email protected]
Subject: [toad] RE: SQL*Optimizer

  

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

 

From: [email protected] [mailto:[email protected]] On Behalf Of
MCALLISTER, MICHAEL CTR AU Contractor AETC AETC/A3IS
Sent: 01 February 2012 01:58
To: [email protected]
Subject: [toad] SQL*Optimizer

 

  

All

As far as I know, when evaluating various versions of a SQL statement within
SQL*Optimizer, you need to leave your computer running. What would be
awesome would be if there was a way for SQL*Optimizer 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