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

Inheritance

object

LoadSqlPlanBaselinesFromCursorCacheDetails

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

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. 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.

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 SQL_TEXT.

IsEnabled

Declaration

[JsonProperty(PropertyName = "isEnabled")]
public bool? IsEnabled { get; set; }

Property Value

Type	Description
bool?	Indicates whether the loaded plans are enabled (true) or not (false). By default, they 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 (true) or non-fixed plans (false). By default, they are loaded as non-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 sqlId are captured.

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.