ASH Report For DB11G/db11g

DB NameDB IdInstanceInst numReleaseRACHost
DB11G278174245db11g111.2.0.3.0NOIS-2YB6X4J

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
2749M (100%)240M (32.1%)359M (47.9%)M (%)

Sample TimeData Source
Analysis Begin Time:06-Jun-13 16:30:00DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 1378
Analysis End Time:06-Jun-13 17:00:00DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 1379
Elapsed Time: 30.0 (mins)  
Sample Count: 340 
Average Active Sessions: 1.89 
Avg. Active Session per CPU: 0.94 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% EventAvg Active Sessions
db file sequential readUser I/O81.181.53
db file parallel readUser I/O3.240.06
log file syncCommit2.650.05
CPU + Wait for CPUCPU2.060.04

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
control file sequential readSystem I/O4.120.08
log file parallel writeSystem I/O3.530.07
db file parallel writeSystem I/O2.060.04

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 read81.18"6","620","1"0.29 file#block#blocks
control file sequential read4.41"0","1","1"3.24 file#block#blocks
log file parallel write3.53"1","3","1"1.18 filesblocksrequests
db file parallel read3.24"1","3","3"0.88 filesblocksrequests
log file sync2.65"241","7018316","0"0.29 buffer#sync scnNOT DEFINED

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
DB11G.WORLDNew Order58.53UNNAMED26.76
getProductDetailsByCategory19.71
getCustomerDetails6.47
Browse Products14.12getCustomerDetails11.18
getProductDetails1.76
UNNAMED1.18
SYS$BACKGROUNDUNNAMED10.00UNNAMED10.00
DB11G.WORLDProcess Orders8.82UNNAMED8.82
Browse and Update Orders4.41getCustomerDetails2.65
getOrdersByCustomer1.18

Back to Load Profile
Back to Top

Top Client IDs

Client ID% ActivityAvg Active SessionsUserProgramService
Swingbench89.411.69 SOEJDBC Thin ClientDB11G.WORLD

Back to Load Profile
Back to Top

