@Generated(value="OracleSDKGenerator",
comments="API Version: 20200630")
public final class SqlStats
extends com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
Sql Stats type object.
Note: Objects should always be created or deserialized using the SqlStats.Builder. This model
distinguishes fields that are null because they are unset from fields that are explicitly
set to null. This is done in the setter methods of the SqlStats.Builder, which maintain a
set of all explicitly set fields called SqlStats.Builder.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take the explicitly set
fields into account. The constructor, on the other hand, does not take the explicitly set fields
into account (since the constructor cannot distinguish explicit null from unset null).
| Modifier and Type | Class and Description |
|---|---|
static class |
SqlStats.Builder |
EXPLICITLY_SET_FILTER_NAME, EXPLICITLY_SET_PROPERTY_NAME| Constructor and Description |
|---|
SqlStats(String sqlIdentifier,
Long planHashValue,
Date timeCollected,
String instanceName,
String lastActiveTime,
Long parseCalls,
Long diskReads,
Long directReads,
Long directWrites,
Long bufferGets,
Long rowsProcessed,
Long serializableAborts,
Long fetches,
Long executions,
Long avoidedExecutions,
Long endOfFetchCount,
Long loads,
Long versionCount,
Long invalidations,
Long obsoleteCount,
Long pxServersExecutions,
Long cpuTimeInUs,
Long elapsedTimeInUs,
Long avgHardParseTimeInUs,
Long concurrencyWaitTimeInUs,
Long applicationWaitTimeInUs,
Long clusterWaitTimeInUs,
Long userIoWaitTimeInUs,
Long plsqlExecTimeInUs,
Long javaExecTimeInUs,
Long sorts,
Long sharableMem,
Long totalSharableMem,
Long typeCheckMem,
Long ioCellOffloadEligibleBytes,
Long ioInterconnectBytes,
Long physicalReadRequests,
Long physicalReadBytes,
Long physicalWriteRequests,
Long physicalWriteBytes,
String exactMatchingSignature,
String forceMatchingSignature,
Long ioCellUncompressedBytes,
Long ioCellOffloadReturnedBytes,
Long childNumber,
Long commandType,
Long usersOpening,
Long usersExecuting,
Long optimizerCost,
String fullPlanHashValue,
String module,
String service,
String action,
String sqlProfile,
String sqlPatch,
String sqlPlanBaseline,
Long deltaExecutionCount,
Long deltaCpuTime,
Long deltaIoBytes,
Long deltaCpuRank,
Long deltaExecsRank,
Long sharableMemRank,
Long deltaIoRank,
Long harmonicSum,
Long wtHarmonicSum,
Long totalSqlCount)
Deprecated.
|
| Modifier and Type | Method and Description |
|---|---|
static SqlStats.Builder |
builder()
Create a new builder.
|
boolean |
equals(Object o) |
String |
getAction()
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
|
Long |
getApplicationWaitTimeInUs()
Application wait time (in microseconds)
|
Long |
getAvgHardParseTimeInUs()
Average hard parse time (in microseconds) used by this cursor
|
Long |
getAvoidedExecutions()
Number of executions attempted on this object, but prevented due to the SQL statement being
in quarantine
|
Long |
getBufferGets()
Number of Buffer Gets
|
Long |
getChildNumber()
Number of this child cursor
|
Long |
getClusterWaitTimeInUs()
Cluster wait time (in microseconds).
|
Long |
getCommandType()
Oracle command type definition
|
Long |
getConcurrencyWaitTimeInUs()
Concurrency wait time (in microseconds)
|
Long |
getCpuTimeInUs()
CPU time (in microseconds) used by this cursor for parsing, executing, and fetching
|
Long |
getDeltaCpuRank()
Rank based on CPU Consumption
|
Long |
getDeltaCpuTime()
CPU time (in microseconds) for the cursor since the last AWR snapshot
|
Long |
getDeltaExecsRank()
Rank based on number of execution
|
Long |
getDeltaExecutionCount()
Number of executions for the cursor since the last AWR snapshot
|
Long |
getDeltaIoBytes()
Number of I/O bytes exchanged between the Oracle database and the storage system for the
cursor since the last AWR snapshot
|
Long |
getDeltaIoRank()
Rank based on I/O Consumption
|
Long |
getDirectReads()
Number of direct reads
|
Long |
getDirectWrites()
Number of Direct writes
|
Long |
getDiskReads()
Number of disk reads
|
Long |
getElapsedTimeInUs()
Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching.
|
Long |
getEndOfFetchCount()
Number of times this cursor was fully executed since the cursor was brought into the library
cache
|
String |
getExactMatchingSignature()
exact_matching_signature Example:
"18067345456756876713" |
Long |
getExecutions()
Number of executions
|
Long |
getFetches()
Number of fetches
|
String |
getForceMatchingSignature()
force_matching_signature Example:
"18067345456756876713" |
String |
getFullPlanHashValue()
Total Number of rows in SQLStats table
|
Long |
getHarmonicSum()
Harmonic sum based on ranking parameters
|
String |
getInstanceName()
Name of Database Instance Example:
"DB10902_1" |
Long |
getInvalidations()
Number of times this child cursor has been invalidated
|
Long |
getIoCellOffloadEligibleBytes()
Number of I/O bytes which can be filtered by the Exadata storage system
|
Long |
getIoCellOffloadReturnedBytes()
Number of bytes that are returned by Exadata cell through the regular I/O path
|
Long |
getIoCellUncompressedBytes()
Number of uncompressed bytes (that is, size after decompression) that are offloaded to the
Exadata cells
|
Long |
getIoInterconnectBytes()
Number of I/O bytes exchanged between Oracle Database and the storage system.
|
Long |
getJavaExecTimeInUs()
Java execution time (in microseconds)
|
String |
getLastActiveTime()
last_active_time Example:
"0000000099CCE300" |
Long |
getLoads()
Number of times the object was either loaded or reloaded
|
String |
getModule()
Module name
|
Long |
getObsoleteCount()
Number of times that a parent cursor became obsolete
|
Long |
getOptimizerCost()
Cost of this query given by the optimizer
|
Long |
getParseCalls()
Total integer of parse calls Example:
60 |
Long |
getPhysicalReadBytes()
Number of bytes read from disks by the monitored SQL
|
Long |
getPhysicalReadRequests()
Number of physical read I/O requests issued by the monitored SQL.
|
Long |
getPhysicalWriteBytes()
Number of bytes written to disks by the monitored SQL
|
Long |
getPhysicalWriteRequests()
Number of physical write I/O requests issued by the monitored SQL
|
Long |
getPlanHashValue()
Plan hash value for the SQL Execution Plan
|
Long |
getPlsqlExecTimeInUs()
PL/SQL execution time (in microseconds)
|
Long |
getPxServersExecutions()
Total number of executions performed by parallel execution servers (0 when the statement has
never been executed in parallel)
|
Long |
getRowsProcessed()
Number of row processed
|
Long |
getSerializableAborts()
Number of serializable aborts
|
String |
getService()
Service name
|
Long |
getSharableMem()
Total shared memory (in bytes) currently occupied by all cursors with this SQL text and plan
|
Long |
getSharableMemRank()
Rank based on sharable memory
|
Long |
getSorts()
Number of sorts that were done for the child cursor
|
String |
getSqlIdentifier()
Unique SQL_ID for a SQL Statement.
|
String |
getSqlPatch()
SQL patch used for this statement, if any
|
String |
getSqlPlanBaseline()
SQL plan baseline used for this statement, if any
|
String |
getSqlProfile()
SQL profile used for this statement, if any
|
Date |
getTimeCollected()
Collection timestamp Example:
"2020-03-31T00:00:00.000Z" |
Long |
getTotalSharableMem()
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)
|
Long |
getTotalSqlCount()
Total number of rows in SQLStats table
|
Long |
getTypeCheckMem()
Typecheck memory
|
Long |
getUserIoWaitTimeInUs()
User I/O wait time (in microseconds)
|
Long |
getUsersExecuting()
Number of users executing the statement
|
Long |
getUsersOpening()
Number of users that have any of the child cursors open
|
Long |
getVersionCount()
Number of cursors present in the cache with this SQL text and plan
|
Long |
getWtHarmonicSum()
Weight based harmonic sum of ranking parameters
|
int |
hashCode() |
SqlStats.Builder |
toBuilder() |
String |
toString() |
String |
toString(boolean includeByteArrayContents)
Return a string representation of the object.
|
markPropertyAsExplicitlySet, wasPropertyExplicitlySet@Deprecated @ConstructorProperties(value={"sqlIdentifier","planHashValue","timeCollected","instanceName","lastActiveTime","parseCalls","diskReads","directReads","directWrites","bufferGets","rowsProcessed","serializableAborts","fetches","executions","avoidedExecutions","endOfFetchCount","loads","versionCount","invalidations","obsoleteCount","pxServersExecutions","cpuTimeInUs","elapsedTimeInUs","avgHardParseTimeInUs","concurrencyWaitTimeInUs","applicationWaitTimeInUs","clusterWaitTimeInUs","userIoWaitTimeInUs","plsqlExecTimeInUs","javaExecTimeInUs","sorts","sharableMem","totalSharableMem","typeCheckMem","ioCellOffloadEligibleBytes","ioInterconnectBytes","physicalReadRequests","physicalReadBytes","physicalWriteRequests","physicalWriteBytes","exactMatchingSignature","forceMatchingSignature","ioCellUncompressedBytes","ioCellOffloadReturnedBytes","childNumber","commandType","usersOpening","usersExecuting","optimizerCost","fullPlanHashValue","module","service","action","sqlProfile","sqlPatch","sqlPlanBaseline","deltaExecutionCount","deltaCpuTime","deltaIoBytes","deltaCpuRank","deltaExecsRank","sharableMemRank","deltaIoRank","harmonicSum","wtHarmonicSum","totalSqlCount"}) public SqlStats(String sqlIdentifier, Long planHashValue, Date timeCollected, String instanceName, String lastActiveTime, Long parseCalls, Long diskReads, Long directReads, Long directWrites, Long bufferGets, Long rowsProcessed, Long serializableAborts, Long fetches, Long executions, Long avoidedExecutions, Long endOfFetchCount, Long loads, Long versionCount, Long invalidations, Long obsoleteCount, Long pxServersExecutions, Long cpuTimeInUs, Long elapsedTimeInUs, Long avgHardParseTimeInUs, Long concurrencyWaitTimeInUs, Long applicationWaitTimeInUs, Long clusterWaitTimeInUs, Long userIoWaitTimeInUs, Long plsqlExecTimeInUs, Long javaExecTimeInUs, Long sorts, Long sharableMem, Long totalSharableMem, Long typeCheckMem, Long ioCellOffloadEligibleBytes, Long ioInterconnectBytes, Long physicalReadRequests, Long physicalReadBytes, Long physicalWriteRequests, Long physicalWriteBytes, String exactMatchingSignature, String forceMatchingSignature, Long ioCellUncompressedBytes, Long ioCellOffloadReturnedBytes, Long childNumber, Long commandType, Long usersOpening, Long usersExecuting, Long optimizerCost, String fullPlanHashValue, String module, String service, String action, String sqlProfile, String sqlPatch, String sqlPlanBaseline, Long deltaExecutionCount, Long deltaCpuTime, Long deltaIoBytes, Long deltaCpuRank, Long deltaExecsRank, Long sharableMemRank, Long deltaIoRank, Long harmonicSum, Long wtHarmonicSum, Long totalSqlCount)
public static SqlStats.Builder builder()
Create a new builder.
public SqlStats.Builder toBuilder()
public String getSqlIdentifier()
Unique SQL_ID for a SQL Statement.
public Long getPlanHashValue()
Plan hash value for the SQL Execution Plan
public Date getTimeCollected()
Collection timestamp Example: "2020-03-31T00:00:00.000Z"
public String getInstanceName()
Name of Database Instance Example: "DB10902_1"
public String getLastActiveTime()
last_active_time Example: "0000000099CCE300"
public Long getParseCalls()
Total integer of parse calls Example: 60
public Long getDiskReads()
Number of disk reads
public Long getDirectReads()
Number of direct reads
public Long getDirectWrites()
Number of Direct writes
public Long getBufferGets()
Number of Buffer Gets
public Long getRowsProcessed()
Number of row processed
public Long getSerializableAborts()
Number of serializable aborts
public Long getFetches()
Number of fetches
public Long getExecutions()
Number of executions
public Long getAvoidedExecutions()
Number of executions attempted on this object, but prevented due to the SQL statement being in quarantine
public Long getEndOfFetchCount()
Number of times this cursor was fully executed since the cursor was brought into the library cache
public Long getLoads()
Number of times the object was either loaded or reloaded
public Long getVersionCount()
Number of cursors present in the cache with this SQL text and plan
public Long getInvalidations()
Number of times this child cursor has been invalidated
public Long getObsoleteCount()
Number of times that a parent cursor became obsolete
public Long getPxServersExecutions()
Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel)
public Long getCpuTimeInUs()
CPU time (in microseconds) used by this cursor for parsing, executing, and fetching
public Long getElapsedTimeInUs()
Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching.
public Long getAvgHardParseTimeInUs()
Average hard parse time (in microseconds) used by this cursor
public Long getConcurrencyWaitTimeInUs()
Concurrency wait time (in microseconds)
public Long getApplicationWaitTimeInUs()
Application wait time (in microseconds)
public Long getClusterWaitTimeInUs()
Cluster wait time (in microseconds). This value is specific to Oracle RAC
public Long getUserIoWaitTimeInUs()
User I/O wait time (in microseconds)
public Long getPlsqlExecTimeInUs()
PL/SQL execution time (in microseconds)
public Long getJavaExecTimeInUs()
Java execution time (in microseconds)
public Long getSorts()
Number of sorts that were done for the child cursor
public Long getSharableMem()
Total shared memory (in bytes) currently occupied by all cursors with this SQL text and plan
public Long getTotalSharableMem()
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)
public Long getTypeCheckMem()
Typecheck memory
public Long getIoCellOffloadEligibleBytes()
Number of I/O bytes which can be filtered by the Exadata storage system
public Long getIoInterconnectBytes()
Number of I/O bytes exchanged between Oracle Database and the storage system. Typically used for Cache Fusion or parallel queries
public Long getPhysicalReadRequests()
Number of physical read I/O requests issued by the monitored SQL. The requests may not be disk reads
public Long getPhysicalReadBytes()
Number of bytes read from disks by the monitored SQL
public Long getPhysicalWriteRequests()
Number of physical write I/O requests issued by the monitored SQL
public Long getPhysicalWriteBytes()
Number of bytes written to disks by the monitored SQL
public String getExactMatchingSignature()
exact_matching_signature Example: "18067345456756876713"
public String getForceMatchingSignature()
force_matching_signature Example: "18067345456756876713"
public Long getIoCellUncompressedBytes()
Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cells
public Long getIoCellOffloadReturnedBytes()
Number of bytes that are returned by Exadata cell through the regular I/O path
public Long getChildNumber()
Number of this child cursor
public Long getCommandType()
Oracle command type definition
public Long getUsersOpening()
Number of users that have any of the child cursors open
public Long getUsersExecuting()
Number of users executing the statement
public Long getOptimizerCost()
Cost of this query given by the optimizer
public String getFullPlanHashValue()
Total Number of rows in SQLStats table
public String getModule()
Module name
public String getService()
Service name
public String getAction()
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
public String getSqlProfile()
SQL profile used for this statement, if any
public String getSqlPatch()
SQL patch used for this statement, if any
public String getSqlPlanBaseline()
SQL plan baseline used for this statement, if any
public Long getDeltaExecutionCount()
Number of executions for the cursor since the last AWR snapshot
public Long getDeltaCpuTime()
CPU time (in microseconds) for the cursor since the last AWR snapshot
public Long getDeltaIoBytes()
Number of I/O bytes exchanged between the Oracle database and the storage system for the cursor since the last AWR snapshot
public Long getDeltaCpuRank()
Rank based on CPU Consumption
public Long getDeltaExecsRank()
Rank based on number of execution
public Long getSharableMemRank()
Rank based on sharable memory
public Long getDeltaIoRank()
Rank based on I/O Consumption
public Long getHarmonicSum()
Harmonic sum based on ranking parameters
public Long getWtHarmonicSum()
Weight based harmonic sum of ranking parameters
public Long getTotalSqlCount()
Total number of rows in SQLStats table
public String toString()
toString in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModelpublic String toString(boolean includeByteArrayContents)
Return a string representation of the object.
includeByteArrayContents - true to include the full contents of byte arrayspublic boolean equals(Object o)
equals in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModelpublic int hashCode()
hashCode in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModelCopyright © 2016–2024. All rights reserved.