-
Notifications
You must be signed in to change notification settings - Fork 82
/
sql_plan_baseline.go
369 lines (304 loc) · 15 KB
/
sql_plan_baseline.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
// Copyright (c) 2016, 2018, 2024, Oracle and/or its affiliates. All rights reserved.
// This software is dual-licensed to you under the Universal Permissive License (UPL) 1.0 as shown at https://oss.oracle.com/licenses/upl or Apache License 2.0 as shown at http://www.apache.org/licenses/LICENSE-2.0. You may choose either license.
// Code generated. DO NOT EDIT.
// Database Management API
//
// Use the Database Management API to monitor and manage resources such as
// Oracle Databases, MySQL Databases, and External Database Systems.
// For more information, see Database Management (https://docs.cloud.oracle.com/iaas/database-management/home.htm).
//
package databasemanagement
import (
"fmt"
"github.com/oracle/oci-go-sdk/v65/common"
"strings"
)
// SqlPlanBaseline The details of a SQL plan baseline.
type SqlPlanBaseline struct {
// The unique plan identifier.
PlanName *string `mandatory:"true" json:"planName"`
// The unique SQL identifier.
SqlHandle *string `mandatory:"true" json:"sqlHandle"`
// The SQL text.
SqlText *string `mandatory:"true" json:"sqlText"`
// The date and time when the plan baseline was created.
TimeCreated *common.SDKTime `mandatory:"true" json:"timeCreated"`
// The execution plan for the SQL statement.
ExecutionPlan *string `mandatory:"true" json:"executionPlan"`
// The origin of the SQL plan baseline.
Origin SqlPlanBaselineOriginEnum `mandatory:"false" json:"origin,omitempty"`
// The date and time when the plan baseline was last modified.
TimeLastModified *common.SDKTime `mandatory:"false" json:"timeLastModified"`
// The date and time when the plan baseline was last executed.
// **Note:** For performance reasons, database does not update this value
// immediately after each execution of the plan baseline. Therefore, the plan
// baseline may have been executed more recently than this value indicates.
TimeLastExecuted *common.SDKTime `mandatory:"false" json:"timeLastExecuted"`
// Indicates whether the plan baseline is enabled (`YES`) or disabled (`NO`).
Enabled SqlPlanBaselineEnabledEnum `mandatory:"false" json:"enabled,omitempty"`
// Indicates whether the plan baseline is accepted (`YES`) or not (`NO`).
Accepted SqlPlanBaselineAcceptedEnum `mandatory:"false" json:"accepted,omitempty"`
// Indicates whether the plan baseline is fixed (`YES`) or not (`NO`).
Fixed SqlPlanBaselineFixedEnum `mandatory:"false" json:"fixed,omitempty"`
// Indicates whether the optimizer was able to reproduce the plan (`YES`) or not (`NO`).
// The value is set to `YES` when a plan is initially added to the plan baseline.
Reproduced SqlPlanBaselineReproducedEnum `mandatory:"false" json:"reproduced,omitempty"`
// Indicates whether the plan baseline is auto-purged (`YES`) or not (`NO`).
AutoPurge SqlPlanBaselineAutoPurgeEnum `mandatory:"false" json:"autoPurge,omitempty"`
// Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.
// When a new adaptive plan is found for a SQL statement that has an existing SQL plan baseline, that new plan
// will be added to the SQL plan baseline as an unaccepted plan, and the `ADAPTIVE` property will be marked `YES`.
// When this new plan is verified (either manually or via the auto evolve task), the plan will be test executed
// and the final plan determined at execution will become an accepted plan if its performance is better than
// the existing plan baseline. At this point, the value of the `ADAPTIVE` property is set to `NO` since the plan
// is no longer adaptive, but resolved.
Adaptive SqlPlanBaselineAdaptiveEnum `mandatory:"false" json:"adaptive,omitempty"`
// The application module name.
Module *string `mandatory:"false" json:"module"`
// The application action.
Action *string `mandatory:"false" json:"action"`
}
func (m SqlPlanBaseline) String() string {
return common.PointerString(m)
}
// ValidateEnumValue returns an error when providing an unsupported enum value
// This function is being called during constructing API request process
// Not recommended for calling this function directly
func (m SqlPlanBaseline) ValidateEnumValue() (bool, error) {
errMessage := []string{}
if _, ok := GetMappingSqlPlanBaselineOriginEnum(string(m.Origin)); !ok && m.Origin != "" {
errMessage = append(errMessage, fmt.Sprintf("unsupported enum value for Origin: %s. Supported values are: %s.", m.Origin, strings.Join(GetSqlPlanBaselineOriginEnumStringValues(), ",")))
}
if _, ok := GetMappingSqlPlanBaselineEnabledEnum(string(m.Enabled)); !ok && m.Enabled != "" {
errMessage = append(errMessage, fmt.Sprintf("unsupported enum value for Enabled: %s. Supported values are: %s.", m.Enabled, strings.Join(GetSqlPlanBaselineEnabledEnumStringValues(), ",")))
}
if _, ok := GetMappingSqlPlanBaselineAcceptedEnum(string(m.Accepted)); !ok && m.Accepted != "" {
errMessage = append(errMessage, fmt.Sprintf("unsupported enum value for Accepted: %s. Supported values are: %s.", m.Accepted, strings.Join(GetSqlPlanBaselineAcceptedEnumStringValues(), ",")))
}
if _, ok := GetMappingSqlPlanBaselineFixedEnum(string(m.Fixed)); !ok && m.Fixed != "" {
errMessage = append(errMessage, fmt.Sprintf("unsupported enum value for Fixed: %s. Supported values are: %s.", m.Fixed, strings.Join(GetSqlPlanBaselineFixedEnumStringValues(), ",")))
}
if _, ok := GetMappingSqlPlanBaselineReproducedEnum(string(m.Reproduced)); !ok && m.Reproduced != "" {
errMessage = append(errMessage, fmt.Sprintf("unsupported enum value for Reproduced: %s. Supported values are: %s.", m.Reproduced, strings.Join(GetSqlPlanBaselineReproducedEnumStringValues(), ",")))
}
if _, ok := GetMappingSqlPlanBaselineAutoPurgeEnum(string(m.AutoPurge)); !ok && m.AutoPurge != "" {
errMessage = append(errMessage, fmt.Sprintf("unsupported enum value for AutoPurge: %s. Supported values are: %s.", m.AutoPurge, strings.Join(GetSqlPlanBaselineAutoPurgeEnumStringValues(), ",")))
}
if _, ok := GetMappingSqlPlanBaselineAdaptiveEnum(string(m.Adaptive)); !ok && m.Adaptive != "" {
errMessage = append(errMessage, fmt.Sprintf("unsupported enum value for Adaptive: %s. Supported values are: %s.", m.Adaptive, strings.Join(GetSqlPlanBaselineAdaptiveEnumStringValues(), ",")))
}
if len(errMessage) > 0 {
return true, fmt.Errorf(strings.Join(errMessage, "\n"))
}
return false, nil
}
// SqlPlanBaselineEnabledEnum Enum with underlying type: string
type SqlPlanBaselineEnabledEnum string
// Set of constants representing the allowable values for SqlPlanBaselineEnabledEnum
const (
SqlPlanBaselineEnabledYes SqlPlanBaselineEnabledEnum = "YES"
SqlPlanBaselineEnabledNo SqlPlanBaselineEnabledEnum = "NO"
)
var mappingSqlPlanBaselineEnabledEnum = map[string]SqlPlanBaselineEnabledEnum{
"YES": SqlPlanBaselineEnabledYes,
"NO": SqlPlanBaselineEnabledNo,
}
var mappingSqlPlanBaselineEnabledEnumLowerCase = map[string]SqlPlanBaselineEnabledEnum{
"yes": SqlPlanBaselineEnabledYes,
"no": SqlPlanBaselineEnabledNo,
}
// GetSqlPlanBaselineEnabledEnumValues Enumerates the set of values for SqlPlanBaselineEnabledEnum
func GetSqlPlanBaselineEnabledEnumValues() []SqlPlanBaselineEnabledEnum {
values := make([]SqlPlanBaselineEnabledEnum, 0)
for _, v := range mappingSqlPlanBaselineEnabledEnum {
values = append(values, v)
}
return values
}
// GetSqlPlanBaselineEnabledEnumStringValues Enumerates the set of values in String for SqlPlanBaselineEnabledEnum
func GetSqlPlanBaselineEnabledEnumStringValues() []string {
return []string{
"YES",
"NO",
}
}
// GetMappingSqlPlanBaselineEnabledEnum performs case Insensitive comparison on enum value and return the desired enum
func GetMappingSqlPlanBaselineEnabledEnum(val string) (SqlPlanBaselineEnabledEnum, bool) {
enum, ok := mappingSqlPlanBaselineEnabledEnumLowerCase[strings.ToLower(val)]
return enum, ok
}
// SqlPlanBaselineAcceptedEnum Enum with underlying type: string
type SqlPlanBaselineAcceptedEnum string
// Set of constants representing the allowable values for SqlPlanBaselineAcceptedEnum
const (
SqlPlanBaselineAcceptedYes SqlPlanBaselineAcceptedEnum = "YES"
SqlPlanBaselineAcceptedNo SqlPlanBaselineAcceptedEnum = "NO"
)
var mappingSqlPlanBaselineAcceptedEnum = map[string]SqlPlanBaselineAcceptedEnum{
"YES": SqlPlanBaselineAcceptedYes,
"NO": SqlPlanBaselineAcceptedNo,
}
var mappingSqlPlanBaselineAcceptedEnumLowerCase = map[string]SqlPlanBaselineAcceptedEnum{
"yes": SqlPlanBaselineAcceptedYes,
"no": SqlPlanBaselineAcceptedNo,
}
// GetSqlPlanBaselineAcceptedEnumValues Enumerates the set of values for SqlPlanBaselineAcceptedEnum
func GetSqlPlanBaselineAcceptedEnumValues() []SqlPlanBaselineAcceptedEnum {
values := make([]SqlPlanBaselineAcceptedEnum, 0)
for _, v := range mappingSqlPlanBaselineAcceptedEnum {
values = append(values, v)
}
return values
}
// GetSqlPlanBaselineAcceptedEnumStringValues Enumerates the set of values in String for SqlPlanBaselineAcceptedEnum
func GetSqlPlanBaselineAcceptedEnumStringValues() []string {
return []string{
"YES",
"NO",
}
}
// GetMappingSqlPlanBaselineAcceptedEnum performs case Insensitive comparison on enum value and return the desired enum
func GetMappingSqlPlanBaselineAcceptedEnum(val string) (SqlPlanBaselineAcceptedEnum, bool) {
enum, ok := mappingSqlPlanBaselineAcceptedEnumLowerCase[strings.ToLower(val)]
return enum, ok
}
// SqlPlanBaselineFixedEnum Enum with underlying type: string
type SqlPlanBaselineFixedEnum string
// Set of constants representing the allowable values for SqlPlanBaselineFixedEnum
const (
SqlPlanBaselineFixedYes SqlPlanBaselineFixedEnum = "YES"
SqlPlanBaselineFixedNo SqlPlanBaselineFixedEnum = "NO"
)
var mappingSqlPlanBaselineFixedEnum = map[string]SqlPlanBaselineFixedEnum{
"YES": SqlPlanBaselineFixedYes,
"NO": SqlPlanBaselineFixedNo,
}
var mappingSqlPlanBaselineFixedEnumLowerCase = map[string]SqlPlanBaselineFixedEnum{
"yes": SqlPlanBaselineFixedYes,
"no": SqlPlanBaselineFixedNo,
}
// GetSqlPlanBaselineFixedEnumValues Enumerates the set of values for SqlPlanBaselineFixedEnum
func GetSqlPlanBaselineFixedEnumValues() []SqlPlanBaselineFixedEnum {
values := make([]SqlPlanBaselineFixedEnum, 0)
for _, v := range mappingSqlPlanBaselineFixedEnum {
values = append(values, v)
}
return values
}
// GetSqlPlanBaselineFixedEnumStringValues Enumerates the set of values in String for SqlPlanBaselineFixedEnum
func GetSqlPlanBaselineFixedEnumStringValues() []string {
return []string{
"YES",
"NO",
}
}
// GetMappingSqlPlanBaselineFixedEnum performs case Insensitive comparison on enum value and return the desired enum
func GetMappingSqlPlanBaselineFixedEnum(val string) (SqlPlanBaselineFixedEnum, bool) {
enum, ok := mappingSqlPlanBaselineFixedEnumLowerCase[strings.ToLower(val)]
return enum, ok
}
// SqlPlanBaselineReproducedEnum Enum with underlying type: string
type SqlPlanBaselineReproducedEnum string
// Set of constants representing the allowable values for SqlPlanBaselineReproducedEnum
const (
SqlPlanBaselineReproducedYes SqlPlanBaselineReproducedEnum = "YES"
SqlPlanBaselineReproducedNo SqlPlanBaselineReproducedEnum = "NO"
)
var mappingSqlPlanBaselineReproducedEnum = map[string]SqlPlanBaselineReproducedEnum{
"YES": SqlPlanBaselineReproducedYes,
"NO": SqlPlanBaselineReproducedNo,
}
var mappingSqlPlanBaselineReproducedEnumLowerCase = map[string]SqlPlanBaselineReproducedEnum{
"yes": SqlPlanBaselineReproducedYes,
"no": SqlPlanBaselineReproducedNo,
}
// GetSqlPlanBaselineReproducedEnumValues Enumerates the set of values for SqlPlanBaselineReproducedEnum
func GetSqlPlanBaselineReproducedEnumValues() []SqlPlanBaselineReproducedEnum {
values := make([]SqlPlanBaselineReproducedEnum, 0)
for _, v := range mappingSqlPlanBaselineReproducedEnum {
values = append(values, v)
}
return values
}
// GetSqlPlanBaselineReproducedEnumStringValues Enumerates the set of values in String for SqlPlanBaselineReproducedEnum
func GetSqlPlanBaselineReproducedEnumStringValues() []string {
return []string{
"YES",
"NO",
}
}
// GetMappingSqlPlanBaselineReproducedEnum performs case Insensitive comparison on enum value and return the desired enum
func GetMappingSqlPlanBaselineReproducedEnum(val string) (SqlPlanBaselineReproducedEnum, bool) {
enum, ok := mappingSqlPlanBaselineReproducedEnumLowerCase[strings.ToLower(val)]
return enum, ok
}
// SqlPlanBaselineAutoPurgeEnum Enum with underlying type: string
type SqlPlanBaselineAutoPurgeEnum string
// Set of constants representing the allowable values for SqlPlanBaselineAutoPurgeEnum
const (
SqlPlanBaselineAutoPurgeYes SqlPlanBaselineAutoPurgeEnum = "YES"
SqlPlanBaselineAutoPurgeNo SqlPlanBaselineAutoPurgeEnum = "NO"
)
var mappingSqlPlanBaselineAutoPurgeEnum = map[string]SqlPlanBaselineAutoPurgeEnum{
"YES": SqlPlanBaselineAutoPurgeYes,
"NO": SqlPlanBaselineAutoPurgeNo,
}
var mappingSqlPlanBaselineAutoPurgeEnumLowerCase = map[string]SqlPlanBaselineAutoPurgeEnum{
"yes": SqlPlanBaselineAutoPurgeYes,
"no": SqlPlanBaselineAutoPurgeNo,
}
// GetSqlPlanBaselineAutoPurgeEnumValues Enumerates the set of values for SqlPlanBaselineAutoPurgeEnum
func GetSqlPlanBaselineAutoPurgeEnumValues() []SqlPlanBaselineAutoPurgeEnum {
values := make([]SqlPlanBaselineAutoPurgeEnum, 0)
for _, v := range mappingSqlPlanBaselineAutoPurgeEnum {
values = append(values, v)
}
return values
}
// GetSqlPlanBaselineAutoPurgeEnumStringValues Enumerates the set of values in String for SqlPlanBaselineAutoPurgeEnum
func GetSqlPlanBaselineAutoPurgeEnumStringValues() []string {
return []string{
"YES",
"NO",
}
}
// GetMappingSqlPlanBaselineAutoPurgeEnum performs case Insensitive comparison on enum value and return the desired enum
func GetMappingSqlPlanBaselineAutoPurgeEnum(val string) (SqlPlanBaselineAutoPurgeEnum, bool) {
enum, ok := mappingSqlPlanBaselineAutoPurgeEnumLowerCase[strings.ToLower(val)]
return enum, ok
}
// SqlPlanBaselineAdaptiveEnum Enum with underlying type: string
type SqlPlanBaselineAdaptiveEnum string
// Set of constants representing the allowable values for SqlPlanBaselineAdaptiveEnum
const (
SqlPlanBaselineAdaptiveYes SqlPlanBaselineAdaptiveEnum = "YES"
SqlPlanBaselineAdaptiveNo SqlPlanBaselineAdaptiveEnum = "NO"
)
var mappingSqlPlanBaselineAdaptiveEnum = map[string]SqlPlanBaselineAdaptiveEnum{
"YES": SqlPlanBaselineAdaptiveYes,
"NO": SqlPlanBaselineAdaptiveNo,
}
var mappingSqlPlanBaselineAdaptiveEnumLowerCase = map[string]SqlPlanBaselineAdaptiveEnum{
"yes": SqlPlanBaselineAdaptiveYes,
"no": SqlPlanBaselineAdaptiveNo,
}
// GetSqlPlanBaselineAdaptiveEnumValues Enumerates the set of values for SqlPlanBaselineAdaptiveEnum
func GetSqlPlanBaselineAdaptiveEnumValues() []SqlPlanBaselineAdaptiveEnum {
values := make([]SqlPlanBaselineAdaptiveEnum, 0)
for _, v := range mappingSqlPlanBaselineAdaptiveEnum {
values = append(values, v)
}
return values
}
// GetSqlPlanBaselineAdaptiveEnumStringValues Enumerates the set of values in String for SqlPlanBaselineAdaptiveEnum
func GetSqlPlanBaselineAdaptiveEnumStringValues() []string {
return []string{
"YES",
"NO",
}
}
// GetMappingSqlPlanBaselineAdaptiveEnum performs case Insensitive comparison on enum value and return the desired enum
func GetMappingSqlPlanBaselineAdaptiveEnum(val string) (SqlPlanBaselineAdaptiveEnum, bool) {
enum, ok := mappingSqlPlanBaselineAdaptiveEnumLowerCase[strings.ToLower(val)]
return enum, ok
}