ASH Report For JKDB/jkdb

DB NameDB IdInstanceInst numReleaseRACHost
JKDB1477930046jkdb111.2.0.1.0NODBSERVER1

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
3222,045M (100%)18,624M (84.5%)3,328M (15.1%)50.0M (0.2%)

Sample TimeData Source
Analysis Begin Time:24-9月 -13 09:40:43V$ACTIVE_SESSION_HISTORY
Analysis End Time:24-9月 -13 09:46:43V$ACTIVE_SESSION_HISTORY
Elapsed Time: 6.0 (mins)  
Sample Count: 13,760 
Average Active Sessions: 38.22 
Avg. Active Session per CPU: 1.19 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% EventAvg Active Sessions
row cache lockConcurrency73.4128.06
CPU + Wait for CPUCPU13.155.03
cursor: mutex SConcurrency5.742.19
library cache lockConcurrency2.410.92
db file sequential readUser I/O1.890.72

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
db file parallel writeSystem I/O1.020.39

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
row cache lock73.41"7","0","3"61.02 cache idmoderequest
  "7","0","5"12.38    
cursor: mutex S5.74"914163366","21474836490","4303502311"0.01 idnvaluewhere
library cache lock2.41"29357352032","29114213696","2"0.14 handle addresslock address100*mode+namespace
db file sequential read1.89"6","41661","1"0.01 file#block#blocks
log file sync1.40"92","1408300946","0"0.01 buffer#sync scnNOT DEFINED

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
JKDBNetVideo.exe33.77UNNAMED33.77
 w3wp.exe27.28UNNAMED27.28
 ORACLE.EXE22.84UNNAMED22.84
 TablesCopier.exe2.86UNNAMED2.86
 UNNAMED2.33UNNAMED2.33

Back to Load Profile
Back to Top

Top Client IDs

No data exists for this section of the report.

Back to Load Profile
Back to Top

Top SQL Command Types

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
SELECT11926.109.98
UPDATE141.530.59
INSERT1371.450.56

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
Connection Management61.4923.50
Parse41.7515.96
Hard Parse22.338.53
SQL Execution18.477.06

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL with Top Events

SQL IDPlanhashSampled # of Executions% ActivityEvent% EventTop Row Source% RwSrcSQL Text
b3tu17s4g0212346988905501.35 row cache lock1.35** Row Source Not Available **1.35 ** SQL Text Not Available **
gkv61pqza3c68106842858301.28 row cache lock1.27** Row Source Not Available **1.27 ** SQL Text Not Available **

Back to Top SQL
Back to Top

Top SQL with Top Row Sources

SQL IDPlanHashSampled # of Executions% ActivityRow Source% RwSrcTop Event% EventSQL Text
b3tu17s4g0212346988905501.35 ** Row Source Not Available **1.35row cache lock1.35 ** SQL Text Not Available **
gkv61pqza3c68106842858301.28 ** Row Source Not Available **1.28row cache lock1.27 ** SQL Text Not Available **

Back to Top SQL
Back to Top

Top SQL using literals

