Prior to downloading this Software, you must review the Software Transaction Agreement located here and confirm, by clicking the I agree check box below, that your organization accepts and is bound by the terms and conditions of the Software Transaction Agreement for this Software.
If you purchased the licenses for this Software by executing an order form with Quest or if you have an agreement with Quest that states that all purchases are governed by such agreement, then the terms and conditions of that agreement supersedes and takes precedence over the Software Transaction Agreement.
SQL Optimizer for Oracle maximizes SQL performance by automating the manual, time-intensive and uncertain process of ensuring that SQL statements are performing as fast as possible.
SQL Optimizer for Oracle maximizes SQL performance by automating the manual, time-intensive and uncertain process of ensuring that SQL statements are performing as fast as possible.
QUEST_SL_TEMP_EXPLAIN1 table is created by the tool, with column OBJECT_NAME varchar(30), the size is too small. Oracle now allows longer or bigger size object names.
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".SELECT * FROM DUAL WHERE 'N' = CBC_GETSHIFT(SYSDATE -(:P10_HOURSDIFF1 / 24), 'N')
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?