Class: OCI::DatabaseManagement::Models::SaveSqlTuningSetAsDetails

Inherits:
Object
  • Object
show all
Defined in:
lib/oci/database_management/models/save_sql_tuning_set_as_details.rb

Overview

Save current list of Sql statements into another Sql tuning set.

Constant Summary collapse

PLAN_FILTER_ENUM = 
[
  PLAN_FILTER_LAST_GENERATED = 'LAST_GENERATED'.freeze,
  PLAN_FILTER_FIRST_GENERATED = 'FIRST_GENERATED'.freeze,
  PLAN_FILTER_LAST_LOADED = 'LAST_LOADED'.freeze,
  PLAN_FILTER_FIRST_LOADED = 'FIRST_LOADED'.freeze,
  PLAN_FILTER_MAX_ELAPSED_TIME = 'MAX_ELAPSED_TIME'.freeze,
  PLAN_FILTER_MAX_BUFFER_GETS = 'MAX_BUFFER_GETS'.freeze,
  PLAN_FILTER_MAX_DISK_READS = 'MAX_DISK_READS'.freeze,
  PLAN_FILTER_MAX_DIRECT_WRITES = 'MAX_DIRECT_WRITES'.freeze,
  PLAN_FILTER_MAX_OPTIMIZER_COST = 'MAX_OPTIMIZER_COST'.freeze
].freeze
RECURSIVE_SQL_ENUM = 
[
  RECURSIVE_SQL_HAS_RECURSIVE_SQL = 'HAS_RECURSIVE_SQL'.freeze,
  RECURSIVE_SQL_NO_RECURSIVE_SQL = 'NO_RECURSIVE_SQL'.freeze
].freeze
RANKING_MEASURE1_ENUM = 
[
  RANKING_MEASURE1_ELAPSED_TIME = 'ELAPSED_TIME'.freeze,
  RANKING_MEASURE1_CPU_TIME = 'CPU_TIME'.freeze,
  RANKING_MEASURE1_OPTIMIZER_COST = 'OPTIMIZER_COST'.freeze,
  RANKING_MEASURE1_BUFFER_GETS = 'BUFFER_GETS'.freeze,
  RANKING_MEASURE1_DISK_READS = 'DISK_READS'.freeze,
  RANKING_MEASURE1_DIRECT_WRITES = 'DIRECT_WRITES'.freeze
].freeze
RANKING_MEASURE2_ENUM = 
[
  RANKING_MEASURE2_ELAPSED_TIME = 'ELAPSED_TIME'.freeze,
  RANKING_MEASURE2_CPU_TIME = 'CPU_TIME'.freeze,
  RANKING_MEASURE2_OPTIMIZER_COST = 'OPTIMIZER_COST'.freeze,
  RANKING_MEASURE2_BUFFER_GETS = 'BUFFER_GETS'.freeze,
  RANKING_MEASURE2_DISK_READS = 'DISK_READS'.freeze,
  RANKING_MEASURE2_DIRECT_WRITES = 'DIRECT_WRITES'.freeze
].freeze
RANKING_MEASURE3_ENUM = 
[
  RANKING_MEASURE3_ELAPSED_TIME = 'ELAPSED_TIME'.freeze,
  RANKING_MEASURE3_CPU_TIME = 'CPU_TIME'.freeze,
  RANKING_MEASURE3_OPTIMIZER_COST = 'OPTIMIZER_COST'.freeze,
  RANKING_MEASURE3_BUFFER_GETS = 'BUFFER_GETS'.freeze,
  RANKING_MEASURE3_DISK_READS = 'DISK_READS'.freeze,
  RANKING_MEASURE3_DIRECT_WRITES = 'DIRECT_WRITES'.freeze
].freeze
LOAD_OPTION_ENUM = 
[
  LOAD_OPTION_INSERT = 'INSERT'.freeze,
  LOAD_OPTION_UPDATE = 'UPDATE'.freeze,
  LOAD_OPTION_MERGE = 'MERGE'.freeze
].freeze
UPDATE_OPTION_ENUM = 
[
  UPDATE_OPTION_REPLACE = 'REPLACE'.freeze,
  UPDATE_OPTION_ACCUMULATE = 'ACCUMULATE'.freeze
].freeze
UPDATE_CONDITION_ENUM = 
[
  UPDATE_CONDITION_OLD = 'OLD'.freeze,
  UPDATE_CONDITION_NEW = 'NEW'.freeze
].freeze

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(attributes = {}) ⇒ SaveSqlTuningSetAsDetails

