SqlStats.Builder (Oracle Cloud Infrastructure Java SDK

java.lang.Object
- com.oracle.bmc.opsi.model.SqlStats.Builder

Enclosing class:: SqlStats

public static class SqlStats.Builder
extends Object

Constructor Summary

Constructors
Constructor and Description

Builder()

Constructors
Constructor and Description
`Builder()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`SqlStats.Builder`	`action(String action)` 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
`SqlStats.Builder`	`applicationWaitTimeInUs(Long applicationWaitTimeInUs)` Application wait time (in microseconds)
`SqlStats.Builder`	`avgHardParseTimeInUs(Long avgHardParseTimeInUs)` Average hard parse time (in microseconds) used by this cursor
`SqlStats.Builder`	`avoidedExecutions(Long avoidedExecutions)` Number of executions attempted on this object, but prevented due to the SQL statement being in quarantine
`SqlStats.Builder`	`bufferGets(Long bufferGets)` Number of Buffer Gets
`SqlStats`	`build()`
`SqlStats.Builder`	`childNumber(Long childNumber)` Number of this child cursor
`SqlStats.Builder`	`clusterWaitTimeInUs(Long clusterWaitTimeInUs)` Cluster wait time (in microseconds).
`SqlStats.Builder`	`commandType(Long commandType)` Oracle command type definition
`SqlStats.Builder`	`concurrencyWaitTimeInUs(Long concurrencyWaitTimeInUs)` Concurrency wait time (in microseconds)
`SqlStats.Builder`	`copy(SqlStats model)`
`SqlStats.Builder`	`cpuTimeInUs(Long cpuTimeInUs)` CPU time (in microseconds) used by this cursor for parsing, executing, and fetching
`SqlStats.Builder`	`deltaCpuRank(Long deltaCpuRank)` Rank based on CPU Consumption
`SqlStats.Builder`	`deltaCpuTime(Long deltaCpuTime)` CPU time (in microseconds) for the cursor since the last AWR snapshot
`SqlStats.Builder`	`deltaExecsRank(Long deltaExecsRank)` Rank based on number of execution
`SqlStats.Builder`	`deltaExecutionCount(Long deltaExecutionCount)` Number of executions for the cursor since the last AWR snapshot
`SqlStats.Builder`	`deltaIoBytes(Long deltaIoBytes)` Number of I/O bytes exchanged between the Oracle database and the storage system for the cursor since the last AWR snapshot
`SqlStats.Builder`	`deltaIoRank(Long deltaIoRank)` Rank based on I/O Consumption
`SqlStats.Builder`	`directReads(Long directReads)` Number of direct reads
`SqlStats.Builder`	`directWrites(Long directWrites)` Number of Direct writes
`SqlStats.Builder`	`diskReads(Long diskReads)` Number of disk reads
`SqlStats.Builder`	`elapsedTimeInUs(Long elapsedTimeInUs)` Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching.
`SqlStats.Builder`	`endOfFetchCount(Long endOfFetchCount)` Number of times this cursor was fully executed since the cursor was brought into the library cache
`SqlStats.Builder`	`exactMatchingSignature(String exactMatchingSignature)` exact_matching_signature Example: `"18067345456756876713"`
`SqlStats.Builder`	`executions(Long executions)` Number of executions
`SqlStats.Builder`	`fetches(Long fetches)` Number of fetches
`SqlStats.Builder`	`forceMatchingSignature(String forceMatchingSignature)` force_matching_signature Example: `"18067345456756876713"`
`SqlStats.Builder`	`fullPlanHashValue(String fullPlanHashValue)` Total Number of rows in SQLStats table
`SqlStats.Builder`	`harmonicSum(Long harmonicSum)` Harmonic sum based on ranking parameters
`SqlStats.Builder`	`instanceName(String instanceName)` Name of Database Instance Example: `"DB10902_1"`
`SqlStats.Builder`	`invalidations(Long invalidations)` Number of times this child cursor has been invalidated
`SqlStats.Builder`	`ioCellOffloadEligibleBytes(Long ioCellOffloadEligibleBytes)` Number of I/O bytes which can be filtered by the Exadata storage system
`SqlStats.Builder`	`ioCellOffloadReturnedBytes(Long ioCellOffloadReturnedBytes)` Number of bytes that are returned by Exadata cell through the regular I/O path
`SqlStats.Builder`	`ioCellUncompressedBytes(Long ioCellUncompressedBytes)` Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cells
`SqlStats.Builder`	`ioInterconnectBytes(Long ioInterconnectBytes)` Number of I/O bytes exchanged between Oracle Database and the storage system.
`SqlStats.Builder`	`javaExecTimeInUs(Long javaExecTimeInUs)` Java execution time (in microseconds)
`SqlStats.Builder`	`lastActiveTime(String lastActiveTime)` last_active_time Example: `"0000000099CCE300"`
`SqlStats.Builder`	`loads(Long loads)` Number of times the object was either loaded or reloaded
`SqlStats.Builder`	`module(String module)` Module name
`SqlStats.Builder`	`obsoleteCount(Long obsoleteCount)` Number of times that a parent cursor became obsolete
`SqlStats.Builder`	`optimizerCost(Long optimizerCost)` Cost of this query given by the optimizer
`SqlStats.Builder`	`parseCalls(Long parseCalls)` Total integer of parse calls Example: `60`
`SqlStats.Builder`	`physicalReadBytes(Long physicalReadBytes)` Number of bytes read from disks by the monitored SQL
`SqlStats.Builder`	`physicalReadRequests(Long physicalReadRequests)` Number of physical read I/O requests issued by the monitored SQL.
`SqlStats.Builder`	`physicalWriteBytes(Long physicalWriteBytes)` Number of bytes written to disks by the monitored SQL
`SqlStats.Builder`	`physicalWriteRequests(Long physicalWriteRequests)` Number of physical write I/O requests issued by the monitored SQL
`SqlStats.Builder`	`planHashValue(Long planHashValue)` Plan hash value for the SQL Execution Plan
`SqlStats.Builder`	`plsqlExecTimeInUs(Long plsqlExecTimeInUs)` PL/SQL execution time (in microseconds)
`SqlStats.Builder`	`pxServersExecutions(Long pxServersExecutions)` Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel)
`SqlStats.Builder`	`rowsProcessed(Long rowsProcessed)` Number of row processed
`SqlStats.Builder`	`serializableAborts(Long serializableAborts)` Number of serializable aborts
`SqlStats.Builder`	`service(String service)` Service name
`SqlStats.Builder`	`sharableMem(Long sharableMem)` Total shared memory (in bytes) currently occupied by all cursors with this SQL text and plan
`SqlStats.Builder`	`sharableMemRank(Long sharableMemRank)` Rank based on sharable memory
`SqlStats.Builder`	`sorts(Long sorts)` Number of sorts that were done for the child cursor
`SqlStats.Builder`	`sqlIdentifier(String sqlIdentifier)` Unique SQL_ID for a SQL Statement.
`SqlStats.Builder`	`sqlPatch(String sqlPatch)` SQL patch used for this statement, if any
`SqlStats.Builder`	`sqlPlanBaseline(String sqlPlanBaseline)` SQL plan baseline used for this statement, if any
`SqlStats.Builder`	`sqlProfile(String sqlProfile)` SQL profile used for this statement, if any
`SqlStats.Builder`	`timeCollected(Date timeCollected)` Collection timestamp Example: `"2020-03-31T00:00:00.000Z"`
`SqlStats.Builder`	`totalSharableMem(Long totalSharableMem)` 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)
`SqlStats.Builder`	`totalSqlCount(Long totalSqlCount)` Total number of rows in SQLStats table
`SqlStats.Builder`	`typeCheckMem(Long typeCheckMem)` Typecheck memory
`SqlStats.Builder`	`userIoWaitTimeInUs(Long userIoWaitTimeInUs)` User I/O wait time (in microseconds)
`SqlStats.Builder`	`usersExecuting(Long usersExecuting)` Number of users executing the statement
`SqlStats.Builder`	`usersOpening(Long usersOpening)` Number of users that have any of the child cursors open
`SqlStats.Builder`	`versionCount(Long versionCount)` Number of cursors present in the cache with this SQL text and plan
`SqlStats.Builder`	`wtHarmonicSum(Long wtHarmonicSum)` Weight based harmonic sum of ranking parameters

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - Builder
```
public Builder()
```
- Method Detail
  - sqlIdentifier
```
public SqlStats.Builder sqlIdentifier(String sqlIdentifier)
```
    Unique SQL_ID for a SQL Statement.
    
    Parameters:
    
    sqlIdentifier - the value to set
    
    Returns:
    
    this builder
  - planHashValue
```
public SqlStats.Builder planHashValue(Long planHashValue)
```
    Plan hash value for the SQL Execution Plan
    
    Parameters:
    
    planHashValue - the value to set
    
    Returns:
    
    this builder
  - timeCollected
```
public SqlStats.Builder timeCollected(Date timeCollected)
```
    Collection timestamp Example: "2020-03-31T00:00:00.000Z"
    
    Parameters:
    
    timeCollected - the value to set
    
    Returns:
    
    this builder
  - instanceName
```
public SqlStats.Builder instanceName(String instanceName)
```
    Name of Database Instance Example: "DB10902_1"
    
    Parameters:
    
    instanceName - the value to set
    
    Returns:
    
    this builder
  - lastActiveTime
```
public SqlStats.Builder lastActiveTime(String lastActiveTime)
```
    last_active_time Example: "0000000099CCE300"
    
    Parameters:
    
    lastActiveTime - the value to set
    
    Returns:
    
    this builder
  - parseCalls
```
public SqlStats.Builder parseCalls(Long parseCalls)
```
    Total integer of parse calls Example: 60
    
    Parameters:
    
    parseCalls - the value to set
    
    Returns:
    
    this builder
  - diskReads
```
public SqlStats.Builder diskReads(Long diskReads)
```
    Number of disk reads
    
    Parameters:
    
    diskReads - the value to set
    
    Returns:
    
    this builder
  - directReads
```
public SqlStats.Builder directReads(Long directReads)
```
    Number of direct reads
    
    Parameters:
    
    directReads - the value to set
    
    Returns:
    
    this builder
  - directWrites
```
public SqlStats.Builder directWrites(Long directWrites)
```
    Number of Direct writes
    
    Parameters:
    
    directWrites - the value to set
    
    Returns:
    
    this builder
  - bufferGets
```
public SqlStats.Builder bufferGets(Long bufferGets)
```
    Number of Buffer Gets
    
    Parameters:
    
    bufferGets - the value to set
    
    Returns:
    
    this builder
  - rowsProcessed
```
public SqlStats.Builder rowsProcessed(Long rowsProcessed)
```
    Number of row processed
    
    Parameters:
    
    rowsProcessed - the value to set
    
    Returns:
    
    this builder
  - serializableAborts
```
public SqlStats.Builder serializableAborts(Long serializableAborts)
```
    Number of serializable aborts
    
    Parameters:
    
    serializableAborts - the value to set
    
    Returns:
    
    this builder
  - fetches
```
public SqlStats.Builder fetches(Long fetches)
```
    Number of fetches
    
    Parameters:
    
    fetches - the value to set
    
    Returns:
    
    this builder
  - executions
```
public SqlStats.Builder executions(Long executions)
```
    Number of executions
    
    Parameters:
    
    executions - the value to set
    
    Returns:
    
    this builder
  - avoidedExecutions
```
public SqlStats.Builder avoidedExecutions(Long avoidedExecutions)
```
    Number of executions attempted on this object, but prevented due to the SQL statement being in quarantine
    
    Parameters:
    
    avoidedExecutions - the value to set
    
    Returns:
    
    this builder
  - endOfFetchCount
```
public SqlStats.Builder endOfFetchCount(Long endOfFetchCount)
```
    Number of times this cursor was fully executed since the cursor was brought into the library cache
    
    Parameters:
    
    endOfFetchCount - the value to set
    
    Returns:
    
    this builder
  - loads
```
public SqlStats.Builder loads(Long loads)
```
    Number of times the object was either loaded or reloaded
    
    Parameters:
    
    loads - the value to set
    
    Returns:
    
    this builder
  - versionCount
```
public SqlStats.Builder versionCount(Long versionCount)
```
    Number of cursors present in the cache with this SQL text and plan
    
    Parameters:
    
    versionCount - the value to set
    
    Returns:
    
    this builder
  - invalidations
```
public SqlStats.Builder invalidations(Long invalidations)
```
    Number of times this child cursor has been invalidated
    
    Parameters:
    
    invalidations - the value to set
    
    Returns:
    
    this builder
  - obsoleteCount
```
public SqlStats.Builder obsoleteCount(Long obsoleteCount)
```
    Number of times that a parent cursor became obsolete
    
    Parameters:
    
    obsoleteCount - the value to set
    
    Returns:
    
    this builder
  - pxServersExecutions
```
public SqlStats.Builder pxServersExecutions(Long pxServersExecutions)
```
    Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel)
    
    Parameters:
    
    pxServersExecutions - the value to set
    
    Returns:
    
    this builder
  - cpuTimeInUs
```
public SqlStats.Builder cpuTimeInUs(Long cpuTimeInUs)
```
    CPU time (in microseconds) used by this cursor for parsing, executing, and fetching
    
    Parameters:
    
    cpuTimeInUs - the value to set
    
    Returns:
    
    this builder
  - elapsedTimeInUs
```
public SqlStats.Builder elapsedTimeInUs(Long elapsedTimeInUs)
```
    Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching.
    
    Parameters:
    
    elapsedTimeInUs - the value to set
    
    Returns:
    
    this builder
  - avgHardParseTimeInUs
```
public SqlStats.Builder avgHardParseTimeInUs(Long avgHardParseTimeInUs)
```
    Average hard parse time (in microseconds) used by this cursor
    
    Parameters:
    
    avgHardParseTimeInUs - the value to set
    
    Returns:
    
    this builder
  - concurrencyWaitTimeInUs
```
public SqlStats.Builder concurrencyWaitTimeInUs(Long concurrencyWaitTimeInUs)
```
    Concurrency wait time (in microseconds)
    
    Parameters:
    
    concurrencyWaitTimeInUs - the value to set
    
    Returns:
    
    this builder
  - applicationWaitTimeInUs
```
public SqlStats.Builder applicationWaitTimeInUs(Long applicationWaitTimeInUs)
```
    Application wait time (in microseconds)
    
    Parameters:
    
    applicationWaitTimeInUs - the value to set
    
    Returns:
    
    this builder
  - clusterWaitTimeInUs
```
public SqlStats.Builder clusterWaitTimeInUs(Long clusterWaitTimeInUs)
```
    Cluster wait time (in microseconds). This value is specific to Oracle RAC
    
    Parameters:
    
    clusterWaitTimeInUs - the value to set
    
    Returns:
    
    this builder
  - userIoWaitTimeInUs
```
public SqlStats.Builder userIoWaitTimeInUs(Long userIoWaitTimeInUs)
```
    User I/O wait time (in microseconds)
    
    Parameters:
    
    userIoWaitTimeInUs - the value to set
    
    Returns:
    
    this builder
  - plsqlExecTimeInUs
```
public SqlStats.Builder plsqlExecTimeInUs(Long plsqlExecTimeInUs)
```
    PL/SQL execution time (in microseconds)
    
    Parameters:
    
    plsqlExecTimeInUs - the value to set
    
    Returns:
    
    this builder
  - javaExecTimeInUs
```
public SqlStats.Builder javaExecTimeInUs(Long javaExecTimeInUs)
```
    Java execution time (in microseconds)
    
    Parameters:
    
    javaExecTimeInUs - the value to set
    
    Returns:
    
    this builder
  - sorts
```
public SqlStats.Builder sorts(Long sorts)
```
    Number of sorts that were done for the child cursor
    
    Parameters:
    
    sorts - the value to set
    
    Returns:
    
    this builder
  - sharableMem
```
public SqlStats.Builder sharableMem(Long sharableMem)
```
    Total shared memory (in bytes) currently occupied by all cursors with this SQL text and plan
    
    Parameters:
    
    sharableMem - the value to set
    
    Returns:
    
    this builder
  - totalSharableMem
```
public SqlStats.Builder totalSharableMem(Long totalSharableMem)
```
    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)
    
    Parameters:
    
    totalSharableMem - the value to set
    
    Returns:
    
    this builder
  - typeCheckMem
```
public SqlStats.Builder typeCheckMem(Long typeCheckMem)
```
    Typecheck memory
    
    Parameters:
    
    typeCheckMem - the value to set
    
    Returns:
    
    this builder
  - ioCellOffloadEligibleBytes
```
public SqlStats.Builder ioCellOffloadEligibleBytes(Long ioCellOffloadEligibleBytes)
```
    Number of I/O bytes which can be filtered by the Exadata storage system
    
    Parameters:
    
    ioCellOffloadEligibleBytes - the value to set
    
    Returns:
    
    this builder
  - ioInterconnectBytes
```
public SqlStats.Builder ioInterconnectBytes(Long ioInterconnectBytes)
```
    Number of I/O bytes exchanged between Oracle Database and the storage system. Typically used for Cache Fusion or parallel queries
    
    Parameters:
    
    ioInterconnectBytes - the value to set
    
    Returns:
    
    this builder
  - physicalReadRequests
```
public SqlStats.Builder physicalReadRequests(Long physicalReadRequests)
```
    Number of physical read I/O requests issued by the monitored SQL. The requests may not be disk reads
    
    Parameters:
    
    physicalReadRequests - the value to set
    
    Returns:
    
    this builder
  - physicalReadBytes
```
public SqlStats.Builder physicalReadBytes(Long physicalReadBytes)
```
    Number of bytes read from disks by the monitored SQL
    
    Parameters:
    
    physicalReadBytes - the value to set
    
    Returns:
    
    this builder
  - physicalWriteRequests
```
public SqlStats.Builder physicalWriteRequests(Long physicalWriteRequests)
```
    Number of physical write I/O requests issued by the monitored SQL
    
    Parameters:
    
    physicalWriteRequests - the value to set
    
    Returns:
    
    this builder
  - physicalWriteBytes
```
public SqlStats.Builder physicalWriteBytes(Long physicalWriteBytes)
```
    Number of bytes written to disks by the monitored SQL
    
    Parameters:
    
    physicalWriteBytes - the value to set
    
    Returns:
    
    this builder
  - exactMatchingSignature
```
public SqlStats.Builder exactMatchingSignature(String exactMatchingSignature)
```
    exact_matching_signature Example: "18067345456756876713"
    
    Parameters:
    
    exactMatchingSignature - the value to set
    
    Returns:
    
    this builder
  - forceMatchingSignature
```
public SqlStats.Builder forceMatchingSignature(String forceMatchingSignature)
```
    force_matching_signature Example: "18067345456756876713"
    
    Parameters:
    
    forceMatchingSignature - the value to set
    
    Returns:
    
    this builder
  - ioCellUncompressedBytes
```
public SqlStats.Builder ioCellUncompressedBytes(Long ioCellUncompressedBytes)
```
    Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cells
    
    Parameters:
    
    ioCellUncompressedBytes - the value to set
    
    Returns:
    
    this builder
  - ioCellOffloadReturnedBytes
```
public SqlStats.Builder ioCellOffloadReturnedBytes(Long ioCellOffloadReturnedBytes)
```
    Number of bytes that are returned by Exadata cell through the regular I/O path
    
    Parameters:
    
    ioCellOffloadReturnedBytes - the value to set
    
    Returns:
    
    this builder
  - childNumber
```
public SqlStats.Builder childNumber(Long childNumber)
```
    Number of this child cursor
    
    Parameters:
    
    childNumber - the value to set
    
    Returns:
    
    this builder
  - commandType
```
public SqlStats.Builder commandType(Long commandType)
```
    Oracle command type definition
    
    Parameters:
    
    commandType - the value to set
    
    Returns:
    
    this builder
  - usersOpening
```
public SqlStats.Builder usersOpening(Long usersOpening)
```
    Number of users that have any of the child cursors open
    
    Parameters:
    
    usersOpening - the value to set
    
    Returns:
    
    this builder
  - usersExecuting
```
public SqlStats.Builder usersExecuting(Long usersExecuting)
```
    Number of users executing the statement
    
    Parameters:
    
    usersExecuting - the value to set
    
    Returns:
    
    this builder
  - optimizerCost
```
public SqlStats.Builder optimizerCost(Long optimizerCost)
```
    Cost of this query given by the optimizer
    
    Parameters:
    
    optimizerCost - the value to set
    
    Returns:
    
    this builder
  - fullPlanHashValue
```
public SqlStats.Builder fullPlanHashValue(String fullPlanHashValue)
```
    Total Number of rows in SQLStats table
    
    Parameters:
    
    fullPlanHashValue - the value to set
    
    Returns:
    
    this builder
  - module
```
public SqlStats.Builder module(String module)
```
    Module name
    
    Parameters:
    
    module - the value to set
    
    Returns:
    
    this builder
  - service
```
public SqlStats.Builder service(String service)
```
    Service name
    
    Parameters:
    
    service - the value to set
    
    Returns:
    
    this builder
  - action
```
public SqlStats.Builder action(String action)
```
    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
    
    Parameters:
    
    action - the value to set
    
    Returns:
    
    this builder
  - sqlProfile
```
public SqlStats.Builder sqlProfile(String sqlProfile)
```
    SQL profile used for this statement, if any
    
    Parameters:
    
    sqlProfile - the value to set
    
    Returns:
    
    this builder
  - sqlPatch
```
public SqlStats.Builder sqlPatch(String sqlPatch)
```
    SQL patch used for this statement, if any
    
    Parameters:
    
    sqlPatch - the value to set
    
    Returns:
    
    this builder
  - sqlPlanBaseline
```
public SqlStats.Builder sqlPlanBaseline(String sqlPlanBaseline)
```
    SQL plan baseline used for this statement, if any
    
    Parameters:
    
    sqlPlanBaseline - the value to set
    
    Returns:
    
    this builder
  - deltaExecutionCount
```
public SqlStats.Builder deltaExecutionCount(Long deltaExecutionCount)
```
    Number of executions for the cursor since the last AWR snapshot
    
    Parameters:
    
    deltaExecutionCount - the value to set
    
    Returns:
    
    this builder
  - deltaCpuTime
```
public SqlStats.Builder deltaCpuTime(Long deltaCpuTime)
```
    CPU time (in microseconds) for the cursor since the last AWR snapshot
    
    Parameters:
    
    deltaCpuTime - the value to set
    
    Returns:
    
    this builder
  - deltaIoBytes
```
public SqlStats.Builder deltaIoBytes(Long deltaIoBytes)
```
    Number of I/O bytes exchanged between the Oracle database and the storage system for the cursor since the last AWR snapshot
    
    Parameters:
    
    deltaIoBytes - the value to set
    
    Returns:
    
    this builder
  - deltaCpuRank
```
public SqlStats.Builder deltaCpuRank(Long deltaCpuRank)
```
    Rank based on CPU Consumption
    
    Parameters:
    
    deltaCpuRank - the value to set
    
    Returns:
    
    this builder
  - deltaExecsRank
```
public SqlStats.Builder deltaExecsRank(Long deltaExecsRank)
```
    Rank based on number of execution
    
    Parameters:
    
    deltaExecsRank - the value to set
    
    Returns:
    
    this builder
  - sharableMemRank
```
public SqlStats.Builder sharableMemRank(Long sharableMemRank)
```
    Rank based on sharable memory
    
    Parameters:
    
    sharableMemRank - the value to set
    
    Returns:
    
    this builder
  - deltaIoRank
```
public SqlStats.Builder deltaIoRank(Long deltaIoRank)
```
    Rank based on I/O Consumption
    
    Parameters:
    
    deltaIoRank - the value to set
    
    Returns:
    
    this builder
  - harmonicSum
```
public SqlStats.Builder harmonicSum(Long harmonicSum)
```
    Harmonic sum based on ranking parameters
    
    Parameters:
    
    harmonicSum - the value to set
    
    Returns:
    
    this builder
  - wtHarmonicSum
```
public SqlStats.Builder wtHarmonicSum(Long wtHarmonicSum)
```
    Weight based harmonic sum of ranking parameters
    
    Parameters:
    
    wtHarmonicSum - the value to set
    
    Returns:
    
    this builder
  - totalSqlCount
```
public SqlStats.Builder totalSqlCount(Long totalSqlCount)
```
    Total number of rows in SQLStats table
    
    Parameters:
    
    totalSqlCount - the value to set
    
    Returns:
    
    this builder
  - build
```
public SqlStats build()
```
  - copy
```
public SqlStats.Builder copy(SqlStats model)
```

Class SqlStats.Builder

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

Builder

Method Detail

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

build

copy