カテゴリ
製品バージョン
トピック
サブトピック
言語
[SQL Optimizer for Oracle] Support Bundle の収集方法 (4326181)
本ナレッジでは、SQL Optimizer for Oracle の Support Bundle の収集方法を説明します。 < ... <p>1. SQL Optimizer for Oracle の以下画面をクリックします。</p>
Optimizer cannot generate indexes “No Index sets found” (4378887)
User has updated Optimizer from version 9.3 to 10.0 and can no longer generate indexes for SQL using the “Index Generation” option. ... The issue is persistent with any SQL statement. ... Optimizer 9.3 can generate indexes for the user.
SQL Optimizer is not recognizing a bind variable when using a flashback query (4378847)
SQL Optimizer is not recognizing a bind variable when using a flashback query . ... To reproduce the issue please follow the steps below: ... Write down the result and wait for some minutes (for example 13/03/2025 11:20:12.565000 +01:00).
How do you format a statement inside SQL Optimizer for Oracle? (4378758)
How do you format a statement inside SQL Optimizer for Oracle? ... If you have an unformatted sql statement in SQL Optimizer, you can right-click in the text area of the SQL statement, and choose the 'Format SQL' option, which will format the statement within the application.
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')
製品の新しい関連付け
- セルフ・サービス・ツール
- ナレッジベース
- 通知および警告
- 製品別サポート
- ソフトウェアのダウンロード
- 技術文書
- ユーザーフォーラム
- ビデオチュートリアル
- RSSフィード
- お問い合わせ
- Technical Support
- すべて表示