// 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);
}
})();