# This is an automatically generated code sample.
# To make this code sample work in your Oracle Cloud tenancy,
# please replace the values for any parameters whose current values do not fit
# your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
# boolean, number, and enum parameters with values not fitting your use case).
require 'oci'
require 'date'
# Create a default config using DEFAULT profile in default location
# Refer to https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File for more info
config = OCI::ConfigFileLoader.load_config
# Initialize service client with default config file
opsi_client = OCI::Opsi::OperationsInsightsClient.new(config: config)
# Send the request to service, some parameters are not required, see API doc for more info
ingest_sql_stats_response =
opsi_client.ingest_sql_stats(
OCI::Opsi::Models::IngestSqlStatsDetails.new(
items: [
OCI::Opsi::Models::SqlStats.new(
sql_identifier: 'EXAMPLE-sqlIdentifier-Value',
plan_hash_value: 894,
time_collected: DateTime.parse('2005-07-25T21:22:11.652Z'),
instance_name: 'EXAMPLE-instanceName-Value',
last_active_time: 'EXAMPLE-lastActiveTime-Value',
parse_calls: 360,
disk_reads: 267,
direct_reads: 479,
direct_writes: 776,
buffer_gets: 256,
rows_processed: 343,
serializable_aborts: 550,
fetches: 816,
executions: 25,
avoided_executions: 95,
end_of_fetch_count: 947,
loads: 731,
version_count: 341,
invalidations: 499,
obsolete_count: 604,
px_servers_executions: 292,
cpu_time_in_us: 498,
elapsed_time_in_us: 685,
avg_hard_parse_time_in_us: 170,
concurrency_wait_time_in_us: 804,
application_wait_time_in_us: 276,
cluster_wait_time_in_us: 402,
user_io_wait_time_in_us: 642,
plsql_exec_time_in_us: 209,
java_exec_time_in_us: 923,
sorts: 629,
sharable_mem: 996,
total_sharable_mem: 236,
type_check_mem: 982,
io_cell_offload_eligible_bytes: 337,
io_interconnect_bytes: 909,
physical_read_requests: 425,
physical_read_bytes: 542,
physical_write_requests: 707,
physical_write_bytes: 333,
exact_matching_signature: 'EXAMPLE-exactMatchingSignature-Value',
force_matching_signature: 'EXAMPLE-forceMatchingSignature-Value',
io_cell_uncompressed_bytes: 129,
io_cell_offload_returned_bytes: 201,
child_number: 645,
command_type: 711,
users_opening: 554,
users_executing: 651,
optimizer_cost: 999,
full_plan_hash_value: 'EXAMPLE-fullPlanHashValue-Value',
module: 'EXAMPLE-module-Value',
service: 'EXAMPLE-service-Value',
action: 'EXAMPLE-action-Value',
sql_profile: 'EXAMPLE-sqlProfile-Value',
sql_patch: 'EXAMPLE-sqlPatch-Value',
sql_plan_baseline: 'EXAMPLE-sqlPlanBaseline-Value',
delta_execution_count: 112,
delta_cpu_time: 443,
delta_io_bytes: 345,
delta_cpu_rank: 749,
delta_execs_rank: 394,
sharable_mem_rank: 320,
delta_io_rank: 146,
harmonic_sum: 332,
wt_harmonic_sum: 802,
total_sql_count: 45
)
]
)
)
# Get the data from response
puts "#{ingest_sql_stats_response.data}"