ASH Report For DB11G/DB11G

DB NameDB IdInstanceInst numReleaseRACHost
DB11G279886783DB11G111.2.0.3.0NOol6-112.localdomain

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
2597M (100%)372M (62.3%)204M (34.2%)4.0M (0.7%)

Sample TimeData Source
Analysis Begin Time:07-Oct-13 20:57:46V$ACTIVE_SESSION_HISTORY
Analysis End Time:07-Oct-13 21:02:46V$ACTIVE_SESSION_HISTORY
Elapsed Time: 5.0 (mins)  
Sample Count: 1,433 
Average Active Sessions: 4.78 
Avg. Active Session per CPU: 2.39 
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 CPUCPU88.144.21
db file sequential readUser I/O2.650.13

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
CPU + Wait for CPUCPU2.790.13
log file parallel writeSystem I/O1.540.07

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 read2.65"6","8526","1"0.07 file#block#blocks
log file parallel write1.54"1","2","1"0.98 filesblocksrequests

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
DB11G.WORLDNew Order38.87getProductDetailsByCategory19.82
UNNAMED12.70
logon4.88
Browse Products21.98getProductDetails10.40
UNNAMED5.65
logon4.68
UNNAMED14.65UNNAMED14.65
Process Orders7.96UNNAMED7.96
SYS$BACKGROUNDUNNAMED5.51UNNAMED5.51

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
SELECT3436.151.73
PL/SQL EXECUTE1033.641.61
INSERT712.560.60
UPDATE12.860.14

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
SQL Execution85.284.07
PLSQL Execution21.911.05
Parse3.560.17
Cursor Close2.090.10
Hard Parse1.260.06

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
c13sma6rkr27c258345671024317.59 CPU + Wait for CPU17.38HASH JOIN - OUTER7.82 SELECT PRODUCTS.PRODUCT_ID, PR...
147a57cxq3w5y 19314.17 CPU + Wait for CPU13.54** Row Source Not Available **13.54 BEGIN :1 := orderentry.browsep...
0w2qpuc6u2zsp 16212.21 CPU + Wait for CPU11.86** Row Source Not Available **11.86 BEGIN :1 := orderentry.neworde...
0y1prvxqc2ra9302912750917.19 CPU + Wait for CPU7.19SELECT STATEMENT4.05 SELECT PRODUCTS.PRODUCT_ID, PR...
bymb3ujkr3ubk494735477686.77 CPU + Wait for CPU6.14LOAD TABLE CONVENTIONAL3.56 INSERT INTO ORDERS(ORDER_ID, O...

Back to Top SQL
Back to Top

Top SQL with Top Row Sources

SQL IDPlanHashSampled # of Executions% ActivityRow Source% RwSrcTop Event% EventSQL Text
c13sma6rkr27c258345671024317.59 HASH JOIN - OUTER7.89CPU + Wait for CPU7.82 SELECT PRODUCTS.PRODUCT_ID, PR...
SELECT STATEMENT3.63CPU + Wait for CPU3.63
TABLE ACCESS - BY INDEX ROWID1.67CPU + Wait for CPU1.67
147a57cxq3w5y 19314.17 ** Row Source Not Available **14.17CPU + Wait for CPU13.54 BEGIN :1 := orderentry.browsep...
0w2qpuc6u2zsp 16212.21 ** Row Source Not Available **12.21CPU + Wait for CPU11.86 BEGIN :1 := orderentry.neworde...
0y1prvxqc2ra9302912750917.19 SELECT STATEMENT4.05CPU + Wait for CPU4.05 SELECT PRODUCTS.PRODUCT_ID, PR...
bymb3ujkr3ubk494735477686.77 LOAD TABLE CONVENTIONAL4.12CPU + Wait for CPU3.56 INSERT INTO ORDERS(ORDER_ID, O...
INSERT STATEMENT2.16CPU + Wait for CPU2.09

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

ModuleAction% ActivityEvent% Event
  2.09CPU + Wait for CPU2.09

Back to Top SQL
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0w2qpuc6u2zspBEGIN :1 := orderentry.neworder(:2 , :3 , :4 ); END;
0y1prvxqc2ra9SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.PRODUCT_ID = :B2 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID AND ROWNUM < :B1
147a57cxq3w5yBEGIN :1 := orderentry.browseproducts(:2 , :3 , :4 ); END;
bymb3ujkr3ubkINSERT INTO ORDERS(ORDER_ID, ORDER_DATE, CUSTOMER_ID, WAREHOUSE_ID) VALUES (ORDERS_SEQ.NEXTVAL + :B3 , SYSTIMESTAMP , :B2 , :B1 ) RETURNING ORDER_ID INTO :O0
c13sma6rkr27cSELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.CATEGORY_ID = :B3 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID AND INVENTORIES.WAREHOUSE_ID = :B2 AND ROWNUM < :B1

Back to Top SQL
Back to Top

Top PL/SQL Procedures

PLSQL Entry Subprogram% ActivityPLSQL Current Subprogram% Current
SOE.ORDERENTRY.NEWORDER39.57 SQL32.17
SOE.ORDERENTRY.NEWORDER3.98
SYS.DBMS_APPLICATION_INFO.SET_ACTION1.67
SOE.ORDERENTRY.BROWSEPRODUCTS22.89 SQL14.10
SOE.ORDERENTRY.BROWSEPRODUCTS5.51
SYS.DBMS_APPLICATION_INFO.SET_ACTION1.40
SOE.ORDERENTRY.PROCESSORDERS#28.23 SQL6.91
SOE.ORDERENTRY.NEWCUSTOMER4.05 SQL3.56
SOE.ORDERENTRY.BROWSEANDUPDATEORDERS2.65 SQL2.02


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 Exec1,28089.324.27
Cursor close all493.420.16


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
34, 714.33CPU + Wait for CPU4.19 SOEJDBC Thin Client60/300 [ 20%]4
39, 34.12CPU + Wait for CPU3.70 SOEJDBC Thin Client53/300 [ 18%]9
40, 34.05CPU + Wait for CPU3.63 SOEJDBC Thin Client52/300 [ 17%]3
160, 14.05CPU + Wait for CPU3.91 SOEJDBC Thin Client56/300 [ 19%]7
27, 673.84CPU + Wait for CPU3.77 SOEJDBC Thin Client54/300 [ 18%]8

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

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
62.65db file sequential read2.65 /u01/app/oracle/product/11.2.0/db_1/dbs/soe.dbfSOE

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
20:57:46 (14 secs)80CPU + Wait for CPU775.37
log file parallel write10.07
null event10.07
20:58:00 (1.0 min)228CPU + Wait for CPU20214.10
db file sequential read90.63
latch free30.21
20:59:00 (1.0 min)278CPU + Wait for CPU25117.52
db file sequential read80.56
log file parallel write60.42
21:00:00 (1.0 min)349CPU + Wait for CPU31521.98
db file sequential read120.84
log file parallel write70.49
21:01:00 (1.0 min)282CPU + Wait for CPU25717.93
db file sequential read60.42
log file parallel write40.28
21:02:00 (46 secs)216CPU + Wait for CPU20114.03
db file async I/O submit30.21
db file sequential read30.21


Back to Top

End of Report