DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
---|---|---|---|---|---|---|
DB11G | 278174245 | db11g | 1 | 11.2.0.3.0 | NO | IS-2YB6X4J |
CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
---|---|---|---|---|
2 | 749M (100%) | 240M (32.1%) | 359M (47.9%) | M (%) |
Sample Time | Data Source | |
---|---|---|
Analysis Begin Time: | 06-Jun-13 16:30:00 | DBA_HIST_ACTIVE_SESS_HISTORY in AWR snapshot 1378 |
Analysis End Time: | 06-Jun-13 17:00:00 | DBA_HIST_ACTIVE_SESS_HISTORY in AWR snapshot 1379 |
Elapsed Time: | 30.0 (mins) | |
Sample Count: | 340 | |
Average Active Sessions: | 1.89 | |
Avg. Active Session per CPU: | 0.94 | |
Report Target: | None specified |
Event | Event Class | % Event | Avg Active Sessions |
---|---|---|---|
db file sequential read | User I/O | 81.18 | 1.53 |
db file parallel read | User I/O | 3.24 | 0.06 |
log file sync | Commit | 2.65 | 0.05 |
CPU + Wait for CPU | CPU | 2.06 | 0.04 |
Event | Event Class | % Activity | Avg Active Sessions |
---|---|---|---|
control file sequential read | System I/O | 4.12 | 0.08 |
log file parallel write | System I/O | 3.53 | 0.07 |
db file parallel write | System I/O | 2.06 | 0.04 |
Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
---|---|---|---|---|---|---|
db file sequential read | 81.18 | "6","620","1" | 0.29 | file# | block# | blocks |
control file sequential read | 4.41 | "0","1","1" | 3.24 | file# | block# | blocks |
log file parallel write | 3.53 | "1","3","1" | 1.18 | files | blocks | requests |
db file parallel read | 3.24 | "1","3","3" | 0.88 | files | blocks | requests |
log file sync | 2.65 | "241","7018316","0" | 0.29 | buffer# | sync scn | NOT DEFINED |
Service | Module | % Activity | Action | % Action |
---|---|---|---|---|
DB11G.WORLD | New Order | 58.53 | UNNAMED | 26.76 |
DB11G.WORLD | New Order | 58.52941176470588235294117647058823529412 | getProductDetailsByCategory | 19.71 |
DB11G.WORLD | New Order | 58.52941176470588235294117647058823529412 | getCustomerDetails | 6.47 |
DB11G.WORLD | Browse Products | 14.12 | getCustomerDetails | 11.18 |
DB11G.WORLD | Browse Products | 14.11764705882352941176470588235294117647 | getProductDetails | 1.76 |
DB11G.WORLD | Browse Products | 14.11764705882352941176470588235294117647 | UNNAMED | 1.18 |
SYS$BACKGROUND | UNNAMED | 10.00 | UNNAMED | 10.00 |
DB11G.WORLD | Process Orders | 8.82 | UNNAMED | 8.82 |
DB11G.WORLD | Browse and Update Orders | 4.41 | getCustomerDetails | 2.65 |
DB11G.WORLD | Browse and Update Orders | 4.41176470588235294117647058823529411765 | getOrdersByCustomer | 1.18 |
Client ID | % Activity | Avg Active Sessions | User | Program | Service |
---|---|---|---|---|---|
Swingbench | 89.41 | 1.69 | SOE | JDBC Thin Client | DB11G.WORLD |
SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
---|---|---|---|
SELECT | 8 | 55.59 | 1.05 |
INSERT | 3 | 23.24 | 0.44 |
UPDATE | 3 | 6.47 | 0.12 |
PL/SQL EXECUTE | 2 | 2.06 | 0.04 |
Phase of Execution | % Activity | Avg Active Sessions |
---|---|---|
SQL Execution | 87.35 | 1.65 |
PLSQL Execution | 2.06 | 0.04 |
SQL ID | Planhash | Sampled # of Executions | % Activity | Event | % Event | Top Row Source | % RwSrc | SQL Text |
---|---|---|---|---|---|---|---|---|
8dq0v1mjngj7t | 900611645 | 69 | 20.29 | db file sequential read | 20.29 | TABLE ACCESS - BY INDEX ROWID | 11.47 | SELECT CUSTOMER_ID, CUST_FIRST... |
c13sma6rkr27c | 1640444070 | 67 | 19.71 | db file sequential read | 16.47 | TABLE ACCESS - BY INDEX ROWID | 16.18 | SELECT PRODUCTS.PRODUCT_ID, PR... |
c13sma6rkr27c | 1640444070 | 67 | 19.70588235294117647058823529411764705882 |
db file parallel read | 3.24 | TABLE ACCESS - BY INDEX ROWID | 2.65 | |
bymb3ujkr3ubk | 494735477 | 49 | 14.41 | db file sequential read | 14.12 | LOAD TABLE CONVENTIONAL | 14.12 | INSERT INTO ORDERS(ORDER_ID, O... |
0yas01u2p9ch4 | 27 | 7.94 | db file sequential read | 7.94 | ** Row Source Not Available ** | 7.94 | INSERT INTO ORDER_ITEMS(ORDER_... | |
7hk2m2702ua0g | 4269299407 | 23 | 6.76 | db file sequential read | 6.76 | TABLE ACCESS - BY INDEX ROWID | 2.06 | WITH NEED_TO_PROCESS AS (SELEC... |
SQL ID | PlanHash | Sampled # of Executions | % Activity | Row Source | % RwSrc | Top Event | % Event | SQL Text |
---|---|---|---|---|---|---|---|---|
8dq0v1mjngj7t | 900611645 | 69 | 20.29 | TABLE ACCESS - BY INDEX ROWID | 11.47 | db file sequential read | 11.47 | SELECT CUSTOMER_ID, CUST_FIRST... |
8dq0v1mjngj7t | 900611645 | 69 | 20.29411764705882352941176470588235294118 |
INDEX - UNIQUE SCAN | 8.82 | db file sequential read | 8.82 | |
c13sma6rkr27c | 1640444070 | 67 | 19.71 | TABLE ACCESS - BY INDEX ROWID | 18.82 | db file sequential read | 16.18 | SELECT PRODUCTS.PRODUCT_ID, PR... |
bymb3ujkr3ubk | 494735477 | 49 | 14.41 | LOAD TABLE CONVENTIONAL | 14.41 | db file sequential read | 14.12 | INSERT INTO ORDERS(ORDER_ID, O... |
0yas01u2p9ch4 | 27 | 7.94 | ** Row Source Not Available ** | 7.94 | db file sequential read | 7.94 | INSERT INTO ORDER_ITEMS(ORDER_... | |
7hk2m2702ua0g | 4269299407 | 23 | 6.76 | TABLE ACCESS - BY INDEX ROWID | 2.06 | db file sequential read | 2.06 | WITH NEED_TO_PROCESS AS (SELEC... |
7hk2m2702ua0g | 4269299407 | 23 | 6.76470588235294117647058823529411764706 |
INDEX - UNIQUE SCAN | 1.47 | db file sequential read | 1.47 | |
7hk2m2702ua0g | 4269299407 | 23 | 6.76470588235294117647058823529411764706 |
INDEX - UNIQUE SCAN | 1.18 | db file sequential read | 1.18 |
PLSQL Entry Subprogram | % Activity | PLSQL Current Subprogram | % Current |
---|---|---|---|
SOE.ORDERENTRY.NEWORDER | 58.53 | SQL | 57.65 |
SOE.ORDERENTRY.BROWSEPRODUCTS | 14.12 | SQL | 12.94 |
SOE.ORDERENTRY.PROCESSORDERS#2 | 8.82 | SQL | 8.82 |
SOE.ORDERENTRY.BROWSEANDUPDATEORDERS | 4.41 | SQL | 4.41 |
Call Type | Count | % Activity | Avg Active Sessions |
---|---|---|---|
V8 Bundled Exec | 306 | 90.00 | 1.70 |
Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
---|---|---|---|---|---|---|---|
156, 3 | 6.18 | db file sequential read | 5.59 | SOE | JDBC Thin Client | 19/180 [ 11%] | 7 |
27, 1113 | 5.59 | db file sequential read | 5.00 | SOE | JDBC Thin Client | 17/180 [ 9%] | 7 |
139, 929 | 5.59 | db file sequential read | 5.29 | SOE | JDBC Thin Client | 18/180 [ 10%] | 11 |
142,21777 | 5.59 | db file sequential read | 4.71 | SOE | JDBC Thin Client | 16/180 [ 9%] | 4 |
153,27411 | 5.59 | db file sequential read | 4.71 | SOE | JDBC Thin Client | 16/180 [ 9%] | 5 |
Blocking Sid (Inst) | % Activity | Event Caused | % Event | User | Program | # Samples Active | XIDs |
---|---|---|---|---|---|---|---|
129, 1( 1) | 2.65 | log file sync | 2.65 | SYS | ORACLE.EXE (LGWR) | 12/180 [ 7%] | 0 |
Object ID | % Activity | Event | % Event | Object Name (Type) | Tablespace |
---|---|---|---|---|---|
81227 | 24.41 | db file sequential read | 21.76 | SOE.INVENTORIES (TABLE) | SOE |
81227 | 24.41176470588235294117647058823529411765 | db file parallel read | 2.65 | SOE.INVENTORIES (TABLE) | SOE |
81223 | 13.53 | db file sequential read | 13.53 | SOE.CUSTOMERS (TABLE) | SOE |
81234 | 10.59 | db file sequential read | 10.59 | SOE.CUSTOMERS_PK (INDEX) | SOE |
81237 | 8.53 | db file sequential read | 8.53 | SOE.ORDER_PK (INDEX) | SOE |
81249 | 7.06 | db file sequential read | 6.76 | SOE.ORD_WAREHOUSE_IX (INDEX) | SOE |
File ID | % Activity | Event | % Event | File Name | Tablespace |
---|---|---|---|---|---|
6 | 84.71 | db file sequential read | 81.18 | C:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SOE.DBF | SOE |
6 | 84.70588235294117647058823529411764705882 | db file parallel read | 3.24 | C:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SOE.DBF | SOE |
Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
---|---|---|---|---|
16:30:00 (5.0 min) | 1 | control file sequential read | 1 | 0.29 |
16:35:00 (5.0 min) | 30 | db file sequential read | 22 | 6.47 |
16:35:00 (5.0 min) | 30 | db file parallel read | 4 | 1.18 |
16:35:00 (5.0 min) | 30 | control file sequential read | 2 | 0.59 |
16:40:00 (5.0 min) | 89 | db file sequential read | 68 | 20.00 |
16:40:00 (5.0 min) | 89 | control file sequential read | 7 | 2.06 |
16:40:00 (5.0 min) | 89 | log file sync | 4 | 1.18 |
16:45:00 (5.0 min) | 76 | db file sequential read | 63 | 18.53 |
16:45:00 (5.0 min) | 76 | db file parallel read | 4 | 1.18 |
16:45:00 (5.0 min) | 76 | log file parallel write | 3 | 0.88 |
16:50:00 (5.0 min) | 75 | db file sequential read | 62 | 18.24 |
16:50:00 (5.0 min) | 75 | log file parallel write | 3 | 0.88 |
16:50:00 (5.0 min) | 75 | log file sync | 3 | 0.88 |
16:55:00 (5.0 min) | 69 | db file sequential read | 61 | 17.94 |
16:55:00 (5.0 min) | 69 | log file parallel write | 3 | 0.88 |
16:55:00 (5.0 min) | 69 | CPU + Wait for CPU | 2 | 0.59 |