adaptiveplans
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| adaptiveplans [2015/07/22 14:03] – z0hpvk | adaptiveplans [2025/03/08 22:24] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 10: | Line 10: | ||
| With an adaptive plan you may see differences between the estimated rows (E-Rows) and actual rows (A-Rows).\\ | With an adaptive plan you may see differences between the estimated rows (E-Rows) and actual rows (A-Rows).\\ | ||
| - | The v$SQL view has a new column called IS_RESOLVED_ADAPTIVE_PLAN.\\ | + | The V$SQL view has a new column called IS_RESOLVED_ADAPTIVE_PLAN.\\ |
| - | This column can have a value of N, Y or null.\\ | + | This column can have a value of null, Y or N\\ |
| * Null : Non-Adapative Plan | * Null : Non-Adapative Plan | ||
| * Y : Adaptive Plan and a final plan has been selected | * Y : Adaptive Plan and a final plan has been selected | ||
adaptiveplans.1437573784.txt.gz · Last modified: 2025/03/08 22:23 (external edit)