Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace SqlStats

Sql Stats type object.

Properties

Functions

Properties

Optional action

action: undefined | string

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

Optional applicationWaitTimeInUs

applicationWaitTimeInUs: undefined | number

Application wait time (in microseconds) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional avgHardParseTimeInUs

avgHardParseTimeInUs: undefined | number

Average hard parse time (in microseconds) used by this cursor Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional avoidedExecutions

avoidedExecutions: undefined | number

Number of executions attempted on this object, but prevented due to the SQL statement being in quarantine Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional bufferGets

bufferGets: undefined | number

Number of Buffer Gets Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional childNumber

childNumber: undefined | number

Number of this child cursor Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional clusterWaitTimeInUs

clusterWaitTimeInUs: undefined | number

Cluster wait time (in microseconds). This value is specific to Oracle RAC Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional commandType

commandType: undefined | number

Oracle command type definition Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional concurrencyWaitTimeInUs

concurrencyWaitTimeInUs: undefined | number

Concurrency wait time (in microseconds) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional cpuTimeInUs

cpuTimeInUs: undefined | number

CPU time (in microseconds) used by this cursor for parsing, executing, and fetching Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional deltaCpuRank

deltaCpuRank: undefined | number

Rank based on CPU Consumption Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional deltaCpuTime

deltaCpuTime: undefined | number

CPU time (in microseconds) for the cursor since the last AWR snapshot Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional deltaExecsRank

deltaExecsRank: undefined | number

Rank based on number of execution Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional deltaExecutionCount

deltaExecutionCount: undefined | number

Number of executions for the cursor since the last AWR snapshot Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional deltaIoBytes

deltaIoBytes: undefined | number

Number of I/O bytes exchanged between the Oracle database and the storage system for the cursor since the last AWR snapshot Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional deltaIoRank

deltaIoRank: undefined | number

Rank based on I/O Consumption Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional directReads

directReads: undefined | number

Number of direct reads Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional directWrites

directWrites: undefined | number

Number of Direct writes Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional diskReads

diskReads: undefined | number

Number of disk reads Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional elapsedTimeInUs

elapsedTimeInUs: undefined | number

Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional endOfFetchCount

endOfFetchCount: undefined | number

Number of times this cursor was fully executed since the cursor was brought into the library cache Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional exactMatchingSignature

exactMatchingSignature: undefined | string

exact_matching_signature Example: {@code "18067345456756876713"}

Optional executions

executions: undefined | number

Number of executions Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional fetches

fetches: undefined | number

Number of fetches Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional forceMatchingSignature

forceMatchingSignature: undefined | string

force_matching_signature Example: {@code "18067345456756876713"}

Optional fullPlanHashValue

fullPlanHashValue: undefined | string

Total Number of rows in SQLStats table

Optional harmonicSum

harmonicSum: undefined | number

Harmonic sum based on ranking parameters Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

instanceName

instanceName: string

Name of Database Instance Example: {@code "DB10902_1"}

Optional invalidations

invalidations: undefined | number

Number of times this child cursor has been invalidated Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional ioCellOffloadEligibleBytes

ioCellOffloadEligibleBytes: undefined | number

Number of I/O bytes which can be filtered by the Exadata storage system Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional ioCellOffloadReturnedBytes

ioCellOffloadReturnedBytes: undefined | number

Number of bytes that are returned by Exadata cell through the regular I/O path Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional ioCellUncompressedBytes

ioCellUncompressedBytes: undefined | number

Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cells Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional ioInterconnectBytes

ioInterconnectBytes: undefined | number

Number of I/O bytes exchanged between Oracle Database and the storage system. Typically used for Cache Fusion or parallel queries Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional javaExecTimeInUs

javaExecTimeInUs: undefined | number

Java execution time (in microseconds) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional lastActiveTime

lastActiveTime: undefined | string

last_active_time Example: {@code "0000000099CCE300"}

Optional loads

loads: undefined | number

Number of times the object was either loaded or reloaded Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional module

module: undefined | string

Module name

Optional obsoleteCount

obsoleteCount: undefined | number

Number of times that a parent cursor became obsolete Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional optimizerCost

optimizerCost: undefined | number

Cost of this query given by the optimizer Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional parseCalls

parseCalls: undefined | number

Total integer of parse calls Example: {@code 60} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional physicalReadBytes

physicalReadBytes: undefined | number

Number of bytes read from disks by the monitored SQL Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional physicalReadRequests

physicalReadRequests: undefined | number

Number of physical read I/O requests issued by the monitored SQL. The requests may not be disk reads Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional physicalWriteBytes

physicalWriteBytes: undefined | number

Number of bytes written to disks by the monitored SQL Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional physicalWriteRequests

physicalWriteRequests: undefined | number

Number of physical write I/O requests issued by the monitored SQL Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

planHashValue

planHashValue: number

Plan hash value for the SQL Execution Plan Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional plsqlExecTimeInUs

plsqlExecTimeInUs: undefined | number

PL/SQL execution time (in microseconds) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional pxServersExecutions

pxServersExecutions: undefined | number

Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional rowsProcessed

rowsProcessed: undefined | number

Number of row processed Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional serializableAborts

serializableAborts: undefined | number

Number of serializable aborts Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional service

service: undefined | string

Service name

Optional sharableMem

sharableMem: undefined | number

Total shared memory (in bytes) currently occupied by all cursors with this SQL text and plan Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional sharableMemRank

sharableMemRank: undefined | number

Rank based on sharable memory Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional sorts

sorts: undefined | number

Number of sorts that were done for the child cursor Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

sqlIdentifier

sqlIdentifier: string

Unique SQL_ID for a SQL Statement.

Optional sqlPatch

sqlPatch: undefined | string

SQL patch used for this statement, if any

Optional sqlPlanBaseline

sqlPlanBaseline: undefined | string

SQL plan baseline used for this statement, if any

Optional sqlProfile

sqlProfile: undefined | string

SQL profile used for this statement, if any

timeCollected

timeCollected: Date

Collection timestamp Example: {@code "2020-03-31T00:00:00.000Z"}

Optional totalSharableMem

totalSharableMem: undefined | number

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) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional totalSqlCount

totalSqlCount: undefined | number

Total number of rows in SQLStats table Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional typeCheckMem

typeCheckMem: undefined | number

Typecheck memory Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional userIoWaitTimeInUs

userIoWaitTimeInUs: undefined | number

User I/O wait time (in microseconds) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional usersExecuting

usersExecuting: undefined | number

Number of users executing the statement Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional usersOpening

usersOpening: undefined | number

Number of users that have any of the child cursors open Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional versionCount

versionCount: undefined | number

Number of cursors present in the cache with this SQL text and plan Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional wtHarmonicSum

wtHarmonicSum: undefined | number

Weight based harmonic sum of ranking parameters Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Functions

getDeserializedJsonObj

  • getDeserializedJsonObj(obj: SqlStats): object

getJsonObj