[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;
|
|
|