Class SqlStats

Sql Stats type object.

Inheritance

object

SqlStats

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.OpsiService.Models

Assembly: OCI.DotNetSDK.Opsi.dll

Syntax

public class SqlStats

Properties

Action

Declaration

[JsonProperty(PropertyName = "action")]
public string Action { get; set; }

Property Value

Type	Description
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

ApplicationWaitTimeInUs

Declaration

[JsonProperty(PropertyName = "applicationWaitTimeInUs")]
public long? ApplicationWaitTimeInUs { get; set; }

Property Value

Type	Description
long?	Application wait time (in microseconds)

AvgHardParseTimeInUs

Declaration

[JsonProperty(PropertyName = "avgHardParseTimeInUs")]
public long? AvgHardParseTimeInUs { get; set; }

Property Value

Type	Description
long?	Average hard parse time (in microseconds) used by this cursor

AvoidedExecutions

Declaration

[JsonProperty(PropertyName = "avoidedExecutions")]
public long? AvoidedExecutions { get; set; }

Property Value

Type	Description
long?	Number of executions attempted on this object, but prevented due to the SQL statement being in quarantine

BufferGets

Declaration

[JsonProperty(PropertyName = "bufferGets")]
public long? BufferGets { get; set; }

Property Value

Type	Description
long?	Number of Buffer Gets

ChildNumber

Declaration

[JsonProperty(PropertyName = "childNumber")]
public long? ChildNumber { get; set; }

Property Value

Type	Description
long?	Number of this child cursor

ClusterWaitTimeInUs

Declaration

[JsonProperty(PropertyName = "clusterWaitTimeInUs")]
public long? ClusterWaitTimeInUs { get; set; }

Property Value

Type	Description
long?	Cluster wait time (in microseconds). This value is specific to Oracle RAC

CommandType

Declaration

[JsonProperty(PropertyName = "commandType")]
public long? CommandType { get; set; }

Property Value

Type	Description
long?	Oracle command type definition

ConcurrencyWaitTimeInUs

Declaration

[JsonProperty(PropertyName = "concurrencyWaitTimeInUs")]
public long? ConcurrencyWaitTimeInUs { get; set; }

Property Value

Type	Description
long?	Concurrency wait time (in microseconds)

CpuTimeInUs

Declaration

[JsonProperty(PropertyName = "cpuTimeInUs")]
public long? CpuTimeInUs { get; set; }

Property Value

Type	Description
long?	CPU time (in microseconds) used by this cursor for parsing, executing, and fetching

DeltaCpuRank

Declaration

[JsonProperty(PropertyName = "deltaCpuRank")]
public long? DeltaCpuRank { get; set; }

Property Value

Type	Description
long?	Rank based on CPU Consumption

DeltaCpuTime

Declaration

[JsonProperty(PropertyName = "deltaCpuTime")]
public long? DeltaCpuTime { get; set; }

Property Value

Type	Description
long?	CPU time (in microseconds) for the cursor since the last AWR snapshot

DeltaExecsRank

Declaration

[JsonProperty(PropertyName = "deltaExecsRank")]
public long? DeltaExecsRank { get; set; }

Property Value

Type	Description
long?	Rank based on number of execution

DeltaExecutionCount

Declaration

[JsonProperty(PropertyName = "deltaExecutionCount")]
public long? DeltaExecutionCount { get; set; }

Property Value

Type	Description
long?	Number of executions for the cursor since the last AWR snapshot

DeltaIoBytes

Declaration

[JsonProperty(PropertyName = "deltaIoBytes")]
public long? DeltaIoBytes { get; set; }

Property Value

Type	Description
long?	Number of I/O bytes exchanged between the Oracle database and the storage system for the cursor since the last AWR snapshot

DeltaIoRank

Declaration

[JsonProperty(PropertyName = "deltaIoRank")]
public long? DeltaIoRank { get; set; }

Property Value

Type	Description
long?	Rank based on I/O Consumption

DirectReads

Declaration

[JsonProperty(PropertyName = "directReads")]
public long? DirectReads { get; set; }

Property Value

Type	Description
long?	Number of direct reads

DirectWrites

Declaration

[JsonProperty(PropertyName = "directWrites")]
public long? DirectWrites { get; set; }

Property Value

Type	Description
long?	Number of Direct writes

DiskReads

Declaration

[JsonProperty(PropertyName = "diskReads")]
public long? DiskReads { get; set; }

Property Value

Type	Description
long?	Number of disk reads

ElapsedTimeInUs

Declaration

[JsonProperty(PropertyName = "elapsedTimeInUs")]
public long? ElapsedTimeInUs { get; set; }

Property Value

Type	Description
long?	Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching.

EndOfFetchCount

Declaration

[JsonProperty(PropertyName = "endOfFetchCount")]
public long? EndOfFetchCount { get; set; }

Property Value

Type	Description
long?	Number of times this cursor was fully executed since the cursor was brought into the library cache

ExactMatchingSignature

Declaration