Initializes the object

Parameters:

  • attributes (Hash) (defaults to: {}) —

    Model attributes in the form of hash

Options Hash (attributes):



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
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 343

def initialize(attributes = {})
  return unless attributes.is_a?(Hash)

  # convert string to symbol for hash key
  attributes = attributes.each_with_object({}) { |(k, v), h| h[k.to_sym] = v }

  self.credential_details = attributes[:'credentialDetails'] if attributes[:'credentialDetails']

  raise 'You cannot provide both :credentialDetails and :credential_details' if attributes.key?(:'credentialDetails') && attributes.key?(:'credential_details')

  self.credential_details = attributes[:'credential_details'] if attributes[:'credential_details']

  self.show_sql_only = attributes[:'showSqlOnly'] if attributes[:'showSqlOnly']

  raise 'You cannot provide both :showSqlOnly and :show_sql_only' if attributes.key?(:'showSqlOnly') && attributes.key?(:'show_sql_only')

  self.show_sql_only = attributes[:'show_sql_only'] if attributes[:'show_sql_only']

  self.owner = attributes[:'owner'] if attributes[:'owner']
  self.owner = "null" if owner.nil? && !attributes.key?(:'owner') # rubocop:disable Style/StringLiterals

  self.name = attributes[:'name'] if attributes[:'name']

  self.destination_sql_tuning_set_name = attributes[:'destinationSqlTuningSetName'] if attributes[:'destinationSqlTuningSetName']

  raise 'You cannot provide both :destinationSqlTuningSetName and :destination_sql_tuning_set_name' if attributes.key?(:'destinationSqlTuningSetName') && attributes.key?(:'destination_sql_tuning_set_name')

  self.destination_sql_tuning_set_name = attributes[:'destination_sql_tuning_set_name'] if attributes[:'destination_sql_tuning_set_name']

  self.destination_sql_tuning_set_description = attributes[:'destinationSqlTuningSetDescription'] if attributes[:'destinationSqlTuningSetDescription']

  raise 'You cannot provide both :destinationSqlTuningSetDescription and :destination_sql_tuning_set_description' if attributes.key?(:'destinationSqlTuningSetDescription') && attributes.key?(:'destination_sql_tuning_set_description')

  self.destination_sql_tuning_set_description = attributes[:'destination_sql_tuning_set_description'] if attributes[:'destination_sql_tuning_set_description']

  self.destination_sql_tuning_set_owner = attributes[:'destinationSqlTuningSetOwner'] if attributes[:'destinationSqlTuningSetOwner']
  self.destination_sql_tuning_set_owner = "null" if destination_sql_tuning_set_owner.nil? && !attributes.key?(:'destinationSqlTuningSetOwner') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :destinationSqlTuningSetOwner and :destination_sql_tuning_set_owner' if attributes.key?(:'destinationSqlTuningSetOwner') && attributes.key?(:'destination_sql_tuning_set_owner')

  self.destination_sql_tuning_set_owner = attributes[:'destination_sql_tuning_set_owner'] if attributes[:'destination_sql_tuning_set_owner']
  self.destination_sql_tuning_set_owner = "null" if destination_sql_tuning_set_owner.nil? && !attributes.key?(:'destinationSqlTuningSetOwner') && !attributes.key?(:'destination_sql_tuning_set_owner') # rubocop:disable Style/StringLiterals

  self.create_new = attributes[:'createNew'] if attributes[:'createNew']

  raise 'You cannot provide both :createNew and :create_new' if attributes.key?(:'createNew') && attributes.key?(:'create_new')

  self.create_new = attributes[:'create_new'] if attributes[:'create_new']

  self.basic_filter = attributes[:'basicFilter'] if attributes[:'basicFilter']
  self.basic_filter = "null" if basic_filter.nil? && !attributes.key?(:'basicFilter') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :basicFilter and :basic_filter' if attributes.key?(:'basicFilter') && attributes.key?(:'basic_filter')

  self.basic_filter = attributes[:'basic_filter'] if attributes[:'basic_filter']
  self.basic_filter = "null" if basic_filter.nil? && !attributes.key?(:'basicFilter') && !attributes.key?(:'basic_filter') # rubocop:disable Style/StringLiterals

  self.plan_filter = attributes[:'planFilter'] if attributes[:'planFilter']
  self.plan_filter = "null" if plan_filter.nil? && !attributes.key?(:'planFilter') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :planFilter and :plan_filter' if attributes.key?(:'planFilter') && attributes.key?(:'plan_filter')

  self.plan_filter = attributes[:'plan_filter'] if attributes[:'plan_filter']
  self.plan_filter = "null" if plan_filter.nil? && !attributes.key?(:'planFilter') && !attributes.key?(:'plan_filter') # rubocop:disable Style/StringLiterals

  self.recursive_sql = attributes[:'recursiveSql'] if attributes[:'recursiveSql']
  self.recursive_sql = "HAS_RECURSIVE_SQL" if recursive_sql.nil? && !attributes.key?(:'recursiveSql') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :recursiveSql and :recursive_sql' if attributes.key?(:'recursiveSql') && attributes.key?(:'recursive_sql')

  self.recursive_sql = attributes[:'recursive_sql'] if attributes[:'recursive_sql']
  self.recursive_sql = "HAS_RECURSIVE_SQL" if recursive_sql.nil? && !attributes.key?(:'recursiveSql') && !attributes.key?(:'recursive_sql') # rubocop:disable Style/StringLiterals

  self.result_percentage = attributes[:'resultPercentage'] if attributes[:'resultPercentage']
  self.result_percentage = 1.0 if result_percentage.nil? && !attributes.key?(:'resultPercentage') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :resultPercentage and :result_percentage' if attributes.key?(:'resultPercentage') && attributes.key?(:'result_percentage')

  self.result_percentage = attributes[:'result_percentage'] if attributes[:'result_percentage']
  self.result_percentage = 1.0 if result_percentage.nil? && !attributes.key?(:'resultPercentage') && !attributes.key?(:'result_percentage') # rubocop:disable Style/StringLiterals

  self.result_limit = attributes[:'resultLimit'] if attributes[:'resultLimit']

  raise 'You cannot provide both :resultLimit and :result_limit' if attributes.key?(:'resultLimit') && attributes.key?(:'result_limit')

  self.result_limit = attributes[:'result_limit'] if attributes[:'result_limit']

  self.ranking_measure1 = attributes[:'rankingMeasure1'] if attributes[:'rankingMeasure1']
  self.ranking_measure1 = "null" if ranking_measure1.nil? && !attributes.key?(:'rankingMeasure1') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :rankingMeasure1 and :ranking_measure1' if attributes.key?(:'rankingMeasure1') && attributes.key?(:'ranking_measure1')

  self.ranking_measure1 = attributes[:'ranking_measure1'] if attributes[:'ranking_measure1']
  self.ranking_measure1 = "null" if ranking_measure1.nil? && !attributes.key?(:'rankingMeasure1') && !attributes.key?(:'ranking_measure1') # rubocop:disable Style/StringLiterals

  self.ranking_measure2 = attributes[:'rankingMeasure2'] if attributes[:'rankingMeasure2']
  self.ranking_measure2 = "null" if ranking_measure2.nil? && !attributes.key?(:'rankingMeasure2') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :rankingMeasure2 and :ranking_measure2' if attributes.key?(:'rankingMeasure2') && attributes.key?(:'ranking_measure2')

  self.ranking_measure2 = attributes[:'ranking_measure2'] if attributes[:'ranking_measure2']
  self.ranking_measure2 = "null" if ranking_measure2.nil? && !attributes.key?(:'rankingMeasure2') && !attributes.key?(:'ranking_measure2') # rubocop:disable Style/StringLiterals

  self.ranking_measure3 = attributes[:'rankingMeasure3'] if attributes[:'rankingMeasure3']
  self.ranking_measure3 = "null" if ranking_measure3.nil? && !attributes.key?(:'rankingMeasure3') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :rankingMeasure3 and :ranking_measure3' if attributes.key?(:'rankingMeasure3') && attributes.key?(:'ranking_measure3')

  self.ranking_measure3 = attributes[:'ranking_measure3'] if attributes[:'ranking_measure3']
  self.ranking_measure3 = "null" if ranking_measure3.nil? && !attributes.key?(:'rankingMeasure3') && !attributes.key?(:'ranking_measure3') # rubocop:disable Style/StringLiterals

  self.attribute_list = attributes[:'attributeList'] if attributes[:'attributeList']
  self.attribute_list = "TYPICAL" if attribute_list.nil? && !attributes.key?(:'attributeList') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :attributeList and :attribute_list' if attributes.key?(:'attributeList') && attributes.key?(:'attribute_list')

  self.attribute_list = attributes[:'attribute_list'] if attributes[:'attribute_list']
  self.attribute_list = "TYPICAL" if attribute_list.nil? && !attributes.key?(:'attributeList') && !attributes.key?(:'attribute_list') # rubocop:disable Style/StringLiterals

  self.load_option = attributes[:'loadOption'] if attributes[:'loadOption']
  self.load_option = "INSERT" if load_option.nil? && !attributes.key?(:'loadOption') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :loadOption and :load_option' if attributes.key?(:'loadOption') && attributes.key?(:'load_option')

  self.load_option = attributes[:'load_option'] if attributes[:'load_option']
  self.load_option = "INSERT" if load_option.nil? && !attributes.key?(:'loadOption') && !attributes.key?(:'load_option') # rubocop:disable Style/StringLiterals

  self.update_option = attributes[:'updateOption'] if attributes[:'updateOption']
  self.update_option = "REPLACE" if update_option.nil? && !attributes.key?(:'updateOption') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :updateOption and :update_option' if attributes.key?(:'updateOption') && attributes.key?(:'update_option')

  self.update_option = attributes[:'update_option'] if attributes[:'update_option']
  self.update_option = "REPLACE" if update_option.nil? && !attributes.key?(:'updateOption') && !attributes.key?(:'update_option') # rubocop:disable Style/StringLiterals

  self.update_condition = attributes[:'updateCondition'] if attributes[:'updateCondition']
  self.update_condition = "null" if update_condition.nil? && !attributes.key?(:'updateCondition') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :updateCondition and :update_condition' if attributes.key?(:'updateCondition') && attributes.key?(:'update_condition')

  self.update_condition = attributes[:'update_condition'] if attributes[:'update_condition']
  self.update_condition = "null" if update_condition.nil? && !attributes.key?(:'updateCondition') && !attributes.key?(:'update_condition') # rubocop:disable Style/StringLiterals

  self.update_attributes = attributes[:'updateAttributes'] if attributes[:'updateAttributes']
  self.update_attributes = "null" if update_attributes.nil? && !attributes.key?(:'updateAttributes') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :updateAttributes and :update_attributes' if attributes.key?(:'updateAttributes') && attributes.key?(:'update_attributes')

  self.update_attributes = attributes[:'update_attributes'] if attributes[:'update_attributes']
  self.update_attributes = "null" if update_attributes.nil? && !attributes.key?(:'updateAttributes') && !attributes.key?(:'update_attributes') # rubocop:disable Style/StringLiterals

  self.is_ignore_null = attributes[:'isIgnoreNull'] unless attributes[:'isIgnoreNull'].nil?
  self.is_ignore_null = true if is_ignore_null.nil? && !attributes.key?(:'isIgnoreNull') # rubocop:disable Style/StringLiterals

  raise 'You cannot provide both :isIgnoreNull and :is_ignore_null' if attributes.key?(:'isIgnoreNull') && attributes.key?(:'is_ignore_null')

  self.is_ignore_null = attributes[:'is_ignore_null'] unless attributes[:'is_ignore_null'].nil?
  self.is_ignore_null = true if is_ignore_null.nil? && !attributes.key?(:'isIgnoreNull') && !attributes.key?(:'is_ignore_null') # rubocop:disable Style/StringLiterals

  self.commit_rows = attributes[:'commitRows'] if attributes[:'commitRows']

  raise 'You cannot provide both :commitRows and :commit_rows' if attributes.key?(:'commitRows') && attributes.key?(:'commit_rows')

  self.commit_rows = attributes[:'commit_rows'] if attributes[:'commit_rows']
