Class SqlPlanLine
SQL Plan Line type object.
Inherited Members
Namespace: Oci.OpsiService.Models
Assembly: OCI.DotNetSDK.Opsi.dll
Syntax
public class SqlPlanLine
Properties
AccessPredicates
Declaration
[JsonProperty(PropertyName = "accessPredicates")]
public string AccessPredicates { get; set; }
Property Value
Type | Description |
---|---|
string | Access predicates Example: "\"RESOURCE_ID\"=:1 AND \"QUERY_ID\"=:2" |
Bytes
Declaration
[JsonProperty(PropertyName = "bytes")]
public long? Bytes { get; set; }
Property Value
Type | Description |
---|---|
long? | Bytes Example: 150 |
Cardinality
Declaration
[JsonProperty(PropertyName = "cardinality")]
public long? Cardinality { get; set; }
Property Value
Type | Description |
---|---|
long? | Cardinality Example: 1 |
Cost
Declaration
[JsonProperty(PropertyName = "cost")]
public long? Cost { get; set; }
Property Value
Type | Description |
---|---|
long? | Cost Example: 1 |
CpuCost
Declaration
[JsonProperty(PropertyName = "cpuCost")]
public long? CpuCost { get; set; }
Property Value
Type | Description |
---|---|
long? | CPU cost Example: 7321 |
Depth
Declaration
[JsonProperty(PropertyName = "depth")]
public long? Depth { get; set; }
Property Value
Type | Description |
---|---|
long? | Depth Example: 3 |
Distribution
Declaration
[JsonProperty(PropertyName = "distribution")]
public string Distribution { get; set; }
Property Value
Type | Description |
---|---|
string | Distribution Example: "QC (RANDOM)" |
ElapsedTimeInSec
Declaration
[JsonProperty(PropertyName = "elapsedTimeInSec")]
public float? ElapsedTimeInSec { get; set; }
Property Value
Type | Description |
---|---|
float? | Total elapsed time Example: 1.2 |
FilterPredicates
Declaration
[JsonProperty(PropertyName = "filterPredicates")]
public string FilterPredicates { get; set; }
Property Value
Type | Description |
---|---|
string | Filter predicates Example: "(INTERNAL_FUNCTION(\"J\".\"DATABASE_ROLE\") OR (\"J\".\"DATABASE_ROLE\" IS NULL AND SYS_CONTEXT('userenv','database_role')='PRIMARY'))" |
Identifier
Declaration
[Required(ErrorMessage = "Identifier is required.")]
[JsonProperty(PropertyName = "identifier")]
public long? Identifier { get; set; }
Property Value
Type | Description |
---|---|
long? | Identifier Example: 3 |
Remarks
Required
IoCost
Declaration
[JsonProperty(PropertyName = "ioCost")]
public long? IoCost { get; set; }
Property Value
Type | Description |
---|---|
long? | IO cost Example: 1 |
ObjectAlias
Declaration
[JsonProperty(PropertyName = "objectAlias")]
public string ObjectAlias { get; set; }
Property Value
Type | Description |
---|---|
string | Object Alias Example: "PLAN_LINES@SEL$1" |
ObjectInstance
Declaration
[JsonProperty(PropertyName = "objectInstance")]
public long? ObjectInstance { get; set; }
Property Value
Type | Description |
---|---|
long? | Object Instance Example: 37472 |
ObjectName
Declaration
[JsonProperty(PropertyName = "objectName")]
public string ObjectName { get; set; }
Property Value
Type | Description |
---|---|
string | Object Name Example: "PLAN_LINES_PK" |
ObjectNode
Declaration
[JsonProperty(PropertyName = "objectNode")]
public string ObjectNode { get; set; }
Property Value
Type | Description |
---|---|
string | Object Node Example: "Q4000" |
ObjectOwner
Declaration
[JsonProperty(PropertyName = "objectOwner")]
public string ObjectOwner { get; set; }
Property Value
Type | Description |
---|---|
string | Object Owner Example: "TENANT_A#SCHEMA" |
ObjectType
Declaration
[JsonProperty(PropertyName = "objectType")]
public string ObjectType { get; set; }
Property Value
Type | Description |
---|---|
string | Object Type Example: "INDEX (UNIQUE)" |
Operation
Declaration
[Required(ErrorMessage = "Operation is required.")]
[JsonProperty(PropertyName = "operation")]
public string Operation { get; set; }
Property Value
Type | Description |
---|---|
string | Operation Example: "SELECT STATEMENT" |
Remarks
Required
Optimizer
Declaration
[JsonProperty(PropertyName = "optimizer")]
public string Optimizer { get; set; }
Property Value
Type | Description |
---|---|
string | Optimizer Example: "CLUSTER" |
Options
Declaration
[JsonProperty(PropertyName = "options")]
public string Options { get; set; }
Property Value
Type | Description |
---|---|
string | Options Example: "RANGE SCAN" |
Other
Declaration
[JsonProperty(PropertyName = "other")]
public string Other { get; set; }
Property Value
Type | Description |
---|---|
string | Other Example: |
OtherTag
Declaration
[JsonProperty(PropertyName = "otherTag")]
public string OtherTag { get; set; }
Property Value
Type | Description |
---|---|
string | Other Tag Example: "PARALLEL_COMBINED_WITH_PARENT" |
OtherXML
Declaration
[JsonProperty(PropertyName = "otherXML")]
public string OtherXML { get; set; }
Property Value
Type | Description |
---|---|
string |
ParentIdentifier
Declaration
[JsonProperty(PropertyName = "parentIdentifier")]
public long? ParentIdentifier { get; set; }
Property Value
Type | Description |
---|---|
long? | Parent Identifier Example: 2 |
PartitionIdentifier
Declaration
[JsonProperty(PropertyName = "partitionIdentifier")]
public long? PartitionIdentifier { get; set; }
Property Value
Type | Description |
---|---|
long? | Partition identifier Example: 8 |
PartitionStart
Declaration
[JsonProperty(PropertyName = "partitionStart")]
public string PartitionStart { get; set; }
Property Value
Type | Description |
---|---|
string | Partition start Example: 1 |
PartitionStop
Declaration
[JsonProperty(PropertyName = "partitionStop")]
public string PartitionStop { get; set; }
Property Value
Type | Description |
---|---|
string | Partition stop Example: 2 |
PlanHash
Declaration
[Required(ErrorMessage = "PlanHash is required.")]
[JsonProperty(PropertyName = "planHash")]
public long? PlanHash { get; set; }
Property Value
Type | Description |
---|---|
long? | Plan hash value for the SQL Execution Plan |
Remarks
Required
Position
Declaration
[JsonProperty(PropertyName = "position")]
public long? Position { get; set; }
Property Value
Type | Description |
---|---|
long? | Position Example: 1 |
Projection
Declaration
[JsonProperty(PropertyName = "projection")]
public string Projection { get; set; }
Property Value
Type | Description |
---|---|
string | Projection Example: "COUNT(*)[22]" |
QblockName
Declaration
[JsonProperty(PropertyName = "qblockName")]
public string QblockName { get; set; }
Property Value
Type | Description |
---|---|
string | Qblock Name Example: "SEL$1" |
Remark
Declaration
[JsonProperty(PropertyName = "remark")]
public string Remark { get; set; }
Property Value
Type | Description |
---|---|
string | Remark Example: "" |
SearchColumns
Declaration
[JsonProperty(PropertyName = "searchColumns")]
public long? SearchColumns { get; set; }
Property Value
Type | Description |
---|---|
long? | Search Columns Example: 3 |
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
TempSpace
Declaration
[JsonProperty(PropertyName = "tempSpace")]
public long? TempSpace { get; set; }
Property Value
Type | Description |
---|---|
long? | Time space Example: 15614000 |
TimeCollected
Declaration
[Required(ErrorMessage = "TimeCollected is required.")]
[JsonProperty(PropertyName = "timeCollected")]
public DateTime? TimeCollected { get; set; }
Property Value
Type | Description |
---|---|
DateTime? | Collection time stamp Example: "2020-05-06T00:00:00.000Z" |
Remarks
Required
Version
Declaration
[JsonProperty(PropertyName = "version")]
public float? Version { get; set; }
Property Value
Type | Description |
---|---|
float? | Version Example: 1 |