[Home] [Help] [Dependency Information]
Object Name: | GV_$PGATARGET_ADVICE_HISTOGRAM |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
PGA_TARGET_FOR_ESTIMATE | NUMBER | |||
PGA_TARGET_FACTOR | NUMBER | |||
ADVICE_STATUS | VARCHAR2 | (3) | ||
LOW_OPTIMAL_SIZE | NUMBER | |||
HIGH_OPTIMAL_SIZE | NUMBER | |||
ESTD_OPTIMAL_EXECUTIONS | NUMBER | |||
ESTD_ONEPASS_EXECUTIONS | NUMBER | |||
ESTD_MULTIPASSES_EXECUTIONS | NUMBER | |||
ESTD_TOTAL_EXECUTIONS | NUMBER | |||
IGNORED_WORKAREAS_COUNT | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, PGA_TARGET_FOR_ESTIMATE
, PGA_TARGET_FACTOR
, ADVICE_STATUS
, LOW_OPTIMAL_SIZE
, HIGH_OPTIMAL_SIZE
, ESTD_OPTIMAL_EXECUTIONS
, ESTD_ONEPASS_EXECUTIONS
, ESTD_MULTIPASSES_EXECUTIONS
, ESTD_TOTAL_EXECUTIONS
, IGNORED_WORKAREAS_COUNT
, CON_ID
FROM SYS.GV_$PGATARGET_ADVICE_HISTOGRAM;
|
|
|