end

Instance Attribute Details

#attribute_list ⇒ String

Specifies the list of Sql statement attributes to return in the result. Note that this parameter cannot be made an enum since custom value can take a list of comma separated attribute names. Attribute list can take one of the following values. TYPICAL - Specifies BASIC plus Sql plan (without row source statistics) and without object reference list (default). BASIC - Specifies all attributes (such as execution statistics and binds) except the plans. The execution context is always part of the result. ALL - Specifies all attributes. CUSTOM - Comma-separated list of the following attribute names. - EXECUTION_STATISTICS - BIND_LIST - OBJECT_LIST - SQL_PLAN - SQL_PLAN_STATISTICS Usage examples: 1. "attributeList": "TYPICAL" 2. "attributeList": "ALL" 3. "attributeList": "EXECUTION_STATISTICS,OBJECT_LIST,SQL_PLAN"

Returns:

  • (String) 


170
171
172
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 170

def attribute_list
  @attribute_list
end

#basic_filter ⇒ String

Specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW. User could use any combination of the following columns with appropriate values as Sql predicate Refer to the documentation docs.oracle.com/en/database/oracle/oracle-database/18/arpls/DBMS_SQLTUNE.html#GUID-1F4AFB03-7B29-46FC-B3F2-CB01EC36326C

