[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | DBA_SQL_PLAN_BASELINES |
|---|---|
| Object Type: | VIEW |
| Owner: | SYS |
| Subobject Name: | |
| Status: | VALID |
set of plan baselines
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SIGNATURE | NUMBER | Yes | unique SQL identifier generated from normalized SQL text | |
| SQL_HANDLE | VARCHAR2 | (128) | Yes | unique SQL identifier in string form as a search key |
| SQL_TEXT | CLOB | (4000) | Yes | un-normalized SQL text |
| PLAN_NAME | VARCHAR2 | (128) | Yes | unique plan identifier in string form as a search key |
| CREATOR | VARCHAR2 | (128) | user who created the plan baseline | |
| ORIGIN | VARCHAR2 | (14) | how plan baseline was created | |
| PARSING_SCHEMA_NAME | VARCHAR2 | (128) | name of parsing schema | |
| DESCRIPTION | VARCHAR2 | (500) | text description provided for plan baseline | |
| VERSION | VARCHAR2 | (64) | database version at time of plan baseline creation | |
| CREATED | TIMESTAMP(6) | (11) | Yes | time when plan baseline was created |
| LAST_MODIFIED | TIMESTAMP(6) | (11) | time when plan baseline was last modified | |
| LAST_EXECUTED | TIMESTAMP(6) | (11) | time when plan baseline was last executed | |
| LAST_VERIFIED | TIMESTAMP(6) | (11) | time when plan baseline was last verified | |
| ENABLED | VARCHAR2 | (3) | enabled status of plan baseline | |
| ACCEPTED | VARCHAR2 | (3) | accepted status of plan baseline | |
| FIXED | VARCHAR2 | (3) | fixed status of plan baseline | |
| REPRODUCED | VARCHAR2 | (3) | reproduced status of plan baseline | |
| AUTOPURGE | VARCHAR2 | (3) | auto-purge status of plan baseline | |
| ADAPTIVE | VARCHAR2 | (3) | adaptive status of plan baseline | |
| OPTIMIZER_COST | NUMBER | plan baseline optimizer cost | ||
| MODULE | VARCHAR2 | (64) | application module name | |
| ACTION | VARCHAR2 | (64) | application action | |
| EXECUTIONS | NUMBER | number of plan baseline executions | ||
| ELAPSED_TIME | NUMBER | total elapse time | ||
| CPU_TIME | NUMBER | total CPU time | ||
| BUFFER_GETS | NUMBER | total buffer gets | ||
| DISK_READS | NUMBER | total disk reads | ||
| DIRECT_WRITES | NUMBER | total direct writes | ||
| ROWS_PROCESSED | NUMBER | total rows processed | ||
| FETCHES | NUMBER | total number of fetches | ||
| END_OF_FETCH_COUNT | NUMBER | total number of full fetches |
Cut, paste (and edit) the following text to query this object:
SELECT SIGNATURE
, SQL_HANDLE
, SQL_TEXT
, PLAN_NAME
, CREATOR
, ORIGIN
, PARSING_SCHEMA_NAME
, DESCRIPTION
, VERSION
, CREATED
, LAST_MODIFIED
, LAST_EXECUTED
, LAST_VERIFIED
, ENABLED
, ACCEPTED
, FIXED
, REPRODUCED
, AUTOPURGE
, ADAPTIVE
, OPTIMIZER_COST
, MODULE
, ACTION
, EXECUTIONS
, ELAPSED_TIME
, CPU_TIME
, BUFFER_GETS
, DISK_READS
, DIRECT_WRITES
, ROWS_PROCESSED
, FETCHES
, END_OF_FETCH_COUNT
FROM SYS.DBA_SQL_PLAN_BASELINES;
SYS
SQL$TEXT
SQLOBJ$
SQLOBJ$AUXDATA
PUBLIC
DBA_SQL_PLAN_BASELINES
SYS
DBMS_SPM_INTERNAL
- show dependent code
|
|
|
|