set pagesize 30000 column name format a70 column value format 999999999999999 select sid,name,value from V$SESSTAT vss,V$statname vst where sid = &1 --and vss.statistic# in (2,3) and vss.STATISTIC# = vst.STATISTIC# and lower(vst.name) like lower('%&2%') order by sid,name;