The time benefit (in seconds) for the highest-rated finding for this object. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Indicates whether an alternative execution plan was reported for this SQL statement.
Indicates whether there is an error in this SQL statement.
Indicates whether an index recommendation was reported for this SQL statement.
Indicates whether a miscellaneous finding was reported for this SQL statement.
Indicates whether a restructure SQL recommendation was reported for this SQL statement.
Indicates whether a SQL Profile recommendation has been implemented for this SQL statement.
Indicates whether a SQL Profile recommendation was reported for this SQL statement.
Indicates whether a statistics recommendation was reported for this SQL statement.
Indicates whether the task timed out.
The parsing schema of the object.
The per-execution percentage benefit. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The unique key of this SQL statement.
The text of the SQL statement.
The unique identifier of the SQL Tuning Advisor task. This is not the OCID. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The execution id of the analyzed SQL object. This is not the OCID. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The key of the object to which these recommendations apply. This is not the OCID. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
A summary of the findings of the objects in a tuning task that match a given filter. This includes the kind of findings that were reported, whether the benefits were analyzed, and the number of benefits obtained.