Show / Hide Table of Contents

Class ListSqlTuningAdvisorTaskRecommendationsRequest

Inheritance
object
ListSqlTuningAdvisorTaskRecommendationsRequest
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 ListSqlTuningAdvisorTaskRecommendationsRequest : IOciRequest
Examples

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

Properties

ExecutionId

Declaration
[Required(ErrorMessage = "ExecutionId is required.")]
[HttpConverter(TargetEnum.Query, "executionId")]
public long? ExecutionId { get; set; }
Property Value
Type Description
long?

The execution ID for an execution of a SQL tuning task. This is not the OCID.

Remarks

Required

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

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 ListSqlTuningAdvisorTaskRecommendationsRequest.SortByEnum? SortBy { get; set; }
Property Value
Type Description
ListSqlTuningAdvisorTaskRecommendationsRequest.SortByEnum?

The possible sortBy values of an object's recommendations.

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.

SqlObjectId

Declaration
[Required(ErrorMessage = "SqlObjectId is required.")]
[HttpConverter(TargetEnum.Query, "sqlObjectId")]
public long? SqlObjectId { get; set; }
Property Value
Type Description
long?

The SQL object ID for the SQL tuning task. This is not the OCID.

Remarks

Required

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

Implements

IOciRequest
In this article
Back to top