Returns:

  • (String) 


114
115
116
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 114

def basic_filter
  @basic_filter
end

#commit_rows ⇒ Integer

Specifies whether to commit statements after DML. If a value is provided, then the load commits after each specified number of statements is inserted. If NULL is provided, then the load commits only once, at the end of the operation.

Returns:

  • (Integer) 


250
251
252
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 250

def commit_rows
  @commit_rows
end

#create_new ⇒ Integer

[Required] Specifies whether to create a new Sql tuning set or not. Possible values 1 - Create a new Sql tuning set 0 - Do not create a new Sql tuning set

Returns:

  • (Integer) 


107
108
109
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 107

def create_new
  @create_new
end

#credential_details ⇒ OCI::DatabaseManagement::Models::SqlTuningSetAdminCredentialDetails

This attribute is required.

Returns:



74
75
76
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 74

def credential_details
  @credential_details
end

#destination_sql_tuning_set_description ⇒ String

The description for the destination Sql tuning set.

Returns:

  • (String) 


95
96
97
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 95

def destination_sql_tuning_set_description
  @destination_sql_tuning_set_description
end

#destination_sql_tuning_set_name ⇒ String

[Required] The name of the destination Sql tuning set.

Returns:

  • (String) 


91
92
93
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 91

def destination_sql_tuning_set_name
  @destination_sql_tuning_set_name
