ASH Report For LPISSUES/LPISSUES

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

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
8510M (100%)332M (65.1%)160M (31.4%)10.2M (2.0%)

Sample TimeData Source
Analysis Begin Time:10-Jan-14 13:55:00V$ACTIVE_SESSION_HISTORY
Analysis End Time:10-Jan-14 13:58:00V$ACTIVE_SESSION_HISTORY
Elapsed Time: 3.0 (mins)  
Sample Count: 6,447 
Average Active Sessions: 35.82 
Avg. Active Session per CPU: 4.48 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% EventAvg Active Sessions
log file syncCommit71.1825.49
log file switch (checkpoint incomplete)Configuration9.113.26
buffer busy waitsConcurrency4.541.63
enq: TX - index contentionConcurrency4.391.57
CPU + Wait for CPUCPU3.551.27

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
log file parallel writeSystem I/O2.330.83
db file async I/O submitSystem I/O1.780.64

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
log file sync71.18"4","21947322","0"0.02 buffer#sync scnNOT DEFINED
buffer busy waits4.54"5","295628","1"0.40 file#block#class#
enq: TX - index contention4.39"1415053316","2949123","101"1.61 name|modeusn<<16 | slotsequence
"1415053316","2293787","88"1.18
log file parallel write2.33"1","3","1"0.08 filesblocksrequests
enq: TX - contention2.19"1415053316","1835032","110"2.19 name|modeusn<<16 | slotsequence

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
SYS$USERSJDBC Thin Client95.72UNNAMED95.72
SYS$BACKGROUNDUNNAMED4.25UNNAMED4.25

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
INSERT1416.675.97
SELECT254.841.73
UPDATE71.470.53

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
SQL Execution23.288.34

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
1nfyr2c6vcpsn 1366.06 enq: TX - index contention2.76** Row Source Not Available **2.76 insert into DLFileVersion (uui...
 1366.06 enq: TX - contention2.19** Row Source Not Available **2.19 insert into DLFileVersion (uui...
15y13zdcppwjr 882.71 buffer busy waits1.47** Row Source Not Available **1.47 insert into Lock_ (uuid_, comp...
 882.71 log file switch (checkpoint incomplete)1.23** Row Source Not Available **1.23 insert into Lock_ (uuid_, comp...
2nbvnxx6s3j53 592.42 log file switch (checkpoint incomplete)1.43** Row Source Not Available **1.43 insert into AssetEntry (groupI...
5t4aphakakw1c 471.88 log file switch (checkpoint incomplete)0.98** Row Source Not Available **0.98 insert into SocialActivity (gr...
ghkgkt4tfdn8g1412913815771.86 log file switch (checkpoint incomplete)1.02TABLE ACCESS - BY INDEX ROWID0.82 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
1nfyr2c6vcpsn 1366.06 ** Row Source Not Available **6.06enq: TX - index contention2.76 insert into DLFileVersion (uui...
15y13zdcppwjr 882.71 ** Row Source Not Available **2.71buffer busy waits1.47 insert into Lock_ (uuid_, comp...
2nbvnxx6s3j53 592.42 ** Row Source Not Available **2.42log file switch (checkpoint incomplete)1.43 insert into AssetEntry (groupI...
5t4aphakakw1c 471.88 ** Row Source Not Available **1.88log file switch (checkpoint incomplete)0.98 insert into SocialActivity (gr...
ghkgkt4tfdn8g1412913815771.86 TABLE ACCESS - BY INDEX ROWID1.38log file switch (checkpoint incomplete)0.82 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 )
1nfyr2c6vcpsninsert into DLFileVersion (uuid_, groupId, companyId, userId, userName, createDate, modifiedDate, repositoryId, folderId, fileEntryId, treePath, extension, mimeType, title, description, changeLog, extraSettings, fileEntryTypeId, version, size_, checksum, status, statusByUserId, statusByUserName, statusDate, fileVersionId) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 )
2nbvnxx6s3j53insert into AssetEntry (groupId, companyId, userId, userName, createDate, modifiedDate, classNameId, classPK, classUuid, classTypeId, visible, startDate, endDate, publishDate, expirationDate, mimeType, title, description, summary, url, layoutUuid, height, width, priority, viewCount, entryId) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 )
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 )
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
COMMIT4,58171.0625.45
V8 Bundled Exec1,57824.488.77


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
125, 12.36log file parallel write2.33 SYSoracle@typhoon...ay.int (LGWR)150/180 [ 83%]0
84, 11.80db file async I/O submit1.78 SYSoracle@typhoon...ay.int (DBW0)115/180 [ 64%]0
49, 31.36log file sync0.95 LPORTAL_TRUNKJDBC Thin Client61/180 [ 34%]0
169, 111.36log file sync1.01 LPORTAL_TRUNKJDBC Thin Client65/180 [ 36%]0
308, 11.33log file sync0.98 LPORTAL_TRUNKJDBC Thin Client63/180 [ 35%]0

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid (Inst)% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
125, 1( 1)80.29log file sync71.18 SYSoracle@typhoon...ay.int (LGWR)152/180 [ 84%]0
log file switch (checkpoint incomplete)9.11
295, 5( 1)2.19enq: TX - contention2.19 LPORTAL_TRUNKJDBC Thin Client59/180 [ 33%]7
170, 7( 1)1.61enq: TX - index contention1.61 LPORTAL_TRUNKJDBC Thin Client67/180 [ 37%]6
305, 5( 1)1.32enq: TX - index contention1.18 LPORTAL_TRUNKJDBC Thin Client80/180 [ 44%]6

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
3889581.66buffer busy waits1.66 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
13:55:00 (1.0 min)1,560log file sync1,29020.01
enq: TX - index contention881.36
CPU + Wait for CPU761.18
13:56:00 (1.0 min)2,504log file sync1,90829.60
enq: TX - index contention1922.98
log file switch (checkpoint incomplete)1592.47
13:57:00 (1.0 min)2,383log file sync1,39121.58
log file switch (checkpoint incomplete)4286.64
buffer busy waits2253.49


Back to Top

End of Report