WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
WHUT	898190546	whut1	1	17-Mar-14 09:03	11.2.0.3.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
oda1	Linux x86 64-bit	24	12	2	94.60

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	14698	24-Mar-14 13:00:26	147	1.8
End Snap:	14699	24-Mar-14 13:10:18	137	1.9
Elapsed:		9.86 (mins)
DB Time:		16.25 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	35,968M	35,968M	Std Block Size:	8K
Shared Pool Size:	12,544M	12,544M	Log Buffer:	166,324K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.7	0.2	0.03	0.01
DB CPU(s):	0.1	0.0	0.00	0.00
Redo size:	18,531.3	1,760.6
Logical reads:	1,408.7	133.8
Block changes:	93.1	8.8
Physical reads:	10.7	1.0
Physical writes:	9.1	0.9
User calls:	169.0	16.1
Parses:	7.6	0.7
Hard parses:	3.3	0.3
W/A MB processed:	0.3	0.0
Logons:	0.2	0.0
Executes:	61.6	5.9
Rollbacks:	0.0	0.0
Transactions:	10.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.91	Redo NoWait %:	100.00
Buffer Hit %:	99.24	In-memory Sort %:	100.00
Library Hit %:	87.28	Soft Parse %:	56.17
Execute to Parse %:	87.73	Latch Hit %:	99.79
Parse CPU to Parse Elapsd %:	0.21	% Non-Parse CPU:	84.29

Shared Pool Statistics

	Begin	End
Memory Usage %:	86.56	86.63
% SQL with executions>1:	97.06	99.39
% Memory for SQL w/exec>1:	95.24	97.68

Top 5 Timed Foreground Events

Host CPU (CPUs: 24 Cores: 12 Sockets: 2)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1.21	1.80	0.5	0.7	1.4	98.8

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.3	26.7	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	96,866.8	96,866.8
SGA use (MB):	49,152.0	49,152.0
PGA use (MB):	715.0	917.4
% Host Mem used for SGA+PGA:	51.48	51.69

RAC Statistics

	Begin	End
Number of Instances:	1	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	0.48	0.05
Global Cache blocks served:	79.18	7.52
GCS/GES messages received:	140.21	13.32
GCS/GES messages sent:	2,619.35	248.86
DBWR Fusion writes:	1.91	0.18
Estd Interconnect traffic (KB)	1,176.24

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %:	99.21
Buffer access - remote cache %:	0.03
Buffer access - disk %:	0.76

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.3
Avg global cache current block receive time (ms):	0.1
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	0.1
Avg global cache cr block flush time (ms):	0.0
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.0
Avg global cache current block flush time (ms):	0.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	492.2
Avg message sent queue time on ksxp (ms):	58.4
Avg message received queue time (ms):	44.7
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.1
% of direct sent messages:	0.73
% of indirect sent messages:	99.26
% of flow controlled messages:	0.00

Cluster Interconnect

• if IP/Public/Source at End snap is different a '*' is displayed

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Buffer Pool Statistics
• Advisory Statistics
• Wait Statistics
• Undo Statistics
• Latch Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Memory Statistics
• Streams Statistics
• Resource Limit Statistics
• Shared Server Statistics
• init.ora Parameters

More RAC Statistics

• RAC Report Summary
• Global Messaging Statistics
• Global CR Served Stats
• Global CURRENT Served Stats
• Global Cache Transfer Stats
• Interconnect Stats
• Dynamic Remastering Statistics

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Wait Event Histogram Detail (64 msec to 2 sec)
• Wait Event Histogram Detail (4 sec to 2 min)
• Wait Event Histogram Detail (4 min to 1 hr)
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 974.7s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 48.7% of Total DB time 974.75 (s)
• Total FG Wait Time: 447.51 (s) DB CPU time: 27.44 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in seconds

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• SQL ordered by Cluster Wait Time
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 79.7% of Total DB Time (s): 975
• Captured PL/SQL account for 5.6% of Total DB Time (s): 975

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 64.5% of Total CPU Time (s): 27
• Captured PL/SQL account for 19.3% of Total CPU Time (s): 27

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 90.0% of Total User I/O Wait Time (s): 31
• Captured PL/SQL account for 2.1% of Total User I/O Wait Time (s): 31

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - Buffer Gets as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 833,268
• Captured SQL account for 80.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 6,332
• Captured SQL account for 93.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 5,319
• Captured SQL account for 38.4% of Total
• Total UnOptimized Read Requests: 5,319
• Captured SQL account for 38.4% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 36,435
• Captured SQL account for 36.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 4,470
• Captured SQL account for 26.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