[JsonProperty(PropertyName = "exactMatchingSignature")]
public string ExactMatchingSignature { get; set; }

Property Value

Type	Description
string	exact_matching_signature Example: "18067345456756876713"

Executions

Declaration

[JsonProperty(PropertyName = "executions")]
public long? Executions { get; set; }

Property Value

Type	Description
long?	Number of executions

Fetches

Declaration

[JsonProperty(PropertyName = "fetches")]
public long? Fetches { get; set; }

Property Value

Type	Description
long?	Number of fetches

ForceMatchingSignature

Declaration

[JsonProperty(PropertyName = "forceMatchingSignature")]
public string ForceMatchingSignature { get; set; }

Property Value

Type	Description
string	force_matching_signature Example: "18067345456756876713"

FullPlanHashValue

Declaration

[JsonProperty(PropertyName = "fullPlanHashValue")]
public string FullPlanHashValue { get; set; }

Property Value

Type	Description
string	Total Number of rows in SQLStats table

HarmonicSum

Declaration

[JsonProperty(PropertyName = "harmonicSum")]
public long? HarmonicSum { get; set; }

Property Value

Type	Description
long?	Harmonic sum based on ranking parameters

InstanceName

Declaration

[Required(ErrorMessage = "InstanceName is required.")]
[JsonProperty(PropertyName = "instanceName")]
public string InstanceName { get; set; }

Property Value

Type	Description
string	Name of Database Instance Example: "DB10902_1"

Remarks

Required

Invalidations

Declaration

[JsonProperty(PropertyName = "invalidations")]
public long? Invalidations { get; set; }

Property Value

Type	Description
long?	Number of times this child cursor has been invalidated

IoCellOffloadEligibleBytes

Declaration

[JsonProperty(PropertyName = "ioCellOffloadEligibleBytes")]
public long? IoCellOffloadEligibleBytes { get; set; }

Property Value

Type	Description
long?	Number of I/O bytes which can be filtered by the Exadata storage system

IoCellOffloadReturnedBytes

Declaration

[JsonProperty(PropertyName = "ioCellOffloadReturnedBytes")]
public long? IoCellOffloadReturnedBytes { get; set; }

Property Value

Type	Description
long?	Number of bytes that are returned by Exadata cell through the regular I/O path

IoCellUncompressedBytes

Declaration

[JsonProperty(PropertyName = "ioCellUncompressedBytes")]
public long? IoCellUncompressedBytes { get; set; }

Property Value

Type	Description
long?	Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cells

IoInterconnectBytes

Declaration

[JsonProperty(PropertyName = "ioInterconnectBytes")]
public long? IoInterconnectBytes { get; set; }

Property Value

Type	Description
long?	Number of I/O bytes exchanged between Oracle Database and the storage system. Typically used for Cache Fusion or parallel queries

JavaExecTimeInUs

Declaration

[JsonProperty(PropertyName = "javaExecTimeInUs")]
public long? JavaExecTimeInUs { get; set; }

Property Value

Type	Description
long?	Java execution time (in microseconds)

LastActiveTime

Declaration

[JsonProperty(PropertyName = "lastActiveTime")]
public string LastActiveTime { get; set; }

Property Value

Type	Description
string	last_active_time Example: "0000000099CCE300"

Loads

Declaration

[JsonProperty(PropertyName = "loads")]
public long? Loads { get; set; }

Property Value

Type	Description
long?	Number of times the object was either loaded or reloaded

Module

Declaration

[JsonProperty(PropertyName = "module")]
public string Module { get; set; }

Property Value

Type	Description
string	Module name

ObsoleteCount

Declaration

[JsonProperty(PropertyName = "obsoleteCount")]
public long? ObsoleteCount { get; set; }

Property Value

Type	Description
long?	Number of times that a parent cursor became obsolete

OptimizerCost

Declaration

[JsonProperty(PropertyName = "optimizerCost")]
public long? OptimizerCost { get; set; }

Property Value

Type	Description
long?	Cost of this query given by the optimizer

ParseCalls

Declaration

[JsonProperty(PropertyName = "parseCalls")]
public long? ParseCalls { get; set; }

Property Value

Type	Description
long?	Total integer of parse calls Example: 60

PhysicalReadBytes

Declaration

[JsonProperty(PropertyName = "physicalReadBytes")]
public long? PhysicalReadBytes { get; set; }

Property Value

Type	Description
long?	Number of bytes read from disks by the monitored SQL

PhysicalReadRequests

Declaration

[JsonProperty(PropertyName = "physicalReadRequests")]
public long? PhysicalReadRequests { get; set; }

Property Value

Type	Description
long?	Number of physical read I/O requests issued by the monitored SQL. The requests may not be disk reads

PhysicalWriteBytes

Declaration

[JsonProperty(PropertyName = "physicalWriteBytes")]
public long? PhysicalWriteBytes { get; set; }

Property Value

Type	Description
long?	Number of bytes written to disks by the monitored SQL

PhysicalWriteRequests

Declaration

[JsonProperty(PropertyName = "physicalWriteRequests")]
public long? PhysicalWriteRequests { get; set; }

