> So, the question is there any way to get "complete" execution plan for > SELECT that includes scalar subquery? Old and good (most of the time) 'explain plan', I think. --=20 Egor http://www.oracledba.ru/orasrp/ Free Oracle Session Resource Profiler -- //www.freelists.org/webpage/oracle-l