end

#destination_sql_tuning_set_owner ⇒ String

Owner of the destination Sql tuning set.

Returns:

  • (String) 


99
100
101
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 99

def destination_sql_tuning_set_owner
  @destination_sql_tuning_set_owner
end

#is_ignore_null ⇒ BOOLEAN

Specifies whether to update attributes when the new value is NULL. If TRUE, then the procedure does not update an attribute when the new value is NULL. That is, do not override with NULL values unless intentional. Possible values - true or false

Returns:

  • (BOOLEAN) 


243
244
245
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 243

def is_ignore_null
  @is_ignore_null
end

#load_option ⇒ String

Specifies which statements are loaded into the Sql tuning set. The possible values are. - INSERT (default) Adds only new statements. - UPDATE Updates existing the Sql statements and ignores any new statements. - MERGE Inserts new statements and updates the information of the existing ones.

Returns:

  • (String) 


182
183
184
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 182

def load_option
  @load_option
end

#name ⇒ String

[Required] The name of the Sql tuning set.

Returns:

  • (String) 


87
88
89
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 87

def name
  @name
end

#owner ⇒ String

The owner of the Sql tuning set.

Returns:

  • (String) 


83
84
85
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 83

def owner
  @owner
end

#plan_filter ⇒ String

Specifies the plan filter. This parameter enables you to select a single plan when a statement has multiple plans. Refer to the documentation docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_SQLSET.html#GUID-9D995019-91AB-4B1E-9EAF-031050789B21

Returns:

  • (String) 


121
122
123
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 121

def plan_filter
  @plan_filter
end

#ranking_measure1 ⇒ String

Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.

Returns:

  • (String) 


140
141
142
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 140

def ranking_measure1
  @ranking_measure1
end

#ranking_measure2 ⇒ String

Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.

Returns:

  • (String) 


145
146
147
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 145

def ranking_measure2
  @ranking_measure2
end

#ranking_measure3 ⇒ String

Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.

Returns:

  • (String) 


150
151
152
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 150

def ranking_measure3
  @ranking_measure3
end

#recursive_sql ⇒ String

Specifies that the filter must include recursive Sql in the Sql tuning set.

Returns:

  • (String) 


125
126
127
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 125

def recursive_sql
  @recursive_sql
end

#result_limit ⇒ Integer

The top limit Sql from the filtered source, ranked by the ranking measure.

Returns:

  • (Integer) 


135
136
137
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 135

def result_limit
  @result_limit
end

#result_percentage ⇒ Float

Specifies a filter that picks the top n% according to the supplied ranking measure. Note that this parameter applies only if one ranking measure is supplied.

Returns:

  • (Float) 


131
132
133
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 131

def result_percentage
  @result_percentage
end

#show_sql_only ⇒ Integer

Flag to indicate whether to save the Sql tuning set or just display the plsql used to save Sql tuning set.

Returns:

  • (Integer) 


79
80
81
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 79

def show_sql_only
  @show_sql_only
end

#update_attributes ⇒ String

Specifies the list of Sql statement attributes to update during a merge or update. Note that this parameter cannot be made an enum since custom value can take a list of comma separated attribute names. Update attributes can take one of the following values. NULL (default) - Specifies the content of the input cursor except the execution context. On other terms, it is equivalent to ALL without execution contexts such as module and action. BASIC - Specifies statistics and binds only. TYPICAL - Specifies BASIC with Sql plans (without row source statistics) and without an object reference list. ALL - Specifies all attributes, including the execution context attributes such as module and action. CUSTOM - List of comma separated attribute names to update EXECUTION_CONTEXT EXECUTION_STATISTICS SQL_BINDS SQL_PLAN SQL_PLAN_STATISTICS (similar to SQL_PLAN with added row source statistics) Usage examples: 1. "updateAttributes": "TYPICAL" 2. "updateAttributes": "BASIC" 3. "updateAttributes": "EXECUTION_STATISTICS,SQL_PLAN_STATISTICS,SQL_PLAN" 4. "updateAttributes": "EXECUTION_STATISTICS,SQL_PLAN"

