ASH Report For EPMPLN/epmpln1

DB NameDB IdInstanceInst numReleaseRACHost
EPMPLN1293223757epmpln1110.2.0.5.0YESemlnpdb1

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
64163,840M (100%)150,912M (92.1%)11,311M (6.9%)M (%)

Sample TimeData Source
Analysis Begin Time:21-Mar-14 08:00:00DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 6520
Analysis End Time:21-Mar-14 09:00:00DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 6521
Elapsed Time: 60.0 (mins)  
Sample Count: 63,462 
Average Active Sessions: 176.28 
Avg. Active Session per CPU: 2.75 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% ActivityAvg Active Sessions
cursor: pin S wait on X Concurrency 27.39 48.29
latch: cache buffers chains Concurrency 19.12 33.71
read by other session User I/O 13.90 24.50
CPU + Wait for CPU CPU 7.36 12.97
enq: SQ - contention Configuration 6.18 10.89

Back to Top Events
Back to Top

Top Background Events

No data exists for this section of the report.

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
cursor: pin S wait on X 27.39 "2747636884","11347303596032","21494990547" 0.01 idn value where|sleeps
latch: cache buffers chains 19.12 "13835058229466993680","124","0" 0.27 address number tries
read by other session 13.90 "285","2451901","1" 0.28 file# block# class#
enq: SQ - contention 6.18 "1397817350","47302","0" 5.60 name|mode object # 0
gc buffer busy 4.82 "279","2802979","65537" 0.21 file# block# id#

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
SYS$USERS JDBC Thin Client 88.07 UNNAMED 88.07
epmpln JDBC Thin Client 5.01 UNNAMED 5.01
  oracle@ydsf (TNS V1-V3) 2.45 UNNAMED 2.45
  coll_main.exe 1.04 UNNAMED 1.04

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
SELECT 859 75.81 133.64
UPDATE 60 3.20 5.64
INSERT 100 1.20 2.11

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL Statements

SQL IDPlanhash% ActivityEvent% EventSQL Text
bn7dr3cnvpqgt 37927490 46.57 latch: cache buffers chains 19.12 select count(1) from sa_msg_re...
      read by other session 13.86
      wait list latch free 4.81
8pg54v2j5v6x0 1801466115 5.64 enq: SQ - contention 5.60 select SEQ_A_VOUCHER_ACCT_NO.N...
c56sbwns406ym 2175995838 1.93 cursor: pin S wait on X 1.88 select sa_query_template_sql.S...
gf0stawtdxnf6   1.73 cursor: pin S wait on X 1.73 select c_cons.CONS_ID as "cons...
  2703347460 1.47 cursor: pin S wait on X 1.42 select c_cons.CONS_ID as "cons...

Back to Top SQL
Back to Top

Top SQL using literals

