|
|
[ÀϹÝ] Sql Tuning - TKPROF È°¿ëÇϱâ |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 211.¢½.74.31 |
ÀÐÀ½:3481 |
|
|
Sql Tuning - TKPROF | ORACLE 2005/04/15 10:54
http://blog.naver.com/lastcom/20011726596
plan ¿¡¼ ¹ß»ýÇÏÁö¾Ê´Â cpu,i/oÁ¤º¸ rowsÀÇ ¼ö±îÁö Á» ´õ detail ÇÏ°Ô º¼ ¼ö ÀÖ´Ù.
.trc ÆÄÀÏ »ý¼º
SQL>ALTER SESSION SET SQL_TRACE = TRUE;
SQL>ALTER SESSION SET TIMED_STATISTICS = TRUE;
SQL>select sysdate from dual;
SQL>ALTER SESSION SET TIMED_STATISTICS = FALSE;
SQL>ALTER SESSION SET SQL_TRACE = FALSE;
ÇöÀç ¼³Á¤µÈ °æ·Î
show parameter user_dump_dest;
Æǵ¶¼º ÀÖ´Â data ·Î º¯È¯
À§ °æ·Î/tkprof ora01208.trc tuning sys=no aggregate=no explain=scott/tiger
select sysdate
from
dual
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.01 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 1 4 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.01 0.01 0 1 4 1
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 47 (GSYSTEM)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: CHOOSE
0 TABLE ACCESS (FULL) OF 'DUAL'
|
|
|
|
|
|