Database Reference
In-Depth Information
The following is a small excerpt from the report generated by the preceding execution (have a look at the
ashrpt_1_0212_2217.txt
file for the full report):
General information about the report:
•
Analysis Begin Time: 12-Feb-14 22:12:30
Analysis End Time: 12-Feb-14 22:17:30
Elapsed Time: 5.0 (mins)
Begin Data Source: V$ACTIVE_SESSION_HISTORY
End Data Source: V$ACTIVE_SESSION_HISTORY
Sample Count: 4,583
Average Active Sessions: 15.28
Avg. Active Session per CPU: 3.82
Report Target: None specified
•
The top wait events:
Avg Active
Event Event Class % Event Sessions
----------------------- ------------- ------- ----------
db file sequential read User I/O 65.94 10.07
log file sync Commit 14.42 2.20
CPU + Wait for CPU CPU 5.59 0.85
write complete waits Configuration 1.07 0.16
•
The activity broken up by engine:
Avg Active
Phase of Execution % Activity Sessions
------------------------------ ---------- ----------
SQL Execution 72.31 11.05
PLSQL Execution 1.46 0.22
•
The top SQL statements with top wait events (here only the first two are shown, the report
contains the top 5):
Sampled #
SQL ID Planhash of Executions % Activity
----------------------- -------------------- -------------------- --------------
Event % Event Top Row Source % RwSrc
------------------------------ ------- --------------------------------- -------
c13sma6rkr27c 569677903 1005 21.99
db file sequential read 21.32 TABLE ACCESS - BY INDEX ROWID 15.64
SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIG
HT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, C
ATALOG_URL, QUANTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.CATEGORY_
ID = :B3 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID AND INVENTORIES.WAREHO
0yas01u2p9ch4 N/A 382 8.34
db file sequential read 7.92 ** Row Source Not Available ** 7.92
INSERT INTO ORDER_ITEMS(ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY
