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. It takes either credentialDetails or databaseCredential. It's recommended to provide databaseCredential

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,
  UPDATE_CONDITION_NULL = 'NULL'.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):



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
508
509
510
511
512
513
514
515
516
517
518
519
520
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 350

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.database_credential = attributes[:'databaseCredential'] if attributes[:'databaseCredential']

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

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

  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) 


174
175
176
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 174

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) 


118
119
120
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 118

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) 


254
255
256
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 254

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) 


111
112
113
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 111

def create_new
  @create_new
end

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

Returns:



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

def credential_details
  @credential_details
end

#database_credential ⇒ OCI::DatabaseManagement::Models::DatabaseCredentialDetails

Returns:



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

def database_credential
  @database_credential
end

#destination_sql_tuning_set_description ⇒ String

The description for 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_description
  @destination_sql_tuning_set_description
end

#destination_sql_tuning_set_name ⇒ String

[Required] The name of 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_name
  @destination_sql_tuning_set_name
end

#destination_sql_tuning_set_owner ⇒ String

Owner of the destination Sql tuning set.

Returns:

  • (String) 


103
104
105
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 103

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) 


247
248
249
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 247

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) 


186
187
188
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 186

def load_option
  @load_option
end

#name ⇒ String

[Required] The name of the Sql tuning set.

Returns:

  • (String) 


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

def name
  @name
end

#owner ⇒ String

The owner 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 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) 


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

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) 


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

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) 


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

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) 


154
155
156
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 154

def ranking_measure3
  @ranking_measure3
end

#recursive_sql ⇒ String

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

Returns:

  • (String) 


129
130
131
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 129

def recursive_sql
  @recursive_sql
end

#result_limit ⇒ Integer

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

Returns:

  • (Integer) 


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

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) 


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

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) 


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

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) 


239
240
241
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 239

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) 


217
218
219
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 217

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) 


206
207
208
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 206

def update_option
  @update_option
end

Class Method Details

.attribute_map ⇒ Object

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



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

def self.attribute_map
  {
    # rubocop:disable Style/SymbolLiteral
    'credential_details': :'credentialDetails',
    'database_credential': :'databaseCredential',
    '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.



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

def self.swagger_types
  {
    # rubocop:disable Style/SymbolLiteral
    'credential_details': :'OCI::DatabaseManagement::Models::SqlTuningSetAdminCredentialDetails',
    'database_credential': :'OCI::DatabaseManagement::Models::DatabaseCredentialDetails',
    '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



593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 593

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

  self.class == other.class &&
    credential_details == other.credential_details &&
    database_credential == other.database_credential &&
    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



646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 646

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


626
627
628
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 626

def eql?(other)
  self == other
end

#hash ⇒ Fixnum

Calculates hash code according to all attributes.

Returns:

  • (Fixnum) —

    Hash code



635
636
637
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 635

def hash
  [credential_details, database_credential, 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



679
680
681
682
683
684
685
686
687
688
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 679

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



673
674
675
 
# File 'lib/oci/database_management/models/save_sql_tuning_set_as_details.rb', line 673

def to_s
  to_hash.to_s
end