Self-service tools will help you to install, configure and trouble shoot your Dell Software product
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.
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...
Error occurs when you go to the History Tab in Performance Analysis -- user then selects SQL Statements. User then performs a right click on a SQL statement and selects Tune SQL.
The following error message will appear: "Unable to open SQL Tuning, Please verify that it is correctly installed...
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...
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...
How to perform a silent deploy of additional products license key to all users after Toad for Oracle is already installed and already activated?
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"
Below error occurs in Optimizer when optimizing a valid Select statement query:
"The Parser did not identify the text as a valid SQL statement." Query runs fine in Toad and SQLPlus.
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?
When launching SQL Optimizer from Toad or by itself, the Connection Manager window does not display any of the TNS entries in the drop-down menu.
|Quest SQL Optimizer for Oracle 8.8.1 Installer (32-Bit)||8/28/2013|
|Quest SQL Optimizer for Oracle 8.8.1 .MSI Installer (32-Bit)||8/28/2013|
|Quest SQL Optimizer for Oracle 8.8.1 .MSI Installer (64-Bit)||8/28/2013|
|Quest SQL Optimizer for Oracle 8.8.1 Installer (64-Bit)||8/28/2013|
|Version||Full Support as of||Limited Support as of||Support Discontinued|
|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.