You can use @OracleSQLDev to get #SQL execution plans
But your user needs access to v$ views!
Create a PLUSTRACE role with select on SYS:
V_$MYSTAT
V_$SESSION
V_$SESSTAT
V_$SQL
V_$SQL_PLAN
V_$SQL_PLAN_STATISTICS
V_$SQL_PLAN_STATISTICS_ALL
V_$STATNAME
https://t.co/XkZKzScQ22
@craigkerstiens I agree. Today Sql like C or C++. Many young programmer know about this, but not understand. Optimization for this programmer is impossible.