Class: OCI::DatabaseManagement::Models::SaveSqlTuningSetAsDetails
- Inherits:
-
Object
- Object
- OCI::DatabaseManagement::Models::SaveSqlTuningSetAsDetails
- 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
-
#attribute_list ⇒ String
Specifies the list of Sql statement attributes to return in the result.
-
#basic_filter ⇒ String
Specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW.
-
#commit_rows ⇒ Integer
Specifies whether to commit statements after DML.
-
#create_new ⇒ Integer
[Required] Specifies whether to create a new Sql tuning set or not.
-
#credential_details ⇒ OCI::DatabaseManagement::Models::SqlTuningSetAdminCredentialDetails
This attribute is required.
-
#destination_sql_tuning_set_description ⇒ String
The description for the destination Sql tuning set.
-
#destination_sql_tuning_set_name ⇒ String
[Required] The name of the destination Sql tuning set.
-
#destination_sql_tuning_set_owner ⇒ String
Owner of the destination Sql tuning set.
-
#is_ignore_null ⇒ BOOLEAN
Specifies whether to update attributes when the new value is NULL.
-
#load_option ⇒ String
Specifies which statements are loaded into the Sql tuning set.
-
#name ⇒ String
[Required] The name of the Sql tuning set.
-
#owner ⇒ String
The owner of the Sql tuning set.
-
#plan_filter ⇒ String
Specifies the plan filter.
-
#ranking_measure1 ⇒ String
Specifies an ORDER BY clause on the selected Sql.
-
#ranking_measure2 ⇒ String
Specifies an ORDER BY clause on the selected Sql.
-
#ranking_measure3 ⇒ String
Specifies an ORDER BY clause on the selected Sql.
-
#recursive_sql ⇒ String
Specifies that the filter must include recursive Sql in the Sql tuning set.
-
#result_limit ⇒ Integer
The top limit Sql from the filtered source, ranked by the ranking measure.
-
#result_percentage ⇒ Float
Specifies a filter that picks the top n% according to the supplied ranking measure.
-
#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.
-
#update_attributes ⇒ String
Specifies the list of Sql statement attributes to update during a merge or update.
-
#update_condition ⇒ String
Specifies when to perform the update.
-
#update_option ⇒ String
Specifies how existing Sql statements are updated.
Class Method Summary collapse
-
.attribute_map ⇒ Object
Attribute mapping from ruby-style variable name to JSON key.
-
.swagger_types ⇒ Object
Attribute type mapping.
Instance Method Summary collapse
-
#==(other) ⇒ Object
Checks equality by comparing each attribute.
-
#build_from_hash(attributes) ⇒ Object
Builds the object from hash.
- #eql?(other) ⇒ Boolean
-
#hash ⇒ Fixnum
Calculates hash code according to all attributes.
-
#initialize(attributes = {}) ⇒ SaveSqlTuningSetAsDetails
constructor
Initializes the object.
-
#to_hash ⇒ Hash
Returns the object in the form of hash.
-
#to_s ⇒ String
Returns the string representation of the object.
Constructor Details
#initialize(attributes = {}) ⇒ SaveSqlTuningSetAsDetails
Initializes the object
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"
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
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.
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
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.
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.
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.
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.
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
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.
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.
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.
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
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.
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.
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.
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.
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.
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.
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.
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"
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.
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
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.
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
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
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.
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
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
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 |