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
|