DBMS_XPLAN.DISPLAY_CURSOR and "User has no SELECT privilege"
I have been making use of the GATHER_PLAN_STATISTICS hint more and more lately. In the interest of getting the most accurate data I usually log in as the user that normally executes the query. These are usually non-privileged accounts that just have access to their…