Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
How to get actual number of rows (A-Rows) to display in the Rows column of the Explain Plan tab
설명
When DBMS_XPlan is set for the display mode in the Explain Plan tab, it always shows E-Rows as the column header for the Rows column. How can a user get the A-Rows to appear, to see the actual number of rows, instead of the estimated number of rows?
해결 방안
Use the GATHER_PLAN_STATISTICS hint in the query to get the actual Row count.
Click here for an article explaining this further.
