Class GetSqlTuningAdvisorTaskSummaryReportRequest

Inheritance

object

GetSqlTuningAdvisorTaskSummaryReportRequest

Implements

IOciRequest

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

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.

Implements

IOciRequest