ASH Report For ORCL/orcl1

DB NameDB IdInstanceInst numReleaseRACHost
ORCL1385339541orcl1111.2.0.1.0YESorac1.com

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
2800M (100%)48M (6.0%)300M (37.5%)4.0M (0.5%)

Sample TimeData Source
Analysis Begin Time:29-8月 -15 10:02:05V$ACTIVE_SESSION_HISTORY
Analysis End Time:29-8月 -15 10:17:05V$ACTIVE_SESSION_HISTORY
Elapsed Time: 15.0 (mins)  
Sample Count: 106 
Average Active Sessions: 0.12 
Avg. Active Session per CPU: 0.06 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% EventAvg Active Sessions
db file sequential readUser I/O24.530.03
CPU + Wait for CPUCPU16.980.02
library cache pinConcurrency6.600.01
log file syncCommit2.830.00
library cache lockConcurrency1.890.00

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
CPU + Wait for CPUCPU15.090.02
Streams AQ: qmn coordinator waiting for slave to startOther4.720.01
control file parallel writeSystem I/O3.770.00
control file sequential readSystem I/O3.770.00
db file sequential readUser I/O3.770.00

Back to Top Events
Back to Top

Top Cluster Events

No data exists for this section of the report.

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
db file sequential read28.30"1","1905","1"0.94 file#block#blocks
library cache pin6.60"2313669264","2180310608","283158604087298"2.83 handle addresspin address100*mode+namespace
  "2313669264","2315181624","283158604087298"1.89    
control file parallel write3.77"2","3","2"2.83 filesblock#requests
control file sequential read3.77"0","4","1"0.94 file#block#blocks
log file parallel write3.77"2","4","2"0.94 filesblocksrequests

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
SYS$BACKGROUNDUNNAMED31.13UNNAMED31.13
orclOEM.SystemPool12.26XMLLoader012.26
SYS$USERSemagent_SQL_rac_database12.26ha_backup2.83
   aq_msgs_per_queue1.89
   textIndexStats1.89
orclJDBC Thin Client8.49UNNAMED8.49
 OEM.BoundedPool6.60UNNAMED6.60

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
SELECT2324.530.03
PL/SQL EXECUTE710.380.01
UPDATE33.770.00
INSERT32.830.00
CREATE TABLE21.890.00

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
SQL Execution41.510.05
Parse25.470.03
Hard Parse23.580.03
PLSQL Compilation4.720.01

Back to Load Profile
Back to Top

Top Remote Instances

No data exists for this section of the report.

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL with Top Events

