Category
Product Version
Topic
Subtopic
How to silently deploy additional products license key after Toad for Oracle is already installed? (4285484)
How to perform a silent deploy of additional products license key to all users after Toad for Oracle is already installed and already activated? ... To silently apply a license key for additional products to all users follow the steps below:
Cannot print the explain plans (4333981)
SQL Optimizer generates the Explain Plans properly but it is not possible to print them.: the file generated only contains a big red cross as below: ... WORKAROUND ... None
Error: 'ORA-01031: insufficient privileges' appears when trying to connect SQL Optimizer to an Oracle Autonomous Database (4375040)
Oracle Autonomous Database is not supported in SQL Optimizer at this time.
Does Optimizer use Oracle system stat tables (AWR tables and views)? (4364436)
And if so do we need the Oracle license for this? ... 1. SQL Optimizer doesn't create stat table in your database. ... It will use Oracle's system stat tables (specifically, they are the AWR tables/views) in certain modules that need access to these statistics and here is the list of modules/features in the product that needs access:
Error Optimizing a valid query: "The Parser did not identify the text as a valid SQL statement." (4221548)
Below error occurs in SQL Optimizer for Oracle when optimizing a valid Select statement query: "The Parser did not identify the text as a valid SQL statement." ... Query statement has an unsupported syntax in the SQL Optimizer engine.
Is there an msi version of the installation? (4234945)
On the Product Download page, the installation file is an exe. ... But some companies do not allow downloads for exe files. ... Is there an msi version that can be downloaded instead? ... For some products an msi version is available for download.
Inspect SGA Job creates a new session instead of connecting to existing Oracle DB session (4371933)
SQL Optimizer creates a new Oracle DB session every time Inspect SGA job is run. ... The module was expected to contain an assembly manifest." SupportBundle Quest SQL Optimizer for Oracle TOAD</em><br><em>Call Stack "Server stack trace: at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName
Get the error 'Invalid Home Name: (Oracle Root)' (4371402)
Trying to set up the database connection using the connection manager on SQL Optimizer for Oracle, got the Invalid Home Name: (Oracle Root) error. ... This error appears when the Oracle client installed is not detected.
Cannot format or optimize SQL statements using IGNORE NULLS clause. (4223495)
Toad 9.01 and below cannot format or tune IGNORE NULLS statement which is part of the Analytic function FIRST_VALUE and LAST_VALUE. ... Steps to replicate: Apply the FIRST_VALUE statement with IGNORE NULLS on any sample table you might have.
Getting error "ORA-01423" when trying to optimize any query (4333900)
Getting error "ORA-01423" when trying to optimize any query Privileges missing Please open SQL Optimizer help and go to Contents | Welcome to SQL Optimizer | Database Privileges<br>There are listed all the privileges required.
How to download a commercial software installer? Need installer by FTP or mail. (4290597)
In some situations, it errors out during the download and won't let the download to complete even though a current support maintenance contract exists. ... Steps to download a commercial product:
Error during installation: Error 1904. Module C:\Program Files...\<file_name>.DLL failed to register. (4224221)
Error is at the end of the installation wizard: ... Error 1904. ... HRESULT -2147221164. ... Contact your support personnel. ... NOTE: The specific .DLL filename may vary. ... Manually register DLL file(s) with Regsvr32 executable:
License key does not work in SQL Optimizer for Oracle. (4277429)
<p>Running SQL Optimizer for Oracle and the license key does not work or is not accepted.</p> <p>If the license key is for QCO SQL Tuning (Quest Central), this uses a different license key than SQL Optimizer. If you are licensed for QCO SQL Tuning, you should download Quest Central for Databases and use the SQL Tuning module bundled with Quest Central.</p>
Error: "Object reference not set to an instance of an object" when connecting to the database. (4289867)
Connect to the database and the error below is immediately received. ... "Object reference not set to an instance of an object" ... Corrupt SQL Optimizer user files. ... Perform the steps below to clear the temp, cache, and corrupted files.
TEMP tablespace used by the different plans, Is this possible? (4269624)
When generating the alternate sql options for a query, one can sort/ see them on the basis of Cost, CPU used, time etc.<br>Is there a way, to see the TEMP tablespace used by the different plans? <div>There is no direct statistics showing the usage of temp tablespace in the Alternatives grid.
The installation of component Microsoft .Net Framework v2.0 has failed (4259698)
Received the following error during Quest SQL Optimizer for Oracle installation: The installation of component Microsoft .Net Framework v2.0 has failed. ... 4121 ... The installation will now abort.
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:
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