Package com.oracle.bmc.opsi.model
Class SqlStats
- java.lang.Object
-
- com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
-
- com.oracle.bmc.opsi.model.SqlStats
-
@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 theSqlStats.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 theSqlStats.Builder
, which maintain a set of all explicitly set fields calledSqlStats.Builder.__explicitlySet__
. ThehashCode()
andequals(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).
-
-
Nested Class Summary
Nested Classes Modifier and Type Class Description static class
SqlStats.Builder
-
Constructor Summary
Constructors Constructor 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.
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method 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_ACTIONLong
getApplicationWaitTimeInUs()
Application wait time (in microseconds)Long
getAvgHardParseTimeInUs()
Average hard parse time (in microseconds) used by this cursorLong
getAvoidedExecutions()
Number of executions attempted on this object, but prevented due to the SQL statement being in quarantineLong
getBufferGets()
Number of Buffer GetsLong
getChildNumber()
Number of this child cursorLong
getClusterWaitTimeInUs()
Cluster wait time (in microseconds).Long
getCommandType()
Oracle command type definitionLong
getConcurrencyWaitTimeInUs()
Concurrency wait time (in microseconds)Long
getCpuTimeInUs()
CPU time (in microseconds) used by this cursor for parsing, executing, and fetchingLong
getDeltaCpuRank()
Rank based on CPU ConsumptionLong
getDeltaCpuTime()
CPU time (in microseconds) for the cursor since the last AWR snapshotLong
getDeltaExecsRank()
Rank based on number of executionLong
getDeltaExecutionCount()
Number of executions for the cursor since the last AWR snapshotLong
getDeltaIoBytes()
Number of I/O bytes exchanged between the Oracle database and the storage system for the cursor since the last AWR snapshotLong
getDeltaIoRank()
Rank based on I/O ConsumptionLong
getDirectReads()
Number of direct readsLong
getDirectWrites()
Number of Direct writesLong
getDiskReads()
Number of disk readsLong
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 cacheString
getExactMatchingSignature()
exact_matching_signature Example: “18067345456756876713”Long
getExecutions()
Number of executionsLong
getFetches()
Number of fetchesString
getForceMatchingSignature()
force_matching_signature Example: “18067345456756876713”String
getFullPlanHashValue()
Total Number of rows in SQLStats tableLong
getHarmonicSum()
Harmonic sum based on ranking parametersString
getInstanceName()
Name of Database Instance Example: “DB10902_1”Long
getInvalidations()
Number of times this child cursor has been invalidatedLong
getIoCellOffloadEligibleBytes()
Number of I/O bytes which can be filtered by the Exadata storage systemLong
getIoCellOffloadReturnedBytes()
Number of bytes that are returned by Exadata cell through the regular I/O pathLong
getIoCellUncompressedBytes()
Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cellsLong
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 reloadedString
getModule()
Module nameLong
getObsoleteCount()
Number of times that a parent cursor became obsoleteLong
getOptimizerCost()
Cost of this query given by the optimizerLong
getParseCalls()
Total integer of parse calls Example: 60Long
getPhysicalReadBytes()
Number of bytes read from disks by the monitored SQLLong
getPhysicalReadRequests()
Number of physical read I/O requests issued by the monitored SQL.Long
getPhysicalWriteBytes()
Number of bytes written to disks by the monitored SQLLong
getPhysicalWriteRequests()
Number of physical write I/O requests issued by the monitored SQLLong
getPlanHashValue()
Plan hash value for the SQL Execution PlanLong
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 processedLong
getSerializableAborts()
Number of serializable abortsString
getService()
Service nameLong
getSharableMem()
Total shared memory (in bytes) currently occupied by all cursors with this SQL text and planLong
getSharableMemRank()
Rank based on sharable memoryLong
getSorts()
Number of sorts that were done for the child cursorString
getSqlIdentifier()
Unique SQL_ID for a SQL Statement.String
getSqlPatch()
SQL patch used for this statement, if anyString
getSqlPlanBaseline()
SQL plan baseline used for this statement, if anyString
getSqlProfile()
SQL profile used for this statement, if anyDate
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 tableLong
getTypeCheckMem()
Typecheck memoryLong
getUserIoWaitTimeInUs()
User I/O wait time (in microseconds)Long
getUsersExecuting()
Number of users executing the statementLong
getUsersOpening()
Number of users that have any of the child cursors openLong
getVersionCount()
Number of cursors present in the cache with this SQL text and planLong
getWtHarmonicSum()
Weight based harmonic sum of ranking parametersint
hashCode()
SqlStats.Builder
toBuilder()
String
toString()
String
toString(boolean includeByteArrayContents)
Return a string representation of the object.
-
-
-
Constructor Detail
-
SqlStats
@Deprecated @ConstructorProperties({"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)
Deprecated.
-
-
Method Detail
-
builder
public static SqlStats.Builder builder()
Create a new builder.
-
toBuilder
public SqlStats.Builder toBuilder()
-
getSqlIdentifier
public String getSqlIdentifier()
Unique SQL_ID for a SQL Statement.- Returns:
- the value
-
getPlanHashValue
public Long getPlanHashValue()
Plan hash value for the SQL Execution Plan- Returns:
- the value
-
getTimeCollected
public Date getTimeCollected()
Collection timestamp Example: “2020-03-31T00:00:00.000Z”- Returns:
- the value
-
getInstanceName
public String getInstanceName()
Name of Database Instance Example: “DB10902_1”- Returns:
- the value
-
getLastActiveTime
public String getLastActiveTime()
last_active_time Example: “0000000099CCE300”- Returns:
- the value
-
getParseCalls
public Long getParseCalls()
Total integer of parse calls Example: 60- Returns:
- the value
-
getDiskReads
public Long getDiskReads()
Number of disk reads- Returns:
- the value
-
getDirectReads
public Long getDirectReads()
Number of direct reads- Returns:
- the value
-
getDirectWrites
public Long getDirectWrites()
Number of Direct writes- Returns:
- the value
-
getBufferGets
public Long getBufferGets()
Number of Buffer Gets- Returns:
- the value
-
getRowsProcessed
public Long getRowsProcessed()
Number of row processed- Returns:
- the value
-
getSerializableAborts
public Long getSerializableAborts()
Number of serializable aborts- Returns:
- the value
-
getFetches
public Long getFetches()
Number of fetches- Returns:
- the value
-
getExecutions
public Long getExecutions()
Number of executions- Returns:
- the value
-
getAvoidedExecutions
public Long getAvoidedExecutions()
Number of executions attempted on this object, but prevented due to the SQL statement being in quarantine- Returns:
- the value
-
getEndOfFetchCount
public Long getEndOfFetchCount()
Number of times this cursor was fully executed since the cursor was brought into the library cache- Returns:
- the value
-
getLoads
public Long getLoads()
Number of times the object was either loaded or reloaded- Returns:
- the value
-
getVersionCount
public Long getVersionCount()
Number of cursors present in the cache with this SQL text and plan- Returns:
- the value
-
getInvalidations
public Long getInvalidations()
Number of times this child cursor has been invalidated- Returns:
- the value
-
getObsoleteCount
public Long getObsoleteCount()
Number of times that a parent cursor became obsolete- Returns:
- the value
-
getPxServersExecutions
public Long getPxServersExecutions()
Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel)- Returns:
- the value
-
getCpuTimeInUs
public Long getCpuTimeInUs()
CPU time (in microseconds) used by this cursor for parsing, executing, and fetching- Returns:
- the value
-
getElapsedTimeInUs
public Long getElapsedTimeInUs()
Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching.- Returns:
- the value
-
getAvgHardParseTimeInUs
public Long getAvgHardParseTimeInUs()
Average hard parse time (in microseconds) used by this cursor- Returns:
- the value
-
getConcurrencyWaitTimeInUs
public Long getConcurrencyWaitTimeInUs()
Concurrency wait time (in microseconds)- Returns:
- the value
-
getApplicationWaitTimeInUs
public Long getApplicationWaitTimeInUs()
Application wait time (in microseconds)- Returns:
- the value
-
getClusterWaitTimeInUs
public Long getClusterWaitTimeInUs()
Cluster wait time (in microseconds).This value is specific to Oracle RAC
- Returns:
- the value
-
getUserIoWaitTimeInUs
public Long getUserIoWaitTimeInUs()
User I/O wait time (in microseconds)- Returns:
- the value
-
getPlsqlExecTimeInUs
public Long getPlsqlExecTimeInUs()
PL/SQL execution time (in microseconds)- Returns:
- the value
-
getJavaExecTimeInUs
public Long getJavaExecTimeInUs()
Java execution time (in microseconds)- Returns:
- the value
-
getSorts
public Long getSorts()
Number of sorts that were done for the child cursor- Returns:
- the value
-
getSharableMem
public Long getSharableMem()
Total shared memory (in bytes) currently occupied by all cursors with this SQL text and plan- Returns:
- the value
-
getTotalSharableMem
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)- Returns:
- the value
-
getTypeCheckMem
public Long getTypeCheckMem()
Typecheck memory- Returns:
- the value
-
getIoCellOffloadEligibleBytes
public Long getIoCellOffloadEligibleBytes()
Number of I/O bytes which can be filtered by the Exadata storage system- Returns:
- the value
-
getIoInterconnectBytes
public Long getIoInterconnectBytes()
Number of I/O bytes exchanged between Oracle Database and the storage system.Typically used for Cache Fusion or parallel queries
- Returns:
- the value
-
getPhysicalReadRequests
public Long getPhysicalReadRequests()
Number of physical read I/O requests issued by the monitored SQL.The requests may not be disk reads
- Returns:
- the value
-
getPhysicalReadBytes
public Long getPhysicalReadBytes()
Number of bytes read from disks by the monitored SQL- Returns:
- the value
-
getPhysicalWriteRequests
public Long getPhysicalWriteRequests()
Number of physical write I/O requests issued by the monitored SQL- Returns:
- the value
-
getPhysicalWriteBytes
public Long getPhysicalWriteBytes()
Number of bytes written to disks by the monitored SQL- Returns:
- the value
-
getExactMatchingSignature
public String getExactMatchingSignature()
exact_matching_signature Example: “18067345456756876713”- Returns:
- the value
-
getForceMatchingSignature
public String getForceMatchingSignature()
force_matching_signature Example: “18067345456756876713”- Returns:
- the value
-
getIoCellUncompressedBytes
public Long getIoCellUncompressedBytes()
Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cells- Returns:
- the value
-
getIoCellOffloadReturnedBytes
public Long getIoCellOffloadReturnedBytes()
Number of bytes that are returned by Exadata cell through the regular I/O path- Returns:
- the value
-
getChildNumber
public Long getChildNumber()
Number of this child cursor- Returns:
- the value
-
getCommandType
public Long getCommandType()
Oracle command type definition- Returns:
- the value
-
getUsersOpening
public Long getUsersOpening()
Number of users that have any of the child cursors open- Returns:
- the value
-
getUsersExecuting
public Long getUsersExecuting()
Number of users executing the statement- Returns:
- the value
-
getOptimizerCost
public Long getOptimizerCost()
Cost of this query given by the optimizer- Returns:
- the value
-
getFullPlanHashValue
public String getFullPlanHashValue()
Total Number of rows in SQLStats table- Returns:
- the value
-
getModule
public String getModule()
Module name- Returns:
- the value
-
getService
public String getService()
Service name- Returns:
- the value
-
getAction
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- Returns:
- the value
-
getSqlProfile
public String getSqlProfile()
SQL profile used for this statement, if any- Returns:
- the value
-
getSqlPatch
public String getSqlPatch()
SQL patch used for this statement, if any- Returns:
- the value
-
getSqlPlanBaseline
public String getSqlPlanBaseline()
SQL plan baseline used for this statement, if any- Returns:
- the value
-
getDeltaExecutionCount
public Long getDeltaExecutionCount()
Number of executions for the cursor since the last AWR snapshot- Returns:
- the value
-
getDeltaCpuTime
public Long getDeltaCpuTime()
CPU time (in microseconds) for the cursor since the last AWR snapshot- Returns:
- the value
-
getDeltaIoBytes
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- Returns:
- the value
-
getDeltaCpuRank
public Long getDeltaCpuRank()
Rank based on CPU Consumption- Returns:
- the value
-
getDeltaExecsRank
public Long getDeltaExecsRank()
Rank based on number of execution- Returns:
- the value
-
getSharableMemRank
public Long getSharableMemRank()
Rank based on sharable memory- Returns:
- the value
-
getDeltaIoRank
public Long getDeltaIoRank()
Rank based on I/O Consumption- Returns:
- the value
-
getHarmonicSum
public Long getHarmonicSum()
Harmonic sum based on ranking parameters- Returns:
- the value
-
getWtHarmonicSum
public Long getWtHarmonicSum()
Weight based harmonic sum of ranking parameters- Returns:
- the value
-
getTotalSqlCount
public Long getTotalSqlCount()
Total number of rows in SQLStats table- Returns:
- the value
-
toString
public String toString()
- Overrides:
toString
in classcom.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
-
toString
public String toString(boolean includeByteArrayContents)
Return a string representation of the object.- Parameters:
includeByteArrayContents
- true to include the full contents of byte arrays- Returns:
- string representation
-
equals
public boolean equals(Object o)
- Overrides:
equals
in classcom.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
-
hashCode
public int hashCode()
- Overrides:
hashCode
in classcom.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
-
-