Class ListSqlTuningAdvisorTaskFindingsRequest

Inheritance

object

ListSqlTuningAdvisorTaskFindingsRequest

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

Examples

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

Properties

BeginExecId

Declaration

[HttpConverter(TargetEnum.Query, "beginExecId")]
public long? BeginExecId { 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.

EndExecId

Declaration

[HttpConverter(TargetEnum.Query, "endExecId")]
public long? EndExecId { 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.

FindingFilter

Declaration

[HttpConverter(TargetEnum.Query, "findingFilter")]
public ListSqlTuningAdvisorTaskFindingsRequest.FindingFilterEnum? FindingFilter { get; set; }

Property Value

Type	Description
ListSqlTuningAdvisorTaskFindingsRequest.FindingFilterEnum?	The filter used to display specific findings in the report.

IndexHashFilter

Declaration

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

Property Value

Type	Description
string	The hash value of the index table name.

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.

SearchPeriod

Declaration

[HttpConverter(TargetEnum.Query, "searchPeriod")]
public ListSqlTuningAdvisorTaskFindingsRequest.SearchPeriodEnum? SearchPeriod { get; set; }

Property Value

Type	Description
ListSqlTuningAdvisorTaskFindingsRequest.SearchPeriodEnum?	The search period during which the API will search for begin and end exec id, if not supplied. Unused if beginExecId and endExecId optional query params are both supplied.

SortBy

Declaration

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

Property Value

Type	Description
ListSqlTuningAdvisorTaskFindingsRequest.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.

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

StatsHashFilter

Declaration

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

Property Value

Type	Description
string	The hash value of the object for the statistic finding search.

Implements

IOciRequest