// 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).
package main
import (
"context"
"fmt"
"time"
"github.com/oracle/oci-go-sdk/v65/common"
"github.com/oracle/oci-go-sdk/v65/example/helpers"
"github.com/oracle/oci-go-sdk/v65/opsi"
)
func ExampleIngestSqlStats() {
// 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.
client, err := opsi.NewOperationsInsightsClientWithConfigurationProvider(common.DefaultConfigProvider())
helpers.FatalIfError(err)
// Create a request and dependent object(s).
req := opsi.IngestSqlStatsRequest{DatabaseId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-databaseId-Value"),
Id: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-id-Value"),
IfMatch: common.String("EXAMPLE-ifMatch-Value"),
IngestSqlStatsDetails: opsi.IngestSqlStatsDetails{Items: []opsi.SqlStats{opsi.SqlStats{ExactMatchingSignature: common.String("EXAMPLE-exactMatchingSignature-Value"),
HarmonicSum: common.Int64(332),
PhysicalReadRequests: common.Int64(425),
TotalSharableMem: common.Int64(236),
VersionCount: common.Int64(341),
EndOfFetchCount: common.Int64(947),
ChildNumber: common.Int64(645),
CommandType: common.Int64(711),
DirectWrites: common.Int64(776),
Sorts: common.Int64(629),
SqlPatch: common.String("EXAMPLE-sqlPatch-Value"),
TimeCollected: &common.SDKTime{Time: time.Now()},
AvoidedExecutions: common.Int64(95),
Executions: common.Int64(25),
IoCellUncompressedBytes: common.Int64(129),
JavaExecTimeInUs: common.Int64(923),
ParseCalls: common.Int64(360),
SerializableAborts: common.Int64(550),
WtHarmonicSum: common.Int64(802),
DiskReads: common.Int64(267),
BufferGets: common.Int64(256),
DeltaIoRank: common.Int64(146),
ForceMatchingSignature: common.String("EXAMPLE-forceMatchingSignature-Value"),
TypeCheckMem: common.Int64(982),
UsersExecuting: common.Int64(651),
AvgHardParseTimeInUs: common.Int64(170),
PlanHashValue: common.Int64(894),
DeltaExecutionCount: common.Int64(112),
DirectReads: common.Int64(479),
IoCellOffloadEligibleBytes: common.Int64(337),
Module: common.String("EXAMPLE-module-Value"),
RowsProcessed: common.Int64(343),
DeltaIoBytes: common.Int64(345),
LastActiveTime: common.String("EXAMPLE-lastActiveTime-Value"),
ObsoleteCount: common.Int64(604),
OptimizerCost: common.Int64(999),
PhysicalWriteRequests: common.Int64(707),
CpuTimeInUs: common.Int64(498),
Loads: common.Int64(731),
PxServersExecutions: common.Int64(292),
IoInterconnectBytes: common.Int64(909),
ConcurrencyWaitTimeInUs: common.Int64(804),
DeltaCpuRank: common.Int64(749),
DeltaCpuTime: common.Int64(443),
PlsqlExecTimeInUs: common.Int64(209),
SharableMemRank: common.Int64(320),
TotalSqlCount: common.Int64(45),
ApplicationWaitTimeInUs: common.Int64(276),
Action: common.String("EXAMPLE-action-Value"),
InstanceName: common.String("EXAMPLE-instanceName-Value"),
IoCellOffloadReturnedBytes: common.Int64(201),
SqlIdentifier: common.String("EXAMPLE-sqlIdentifier-Value"),
SqlProfile: common.String("EXAMPLE-sqlProfile-Value"),
UsersOpening: common.Int64(554),
FullPlanHashValue: common.String("EXAMPLE-fullPlanHashValue-Value"),
DeltaExecsRank: common.Int64(394),
PhysicalWriteBytes: common.Int64(333),
SqlPlanBaseline: common.String("EXAMPLE-sqlPlanBaseline-Value"),
Invalidations: common.Int64(499),
PhysicalReadBytes: common.Int64(542),
Fetches: common.Int64(816),
Service: common.String("EXAMPLE-service-Value"),
SharableMem: common.Int64(996),
ElapsedTimeInUs: common.Int64(685),
UserIoWaitTimeInUs: common.Int64(642),
ClusterWaitTimeInUs: common.Int64(402)}}},
OpcRequestId: common.String("5OTJHHKZBBZO3DGMSYBI<unique_ID>"),
OpcRetryToken: common.String("EXAMPLE-opcRetryToken-Value")}
// Send the request using the service client
resp, err := client.IngestSqlStats(context.Background(), req)
helpers.FatalIfError(err)
// Retrieve value from the response.
fmt.Println(resp)
}