Property Value

Type	Description
long?	Number of physical write I/O requests issued by the monitored SQL

PlanHashValue

Declaration

[Required(ErrorMessage = "PlanHashValue is required.")]
[JsonProperty(PropertyName = "planHashValue")]
public long? PlanHashValue { get; set; }

Property Value

Type	Description
long?	Plan hash value for the SQL Execution Plan

Remarks

Required

PlsqlExecTimeInUs

Declaration

[JsonProperty(PropertyName = "plsqlExecTimeInUs")]
public long? PlsqlExecTimeInUs { get; set; }

Property Value

Type	Description
long?	PL/SQL execution time (in microseconds)

PxServersExecutions

Declaration

[JsonProperty(PropertyName = "pxServersExecutions")]
public long? PxServersExecutions { get; set; }

Property Value

Type	Description
long?	Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel)

RowsProcessed

Declaration

[JsonProperty(PropertyName = "rowsProcessed")]
public long? RowsProcessed { get; set; }

Property Value

Type	Description
long?	Number of row processed

SerializableAborts

Declaration

[JsonProperty(PropertyName = "serializableAborts")]
public long? SerializableAborts { get; set; }

Property Value

Type	Description
long?	Number of serializable aborts

Service

Declaration

[JsonProperty(PropertyName = "service")]
public string Service { get; set; }

Property Value

Type	Description
string	Service name

SharableMem

Declaration

[JsonProperty(PropertyName = "sharableMem")]
public long? SharableMem { get; set; }

Property Value

Type	Description
long?	Total shared memory (in bytes) currently occupied by all cursors with this SQL text and plan

SharableMemRank

Declaration

[JsonProperty(PropertyName = "sharableMemRank")]
public long? SharableMemRank { get; set; }

Property Value

Type	Description
long?	Rank based on sharable memory

Sorts

Declaration

[JsonProperty(PropertyName = "sorts")]
public long? Sorts { get; set; }

Property Value

Type	Description
long?	Number of sorts that were done for the child cursor

SqlIdentifier

Declaration

[Required(ErrorMessage = "SqlIdentifier is required.")]
[JsonProperty(PropertyName = "sqlIdentifier")]
public string SqlIdentifier { get; set; }

Property Value

Type	Description
string	Unique SQL_ID for a SQL Statement.

Remarks

Required

SqlPatch

Declaration

[JsonProperty(PropertyName = "sqlPatch")]
public string SqlPatch { get; set; }

Property Value

Type	Description
string	SQL patch used for this statement, if any

SqlPlanBaseline

Declaration

[JsonProperty(PropertyName = "sqlPlanBaseline")]
public string SqlPlanBaseline { get; set; }

Property Value

Type	Description
string	SQL plan baseline used for this statement, if any

SqlProfile

Declaration

[JsonProperty(PropertyName = "sqlProfile")]
public string SqlProfile { get; set; }

Property Value

Type	Description
string	SQL profile used for this statement, if any

TimeCollected

Declaration

[Required(ErrorMessage = "TimeCollected is required.")]
[JsonProperty(PropertyName = "timeCollected")]
public DateTime? TimeCollected { get; set; }

Property Value

Type	Description
DateTime?	Collection timestamp Example: "2020-03-31T00:00:00.000Z"

Remarks

Required

TotalSharableMem

Declaration

[JsonProperty(PropertyName = "totalSharableMem")]
public long? TotalSharableMem { get; set; }

Property Value

Type	Description
long?	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)

TotalSqlCount

Declaration

[JsonProperty(PropertyName = "totalSqlCount")]
public long? TotalSqlCount { get; set; }

Property Value

Type	Description
long?	Total number of rows in SQLStats table

TypeCheckMem

Declaration

[JsonProperty(PropertyName = "typeCheckMem")]
public long? TypeCheckMem { get; set; }

Property Value

Type	Description
long?	Typecheck memory

UserIoWaitTimeInUs

Declaration

[JsonProperty(PropertyName = "userIoWaitTimeInUs")]
public long? UserIoWaitTimeInUs { get; set; }

Property Value

Type	Description
long?	User I/O wait time (in microseconds)

UsersExecuting

Declaration

[JsonProperty(PropertyName = "usersExecuting")]
public long? UsersExecuting { get; set; }

Property Value

Type	Description
long?	Number of users executing the statement

UsersOpening

Declaration

[JsonProperty(PropertyName = "usersOpening")]
public long? UsersOpening { get; set; }

Property Value

Type	Description
long?	Number of users that have any of the child cursors open

VersionCount

Declaration

[JsonProperty(PropertyName = "versionCount")]
public long? VersionCount { get; set; }

Property Value

Type	Description
long?	Number of cursors present in the cache with this SQL text and plan

WtHarmonicSum

Declaration

[JsonProperty(PropertyName = "wtHarmonicSum")]
public long? WtHarmonicSum { get; set; }

Property Value

Type	Description
long?	Weight based harmonic sum of ranking parameters