Returns:

  • (String) 


235
236
237
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 235

def update_attributes
  @update_attributes
end

#update_condition ⇒ String

Specifies when to perform the update. The procedure only performs the update when the specified condition is satisfied. The condition can refer to either the data source or destination. The condition must use the following prefixes to refer to attributes from the source or the destination: OLD u2014 Refers to statement attributes from the SQL tuning set (destination). NEW u2014 Refers to statement attributes from the input statements (source). NULL u2014 No updates are performed.

Returns:

  • (String) 


213
214
215
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 213

def update_condition
  @update_condition
end

#update_option ⇒ String

Specifies how existing Sql statements are updated. This parameter is applicable only if load_option is specified with UPDATE or MERGE as an option. Update option can take one of the following values. REPLACE (default) - Updates the statement using the new statistics, bind list, object list, and so on. ACCUMULATE - Combines attributes when possible (for example, statistics such as elapsed_time), otherwise replaces the existing values (for example, module and action) with the provided values. Following Sql statement attributes can be accumulated. elapsed_time buffer_gets direct_writes disk_reads row_processed fetches executions end_of_fetch_count stat_period active_stat_period

Returns:

  • (String) 


202
203
204
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 202

def update_option
  @update_option
end

Class Method Details

.attribute_map ⇒ Object

Attribute mapping from ruby-style variable name to JSON key.



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
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 253

def self.attribute_map
  {
    # rubocop:disable Style/SymbolLiteral
    'credential_details': :'credentialDetails',
    'show_sql_only': :'showSqlOnly',
    'owner': :'owner',
    'name': :'name',
    'destination_sql_tuning_set_name': :'destinationSqlTuningSetName',
    'destination_sql_tuning_set_description': :'destinationSqlTuningSetDescription',
    'destination_sql_tuning_set_owner': :'destinationSqlTuningSetOwner',
    'create_new': :'createNew',
    'basic_filter': :'basicFilter',
    'plan_filter': :'planFilter',
    'recursive_sql': :'recursiveSql',
    'result_percentage': :'resultPercentage',
    'result_limit': :'resultLimit',
    'ranking_measure1': :'rankingMeasure1',
    'ranking_measure2': :'rankingMeasure2',
    'ranking_measure3': :'rankingMeasure3',
    'attribute_list': :'attributeList',
    'load_option': :'loadOption',
    'update_option': :'updateOption',
    'update_condition': :'updateCondition',
    'update_attributes': :'updateAttributes',
    'is_ignore_null': :'isIgnoreNull',
    'commit_rows': :'commitRows'
    # rubocop:enable Style/SymbolLiteral
  }
end

.swagger_types ⇒ Object

Attribute type mapping.



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
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 284

def self.swagger_types
  {
    # rubocop:disable Style/SymbolLiteral
    'credential_details': :'OCI::DatabaseManagement::Models::SqlTuningSetAdminCredentialDetails',
    'show_sql_only': :'Integer',
    'owner': :'String',
    'name': :'String',
    'destination_sql_tuning_set_name': :'String',
    'destination_sql_tuning_set_description': :'String',
    'destination_sql_tuning_set_owner': :'String',
    'create_new': :'Integer',
    'basic_filter': :'String',
    'plan_filter': :'String',
    'recursive_sql': :'String',
    'result_percentage': :'Float',
    'result_limit': :'Integer',
    'ranking_measure1': :'String',
    'ranking_measure2': :'String',
    'ranking_measure3': :'String',
    'attribute_list': :'String',
    'load_option': :'String',
    'update_option': :'String',
    'update_condition': :'String',
    'update_attributes': :'String',
    'is_ignore_null': :'BOOLEAN',
    'commit_rows': :'Integer'
    # rubocop:enable Style/SymbolLiteral
  }
