The name of the filter.
- SQL_TEXT: Search pattern to apply to SQL text. - PARSING_SCHEMA_NAME: Name of the parsing schema. - MODULE: Name of the module. - ACTION: Name of the action.
The filter value. It is upper-cased except when it is enclosed in double quotes or filter name is {@code SQL_TEXT}.
Indicates whether the loaded plans are enabled ({@code true}) or not ({@code false}). By default, they are enabled.
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.
The description of the job.
The name of the database job used for loading SQL plan baselines.
The plan identifier. By default, all plans present in the cursor cache for the SQL statement identified by {@code sqlId} are captured. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The SQL handle to use in identifying the SQL plan baseline into which the plans are loaded.
The SQL statement identifier. Identifies a SQL statement in the cursor cache.
The SQL text to use in identifying the SQL plan baseline into which the plans are loaded. If the SQL plan baseline does not exist, it is created.
The details of SQL statements and plans to be loaded from cursor cache. You can specify the plans to load using SQL ID, plan identifier, or filterName and filterValue pair. You can also control the SQL plan baseline into which the plans are loaded using either SQL text or SQL handle. It takes either credentials or databaseCredential. It's recommended to provide databaseCredential