[ALTIBASE] 수행중인 쿼리의 실행계획 확인

select

       to_char(sysdate, 'yyyy/mm/dd hh24:mi:ss')||', P : '||parse_time/1000000||', E: '

       ||execute_time/1000000||', F: '||fetch_time/1000000||', T:'||total_time/1000000||', IP: '

       || substring(comm_name, instr(comm_name, 'P')+1, instr(comm_name, ':') - (instr(comm_name, 'P')+1))||', Query : '

       ,rpad(query, 60)

       ,p.sid, p.text, p.piece

from v$statement a, v$session b, V$PLANTEXT p

where execute_flag = 1

and a.session_id = b.id

and a.session_id != session_id()

and a.session_id = p.sid

order by p.sid,p.piece;