end

Instance Method Details

#==(other) ⇒ Object

Checks equality by comparing each attribute.

Parameters:

  • other (Object) —

    the other object to be compared



580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 580

def ==(other)
  return true if equal?(other)

  self.class == other.class &&
    credential_details == other.credential_details &&
    show_sql_only == other.show_sql_only &&
    owner == other.owner &&
    name == other.name &&
    destination_sql_tuning_set_name == other.destination_sql_tuning_set_name &&
    destination_sql_tuning_set_description == other.destination_sql_tuning_set_description &&
    destination_sql_tuning_set_owner == other.destination_sql_tuning_set_owner &&
    create_new == other.create_new &&
    basic_filter == other.basic_filter &&
    plan_filter == other.plan_filter &&
    recursive_sql == other.recursive_sql &&
    result_percentage == other.result_percentage &&
    result_limit == other.result_limit &&
    ranking_measure1 == other.ranking_measure1 &&
    ranking_measure2 == other.ranking_measure2 &&
    ranking_measure3 == other.ranking_measure3 &&
    attribute_list == other.attribute_list &&
    load_option == other.load_option &&
    update_option == other.update_option &&
    update_condition == other.update_condition &&
    update_attributes == other.update_attributes &&
    is_ignore_null == other.is_ignore_null &&
    commit_rows == other.commit_rows
end

#build_from_hash(attributes) ⇒ Object

Builds the object from hash

Parameters:

  • attributes (Hash) —

    Model attributes in the form of hash

Returns:

  • (Object) —

    Returns the model itself



632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 632

def build_from_hash(attributes)
  return nil unless attributes.is_a?(Hash)

  self.class.swagger_types.each_pair do |key, type|
    if type =~ /^Array<(.*)>/i
      # check to ensure the input is an array given that the the attribute
      # is documented as an array but the input is not
      if attributes[self.class.attribute_map[key]].is_a?(Array)
        public_method("#{key}=").call(
          attributes[self.class.attribute_map[key]]
            .map { |v| OCI::Internal::Util.convert_to_type(Regexp.last_match(1), v) }
        )
      end
    elsif !attributes[self.class.attribute_map[key]].nil?
      public_method("#{key}=").call(
        OCI::Internal::Util.convert_to_type(type, attributes[self.class.attribute_map[key]])
      )
    end
    # or else data not found in attributes(hash), not an issue as the data can be optional
  end

  self
end

#eql?(other) ⇒ Boolean

Parameters:

  • other (Object) —

    the other object to be compared

Returns:

  • (Boolean)

See Also:

  • `==` method


612
613
614
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 612

def eql?(other)
  self == other
end

#hash ⇒ Fixnum

Calculates hash code according to all attributes.

Returns:

  • (Fixnum) —

    Hash code



621
622
623
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 621

def hash
  [credential_details, show_sql_only, owner, name, destination_sql_tuning_set_name, destination_sql_tuning_set_description, destination_sql_tuning_set_owner, create_new, basic_filter, plan_filter, recursive_sql, result_percentage, result_limit, ranking_measure1, ranking_measure2, ranking_measure3, attribute_list, load_option, update_option, update_condition, update_attributes, is_ignore_null, commit_rows].hash
end

#to_hash ⇒ Hash

Returns the object in the form of hash

Returns:

  • (Hash) —

    Returns the object in the form of hash



665
666
667
668
669
670
671
672
673
674
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 665

def to_hash
  hash = {}
  self.class.attribute_map.each_pair do |attr, param|
    value = public_method(attr).call
    next if value.nil? && !instance_variable_defined?("@#{attr}")

    hash[param] = _to_hash(value)
  end
  hash
end

#to_s ⇒ String

Returns the string representation of the object

Returns:

  • (String) —

    String presentation of the object



659
660
661
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 659

def to_s
  to_hash.to_s
end