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%)12,312M (7.5%)68.0M (0.0%)

Sample TimeData Source
Analysis Begin Time:25-Mar-14 04:00:00V$ACTIVE_SESSION_HISTORY
Analysis End Time:25-Mar-14 05:00:00V$ACTIVE_SESSION_HISTORY
Elapsed Time: 60.0 (mins)  
Sample Count: 96,060 
Average Active Sessions: 26.68 
Avg. Active Session per CPU: 0.42 
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 45.01 12.01
CPU + Wait for CPU CPU 21.65 5.78
gc buffer busy Cluster 9.06 2.42
SQL*Net break/reset to client Application 7.41 1.98
SQL*Net message from dblink Network 3.80 1.01

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 45.01 "2747636884","5046586572800","21474983657" 0.01 idn value where|sleeps
gc buffer busy 9.06 "281","1830973","65537" 0.01 file# block# id#
SQL*Net break/reset to client 7.41 "1413697536","0","0" 7.41 driver id break? NOT DEFINED
SQL*Net message from dblink 3.80 "0","1","0" 3.30 driver id #bytes NOT DEFINED
read by other session 2.82 "279","112126","1" 0.00 file# block# class#

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
SYS$USERS JDBC Thin Client 54.59 UNNAMED 54.59
epmpln oracle@lnodsqy1 (TNS V1-V3) 15.37 UNNAMED 15.37
  PL/SQL Developer 7.41 SQL ?? - ?? 7.41
  oracle@lnods2 (TNS V1-V3) 7.40 UNNAMED 7.40
SYS$USERS DBMS_SCHEDULER 5.84 JOB_PRO_TQ_YXCJS_MX 3.70
      GATHER_STATS_JOB 2.14

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 478 72.98 19.47
INSERT 141 9.60 2.56

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL Statements

SQL IDPlanhash% ActivityEvent% EventSQL Text
d9dkp2jmgfvr3 2348481130 33.72 cursor: pin S wait on X 33.41 select sa_resource.RES_ID as "...
3r0q2w331jup9 1726602672 7.41 CPU + Wait for CPU 5.26 SELECT /*+ USE_HASH ("A1") USE...
      db file sequential read 1.07
9tatc9qjgq2qu 2106893031 5.33 gc buffer busy 2.48 SELECT "A1"."INS_NAME", "A1"."...
      CPU + Wait for CPU 1.77
ca4ukj0ujvz3x 2106893031 5.33 gc buffer busy 2.48 SELECT "A1"."INS_NAME", "A1"."...
      CPU + Wait for CPU 1.72
d9dkp2jmgfvr3   4.76 cursor: pin S wait on X 4.75 select sa_resource.RES_ID as "...

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

Complete List of SQL Text

SQL IdSQL Text
3r0q2w331jup9SELECT /*+ USE_HASH ("A1") USE_HASH ("A2") */ "A1"."INS_NAME", "A1"."END_TIME", "A1"."APP_NO", "A1"."END_TIME", "A1"."END_TIME", "A1"."STATUS_CODE", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", " ;A2"."APP_MODE", "A2"."PS_ORG_NO", "A2"."PERMENANT_REDUCE_FLAG", "A2"."ELEC_TYPE_CODE", "A2"."APP_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1", "ARC_S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A2"."APP_NO"="A1"."APP_NO" AND "A1".&q uot;END_TIME"<:2 AND "A1"."END_TIME">=:3 AND "A1"."STATUS_CODE"='02'
9tatc9qjgq2qu SELECT "A1"."INS_NAME", "A1"."INS_NAME", "A1"."APP_NO", "A1"."END_TIME", "A1"."END_TIME", "A1"."STATUS_CODE", "A1"."INS_NAME", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", "A2"."PS_ORG_NO", "A2"."CONS_NO", "A2"."CONS_NO", "A2" ;."CONS_NAME", "A2"."PS_ORG_NO", "A2"."ELEC_ADDR", "A2"."VOLT_CODE", "A2"."TRADE_CODE", "A2"."HEC_INDUSTRY_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."APP_ID", "A2"."T_RUN_CAP", "A2"."ORGN_RUN_CAP", "A2"."T_CONTRACT_CAP", "A2"."ORGN_CONTRAC T_CAP", "A2"."CONS_ID", "A2"."CUST_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1", "ARC_S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A2"."APP_NO"="A1"."APP_NO" AND "A1"."END_TIME">=:2 AND "A1"."END_TIME"<:3 AND "A1"."INS_NAME"&l t;>'103' AND "A1"."INS_NAME"<>'112' AND "A1"."INS_NAME"<>'217' AND "A1"."STATUS_CODE"='02'
ca4ukj0ujvz3x SELECT "A1"."INS_NAME", "A1"."APP_NO", "A1"."INS_NAME", "A1"."END_TIME", "A1"."END_TIME", "A1"."STATUS_CODE", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", "A2"."PS_ORG_NO", "A2"."CONS_NO", "A2"."CONS_NO", "A2"."CONS_NAME", "A2&quo t;."PS_ORG_NO", "A2"."ELEC_ADDR", "A2"."VOLT_CODE", "A2"."TRADE_CODE", "A2"."HEC_INDUSTRY_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."CONS_ID", "A2"."CUST_ID", "A2"."APP_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1", "ARC_S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A1"."APP_NO"="A2"."APP_NO" AND "A1"."INS_NAME"<>'103' AND "A1"."INS_NAME"<>'112' AND "A1"."INS_NAME"<>'217' AND "A1"."END_TIME">=:2 AND "A1"."END_TIME"<:3 AND "A1"."STATUS_CODE"='02'
d9dkp2jmgfvr3select sa_resource.RES_ID as "RES_ID", sa_resource.MODULE_NAME as "MODULE_NAME", sa_resource.RES_NAME as "RES_NAME", sa_resource.RES_TYPE as "RES_TYPE", sa_resource.PERMISSION_ID as "PERMISSION_ID", sa_resource.ATTR1 as "ATTR1", sa_resource.ATTR2 as "ATTR2", sa_resource.ATTR3 as "ATTR3", sa_resource.ATTR4 as &quo t;ATTR4", sa_resource.FOLDER_ID as "FOLDER_ID", sa_resource.HEIGHT as "HEIGHT", sa_resource.PANEL_TITLE as "PANEL_TITLE", sa_resource.B_PANEL as "B_PANEL", sa_resource.VALID_FLAG as "VALID_FLAG", sa_resource.START_TIME as "START_TIME", sa_resource.END_TIME as "END_TIME" from sa_resource where sa_resource.RES_TYPE = 'component' and sa_resource.ATTR1 = :1 and sa_resource.ATTR2 = :2

