Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace SqlTuningSet

Details of the Sql tuning set.

Properties

Functions

Properties

Optional allSqlStatementsFetched

allSqlStatementsFetched: undefined | string

In OCI database management, there is a limit to fetch only 2000 rows. This flag indicates whether all Sql statements of this Sql tuning set matching the filter criteria are fetched or not. Possible values are 'Yes' or 'No'

  • Yes - All Sql statements matching the filter criteria are fetched.
  • No - There are more Sql statements matching the fitler criteria.
      User should fine tune the filter criteria to narrow down the result set.

Optional description

description: undefined | string

The description of the Sql tuning set.

Optional errorMessage

errorMessage: undefined | string

Latest execution error of the plsql that was submitted as a scheduler job.

Optional id

id: undefined | number

The unique Sql tuning set identifier. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

name

name: string

The name of the Sql tuning set.

owner

owner: string

The owner of the Sql tuning set.

Optional scheduledJobName

scheduledJobName: undefined | string

Name of the Sql tuning set scheduler job.

Optional sqlList

sqlList: Array<SqlInSqlTuningSet>

A list of the Sqls associated with the Sql tuning set.

Optional statementCount

statementCount: undefined | number

Number of statements in the Sql tuning set Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional status

status: model.SqlTuningSetStatusTypes

Current status of the Sql tuning set.

Optional timeCreated

timeCreated: Date

The created time of the Sql tuning set.

Optional timeLastModified

timeLastModified: Date

Last modified time of the Sql tuning set.

Functions

getDeserializedJsonObj

getJsonObj