Category
产品版本
主题
副主题
语言
Installation Guide (Simplified Chinese) > 系统要求
Oracle v11 客户端 (Net11) ... Oracle 即时客户端 ... 云数据库服务 Oracle 数据库即服务 在 Amazon EC2 上运行的 Oracle 数据库 虚拟化支持 ... 类型
User Guide (Simplified Chinese) > 教程：分析索引影响
在 ... 索引“变更详细信息”页将被您从 ... 修改完索引后，单击 开始收集要评估的 SQL。 请看联机帮助的“收集 SQL 并运行影响分析”了解 ...
User Guide (Simplified Chinese) > SQL 优化工作流程
描述 ... 批优化生成替代项之后，便将自动测试运行替代项，并为您提供适合您 ... 分析影响评估某些变化（例如索引和参数变化）将会对 SQL 语句 ...
User Guide (Simplified Chinese) > 教程：生成索引
SQL Optimizer 分析一条 SQL 语句的语法、数据库表之间的关系及数据的选择性之后，会 ... 要生成一个索引替代项 在主菜单中选择优化 SQL选项卡。
User Guide (Simplified Chinese) > 教程：扫描 SQL
注： 选中包含子目录复选框以扫描子目录。 使用模式扫描 ... 检查 SGA页面 ... 单击 以选择一个之前创建的数据库连接，然后单击 检查 PI 存储 ...
Installation Guide (Simplified Chinese) > 配置
启动SQL Optimizer 复查选项设置 复查数据文件位置 疑难解答
User Guide (Simplified Chinese) > 教程：部署大纲
大纲名称 输入存储的大纲名称 ... 默认类别名称是 SQL_OPTIMIZIER。 ... 单击 ... 注： 您可以使用管理计划中的大纲管理功能启用和禁用类别，或将 ...
User Guide (Simplified Chinese) > 教程：大纲管理
大纲管理显示了使用 优化 SQL中 SQL 重写模式部署的存储大纲。 ... 在主窗口中选择“管理计划”选项卡。 ... 选择一个要使用的连接。
User Guide (Simplified Chinese) > 数据库权限
常规 ... SYS.DBMS_SPM ... SYS.V_$SQLTEXT_WITH_ NEWLINES 优化 SQL和 批优化 执行方法选项： 根据服务器端设置运行 要求访问 SYS.DBMS_SQL 程序包。
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.
新产品关联性