ASH Report For E2SNDB/E2SNDB

DB NameDB IdInstanceInst numReleaseRACHost
E2SNDB3356242802E2SNDB111.2.0.2.0NOe2sn.localdomain

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
8499M (100%)260M (52.1%)216M (43.3%)10.0M (2.0%)

Sample TimeData Source
Analysis Begin Time:22-May-12 00:00:00V$ACTIVE_SESSION_HISTORY
Analysis End Time:23-May-12 00:00:00V$ACTIVE_SESSION_HISTORY
Elapsed Time: 1,440.0 (mins)  
Sample Count: 19,678 
Average Active Sessions: 0.23 
Avg. Active Session per CPU: 0.03 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% EventAvg Active Sessions
CPU + Wait for CPUCPU60.900.14
db file sequential readUser I/O9.590.02

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
CPU + Wait for CPUCPU27.630.06

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
db file sequential read9.64"9","450786","1"0.02 file#block#blocks

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
E2SNDBNew Order41.38UNNAMED24.54
   getProductQuantity6.97
   getProductDetailsByCategory5.85
SYS$BACKGROUNDUNNAMED28.47UNNAMED28.47
E2SNDBBrowse Products18.18getProductDetails7.27
   UNNAMED6.11
   logon3.58
 UNNAMED3.66UNNAMED3.66
 New Customer1.95logon1.23

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
PL/SQL EXECUTE1640.690.09
SELECT17517.270.04
INSERT177.860.02
UPDATE133.360.01

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
SQL Execution69.710.16
PLSQL Execution37.050.08

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
0w2qpuc6u2zsp 440422.74 CPU + Wait for CPU22.71** Row Source Not Available **22.71 BEGIN :1 := orderentry.neworde...
147a57cxq3w5y 314816.05 CPU + Wait for CPU16.05** Row Source Not Available **16.05 BEGIN :1 := orderentry.browsep...
c749bc43qqfz313887349531854.18 CPU + Wait for CPU4.18SELECT STATEMENT4.16 SELECT SYSDATE FROM DUAL
8z3542ffmp56216555524671903.39 CPU + Wait for CPU3.18SELECT STATEMENT2.84 SELECT QUANTITY_ON_HAND FROM P...
bymb3ujkr3ubk4947354773803.39 CPU + Wait for CPU1.82INSERT STATEMENT1.65 INSERT INTO ORDERS(ORDER_ID, O...
     db file sequential read1.57LOAD TABLE CONVENTIONAL1.57

Back to Top SQL
Back to Top

Top SQL with Top Row Sources

SQL IDPlanHashSampled # of Executions% ActivityRow Source% RwSrcTop Event% EventSQL Text
0w2qpuc6u2zsp 440422.74 ** Row Source Not Available **22.74CPU + Wait for CPU22.71 BEGIN :1 := orderentry.neworde...
147a57cxq3w5y 314816.05 ** Row Source Not Available **16.05CPU + Wait for CPU16.05 BEGIN :1 := orderentry.browsep...
c749bc43qqfz313887349531854.18 SELECT STATEMENT4.16CPU + Wait for CPU4.16 SELECT SYSDATE FROM DUAL
8z3542ffmp56216555524671903.39 SELECT STATEMENT2.84CPU + Wait for CPU2.84 SELECT QUANTITY_ON_HAND FROM P...
bymb3ujkr3ubk4947354773803.39 LOAD TABLE CONVENTIONAL1.72db file sequential read1.57 INSERT INTO ORDERS(ORDER_ID, O...
     INSERT STATEMENT1.65CPU + Wait for CPU1.65

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
0w2qpuc6u2zspBEGIN :1 := orderentry.neworder(:2 , :3 , :4 ); END;
147a57cxq3w5yBEGIN :1 := orderentry.browseproducts(:2 , :3 , :4 ); END;
8z3542ffmp562SELECT QUANTITY_ON_HAND FROM PRODUCT_INFORMATION P, INVENTORIES I WHERE I.PRODUCT_ID = :B2 AND I.PRODUCT_ID = P.PRODUCT_ID AND I.WAREHOUSE_ID = :B1
bymb3ujkr3ubkINSERT INTO ORDERS(ORDER_ID, ORDER_DATE, CUSTOMER_ID, WAREHOUSE_ID) VALUES (ORDERS_SEQ.NEXTVAL + :B3 , SYSTIMESTAMP , :B2 , :B1 ) RETURNING ORDER_ID INTO :O0
c749bc43qqfz3SELECT SYSDATE FROM DUAL

Back to Top SQL
Back to Top

Top PL/SQL Procedures

PLSQL Entry Subprogram% ActivityPLSQL Current Subprogram% Current
SOE.ORDERENTRY.NEWORDER41.39 SQL20.63
   SOE.ORDERENTRY.NEWORDER11.98
   SYS.DBMS_APPLICATION_INFO.SET_ACTION4.63
SOE.ORDERENTRY.BROWSEPRODUCTS20.56 SOE.ORDERENTRY.BROWSEPRODUCTS9.22
   SQL6.13
   SYS.DBMS_APPLICATION_INFO.SET_ACTION3.30
SOE.ORDERENTRY.NEWCUSTOMER1.95 SQL1.42
SOE.ORDERENTRY.BROWSEANDUPDATEORDERS1.68 SQL1.04


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 Exec13,64369.330.16


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
97, 121.69CPU + Wait for CPU21.69 SYSoracle@e2sn.localdomain (PSP0)4,269/86K [ 5%]0
67, 177.11CPU + Wait for CPU6.14 SOEJDBC Thin Client1,208/86K [ 1%]324
136,100096.88CPU + Wait for CPU5.84 SOEJDBC Thin Client1,149/86K [ 1%]326
  db file sequential read1.03   203/86K [ 0%]133
8,596056.80CPU + Wait for CPU5.81 SOEJDBC Thin Client1,143/86K [ 1%]334
161,515476.80CPU + Wait for CPU5.86 SOEJDBC Thin Client1,153/86K [ 1%]313

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
922192.02db file sequential read2.02 SOE.ITEM_PRODUCT_IX (INDEX)PPX
922111.30db file sequential read1.30 SOE.ORDER_PK (INDEX)PPX
922101.22db file sequential read1.21 SOE.ORDER_ITEMS_PK (INDEX)PPX

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
99.48db file sequential read9.42 /u01/oradata/E2SNDB/ppx01.dbfPPX

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
00:00:00 (144.0 min)728CPU + Wait for CPU7153.63
  control file sequential read80.04
  control file parallel write40.02
02:24:00 (144.0 min)660CPU + Wait for CPU6453.28
  control file parallel write120.06
  control file sequential read30.02
04:48:00 (144.0 min)842CPU + Wait for CPU6633.37
  db file sequential read1540.78
  db file parallel write90.05
07:12:00 (144.0 min)3,697CPU + Wait for CPU3,30516.80
  db file sequential read3121.59
  db file parallel write450.23
09:36:00 (144.0 min)3,356CPU + Wait for CPU3,03915.44
  db file sequential read2741.39
  db file parallel write220.11
12:00:00 (144.0 min)3,245CPU + Wait for CPU2,95915.04
  db file sequential read2491.27
  db file parallel write170.09
14:24:00 (144.0 min)3,344CPU + Wait for CPU3,08515.68
  db file sequential read2281.16
  db file parallel write200.10
16:48:00 (144.0 min)2,998CPU + Wait for CPU2,38212.10
  db file sequential read5172.63
  db file parallel write350.18
19:12:00 (144.0 min)814CPU + Wait for CPU6313.21
  db file sequential read1650.84
  db file parallel write80.04


Back to Top

End of Report 448 rows selected.