Get-OCIDatabasemanagementSqlPlanBaselinesList

SYNOPSIS

Invokes DbManagement service - ListSqlPlanBaselines operation.

SYNTAX

Limit

Get-OCIDatabasemanagementSqlPlanBaselinesList -ManagedDatabaseId <String> [-PlanName <String>] [-SqlHandle <String>] [-SqlText <String>] [-IsEnabled <Boolean>] [-IsAccepted <Boolean>] [-IsReproduced <Boolean>] [-IsFixed <Boolean>] [-IsAdaptive <Boolean>] [-Origin <SqlPlanBaselineOrigin>] [-Page <String>] [-Limit <Int32>] [-SortBy <SortByEnum>] [-SortOrder <SortOrders>] [-IsAutoPurged <Boolean>] [-TimeLastExecutedGreaterThan <DateTime>] [-TimeLastExecutedLessThan <DateTime>] [-IsNeverExecuted <Boolean>] [-OpcRequestId <String>] [-OpcNamedCredentialId <String>] [-ConfigFile <String>] [-Endpoint <String>] [-NoRetry] [-Profile <String>] [-Region <String>] [-FullResponse] [-TimeOutInMillis <Int32>] [-AuthType <AuthenticationType>] [<CommonParameters>]

AllPages

Get-OCIDatabasemanagementSqlPlanBaselinesList -ManagedDatabaseId <String> [-PlanName <String>] [-SqlHandle <String>] [-SqlText <String>] [-IsEnabled <Boolean>] [-IsAccepted <Boolean>] [-IsReproduced <Boolean>] [-IsFixed <Boolean>] [-IsAdaptive <Boolean>] [-Origin <SqlPlanBaselineOrigin>] [-Page <String>] [-SortBy <SortByEnum>] [-SortOrder <SortOrders>] [-IsAutoPurged <Boolean>] [-TimeLastExecutedGreaterThan <DateTime>] [-TimeLastExecutedLessThan <DateTime>] [-IsNeverExecuted <Boolean>] [-OpcRequestId <String>] [-OpcNamedCredentialId <String>] [-All] [-ConfigFile <String>] [-Endpoint <String>] [-NoRetry] [-Profile <String>] [-Region <String>] [-FullResponse] [-TimeOutInMillis <Int32>] [-AuthType <AuthenticationType>] [<CommonParameters>]

DESCRIPTION

Lists the SQL plan baselines for the specified Managed Database.

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

-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

-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

-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

-IsAccepted

A filter to return only SQL plan baselines that are either accepted or not accepted. By default, all SQL plan baselines are returned.

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

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

-IsAdaptive

A filter to return only SQL plan baselines that are either adaptive or not adaptive. By default, all SQL plan baselines are returned.

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

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

-IsAutoPurged

A filter to return only SQL plan baselines that are either auto-purged or not auto-purged. By default, all SQL plan baselines are returned.

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

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

-IsEnabled

A filter to return only SQL plan baselines that are either enabled or not enabled. By default, all SQL plan baselines are returned.

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

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

-IsFixed

A filter to return only SQL plan baselines that are either fixed or not fixed. By default, all SQL plan baselines are returned.

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

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

-IsNeverExecuted

A filter to return only SQL plan baselines that are not executed till now. By default, all SQL plan baselines are returned.

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

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

-IsReproduced

A filter to return only SQL plan baselines that were either reproduced or not reproduced by the optimizer. By default, all SQL plan baselines are returned.

Type: Boolean
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

-Origin

A filter to return all the SQL plan baselines that match the origin.

Type: SqlPlanBaselineOrigin
Parameter Sets: (All)
Aliases: None
Accepted values: UnknownEnumValue, AddmSqltune, AutoCapture, AutoSqltune, EvolveAutoIndexLoad, EvolveCreateFromAdaptive, EvolveLoadFromSts, EvolveLoadFromAwr, EvolveLoadFromCursorCache, ManualLoad, ManualLoadFromAwr, ManualLoadFromCursorCache, ManualLoadFromSts, ManualSqltune, StoredOutline, Unknown

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

-PlanName

A filter to return only SQL plan baselines that match the plan name.

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

-SortBy

The option to sort the SQL plan baseline summary data.

Type: SortByEnum
Parameter Sets: (All)
Aliases: None
Accepted values: TimeCreated, TimeLastModified, TimeLastExecuted

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

-SqlHandle

A filter to return all the SQL plan baselines for the specified SQL handle.

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

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

-SqlText

A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.

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

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

-TimeLastExecutedGreaterThan

A filter to return only SQL plan baselines whose last execution time is after the specified value. By default, all SQL plan baselines are returned.

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

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

-TimeLastExecutedLessThan

A filter to return only SQL plan baselines whose last execution time is before the specified value. By default, all SQL plan baselines are returned.

Type: DateTime
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.SqlPlanBaselineCollection
• Oci.DatabasemanagementService.Responses.ListSqlPlanBaselinesResponse

RELATED LINKS

• APIReference
• DotnetSDKAPI
• OCIModulesDocs
• OCIServiceConcepts
• Examples