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
Inherited Members
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 ( |
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
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 |