Class ListSqlTuningAdvisorTaskRecommendationsRequest
Implements
Inherited Members
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