Updated on 2025-07-15 GMT+08:00

ADM_HIST_SQL_PLAN

ADM_HIST_SQL_PLAN displays plan information collected by the current user by running the EXPLAIN PLAN statement.

Table 1 ADM_HIST_SQL_PLAN columns

Name

Type

Description

sql_id

character varying(30)

Session that inserts the data. Its value consists of a worker thread start timestamp and a worker thread ID. Values are constrained by NOT NULL.

plan_hash_value

bigint

Query ID.

operation

character varying(30)

Operation description.

options

character varying(255)

Operation option.

object_name

name

Name of an operated object. It is defined by users.