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