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
ASH Report - From 05-Dec-16 10:30:00 To 05-Dec-16 10:45:00
ASH Report For APPDBC/appdbc1
| 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 | |
ASH Report
Back to Top
Top Events
Back to Top
Top User Events
| Event | Event Class | % Activity | Avg Active Sessions |
|---|
| CPU + Wait for CPU | CPU | 96.26 | 4.06 |
Back to Top Events
Back to Top
Top Background Events
| Event | Event Class | % Activity | Avg Active Sessions |
|---|
| CPU + Wait for CPU | CPU | 1.24 | 0.05 |
Back to Top Events
Back to Top
Top Event P1/P2/P3 Values
No data exists for this section of the report.
Back to Top Events
Back to Top
Load Profile
Back to Top
Top Service/Module
| 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
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 | 16 | 2.53 | 0.11 |
Back to Load Profile
Back to Top
Top SQL
Back to Top
Top SQL Statements
| SQL ID | Planhash | % Activity | Event | % Event | SQL Text |
|---|
| 0yt1b8mbz63nk | 684126672 | 1.11 | CPU + Wait for CPU | 0.37 |
SELECT e.owner, e.segment_typ... |
Back to Top SQL
Back to Top
Top SQL using literals
No data exists for this section of the report.
Back to Top SQL
Back to Top
Complete List of SQL Text
| SQL Id | SQL Text |
|---|
| 0yt1b8mbz63nk |
SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file#
, greatest(e.block_id, c.block#) corr_start_block#
, least(e.block_id+e.blocks-1, c.block#+c.blocks-1) corr_end_block#
, least(e.block_id+e.blocks-1, c.block#+c.blocks-1)
- greatest(e.block_id, c.block#) + 1 blocks_corrupted
, corruption_type description
FROM dba_extents e, v$database_block_corruption c
WHERE e.file_id = c.file#
AND e.block_id <= c.block# + c.blocks - 1
AND e.block_id + e.blocks - 1 >= c.block#
UNION
SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file#
, header_block corr_start_block#
, header_block corr_end_block#
, 1 blocks_corrupted
, corruption_type||' Segment Header' description
FROM dba_segments s, v$database_block_corruption c
WHERE s.header_file = c.file#
AND s.header_block between c.block# and c.block# + c.blocks - 1
UNION
SELECT null owner, null segment_type, null segment_name, null partition_name, c.file#
, greatest(f.block_id, c.block#) corr_start_block#
, least(f.block_id+f.blocks-1, c.block#+c.blocks-1) corr_end_block#
, least(f.block_id+f.blocks-1, c.block#+c.blocks-1)
- greatest(f.block_id, c.block#) + 1 blocks_corrupted
, 'Free Block' description
FROM dba_free_space f, v$database_block_corruption c
WHERE f.file_id = c.file#
AND f.block_id <= c.block# + c.blocks - 1
AND f.block_id + f.blocks - 1 >= c.block#
order by file#, corr_start_block# |
Back to Top SQL
Back to Top
Top PL/SQL Procedures
- 'PL/SQL entry subprogram' represents the application's top-level
entry-point(procedure, function, trigger, package initialization
or RPC call) into PL/SQL.
- 'PL/SQL current subprogram' is the pl/sql subprogram being executed
at the point of sampling . If the value is 'SQL', it represents
the percentage of time spent executing SQL for the particular
plsql entry subprogram
| PLSQL Entry Subprogram | % Activity | PLSQL Current Subprogram | % Current |
|---|
| SYS.KUPM$MCP.MAIN | 94.45 |
SYS.KUPF$FILE_INT.CREATE_DUMP_FILE | 94.45 |
Back to Top
Top Sessions
Back to Top
Top 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 |
|---|
| 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
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 Top
Top DB Objects
No data exists for this section of the report.
Back to Top Objects/Files/Latches
Back to Top
Top DB Files
No data exists for this section of the report.
Back to Top Objects/Files/Latches
Back to Top
Top Latches
No data exists for this section of the report.
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 |
|---|
| 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 |
Back to Top
End of Report
Report written to ashrpt_1_1205_1045.html
Prod:user=sys,db=appdbc SQL>