Plan Hash% Activity# of Sampled SQL VersionsExample SQL 1Example SQL TEXT 1Example SQL 2Example SQL TEXT 2
1675566390 1.40 890 4nxpj1gp0qjc6 SELECT * FROM (SELECT LI.*, CA... bks1zny5ra55a SELECT * FROM (SELECT LI.*, CA...

Back to Top SQL
Back to Top

Complete List of SQL Text

SQL IdSQL Text
4nxpj1gp0qjc6 SELECT * FROM (SELECT LI.*, CASE WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1 WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN CASE WHEN E.SUSPEND_FLAG = 0 THEN CASE WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1 ELSE 0 END WHEN E.SUSPEND_FLAG = 1 THEN CASE WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1 ELSE 0 END ELSE 0 END ELSE 0 END OVERDUED, CASE WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE WHEN LI.TARGET_TIME_NE IS NULL THEN E.TARGET_OVERDUE_MINTIME WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME ELSE LI.TARGET_TIME_NE END TARGET_TIME, FTM.WORKFORM_TYPE_KIND FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/ WF.PROC_INSTANCE_ID, WF.ACTIVITY_INS_ID, WF.WORKITEM_INS_ID, WF.NAME, WF.CURRENT_ STATE, WF.COMPLETE_TIME, WF.CREATE_TIME, WF.LIMIT_TIME, WF.APP_URL, WF.USER_NAME, WF.USER_ID, WF.USER_ENTITY_TYPE, WF.USER_ENTITY_NAME, WF.USER_ENTITY_ID, WF.PARTICIPANT_TYPE, WF.SEND_TYPE, WF.OVERDUED AS OVERDUED_NE, WF.EXT_PROP, WF.FLOW_DIRECTION, WF.BUSINESSKEY, WF.DEPART_ID, F.INSTANCE_ID AS WI_INSTANCE_ID, F.INSTANCE_NAME AS WI_INSTANCE_NAME, F.WORKFORM_TYPE AS WI_WORKFORM_TYPE, F.BUILDER AS WI_BUILDER, F.START_TIME AS WI_CREATE_TIME, F.INSTANCE_STATUS AS WI_INSTANCE_STATUS, F.BUSINESS AS WI_BUSINESS, F.KEYDATA_ID AS WI_KEYDATA_ID, F.IS_FLOW AS WI_IS_FLOW, F.ATTR1 AS WI_ATTR1, F.DEPT_ID AS WI_DEPT_ID, '' AS WT_DEPT_ID, WF.CURRENT_STATE AS WT_WORKTASK_STATUS, NULL AS WT_TARGET_TIME, '' AS WT_LINK_URL, '' AS WT_LINK_PARAM, '' AS WT_IS_BATCH, U.REAL_NAME AS WI_BUILDER_REALNAME, NULL AS HOWLONG_WILL_OVERDUE, NULL AS HOWLONG_OVERDUED, '' AS ACTIVITY_TMP_ID, O.TIME_OUT_TIME AS TARGET_TIME_NE, B.APPROVAL_STATUS AS BE_APPROVAL_STATUS, ORG.ORG_NO, ORG.ORG_NAME, '' AS VIEW_FLAGS FROM SA_WORKFORM_INST F, (SELECT W.* FROM RT_WORKITEMINST W WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = :1 AND W.PARTICIPANT_TYPE = 0 UNION ALL SELECT W.* FROM RT_WORKITEMINST W, SA_BROLE_USER R WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = R.ROLE_ID AND R.USER_ID = :2 AND W.PARTICIPANT_TYPE = 1) WF, SA_USER U, (SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O, SA_WF_BUSINESS_EXT B, SA_DEPT D, SA_ORG ORG WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+) AND F.BUILDER = U.USER_ID(+) AND U.DEPT_ID = D.DEPT_ID(+) AND D. ORG_NO = ORG.ORG_NO(+) AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+) AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:3 LIKE (WF.DEPART_ID || '%')) OR (:4 = WF.DEPART_ID) OR (:5 = WF.DEPART_ID) OR (:6 = WF.DEPART_ID) OR (:7 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :8))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:9 LIKE (F.DEPT_ID || '%')) OR (:10 = F.DEPT_ID) OR (:11 = F.DEPT_ID) OR (:12 = F.DEPT_ID) OR (:13 = F.DEPT_ID) OR (F.DEPT_ID LIKE :14)))))) UNION ALL SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/ WF.PROC_INSTANCE_ID, WF.ACTIVITY_INS_ID, WF.WORKITEM_INS_ID, WF.NAME, WF.CURRENT_STATE, WF.COMPLETE_TIME, WF.CREATE_TIME, WF.LIMIT_TIME, WF.APP_URL, WF.USER_NAME, WF.USER_ID, WF.USER_ENTITY_TYPE, WF.USER_ENTITY_NAME, WF.USER_ENTITY_ID, WF.PARTICIPANT_TYPE, WF.SEND_TYPE, WF.OVERDUED AS OVERDUED_NE, WF.EXT_PROP, WF.FLOW_DIRECTION, WF.BUSINESSKEY, WF.DEPART_ID, F.INSTANCE_ID AS WI_INSTANCE_ID, F.INSTANCE_NAME AS WI_INSTANCE_NAME, F.WOR KFORM_TYPE AS WI_WORKFORM_TYPE, F.BUILDER AS WI_BUILDER, F.START_TIME AS WI_CREATE_TIME, F.INSTANCE_STATUS AS WI_INSTANCE_STATUS, F.BUSINESS AS WI_BUSINESS, F.KEYDATA_ID AS WI_KEYDATA_ID, F.IS_FLOW AS WI_IS_FLOW, F.ATTR1 AS WI_ATTR1, F.DEPT_ID AS WI_DEPT_ID, '' AS WT_DEPT_ID, WF.CURRENT_STATE AS WT_WORKTASK_STATUS, NULL AS WT_TARGET_TIME, '' AS WT_LINK_URL, '' AS WT_LINK_PARAM, '' AS WT_IS_BATCH, U.REAL_NAME AS WI_BUILDER_REALNAME, NULL AS HOWLONG_WILL_OVERDUE, NULL AS HOWLONG_OVERDUED, '' AS ACTIVITY_TMP_ID, O.TIME_OUT_TIME AS TARGET_TIME_NE, B.APPROVAL_STATUS AS BE_APPROVAL_STATUS, ORG.ORG_NO, ORG.ORG_NAME, '' AS VIEW_FLAGS FROM SA_WORKFORM_INST F, (SELECT W.* FROM RT_WORKITEMINST W WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = :15 AND W.PARTICIPANT_TYPE = 0 UNION ALL SELECT W.* FROM RT_WORKITEMINST W, SA_BROLE_USER R WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = R.ROLE_ID AND R.USER_ID = :16 AND W.PARTICIPANT_TYPE = 1) WF, SA_USER U, RT_PROCESSINSTANCE P, (SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O, SA_WF_BUSINESS_EXT B, SA_DEPT D, SA_ORG ORG WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID AND P.PARENT_PROCINC_ID IS NOT NULL AND F.PROCINST_ID = P.PARENT_PROCINC_ID AND F.BUILDER = U.USER_ID(+) AND U.DEPT_ID = D.DEPT_ID(+) AND D.ORG_NO = ORG.ORG_NO(+) AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+) AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+) AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:17 LIKE (WF.DEPART_ID || '%')) OR (:18 = WF.DEPART_ID) OR (:19 = WF.DEPART_ID) OR (:20 = WF.DEPART_ID) OR (:21 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :22))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:23 LIKE (F.DEPT_ID || '%')) OR (:24 = F.DEPT_ID) OR (:25 = F.DEPT_ID) OR (:26 = F.DEPT_ID) OR (:27 = F.DEPT_ID) OR (F.D EPT_ID LIKE :28)))))) AND NOT EXISTS (SELECT 1 FROM SA_WORKFORM_INST RF WHERE WF.PROC_INSTANCE_ID = RF.PROCINST_ID)) LI, SA_WF_WORKFORM_TYPE_MAP FTM, (SELECT ACT_INST_ID, SUSPEND_FLAG, MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME, MIN(SUSPEND_TIME) AS SUSPEND_TIME FROM (SELECT A.ACT_INST_ID, B.* FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID AND A.PROC_INST_ID = B.PROC_INST_ID AND B.COMPLETE_FLAG = 0) GROUP BY ACT_INST_ID, SUSPEND_FLAG) E WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+) AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T WHERE NOT EXISTS (SELECT 1 FROM SA_WF_WORKITEM_EXCLUDED_USER US WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID AND US.USER_ID = :29)
8pg54v2j5v6x0select SEQ_A_VOUCHER_ACCT_NO.NEXTVAL from dual
bks1zny5ra55a SELECT * FROM (SELECT LI.*, CASE WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1 WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN CASE WHEN E.SUSPEND_FLAG = 0 THEN CASE WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1 ELSE 0 END WHEN E.SUSPEND_FLAG = 1 THEN CASE WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1 ELSE 0 END ELSE 0 END ELSE 0 END OVERDUED, CASE WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE WHEN LI.TARGET_TIME_NE IS NULL THEN E.TARGET_OVERDUE_MINTIME WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME ELSE LI.TARGET_TIME_NE END TARGET_TIME, FTM.WORKFORM_TYPE_KIND FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/ WF.PROC_INSTANCE_ID, WF.ACTIVITY_INS_ID, WF.WORKITEM_INS_ID, WF.NAME, WF.CURRENT_ STATE, WF.COMPLETE_TIME, WF.CREATE_TIME, WF.LIMIT_TIME, WF.APP_URL, WF.USER_NAME, WF.USER_ID, WF.USER_ENTITY_TYPE, WF.USER_ENTITY_NAME, WF.USER_ENTITY_ID, WF.PARTICIPANT_TYPE, WF.SEND_TYPE, WF.OVERDUED AS OVERDUED_NE, WF.EXT_PROP, WF.FLOW_DIRECTION, WF.BUSINESSKEY, WF.DEPART_ID, F.INSTANCE_ID AS WI_INSTANCE_ID, F.INSTANCE_NAME AS WI_INSTANCE_NAME, F.WORKFORM_TYPE AS WI_WORKFORM_TYPE, F.BUILDER AS WI_BUILDER, F.START_TIME AS WI_CREATE_TIME, F.INSTANCE_STATUS AS WI_INSTANCE_STATUS, F.BUSINESS AS WI_BUSINESS, F.KEYDATA_ID AS WI_KEYDATA_ID, F.IS_FLOW AS WI_IS_FLOW, F.ATTR1 AS WI_ATTR1, F.DEPT_ID AS WI_DEPT_ID, '' AS WT_DEPT_ID, WF.CURRENT_STATE AS WT_WORKTASK_STATUS, NULL AS WT_TARGET_TIME, '' AS WT_LINK_URL, '' AS WT_LINK_PARAM, '' AS WT_IS_BATCH, U.REAL_NAME AS WI_BUILDER_REALNAME, NULL AS HOWLONG_WILL_OVERDUE, NULL AS HOWLONG_OVERDUED, '' AS ACTIVITY_TMP_ID, O.TIME_OUT_TIME AS TARGET_TIME_NE, B.APPROVAL_STATUS AS BE_APPROVAL_STATUS, ORG.ORG_NO, ORG.ORG_NAME, '' AS VIEW_FLAGS FROM SA_WORKFORM_INST F, (SELECT W.* FROM RT_WORKITEMINST W WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = :1 AND W.PARTICIPANT_TYPE = 0 UNION ALL SELECT W.* FROM RT_WORKITEMINST W, SA_BROLE_USER R WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = R.ROLE_ID AND R.USER_ID = :2 AND W.PARTICIPANT_TYPE = 1) WF, SA_USER U, (SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O, SA_WF_BUSINESS_EXT B, SA_DEPT D, SA_ORG ORG WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+) AND F.BUILDER = U.USER_ID(+) AND U.DEPT_ID = D.DEPT_ID(+) AND D. ORG_NO = ORG.ORG_NO(+) AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+) AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:3 LIKE (WF.DEPART_ID || '%')) OR (:4 = WF.DEPART_ID) OR (:5 = WF.DEPART_ID) OR (:6 = WF.DEPART_ID) OR (:7 = WF.DEPART_ID) OR (:8 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :9))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:10 LIKE (F.DEPT_ID || '%')) OR (:11 = F.DEPT_ID) OR (:12 = F.DEPT_ID) OR (:13 = F.DEPT_ID) OR (:14 = F.DEPT_ID) OR (:15 = F.DEPT_ID) OR (F.DEPT_ID LIKE :16) ))))) UNION ALL SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/ WF.PROC_INSTANCE_ID, WF.ACTIVITY_INS_ID, WF.WORKITEM_INS_ID, WF.NAME, WF.CURRENT_STATE, WF.COMPLETE_TIME, WF.CREATE_TIME, WF.LIMIT_TIME, WF.APP_URL, WF.USER_NAME, WF.USER_ID, WF.USER_ENTITY_TYPE, WF.USER_ENTITY_NAME, WF.USER_ENTITY_ID, WF.PARTICIPANT_TYPE, WF.SEND_TYPE, WF.OVERDUED AS OVERDUED_NE, WF.EXT_PROP, WF.FLOW_DIRECTION, WF.BUSINESSKEY, WF.DEPART_ID, F.INSTANCE_ID AS WI_INSTANCE_ID, F.INSTANCE_NAME AS WI_INSTANCE_NAME, F.WORKFORM_TYPE AS WI_WORKFORM_TYPE, F.BUILDER AS WI_BUILDER, F.START_TIME AS WI_CREATE_TIME, F.INSTANCE_STATUS AS WI_INSTANCE_STATUS, F.BUSINESS AS WI_BUSINESS, F.KEYDATA_ID AS WI_KEYDATA_ID, F.IS_FLOW AS WI_IS_FLOW, F.ATTR1 AS WI_ATTR1, F.DEPT_ID AS WI_DEPT_ID, '' AS WT_DEPT_ID, WF.CURRENT_STATE AS WT_WORKTASK_STATUS, NULL AS WT_TARGET_TIME, '' AS WT_LINK_URL, '' AS WT_LINK_PARAM, '' AS WT_IS_BATCH, U.REAL_NAME AS WI_BUILDER_REALNAME, NULL AS HOWLONG_WILL_OVERDUE, NULL AS HOWLONG_OVERDUED, '' AS ACTIVITY_TMP_ID, O.TIME_OUT_TIME AS TARGET_TIME_NE, B.APPROVAL_STATUS AS BE_APPROVAL_STATUS, ORG.ORG_NO, ORG.ORG_NAME, '' AS VIEW_FLAGS FROM SA_WORKFORM_INST F, (SELECT W.* FROM RT_WORKITEMINST W WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = :17 AND W.PARTICIPANT_TYPE = 0 UNION ALL SELECT W.* FROM RT_WORKITEMINST W, SA_BROLE_USER R WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = R.ROLE_ID AND R.USER_ID = :18 AND W.PARTICIPANT_TYPE = 1) WF, SA_USER U, RT_PROCESSINSTANCE P, (SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O, SA_WF_BUSINESS_EXT B, SA_DEPT D, SA_ORG ORG WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID AND P.PARENT_PROCINC_ID IS NOT NULL AND F.PROCINST_ID = P.PARENT_PROCINC_ID AND F.BUILDER = U.USER_ID(+) AND U.DEPT_ID = D.DEPT_ID(+) AND D.ORG_NO = ORG.ORG_NO(+) AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+) AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+) AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:19 LIKE (WF.DEPART_ID || '%')) OR (:20 = WF.DEPART_ID) OR (:21 = WF.DEPART_ID) OR (:22 = WF.DEPART_ID) OR (:23 = WF.DEPART_ID) OR (:24 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :25))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:26 LIKE (F.DEPT_ID || '%')) OR (:27 = F.DEPT_ID) O R (:28 = F.DEPT_ID) OR (:29 = F.DEPT_ID) OR (:30 = F.DEPT_ID) OR (:31 = F.DEPT_ID) OR (F.DEPT_ID LIKE :32)))))) AND NOT EXISTS (SELECT 1 FROM SA_WORKFORM_INST RF WHERE WF.PROC_INSTANCE_ID = RF.PROCINST_ID)) LI, SA_WF_WORKFORM_TYPE_MAP FTM, (SELECT ACT_INST_ID, SUSPEND_FLAG, MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME, MIN(SUSPEND_TIME) AS SUSPEND_TIME FROM (SELECT A.ACT_INST_ID, B.* FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID AND A.PROC_INST_ID = B.PROC_INST_ID AND B.COMPLETE_FLAG = 0) GROUP BY ACT_INST_ID, SUSPEND_FLAG) E WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+) AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T WHERE NOT EXISTS (SELECT 1 FROM SA_WF_WORKITEM_EXCLUDED_USER US WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID AND US.USER_ID = :33)
bn7dr3cnvpqgtselect count(1) from sa_msg_receive, sa_msg, sa_msg_handle where ((sa_msg.MSG_ID = sa_msg_receive.MSG_ID) and (sa_msg.MSG_TYPE = sa_msg_handle.TYPE_ID)) and (sa_msg_receive.RECEIVER_ID = :1 )
c56sbwns406ymselect sa_query_template_sql.SQL_ID as "SQL_ID", sa_query_template_sql.TEMPLATE_ID as "TEMPLATE_ID", sa_query_source_sql.QUERY_ID as "QUERY_ID", sa_query_source_sql.SQL_NAME as "SQL_NAME", sa_query_source_sql.SQL_COMMAND as "SQL_COMMAND" from sa_query_template_sql, sa_query_source_sql where (sa_query_template_sql.SQL_ID=sa_query_source_sql.SQL_ID) and (sa_query_template_sql.TEMPLATE_ID=:1)
gf0stawtdxnf6 select c_cons.CONS_ID as "consId", c_cons.VAT_ID as "vatId", c_cons.CUST_ID as "custId", c_cons.CONS_NO as "consNo", c_cons.CONS_NAME as "consName", c_cons.CUST_QUERY_NO as "custQueryNo", c_cons.TMP_PAY_RELA_NO as "tmpPayRelaNo", c_cons.ORGN_CONS_NO as "orgnConsNo", c_cons.CONS_SORT_CODE as "consSortCode", c_cons.ELEC_ADDR as "elecAddr", c_cons.TRADE_CODE as "tradeCode", c_con s.ELEC_TYPE_CODE as "elecTypeCode", c_cons.CONTRACT_CAP as "contractCap", c_cons.RUN_CAP as "runCap", c_cons.SHIFT_NO as "shiftNo", c_cons.LODE_ATTR_CODE as "lodeAttrCode", c_cons.VOLT_CODE as "voltCode", c_cons.HEC_INDUSTRY_CODE as "hecIndustryCode", c_cons.HOLIDAY as "holiday", c_cons.BUILD_DATE as "buildDate", c_cons.PS_DATE as "psDate", c_cons.CANCEL_DATE as "cancelDate", c_cons.DUE_DATE as "dueDate", c_cons.NOTIFY_MODE as "notifyMode", c_cons.SETTLE_MODE as "settleMode", c_cons.STATUS_CODE as "statusCode", c_cons.ORG_NO as "orgNo", c_cons.RRIO_CODE as "rrioCode", c_cons.CHK_CYCLE as "chkCycle", c_cons.LAST_CHK_DATE as "lastChkDate", c_cons.CHECKER_NO as "checkerNo", c_cons.POWEROFF_CODE as "poweroffCode", c_cons.TRANSFER_CODE as "transferCode", c_cons.MR_SECT_NO as "mrSectNo", c_cons.NOTE_TYPE_CODE as "noteTypeCode", c_cons.TMP_FLAG as "tmpFlag", c_cons.TMP_DATE as "tmpDate", c_cons.MEAS_MODE as "measMode", c_cons.DB_TIMESTAMP as "dbTimestamp" from c_cons where CONS_ID = :1

