Class 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 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).
    • 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

      • 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 class com.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 class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
      • hashCode

        public int hashCode()
        Overrides:
        hashCode in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel