Category
제품 버전
항목
하위 항목
언어
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.
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.
신제품 조합