Keyword: ADVICE
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| GV$DB_CACHE_ADVICE | Synonym for GV_$DB_CACHE_ADVICE |
| GV$MTTR_TARGET_ADVICE | Synonym for GV_$MTTR_TARGET_ADVICE |
| GV$PGA_TARGET_ADVICE | Synonym for GV_$PGA_TARGET_ADVICE |
| GV$PGA_TARGET_ADVICE_HISTOGRAM | Synonym for GV_$PGATARGET_ADVICE_HISTOGRAM |
| GV$SHARED_POOL_ADVICE | Synonym for GV_$SHARED_POOL_ADVICE |
| V$DB_CACHE_ADVICE | Synonym for V_$DB_CACHE_ADVICE |
| V$MTTR_TARGET_ADVICE | Synonym for V_$MTTR_TARGET_ADVICE |
| V$PGA_TARGET_ADVICE | Synonym for V_$PGA_TARGET_ADVICE |
| V$PGA_TARGET_ADVICE_HISTOGRAM | Synonym for V_$PGA_TARGET_ADVICE_HISTOGRAM |
| V$SHARED_POOL_ADVICE | Synonym for V_$SHARED_POOL_ADVICE |
Columns
| Column Name | Description |
|---|---|
| ADVICE (DBA_2PC_PENDING) | C for commit, R for rollback, else null |
| ADVICE_STATUS (GV$DB_CACHE_ADVICE) | |
| ADVICE_STATUS (GV$PGA_TARGET_ADVICE) | |
| ADVICE_STATUS (GV$PGA_TARGET_ADVICE_HISTOGRAM) | |
| ADVICE_STATUS (V$MTTR_TARGET_ADVICE) | |
| ADVICE_STATUS (V$PGA_TARGET_ADVICE_HISTOGRAM) | |
| ADVICE_STATUS (GV$MTTR_TARGET_ADVICE) | |
| ADVICE_STATUS (V$PGA_TARGET_ADVICE) | |
| ADVICE_STATUS (V$DB_CACHE_ADVICE) |