Back to Top SQL
Back to Top

Top PL/SQL Procedures

PLSQL Entry Subprogram% ActivityPLSQL Current Subprogram% Current
SYS.DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC 4.40 SQL 3.69
LN_NEU_SGS.PRO_TQ_YXCJS_MX_AUTO 3.70 SQL 3.70
EPM_LN.PRC_O_CONSBASE 2.33 SQL 2.33


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
315,63441 3.70 CPU + Wait for CPU 2.64 EPMDSS oracle@lnodsqy1 (TNS V1-V3) 2,535/3,600 [ 70%] 0
872, 5046 3.70 CPU + Wait for CPU 2.62 EPMDSS oracle@lnods2 (TNS V1-V3) 2,514/3,600 [ 70%] 0
1891,54259 3.70 SQL*Net message from dblink 3.30 LN_NEU_SGS oracle@emlnpdb1 (J000) 3,173/3,600 [ 88%] 375
2621,54387 3.70 SQL*Net break/reset to client 3.70 LN_NEU_GD plsqldev.exe 3,558/3,600 [ 99%] 0
2936,39317 3.70 SQL*Net break/reset to client 3.70 LN_NEU_GD plsqldev.exe 3,558/3,600 [ 99%] 0

Back to Top Sessions
Back to Top

Top Blocking Sessions

No data exists for this section of the report.

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
43244 14.87 gc buffer busy 8.61 EPSA_LN.SA_WORKFORM_INST_HISTORY (TABLE) EPSA
    read by other session 2.65    
    db file scattered read 1.92    
42894 3.70 SQL*Net break/reset to client 3.70 EPM_LN.C_CONTACT (TABLE) EPMDAT1
548470 3.70 SQL*Net break/reset to client 3.70 EPM_LN.C_CUST_C_CONTACT_FK (INDEX) EPMDAT1

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
281 1.67 gc buffer busy 0.89 /dev/vgepm1/rlvepsa_data03 EPSA
286 1.57 gc buffer busy 0.91 /dev/vgepm1/rlvepsa_data08 EPSA
284 1.54 gc buffer busy 0.89 /dev/vgepm1/rlvepsa_data06 EPSA
280 1.52 gc buffer busy 0.87 /dev/vgepm1/rlvepsa_data02 EPSA
285 1.51 gc buffer busy 0.85 /dev/vgepm1/rlvepsa_data07 EPSA

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
04:00:00 (6.0 min) 6,068 CPU + Wait for CPU 2,446 2.55
    gc buffer busy 1,015 1.06
    SQL*Net break/reset to client 714 0.74
04:06:00 (6.0 min) 5,791 CPU + Wait for CPU 2,346 2.44
    gc buffer busy 951 0.99
    SQL*Net break/reset to client 708 0.74
04:12:00 (6.0 min) 5,479 CPU + Wait for CPU 2,283 2.38
    SQL*Net break/reset to client 712 0.74
    gc buffer busy 702 0.73
04:18:00 (6.0 min) 51,201 cursor: pin S wait on X 43,211 44.98
    row cache lock 2,474 2.58
    CPU + Wait for CPU 2,023 2.11
04:24:00 (6.0 min) 5,109 CPU + Wait for CPU 2,542 2.65
    gc buffer busy 846 0.88
    SQL*Net break/reset to client 710 0.74
04:30:00 (6.0 min) 5,093 CPU + Wait for CPU 2,360 2.46
    gc buffer busy 890 0.93
    SQL*Net break/reset to client 712 0.74
04:36:00 (6.0 min) 4,333 CPU + Wait for CPU 1,918 2.00
    gc buffer busy 866 0.90
    SQL*Net break/reset to client 712 0.74
04:42:00 (6.0 min) 4,627 CPU + Wait for CPU 2,015 2.10
    gc buffer busy 835 0.87
    SQL*Net break/reset to client 710 0.74
04:48:00 (6.0 min) 4,174 CPU + Wait for CPU 1,743 1.81
    gc buffer busy 813 0.85
    SQL*Net break/reset to client 712 0.74
04:54:00 (6.0 min) 4,185 CPU + Wait for CPU 1,518 1.58
    gc buffer busy 847 0.88
    SQL*Net break/reset to client 712 0.74


Back to Top

End of Report