歯sql_tuning2

Size: px

Start display at page:

Download "歯sql_tuning2"

서웅 호
5 years ago
Views:

1 <Tuning > SQL Tuning (2) SQL SQL SQL Tuning

3 ROW(1) ROW(2) ROW(n) update ROW(2) at time 1 & Uncommitted update ROW(2) at time 2 UTLLOCKT WAITING_SESSION TYPE MODE_REQUESTED MODE_HELD LOCK_ID1 LOCK_ID NONE NONE NONE TX EXCLUSIVE EXCLUSIVE ❶ `10` COMMIT or ROLLBACK ❷ SQL*DBA Monitor `KILL SESSION` `10` KILL

5 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * SELECT * FROM EMP WHERE DEPTNO = 10 ORDER BY JOB call count cpu elapsed disk query current rows Parse Execute Fetch Toatl Misses in Library cache during parse : 1 Parsing user id = 12 (scott( scott) Rows Execution Plan select statement 100 sort (order by) 100 table access by rowid of emp index range scan of emp_idxq * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

13 3GL? HOLD_CURSOR? LOOP SQL? OVERALL SQL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows Parse Execute Fetch Total Misses in Library cache during parse : user SQL statements in session. 9 internal SQL statements in session. 741 SQL statements in session. EXPLAINed 59 statements in this session. OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS count cpu call count cpu elapsed disk query current rows Parse Execute Fetch Total Misses in Library cache during parse : user SQL statements in session. 9 internal SQL statements in session. 741 SQL statements in session. EXPLAINed 59 statements in this session. (Parse count * 0.01) cpu

14 OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows Parse Execute Fetch Total Misses in Library cache during parse : 30 e disk q (Parse count *.0.03) disk 62 user SQL statements in session. 9 internal SQL statements in session. 741 SQL statements in session. EXPLAINed 59 statements in this session. OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows Parse Execute Fetch Total Misses in Library cache during parse : user SQL statements in session. 9 internal SQL statements in session. 741 SQL statements in session. EXPLAINed 59 statements in this session. disk query curr (Execute disk + Fetch disk) (Execute query + Fetch query +.Execute current + Fetch current) 10%

15 OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows Parse Execute Fetch Total Misses in Library cache during parse : user SQL statements in session. 9 internal SQL statements in session. 741 SQL statements in session. EXPLAINed 59 statements in SQL this session. OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows > MON LCACHE 'pins'. Parse Execute SQL Fetch Total Misses in Library cache during parse : 30 arse : 30 session. session. 62 user SQL statements in session. 9 internal SQL statements in session. 741 SQL statements in session. EXPLAINed 59 statements in this session.

13주-14주proc.PDF

13주-14주proc.PDF 12 : Pro*C/C++ 1 2 Embeded SQL 3 PRO *C 31 C/C++ PRO *C NOT! NOT AND && AND OR OR EQUAL == = SQL,,, Embeded SQL SQL 32 Pro*C C SQL Pro*C C, C Pro*C, C C 321, C char : char[n] : n int, short, long : float

歯sql_tuning2

歯sql_tuning2