Get Live Help

Start Chat

Assistant is available.

close

Product Support - SQL Optimizer for Oracle

Filter to browse recommended product support content
(Choose different product)

Self-service tools will help you to install, configure and trouble shoot your Dell Software product

480 X 270 player for the Support Link Solution pages
  • Summary
  • Knowledge
    Articles
  • Download
    New Releases
  • Release Notes
    and Guides
  • Product
    Life Cycle
When I send SQL from Toad to Sql Optimizer I get a blank screen. (58219)

When I send SQL from Toad to Sql Optimizer I get a blank screen. See attachment BLANK.jpg.  Also, when opening SQL Optimizer, it opens a new sessions, but there is no "Optimize SQL" window with SQL Details.

Product(s): SQL-Optimizer-for-Oracle
Created On: 10/21/2009
(3 Ratings)
Last Updated On: 3/18/2014
"Cannot find oci.dll: in " error when trying to connect. (69276)

When connecting in Optimizer, I get the error "Cannot find oci.dll: in CLI10GR2USER". This is an issue for anything I try to connect to. There are no problems connecting, using this client or to any database in other applications, including Toad. The errors below are received in this order, but...

Product(s): SQL-Optimizer-for-Oracle
Created On: 1/20/2011
(2 Ratings)
Last Updated On: 11/14/2013
Support of Virtual Private Database security authentication. (43256)

User uses Virtual Private Database (VPD) security and SQL Optimizer 7.2 does not allow user to set the proper environment before running and, therefore, program errors out. Is there a plan for integrating VPD/environment configuration functions into this tool?

Product(s): SQL-Optimizer-for-Oracle
Created On: 5/30/2008
(0 Ratings)
Last Updated On: 4/8/2014
Is CodeSite utility part of SQL Optimizer for Oracle? (120111)

User has found a utility program called CodeSite inside the SQL Optimizer for Oracle directory. Is this program a part of SQL Optimizer? If so, is this an open source or license required? Would it effect to SQL Optimizer if CodeSite program is uninstalled?<?xml:namespace prefix = o ns = "urn...

Product(s): SQL-Optimizer-for-Oracle
Created On: 2/7/2014
(0 Ratings)
Last Updated On: 2/7/2014
"Error check for updates" when launching and sometimes hangs (100596)

Window "Error check for updates" pops up when SQL Optimizer is launched. Sometimes Optimizer will hang at this point.

Product(s): SQL-Optimizer-for-Oracle
Created On: 11/22/2012
(0 Ratings)
Last Updated On: 10/15/2013
Prompted for bind variable that is not there when referencing an object type (116327)

When running alternatives returned from optimizing SQL, if it contains a reference to an object type, the object type will be confused as a bind variable and SQL Optimizer prompts users to enter a value for that bind variable.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office...

Product(s): SQL-Optimizer-for-Oracle
Created On: 11/14/2013
(0 Ratings)
Last Updated On: 12/6/2013
Will not optimize query with xml (115294)

Query executes correctly and explain plan display correctly in both Toad and SQLPlus but receive syntax error when SQL Optimizer attempts to run explain plan or execute the SQL. "The Parser did not identify the text as a valid SQL statement." "ORA-19224: XPTY0004 - XQuery static type mismatch...

Product(s): SQL-Optimizer-for-Oracle
Created On: 10/16/2013
(0 Ratings)
Last Updated On: 2/5/2014
Error 1603 (Internal error 2738) when installing SQL Optimizer as part of Toad bundle. (66625)

Getting error 1603 when installing SQL Optimizer as part of Toad bundle. The following error is displayed in the msi log: "Error 2738: Could not access VBScript runtime for custom action
MSI (s) (AC:84) [14:37:52:749]: Product: Quest SQL Optimizer for Oracle -- Internal Error 2738"

Product(s): SQL-Optimizer-for-Oracle
Created On: 9/30/2010
(0 Ratings)
Last Updated On: 2/19/2014
SQL Optimizer gives "Invalid authorization key" message. (36981)

When I launch SQL Optimizer from a Quest product, like Toad, or try to registered SQL Optimizer, it gives me one on the following message:

"Invalid authorization key"
"Invalid authorization key (Wrong Edition)"
"Invalid authorization key (Bad License Key)"
"Invalid authorization...

Product(s): SQL-Optimizer-for-Oracle
Created On: 11/27/2007
(0 Ratings)
Last Updated On: 2/11/2014
How to launch SQL Optimizer from within Toad for Oracle? (105609)

How to launch SQL Optimizer from within Toad for Oracle?  How to optimize SQL query statements in Toad for Oracle using SQL Optimizer add-on or component? What are the different ways to launch SQL Optimizer?

Product(s): SQL-Optimizer-for-Oracle
Created On: 4/10/2013
(0 Ratings)
Last Updated On: 12/26/2013
Version Full Support as of Limited Support as of Support Discontinued
8.7.x 9/25/2012
8.8.x 6/5/2013
8.6 4/12/2012 1/1/2014 6/1/2014
8.5 9/20/2011 4/1/2013 10/1/2013
8.0 9/16/2010 10/1/2012 4/1/2013
Earlier product versions not listed are considered discontinued.

The Product Support Lifecycle table above describes the phase during which Dell Software products are eligible for product support and new release downloads.