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 NameDB IdInstanceInst numReleaseRACHost
APPDBC2699934982appdbc1110.2.0.4.0YESerpdb-m9k-d00

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
3236,864M (100%)22,960M (62.3%)13,792M (37.4%)50.0M (0.1%)

Sample TimeData Source
Analysis Begin Time:05-Dec-16 10:30:00V$ACTIVE_SESSION_HISTORY
Analysis End Time:05-Dec-16 10:45:00V$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

EventEvent Class% ActivityAvg Active Sessions
CPU + Wait for CPU CPU 96.26 4.06

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg 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

ServiceModule% ActivityAction% 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

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
SELECT 16 2.53 0.11

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL Statements

SQL IDPlanhash% ActivityEvent% EventSQL 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 IdSQL 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

PLSQL Entry Subprogram% ActivityPLSQL 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

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
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

Slot Time (Duration)Slot CountEventEvent 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>