DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
---|---|---|---|---|---|---|
DBM11203 | 2532911053 | DBM11203 | 1 | 11.2.0.3.0 | NO | helicon |
CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
---|---|---|---|---|
8 | 1,019M (100%) | 728M (71.4%) | 208M (20.4%) | 16.0M (1.6%) |
Sample Time | Data Source | |
---|---|---|
Analysis Begin Time: | 23-Apr-14 18:45:00 | DBA_HIST_ACTIVE_SESS_HISTORY in AWR snapshot 1823 |
Analysis End Time: | 23-Apr-14 19:00:00 | DBA_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 |
Event | Event Class | % Event | Avg Active Sessions |
---|---|---|---|
db file sequential read | User I/O | 67.23 | 4.90 |
CPU + Wait for CPU | CPU | 28.96 | 2.11 |
log file sync | Commit | 1.68 | 0.12 |
Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
---|---|---|---|---|---|---|
db file sequential read | 67.23 | "5","10401","1" | 0.15 | file# | block# | blocks |
log file sync | 1.68 | "869","100244426","0" | 0.15 | buffer# | sync scn | NOT DEFINED |
Service | Module | % Activity | Action | % Action |
---|---|---|---|---|
DBM11203.antognini.ch | Swingbench User Thread | 98.17 | UNNAMED | 98.17 |
SYS$BACKGROUND | UNNAMED | 1.83 | UNNAMED | 1.83 |
Client ID | % Activity | Avg Active Sessions | User | Program | Service |
---|---|---|---|---|---|
Swingbench | 98.17 | 7.16 | SOE | JDBC Thin Client | DBM11203.antognini.ch |
SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
---|---|---|---|
SELECT | 7 | 63.11 | 4.60 |
INSERT | 4 | 24.54 | 1.79 |
UPDATE | 2 | 7.47 | 0.54 |
Phase of Execution | % Activity | Avg Active Sessions |
---|---|---|
SQL Execution | 94.66 | 6.90 |
SQL ID | Planhash | Sampled # of Executions | % Activity | Event | % Event | Top Row Source | % RwSrc | SQL Text |
---|---|---|---|---|---|---|---|---|
82ud5h0qcg0bf | 4238351645 | 187 | 28.51 | db file sequential read | 28.51 | TABLE ACCESS - BY INDEX ROWID | 14.63 | select customer_id, cust_first... |
g8rhybcumtwd6 | 799079936 | 160 | 24.39 | CPU + Wait for CPU | 23.63 | INDEX - RANGE SCAN | 9.15 | SELECT /*+ first_rows index(cu... |
9zd49du11u7cf | 59 | 8.99 | db file sequential read | 8.54 | ** Row Source Not Available ** | 8.54 | insert into orders(ORDER_ID, O... | |
8vvvyuun2urt6 | 57 | 8.84 | db file sequential read | 8.38 | ** Row Source Not Available ** | 8.38 | insert into order_items(ORDER_... | |
d5j6fbqmu3gjp | 724732537 | 50 | 7.62 | db file sequential read | 7.32 | INDEX - RANGE SCAN | 4.57 | SELECT /*+ use_nl */ o.order_i... |
SQL ID | PlanHash | Sampled # of Executions | % Activity | Row Source | % RwSrc | Top Event | % Event | SQL Text |
---|---|---|---|---|---|---|---|---|
82ud5h0qcg0bf | 4238351645 | 187 | 28.51 | TABLE ACCESS - BY INDEX ROWID | 14.63 | db file sequential read | 14.63 | select customer_id, cust_first... |
82ud5h0qcg0bf | 4238351645 | 187 | 28.50609756097560975609756097560975609756 |
INDEX - UNIQUE SCAN | 13.87 | db file sequential read | 13.87 | |
g8rhybcumtwd6 | 799079936 | 160 | 24.39 | INDEX - RANGE SCAN | 9.60 | CPU + Wait for CPU | 9.15 | SELECT /*+ first_rows index(cu... |
g8rhybcumtwd6 | 799079936 | 160 | 24.3902439024390243902439024390243902439 |
INDEX - UNIQUE SCAN | 5.18 | CPU + Wait for CPU | 5.03 | |
g8rhybcumtwd6 | 799079936 | 160 | 24.3902439024390243902439024390243902439 |
TABLE ACCESS - BY INDEX ROWID | 4.73 | CPU + Wait for CPU | 4.73 | |
9zd49du11u7cf | 59 | 8.99 | ** Row Source Not Available ** | 8.99 | db file sequential read | 8.54 | insert into orders(ORDER_ID, O... | |
8vvvyuun2urt6 | 57 | 8.84 | ** Row Source Not Available ** | 8.84 | db file sequential read | 8.38 | insert into order_items(ORDER_... | |
d5j6fbqmu3gjp | 724732537 | 50 | 7.62 | INDEX - RANGE SCAN | 4.73 | db file sequential read | 4.57 | SELECT /*+ use_nl */ o.order_i... |
d5j6fbqmu3gjp | 724732537 | 50 | 7.62195121951219512195121951219512195122 |
TABLE ACCESS - BY INDEX ROWID | 1.22 | db file sequential read | 1.22 |
Call Type | Count | % Activity | Avg Active Sessions |
---|---|---|---|
V8 Bundled Exec | 631 | 96.19 | 7.01 |
COMMIT | 13 | 1.98 | 0.14 |
Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
---|---|---|---|---|---|---|---|
70, 3 | 5.03 | db file sequential read | 3.81 | SOE | JDBC Thin Client | 25/90 [ 28%] | 13 |
70, 3 | 5.0304878048780487804878048780487804878 | CPU + Wait for CPU | 1.22 | SOE | JDBC Thin Client | 8/90 [ 9%] | 3 |
71, 61 | 4.88 | db file sequential read | 3.51 | SOE | JDBC Thin Client | 23/90 [ 26%] | 12 |
71, 61 | 4.87804878048780487804878048780487804878 | CPU + Wait for CPU | 1.37 | SOE | JDBC Thin Client | 9/90 [ 10%] | 0 |
129, 5 | 4.73 | db file sequential read | 3.20 | SOE | JDBC Thin Client | 21/90 [ 23%] | 10 |
129, 5 | 4.72560975609756097560975609756097560976 | CPU + Wait for CPU | 1.22 | SOE | JDBC Thin Client | 8/90 [ 9%] | 1 |
161, 35 | 4.73 | db file sequential read | 3.05 | SOE | JDBC Thin Client | 20/90 [ 22%] | 9 |
161, 35 | 4.72560975609756097560975609756097560976 | CPU + Wait for CPU | 1.68 | SOE | JDBC Thin Client | 11/90 [ 12%] | 0 |
39, 73 | 4.57 | db file sequential read | 3.96 | SOE | JDBC Thin Client | 26/90 [ 29%] | 12 |
Blocking Sid (Inst) | % Activity | Event Caused | % Event | User | Program | # Samples Active | XIDs |
---|---|---|---|---|---|---|---|
95, 1( 1) | 1.68 | log file sync | 1.68 | SYS | oracle@helicon (LGWR) | 147/90 [163%] | 0 |
Object ID | % Activity | Event | % Event | Object Name (Type) | Tablespace |
---|---|---|---|---|---|
43498 | 16.01 | db file sequential read | 16.01 | SOE.CUSTOMERS_PK (INDEX) | SOE |
43487 | 14.63 | db file sequential read | 14.63 | SOE.CUSTOMERS (TABLE) | SOE |
44495 | 8.84 | db file sequential read | 8.84 | SOE.ORD_CUSTOMER_IX (INDEX) | SOE |
43491 | 6.25 | db file sequential read | 6.25 | SOE.INVENTORIES (TABLE) | SOE |
44499 | 5.79 | db file sequential read | 5.64 | SOE.ITEM_ORDER_IX (INDEX) | SOE |
File ID | % Activity | Event | % Event | File Name | Tablespace |
---|---|---|---|---|---|
5 | 67.38 | db file sequential read | 67.23 | +DATA/dbm11203/datafile/soe.486.836957131 | SOE |
Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
---|---|---|---|---|
18:45:00 (5.0 min) | 248 | db file sequential read | 176 | 26.83 |
18:45:00 (5.0 min) | 248 | CPU + Wait for CPU | 61 | 9.30 |
18:45:00 (5.0 min) | 248 | log file sync | 6 | 0.91 |
18:50:00 (5.0 min) | 221 | db file sequential read | 151 | 23.02 |
18:50:00 (5.0 min) | 221 | CPU + Wait for CPU | 64 | 9.76 |
18:50:00 (5.0 min) | 221 | db file parallel write | 2 | 0.30 |
18:55:00 (5.0 min) | 187 | db file sequential read | 114 | 17.38 |
18:55:00 (5.0 min) | 187 | CPU + Wait for CPU | 67 | 10.21 |
18:55:00 (5.0 min) | 187 | log file sync | 4 | 0.61 |