Category
Product Version
Topic
Subtopic
"Cannot find oci.dll: in <some_client>" error when trying to connect. (4316289)
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 the main error is the 3rd error below:
No alternatives generated for a script with a bind variable (4239689)
When trying to optimize a script with bind variable, if there are no bind variable details to enter, you have to cancel the window, but this in turn doesn't generate any alternative scripts. ... The current version of the product does not support Object Type in Table Collection.
Plan Control connection gave error: "The Plan Control session can only be used in Oracle 11G o (4283967)
The Plan Control Session can only be used in Oracle 11G or later. ... Connecting to any earlier versions would not be allowed." ... Feature specific to Oracle 11G. ... You can only use Plan Control mode with an Oracle 11g connection.
Quest.Tuning.Oracle.Main has stopped working error when opening Quest SQL Optimizer for Oracle (4260590)
I recently installed Quest SQL Optimizer 8 for Oracle and when I start the program I receive an error immediately: ... Windows is checking for a solution to the problem.....
Optimizing SQL is causing the date to be reformatted with spaces. (4271135)
When I tried to optimize a code with a date in single quotes, SQL Optimizer always reformats the date with spaces in between after generating alternatives and the alternatives will not execute. ... Not a SQL Optimizer issue.
Why is there a performance gain by using NVL('XYZ', UID)? (4271029)
When I run my code through SQL Optimizer and it makes the following suggestion regarding my code. ... This seems to greatly enhance performance. ... The explain plains are the same, except for cost.
Request to change the SQL Optimizer Desktop Shortcuts to be saved in [C:\Documents and Setting (4302331)
The reason is when we install SQL Optimizer for our users, and those users login to Windows, they do not see the SQL Optimizer Shortcuts. ... The above problem does not happen in Toad for Oracle because the Toad shortcuts are located in [C:\Documents and Settings\All Users\].
Every time I start SQL Optimizer for Oracle 8.0.0, I get the error: Method not found: 'Void AxQE (4296092)
I installed Toad for Oracle 10.6.1 and every time I start or launch Quest SQL Optimizer for Oracle 8.0.0, I get the error below. ... RESOLUTION 1: ... Perform a complete uninstall and reinstall of both Toad for Oracle and SQL Optimizer (NOTE: if you prefer, you can try re-installing SQL Optimizer by itself first before re-installing everything).
Error 1603 (Internal error 2738) when installing SQL Optimizer (4310877)
Getting error 1603 when installing SQL Optimizer as part of Toad bundle. ... The following error is displayed in the msi log: ... Microsoft has created a Fix-It this issue for 64bit Windows: ... What this Fix it does is to automatically remove any incorrect or corrupt registry entries that interfere with VB support in windows and then re-registers the DLL ensuring that the correct registry setting are there.
I get error ORA-28113: policy predicate has error when I tune my SQL statements. (4296031)
<p>I get error ORA-28113: policy predicate has error when I perform SQL Tuning on my SQL script by going to or using Optimize Current SQL from inside Toad or going directly in SQL Optimizer. ... I have privileges or grants on the Views only of the tables.</p> <p>Grant the privileges to access the underlying objects of the View.
Error in Optimizer: "Could not load file or assembly file:...XpertTrace.dll or one of its depe (4222487)
The following error occurs with any SQL user tries to optimize in Optimizer. ... The module was expected to contain an assembly manifest." ... SupportBundle Quest SQL Optimizer for Oracle L1126853 5048 4352 06/28/2010 "11:18:57.609 AM" Call Stack "0: at Quest.Tuning.Common.DebugLog.TLogEngine.SendException(Exception e) 1: at Quest.Tuning.Common.DebugLog.TLogMessage.SendException(LogCategory aCategory, Exception aEx) 2: at Quest.Tuning.Common.TSupport.GetAssemblyInfo(String aAsse.....
<span id="title">SQL Optimizer prompting for bind variable on table alias of DBLink</span>.</p (4285198)
I created a DBLink to a SQL Server database and send a query to SQL Optimizer with a table alias pointing to the table reference by the DBLink. ... SELECT * FROM accountstemp@MYSQLSERVERDBLINK.US.ORACLE.COM TT WHERE tt.CreateUserID = 1154;
Report graphs not rendered correctly in SQL Optimizer 8 (4238794)
In SQL Optimizer 8, the graphs in the Reports are not rendered correctly in relation for the data. ... For example, if the original statement is faster than the alternative in a discipline, the graph bar is not rendered in the report.
Which versions of Toad are still supported? (4290965)
Which versions of Toad are still supported? ... How do I find out the end of life cycle for particular versions of Toad? ... In general Support for versions of Toad ranges from the current vesion to about 3 versions back.
Common Oracle connection issues in Toad for Oracle 10.x & above. Frequently asked questions. (4261793)
How to troubleshoot connection errors when logging-in to a supported Oracle database using either a 32-bit or 64-bit Oracle Client. ... OCI.dll, The specified module could not be found ... Any version prior to 11.6 is a 32-bit version.
Can a primary account holder restrict the download of Quest products from Support Link to othe (4238357)
Any account that is up on maintenance will have the full benefit of Support Link, including the ability to download a Quest product.</p>
Blank error prompt on connection. "Can't Initialize OCI. Error -1" when trying to connect. (4234132)
When trying to connect, either a blank error prompt is given, or the message "Can't Initialize OCI. ... Connection in other Quest products like Toad for Oracle or Spotlight don't have any issues.
Can an explain plan table be specified for use with ‘Auto Optimize SQL’? "ORA 00905: missing keyword" given when using Auto Optimizer. (4232532)
How do you specify the explain plan table when using the embedded ‘Auto Optimize SQL’ feature in Toad's Editor? ... The SQL statement being optimized is valid and can run. ... Explain plan can be run on this statement also.
Not able to filter information when creating report in Inspect SGA (4249146)
I would like to be able to filter the information that shows up on reports created from an Inspect SGA run. ... I want to capture all the information during the inspection, but may want a report with only a portion of the total results.
A newly installed application exists with error whenever it is closed. (4327788)
A newly installed application exists with error whenever it is closed. ... Uninstall SQL Optmizer for Oracle, and delete the Optimizer data folder if it still exists after uninstall, e.g. ... C:\Documents and Settings\[login user]\Application Data\Quest Software\Quest SQL Optimizer for Oracle.
Not able to run multiple inspect jobs at the same time (4242153)
I would like to be able to use the Inspect SGA feature on the same job that is running on multiple databases at the same time. ... If I have one instance of Optimizer open, I can only monitor one database.
How do you define a specific method of optimization without using all hints in Oracle? (4238444)
How do you define a specific method of optimization without using all hints in Oracle, in order to generate the alternative statements? <p>In the Optimizer Intelligence Level settings, go to the 'Optimizer | Intelligence' menu, and choose the 'Custom Settings' tick box.<br>This will enable the ability to choose specific hints in the 'Optimizer | Hints' menu, and also other options which are otherwise greyed out when the predefined settings are enabled.</p>
How to Uninstall SQL Optimizer for Oracle (4253664)
Uninstall SQL Optimizer using your Windows add/remove programs feature. ... For example, in Windows 7, select Control Panel | Programs | Programs and Features | Uninstall a program. ... Select SQL Optimizer for Oracle (the version or edition that you want to uninstall).
How to add another product to Supportlink profile (4297825)
How do I add another registered product to my Supportlink Profile? ... 1) After logging into Supportlink, click Site Profile on the right hand side bottom portion of the window. ... 2) Select the product you want to add in the Selected Product dropdown field.
Batch Optimize check connection gave "Datatype is not supported" in the message field. (4271017)
"Datatype is not supported" in the message field. ... The could be cause by unsupported Oracle client (e.g. Oracle 7.3.4). ... Please consult the Release Notes of you version of SQL Optimizer to make sure you are using supported Oracle client and server.
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All