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%) | 260M (25.5%) | 16.0M (1.6%) |
Sample Time | Data Source | |
---|---|---|
Analysis Begin Time: | 23-Apr-14 19:30:00 | V$ACTIVE_SESSION_HISTORY |
Analysis End Time: | 23-Apr-14 19:45:00 | V$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 |
Event | Event Class | % Event | Avg Active Sessions |
---|---|---|---|
db file sequential read | User I/O | 73.34 | 10.08 |
CPU + Wait for CPU | CPU | 20.97 | 2.88 |
log file sync | Commit | 2.17 | 0.30 |
Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
---|---|---|---|---|---|---|
db file sequential read | 73.44 | "5","245639","1" | 0.02 | file# | block# | blocks |
log file sync | 2.17 | "6680","101317920","0" | 0.02 | buffer# | sync scn | NOT DEFINED |
Service | Module | % Activity | Action | % Action |
---|---|---|---|---|
DBM11203.antognini.ch | Swingbench User Thread | 98.10 | UNNAMED | 98.10 |
SYS$BACKGROUND | UNNAMED | 1.66 | UNNAMED | 1.66 |
Client ID | % Activity | Avg Active Sessions | User | Program | Service |
---|---|---|---|---|---|
Swingbench | 98.10 | 13.49 | SOE | JDBC Thin Client | DBM11203.antognini.ch |
SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
---|---|---|---|
SELECT | 21 | 56.46 | 7.76 |
INSERT | 10 | 28.58 | 3.93 |
UPDATE | 5 | 10.14 | 1.39 |
Phase of Execution | % Activity | Avg Active Sessions |
---|---|---|
SQL Execution | 94.53 | 13.00 |
SQL ID | Planhash | Sampled # of Executions | % Activity | Event | % Event | Top Row Source | % RwSrc | SQL Text |
---|---|---|---|---|---|---|---|---|
82ud5h0qcg0bf | 4238351645 | 3542 | 28.71 | db file sequential read | 28.22 | TABLE ACCESS - BY INDEX ROWID | 15.86 | select customer_id, cust_first... |
g8rhybcumtwd6 | 799079936 | 2172 | 17.56 | CPU + Wait for CPU | 16.63 | INDEX - RANGE SCAN | 6.00 | SELECT /*+ first_rows index(cu... |
8vvvyuun2urt6 | 1365 | 11.11 | db file sequential read | 10.23 | ** Row Source Not Available ** | 10.23 | insert into order_items(ORDER_... | |
9zd49du11u7cf | 1268 | 10.30 | db file sequential read | 9.86 | ** Row Source Not Available ** | 9.86 | insert into orders(ORDER_ID, O... | |
d5j6fbqmu3gjp | 724732537 | 995 | 8.07 | db file sequential read | 7.96 | INDEX - RANGE SCAN | 3.68 | SELECT /*+ use_nl */ o.order_i... |
SQL ID | PlanHash | Sampled # of Executions | % Activity | Row Source | % RwSrc | Top Event | % Event | SQL Text |
---|---|---|---|---|---|---|---|---|
82ud5h0qcg0bf | 4238351645 | 3542 | 28.71 | TABLE ACCESS - BY INDEX ROWID | 15.98 | db file sequential read | 15.86 | select customer_id, cust_first... |
82ud5h0qcg0bf | 4238351645 | 3542 | 28.71343138839502181994504606432843058025 |
INDEX - UNIQUE SCAN | 12.53 | db file sequential read | 12.36 | |
g8rhybcumtwd6 | 799079936 | 2172 | 17.56 | INDEX - RANGE SCAN | 6.14 | CPU + Wait for CPU | 6.00 | SELECT /*+ first_rows index(cu... |
g8rhybcumtwd6 | 799079936 | 2172 | 17.56101503151769839987069662194924842412 |
INDEX - UNIQUE SCAN | 4.90 | CPU + Wait for CPU | 4.72 | |
g8rhybcumtwd6 | 799079936 | 2172 | 17.56101503151769839987069662194924842412 |
TABLE ACCESS - BY INDEX ROWID | 2.93 | CPU + Wait for CPU | 2.70 | |
8vvvyuun2urt6 | 1365 | 11.11 | ** Row Source Not Available ** | 11.11 | db file sequential read | 10.23 | insert into order_items(ORDER_... | |
9zd49du11u7cf | 1268 | 10.30 | ** Row Source Not Available ** | 10.30 | db file sequential read | 9.86 | insert into orders(ORDER_ID, O... | |
d5j6fbqmu3gjp | 724732537 | 995 | 8.07 | INDEX - RANGE SCAN | 3.70 | db file sequential read | 3.68 | SELECT /*+ use_nl */ o.order_i... |
d5j6fbqmu3gjp | 724732537 | 995 | 8.06529820591562954582188459673508970422 |
TABLE ACCESS - BY INDEX ROWID | 1.65 | db file sequential read | 1.64 | |
d5j6fbqmu3gjp | 724732537 | 995 | 8.06529820591562954582188459673508970422 |
TABLE ACCESS - BY INDEX ROWID | 1.44 | db file sequential read | 1.41 |
Call Type | Count | % Activity | Avg Active Sessions |
---|---|---|---|
V8 Bundled Exec | 11,809 | 95.43 | 13.12 |
COMMIT | 304 | 2.46 | 0.34 |
Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
---|---|---|---|---|---|---|---|
131, 53 | 2.69 | db file sequential read | 1.98 | SOE | JDBC Thin Client | 245/900 [ 27%] | 114 |
7, 65 | 2.68 | db file sequential read | 2.11 | SOE | JDBC Thin Client | 261/900 [ 29%] | 126 |
3, 3 | 2.66 | db file sequential read | 1.99 | SOE | JDBC Thin Client | 246/900 [ 27%] | 133 |
6, 59 | 2.60 | db file sequential read | 1.92 | SOE | JDBC Thin Client | 238/900 [ 26%] | 120 |
162, 3 | 2.60 | db file sequential read | 1.93 | SOE | JDBC Thin Client | 239/900 [ 27%] | 116 |
Blocking Sid (Inst) | % Activity | Event Caused | % Event | User | Program | # Samples Active | XIDs |
---|---|---|---|---|---|---|---|
95, 1( 1) | 3.48 | log file sync | 2.17 | SYS | oracle@helicon (LGWR) | 147/900 [ 16%] | 0 |
Object ID | % Activity | Event | % Event | Object Name (Type) | Tablespace |
---|---|---|---|---|---|
43487 | 16.07 | db file sequential read | 15.99 | SOE.CUSTOMERS (TABLE) | SOE |
43498 | 14.09 | db file sequential read | 14.02 | SOE.CUSTOMERS_PK (INDEX) | SOE |
44495 | 8.08 | db file sequential read | 8.08 | SOE.ORD_CUSTOMER_IX (INDEX) | SOE |
43491 | 7.35 | db file sequential read | 7.34 | SOE.INVENTORIES (TABLE) | SOE |
44499 | 5.88 | db file sequential read | 5.85 | SOE.ITEM_ORDER_IX (INDEX) | SOE |
File ID | % Activity | Event | % Event | File Name | Tablespace |
---|---|---|---|---|---|
5 | 73.62 | db file sequential read | 73.27 | +DATA/dbm11203/datafile/soe.486.836957131 | SOE |
Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
---|---|---|---|---|
19:30:00 (2.0 min) | 1,349 | db file sequential read | 990 | 8.00 |
19:30:00 (2.0 min) | 1349 | CPU + Wait for CPU | 300 | 2.42 |
19:30:00 (2.0 min) | 1349 | log file sync | 20 | 0.16 |
19:32:00 (2.0 min) | 1,520 | db file sequential read | 1,133 | 9.16 |
19:32:00 (2.0 min) | 1520 | CPU + Wait for CPU | 336 | 2.72 |
19:32:00 (2.0 min) | 1520 | log file sync | 27 | 0.22 |
19:34:00 (2.0 min) | 1,711 | db file sequential read | 1,243 | 10.05 |
19:34:00 (2.0 min) | 1711 | CPU + Wait for CPU | 368 | 2.97 |
19:34:00 (2.0 min) | 1711 | log file sync | 44 | 0.36 |
19:36:00 (2.0 min) | 1,805 | db file sequential read | 1,392 | 11.25 |
19:36:00 (2.0 min) | 1805 | CPU + Wait for CPU | 320 | 2.59 |
19:36:00 (2.0 min) | 1805 | log file sync | 35 | 0.28 |
19:38:00 (2.0 min) | 1,793 | db file sequential read | 1,291 | 10.43 |
19:38:00 (2.0 min) | 1793 | CPU + Wait for CPU | 357 | 2.89 |
19:38:00 (2.0 min) | 1793 | log file sync | 52 | 0.42 |
19:40:00 (2.0 min) | 1,686 | db file sequential read | 1,204 | 9.73 |
19:40:00 (2.0 min) | 1686 | CPU + Wait for CPU | 388 | 3.14 |
19:40:00 (2.0 min) | 1686 | log file sync | 46 | 0.37 |
19:42:00 (2.0 min) | 1,610 | db file sequential read | 1,160 | 9.37 |
19:42:00 (2.0 min) | 1610 | CPU + Wait for CPU | 378 | 3.05 |
19:42:00 (2.0 min) | 1610 | log file sync | 28 | 0.23 |
19:44:00 (60 secs) | 900 | db file sequential read | 675 | 5.45 |
19:44:00 (60 secs) | 900 | CPU + Wait for CPU | 191 | 1.54 |
19:44:00 (60 secs) | 900 | log file sync | 16 | 0.13 |