ASH Report For DBM11203/DBM11203

DB NameDB IdInstanceInst numReleaseRACHost
DBM112032532911053DBM11203111.2.0.3.0NOhelicon

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
81,019M (100%)728M (71.4%)260M (25.5%)16.0M (1.6%)

Sample TimeData Source
Analysis Begin Time:23-Apr-14 19:30:00V$ACTIVE_SESSION_HISTORY
Analysis End Time:23-Apr-14 19:45:00V$ACTIVE_SESSION_HISTORY
Elapsed Time: 15.0 (mins)  
Sample Count: 12,374 
Average Active Sessions: 13.75 
Avg. Active Session per CPU: 1.72 
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/O73.3410.08
CPU + Wait for CPUCPU20.972.88
log file syncCommit2.170.30

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
db file sequential read73.44"5","245639","1"0.02 file#block#blocks
log file sync2.17"6680","101317920","0"0.02 buffer#sync scnNOT DEFINED

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
DBM11203.antognini.chSwingbench User Thread98.10UNNAMED98.10
SYS$BACKGROUNDUNNAMED1.66UNNAMED1.66

Back to Load Profile
Back to Top

Top Client IDs

Client ID% ActivityAvg Active SessionsUserProgramService
Swingbench98.1013.49 SOEJDBC Thin ClientDBM11203.antognini.ch

Back to Load Profile
Back to Top

Top SQL Command Types

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
SELECT2156.467.76
INSERT1028.583.93
UPDATE510.141.39

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
SQL Execution94.5313.00

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
82ud5h0qcg0bf4238351645354228.71 db file sequential read28.22TABLE ACCESS - BY INDEX ROWID15.86 select customer_id, cust_first...
g8rhybcumtwd6799079936217217.56 CPU + Wait for CPU16.63INDEX - RANGE SCAN6.00 SELECT /*+ first_rows index(cu...
8vvvyuun2urt6 136511.11 db file sequential read10.23** Row Source Not Available **10.23 insert into order_items(ORDER_...
9zd49du11u7cf 126810.30 db file sequential read9.86** Row Source Not Available **9.86 insert into orders(ORDER_ID, O...
d5j6fbqmu3gjp7247325379958.07 db file sequential read7.96INDEX - RANGE SCAN3.68 SELECT /*+ use_nl */ o.order_i...

Back to Top SQL
Back to Top

Top SQL with Top Row Sources

SQL IDPlanHashSampled # of Executions% ActivityRow Source% RwSrcTop Event% EventSQL Text
82ud5h0qcg0bf4238351645354228.71 TABLE ACCESS - BY INDEX ROWID15.98db file sequential read15.86 select customer_id, cust_first...
INDEX - UNIQUE SCAN12.53db file sequential read12.36
g8rhybcumtwd6799079936217217.56 INDEX - RANGE SCAN6.14CPU + Wait for CPU6.00 SELECT /*+ first_rows index(cu...
INDEX - UNIQUE SCAN4.90CPU + Wait for CPU4.72
TABLE ACCESS - BY INDEX ROWID2.93CPU + Wait for CPU2.70
8vvvyuun2urt6 136511.11 ** Row Source Not Available **11.11db file sequential read10.23 insert into order_items(ORDER_...
9zd49du11u7cf 126810.30 ** Row Source Not Available **10.30db file sequential read9.86 insert into orders(ORDER_ID, O...
d5j6fbqmu3gjp7247325379958.07 INDEX - RANGE SCAN3.70db file sequential read3.68 SELECT /*+ use_nl */ o.order_i...
TABLE ACCESS - BY INDEX ROWID1.65db file sequential read1.64
TABLE ACCESS - BY INDEX ROWID1.44db file sequential read1.41

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
82ud5h0qcg0bfselect customer_id, cust_first_name , cust_last_name , nls_language , nls_territory , credit_limit , cust_email , account_mgr_id from customers where customer_id = :1
8vvvyuun2urt6insert into order_items(ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY) values (:1 , :2 , :3 , :4 , :5 )
9zd49du11u7cfinsert into orders(ORDER_ID, ORDER_DATE, CUSTOMER_ID, WAREHOUSE_ID) values (:1 , :2 , :3 , :4 )
d5j6fbqmu3gjpSELECT /*+ use_nl */ o.order_id, line_item_id, product_id, unit_price, quantity, order_mode, order_status, order_total, sales_rep_id, promotion_id, c.customer_id, cust_first_name, cust_last_name, credit_limit, cust_email FROM orders o , order_items oi, customers c WHERE o.order_id = oi.order_id and o.customer_id = c.customer_id and c.customer_id = :1
g8rhybcumtwd6SELECT /*+ first_rows index(customers, customers_pk) index(orders, order_status_ix) */ o.order_id, line_item_id, product_id, unit_price, quantity, order_mode, order_status, order_total, sales_rep_id, promotion_id, c.customer_id, cust_first_name, cust_last_name, credit_limit, cust_email, order_date FROM orders o , order_items oi, customers c WHERE o.order_id = oi.order_id and o.customer_id = c.customer_id and o.order_status <= 4

Back to Top SQL
Back to Top

Top PL/SQL Procedures

No data exists for this section of the report.


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 Exec11,80995.4313.12
COMMIT3042.460.34


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
131, 532.69db file sequential read1.98 SOEJDBC Thin Client245/900 [ 27%]114
7, 652.68db file sequential read2.11 SOEJDBC Thin Client261/900 [ 29%]126
3, 32.66db file sequential read1.99 SOEJDBC Thin Client246/900 [ 27%]133
6, 592.60db file sequential read1.92 SOEJDBC Thin Client238/900 [ 26%]120
162, 32.60db file sequential read1.93 SOEJDBC Thin Client239/900 [ 27%]116

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid (Inst)% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
95, 1( 1)3.48log file sync2.17 SYSoracle@helicon (LGWR)147/900 [ 16%]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
4348716.07db file sequential read15.99 SOE.CUSTOMERS (TABLE)SOE
4349814.09db file sequential read14.02 SOE.CUSTOMERS_PK (INDEX)SOE
444958.08db file sequential read8.08 SOE.ORD_CUSTOMER_IX (INDEX)SOE
434917.35db file sequential read7.34 SOE.INVENTORIES (TABLE)SOE
444995.88db file sequential read5.85 SOE.ITEM_ORDER_IX (INDEX)SOE

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
573.62db file sequential read73.27 +DATA/dbm11203/datafile/soe.486.836957131SOE

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
19:30:00 (2.0 min)1,349db file sequential read9908.00
CPU + Wait for CPU3002.42
log file sync200.16
19:32:00 (2.0 min)1,520db file sequential read1,1339.16
CPU + Wait for CPU3362.72
log file sync270.22
19:34:00 (2.0 min)1,711db file sequential read1,24310.05
CPU + Wait for CPU3682.97
log file sync440.36
19:36:00 (2.0 min)1,805db file sequential read1,39211.25
CPU + Wait for CPU3202.59
log file sync350.28
19:38:00 (2.0 min)1,793db file sequential read1,29110.43
CPU + Wait for CPU3572.89
log file sync520.42
19:40:00 (2.0 min)1,686db file sequential read1,2049.73
CPU + Wait for CPU3883.14
log file sync460.37
19:42:00 (2.0 min)1,610db file sequential read1,1609.37
CPU + Wait for CPU3783.05
log file sync280.23
19:44:00 (60 secs)900db file sequential read6755.45
CPU + Wait for CPU1911.54
log file sync160.13


Back to Top

End of Report