728x90 반응형 oracle parse1 [ORACLE] EXECUTE, PARSE, HARD PARSE 성능 분석 쿼리 ※ :DBID :INSTANCE_NUMBER :BEGIN_SNAP_ID :END_SNAP_ID 값 설정후 스크립트 실행 snap_id 찾기 select snap_id, to_char(min(begin_time),'dd hh24:mi') DTIME, to_char(min(end_time),'dd hh24:mi') ETIME FROM DBA_HIST_SYSMETRIC_SUMMARY WHERE begin_time > sysdate-2 and instance_number=1 group by snap_id order by snap_id / Execute select TO_CHAR(END_INTERVAL_TIME, 'DD HH24:MI') TIME, round(EXECUTES/EL,2) "Executes" from.. 2023. 2. 8. 이전 1 다음 728x90 반응형