Access predicates Example: {@code "\"RESOURCE_ID\"=:1 AND \"QUERY_ID\"=:2"}
Bytes Example: {@code 150} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Cardinality Example: {@code 1} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Cost Example: {@code 1} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
CPU cost Example: {@code 7321} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Depth Example: {@code 3} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Distribution Example: {@code "QC (RANDOM)"}
Total elapsed time Example: {@code 1.2} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Filter predicates Example: {@code "(INTERNAL_FUNCTION(\"J\".\"DATABASE_ROLE\") OR (\"J\".\"DATABASE_ROLE\" IS NULL AND SYS_CONTEXT('userenv','database_role')='PRIMARY'))"}
Identifier Example: {@code 3} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
IO cost Example: {@code 1} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Object Alias Example: {@code "PLAN_LINES@SEL$1"}
Object Instance Example: {@code 37472} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Object Name Example: {@code "PLAN_LINES_PK"}
Object Node Example: {@code "Q4000"}
Object Owner Example: {@code "TENANT_A#SCHEMA"}
Object Type Example: {@code "INDEX (UNIQUE)"}
Operation Example: {@code "SELECT STATEMENT"}
Optimizer Example: {@code "CLUSTER"}
Options Example: {@code "RANGE SCAN"}
Other Example:
Other Tag Example: {@code "PARALLEL_COMBINED_WITH_PARENT"}
Other SQL
Example: {@code "
Parent Identifier Example: {@code 2} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Partition identifier Example: {@code 8} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Partition start Example: {@code 1}
Partition stop Example: {@code 2}
Plan hash value for the SQL Execution Plan Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Position Example: {@code 1} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Projection Example: {@code "COUNT(*)[22]"}
Qblock Name Example: {@code "SEL$1"}
Remark Example: {@code ""}
Search Columns Example: {@code 3} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Unique SQL_ID for a SQL Statement.
Time space Example: {@code 15614000} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Collection time stamp Example: {@code "2020-05-06T00:00:00.000Z"}
Version Example: {@code 1} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
SQL Plan Line type object.