Top SQL Command Types

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
SELECT855.591.05
INSERT323.240.44
UPDATE36.470.12
PL/SQL EXECUTE22.060.04

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
SQL Execution87.351.65
PLSQL Execution2.060.04

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
8dq0v1mjngj7t9006116456920.29 db file sequential read20.29TABLE ACCESS - BY INDEX ROWID11.47 SELECT CUSTOMER_ID, CUST_FIRST...
c13sma6rkr27c16404440706719.71 db file sequential read16.47TABLE ACCESS - BY INDEX ROWID16.18 SELECT PRODUCTS.PRODUCT_ID, PR...
db file parallel read3.24TABLE ACCESS - BY INDEX ROWID2.65
bymb3ujkr3ubk4947354774914.41 db file sequential read14.12LOAD TABLE CONVENTIONAL14.12 INSERT INTO ORDERS(ORDER_ID, O...
0yas01u2p9ch4 277.94 db file sequential read7.94** Row Source Not Available **7.94 INSERT INTO ORDER_ITEMS(ORDER_...
7hk2m2702ua0g4269299407236.76 db file sequential read6.76TABLE ACCESS - BY INDEX ROWID2.06 WITH NEED_TO_PROCESS AS (SELEC...

Back to Top SQL
Back to Top

Top SQL with Top Row Sources

SQL IDPlanHashSampled # of Executions% ActivityRow Source% RwSrcTop Event% EventSQL Text
8dq0v1mjngj7t9006116456920.29 TABLE ACCESS - BY INDEX ROWID11.47db file sequential read11.47 SELECT CUSTOMER_ID, CUST_FIRST...
INDEX - UNIQUE SCAN8.82db file sequential read8.82
c13sma6rkr27c16404440706719.71 TABLE ACCESS - BY INDEX ROWID18.82db file sequential read16.18 SELECT PRODUCTS.PRODUCT_ID, PR...
bymb3ujkr3ubk4947354774914.41 LOAD TABLE CONVENTIONAL14.41db file sequential read14.12 INSERT INTO ORDERS(ORDER_ID, O...
0yas01u2p9ch4 277.94 ** Row Source Not Available **7.94db file sequential read7.94 INSERT INTO ORDER_ITEMS(ORDER_...
7hk2m2702ua0g4269299407236.76 TABLE ACCESS - BY INDEX ROWID2.06db file sequential read2.06 WITH NEED_TO_PROCESS AS (SELEC...
INDEX - UNIQUE SCAN1.47db file sequential read1.47
INDEX - UNIQUE SCAN1.18db file sequential read1.18

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
0yas01u2p9ch4INSERT INTO ORDER_ITEMS(ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY) VALUES (:B4 , :B3 , :B2 , :B1 , 1)
7hk2m2702ua0gWITH NEED_TO_PROCESS AS (SELECT ORDER_ID, CUSTOMER_ID FROM ORDERS WHERE ORDER_STATUS <= 4 AND WAREHOUSE_ID = :B1 AND ROWNUM < 10 ) SELECT O.ORDER_ID, OI.LINE_ITEM_ID, OI.PRODUCT_ID, OI.UNIT_PRICE, OI.QUANTITY, O.ORDER_MODE, O.ORDER_STATUS, O.ORDER_TOTAL, O.SALES_REP_ID, O.PROMOTION_ID, C.CUSTOMER_ID, C.CUST_FIRST_NAME, C.CUST_LAST_NAME, C.CREDIT_LIMIT, C.CUST_EMAIL, O.ORDER_DATE FROM ORDERS O, NEED_TO_PROCESS NTP, CUSTOMERS C, ORDER_ITEMS OI WHERE NTP.ORDER_ID = O.ORDER_ID AND C.CUSTOMER_ID = O.CUSTOMER_ID AND OI.ORDER_ID (+) = O.ORDER_ID
8dq0v1mjngj7tSELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID FROM CUSTOMERS WHERE CUSTOMER_ID = :B2 AND ROWNUM < :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
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.NEWORDER58.53 SQL57.65
SOE.ORDERENTRY.BROWSEPRODUCTS14.12 SQL12.94
SOE.ORDERENTRY.PROCESSORDERS#28.82 SQL8.82
SOE.ORDERENTRY.BROWSEANDUPDATEORDERS4.41 SQL4.41


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 Exec30690.001.70


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
156, 36.18db file sequential read5.59 SOEJDBC Thin Client19/180 [ 11%]7
27, 11135.59db file sequential read5.00 SOEJDBC Thin Client17/180 [ 9%]7
139, 9295.59db file sequential read5.29 SOEJDBC Thin Client18/180 [ 10%]11
142,217775.59db file sequential read4.71 SOEJDBC Thin Client16/180 [ 9%]4
153,274115.59db file sequential read4.71 SOEJDBC Thin Client16/180 [ 9%]5

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid (Inst)% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
129, 1( 1)2.65log file sync2.65 SYSORACLE.EXE (LGWR)12/180 [ 7%]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
8122724.41db file sequential read21.76 SOE.INVENTORIES (TABLE)SOE
db file parallel read2.65
8122313.53db file sequential read13.53 SOE.CUSTOMERS (TABLE)SOE
8123410.59db file sequential read10.59 SOE.CUSTOMERS_PK (INDEX)SOE
812378.53db file sequential read8.53 SOE.ORDER_PK (INDEX)SOE
812497.06db file sequential read6.76 SOE.ORD_WAREHOUSE_IX (INDEX)SOE

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
684.71db file sequential read81.18 C:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SOE.DBFSOE
db file parallel read3.24

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
16:30:00 (5.0 min)1control file sequential read10.29
16:35:00 (5.0 min)30db file sequential read226.47
db file parallel read41.18
control file sequential read20.59
16:40:00 (5.0 min)89db file sequential read6820.00
control file sequential read72.06
log file sync41.18
16:45:00 (5.0 min)76db file sequential read6318.53
db file parallel read41.18
log file parallel write30.88
16:50:00 (5.0 min)75db file sequential read6218.24
log file parallel write30.88
log file sync30.88
16:55:00 (5.0 min)69db file sequential read6117.94
log file parallel write30.88
CPU + Wait for CPU20.59


Back to Top

End of Report