Class ListSqlTuningAdvisorTasksRequest

Inheritance

object

ListSqlTuningAdvisorTasksRequest

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 ListSqlTuningAdvisorTasksRequest : IOciRequest

Examples

Click here to see an example of how to use ListSqlTuningAdvisorTasks request.

Properties

Limit

Declaration

[HttpConverter(TargetEnum.Query, "limit")]
public int? Limit { get; set; }

Property Value

Type	Description
int?	The maximum number of records returned in the paginated response.

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

Name

Declaration

[HttpConverter(TargetEnum.Query, "name")]
public string Name { get; set; }

Property Value

Type	Description
string	The optional query parameter to filter the SQL Tuning Advisor task list by name.

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.

Page

Declaration

[HttpConverter(TargetEnum.Query, "page")]
public string Page { get; set; }

Property Value

Type	Description
string	The page token representing the page from where the next set of paginated results are retrieved. This is usually retrieved from a previous list call.

SortBy

Declaration

[HttpConverter(TargetEnum.Query, "sortBy")]
public ListSqlTuningAdvisorTasksRequest.SortByEnum? SortBy { get; set; }

Property Value

Type	Description
ListSqlTuningAdvisorTasksRequest.SortByEnum?	The option to sort the SQL Tuning Advisor task summary data.

SortOrder

Declaration

[HttpConverter(TargetEnum.Query, "sortOrder")]
public SortOrders? SortOrder { get; set; }

Property Value

Type	Description
SortOrders?	The option to sort information in ascending (\u2018ASC\u2019) or descending (\u2018DESC\u2019) order. Descending order is the default order.

Status

Declaration

[HttpConverter(TargetEnum.Query, "status")]
public ListSqlTuningAdvisorTasksRequest.StatusEnum? Status { get; set; }

Property Value

Type	Description
ListSqlTuningAdvisorTasksRequest.StatusEnum?	The optional query parameter to filter the SQL Tuning Advisor task list by status.

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.

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.

Implements

IOciRequest