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.ExplicitlySetBmcModelSql 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 classSqlStats.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.Builderbuilder()Create a new builder.booleanequals(Object o)StringgetAction()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_ACTIONLonggetApplicationWaitTimeInUs()Application wait time (in microseconds)LonggetAvgHardParseTimeInUs()Average hard parse time (in microseconds) used by this cursorLonggetAvoidedExecutions()Number of executions attempted on this object, but prevented due to the SQL statement being in quarantineLonggetBufferGets()Number of Buffer GetsLonggetChildNumber()Number of this child cursorLonggetClusterWaitTimeInUs()Cluster wait time (in microseconds).LonggetCommandType()Oracle command type definitionLonggetConcurrencyWaitTimeInUs()Concurrency wait time (in microseconds)LonggetCpuTimeInUs()CPU time (in microseconds) used by this cursor for parsing, executing, and fetchingLonggetDeltaCpuRank()Rank based on CPU ConsumptionLonggetDeltaCpuTime()CPU time (in microseconds) for the cursor since the last AWR snapshotLonggetDeltaExecsRank()Rank based on number of executionLonggetDeltaExecutionCount()Number of executions for the cursor since the last AWR snapshotLonggetDeltaIoBytes()Number of I/O bytes exchanged between the Oracle database and the storage system for the cursor since the last AWR snapshotLonggetDeltaIoRank()Rank based on I/O ConsumptionLonggetDirectReads()Number of direct readsLonggetDirectWrites()Number of Direct writesLonggetDiskReads()Number of disk readsLonggetElapsedTimeInUs()Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching.LonggetEndOfFetchCount()Number of times this cursor was fully executed since the cursor was brought into the library cacheStringgetExactMatchingSignature()exact_matching_signature Example: “18067345456756876713”LonggetExecutions()Number of executionsLonggetFetches()Number of fetchesStringgetForceMatchingSignature()force_matching_signature Example: “18067345456756876713”StringgetFullPlanHashValue()Total Number of rows in SQLStats tableLonggetHarmonicSum()Harmonic sum based on ranking parametersStringgetInstanceName()Name of Database Instance Example: “DB10902_1”LonggetInvalidations()Number of times this child cursor has been invalidatedLonggetIoCellOffloadEligibleBytes()Number of I/O bytes which can be filtered by the Exadata storage systemLonggetIoCellOffloadReturnedBytes()Number of bytes that are returned by Exadata cell through the regular I/O pathLonggetIoCellUncompressedBytes()Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cellsLonggetIoInterconnectBytes()Number of I/O bytes exchanged between Oracle Database and the storage system.LonggetJavaExecTimeInUs()Java execution time (in microseconds)StringgetLastActiveTime()last_active_time Example: “0000000099CCE300”LonggetLoads()Number of times the object was either loaded or reloadedStringgetModule()Module nameLonggetObsoleteCount()Number of times that a parent cursor became obsoleteLonggetOptimizerCost()Cost of this query given by the optimizerLonggetParseCalls()Total integer of parse calls Example: 60LonggetPhysicalReadBytes()Number of bytes read from disks by the monitored SQLLonggetPhysicalReadRequests()Number of physical read I/O requests issued by the monitored SQL.LonggetPhysicalWriteBytes()Number of bytes written to disks by the monitored SQLLonggetPhysicalWriteRequests()Number of physical write I/O requests issued by the monitored SQLLonggetPlanHashValue()Plan hash value for the SQL Execution PlanLonggetPlsqlExecTimeInUs()PL/SQL execution time (in microseconds)LonggetPxServersExecutions()Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel)LonggetRowsProcessed()Number of row processedLonggetSerializableAborts()Number of serializable abortsStringgetService()Service nameLonggetSharableMem()Total shared memory (in bytes) currently occupied by all cursors with this SQL text and planLonggetSharableMemRank()Rank based on sharable memoryLonggetSorts()Number of sorts that were done for the child cursorStringgetSqlIdentifier()Unique SQL_ID for a SQL Statement.StringgetSqlPatch()SQL patch used for this statement, if anyStringgetSqlPlanBaseline()SQL plan baseline used for this statement, if anyStringgetSqlProfile()SQL profile used for this statement, if anyDategetTimeCollected()Collection timestamp Example: “2020-03-31T00:00:00.000Z”LonggetTotalSharableMem()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)LonggetTotalSqlCount()Total number of rows in SQLStats tableLonggetTypeCheckMem()Typecheck memoryLonggetUserIoWaitTimeInUs()User I/O wait time (in microseconds)LonggetUsersExecuting()Number of users executing the statementLonggetUsersOpening()Number of users that have any of the child cursors openLonggetVersionCount()Number of cursors present in the cache with this SQL text and planLonggetWtHarmonicSum()Weight based harmonic sum of ranking parametersinthashCode()SqlStats.BuildertoBuilder()StringtoString()StringtoString(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:
toStringin 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:
equalsin classcom.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
-
hashCode
public int hashCode()
- Overrides:
hashCodein classcom.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
-
-