Back to Top SQL
Back to Top

Top PL/SQL Procedures

No data exists for this section of the report.


Back to Top

Top Sessions

Back to Top

Top Sessions

No data exists for this section of the report.

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
1435,49827 5.60 enq: SQ - contention 5.60 EPSA_LN JDBC Thin Client 28/360 [ 8%] 0
2579,58148 1.56 library cache load lock 1.56 EPM_LN JDBC Thin Client 29/360 [ 8%] 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

Object ID% ActivityEvent% EventObject Name (Type)Tablespace
283722 17.84 read by other session 13.20 EPSA_LN.PK_SA_MSG_RECEIVE (INDEX) EPSA
    gc buffer busy 4.19    
43104 1.39 gc buffer busy 0.59 EPSA_LN.SA_MSG (TABLE) EPSA

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
285 2.70 read by other session 2.04 /dev/vgepm1/rlvepsa_data07 EPSA
280 2.53 read by other session 2.02 /dev/vgepm1/rlvepsa_data02 EPSA
287 2.17 read by other session 1.68 /dev/vgepm1/rlvepsa_data09 EPSA
282 2.11 read by other session 1.66 /dev/vgepm1/rlvepsa_data04 EPSA
288 2.03 read by other session 1.14 /dev/vgepm1/rlvepsa_data10 EPSA

