Oracle Technology Network
Articles
Articles
ASH Report For O102EE1/o102ee1
| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|---|---|---|---|---|---|
| O102EE1 | 2384218455 | o102ee1 | 1 | 10.2.0.3.0 | NO | hpap0601 |
| CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
|---|---|---|---|---|
| 4 | 256M (100%) | 92M (35.9%) | 172M (67.2%) | 5.1M (2.0%) |
| Sample Time | Data Source | |
|---|---|---|
| Analysis Begin Time: | 02-4譛・-07 20:02:34 | V$ACTIVE_SESSION_HISTORY |
| Analysis End Time: | 02-4譛・-07 20:07:34 | V$ACTIVE_SESSION_HISTORY |
| Elapsed Time: | 5.0 (mins) | |
| Sample Count: | 1,291 | |
| Average Active Sessions: | 4.30 | |
| Avg. Active Session per CPU: | 1.08 | |
| Report Target: | None specified |
ASH Report
- Top Events
- Load Profile
- Top SQL
- Top PL/SQL
- Top Sessions
- Top Objects/Files/Latches
- Activity Over Time
Back to Top
Top Events
Back to TopTop User Events
| Event | Event Class | % Activity | Avg Active Sessions |
|---|---|---|---|
| CPU + Wait for CPU | CPU | 80.40 | 3.46 |
| read by other session | User I/O | 13.25 | 0.57 |
| db file scattered read | User I/O | 2.32 | 0.10 |
| latch free | Other | 1.08 | 0.05 |
| db file sequential read | User I/O | 1.01 | 0.04 |
Back to Top Events
Back to Top
Top Background Events
No data exists for this section of the report.
Back to Top Events
Back to Top
Top Event P1/P2/P3 Values
| Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
|---|---|---|---|---|---|---|
| read by other session | 13.25 | "4","31","1" | 0.23 | file# | block# | class# |
| db file scattered read | 2.32 | "4","286","4" | 0.08 | file# | block# | blocks |
| latch free | 1.08 | "786844308","127","0" | 0.85 | address | number | tries |
| db file sequential read | 1.01 | "4","336","1" | 0.08 | file# | block# | blocks |
Back to Top Events
Back to Top
Load Profile
Back to TopTop Service/Module
| Service | Module | % Activity | Action | % Action |
|---|---|---|---|---|
| SYS$USERS | SQL*Plus | 98.06 | UNNAMED | 98.06 |
Back to Load Profile
Back to Top
Top Client IDs
No data exists for this section of the report.
Back to Load Profile
Back to Top
Top SQL Command Types
- 'Distinct SQLIDs' is the count of the distinct number of SQLIDs with the given SQL Command Type found over all the ASH samples in the analysis period
| SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
|---|---|---|---|
| SELECT | 1,167 | 96.90 | 4.17 |
Back to Load Profile
Back to Top
Top SQL
Back to TopTop SQL Statements
| SQL ID | Planhash | % Activity | Event | % Event | SQL Text |
|---|---|---|---|---|---|
| 8zt0p6avg76yz | 1396384608 | 6.20 | CPU + Wait for CPU | 6.12 | SELECT COUNT(ename) FROM emp3 ... |
Top SQL using literals
| Plan Hash | % Activity | # of Sampled SQL Versions | Example SQL 1 | Example SQL TEXT 1 | Example SQL 2 | Example SQL TEXT 2 |
|---|---|---|---|---|---|---|
| 2226897347 | 90.24 | 1165 | 0013pqzx8kbfg | select emp1no, ename from emp1... | gzz4872a6424p | select emp1no, ename from emp1... |
Complete List of SQL Text
Top PL/SQL Procedures
No data exists for this section of the report.
Top Sessions
Back to TopTop Sessions
- '# Samples Active' shows the number of ASH samples in which the session was found waiting for that particular event. The percentage shown in this column is calculated with respect to wall clock time and not total database activity.
- 'XIDs' shows the number of distinct transaction IDs sampled in ASH when the session was waiting for that particular event
- For sessions running Parallel Queries, this section will NOT aggregate the PQ slave activity into the session issuing the PQ. Refer to the 'Top Sessions running PQs' section for such statistics.
| Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
|---|---|---|---|---|---|---|---|
| 474,30118 | 22.93 | CPU + Wait for CPU | 17.20 | SCOTT | sqlplus@hpap0601 (TNS V1-V3) | 222/300 [ 74%] | 0 |
| read by other session | 4.26 | 55/300 [ 18%] | 0 | ||||
| 468, 3826 | 22.70 | CPU + Wait for CPU | 18.90 | SCOTT | sqlplus@hpap0601 (TNS V1-V3) | 244/300 [ 81%] | 0 |
| read by other session | 2.71 | 35/300 [ 12%] | 0 | ||||
| 480,48100 | 22.70 | CPU + Wait for CPU | 20.06 | SCOTT | sqlplus@hpap0601 (TNS V1-V3) | 259/300 [ 86%] | 0 |
| read by other session | 1.78 | 23/300 [ 8%] | 0 | ||||
| 461,65104 | 22.15 | CPU + Wait for CPU | 15.80 | SCOTT | sqlplus@hpap0601 (TNS V1-V3) | 204/300 [ 68%] | 0 |
| read by other session | 4.49 | 58/300 [ 19%] | 0 | ||||
| db file scattered read | 1.16 | 15/300 [ 5%] | 0 | ||||
| 467,33263 | 7.59 | CPU + Wait for CPU | 7.51 | SCOTT | sqlplus@hpap0601 (TNS V1-V3) | 97/300 [ 32%] | 0 |
Back to Top Sessions
Back to Top
Top Blocking Sessions
No data exists for this section of the report.
Back to Top Sessions
Back to Top
Top Sessions running PQs
No data exists for this section of the report.
Back to Top Sessions
Back to Top
Top Objects/Files/Latches
Back to TopTop DB Objects
- With respect to Application, Cluster, User I/O and buffer busy waits only.
| Object ID | % Activity | Event | % Event | Object Name (Type) | Tablespace |
|---|---|---|---|---|---|
| 15339 | 16.58 | read by other session | 13.25 | SCOTT.EMP1 (TABLE) | USERS |
| db file scattered read | 2.32 | ||||
| db file sequential read | 1.01 |
Back to Top Objects/Files/Latches
Back to Top
Top DB Files
- With respect to Cluster and User I/O events only.
| File ID | % Activity | Event | % Event | File Name | Tablespace |
|---|---|---|---|---|---|
| 4 | 16.58 | read by other session | 13.25 | /opt/app/oracle/oradata/o102ee1/users01.dbf | USERS |
| db file scattered read | 2.32 | ||||
| db file sequential read | 1.01 |
Back to Top Objects/Files/Latches
Back to Top
Top Latches
| Latch | % Latch | Blocking Sid | % Activity | Max Sampled Wait secs | # Waits Sampled | # Sampled Wts < 10ms | # Sampled Wts 10ms - 100ms | # Sampled Wts 100ms - 1s | # Sampled Wts > 1s |
|---|---|---|---|---|---|---|---|---|---|
| latch: simulator lru latch | 1.08 | Held Shared | 1.08 | 0.97 | 14 | 0 | 8 | 6 | 0 |
Back to Top Objects/Files/Latches
Back to Top
Activity Over Time
- Analysis period is divided into smaller time slots
- Top 3 events are reported in each of those slots
- 'Slot Count' shows the number of ASH samples in that slot
- 'Event Count' shows the number of ASH samples waiting for that event in that slot
- '% Event' is 'Event Count' over all ASH samples in the analysis period
| Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
|---|---|---|---|---|
| 20:02:34 (26 secs) | 107 | CPU + Wait for CPU | 85 | 6.58 |
| read by other session | 11 | 0.85 | ||
| db file scattered read | 5 | 0.39 | ||
| 20:03:00 (1.0 min) | 237 | CPU + Wait for CPU | 178 | 13.79 |
| read by other session | 51 | 3.95 | ||
| db file scattered read | 5 | 0.39 | ||
| 20:04:00 (1.0 min) | 249 | CPU + Wait for CPU | 209 | 16.19 |
| read by other session | 30 | 2.32 | ||
| db file scattered read | 4 | 0.31 | ||
| 20:05:00 (1.0 min) | 304 | CPU + Wait for CPU | 283 | 21.92 |
| latch free | 9 | 0.70 | ||
| latch: cache buffers chains | 6 | 0.46 | ||
| 20:06:00 (1.0 min) | 257 | CPU + Wait for CPU | 187 | 14.48 |
| read by other session | 50 | 3.87 | ||
| db file scattered read | 10 | 0.77 | ||
| 20:07:00 (34 secs) | 137 | CPU + Wait for CPU | 99 | 7.67 |
| read by other session | 27 | 2.09 | ||
| db file scattered read | 6 | 0.46 |
End of Report
Printer View