Class GetSqlTuningAdvisorTaskSummaryReportRequest
Implements
Inherited Members
Namespace: Oci.DatabasemanagementService.Requests
Assembly: OCI.DotNetSDK.Databasemanagement.dll
Syntax
public class GetSqlTuningAdvisorTaskSummaryReportRequest : IOciRequest
Examples
Click here to see an example of how to use GetSqlTuningAdvisorTaskSummaryReport request.
Properties
BeginExecIdGreaterThanOrEqualTo
Declaration
[HttpConverter(TargetEnum.Query, "beginExecIdGreaterThanOrEqualTo")]
public long? BeginExecIdGreaterThanOrEqualTo { get; set; }
Property Value
Type | Description |
---|---|
long? | The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks. |
EndExecIdLessThanOrEqualTo
Declaration
[HttpConverter(TargetEnum.Query, "endExecIdLessThanOrEqualTo")]
public long? EndExecIdLessThanOrEqualTo { get; set; }
Property Value
Type | Description |
---|---|
long? | The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks. |
ManagedDatabaseId
Declaration
[Required(ErrorMessage = "ManagedDatabaseId is required.")]
[HttpConverter(TargetEnum.Path, "managedDatabaseId")]
public string ManagedDatabaseId { get; set; }
Property Value
Type | Description |
---|---|
string | The OCID of the Managed Database. |
Remarks
Required
OpcNamedCredentialId
Declaration
[HttpConverter(TargetEnum.Header, "opc-named-credential-id")]
public string OpcNamedCredentialId { get; set; }
Property Value
Type | Description |
---|---|
string | The OCID of the Named Credential. |
OpcRequestId
Declaration
[HttpConverter(TargetEnum.Header, "opc-request-id")]
public string OpcRequestId { get; set; }
Property Value
Type | Description |
---|---|
string | The client request ID for tracing. |
SearchPeriod
Declaration
[HttpConverter(TargetEnum.Query, "searchPeriod")]
public GetSqlTuningAdvisorTaskSummaryReportRequest.SearchPeriodEnum? SearchPeriod { get; set; }
Property Value
Type | Description |
---|---|
GetSqlTuningAdvisorTaskSummaryReportRequest.SearchPeriodEnum? | How far back the API will search for begin and end exec id. Unused if neither exec ids nor time filter query params are supplied. This is applicable only for Auto SQL Tuning tasks. |
SqlTuningAdvisorTaskId
Declaration
[Required(ErrorMessage = "SqlTuningAdvisorTaskId is required.")]
[HttpConverter(TargetEnum.Path, "sqlTuningAdvisorTaskId")]
public long? SqlTuningAdvisorTaskId { get; set; }
Property Value
Type | Description |
---|---|
long? | The SQL tuning task identifier. This is not the OCID. |
Remarks
Required
TimeGreaterThanOrEqualTo
Declaration
[HttpConverter(TargetEnum.Query, "timeGreaterThanOrEqualTo")]
public DateTime? TimeGreaterThanOrEqualTo { get; set; }
Property Value
Type | Description |
---|---|
DateTime? | The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks. |
TimeLessThanOrEqualTo
Declaration
[HttpConverter(TargetEnum.Query, "timeLessThanOrEqualTo")]
public DateTime? TimeLessThanOrEqualTo { get; set; }
Property Value
Type | Description |
---|---|
DateTime? | The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks. |