ADM_HIST_SQL_PLAN
ADM_HIST_SQL_PLAN displays plan information collected by the current user by running the EXPLAIN PLAN statement.
| 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.