Get-OCIDatabasemanagementSqlTuningAdvisorTaskFindingsList

SYNOPSIS

Invokes SqlTuning service - ListSqlTuningAdvisorTaskFindings operation.

SYNTAX

Limit

Get-OCIDatabasemanagementSqlTuningAdvisorTaskFindingsList -ManagedDatabaseId <String> -SqlTuningAdvisorTaskId <Int64> [-BeginExecId <Int64>] [-EndExecId <Int64>] [-SearchPeriod <SearchPeriodEnum>] [-FindingFilter <FindingFilterEnum>] [-StatsHashFilter <String>] [-IndexHashFilter <String>] [-SortBy <SortByEnum>] [-SortOrder <SortOrders>] [-Page <String>] [-Limit <Int32>] [-OpcRequestId <String>] [-OpcNamedCredentialId <String>] [-ConfigFile <String>] [-Endpoint <String>] [-NoRetry] [-Profile <String>] [-Region <String>] [-FullResponse] [-TimeOutInMillis <Int32>] [-AuthType <AuthenticationType>] [<CommonParameters>]

AllPages

Get-OCIDatabasemanagementSqlTuningAdvisorTaskFindingsList -ManagedDatabaseId <String> -SqlTuningAdvisorTaskId <Int64> [-BeginExecId <Int64>] [-EndExecId <Int64>] [-SearchPeriod <SearchPeriodEnum>] [-FindingFilter <FindingFilterEnum>] [-StatsHashFilter <String>] [-IndexHashFilter <String>] [-SortBy <SortByEnum>] [-SortOrder <SortOrders>] [-Page <String>] [-OpcRequestId <String>] [-OpcNamedCredentialId <String>] [-All] [-ConfigFile <String>] [-Endpoint <String>] [-NoRetry] [-Profile <String>] [-Region <String>] [-FullResponse] [-TimeOutInMillis <Int32>] [-AuthType <AuthenticationType>] [<CommonParameters>]

DESCRIPTION

Gets an array of the details of the findings that match specific filters.

PARAMETERS

-All

Fetches all pages of results.

Type: SwitchParameter
Parameter Sets: AllPages
Aliases: None

Required: True
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-AuthType

Type of authentication to use for making API requests. Default is Key based Authentication.

Type: AuthenticationType
Parameter Sets: (All)
Aliases: None
Accepted values: ApiKey, InstancePrincipal, SessionToken

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-BeginExecId

The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task.

Type: Int64
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-ConfigFile

The path to the config file.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-EndExecId

The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task.

Type: Int64
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Endpoint

The value to use as the service endpoint, including any required API version path.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-FindingFilter

The filter used to display specific findings in the report.

Type: FindingFilterEnum
Parameter Sets: (All)
Aliases: None
Accepted values: None, Findings, Nofindings, Errors, Profiles, Indices, Stats, Restructure, Alternative, AutoProfiles, OtherProfiles

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-FullResponse

Output the complete response returned by the API Operation. Using this switch will make this Cmdlet output an object containing response headers in-addition to an optional response body.

Type: SwitchParameter
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-IndexHashFilter

The hash value of the index table name.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Limit

The maximum number of records returned in the paginated response.

Type: Int32
Parameter Sets: Limit
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-ManagedDatabaseId

The OCID of the Managed Database.

Type: String
Parameter Sets: (All)
Aliases: None

Required: True
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-NoRetry

Disable retry logic for calls to services.

Type: SwitchParameter
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-OpcNamedCredentialId

The OCID of the Named Credential.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-OpcRequestId

The client request ID for tracing.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Page

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.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Profile

The profile in the config file to load.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Region

Region-id of the region to make calls against. eg) us-phoenix-1, ap-singapore-1

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-SearchPeriod

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.

Type: SearchPeriodEnum
Parameter Sets: (All)
Aliases: None
Accepted values: Last24Hr, Last7Day, Last31Day, SinceLast, All

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-SortBy

The possible sortBy values of an object's recommendations.

Type: SortByEnum
Parameter Sets: (All)
Aliases: None
Accepted values: DbtimeBenefit, ParsingSchema, SqlId, Stats, Profiles, SqlBenefit, Date, Indices, Restructure, Alternative, Misc, Error, Timeouts

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-SortOrder

The option to sort information in ascending ('ASC') or descending ('DESC') order. Descending order is the default order.

Type: SortOrders
Parameter Sets: (All)
Aliases: None
Accepted values: Asc, Desc

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-SqlTuningAdvisorTaskId

The SQL tuning task identifier. This is not the OCID.

Type: Int64
Parameter Sets: (All)
Aliases: None

Required: True
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-StatsHashFilter

The hash value of the object for the statistic finding search.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-TimeOutInMillis

Max wait time in milliseconds for the API request to complete. Default is 100000 millis(100 secs).

Type: Int32
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

OUTPUTS

• Oci.DatabasemanagementService.Models.SqlTuningAdvisorTaskFindingCollection
• Oci.DatabasemanagementService.Responses.ListSqlTuningAdvisorTaskFindingsResponse

RELATED LINKS

• APIReference
• DotnetSDKAPI
• OCIModulesDocs
• OCIServiceConcepts
• Examples