ASH Report For LPISSUES/LPISSUES

DB NameDB IdInstanceInst numReleaseRACHost
LPISSUES940778140LPISSUES111.2.0.3.0NOtyphoon.liferay.int

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
8510M (100%)324M (63.6%)168M (33.0%)10.2M (2.0%)

Sample TimeData Source
Analysis Begin Time:10-Jan-14 14:12:00V$ACTIVE_SESSION_HISTORY
Analysis End Time:10-Jan-14 14:20:00V$ACTIVE_SESSION_HISTORY
Elapsed Time: 8.0 (mins)  
Sample Count: 22,648 
Average Active Sessions: 47.18 
Avg. Active Session per CPU: 5.90 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% EventAvg Active Sessions
enq: TX - row lock contentionApplication50.5523.85
log file syncCommit20.719.77
log file switch (checkpoint incomplete)Configuration14.616.89
enq: TX - index contentionConcurrency5.442.57
buffer busy waitsConcurrency3.671.73

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
db file async I/O submitSystem I/O1.740.82
log file parallel writeSystem I/O1.050.49

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
enq: TX - row lock contention50.55"1415053318","2424835","168"2.41 name|modeusn<<16 | slotsequence
"1415053318","851978","241"2.12
"1415053318","3997722","84"2.12
log file sync20.71"11","23175149","0"0.00 buffer#sync scnNOT DEFINED
enq: TX - index contention5.44"1415053316","589825","15331"4.75 name|modeusn<<16 | slotsequence
buffer busy waits3.67"5","295629","1"0.52 file#block#class#
db file async I/O submit1.74"1961","0","0"0.06 requestsinterrupttimeout

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
SYS$USERSJDBC Thin Client96.70UNNAMED96.70
SYS$BACKGROUNDUNNAMED2.96UNNAMED2.96

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
UPDATE752.0524.56
INSERT1518.438.69
SELECT265.042.38

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
SQL Execution75.5835.66

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
dvqzv80j8kgw13112235393651150.96 enq: TX - row lock contention50.55UPDATE50.55 update DLFolder set uuid_=:1 ,...
15y13zdcppwjr 1175.27 log file switch (checkpoint incomplete)3.05** Row Source Not Available **3.05 insert into Lock_ (uuid_, comp...
 1175.27 buffer busy waits2.19** Row Source Not Available **2.19 insert into Lock_ (uuid_, comp...
fbvszs8phhqkr 625.20 enq: TX - index contention4.83** Row Source Not Available **4.83 insert into SystemEvent (group...
5t4aphakakw1c 913.75 log file switch (checkpoint incomplete)3.48** Row Source Not Available **3.48 insert into SocialActivity (gr...
ghkgkt4tfdn8g14129138151972.29 log file switch (checkpoint incomplete)1.58TABLE ACCESS - BY INDEX ROWID1.10 select dlfileentr0_.fileEntryI...

Back to Top SQL
Back to Top

Top SQL with Top Row Sources

SQL IDPlanHashSampled # of Executions% ActivityRow Source% RwSrcTop Event% EventSQL Text
dvqzv80j8kgw13112235393651150.96 UPDATE50.94enq: TX - row lock contention50.55 update DLFolder set uuid_=:1 ,...
15y13zdcppwjr 1175.27 ** Row Source Not Available **5.27log file switch (checkpoint incomplete)3.05 insert into Lock_ (uuid_, comp...
fbvszs8phhqkr 625.20 ** Row Source Not Available **5.20enq: TX - index contention4.83 insert into SystemEvent (group...
5t4aphakakw1c 913.75 ** Row Source Not Available **3.75log file switch (checkpoint incomplete)3.48 insert into SocialActivity (gr...
ghkgkt4tfdn8g14129138151972.29 TABLE ACCESS - BY INDEX ROWID1.63log file switch (checkpoint incomplete)1.10 select dlfileentr0_.fileEntryI...

Back to Top SQL
Back to Top

Top SQL using literals

No data exists for this section of the report.

Back to Top SQL
Back to Top

Top Parsing Module/Action

No data exists for this section of the report.

Back to Top SQL
Back to Top

Complete List of SQL Text

SQL IdSQL Text
15y13zdcppwjrinsert into Lock_ (uuid_, companyId, userId, userName, createDate, className, key_, owner, inheritable, expirationDate, lockId) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 )
5t4aphakakw1cinsert into SocialActivity (groupId, companyId, userId, createDate, activitySetId, mirrorActivityId, classNameId, classPK, parentClassNameId, parentClassPK, type_, extraData, receiverUserId, activityId) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 )
dvqzv80j8kgw1update DLFolder set uuid_=:1 , groupId=:2 , companyId=:3 , userId=:4 , userName=:5 , createDate=:6 , modifiedDate=:7 , repositoryId=:8 , mountPoint=:9 , parentFolderId=:10 , treePath=:11 , name=:12 , description=:13 , lastPostDate=:14 , defaultFileEntryTypeId=:15 , hidden_=:16 , overrideFileEntryTypes=:17 , status=:18 , statusByUserId=:19 , statusByUserName=:20 , statusDate=:21 where folderId=:22
fbvszs8phhqkrinsert into SystemEvent (groupId, companyId, userId, userName, createDate, classNameId, classPK, classUuid, referrerClassNameId, parentSystemEventId, systemEventSetKey, type_, extraData, systemEventId) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 )
ghkgkt4tfdn8gselect dlfileentr0_.fileEntryId as fileEntr1_394_, dlfileentr0_.uuid_ as uuid2_394_, dlfileentr0_.groupId as groupId394_, dlfileentr0_.companyId as companyId394_, dlfileentr0_.userId as userId394_, dlfileentr0_.userName as userName394_, dlfileentr0_.createDate as createDate394_, dlfileentr0_.modifiedDate as modified8_394_, dlfileentr0_.classNameId as classNam9_394_, dlfileentr0_.classPK as classPK394_, dlfileentr0_.repositoryId as reposit11_394_, dlfileentr0_.folderId as folderId394_, dlfileentr0_.treePath as treePath394_, dlfileentr0_.name as name394_, dlfileentr0_.extension as extension394_, dlfileentr0_.mimeType as mimeType394_, dlfileentr0_.title as title394_, dlfileentr0_.description as descrip18_394_, dlfileentr0_.extraSettings as extraSe19_394_, dlfileentr0_.fileEntryTypeId as fileEnt20_394_, dlfileentr0_.version as version394_, dlfileentr0_.size_ as size22_394_, dlfileentr0_.readCount as readCount394_, dlfileentr0_.smallImageId as smallIm24_394_, dlfileentr0_.largeImageId as largeIm25_394_, dlfileentr0_.custom1ImageId as custom26_394_, dlfileentr0_.custom2ImageId as custom27_394_, dlfileentr0_.manualCheckInRequired as manualC28_394_ from DLFileEntry dlfileentr0_ where (dlfileentr0_.groupId=:1 )AND(dlfileentr0_.folderId=:2 )AND(dlfileentr0_.title=:3 )

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
V8 Bundled Exec17,21976.0335.87
COMMIT4,70720.789.81


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
84, 11.74db file async I/O submit1.74 SYSoracle@typhoon...ay.int (DBW0)395/480 [ 82%]0
253, 4771.47enq: TX - row lock contention0.69 LPORTAL_TRUNKJDBC Thin Client156/480 [ 33%]96
56, 2571.39enq: TX - row lock contention0.80 LPORTAL_TRUNKJDBC Thin Client181/480 [ 38%]93
177, 1251.33enq: TX - row lock contention0.68 LPORTAL_TRUNKJDBC Thin Client154/480 [ 32%]101
149, 17671.33enq: TX - row lock contention0.88 LPORTAL_TRUNKJDBC Thin Client199/480 [ 41%]96

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid (Inst)% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
125, 1( 1)35.71log file sync20.71 SYSoracle@typhoon...ay.int (LGWR)246/480 [ 51%]0
log file switch (checkpoint incomplete)14.98
15, 465( 1)5.06enq: TX - index contention4.75 LPORTAL_TRUNKJDBC Thin Client260/480 [ 54%]75
130, 637( 1)3.10enq: TX - row lock contention3.10 LPORTAL_TRUNKJDBC Thin Client252/480 [ 53%]61
260, 281( 1)2.83enq: TX - row lock contention2.83 LPORTAL_TRUNKJDBC Thin Client266/480 [ 55%]86
169, 19( 1)2.38enq: TX - row lock contention2.33 LPORTAL_TRUNKJDBC Thin Client187/480 [ 39%]78

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

Object ID% ActivityEvent% EventObject Name (Type)Tablespace
38888250.80enq: TX - row lock contention50.55 LPORTAL_TRUNK.DLFOLDER (TABLE)LPORTAL
3889581.98buffer busy waits1.98 LPORTAL_TRUNK.LOCK_ (TABLE)LPORTAL

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
14:12:00 (1.0 min)1,022enq: TX - row lock contention6993.09
log file sync2471.09
log file switch (checkpoint incomplete)250.11
14:13:00 (1.0 min)3,060enq: TX - row lock contention1,7957.93
log file sync7363.25
log file switch (checkpoint incomplete)2991.32
14:14:00 (1.0 min)3,159enq: TX - row lock contention1,5776.96
log file sync7303.22
log file switch (checkpoint incomplete)4381.93
14:15:00 (1.0 min)3,187enq: TX - row lock contention1,6637.34
log file switch (checkpoint incomplete)7203.18
log file sync5312.34
14:16:00 (1.0 min)3,198enq: TX - row lock contention1,8888.34
log file switch (checkpoint incomplete)5842.58
log file sync4582.02
14:17:00 (1.0 min)3,265enq: TX - index contention1,0764.75
enq: TX - row lock contention8843.90
log file sync6162.72
14:18:00 (1.0 min)2,982enq: TX - row lock contention1,4726.50
log file sync7913.49
log file switch (checkpoint incomplete)4862.15
14:19:00 (1.0 min)2,775enq: TX - row lock contention1,4706.49
log file sync5822.57
log file switch (checkpoint incomplete)4111.81


Back to Top

End of Report