// 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).

import * as opsi from "oci-opsi";
import common = require("oci-common");

// Create a default authentication provider that uses the DEFAULT
// profile in the configuration file.
// Refer to <see href="https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File>the public documentation</see> on how to prepare a configuration file.

const provider: common.ConfigFileAuthenticationDetailsProvider = new common.ConfigFileAuthenticationDetailsProvider();

(async () => {
  try {
    // Create a service client
    const client = new opsi.OperationsInsightsClient({ authenticationDetailsProvider: provider });

    // Create a request and dependent object(s).
    const ingestSqlStatsDetails = {
      items: [
        {
          sqlIdentifier: "EXAMPLE-sqlIdentifier-Value",
          planHashValue: 894,
          timeCollected: new Date("Mon Jul 25 21:22:11 UTC 2005"),
          instanceName: "EXAMPLE-instanceName-Value",
          lastActiveTime: "EXAMPLE-lastActiveTime-Value",
          parseCalls: 360,
          diskReads: 267,
          directReads: 479,
          directWrites: 776,
          bufferGets: 256,
          rowsProcessed: 343,
          serializableAborts: 550,
          fetches: 816,
          executions: 25,
          avoidedExecutions: 95,
          endOfFetchCount: 947,
          loads: 731,
          versionCount: 341,
          invalidations: 499,
          obsoleteCount: 604,
          pxServersExecutions: 292,
          cpuTimeInUs: 498,
          elapsedTimeInUs: 685,
          avgHardParseTimeInUs: 170,
          concurrencyWaitTimeInUs: 804,
          applicationWaitTimeInUs: 276,
          clusterWaitTimeInUs: 402,
          userIoWaitTimeInUs: 642,
          plsqlExecTimeInUs: 209,
          javaExecTimeInUs: 923,
          sorts: 629,
          sharableMem: 996,
          totalSharableMem: 236,
          typeCheckMem: 982,
          ioCellOffloadEligibleBytes: 337,
          ioInterconnectBytes: 909,
          physicalReadRequests: 425,
          physicalReadBytes: 542,
          physicalWriteRequests: 707,
          physicalWriteBytes: 333,
          exactMatchingSignature: "EXAMPLE-exactMatchingSignature-Value",
          forceMatchingSignature: "EXAMPLE-forceMatchingSignature-Value",
          ioCellUncompressedBytes: 129,
          ioCellOffloadReturnedBytes: 201,
          childNumber: 645,
          commandType: 711,
          usersOpening: 554,
          usersExecuting: 651,
          optimizerCost: 999,
          fullPlanHashValue: "EXAMPLE-fullPlanHashValue-Value",
          module: "EXAMPLE-module-Value",
          service: "EXAMPLE-service-Value",
          action: "EXAMPLE-action-Value",
          sqlProfile: "EXAMPLE-sqlProfile-Value",
          sqlPatch: "EXAMPLE-sqlPatch-Value",
          sqlPlanBaseline: "EXAMPLE-sqlPlanBaseline-Value",
          deltaExecutionCount: 112,
          deltaCpuTime: 443,
          deltaIoBytes: 345,
          deltaCpuRank: 749,
          deltaExecsRank: 394,
          sharableMemRank: 320,
          deltaIoRank: 146,
          harmonicSum: 332,
          wtHarmonicSum: 802,
          totalSqlCount: 45
        }
      ]
    };

    const ingestSqlStatsRequest: opsi.requests.IngestSqlStatsRequest = {
      ingestSqlStatsDetails: ingestSqlStatsDetails,
      databaseId: "ocid1.test.oc1..<unique_ID>EXAMPLE-databaseId-Value",
      id: "ocid1.test.oc1..<unique_ID>EXAMPLE-id-Value",
      opcRequestId: "5OTJHHKZBBZO3DGMSYBI<unique_ID>",
      ifMatch: "EXAMPLE-ifMatch-Value",
      opcRetryToken: "EXAMPLE-opcRetryToken-Value"
    };

    // Send request to the Client.
    const ingestSqlStatsResponse = await client.ingestSqlStats(ingestSqlStatsRequest);
  } catch (error) {
    console.log("ingestSqlStats Failed with error  " + error);
  }
})();