Class SqlStats
Sql Stats type object.
Inherited Members
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 |