Category
产品版本
主题
副主题
语言
Error "The parser did not identify the text as a valid SQL statement" along with ORA-00942 (4305861)
The following error occurs when sending a query for optimization from Spotlight on Oracle: ... "The parser did not identify the text as a valid SQL statement" ... and then "ORA-00942: table or view does not exist" at the bottom.
How to upload a file into the Service Request (4326641)
It can be uploaded via email if the attached file is a small one,</p><p>2. ... If the file is larger than 10 Mb. it could best to upload it directly into the case, by following these steps : </p><p></p><p> i. Go to : https://support.quest.com/</p><p> ii.
Where can you find VPAT, Section 508 and Accessibility information for all products? (4241784)
Where can you find VPAT, Section 508 and Accessibility information for all products? ... Please navigate to: https://www.quest.com/legal/section-508.aspx<br>Information for all products can be found in the links on the above page.
How long should I wait for the Index Recommendation to complete? (4270609)
Using the Index Recommendation is taking a long time to complete. ... How does one know if it still functioning properly or if the process is hanging? ... With respect to how long to wait for index recommendation to complete, use SQL Tracker to tell if SQL Optimizer is doing anything.
Getting "Format '%s' invalid or incompatible with argument" error (4246301)
When optimizing a statement that has the following clause in it, I get an error that says, "Format '%s' invalid or incompatible with argument". ... substr(upper(translate(i2.invoice_num,'a!@#/-_$%^&*.','a')), 4),'NomatchKluDge1')
How to alter session parameter "_unnest_subquery" for tuning session? (4225707)
How do you alter a session parameter for a tuning session? ... I found the "Alter Session Parameters" option from the right-click menu in the SQL pane, but "_unnest_subquery" is not listed. ... WORKAROUND:
Differences in Explain Plan between Optimizer and other Quest tools such as Toad for Oracle an (4223786)
Also the background queries show "ORA-12571: TNS:packet writer failure." error.</p> <p>Use an Oracle client that is the same or higher version as the database used. ... Optimizer's Connection window allows to select a different Oracle Home for the connection.
Error : "ORA-06502: PL/SQL: numeric or value error character string buffer too small" when usi (4326805)
During 'Auto Optimize' a sql, SQL Optimizer prompts for real value for some bind variables. ... With three Chinese characters as the real value and click the 'Auto Optimize' button, the Alternatives window shows the error message: ' ORA-06502: PL/SQL: numeric or value error: character string buffer too small '.
"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.
新产品关联性