FORCE_MATCHING_SIGNATURE% Activity# of Sampled SQL VersionsExample SQL 1Example SQL TEXT 1Example SQL 2Example SQL TEXT 2
973263422744260118115.4729 18tv6uua2pk4u Select T.LISTNO, T.VEHPLATE, C... fu62y7yg0v9gp Select T.LISTNO, T.VEHPLATE, C...
46024417349136084882.098 3sa2dd8a6bcj8 select * from Device where Dev... bqd0hjuhdryab select * from Device where Dev...
84907843457297763911.2919 168vc2m26j64h Select Contenttype, Decode(Con... fk74sca79bshx Select Contenttype, Decode(Con...

Back to Top SQL
Back to Top

Top Parsing Module/Action

ModuleAction% ActivityEvent% Event
w3wp.exe 21.00row cache lock18.44
   CPU + Wait for CPU1.40
NetVideo.exe 16.16CPU + Wait for CPU8.85
   cursor: mutex S4.40
   library cache lock1.90
  2.35row cache lock2.14
TablesCopier.exe 1.32CPU + Wait for CPU0.90

Back to Top SQL
Back to Top

Complete List of SQL Text

SQL IdSQL Text
168vc2m26j64hSelect Contenttype, Decode(Contenttype, 1, '咨询', 2, '投诉', 3, '建议', 4, '救援', 5, '报料', 6, '举报', 7, '调度指令', 8, '突发性交通事件', 9, '计划性交通事件', 10, '内部通知', 11, '外部公告') As Contenttypename, Contenttitle, a.Contenttitlename, Count(1) Alertgroupno From (Select Contenttype, Contenttitle, t.Contentid, t.Userid From Alert t Where t.Userid = '768' And t.Alerttime <= Sysdate And t.Flags In (0, 2) Group By t.Contenttype, t.Contenttitle, t.Userid, t.Contentid) Left Join Alertcontenttitle a On Contenttitle = a.Contenttitleid Group By Contenttype, Contenttitle, a.Contenttitlename Order By Contenttype
18tv6uua2pk4uSelect T.LISTNO, T.VEHPLATE, C.DEVICENAME, A.AREANAME, B.ROADNAME, D.LANENAME, To_Char(T.OPTIME, 'yyyy-mm-dd HH24:mi:ss') OPTIME, E.DIRECTIONNAME, C.MILEPOST, T.VEHSPEED From (Select T.LISTNO, T.DEVICEID, T.VEHPLATE, T.DIRECTIONNO, T.LANENO, T.OPTIME, T.VEHSPEED From CAPTURELIST T Where LISTNO In (Select * From (Select LISTNO From VEHPLATEBLACKMAIN Where STATUSCODE='3' And LISTNO Is Not Null And OPTIME Is Not Null And VEHPLATE In (Select VEHPLATE From EMPLATTENTION Where EMPLCODE='e7f4c6ae-fa3b-4359-bc16-05f85fc7843c' Union Select VEHPLATE From COMATTENTION Where COMPANYID='23') And OPTIME>=To_Date('2013-09-16 13:20:07', 'yyyy-mm-dd hh24:mi:ss') Order By OPTIME Desc) Where rownum<=10)) T, AREA A, ROADBASE B, DEVICE C, LANECODE D, (select * from ROADDIRECTION ss where ss.directiontype=2 ) E Where T.DEVICEID = C.DEVICEID And A.AREANO = B.AREANO And B.ROADNO = C.ROADNO And T.LANENO = D.LANENO(+) And C.DIRECTIONNO = E.DIRECTIONCODE(+) And C.ROADNO = E.ROADNO(+) Order By T.OPTIME Desc
3sa2dd8a6bcj8select * from Device where DeviceID = (select DeviceID from CaptureList where ListNo ='DA7CE95C-3760-4BE6-881D-A0F99F0EFDA7')
b3tu17s4g0212** SQL Text Not Available **
bqd0hjuhdryabselect * from Device where DeviceID = (select DeviceID from CaptureList where ListNo ='8E532350-8565-472c-8EC5-0175BF486581')
fk74sca79bshxSelect Contenttype, Decode(Contenttype, 1, '咨询', 2, '投诉', 3, '建议', 4, '救援', 5, '报料', 6, '举报', 7, '调度指令', 8, '突发性交通事件', 9, '计划性交通事件', 10, '内部通知', 11, '外部公告') As Contenttypename, Contenttitle, a.Contenttitlename, Count(1) Alertgroupno From (Select Contenttype, Contenttitle, t.Contentid, t.Userid From Alert t Where t.Userid = 'f7d2e7e3-a857-4e2f-8875-75744daf0109' And t.Alerttime <= Sysdate And t.Flags In (0, 2) Group By t.Contenttype, t.Contenttitle, t.Userid, t.Contentid) Left Join Alertcontenttitle a On Contenttitle = a.Contenttitleid Group By Contenttype, Contenttitle, a.Contenttitlename Order By Contenttype
fu62y7yg0v9gpSelect T.LISTNO, T.VEHPLATE, C.DEVICENAME, A.AREANAME, B.ROADNAME, D.LANENAME, To_Char(T.OPTIME, 'yyyy-mm-dd HH24:mi:ss') OPTIME, E.DIRECTIONNAME, C.MILEPOST, T.VEHSPEED From (Select T.LISTNO, T.DEVICEID, T.VEHPLATE, T.DIRECTIONNO, T.LANENO, T.OPTIME, T.VEHSPEED From CAPTURELIST T Where LISTNO In (Select * From (Select LISTNO From VEHPLATEBLACKMAIN Where STATUSCODE='3' And LISTNO Is Not Null And OPTIME Is Not Null And VEHPLATE In (Select VEHPLATE From EMPLATTENTION Where EMPLCODE='1b14eadb-f924-4994-b529-acb5424e330b' Union Select VEHPLATE From COMATTENTION Where COMPANYID='121') And OPTIME>=To_Date('2013-09-16 14:15:07', 'yyyy-mm-dd hh24:mi:ss') Order By OPTIME Desc) Where rownum<=10)) T, AREA A, ROADBASE B, DEVICE C, LANECODE D, (select * from ROADDIRECTION ss where ss.directiontype=2 ) E Where T.DEVICEID = C.DEVICEID And A.AREANO = B.AREANO And B.ROADNO = C.ROADNO And T.LANENO = D.LANENO(+) And C.DIRECTIONNO = E.DIRECTIONCODE(+) And C.ROADNO = E.ROADNO(+) Order By T.OPTIME Desc
gkv61pqza3c68** SQL Text Not Available **

Back to Top SQL
Back to Top

Top PL/SQL Procedures

No data exists for this section of the report.


Back to Top

Top Java Workload

No data exists for this section of the report.


Back to Top

Top Call Types

Call TypeCount% ActivityAvg Active Sessions
OAUTH6,28845.7017.47
V8 Bundled Exec4,86535.3613.51
LOGOFF7535.472.09
FETCH5143.741.43


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
58, 78692.58row cache lock1.35 JKDB_SGNetVideo.exe186/360 [ 52%]0
208, 67052.58row cache lock1.35 JKDB_SGNetVideo.exe186/360 [ 52%]0
256,115642.58row cache lock1.35 JKDB_SGNetVideo.exe186/360 [ 52%]0
260, 21032.58row cache lock1.35 JKDB_SGNetVideo.exe186/360 [ 52%]0
335, 27332.58row cache lock1.35 JKDB_SGNetVideo.exe186/360 [ 52%]0

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid (Inst)% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
256,11564( 1)12.08row cache lock11.50 JKDB_SGNetVideo.exe355/360 [ 99%]0
103, 8418( 1)10.79row cache lock10.79 JKDB_SGORACLE.EXE186/360 [ 52%]0
630, 3781( 1)8.17row cache lock7.65 JKDB_SGNetVideo.exe355/360 [ 99%]0
481,17006( 1)8.16row cache lock7.67 JKDB_SGw3wp.exe355/360 [ 99%]0
359, 31( 1)6.88row cache lock6.31 JKDB_SGw3wp.exe355/360 [ 99%]0

Back to Top Sessions
Back to Top

Top Sessions running PQs

No data exists for this section of the report.

Back to Top Sessions
Back to Top

Top Objects/Files/Latches

Back to Top

Top DB Objects

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Top Latches

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Activity Over Time

Slot Time (Duration)Slot CountEventEvent Count% Event
09:40:43 (17 secs)869row cache lock8426.12
  db file sequential read80.06
  log file sync70.05
09:41:00 (1.0 min)3,351row cache lock3,20823.31
  db file sequential read440.32
  db file parallel write290.21
09:42:00 (1.0 min)3,445row cache lock3,32524.16
  db file sequential read430.31
  CPU + Wait for CPU260.19
09:43:00 (1.0 min)3,003row cache lock2,72619.81
  CPU + Wait for CPU1080.78
  db file sequential read560.41
09:44:00 (1.0 min)1,005CPU + Wait for CPU5884.27
  cursor: mutex S2001.45
  library cache lock880.64
09:45:00 (1.0 min)1,098CPU + Wait for CPU6254.54
  cursor: mutex S2691.95
  library cache lock1060.77
09:46:00 (43 secs)989CPU + Wait for CPU4653.38
  cursor: mutex S3002.18
  library cache lock1290.94


Back to Top

End of Report