Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace LoadSqlPlanBaselinesFromAwrDetails

The details required to load plans from Automatic Workload Repository (AWR). It takes either credentials or databaseCredential. It's recommended to provide databaseCredential

Properties

beginSnapshot

beginSnapshot: number

The begin snapshot. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional credentials

Optional databaseCredential

endSnapshot

endSnapshot: number

The end snapshot. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional isEnabled

isEnabled: undefined | false | true

Indicates whether the loaded plans are enabled ({@code true}) or not ({@code false}). By default, they are enabled.

Optional isFixed

isFixed: undefined | false | true

Indicates whether the plans are loaded as fixed plans ({@code true}) or non-fixed plans ({@code false}). By default, they are loaded as non-fixed plans.

Optional jobDescription

jobDescription: undefined | string

The description of the job.

jobName

jobName: string

The name of the database job used for loading SQL plan baselines.

Optional sqlTextFilter

sqlTextFilter: undefined | string

A filter applied to AWR to select only qualifying plans to be loaded. By default all plans in AWR are selected. The filter can take the form of any {@code WHERE} clause predicate that can be specified against the column {@code DBA_HIST_SQLTEXT.SQL_TEXT}. An example is {@code sql_text like 'SELECT %'}.

Functions

getDeserializedJsonObj

getJsonObj