Class LoadSqlPlanBaselinesFromCursorCacheDetails
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
Inherited Members
Namespace: Oci.DatabasemanagementService.Models
Assembly: OCI.DotNetSDK.Databasemanagement.dll
Syntax
public class LoadSqlPlanBaselinesFromCursorCacheDetails
Properties
Credentials
Declaration
[JsonProperty(PropertyName = "credentials")]
public ManagedDatabaseCredential Credentials { get; set; }
Property Value
Type | Description |
---|---|
ManagedDatabaseCredential |
DatabaseCredential
Declaration
[JsonProperty(PropertyName = "databaseCredential")]
public DatabaseCredentialDetails DatabaseCredential { get; set; }
Property Value
Type | Description |
---|---|
DatabaseCredentialDetails |
FilterName
Declaration
[JsonProperty(PropertyName = "filterName")]
[JsonConverter(typeof(StringEnumConverter))]
public LoadSqlPlanBaselinesFromCursorCacheDetails.FilterNameEnum? FilterName { get; set; }
Property Value
Type | Description |
---|---|
LoadSqlPlanBaselinesFromCursorCacheDetails.FilterNameEnum? | The name of the filter.
|
FilterValue
Declaration
[JsonProperty(PropertyName = "filterValue")]
public string FilterValue { get; set; }
Property Value
Type | Description |
---|---|
string | The filter value. It is upper-cased except when it is enclosed in
double quotes or filter name is |
IsEnabled
Declaration
[JsonProperty(PropertyName = "isEnabled")]
public bool? IsEnabled { get; set; }
Property Value
Type | Description |
---|---|
bool? | Indicates whether the loaded plans are enabled ( |
IsFixed
Declaration
[JsonProperty(PropertyName = "isFixed")]
public bool? IsFixed { get; set; }
Property Value
Type | Description |
---|---|
bool? | Indicates whether the plans are loaded as fixed plans ( |
JobDescription
Declaration
[JsonProperty(PropertyName = "jobDescription")]
public string JobDescription { get; set; }
Property Value
Type | Description |
---|---|
string | The description of the job. |
JobName
Declaration
[Required(ErrorMessage = "JobName is required.")]
[JsonProperty(PropertyName = "jobName")]
public string JobName { get; set; }
Property Value
Type | Description |
---|---|
string | The name of the database job used for loading SQL plan baselines. |
Remarks
Required
PlanHash
Declaration
[JsonProperty(PropertyName = "planHash")]
public decimal? PlanHash { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The plan identifier. By default, all plans present in the cursor cache
for the SQL statement identified by |
SqlHandle
Declaration
[JsonProperty(PropertyName = "sqlHandle")]
public string SqlHandle { get; set; }
Property Value
Type | Description |
---|---|
string | The SQL handle to use in identifying the SQL plan baseline into which the plans are loaded. |
SqlId
Declaration
[JsonProperty(PropertyName = "sqlId")]
public string SqlId { get; set; }
Property Value
Type | Description |
---|---|
string | The SQL statement identifier. Identifies a SQL statement in the cursor cache. |
SqlText
Declaration
[JsonProperty(PropertyName = "sqlText")]
public string SqlText { get; set; }
Property Value
Type | Description |
---|---|
string | 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. |