SQL IDPlanhashSampled # of Executions% ActivityEvent% EventTop Row Source% RwSrcSQL Text
fdyupq2cqju26 23.77 db file sequential read2.83** Row Source Not Available **2.83 BEGIN :1 := MGMT_BLACKOUT_ENGI...
1ufgszt35yvmu414865286602.83 CPU + Wait for CPU1.89** Row Source Not Available **1.89 /* OracleOEM */ SELECT end_tim...
3b2ffwwc3spz4139008310311.89 CPU + Wait for CPU1.89FILTER1.89 SELECT TO_CHAR(MAX(CAST(l.exec...
8b5vzx9k2t7s9 01.89 db file sequential read1.89** Row Source Not Available **1.89 /* OracleOEM */ DECLARE TYPE d...
8vwv6hx92ymmm231501825421.89 db file sequential read0.94UPDATE0.94 UPDATE MGMT_CURRENT_METRICS SE...

Back to Top SQL
Back to Top

Top SQL with Top Row Sources

SQL IDPlanHashSampled # of Executions% ActivityRow Source% RwSrcTop Event% EventSQL Text
fdyupq2cqju26 23.77 ** Row Source Not Available **3.77db file sequential read2.83 BEGIN :1 := MGMT_BLACKOUT_ENGI...
1ufgszt35yvmu414865286602.83 ** Row Source Not Available **2.83CPU + Wait for CPU1.89 /* OracleOEM */ SELECT end_tim...
3b2ffwwc3spz4139008310311.89 FILTER1.89CPU + Wait for CPU1.89 SELECT TO_CHAR(MAX(CAST(l.exec...
8b5vzx9k2t7s9 01.89 ** Row Source Not Available **1.89db file sequential read1.89 /* OracleOEM */ DECLARE TYPE d...
8vwv6hx92ymmm231501825421.89 UPDATE0.94db file sequential read0.94 UPDATE MGMT_CURRENT_METRICS SE...

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

Top Parsing Module/Action

ModuleAction% ActivityEvent% Event
JDBC Thin Client 2.83CPU + Wait for CPU1.89
OEM.BoundedPool 2.83db file sequential read1.89
emagent_SQL_oracle_databasesql_response_collect2.83db file sequential read1.89
emagent_SQL_rac_databaseha_backup2.83CPU + Wait for CPU1.89
OEM.SystemPoolXMLLoader01.89db file sequential read1.89

Back to Top SQL
Back to Top

Complete List of SQL Text

SQL IdSQL Text
1ufgszt35yvmu/* OracleOEM */ SELECT end_time, status, session_key, session_recid, session_stamp, command_id, start_time, time_taken_display, input_type, output_device_type, input_bytes_display, output_bytes_display, output_bytes_per_sec_display FROM (SELECT end_time, status, session_key, session_recid, session_stamp, command_id, start_time, time_taken_display, input_type, output_device_type, input_bytes_display, output_bytes_display, output_bytes_per_sec_display FROM v$rman_backup_job_details ORDER BY end_time DESC) WHERE rownum = 1
3b2ffwwc3spz4SELECT TO_CHAR(MAX(CAST(l.execution_end AS TIMESTAMP)), 'DD-MON-YYYY HH24:MI:SSxFF'), TO_CHAR(CAST(sysdate AS TIMESTAMP), 'DD-MON-YYYY HH24:MI:SSxFF') from dba_advisor_tasks l where l.advisor_name='Segment Advisor' and TO_CHAR(CAST(l.execution_end AS TIMESTAMP), 'DD-MON-YYYY HH24:MI:SSxFF') > '29-8月 -2015 09:11:06.000000'
8b5vzx9k2t7s9 /* OracleOEM */ DECLARE TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; x clob := null; pos1 INTEGER := 1; pos2 INTEGER := 4000; statData clob := null; sizeData clob := null; objectsData clob := null; tmp VARCHAR2(4000); partitionName VARCHAR2(4000); jobName VARCHAR2(500); idx_name VARCHAR2(4000); part_name VARCHAR2(4000); tmp_str VARCHAR2(4000); guid RAW(16); idx_guid RAW(16); cursor idx_cur IS select owner, job_name, comments from dba_scheduler_jobs where job_name like 'EM_IDX_STAT_JOB%' and upper(owner) = 'DBSNMP'; idx_rec idx_cur%ROWTYPE; BEGIN OPEN idx_cur; FETCH idx_cur into idx_rec; guid := :1; IF idx_cur%FOUND THEN dbms_lob.createtemporary(statData, false); dbms_lob.createtemporary(sizeData, false); dbms_lob.createtemporary(objectsData, false); idx_name := substr(idx_rec.comments, 1, instr(idx_rec.comments, '|')-1); tmp_str := substr(idx_rec.comments, instr(idx_rec.comments, '|')+1); part_name := substr(tmp_str, 1, instr(tmp_str, '|')-1); idx_guid := substr(tmp_str, instr(tmp_str, '|')+1); if guid = idx_guid THEN if part_name != 'null' then partitionName := part_name; end if; ctx_report.index_stats(idx_name, x, partitionName, true, 5); pos1 := dbms_lob.instr(x, 'indexed documents:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'allocated docids:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, '$I rows:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'unique tokens:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average $I rows per token:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average size per token:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average frequency per token:'); IF pos1 > 0 T HEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'token type:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'unique tokens:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'total rows:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average rows:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'total size:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average size:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average frequency:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'total size of $I data:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'estimated row fragmentation:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'garbage docids:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'estimated garbage size:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, ch r(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); dbms_lob.writeappend(statData, pos2-pos1, tmp); END IF; /*dbms_lob.freetemporary(x); */ /* Gather Index Objects Data */ ctx_report.describe_index(idx_name, x); pos1 := 1; pos1 := dbms_lob.instr(x, 'datastore:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'filter:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'section group:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'lexer:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'wordlist:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'stemmer:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'fuzzy_match:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'stoplist:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'storage:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; /* Gather Size Data */ ctx_report.index_size(idx_name, x, partitionName); pos1 := 1; LOOP pos1 := dbms_lob.instr(x, 'INDEX (', pos1); EXIT WHEN pos1 < 1; pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'TABLE NAME:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'TABLESPACE NAME:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'BLOCKS ALLOCATED:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'BLOCKS USED:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'BYTES ALLOCATED:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'BYTES USED:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); END LOOP; OPEN data_cursor FOR SELECT idx_name , partitionName, dbms_lob.substr(statData), dbms_lob.substr(sizeData), dbms_lob.substr(objectsData) FROM DUAL; :2 := data_cursor; jobName := idx_rec.owner || '.' || idx_rec.job_name; dbms_scheduler.drop_job(job_name => jobName, force => true); dbms_lob.freetemporary(sizeData); dbms_lob.freetemporary(statData); dbms_lob.freetemporary(objectsData); dbms_lob.freetemporary(x); end if; ELSE OPEN data_cursor FOR select 'dummy', 'dummy', 'dummy', 'dummy', 'dummy' from dual; :2 := data_cursor; END IF; END;
8vwv6hx92ymmmUPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
fdyupq2cqju26BEGIN :1 := MGMT_BLACKOUT_ENGINE.get_blackout_windows(:2, :3); END;

Back to Top SQL
Back to Top

Top PL/SQL Procedures

PLSQL Entry Subprogram% ActivityPLSQL Current Subprogram% Current
SYSMAN.EM_VIOLATION_CHECKS3.77 SQL3.77
DBSNMP.MGMT_RESPONSE.GET_METRIC_CURS1.89 SQL1.89
DBSNMP.BSLN_INTERNAL.MAINTAIN_THRESHOLDS1.89 SQL1.89
SYSMAN.EMD_LOADER.UPDATE_CURRENT_METRICS1.89 SQL1.89
SYSMAN.MGMT_BLACKOUT_ENGINE.GET_BLACKOUT_WINDOWS1.89 SQL1.89


Back to Top

Top Java Workload

No data exists for this section of the report.


Back to Top

Top Call Types

Call TypeCount% ActivityAvg Active Sessions
V8 Bundled Exec4744.340.05
FETCH43.770.00
LOGOFF43.770.00
Dequeue pre 8.143.770.00
AQ batch enqueue/dequeue43.770.00


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
41, 814.15CPU + Wait for CPU7.55 DBSNMPemagent@orac1.com (TNS V1-V3)8/900 [ 1%]1
  db file sequential read5.66   6/900 [ 1%]0
35, 1312.26db file sequential read10.38 SYSMANOMS11/900 [ 1%]4
12, 18.49reliable message2.83 SYSoracle@orac1.com (MMON)3/900 [ 0%]0
  CPU + Wait for CPU1.89   2/900 [ 0%]0
  control file sequential read1.89   2/900 [ 0%]0
44, 1176.60db file sequential read5.66 SYSMANOMS6/900 [ 1%]1
5, 14.72CPU + Wait for CPU4.72 SYSoracle@orac1.com (DIA0)5/900 [ 1%]0

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid (Inst)% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
9, 1( 1)2.83log file sync2.83 SYSoracle@orac1.com (LGWR)4/900 [ 0%]0

Back to Top Sessions
Back to Top

Top Sessions running PQs

Sid,Srl# (Inst)% ActivitySQL IDEvent% EventUserProgramSQL Text
145,32231(1)2.831mjhyad05m8pfCPU + Wait for CPU0.94 DBSNMPperl@orac1.com (TNS V1-V3) SELECT value FROM gv$osstat W...
41, 8(1)1.890v6s91manuhz8CPU + Wait for CPU0.94 UserID:  /* OracleOEM */ SELECT blockin...

Back to Top Sessions
Back to Top

Top Objects/Files/Latches

Back to Top

Top DB Objects

Object ID% ActivityEvent% EventObject Name (Type)Tablespace
5283.77db file sequential read3.77 SYS.KOTTD$ (TABLE)SYSTEM
58462.83db file sequential read2.83 SYS.SCHEDULER$_LOBJ_UK (INDEX)SYSTEM
671332.83db file sequential read2.83 SYSMAN.MGMT_METRICS_RAW_PK (INDEX)SYSAUX
7021.89db file sequential read1.89 SYS.STREAMS$_APPLY_PROCESS (TABLE)SYSTEM

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
113.21db file sequential read13.21 +DATA/orcl/datafile/system.256.857558707SYSTEM
213.21db file sequential read12.26 +DATA/orcl/datafile/sysaux.257.857558709SYSAUX

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:02:05 (1.9 min)41db file sequential read1716.04
  CPU + Wait for CPU1110.38
  log file parallel write43.77
10:04:00 (2.0 min)12CPU + Wait for CPU65.66
  db file sequential read32.83
  Disk file operations I/O10.94
10:06:00 (2.0 min)14db file sequential read65.66
  CPU + Wait for CPU32.83
  control file sequential read21.89
10:08:00 (2.0 min)4CPU + Wait for CPU10.94
  db file sequential read10.94
  gc cr grant 2-way10.94
10:10:00 (2.0 min)16CPU + Wait for CPU65.66
  library cache pin54.72
  db file sequential read21.89
10:12:00 (2.0 min)9Streams AQ: qmn coordinator waiting for slave to start54.72
  CPU + Wait for CPU21.89
  KJC: Wait for msg sends to complete10.94
10:14:00 (2.0 min)9CPU + Wait for CPU54.72
  PX Deq: Slave Session Stats10.94
  db file sequential read10.94
10:16:00 (1.1 min)1control file parallel write10.94


Back to Top

End of Report