Category
Product Version
Topic
Subtopic
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.
Getting Ora-00932 error when optimizing a statement with a "date variable - 1" included in it (4251211)
When using the new 'Optimize Current SQL' feature in Toad for Oracle, if I try to optimize the following statement it works fine... ... However, if I add (- 1) to the end and try to optimize it, I get an 'ORA-00932: inconsistent datatypes: expected DATE got number' error.
Optimize Indexes, The SQL Optimizer runs for hours with no results after running a workload to generate Index scenarios (4265533)
What is the best way use SQL Optimizer after running a workload to generate Index scenarios and to determine the best Index? ... The Optimize Indexes module is designed to provide index recommendations for a group of SQL statements based on their workload.
Quest SQL Optimizer for Oracle license key has expired. (4217819)
The license key for Quest SQL Optimizer for Oracle has expired, how do I obtain a new license key? ... All keys for Quest SQL Optimizer for Oracle Stand Alone will be invalid and no longer supported.
Have SQL Optimizer handle the situation better when user does not have Crate Any Index privilege (4238336)
When I run the index generator in the Optimize SQL tab, if I do not have the Create Any Index privilege granted to me, I will get a message that says no indexes were found that could help and to increase the intelligence level and try again.
Error when checking/unchecking the SQL checkbox: "DataTable internal index is corrupted" (4240732)
Getting the following error when ticking or unticking a selected SQL checkbox in Batch Optimize: ... The following unhandled error has occurred: ... DataTable internal index is corrupted: '5'. ... Product defect
"Failed to update scenario data file" error when optimizing statement (4239255)
Tried several times to optimize a query of mine. ... It would generate about 30+ alternate queries, but would crash while executing one of them. ... The following error shows. ... The following unhandled error has occurred:
Connections from TOAD are not sent to SQL Optimizer (4274114)
Both are newly installed. ... When Optimizer is launched from TOAD 13.1.1, it asks for a password because it have not connections imported or synced. ... You need to install Toad 13.2 and then you can send passwords to SQL Optimizer 9.3.2
Information that fall into the trace stats category is not filled in when using auto optimize option (4334158)
When using auto optimize and checking the "Execution Statistics" tab (see below), I see Trace Stats(not setup) and the data there is not filled in. ... What do I need to enable and how in order to have all this information?
How to install Service Pack 2 (SP1) for LiteSpeed 5.2? (4218406)
Extended stored procedures, exes, or dlls are missing, backups are not compressing, the LiteSpeed checkbox is not illuminated on the GUI screens, generally, LiteSpeed seems not to be installed after upgrading to Service Pack 1.
<p style="MARGIN: 0in 0in 10pt" class="MsoNormal"><span style="LINE-HEIGHT: 115%; FONT-FAMILY: 'V (4278633)
After optimizing the query, clicking on the Report tab gave message: ... If the original and alternatives are not executed, it cannot generate the report. ... There are two ways to execute. ... 1. You can do it one at a time by highlighting the original and alternatives, then clicking on the Execute button.
Says it cannot find a valid statement when using an equation to get date value (4244551)
When using an equation to get a date in a SQL, like the one below, the optimzer returns a message saying, "The Parser did not identify the text as a valid SQL statement". ... FROM DUAL ... WHERE 'N' = CBC_GETSHIFT(SYSDATE -(:P10_HOURSDIFF1 / 24), 'N')
How does it test 'Update' Statements? (4237904)
Does it actually do the update on the database? ... Does it start a transaction then end it? <span>To test Update statements, SQL Optimizer will run the statement and then rollback the transaction so it does not save it.
Getting "Attempted to read or write protected memory. This is often an indication that other memo (4249953)
When optimizing sql at intelligence level 5, I get an "Attempted to read or write protected memory. ... This is often an indication that other memory is corrupt." error. ... WORKAROUND: ... Optimize at an intelligence level lower than 5.
When the SQL Inspector is run, the explain plan it generates combines 2 different schema plans in (4244759)
If multiple schema have exactly the same SQL statements, then the explain plan which is generated by SQL Inspector seems to be wrong. ... When the SQL Inspector is run, the explain plan it generates combines 2 different schema plans into one.
SQL Optimizer for Oracle creates QUEST_SL_TEMP_EXPLAIN1 table with column OBJECT_NAME too small [table script provided]. (4289730)
Oracle now allows longer or bigger size object names. ... <p>STATUS:</p><p>Waiting for fix in a future release of SQL Optimizer for Oracle.</p><p> </p><p>WORKAROUND:</p><p>Use the script below to drop and re-create the table with larger size column.
Batch optimizing XML file returns "Collection was modified; enumeration operation may not execute." (4261151)
When executing a batch optimize on a .XML file: 1. ... 3. After batch optimize is completed, click on 'Job Report' and Toad will generate the following error ... The following unhandled error has occurred
How to add an Account ID to a Support Account? (4284344)
Quest Support Administrators will have to do it for you. ... To arrange this contact them at supportadmin@quest.com
Connection, "Can't initialize OCI. Error -1" on 64-bit operating system with 32-bit client. (4266213)
When trying to connect to a database using Toad for Oracle on a Windows 7 64-bit or Windows Server 2003 2008 64-bit operating system, the following error occurs: ... The Oracle client installed is a 32-bit Oracle client.
How to tune long running SQL? (4332378)
How to tune long running sql s? ... Original sql is long running, since there are many alternate SQLs created, it is going to take a long time to complete executing all alternates. ... What is the best way to find the alternate SQLs without taking significant time.
SGA Inspector Error: "Object is currently in use elsewhere" (4239736)
None ... STATUS ... Waiting for fix in a future release of Quest SQL Optimizer for Oracle.
SQL Termination Criteria does not work in Batch Run (4332116)
In Optimize SQL, when clicking Batch Run to execute all the SQL statements, the process does not terminate even if the execution time exceeded the user defined time limit. ... WORKAROUND: ... None
Error optimizing query using WITH clause: "This type of SQL statement is not supported (4275525)
The following error occurs when optimizing query using WITH clause: ... This query does not have Group By clause. ... This type of SQL statement is not supported. ... WORKAROUND: ... None. ... STATUS:
Error executing query: "ORA-06502: PL/SQL: numeric or value error: character string buffer too sm (4223520)
The following error occurs when executing original or alternate query in Optimizer: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512 ... Large text values containing quotation marks.
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