DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
---|---|---|---|---|---|---|
DB11G | 279886783 | DB11G | 1 | 11.2.0.3.0 | NO | ol6-112.localdomain |
CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
---|---|---|---|---|
2 | 597M (100%) | 372M (62.3%) | 204M (34.2%) | 4.0M (0.7%) |
Sample Time | Data Source | |
---|---|---|
Analysis Begin Time: | 07-Oct-13 20:57:46 | V$ACTIVE_SESSION_HISTORY |
Analysis End Time: | 07-Oct-13 21:02:46 | V$ACTIVE_SESSION_HISTORY |
Elapsed Time: | 5.0 (mins) | |
Sample Count: | 1,433 | |
Average Active Sessions: | 4.78 | |
Avg. Active Session per CPU: | 2.39 | |
Report Target: | None specified |
Event | Event Class | % Event | Avg Active Sessions |
---|---|---|---|
CPU + Wait for CPU | CPU | 88.14 | 4.21 |
db file sequential read | User I/O | 2.65 | 0.13 |
Event | Event Class | % Activity | Avg Active Sessions |
---|---|---|---|
CPU + Wait for CPU | CPU | 2.79 | 0.13 |
log file parallel write | System I/O | 1.54 | 0.07 |
Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
---|---|---|---|---|---|---|
db file sequential read | 2.65 | "6","8526","1" | 0.07 | file# | block# | blocks |
log file parallel write | 1.54 | "1","2","1" | 0.98 | files | blocks | requests |
Service | Module | % Activity | Action | % Action |
---|---|---|---|---|
DB11G.WORLD | New Order | 38.87 | getProductDetailsByCategory | 19.82 |
DB11G.WORLD | New Order | 38.86950453593859036985345429169574319609 | UNNAMED | 12.70 |
DB11G.WORLD | New Order | 38.86950453593859036985345429169574319609 | logon | 4.88 |
DB11G.WORLD | Browse Products | 21.98 | getProductDetails | 10.40 |
DB11G.WORLD | Browse Products | 21.98185624563852058618283321702721563154 | UNNAMED | 5.65 |
DB11G.WORLD | Browse Products | 21.98185624563852058618283321702721563154 | logon | 4.68 |
DB11G.WORLD | UNNAMED | 14.65 | UNNAMED | 14.65 |
DB11G.WORLD | Process Orders | 7.96 | UNNAMED | 7.96 |
SYS$BACKGROUND | UNNAMED | 5.51 | UNNAMED | 5.51 |
SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
---|---|---|---|
SELECT | 34 | 36.15 | 1.73 |
PL/SQL EXECUTE | 10 | 33.64 | 1.61 |
INSERT | 7 | 12.56 | 0.60 |
UPDATE | 1 | 2.86 | 0.14 |
Phase of Execution | % Activity | Avg Active Sessions |
---|---|---|
SQL Execution | 85.28 | 4.07 |
PLSQL Execution | 21.91 | 1.05 |
Parse | 3.56 | 0.17 |
Cursor Close | 2.09 | 0.10 |
Hard Parse | 1.26 | 0.06 |
SQL ID | Planhash | Sampled # of Executions | % Activity | Event | % Event | Top Row Source | % RwSrc | SQL Text |
---|---|---|---|---|---|---|---|---|
c13sma6rkr27c | 2583456710 | 243 | 17.59 | CPU + Wait for CPU | 17.38 | HASH JOIN - OUTER | 7.82 | SELECT PRODUCTS.PRODUCT_ID, PR... |
147a57cxq3w5y | 193 | 14.17 | CPU + Wait for CPU | 13.54 | ** Row Source Not Available ** | 13.54 | BEGIN :1 := orderentry.browsep... | |
0w2qpuc6u2zsp | 162 | 12.21 | CPU + Wait for CPU | 11.86 | ** Row Source Not Available ** | 11.86 | BEGIN :1 := orderentry.neworde... | |
0y1prvxqc2ra9 | 302912750 | 91 | 7.19 | CPU + Wait for CPU | 7.19 | SELECT STATEMENT | 4.05 | SELECT PRODUCTS.PRODUCT_ID, PR... |
bymb3ujkr3ubk | 494735477 | 68 | 6.77 | CPU + Wait for CPU | 6.14 | LOAD TABLE CONVENTIONAL | 3.56 | INSERT INTO ORDERS(ORDER_ID, O... |
SQL ID | PlanHash | Sampled # of Executions | % Activity | Row Source | % RwSrc | Top Event | % Event | SQL Text |
---|---|---|---|---|---|---|---|---|
c13sma6rkr27c | 2583456710 | 243 | 17.59 | HASH JOIN - OUTER | 7.89 | CPU + Wait for CPU | 7.82 | SELECT PRODUCTS.PRODUCT_ID, PR... |
c13sma6rkr27c | 2583456710 | 243 | 17.58548499651081646894626657362177250523 |
SELECT STATEMENT | 3.63 | CPU + Wait for CPU | 3.63 | |
c13sma6rkr27c | 2583456710 | 243 | 17.58548499651081646894626657362177250523 |
TABLE ACCESS - BY INDEX ROWID | 1.67 | CPU + Wait for CPU | 1.67 | |
147a57cxq3w5y | 193 | 14.17 | ** Row Source Not Available ** | 14.17 | CPU + Wait for CPU | 13.54 | BEGIN :1 := orderentry.browsep... | |
0w2qpuc6u2zsp | 162 | 12.21 | ** Row Source Not Available ** | 12.21 | CPU + Wait for CPU | 11.86 | BEGIN :1 := orderentry.neworde... | |
0y1prvxqc2ra9 | 302912750 | 91 | 7.19 | SELECT STATEMENT | 4.05 | CPU + Wait for CPU | 4.05 | SELECT PRODUCTS.PRODUCT_ID, PR... |
bymb3ujkr3ubk | 494735477 | 68 | 6.77 | LOAD TABLE CONVENTIONAL | 4.12 | CPU + Wait for CPU | 3.56 | INSERT INTO ORDERS(ORDER_ID, O... |
bymb3ujkr3ubk | 494735477 | 68 | 6.76901605024424284717376133984647592463 |
INSERT STATEMENT | 2.16 | CPU + Wait for CPU | 2.09 |
Module | Action | % Activity | Event | % Event |
---|---|---|---|---|
2.09 | CPU + Wait for CPU | 2.09 |
PLSQL Entry Subprogram | % Activity | PLSQL Current Subprogram | % Current |
---|---|---|---|
SOE.ORDERENTRY.NEWORDER | 39.57 | SQL | 32.17 |
SOE.ORDERENTRY.NEWORDER | 39.56734124214933705512909979064898813678 |
SOE.ORDERENTRY.NEWORDER | 3.98 |
SOE.ORDERENTRY.NEWORDER | 39.56734124214933705512909979064898813678 |
SYS.DBMS_APPLICATION_INFO.SET_ACTION | 1.67 |
SOE.ORDERENTRY.BROWSEPRODUCTS | 22.89 | SQL | 14.10 |
SOE.ORDERENTRY.BROWSEPRODUCTS | 22.88904396371249127704117236566643405443 |
SOE.ORDERENTRY.BROWSEPRODUCTS | 5.51 |
SOE.ORDERENTRY.BROWSEPRODUCTS | 22.88904396371249127704117236566643405443 |
SYS.DBMS_APPLICATION_INFO.SET_ACTION | 1.40 |
SOE.ORDERENTRY.PROCESSORDERS#2 | 8.23 | SQL | 6.91 |
SOE.ORDERENTRY.NEWCUSTOMER | 4.05 | SQL | 3.56 |
SOE.ORDERENTRY.BROWSEANDUPDATEORDERS | 2.65 | SQL | 2.02 |
Call Type | Count | % Activity | Avg Active Sessions |
---|---|---|---|
V8 Bundled Exec | 1,280 | 89.32 | 4.27 |
Cursor close all | 49 | 3.42 | 0.16 |
Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
---|---|---|---|---|---|---|---|
34, 71 | 4.33 | CPU + Wait for CPU | 4.19 | SOE | JDBC Thin Client | 60/300 [ 20%] | 4 |
39, 3 | 4.12 | CPU + Wait for CPU | 3.70 | SOE | JDBC Thin Client | 53/300 [ 18%] | 9 |
40, 3 | 4.05 | CPU + Wait for CPU | 3.63 | SOE | JDBC Thin Client | 52/300 [ 17%] | 3 |
160, 1 | 4.05 | CPU + Wait for CPU | 3.91 | SOE | JDBC Thin Client | 56/300 [ 19%] | 7 |
27, 67 | 3.84 | CPU + Wait for CPU | 3.77 | SOE | JDBC Thin Client | 54/300 [ 18%] | 8 |
File ID | % Activity | Event | % Event | File Name | Tablespace |
---|---|---|---|---|---|
6 | 2.65 | db file sequential read | 2.65 | /u01/app/oracle/product/11.2.0/db_1/dbs/soe.dbf | SOE |
Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
---|---|---|---|---|
20:57:46 (14 secs) | 80 | CPU + Wait for CPU | 77 | 5.37 |
20:57:46 (14 secs) | 80 | log file parallel write | 1 | 0.07 |
20:57:46 (14 secs) | 80 | null event | 1 | 0.07 |
20:58:00 (1.0 min) | 228 | CPU + Wait for CPU | 202 | 14.10 |
20:58:00 (1.0 min) | 228 | db file sequential read | 9 | 0.63 |
20:58:00 (1.0 min) | 228 | latch free | 3 | 0.21 |
20:59:00 (1.0 min) | 278 | CPU + Wait for CPU | 251 | 17.52 |
20:59:00 (1.0 min) | 278 | db file sequential read | 8 | 0.56 |
20:59:00 (1.0 min) | 278 | log file parallel write | 6 | 0.42 |
21:00:00 (1.0 min) | 349 | CPU + Wait for CPU | 315 | 21.98 |
21:00:00 (1.0 min) | 349 | db file sequential read | 12 | 0.84 |
21:00:00 (1.0 min) | 349 | log file parallel write | 7 | 0.49 |
21:01:00 (1.0 min) | 282 | CPU + Wait for CPU | 257 | 17.93 |
21:01:00 (1.0 min) | 282 | db file sequential read | 6 | 0.42 |
21:01:00 (1.0 min) | 282 | log file parallel write | 4 | 0.28 |
21:02:00 (46 secs) | 216 | CPU + Wait for CPU | 201 | 14.03 |
21:02:00 (46 secs) | 216 | db file async I/O submit | 3 | 0.21 |
21:02:00 (46 secs) | 216 | db file sequential read | 3 | 0.21 |