• %Total - Cluster Time as a percentage of Total Cluster Wait Time
• %Clu - Cluster Time as a percentage of Elapsed Time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Only SQL with Cluster Wait Time > .005 seconds is reported
• Total Cluster Wait Time (s): 1
• Captured SQL account for 77.5% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
08bqjmf8490s2	SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
096gmfb7sq5aj	select rowid, msgid, subscriber#, name, address#, dequeue_time, transaction_id, dequeue_user, flags from "SYS"."AQ$_ALERT_QT_L"
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0raxdjdhzt95w	select account, sno, bankacc, identityid, cardbalance, ebagamt from account@dl_syntong where CardID=2860888294
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
11daatwqdz24k	SELECT accType.flag, accType.acctype, accInfo.account, TRIM(accType.name) AS acctypename, accInfo.accamt accamt FROM AccType@dl_syntong accType, AccInfo@dl_syntong accInfo WHERE accInfo.accType = accType.accType AND accInfo.account =204030
12rtwdjfcgcd3	select account, sno, bankacc, identityid, cardbalance, ebagamt from account@dl_syntong where CardID=1681911302
1782k2pn3asd2	select account, sno, bankacc, identityid, cardbalance, ebagamt from account@dl_syntong where CardID=2860712822
180ac4chq1msm	update cardreader set CurrentState = 0 where DoorControlID = :DoorControlID
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1pwtmwrudcddb	SELECT /*+NESTED_TABLE_GET_REFS+*/ "SCHOOL"."ACCOUNT".* FROM "SCHOOL"."ACCOUNT"
1r833j9qkj39f	select account, sno, bankacc, identityid, cardbalance, ebagamt from account@dl_syntong where CardID=2729662019
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
1ybdwd9vb592s	SELECT ID, DCCID, Descript, DoorControlID, WorkMode, PasswordMode, StartTime1, StopTime1, InOut1, WorkState1, ControlMode1, StartTime2, StopTime2, InOut2, WorkState2, ControlMode2, StartTime3, StopTime3, InOut3, WorkState3, ControlMode3, StartTime4, StopTime4, WorkState4, InOut4, ControlMode4, SexMode, PIDMode, DoorPassword, CardReaderState, WorkAroundID, CurrentState, LockType, WorkMode2, PasswordMode2, SexMode2, PIDMode2, WorkMode3, PasswordMode3, SexMode3, PIDMode3, WorkMode4, PasswordMode4, SexMode4, PIDMode4, CTN_Time, CTN_Cards FROM CARDREADER WHERE DoorcontrolID = :DoorControlID ORDER BY DCCID
20u3hr7x845zh	select account, sno, bankacc, identityid, cardbalance, ebagamt from account@dl_syntong where CardID=1320766662
24f3dvhg0x842	SELECT SYNNAM, SYNNAM2, SYNTAB, TABOWN, TABNODE, PUBLIC$, SYNOWN, SYNOWNID, TABOWNID, SYNOBJNO FROM SYS.EXU9PTS WHERE SYNOBJNO IN ( SELECT SYNOBJNO FROM SYS.EXU9TYPT WHERE TABOBJNO = :1 ) ORDER BY SYNTIME
2j0fw19fph49j	SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2xjrfr0zm5j20	select account, sno, bankacc, identityid, cardbalance, ebagamt from account@dl_syntong where CardID=2860936294
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3djzdn62r5gv4	SELECT /*+NESTED_TABLE_GET_REFS+*/ "SCHOOL"."HISTRJN".* FROM "SCHOOL"."HISTRJN"
3f751tsaf2j02	SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'
3mz197u2c5tru	INSERT INTO IDINFORMATION (NO, NAME, SEX, SNO, CLASS, PIDCODE, BORN, IDTYPE, IDNO, AREACODE, DEPTCODE, INDATE, NATIONCODE, PEOPLECODE, ZZMM, EXPDATE, ZIP, CHECKFLAG, OPENFLAG, WRITEFLAG, OPENACCDATE, LASTUPDATE, ACCOUNT, RIGHT, JG, TEL, EMAIL, ADDR, ENABLEID, TEMACCOUNT, TEMFLAG, TEMDATETIME, EXPCARDFLAG) VALUES('000000250274', '³Â¸Õ', '1', '10618', '2', '27', '19810630', '001', '420107198106300015', '001', '103125', '20140303', '156', '01', '13', '', '', '1', '0', '', '', TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS'), 0, '', '', '', '', '', '2', 0, '0', '', '')
4308cqrzmnd79	select nvl(spare3, 0), property, flags, nvl(spare5, 'NN0') from tab$ where obj# = :1
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4hty17xfznd4a	UPDATE CARDREADER SET CurrentState = :CurrentState WHERE DoorcontrolID = :DoorControlID AND DCCID =:DCCID
4qx1wbd3658n6	SELECT accType.flag, accType.acctype, accInfo.account, TRIM(accType.name) AS acctypename, accInfo.accamt accamt FROM AccType@dl_syntong accType, AccInfo@dl_syntong accInfo WHERE accInfo.accType = accType.accType AND accInfo.account =209458
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
60mwj5fxv4ur9	update tab$ set spare3 = :1, spare5 = :3 where obj# = :2
63t3ufgq37m0c	SELECT instance_number, instance_name, host_name FROM ( SELECT dbin.instance_number as instance_number, max(dbin.instance_name) as instance_name, max(dbin.host_name) as host_name, sum(case when s.snap_id in (:bid, :eid) then 1 else 0 end) as cnt_edge FROM WRM$_SNAPSHOT s , WRM$_DATABASE_INSTANCE dbin WHERE s.dbid = :dbid AND dbin.instance_number = s.instance_number AND s.snap_id >= :bid AND s.snap_id <= :eid AND dbin.dbid = s.dbid AND dbin.startup_time = s.startup_time GROUP BY dbin.instance_number ) WHERE cnt_edge < 2
69k5bhm12sz98	SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6va1uyf3b276j	SELECT DISTINCT "A1"."M_ROW$$" FROM "SCHOOL"."MLOG$_TRJN" "A1" WHERE "A1"."M_ROW$$"<>ALL (SELECT "A2".ROWID FROM "TRJN" "A2" WHERE "A2".ROWID="A1"."M_ROW$$") AND "A1"."SNAPTIME$$">:1 AND "A1"."DMLTYPE$$"<>'I'
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
6x2cz59yrxz3a	SELECT NAME, OBJID, OWNER, PROPERTY, PACKAGE, PKG_SCHEMA, NAMESPACE, TYPE#, CLASS FROM SYS.EXU9ACTIONOBJ WHERE OBJID = :1 ORDER BY LEVEL#
6y0tb6wcmczp8	SELECT BUCKET, ENDPTHASH, ENDPTVAL, UTL_RAW.CAST_TO_RAW(ENDPTVAL) ENDPTVAL_RAW FROM SYS.EXU8HSTU WHERE POBJID = :1 AND INTCOL = :2 ORDER BY BUCKET
719syuvrm29tq	SELECT IOBJID, IDOBJID, INAME, IOWNER, IOWNERID, ISPACE, ITSNO, IFILENO, IBLOCKNO, BTNAME, BTOWNER, PROPERTY, CLUSTER$, PCTFREE$, INITRANS, MAXTRANS, BLEVEL, TYPE, DEFLOG, TSDEFLOG, DEGREE, INSTANCES, ROWCNT, LEAFCNT, DISTKEY, LBLKKEY, DBLKKEY, CLUFAC, PRECCNT, IFLAGS FROM SYS.EXU11IND WHERE BTOBJID = :1 AND SYSGENCONST = 0 ORDER BY IOWNERID, IOBJID
772s25v1y0x8k	select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
7s0yy7vj75dvf	SELECT CNO, CNAME, TYPE, CONDITION, CONDLENGTH, ENABLED, DEFER, INAME, IDXSYSGEND FROM SYS.EXU8CONU WHERE OBJID = :1 AND TYPE IN (1, 2, 3, 7, 11, 12, 14, 15, 16, 17) ORDER BY CNO
8342733gfcsdu	SELECT COUNT(*) FROM ALL_TABLES WHERE TABLE_NAME = 'AW$$TEMP_EXP_TABLE' || :B2 AND OWNER = :B1
84k66tf2s7y1c	insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id
896y3kr66cfdm	SET TRANSACTION READ ONLY
8vwv6hx92ymmm	UPDATE 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
96g93hntrzjtr	select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9dhn1b8d88dpf	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
9jyrnnbdj8wgv	SELECT /*+NESTED_TABLE_GET_REFS+*/ "SCHOOL"."CHECKLIST".* FROM "SCHOOL"."CHECKLIST"
9xvu3gwfcnx0p	select count(*) from FEEDEPT_LOG where flag='0'
athfuwyys6qs3	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"IDDBUSER"."TRJN"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
b33bawb86z37s	select account, sno, bankacc, identityid, cardbalance, ebagamt from account@dl_syntong where CardID=1681845510
bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
cfxbacspz0yh2	INSERT /*+ IDX(0) */ INTO "SCHOOL"."MLOG$_TRJN" (dmltype$$, old_new$$, snaptime$$, change_vector$$, xid$$, m_row$$) VALUES (:d, :o, to_date('4000-01-01:00:00:00', 'YYYY-MM-DD:HH24:MI:SS'), :c, :x, :m)
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
csj1ggdtntts5	select account, sno, bankacc, identityid, cardbalance, ebagamt from account@dl_syntong where CardID=1681950278
cywxs9hpaztvh	SELECT /*+NESTED_TABLE_GET_REFS+*/ "SCHOOL"."DEPTREPORT".* FROM "SCHOOL"."DEPTREPORT"
d39a9gpw7wdu8	SELECT TOWNER, TNAME, NAME, LENGTH, PRECISION, SCALE, TYPE, ISNULL, CONNAME, COLID, INTCOLID, SEGCOLID, COMMENT$, DEFAULT$, DFLTLEN, ENABLED, DEFER, FLAGS, COLPROP, ADTNAME, ADTOWNER, CHARSETID, CHARSETFORM, FSPRECISION, LFPRECISION, CHARLEN, TFLAGS, 100 FROM SYS.EXU8COLU WHERE TOBJID = :1 ORDER BY INTCOLID
d3mdnaprqgkm0	select account, sno, bankacc, identityid, cardbalance, ebagamt from account@dl_syntong where CardID=1681531478
d4ggk0agny9tf	SET TRANSACTION READ WRITE
d6q01466mmc4t	UPDATE DoorControl SET LastUpdateTime = :LastUpdateTime WHERE ID = :ID
dk0z4q904m31t	update idinformation@dl_idmanage set ACCOUNT=:b0, OPENFLAG='1', OPENACCDATE=:b1 where NO=:b2
f3w7zhq201fxu	SELECT COLNAME, COLNO, PROPERTY, NOLOG FROM SYS.EXU10CCLU WHERE CNO = :1 ORDER BY COLNO
f4amp8adnxrp5	SELECT "A2"."FROMACCOUNT", "A2"."ACCTYPE", "A2"."OPENLOCATION", "A2"."TRADELOCATION", "A2"."FROMJNNUMBER", "A2"."TOACCOUNT", "A2"."SYSCODE", "A2"."POSCODE", "A2"."DINESEQ", "A2"."OPERCODE", "A2"."TRANCODE", "A2"."JOURNALSTATUS", "A2"."JNDATETIME", "A2"."EFFECTDATE", "A2"."CARDBALANCE", "A2"."USEDCARDNUM", "A2"."SUBSEQ", "A2"."TRANAMT", "A2"."ENSUREAMT", "A2"."FEEAMT", "A2"."CONSUMETYPE", "A2"."RESUME", "A2"."BANKACC", "A2"."CASHFLAG", "A2"."DIGITALSIGN", "A2"."EBAGAMT", "A2"."CHECKCODE", "A2"."CHECKFLAG", "A2"."REFUNDAMT", ROWIDTOCHAR("A2".ROWID) FROM "TRJN" "A2", (SELECT DISTINCT "A3"."M_ROW$$" "M_ROW$$" FROM "SCHOOL"."MLOG$_TRJN" "A3" WHERE "A3"."SNAPTIME$$">:1 AND "A3"."DMLTYPE$$"<>'D') "A1" WHERE "A2".ROWID="A1"."M_ROW$$"
fg28tkj5xph8y	begin dbms_mview . refresh ( 'ACCOUNT' , 'F' ) ; end ;
fhckmsatm8t4j	select account, sno, bankacc, identityid, cardbalance, ebagamt from account@dl_syntong where CardID=1681934646
fqj226s44h36k	SELECT OBJID, NAME, OWNER, OWNERID, TABLESPACE, TSNO, FILENO, BLOCKNO, AUDIT$, COMMENT$, CLUSTERFLAG, PCTFREE$, PCTUSED$, INITRANS, MAXTRANS, DEGREE, INSTANCES, CACHE, PROPERTY, DEFLOG, TSDEFLOG, ROID, ROWCNT, BLKCNT, AVGRLEN, TFLAGS, TRIGFLAG, OBJSTATUS, XDBOOL FROM SYS.EXU10TABU T$ WHERE NOT EXISTS ( SELECT NAME FROM SYS.EXU8NXPU N$ WHERE N$.NAME = T$.NAME AND N$.TYPE = 2) ORDER BY T$.XDBOOL DESC, T$.NAME
gc1y234jjnbv4	select account, sno, bankacc, identityid, cardbalance, ebagamt from account@dl_syntong where CardID=2563545661
ggn0cngz6ybh1	SELECT OWNERID, OWNER, OBJID, NAME, CURVAL, MINVAL, MAXVAL, INCR, CACHE, CYCLE, ORDER$, AUDT FROM SYS.EXU8SEQU
gmh1ntt3rmu3x	select account, sno, bankacc, identityid, cardbalance, ebagamt from account@dl_syntong where CardID=2860603910

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

Back to Instance Activity Statistics
Back to Top

IO Stats

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times, in milliseconds
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Ordered by (Data Read + Write) desc for each function

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File