Uses of Class
com.oracle.bmc.opsi.model.SqlStats.Builder

Packages that use SqlStats.Builder

Package	Description
com.oracle.bmc.opsi.model

Uses of SqlStats.Builder in com.oracle.bmc.opsi.model

Methods in com.oracle.bmc.opsi.model that return SqlStats.Builder

Modifier and Type	Method and Description
SqlStats.Builder	SqlStats.Builder.action(String action) Contains the name of the action that was executing when the SQL statement was first parsed, which is set by calling DBMS_APPLICATION_INFO.SET_ACTION
SqlStats.Builder	SqlStats.Builder.applicationWaitTimeInUs(Long applicationWaitTimeInUs) Application wait time (in microseconds)
SqlStats.Builder	SqlStats.Builder.avgHardParseTimeInUs(Long avgHardParseTimeInUs) Average hard parse time (in microseconds) used by this cursor
SqlStats.Builder	SqlStats.Builder.avoidedExecutions(Long avoidedExecutions) Number of executions attempted on this object, but prevented due to the SQL statement being in quarantine
SqlStats.Builder	SqlStats.Builder.bufferGets(Long bufferGets) Number of Buffer Gets
static SqlStats.Builder	SqlStats.builder() Create a new builder.
SqlStats.Builder	SqlStats.Builder.childNumber(Long childNumber) Number of this child cursor
SqlStats.Builder	SqlStats.Builder.clusterWaitTimeInUs(Long clusterWaitTimeInUs) Cluster wait time (in microseconds).
SqlStats.Builder	SqlStats.Builder.commandType(Long commandType) Oracle command type definition
SqlStats.Builder	SqlStats.Builder.concurrencyWaitTimeInUs(Long concurrencyWaitTimeInUs) Concurrency wait time (in microseconds)
SqlStats.Builder	SqlStats.Builder.copy(SqlStats model)
SqlStats.Builder	SqlStats.Builder.cpuTimeInUs(Long cpuTimeInUs) CPU time (in microseconds) used by this cursor for parsing, executing, and fetching
SqlStats.Builder	SqlStats.Builder.deltaCpuRank(Long deltaCpuRank) Rank based on CPU Consumption
SqlStats.Builder	SqlStats.Builder.deltaCpuTime(Long deltaCpuTime) CPU time (in microseconds) for the cursor since the last AWR snapshot
SqlStats.Builder	SqlStats.Builder.deltaExecsRank(Long deltaExecsRank) Rank based on number of execution
SqlStats.Builder	SqlStats.Builder.deltaExecutionCount(Long deltaExecutionCount) Number of executions for the cursor since the last AWR snapshot
SqlStats.Builder	SqlStats.Builder.deltaIoBytes(Long deltaIoBytes) Number of I/O bytes exchanged between the Oracle database and the storage system for the cursor since the last AWR snapshot
SqlStats.Builder	SqlStats.Builder.deltaIoRank(Long deltaIoRank) Rank based on I/O Consumption
SqlStats.Builder	SqlStats.Builder.directReads(Long directReads) Number of direct reads
SqlStats.Builder	SqlStats.Builder.directWrites(Long directWrites) Number of Direct writes
SqlStats.Builder	SqlStats.Builder.diskReads(Long diskReads) Number of disk reads
SqlStats.Builder	SqlStats.Builder.elapsedTimeInUs(Long elapsedTimeInUs) Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching.
SqlStats.Builder	SqlStats.Builder.endOfFetchCount(Long endOfFetchCount) Number of times this cursor was fully executed since the cursor was brought into the library cache
SqlStats.Builder	SqlStats.Builder.exactMatchingSignature(String exactMatchingSignature) exact_matching_signature Example: "18067345456756876713"
SqlStats.Builder	SqlStats.Builder.executions(Long executions) Number of executions
SqlStats.Builder	SqlStats.Builder.fetches(Long fetches) Number of fetches
SqlStats.Builder	SqlStats.Builder.forceMatchingSignature(String forceMatchingSignature) force_matching_signature Example: "18067345456756876713"
SqlStats.Builder	SqlStats.Builder.fullPlanHashValue(String fullPlanHashValue) Total Number of rows in SQLStats table
SqlStats.Builder	SqlStats.Builder.harmonicSum(Long harmonicSum) Harmonic sum based on ranking parameters
SqlStats.Builder	SqlStats.Builder.instanceName(String instanceName) Name of Database Instance Example: "DB10902_1"
SqlStats.Builder	SqlStats.Builder.invalidations(Long invalidations) Number of times this child cursor has been invalidated
SqlStats.Builder	SqlStats.Builder.ioCellOffloadEligibleBytes(Long ioCellOffloadEligibleBytes) Number of I/O bytes which can be filtered by the Exadata storage system
SqlStats.Builder	SqlStats.Builder.ioCellOffloadReturnedBytes(Long ioCellOffloadReturnedBytes) Number of bytes that are returned by Exadata cell through the regular I/O path
SqlStats.Builder	SqlStats.Builder.ioCellUncompressedBytes(Long ioCellUncompressedBytes) Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cells
SqlStats.Builder	SqlStats.Builder.ioInterconnectBytes(Long ioInterconnectBytes) Number of I/O bytes exchanged between Oracle Database and the storage system.
SqlStats.Builder	SqlStats.Builder.javaExecTimeInUs(Long javaExecTimeInUs) Java execution time (in microseconds)
SqlStats.Builder	SqlStats.Builder.lastActiveTime(String lastActiveTime) last_active_time Example: "0000000099CCE300"
SqlStats.Builder	SqlStats.Builder.loads(Long loads) Number of times the object was either loaded or reloaded
SqlStats.Builder	SqlStats.Builder.module(String module) Module name
SqlStats.Builder	SqlStats.Builder.obsoleteCount(Long obsoleteCount) Number of times that a parent cursor became obsolete
SqlStats.Builder	SqlStats.Builder.optimizerCost(Long optimizerCost) Cost of this query given by the optimizer
SqlStats.Builder	SqlStats.Builder.parseCalls(Long parseCalls) Total integer of parse calls Example: 60
SqlStats.Builder	SqlStats.Builder.physicalReadBytes(Long physicalReadBytes) Number of bytes read from disks by the monitored SQL
SqlStats.Builder	SqlStats.Builder.physicalReadRequests(Long physicalReadRequests) Number of physical read I/O requests issued by the monitored SQL.
SqlStats.Builder	SqlStats.Builder.physicalWriteBytes(Long physicalWriteBytes) Number of bytes written to disks by the monitored SQL
SqlStats.Builder	SqlStats.Builder.physicalWriteRequests(Long physicalWriteRequests) Number of physical write I/O requests issued by the monitored SQL
SqlStats.Builder	SqlStats.Builder.planHashValue(Long planHashValue) Plan hash value for the SQL Execution Plan
SqlStats.Builder	SqlStats.Builder.plsqlExecTimeInUs(Long plsqlExecTimeInUs) PL/SQL execution time (in microseconds)
SqlStats.Builder	SqlStats.Builder.pxServersExecutions(Long pxServersExecutions) Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel)
SqlStats.Builder	SqlStats.Builder.rowsProcessed(Long rowsProcessed) Number of row processed
SqlStats.Builder	SqlStats.Builder.serializableAborts(Long serializableAborts) Number of serializable aborts
SqlStats.Builder	SqlStats.Builder.service(String service) Service name
SqlStats.Builder	SqlStats.Builder.sharableMem(Long sharableMem) Total shared memory (in bytes) currently occupied by all cursors with this SQL text and plan
SqlStats.Builder	SqlStats.Builder.sharableMemRank(Long sharableMemRank) Rank based on sharable memory
SqlStats.Builder	SqlStats.Builder.sorts(Long sorts) Number of sorts that were done for the child cursor
SqlStats.Builder	SqlStats.Builder.sqlIdentifier(String sqlIdentifier) Unique SQL_ID for a SQL Statement.
SqlStats.Builder	SqlStats.Builder.sqlPatch(String sqlPatch) SQL patch used for this statement, if any
SqlStats.Builder	SqlStats.Builder.sqlPlanBaseline(String sqlPlanBaseline) SQL plan baseline used for this statement, if any
SqlStats.Builder	SqlStats.Builder.sqlProfile(String sqlProfile) SQL profile used for this statement, if any
SqlStats.Builder	SqlStats.Builder.timeCollected(Date timeCollected) Collection timestamp Example: "2020-03-31T00:00:00.000Z"
SqlStats.Builder	SqlStats.toBuilder()
SqlStats.Builder	SqlStats.Builder.totalSharableMem(Long totalSharableMem) Total shared memory (in bytes) occupied by all cursors with this SQL text and plan if they were to be fully loaded in the shared pool (that is, cursor size)
SqlStats.Builder	SqlStats.Builder.totalSqlCount(Long totalSqlCount) Total number of rows in SQLStats table
SqlStats.Builder	SqlStats.Builder.typeCheckMem(Long typeCheckMem) Typecheck memory
SqlStats.Builder	SqlStats.Builder.userIoWaitTimeInUs(Long userIoWaitTimeInUs) User I/O wait time (in microseconds)
SqlStats.Builder	SqlStats.Builder.usersExecuting(Long usersExecuting) Number of users executing the statement
SqlStats.Builder	SqlStats.Builder.usersOpening(Long usersOpening) Number of users that have any of the child cursors open
SqlStats.Builder	SqlStats.Builder.versionCount(Long versionCount) Number of cursors present in the cache with this SQL text and plan
SqlStats.Builder	SqlStats.Builder.wtHarmonicSum(Long wtHarmonicSum) Weight based harmonic sum of ranking parameters