IT 냉동인간 미니대왕님(miniking)

[오라클 튜닝] instance 튜닝2 1. 디스크 I/O 상태 분석 -> I/O 횟수가 한 쪽으로 심하게 몰릴 경우 데이터파일 재구성 검토 vi disk_io.sql -------------------------------------------------------------------------------- set pagesize 66 set linesize 140 set echo off set feedback off set verify off ttitle 'Disk I/O per Disk Files' col tablespace_name heading 'Tablespace Name' format a10 col file_name heading 'File Name' format a50 col phyrds..

trace 확인 sql -------------------------------------------------------------------------------- conn / as sysdba show parameter user_dump_dest grant alter session to scott; conn scott/tiger alter session set sql_trace=true; select * from dept; ! cd [user_dump_dest] ex ) cd /app/oracle/diag/rdbms/testdb/testdb/trace tkprof testdb_ora_28098.trc testdb_ora_28098.tkf explain=scott/tiger sys=no tail -1..