Class LoadSqlPlanBaselinesFromAwrDetails

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

Inheritance

object

LoadSqlPlanBaselinesFromAwrDetails

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 LoadSqlPlanBaselinesFromAwrDetails

Properties

BeginSnapshot

Declaration

[Required(ErrorMessage = "BeginSnapshot is required.")]
[JsonProperty(PropertyName = "beginSnapshot")]
public int? BeginSnapshot { get; set; }

Property Value

Type	Description
int?	The begin snapshot.

Remarks

Required

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

EndSnapshot

Declaration

[Required(ErrorMessage = "EndSnapshot is required.")]
[JsonProperty(PropertyName = "endSnapshot")]
public int? EndSnapshot { get; set; }

Property Value

Type	Description
int?	The end snapshot.

Remarks

Required

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

SqlTextFilter

Declaration

[JsonProperty(PropertyName = "sqlTextFilter")]
public string SqlTextFilter { get; set; }

Property Value

Type	Description
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 WHERE clause predicate that can be specified against the column DBA_HIST_SQLTEXT.SQL_TEXT. An example is sql_text like 'SELECT %'.