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%)208M (20.4%)16.0M (1.6%)

Sample TimeData Source
Analysis Begin Time:23-Apr-14 18:45:00DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 1823
Analysis End Time:23-Apr-14 19:00:00DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 1823
+ V$ACTIVE_SESSION_HISTORY
Elapsed Time: 15.0 (mins)  
Sample Count: 656 
Average Active Sessions: 7.29 
Avg. Active Session per CPU: 0.91 
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/O67.234.90
CPU + Wait for CPUCPU28.962.11
log file syncCommit1.680.12

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 read67.23"5","10401","1"0.15 file#block#blocks
log file sync1.68"869","100244426","0"0.15 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.17UNNAMED98.17
SYS$BACKGROUNDUNNAMED1.83UNNAMED1.83

Back to Load Profile
Back to Top

Top Client IDs

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

Back to Load Profile
Back to Top

Top SQL Command Types

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
SELECT763.114.60
INSERT424.541.79
UPDATE27.470.54

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
SQL Execution94.666.90

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
82ud5h0qcg0bf423835164518728.51 db file sequential read28.51TABLE ACCESS - BY INDEX ROWID14.63 select customer_id, cust_first...
g8rhybcumtwd679907993616024.39 CPU + Wait for CPU23.63INDEX - RANGE SCAN9.15 SELECT /*+ first_rows index(cu...
9zd49du11u7cf 598.99 db file sequential read8.54** Row Source Not Available **8.54 insert into orders(ORDER_ID, O...
8vvvyuun2urt6 578.84 db file sequential read8.38** Row Source Not Available **8.38 insert into order_items(ORDER_...
d5j6fbqmu3gjp724732537507.62 db file sequential read7.32INDEX - RANGE SCAN4.57 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
82ud5h0qcg0bf423835164518728.51 TABLE ACCESS - BY INDEX ROWID14.63db file sequential read14.63 select customer_id, cust_first...
INDEX - UNIQUE SCAN13.87db file sequential read13.87
g8rhybcumtwd679907993616024.39 INDEX - RANGE SCAN9.60CPU + Wait for CPU9.15 SELECT /*+ first_rows index(cu...
INDEX - UNIQUE SCAN5.18CPU + Wait for CPU5.03
TABLE ACCESS - BY INDEX ROWID4.73CPU + Wait for CPU4.73
9zd49du11u7cf 598.99 ** Row Source Not Available **8.99db file sequential read8.54 insert into orders(ORDER_ID, O...
8vvvyuun2urt6 578.84 ** Row Source Not Available **8.84db file sequential read8.38 insert into order_items(ORDER_...
d5j6fbqmu3gjp724732537507.62 INDEX - RANGE SCAN4.73db file sequential read4.57 SELECT /*+ use_nl */ o.order_i...
TABLE ACCESS - BY INDEX ROWID1.22db file sequential read1.22

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 Exec63196.197.01
COMMIT131.980.14


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
70, 35.03db file sequential read3.81 SOEJDBC Thin Client25/90 [ 28%]13
CPU + Wait for CPU1.22 8/90 [ 9%]3
71, 614.88db file sequential read3.51 SOEJDBC Thin Client23/90 [ 26%]12
CPU + Wait for CPU1.37 9/90 [ 10%]0
129, 54.73db file sequential read3.20 SOEJDBC Thin Client21/90 [ 23%]10
CPU + Wait for CPU1.22 8/90 [ 9%]1
161, 354.73db file sequential read3.05 SOEJDBC Thin Client20/90 [ 22%]9
CPU + Wait for CPU1.68 11/90 [ 12%]0
39, 734.57db file sequential read3.96 SOEJDBC Thin Client26/90 [ 29%]12

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid (Inst)% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
95, 1( 1)1.68log file sync1.68 SYSoracle@helicon (LGWR)147/90 [163%]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
4349816.01db file sequential read16.01 SOE.CUSTOMERS_PK (INDEX)SOE
4348714.63db file sequential read14.63 SOE.CUSTOMERS (TABLE)SOE
444958.84db file sequential read8.84 SOE.ORD_CUSTOMER_IX (INDEX)SOE
434916.25db file sequential read6.25 SOE.INVENTORIES (TABLE)SOE
444995.79db file sequential read5.64 SOE.ITEM_ORDER_IX (INDEX)SOE

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
567.38db file sequential read67.23 +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
18:45:00 (5.0 min)248db file sequential read17626.83
CPU + Wait for CPU619.30
log file sync60.91
18:50:00 (5.0 min)221db file sequential read15123.02
CPU + Wait for CPU649.76
db file parallel write20.30
18:55:00 (5.0 min)187db file sequential read11417.38
CPU + Wait for CPU6710.21
log file sync40.61


Back to Top

End of Report