>100 Views
April 12, 15
スライド概要
Slideshare移行 2023-08-10時点View : 7323 views
個人事業主/Love SQL/Tuning/DBエンジニア/JPOUG/Oracle ACE Pro/ex-AWS BigData Consultant/ex-DEC/Oracle,PostgreSQL,Aurora,Redshift,Athena,SCT,DMS,Glue/偶にNowPlaying♪垂れ流し/
〜 1
👻 5
👻 〜 SQL$ID:$b3gz8wsDmw9f CPU$Time$ User$I/O$Wait$Time$$ CPU$Time$ 39% Cluster$Wait$Time$ ApplicaKon$Wait$Time$$ !!!! 60% 👻 Concurrency$Wait$Time$$ !!!! Concurrency$Wait$ Time$$ 1%$ 6
7
8
SQL$ID:$b3gz8wsDmw9f CPU$Time$ User$I/O$Wait$Time$$ CPU$Time$ 39% Cluster$Wait$Time$ ApplicaKon$Wait$Time$$ !!!! 60% 👻 Concurrency$Wait$Time$$ !!!! Concurrency$Wait$ Time$$ 1%$
10
👻 11
👻 12
TIME --------------20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 20150327 114938 USERNAME -----------------------------SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT SCOTT 👻 13 STATUS -------INACTIVE INACTIVE INACTIVE INACTIVE ACTIVE INACTIVE INACTIVE INACTIVE INACTIVE INACTIVE INACTIVE INACTIVE INACTIVE INACTIVE INACTIVE INACTIVE INACTIVE INACTIVE INACTIVE INACTIVE ACTIVE INACTIVE INACTIVE INACTIVE ACTIVE ACTIVE INACTIVE INACTIVE INACTIVE INACTIVE INACTIVE INACTIVE EVENT ------------------------SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message to client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client SQL*Net message from client
14
23時48分43秒 CPU %user %nice %system %iowait %steal %idle 23時48分48秒 all 69.85 0.05 29.84 0.00 0.00 0.26 23時48分48秒 0 72.69 0.00 27.10 0.00 0.00 0.21 23時48分48秒 1 65.55 0.00 34.03 0.00 0.00 0.42 23時48分48秒 2 72.15 0.00 27.64 0.00 0.00 0.21 23時48分48秒 3 68.94 0.00 30.85 0.00 0.00 0.21 23時48分48秒 CPU %user %nice %system %iowait %steal %idle 23時48分53秒 all 69.71 0.00 30.29 0.00 0.00 0.00 23時48分53秒 0 71.25 0.00 28.75 0.00 0.00 0.00 23時48分53秒 1 65.69 0.00 34.31 0.00 0.00 0.00 23時48分53秒 2 71.93 0.00 28.07 0.00 0.00 0.00 23時48分53秒 3 69.85 0.00 30.15 0.00 0.00 0.00 23時48分53秒 CPU %user %nice %system %iowait %steal %idle 23時48分58秒 all 70.29 0.00 29.66 0.00 0.00 0.05 23時48分58秒 0 72.56 0.00 27.44 0.00 0.00 0.00 23時48分58秒 1 67.01 0.00 32.99 0.00 0.00 0.00 23時48分58秒 2 70.62 0.00 29.38 0.00 0.00 0.00 23時48分58秒 3 71.01 0.00 28.78 0.00 0.00 0.21 15
16
17
call count ------- -----Parse 4684 Execute 4684 Fetch 4684 ------- -----total 14052 cpu elapsed disk query current -------- ---------- ---------- ---------- ---------0.04 0.24 0 0 0 0.12 0.40 0 0 0 0.13 0.35 0 4684 0 -------- ---------- ---------- ---------- ---------0.30 0.99 0 4684 0 Elapsed times include waiting on following events: Event waited on Times ---------------------------------------Waited SQL*Net message to client 4684 SQL*Net message from client 4684 Max. Wait ---------0.00 0.10 AME WAIT_CLASS ---------------------------------------- -------------------SQL*Net message to client Network SQL*Net message from client Idle 18 rows ---------0 0 0 ---------0 Total Waited -----------0.03 31.00
👻 23時48分27秒 runq-sz plist-sz ldavg-1 ldavg-5 ldavg-15 23時48分32秒 15 437 15.37 7.25 3.62 23時48分37秒 24 437 15.18 7.35 3.67 23時48分42秒 10 437 15.01 7.44 3.72 23時48分47秒 27 437 14.85 7.54 3.77 23時48分52秒 14 437 14.94 7.68 3.83 23時48分57秒 22 437 15.18 7.85 3.91 23時49分02秒 20 437 15.25 7.98 3.97 19
👻👻👻👻👻 👻 20
http://www.jpoug.org 21 ✌