Using the report name ashrpt_1_1205_1045.html Summary of All User Input ------------------------- Format : HTML DB Id : 2699934982 Inst num : 1 Begin time : 05-Dec-16 10:30:00 End time : 05-Dec-16 10:45:00 Slot width : Default Report targets : 0 Report name : ashrpt_1_1205_1045.html
DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
---|---|---|---|---|---|---|
APPDBC | 2699934982 | appdbc1 | 1 | 10.2.0.4.0 | YES | erpdb-m9k-d00 |
CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
---|---|---|---|---|
32 | 36,864M (100%) | 22,960M (62.3%) | 13,792M (37.4%) | 50.0M (0.1%) |
Sample Time | Data Source | |
---|---|---|
Analysis Begin Time: | 05-Dec-16 10:30:00 | V$ACTIVE_SESSION_HISTORY |
Analysis End Time: | 05-Dec-16 10:45:00 | V$ACTIVE_SESSION_HISTORY |
Elapsed Time: | 15.0 (mins) | |
Sample Count: | 3,799 | |
Average Active Sessions: | 4.22 | |
Avg. Active Session per CPU: | 0.13 | |
Report Target: | None specified |
Event | Event Class | % Activity | Avg Active Sessions |
---|---|---|---|
CPU + Wait for CPU | CPU | 96.26 | 4.06 |
Back to Top Events
Back to Top
Event | Event Class | % Activity | Avg Active Sessions |
---|---|---|---|
CPU + Wait for CPU | CPU | 1.24 | 0.05 |
Back to Top Events
Back to Top
No data exists for this section of the report.
Back to Top Events
Back to Top
Service | Module | % Activity | Action | % Action |
---|---|---|---|---|
SYS$USERS | Data Pump Master | 94.45 | SYS_EXPORT_TABLE_01 | 23.61 |
SYS_EXPORT_TABLE_02 | 23.61 | |||
SYS_EXPORT_TABLE_04 | 23.61 | |||
SYS$BACKGROUND | UNNAMED | 2.42 | UNNAMED | 2.42 |
SYS$USERS | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | 1.18 | UNNAMED | 1.18 |
Back to Load Profile
Back to Top
No data exists for this section of the report.
Back to Load Profile
Back to Top
SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
---|---|---|---|
SELECT | 16 | 2.53 | 0.11 |
Back to Load Profile
Back to Top
SQL ID | Planhash | % Activity | Event | % Event | SQL Text |
---|---|---|---|---|---|
0yt1b8mbz63nk | 684126672 | 1.11 | CPU + Wait for CPU | 0.37 | SELECT e.owner, e.segment_typ... |
No data exists for this section of the report.
PLSQL Entry Subprogram | % Activity | PLSQL Current Subprogram | % Current |
---|---|---|---|
SYS.KUPM$MCP.MAIN | 94.45 | SYS.KUPF$FILE_INT.CREATE_DUMP_FILE | 94.45 |
Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
---|---|---|---|---|---|---|---|
2576,53607 | 23.61 | CPU + Wait for CPU | 23.61 | SYS | oracle@erpdb-m9k-d00 (DM02) | 897/900 [100%] | 0 |
2649,29762 | 23.61 | CPU + Wait for CPU | 23.61 | SYS | oracle@erpdb-m9k-d00 (DM03) | 897/900 [100%] | 0 |
2660, 1889 | 23.61 | CPU + Wait for CPU | 23.61 | SYS | oracle@erpdb-m9k-d00 (DM01) | 897/900 [100%] | 0 |
2687,19952 | 23.61 | CPU + Wait for CPU | 23.61 | SYS | oracle@erpdb-m9k-d00 (DM00) | 897/900 [100%] | 0 |
Back to Top Sessions
Back to Top
No data exists for this section of the report.
Back to Top Sessions
Back to Top
No data exists for this section of the report.
Back to Top Sessions
Back to Top
No data exists for this section of the report.
Back to Top Objects/Files/Latches
Back to Top
No data exists for this section of the report.
Back to Top Objects/Files/Latches
Back to Top
No data exists for this section of the report.
Back to Top Objects/Files/Latches
Back to Top
Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
---|---|---|---|---|
10:30:00 (2.0 min) | 553 | CPU + Wait for CPU | 525 | 13.82 |
gc cr disk read | 7 | 0.18 | ||
gcs log flush sync | 6 | 0.16 | ||
10:32:00 (2.0 min) | 497 | CPU + Wait for CPU | 487 | 12.82 |
db file sequential read | 5 | 0.13 | ||
gc cr disk read | 2 | 0.05 | ||
10:34:00 (2.0 min) | 497 | CPU + Wait for CPU | 482 | 12.69 |
db file sequential read | 7 | 0.18 | ||
gc cr disk read | 6 | 0.16 | ||
10:36:00 (2.0 min) | 498 | CPU + Wait for CPU | 494 | 13.00 |
reliable message | 4 | 0.11 | ||
10:38:00 (2.0 min) | 498 | CPU + Wait for CPU | 493 | 12.98 |
PX Deq: reap credit | 2 | 0.05 | ||
reliable message | 2 | 0.05 | ||
10:40:00 (2.0 min) | 499 | CPU + Wait for CPU | 484 | 12.74 |
db file sequential read | 7 | 0.18 | ||
reliable message | 3 | 0.08 | ||
10:42:00 (2.0 min) | 510 | CPU + Wait for CPU | 499 | 13.14 |
reliable message | 9 | 0.24 | ||
control file parallel write | 1 | 0.03 | ||
10:44:00 (60 secs) | 247 | CPU + Wait for CPU | 240 | 6.32 |
gc cr disk read | 3 | 0.08 | ||
PX Deq: reap credit | 1 | 0.03 |
End of Report Report written to ashrpt_1_1205_1045.html Prod:user=sys,db=appdbc SQL>