Class SqlPlanLine

SQL Plan Line type object.

Inheritance

object

SqlPlanLine

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 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'))"

ForceMatchingSignature

Declaration

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

Property Value

Type	Description
string	Force matching signature Example: "18067345456756876713"

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

TimeGenerated

Declaration

[JsonProperty(PropertyName = "timeGenerated")]
public DateTime? TimeGenerated { get; set; }

Property Value

Type	Description
DateTime?	Generation time stamp Example: "2020-05-05T02:10:00.000Z"

Version

Declaration

[JsonProperty(PropertyName = "version")]
public float? Version { get; set; }

Property Value

Type	Description
float?	Version Example: 1