Back to Top Objects/Files/Latches
Back to Top

Top Latches

Latch% LatchBlocking Sid% ActivityMax Sampled Wait secs# Waits Sampled# Sampled Wts < 10ms# Sampled Wts 10ms - 100ms# Sampled Wts 100ms - 1s# Sampled Wts > 1s
latch: cache buffers chains 19.12 Held Shared 16.44 0.05 10,424 4,871 5,553 0 0
latch: row cache objects 2.80 Held Shared 2.80 10.31 280 1 0 12 267

Back to Top Objects/Files/Latches
Back to Top

Activity Over Time

Slot Time (Duration)Slot CountEventEvent Count% Event
08:00:00 (5.0 min) 3,745 latch: cache buffers chains 1,670 2.63
    read by other session 953 1.50
    CPU + Wait for CPU 625 0.98
08:30:00 (5.0 min) 16,592 cursor: pin S wait on X 8,488 13.37
    enq: SQ - contention 1,960 3.09
    library cache load lock 1,098 1.73
08:35:00 (5.0 min) 20,171 cursor: pin S wait on X 8,896 14.02
    latch: cache buffers chains 2,512 3.96
    enq: SQ - contention 1,960 3.09
08:40:00 (5.0 min) 6,158 latch: cache buffers chains 2,208 3.48
    read by other session 1,450 2.28
    CPU + Wait for CPU 818 1.29
08:45:00 (5.0 min) 5,493 latch: cache buffers chains 1,636 2.58
    read by other session 1,191 1.88
    CPU + Wait for CPU 876 1.38
08:50:00 (5.0 min) 5,554 latch: cache buffers chains 1,579 2.49
    read by other session 1,266 1.99
    CPU + Wait for CPU 939 1.48
08:55:00 (5.0 min) 5,749 latch: cache buffers chains 1,442 2.27
    read by other session 1,314 2.07
    CPU + Wait for CPU 973 1.53


Back to Top

End of Report