WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

IMSCMDB 1859377741 imscmdb2 2 10.2.0.4.0 YES yunwei2

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
IMSCMDB	1859377741	imscmdb2	2	10.2.0.4.0	YES	yunwei2

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 36849 02-Aug-14 06:00:15 424 6.5

End Snap: 36850 02-Aug-14 07:00:30 425 6.6

Elapsed: 60.25 (mins)

DB Time: 67.23 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	36849	02-Aug-14 06:00:15	424	6.5
End Snap:	36850	02-Aug-14 07:00:30	425	6.6
Elapsed:		60.25 (mins)
DB Time:		67.23 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 9,984M 9,984M Std Block Size: 8K

Shared Pool Size: 3,952M 3,952M Log Buffer: 14,320K

	Begin	End
Buffer Cache:	9,984M	9,984M	Std Block Size:	8K
Shared Pool Size:	3,952M	3,952M	Log Buffer:	14,320K

Load Profile

Per Second Per Transaction

Redo size: 81,208.90 758.47

Logical reads: 30,452.05 284.41

Block changes: 541.80 5.06

Physical reads: 409.32 3.82

Physical writes: 25.67 0.24

User calls: 1,073.77 10.03

Parses: 394.23 3.68

Hard parses: 2.56 0.02

Sorts: 12.34 0.12

Logons: 0.72 0.01

Executes: 432.29 4.04

Transactions: 107.07

	Per Second	Per Transaction
Redo size:	81,208.90	758.47
Logical reads:	30,452.05	284.41
Block changes:	541.80	5.06
Physical reads:	409.32	3.82
Physical writes:	25.67	0.24
User calls:	1,073.77	10.03
Parses:	394.23	3.68
Hard parses:	2.56	0.02
Sorts:	12.34	0.12
Logons:	0.72	0.01
Executes:	432.29	4.04
Transactions:	107.07

% Blocks changed per Read: 1.78 Recursive Call %: 31.90

Rollback per transaction %: 18.77 Rows per Sort: 63.64

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

Buffer Hit %: 98.66 In-memory Sort %: 100.00

Library Hit %: 98.40 Soft Parse %: 99.35

Execute to Parse %: 8.80 Latch Hit %: 98.91

Parse CPU to Parse Elapsd %: 23.68 % Non-Parse CPU: 98.46

Shared Pool Statistics

Begin End

Memory Usage %: 45.06 44.77

% SQL with executions>1: 67.43 73.15

% Memory for SQL w/exec>1: 70.62 62.94

	Begin	End
Memory Usage %:	45.06	44.77
% SQL with executions>1:	67.43	73.15
% Memory for SQL w/exec>1:	70.62	62.94

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

CPU time 2,228 55.2

PX Deq Credit: send blkd 167,467 651 4 16.1 Other

log file sync 315,591 495 2 12.3 Commit

db file sequential read 299,558 218 1 5.4 User I/O

log file parallel write 208,517 163 1 4.0 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		2,228		55.2
PX Deq Credit: send blkd	167,467	651	4	16.1	Other
log file sync	315,591	495	2	12.3	Commit
db file sequential read	299,558	218	1	5.4	User I/O
log file parallel write	208,517	163	1	4.0	System I/O

RAC Statistics

Begin End

Number of Instances: 2 2

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 73.83 0.69

Global Cache blocks served: 364.16 3.40

GCS/GES messages received: 1,539.01 14.37

GCS/GES messages sent: 1,160.91 10.84

DBWR Fusion writes: 2.02 0.02

Estd Interconnect traffic (KB) 4,031.27

	Per Second	Per Transaction
Global Cache blocks received:	73.83	0.69
Global Cache blocks served:	364.16	3.40
GCS/GES messages received:	1,539.01	14.37
GCS/GES messages sent:	1,160.91	10.84
DBWR Fusion writes:	2.02	0.02
Estd Interconnect traffic (KB)	4,031.27

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

Buffer access - local cache %: 98.41

Buffer access - remote cache %: 0.24

Buffer access - disk %: 1.34

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1

Avg global cache cr block receive time (ms): 0.5

Avg global cache current block receive time (ms): 0.8

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 %: 2.7

Avg global cache cr block flush time (ms): 1.3

Avg global cache current block pin time (ms): 0.0

Avg global cache current block send time (ms): 0.1

Global cache log flushes for current blocks served %: 0.0

Avg global cache current block flush time (ms): 2.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0

Avg message sent queue time on ksxp (ms): 0.3

Avg message received queue time (ms): 0.4

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.1

% of direct sent messages: 11.56

% of indirect sent messages: 74.54

% of flow controlled messages: 13.90

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
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Wait Class
Wait Events
Background Wait Events
Operating System Statistics
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 4033.8s
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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	3,258.06	80.77
DB CPU	2,228.13	55.24
parse time elapsed	154.83	3.84
hard parse elapsed time	64.25	1.59
connection management call elapsed time	3.74	0.09
PL/SQL execution elapsed time	1.02	0.03
sequence load elapsed time	0.85	0.02
hard parse (sharing criteria) elapsed time	0.34	0.01
repeated bind elapsed time	0.34	0.01
PL/SQL compilation elapsed time	0.09	0.00
hard parse (bind mismatch) elapsed time	0.02	0.00
DB time	4,033.83
background elapsed time	625.57
background cpu time	316.32

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
Other	1,607,008	84.70	785	0	4.15
Commit	315,591	0.00	495	2	0.82
User I/O	466,042	0.00	373	1	1.20
System I/O	281,923	0.00	260	1	0.73
Cluster	442,963	0.24	140	0	1.14
Concurrency	40,325	10.83	126	3	0.10
Network	2,765,678	0.00	3	0	7.15
Application	709	0.00	3	4	0.00
Configuration	8	0.00	0	10	0.00

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
PX Deq Credit: send blkd	167,467	32.68	651	4	0.43
log file sync	315,591	0.00	495	2	0.82
db file sequential read	299,558	0.00	218	1	0.77
log file parallel write	208,517	0.00	163	1	0.54
db file scattered read	163,182	0.00	152	1	0.42
gc cr multi block request	275,511	0.05	83	0	0.71
name-service call wait	938	0.43	62	66	0.00
kst: async disk IO	1,996	0.00	48	24	0.01
cursor: pin S wait on X	4,390	99.48	45	10	0.01
latch: cache buffers chains	4,554	0.00	36	8	0.01
os thread startup	424	0.24	29	68	0.00
db file parallel write	14,756	0.00	27	2	0.04
gc cr grant 2-way	85,223	0.00	21	0	0.22
gc current block 2-way	47,087	0.04	17	0	0.12
control file sequential read	54,408	0.00	17	0	0.14
PX Deq: reap credit	819,401	91.60	13	0	2.12
DFS lock handle	1,784	0.00	10	6	0.00
gcs drm freeze in enter server mode	41	2.44	10	245	0.00
IPC send completion sync	2,732	94.58	8	3	0.01
library cache lock	13,097	0.00	8	1	0.03
wait for scn ack	27,436	0.00	7	0	0.07
gc cr disk read	15,664	0.00	6	0	0.04
gcs log flush sync	4,654	21.36	6	1	0.01
row cache lock	14,136	0.00	5	0	0.04
gc cr block 2-way	8,859	0.01	5	1	0.02
kksfbc child completion	79	97.47	4	48	0.00
CGS wait for IPC msg	528,867	99.97	4	0	1.37
db file parallel read	2,547	0.00	3	1	0.01
global enqueue expand wait	333	88.59	3	9	0.00
gc buffer busy	278	9.71	3	10	0.00
SQL*Net message to client	2,758,790	0.00	3	0	7.13
enq: TX - row lock contention	620	0.00	3	4	0.00
enq: PS - contention	2,610	0.00	3	1	0.01
control file parallel write	1,717	0.00	2	1	0.00
library cache load lock	371	0.00	2	4	0.00
gc current grant busy	4,223	0.00	2	0	0.01
gc current grant 2-way	4,617	0.00	2	0	0.01
Log archive I/O	267	0.00	2	6	0.00
gc remaster	147	0.00	1	9	0.00
log file sequential read	258	0.00	1	4	0.00
latch: shared pool	213	0.00	1	4	0.00
latch free	296	0.00	1	3	0.00
latch: parallel query alloc buffer	121	0.00	1	6	0.00
latch: ges resource hash list	142	0.00	1	5	0.00
enq: TX - index contention	231	0.00	1	3	0.00
rdbms ipc reply	1,567	0.00	0	0	0.00
gc cr block busy	184	0.00	0	2	0.00
LGWR wait for redo copy	8,080	0.00	0	0	0.02
kjbdrmcvtq lmon drm quiesce: ping completion	20	0.00	0	14	0.00
ksxr poll remote instances	28,323	43.96	0	0	0.07
buffer busy waits	2,243	0.00	0	0	0.01
library cache pin	555	0.00	0	0	0.00
reliable message	409	0.00	0	1	0.00
ges global resource directory to be frozen	20	100.00	0	10	0.00
direct path read	462	0.00	0	0	0.00
SGA: allocation forcing component growth	19	42.11	0	8	0.00
direct path write	275	0.00	0	1	0.00
ges2 LMON to wake up LMD - mrcvr	24	25.00	0	6	0.00
PX qref latch	10,691	98.79	0	0	0.03
read by other session	18	0.00	0	4	0.00
SQL*Net more data from client	1,959	0.00	0	0	0.01
SQL*Net more data to client	4,929	0.00	0	0	0.01
log file switch completion	2	0.00	0	34	0.00
gc object scan	902	98.67	0	0	0.00
gc current multi block request	267	0.00	0	0	0.00
PX Deq: Signal ACK	344	31.69	0	0	0.00
latch: session allocation	24	0.00	0	2	0.00
enq: CF - contention	99	0.00	0	0	0.00
enq: FB - contention	83	0.00	0	0	0.00
SQL*Net break/reset to client	82	0.00	0	0	0.00
latch: library cache	12	0.00	0	1	0.00
latch: messages	11	0.00	0	1	0.00
enq: HW - contention	6	0.00	0	2	0.00
latch: KCL gc element parent latch	8	0.00	0	1	0.00
cursor: pin S	239	0.00	0	0	0.00
latch: gcs resource hash	3	0.00	0	2	0.00
latch: enqueue hash chains	7	0.00	0	1	0.00
enq: WF - contention	14	0.00	0	0	0.00
enq: TA - contention	11	0.00	0	0	0.00
enq: IR - contention	6	0.00	0	0	0.00
latch: object queue header operation	44	0.00	0	0	0.00
log file single write	4	0.00	0	1	0.00
enq: TM - contention	6	0.00	0	0	0.00
enq: US - contention	3	0.00	0	1	0.00
cursor: mutex S	94	0.00	0	0	0.00
gc current block busy	1	0.00	0	2	0.00
buffer deadlock	41	100.00	0	0	0.00
enq: PE - contention	2	0.00	0	0	0.00
KJC: Wait for msg sends to complete	10	0.00	0	0	0.00
enq: PG - contention	2	0.00	0	0	0.00
latch: library cache lock	1	0.00	0	1	0.00
latch: redo allocation	2	0.00	0	0	0.00
enq: PW - flush prewarm buffers	1	0.00	0	0	0.00
enq: DR - contention	1	0.00	0	0	0.00
cursor: mutex X	4	0.00	0	0	0.00
SQL*Net message from client	2,758,793	0.00	1,056,243	383	7.13
PX Idle Wait	161,648	98.29	391,803	2424	0.42
gcs remote message	2,108,309	89.58	13,814	7	5.45
jobq slave wait	3,736	99.95	10,881	2913	0.01
Streams AQ: qmn slave idle wait	139	8.63	3,530	25395	0.00
Streams AQ: qmn coordinator idle wait	264	51.89	3,530	13371	0.00
ges remote message	188,477	90.90	3,518	19	0.49
virtual circuit status	120	100.00	3,514	29285	0.00
DIAG idle wait	17,223	0.00	3,364	195	0.04
Streams AQ: waiting for time management or cleanup tasks	1	100.00	2,784	2783971	0.00
PX Deq: Execution Msg	71,114	36.68	1,922	27	0.18
PX Deq: Table Q Normal	63,283	12.26	590	9	0.16
PX Deq: Execute Reply	16,513	30.44	10	1	0.04
PX Deq: Msg Fragment	13,563	39.96	8	1	0.04
PX Deq: Parse Reply	689	14.08	0	1	0.00
PX Deq Credit: need buffer	367	33.79	0	1	0.00
PX Deq: Join ACK	851	29.61	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	264	100.00	0	0	0.00
class slave wait	2	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	208,535	0.00	163	1	0.54
kst: async disk IO	1,996	0.00	48	24	0.01
db file parallel write	14,756	0.00	27	2	0.04
events in waitclass Other	599,585	90.47	21	0	1.55
os thread startup	293	0.00	15	51	0.00
control file sequential read	10,084	0.00	5	0	0.03
control file parallel write	1,717	0.00	2	1	0.00
Log archive I/O	267	0.00	2	6	0.00
log file sequential read	258	0.00	1	4	0.00
library cache lock	1,531	0.00	1	0	0.00
row cache lock	634	0.00	0	0	0.00
gc cr block 2-way	646	0.00	0	0	0.00
gc current block 2-way	323	0.00	0	0	0.00
gc object scan	902	98.67	0	0	0.00
direct path read	97	0.00	0	0	0.00
db file sequential read	6	0.00	0	3	0.00
direct path write	77	0.00	0	0	0.00
gc current grant busy	42	0.00	0	0	0.00
library cache pin	7	0.00	0	0	0.00
gc current block busy	1	0.00	0	2	0.00
log file single write	4	0.00	0	1	0.00
gc current grant 2-way	8	0.00	0	0	0.00
latch: cache buffers chains	8	0.00	0	0	0.00
buffer busy waits	4	0.00	0	0	0.00
enq: TM - contention	5	0.00	-0	-14	0.00
rdbms ipc message	264,190	22.13	48,874	185	0.68
gcs remote message	2,108,287	89.58	13,814	7	5.45
Streams AQ: qmn slave idle wait	139	8.63	3,530	25395	0.00
Streams AQ: qmn coordinator idle wait	264	51.89	3,530	13371	0.00
smon timer	768	95.70	3,528	4594	0.00
pmon timer	1,318	99.92	3,526	2675	0.00
ges remote message	188,460	90.90	3,518	19	0.49
DIAG idle wait	17,223	0.00	3,364	195	0.04
Streams AQ: waiting for time management or cleanup tasks	1	100.00	2,784	2783971	0.00
PX Deq: Join ACK	29	41.38	0	1	0.00
PX Deq: Parse Reply	27	40.74	0	1	0.00
PX Deq: Execute Reply	26	34.62	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	264	100.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	91,292
AVG_IDLE_TIME	270,208
AVG_IOWAIT_TIME	15,417
AVG_SYS_TIME	9,870
AVG_USER_TIME	81,309
BUSY_TIME	1,462,383
IDLE_TIME	4,325,162
IOWAIT_TIME	248,461
SYS_TIME	159,676
USER_TIME	1,302,707
LOAD	0
OS_CPU_WAIT_TIME	1,494,000
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,420,214,272
NUM_CPUS	16
NUM_CPU_CORES	8

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
imscmdb	3,927.90	2,166.50	1,452,206	108,568,950
SYS$USERS	92.80	56.20	27,142	483,984
SYS$BACKGROUND	0.00	0.00	328	315,935
imscmdbXDB	0.00	0.00	0	0

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 centisecond (100th of a second)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
imscmdb	438403	35964	36972	10970	2755087	293
SYS$USERS	27142	1253	764	36	5697	1
SYS$BACKGROUND	497	131	2485	1572	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
558	511	2,696	0.21	13.83	d8p3qw80pv9fp		update MW_SYS.mwt_is_ulog set ...
510	37	13	39.23	12.64	2kwvpwwtvu8g3	AlertService	select distinct b.ruleid, b.c...
59	18	1	58.67	1.45	7tc7jsq9rgr3m		select a.V0635, a.resourceid, ...
56	17	1	55.57	1.38	16c15j5bv8gy0		select a.V0640, a.resourceid, ...
51	50	520,888	0.00	1.26	bhczqay9abvbf	TransDataDB	SELECT CLASSNAME, CLASSPROPERT...
42	12	1	42.09	1.04	2wbazma7kv2hd		select a.V0635, a.resourceid, ...
38	13	1	38.02	0.94	bfbttf5chb890		select a.V0635, a.resourceid, ...
37	14	1	36.64	0.91	8fxyfk78hv8my		select a.V0640, a.resourceid, ...
35	12	1	34.54	0.86	6zfband4zby21		select a.V0640, a.resourceid, ...
32	11	1	32.14	0.80	2jdn220qbx0kq		select a.V0635, a.resourceid, ...

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 DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
511	558	2,696	0.19	13.83	d8p3qw80pv9fp		update MW_SYS.mwt_is_ulog set ...
50	51	520,888	0.00	1.26	bhczqay9abvbf	TransDataDB	SELECT CLASSNAME, CLASSPROPERT...
37	510	13	2.85	12.64	2kwvpwwtvu8g3	AlertService	select distinct b.ruleid, b.c...
25	25	4,590	0.01	0.61	0pp31sac8s8dh	IMSV3(Schedule)	select * from all_tables where...
18	59	1	17.57	1.45	7tc7jsq9rgr3m		select a.V0635, a.resourceid, ...
17	56	1	17.37	1.38	16c15j5bv8gy0		select a.V0640, a.resourceid, ...
15	16	54	0.28	0.39	03sv01x3w9s61	IMSV3(Schedule)	select mm.num, gg.num from (se...
14	37	1	14.11	0.91	8fxyfk78hv8my		select a.V0640, a.resourceid, ...
14	15	54	0.26	0.37	g2hg5ta2f3s1z	IMSV3(Schedule)	select oo.num, mm.num from (se...
13	38	1	12.87	0.94	bfbttf5chb890		select a.V0635, a.resourceid, ...
12	42	1	12.17	1.04	2wbazma7kv2hd		select a.V0635, a.resourceid, ...

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: 110,082,762
Captured SQL account for 41.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
21,765,643	2,696	8,073.31	19.77	511.09	557.81	d8p3qw80pv9fp		update MW_SYS.mwt_is_ulog set ...
3,633,657	520,888	6.98	3.30	50.34	50.80	bhczqay9abvbf	TransDataDB	SELECT CLASSNAME, CLASSPROPERT...
1,085,614	1	1,085,614.00	0.99	12.87	38.02	bfbttf5chb890		select a.V0635, a.resourceid, ...
1,085,590	1	1,085,590.00	0.99	14.11	36.64	8fxyfk78hv8my		select a.V0640, a.resourceid, ...
1,057,197	1	1,057,197.00	0.96	17.57	58.67	7tc7jsq9rgr3m		select a.V0635, a.resourceid, ...
1,057,189	1	1,057,189.00	0.96	17.37	55.57	16c15j5bv8gy0		select a.V0640, a.resourceid, ...
867,330	702	1,235.51	0.79	5.86	20.02	g62gnq4cka5qt	IMSServer	select computersy0_.ObjectId a...
861,045	712	1,209.33	0.78	5.68	19.53	dzwnckwmd4xqr	IMSServer	select computersy0_.ObjectId a...
858,531	700	1,226.47	0.78	5.51	20.33	dyb6b6fy5vn4p	IMSServer	select computersy0_.ObjectId a...
837,162	684	1,223.92	0.76	5.37	20.40	c1hf0t989bpyt	IMSServer	select computersy0_.ObjectId a...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 1,479,685
Captured SQL account for 66.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
155,615	1	155,615.00	10.52	14.11	36.64	8fxyfk78hv8my		select a.V0640, a.resourceid, ...
155,511	1	155,511.00	10.51	12.87	38.02	bfbttf5chb890		select a.V0635, a.resourceid, ...
132,184	1	132,184.00	8.93	12.17	42.09	2wbazma7kv2hd		select a.V0635, a.resourceid, ...
131,775	1	131,775.00	8.91	11.84	34.54	6zfband4zby21		select a.V0640, a.resourceid, ...
101,803	1	101,803.00	6.88	11.48	31.84	auuqn7zfjumj5		select a.V0640, a.resourceid, ...
100,389	1	100,389.00	6.78	11.43	32.14	2jdn220qbx0kq		select a.V0635, a.resourceid, ...
91,078	1	91,078.00	6.16	17.37	55.57	16c15j5bv8gy0		select a.V0640, a.resourceid, ...
90,024	1	90,024.00	6.08	17.57	58.67	7tc7jsq9rgr3m		select a.V0635, a.resourceid, ...
27,137	11	2,467.00	1.83	12.73	32.04	4zbzjuu5h34dn	JDBC Thin Client	select a.spaceName, a.status,...
2,797	13	215.15	0.19	37.03	510.01	2kwvpwwtvu8g3	AlertService	select distinct b.ruleid, b.c...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 1,562,700
Captured SQL account for 57.8% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
520,888	0	0.00	bhczqay9abvbf	TransDataDB	SELECT CLASSNAME, CLASSPROPERT...
75,802	75,736	1.00	520mkxqpf15q8		select 1 from dual
29,009	29,009	1.00	2ym6hhaq30r73		select type#, blocks, extents,...
17,859	17,731	0.99	0fpr7xfqgftjh	TransDataDB	SELECT V0645, H, L, A, to_char...
17,822	17,738	1.00	14b5qj9pfsh53	TransDataDB	SELECT V0630, H, L, A, to_char...
17,767	17,767	1.00	7d62wzbkw42dj		select dictdba.SEQ_RESOURCE_VI...
17,321	17,211	0.99	a676tfuwm597g	TransDataDB	UPDATE PERFORMANCEDBA.CPULOAD5...
17,204	17,075	0.99	gbna6926q30s2	TransDataDB	UPDATE PERFORMANCEDBA.CPULOAD5...
12,533	12,529	1.00	a3z8qwbhx7p91	TransDataDB	SELECT V0600, H, L, A, to_char...
9,615	9,595	1.00	8t59gz6p9vh9b	TransDataDB	SELECT V0600, H, L, A, to_char...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,425,127
Captured SQL account for 62.3% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
520,295	520,888	36.51	bhczqay9abvbf	TransDataDB	SELECT CLASSNAME, CLASSPROPERT...
75,734	75,802	5.31	520mkxqpf15q8		select 1 from dual
29,008	29,009	2.04	2ym6hhaq30r73		select type#, blocks, extents,...
17,849	17,859	1.25	0fpr7xfqgftjh	TransDataDB	SELECT V0645, H, L, A, to_char...
17,838	17,822	1.25	14b5qj9pfsh53	TransDataDB	SELECT V0630, H, L, A, to_char...
17,767	17,767	1.25	7d62wzbkw42dj		select dictdba.SEQ_RESOURCE_VI...
17,363	17,321	1.22	a676tfuwm597g	TransDataDB	UPDATE PERFORMANCEDBA.CPULOAD5...
17,239	17,204	1.21	gbna6926q30s2	TransDataDB	UPDATE PERFORMANCEDBA.CPULOAD5...
12,533	12,533	0.88	a3z8qwbhx7p91	TransDataDB	SELECT V0600, H, L, A, to_char...
9,612	9,605	0.67	ba14hks4vuy6y	TransDataDB	UPDATE PERFORMANCEDBA.COMPUTER...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
233	226	53txd0pcdmkhx	JDBC Thin Client	INSERT INTO QRTZ_FIRED_TRIGGER...
59	5,385	1wgnaj5cb47zn		SELECT COUNT(*) FROM MW_SYS.MW...
48	113	f9cgpd7yp5s01	JDBC Thin Client	SELECT TRIGGER_NAME FROM QRTZ_...
40	113	5xnhn40m7fhxf	JDBC Thin Client	UPDATE QRTZ_TRIGGERS SET TRIGG...
25	5,392	aqv4p9q9urgpg		INSERT INTO MW_SYS.MWT_IS_MDLA...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)	CWT % of Elapsd Time	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
11.89	37.01	32.14	11.43	1	2jdn220qbx0kq		select a.V0635, a.resourceid, ...
11.74	36.86	31.84	11.48	1	auuqn7zfjumj5		select a.V0640, a.resourceid, ...
10.14	24.09	42.09	12.17	1	2wbazma7kv2hd		select a.V0635, a.resourceid, ...
7.07	1.39	510.01	37.03	13	2kwvpwwtvu8g3	AlertService	select distinct b.ruleid, b.c...
6.23	19.44	32.04	12.73	11	4zbzjuu5h34dn	JDBC Thin Client	select a.spaceName, a.status,...
6.06	17.54	34.54	11.84	1	6zfband4zby21		select a.V0640, a.resourceid, ...
4.48	46.08	9.72	1.93	1	dpyv0xg8zm9u8	SocketClient	select * from (select t.DIMENS...
4.41	60.56	7.28	4.17	1	1bvka5z986kcv		select a.V0635, a.resourceid, ...
4.37	62.43	7.00	4.15	1	8q9a707ycxbu0		select a.V0640, a.resourceid, ...
1.53	2.75	55.57	17.37	1	16c15j5bv8gy0		select a.V0640, a.resourceid, ...
1.39	2.37	58.67	17.57	1	7tc7jsq9rgr3m		select a.V0635, a.resourceid, ...
0.85	12.20	6.97	4.88	12	a8gqd7rwbm8yv		select f.tablespace_name as na...
0.55	43.92	1.24	1.09	9,380	96g93hntrzjtr		select /+ rule / bucket_cnt,...
0.34	13.75	2.47	2.28	5,617	2v9mrz12gust7	TransDataDB	INSERT INTO STATDBA.T_BUSINESS...
0.30	8.86	3.41	3.03	7,761	5vru3bs9hfb4j	TransDataDB	INSERT INTO STATDBA.T_ONLINECO...
0.28	0.73	38.02	12.87	1	bfbttf5chb890		select a.V0635, a.resourceid, ...
0.27	20.18	1.33	1.32	6,535	db78fxqxwxt7r		select /+ rule / bucket, en...
0.27	0.73	36.64	14.11	1	8fxyfk78hv8my		select a.V0640, a.resourceid, ...
0.17	3.42	4.95	4.95	5,365	az33m61ym46y4	IMSServer	SELECT NULL AS table_cat, ...
0.13	6.35	2.09	2.08	5,968	8m1k4p1m18jtp	TransDataDB	INSERT INTO STATDBA.T_BSSESSIO...
0.06	2.31	2.78	2.78	9,605	ba14hks4vuy6y	TransDataDB	UPDATE PERFORMANCEDBA.COMPUTER...
0.04	5.17	0.77	0.56	1,067	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
0.03	3.58	0.75	0.74	1,083	83taa7kaw59c1		select name, intcol#, segcol#,...
0.02	12.92	0.13	0.13	1,143	6769wyy3yf66f		select pos#, intcol#, col#, sp...
0.02	2.47	0.67	0.67	5,644	7rkmxtb5f7xfb	TransDataDB	SELECT VALUE FROM STATDBA.T_BU...
0.01	1.73	0.57	0.57	5,390	591qw5jhtkfp9		SELECT MW_SYS.MWQ_OBJ_DISPIDX....
0.01	16.60	0.06	0.05	1	0dwr2vd6vbqzs		SELECT count(*) over () as tot...
0.01	0.84	0.84	0.84	7,788	8qaurqkq4p6wq	TransDataDB	SELECT VALUE FROM STATDBA.T_ON...
0.01	0.25	2.81	2.59	5,392	aqv4p9q9urgpg		INSERT INTO MW_SYS.MWT_IS_MDLA...
0.01	0.50	1.28	1.28	17,767	7d62wzbkw42dj		select dictdba.SEQ_RESOURCE_VI...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

03sv01x3w9s61 select mm.num, gg.num from (select count(*) as num from mw_app.mwt_ud_sjgl h where (h.sj_hgjssj - h.SJGL_SLJSSJ) * 24 < 8 and h.sj_hgjssj>=to_date(:1, 'yyyy-mm-dd') and h.sj_hgjssj < to_date(:2, 'yyyy-MM-DD hh24:mi:ss') and h.SJGL_SLJSSJ>=to_date(:3, 'yyyy-mm-dd') and h.SJGL_SLJSSJ < to_date(:4, 'yyyy-MM-DD hh24:mi:ss') and h.sj_zt = '??' and h.OBJ_ID in (select ydlp.obj_id from dictdba.dt_corporation t, mw_sys.mwt_pd_deps n, mw_sys.mwt_om_link r, mw_sys.mwt_pd_emps m, (select g.OBJ_ID, o.CUSER_ID from mw_app.mwt_ud_sjgl g left join mw_sys.MWT_OM_OBJ o on g.OBJ_ID = o.OBJ_ID) ydlp where to_char(t.corp_code) = n.areacode and n.obj_id = r.src_obj_id and r.tgt_obj_id = m.obj_id and m.SYSUSERID = ydlp.CUSER_ID and t.corp_name = (select t.corp_name from dictdba.dt_corporation t where t.corp_code = :5))) mm, (select count(*) as num from mw_app.mwt_ud_sjgl h where h.sj_hgjssj>=to_date(:6, 'yyyy-mm-dd') and h.sj_hgjssj< to_date(:7, 'yyyy-MM-DD hh24:mi:ss') and h.SJ_ZT = '??' and h.OBJ_ID in (select ydlp.obj_id from dictdba.dt_corporation t, mw_sys.mwt_pd_deps n, mw_sys.mwt_om_link r, mw_sys.mwt_pd_emps m, (select g.OBJ_ID, o.CUSER_ID from mw_app.mwt_ud_sjgl g left join mw_sys.MWT_OM_OBJ o on g.OBJ_ID = o.OBJ_ID) ydlp where to_char(t.corp_code) = n.areacode and n.obj_id = r.src_obj_id and r.tgt_obj_id = m.obj_id and m.SYSUSERID = ydlp.CUSER_ID and t.corp_name = (select t.corp_name from dictdba.dt_corporation t where t.corp_code = :8))) gg

0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id

0fpr7xfqgftjh SELECT V0645, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.CPULOAD5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')

0pp31sac8s8dh select * from all_tables where owner='RESOURCEDBA' and table_name = 'CORPORATION_FOLDERMAP'

14b5qj9pfsh53 SELECT V0630, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.CPULOAD5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')

16c15j5bv8gy0 select a.V0640, a.resourceid, c.typeid from performancedba.CPUSAVGLOAD5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='Computersystem' and a.V0640 != -9999?

1bvka5z986kcv select a.V0635, a.resourceid, c.typeid from performancedba.L2LinkOutDropPacketRate5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='L2Link' and a.V0635 != -9999?

1wgnaj5cb47zn SELECT COUNT(*) FROM MW_SYS.MWT_IS_LOGIN WHERE USER_ID=:1 AND LOGIN_IP=:2

2jdn220qbx0kq select a.V0635, a.resourceid, c.typeid from performancedba.L2LinkTotalBandwidthUR5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='L2Link' and a.V0635 != -9999?

2kwvpwwtvu8g3 select distinct b.ruleid, b.corporationid, c.departmentid, c.roleid, c.userid, b.countnumber from performancedba.alertinformtemp c, ( select a.ruleid, a.corporationid, count(*) countnumber from performancedba.alertinformtemp a where a.status = 1 and a.needpop = 1 group by a.ruleid, a.corporationid) b where c.ruleid=b.ruleid and c.corporationid = b.corporationid

2v9mrz12gust7 INSERT INTO STATDBA.T_BUSINESSDAYLOGINNUM (CORPORATIONID, TIME, DIMENSION_COLUMN1, VALUE, DIMENSION_COLUMN0, FLAG, flag_rz) values (:1, to_date(:2, 'yyyy-mm-dd hh24:mi:ss'), :3, :4, :5, :6, :7)

2wbazma7kv2hd select a.V0635, a.resourceid, c.typeid from performancedba.L2LinkTotalFlow5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='L2Link' and a.V0635 != -9999?

2ym6hhaq30r73 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

4zbzjuu5h34dn select a.spaceName, a.status, NVL (b.total_bytes, 0) total_bytes, a.free_bytes, a.free_blocks, b.phyrds, b.phywrts, b.readtim, b.writetim, a.fsfi from (SELECT t.tablespace_name spaceName, t.contents, t.status status, NVL (f.free_bytes, 0) free_bytes, NVL (f.free_blocks, 0) free_blocks, fsfi FROM sys.dba_tablespaces t, (SELECT tablespace_name, SUM(bytes) free_bytes, SUM(blocks) free_blocks, sqrt(max(blocks)/sum(blocks))*(100/SQRT(SQRT(COUNT(BLOCKS)))) fsfi FROM sys.dba_free_space GROUP BY tablespace_name) f WHERE t.tablespace_name = f.tablespace_name(+) ORDER BY t.tablespace_name) a left outer join (SELECT d.tablespace_name spaceName, SUM(d.bytes) total_bytes, SUM(f.phyrds) phyrds, SUM(f.phywrts) phywrts, SUM(f.readtim) readtim, SUM(f.writetim) writetim FROM sys.dba_data_files d, V$filestat f WHERE d.file_id = f.file# GROUP BY d.tablespace_name) b on a.SPACENAME = b.SPACENAME

520mkxqpf15q8 select 1 from dual

53txd0pcdmkhx INSERT INTO QRTZ_FIRED_TRIGGERS (ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, IS_VOLATILE, INSTANCE_NAME, FIRED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_STATEFUL, REQUESTS_RECOVERY, PRIORITY) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)

591qw5jhtkfp9 SELECT MW_SYS.MWQ_OBJ_DISPIDX.NEXTVAL FROM DUAL

5vru3bs9hfb4j INSERT INTO STATDBA.T_ONLINECOUNTREAL (CORPORATIONID, TIME, DIMENSION_COLUMN1, VALUE, DIMENSION_COLUMN0, FLAG, flag_rz) values (:1, to_date(:2, 'yyyy-mm-dd hh24:mi:ss'), :3, :4, :5, :6, :7)

5xnhn40m7fhxf UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = :1 WHERE TRIGGER_NAME = :2 AND TRIGGER_GROUP = :3 AND TRIGGER_STATE = :4

6769wyy3yf66f select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1

6zfband4zby21 select a.V0640, a.resourceid, c.typeid from performancedba.L2LinkTotalFlow5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='L2Link' and a.V0640 != -9999?

7d62wzbkw42dj select dictdba.SEQ_RESOURCE_VISU.Nextval as ID from dual

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

7rkmxtb5f7xfb SELECT VALUE FROM STATDBA.T_BUSINESSDAYLOGINNUM WHERE CORPORATIONID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd hh24:mi:ss') AND DIMENSION_COLUMN1 = :3 AND DIMENSION_COLUMN0 = :4

7tc7jsq9rgr3m select a.V0635, a.resourceid, c.typeid from performancedba.CPUSAVGLOAD5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='Computersystem' and a.V0635 != -9999?

83taa7kaw59c1 select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#

8fxyfk78hv8my select a.V0640, a.resourceid, c.typeid from performancedba.MEMLOAD5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='Computersystem' and a.V0640 != -9999?

8m1k4p1m18jtp INSERT INTO STATDBA.T_BSSESSIONNUM (CORPORATIONID, TIME, DIMENSION_COLUMN1, VALUE, DIMENSION_COLUMN0, FLAG, flag_rz) values (:1, to_date(:2, 'yyyy-mm-dd hh24:mi:ss'), :3, :4, :5, :6, :7)

8q9a707ycxbu0 select a.V0640, a.resourceid, c.typeid from performancedba.L2LinkOutDropPacketRate5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='L2Link' and a.V0640 != -9999?

8qaurqkq4p6wq SELECT VALUE FROM STATDBA.T_ONLINECOUNTREAL WHERE CORPORATIONID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd hh24:mi:ss') AND DIMENSION_COLUMN1 = :3 AND DIMENSION_COLUMN0 = :4

8t59gz6p9vh9b SELECT V0600, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.COMPUTERSYSTEMSTATUS5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')

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

a3z8qwbhx7p91 SELECT V0600, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.COMPUTERSYSTEMRUNNINGTIME5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')

a676tfuwm597g UPDATE PERFORMANCEDBA.CPULOAD5MIN SET V0630 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')

a8gqd7rwbm8yv select f.tablespace_name as name, sum(f.bytes) as used from SYS.Dba_Segments f group by f.tablespace_name

aqv4p9q9urgpg INSERT INTO MW_SYS.MWT_IS_MDLADT (OBJ_ID, MDLADT_OPERATOR, MDLADT_IP, MDLADT_EXT, MDLADT_TIME, MDLADT_TYPE, OBJ_DISPIDX, MDLADT_ID, MDLADT_ACTION) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9)

auuqn7zfjumj5 select a.V0640, a.resourceid, c.typeid from performancedba.L2LinkTotalBandwidthUR5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='L2Link' and a.V0640 != -9999?

az33m61ym46y4 SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name

ba14hks4vuy6y UPDATE PERFORMANCEDBA.COMPUTERSYSTEMSTATUS5MIN SET V0600 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')

bfbttf5chb890 select a.V0635, a.resourceid, c.typeid from performancedba.MEMLOAD5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='Computersystem' and a.V0635 != -9999?

bhczqay9abvbf SELECT CLASSNAME, CLASSPROPERTY FROM performancedba.MESSAGEKEYWORD WHERE SCENE='SGEPRI' AND ORIGINALCLASS='IpInterface' AND KEYWORD='OriginalKey'

c1hf0t989bpyt select computersy0_.ObjectId as col_0_0_ from RESOURCEDBA.ComputerSystem computersy0_ inner join RESOURCEDBA.CIMSystem computersy0_1_ on computersy0_.ObjectId=computersy0_1_.ObjectId inner join RESOURCEDBA.LogicalElement computersy0_2_ on computersy0_.ObjectId=computersy0_2_.ObjectId inner join RESOURCEDBA.ManagedElement computersy0_3_ on computersy0_.ObjectId=computersy0_3_.ObjectId inner join RESOURCEDBA.Object computersy0_4_ on computersy0_.ObjectId=computersy0_4_.OBJECTID where computersy0_4_.OriginalKey='NARI00-0F-E2-A6-30-92' and computersy0_4_.NetRegion=4

d8p3qw80pv9fp update MW_SYS.mwt_is_ulog set ulog_offtime=:1 where id=(select max(id) from MW_SYS.mwt_is_ulog where user_id=:2 and ulog_ip=:3 and ulog_type=:4)

db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

dpyv0xg8zm9u8 select * from (select t.DIMENSION_COLUMN0, t.DIMENSION_COLUMN1, t.DIMENSION_COLUMN2, t.time, t.value, ROWID from statdba.T_AltTypNumSta t where t.corporationid=17 and t.flag is null order by time desc ) where rownum<=100

dyb6b6fy5vn4p select computersy0_.ObjectId as col_0_0_ from RESOURCEDBA.ComputerSystem computersy0_ inner join RESOURCEDBA.CIMSystem computersy0_1_ on computersy0_.ObjectId=computersy0_1_.ObjectId inner join RESOURCEDBA.LogicalElement computersy0_2_ on computersy0_.ObjectId=computersy0_2_.ObjectId inner join RESOURCEDBA.ManagedElement computersy0_3_ on computersy0_.ObjectId=computersy0_3_.ObjectId inner join RESOURCEDBA.Object computersy0_4_ on computersy0_.ObjectId=computersy0_4_.OBJECTID where computersy0_4_.OriginalKey='NARI00-0F-E2-A6-31-1E' and computersy0_4_.NetRegion=4

dzwnckwmd4xqr select computersy0_.ObjectId as col_0_0_ from RESOURCEDBA.ComputerSystem computersy0_ inner join RESOURCEDBA.CIMSystem computersy0_1_ on computersy0_.ObjectId=computersy0_1_.ObjectId inner join RESOURCEDBA.LogicalElement computersy0_2_ on computersy0_.ObjectId=computersy0_2_.ObjectId inner join RESOURCEDBA.ManagedElement computersy0_3_ on computersy0_.ObjectId=computersy0_3_.ObjectId inner join RESOURCEDBA.Object computersy0_4_ on computersy0_.ObjectId=computersy0_4_.OBJECTID where computersy0_4_.OriginalKey='NARI00-0F-E2-A6-31-00' and computersy0_4_.NetRegion=4

f9cgpd7yp5s01 SELECT TRIGGER_NAME FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2

g2hg5ta2f3s1z select oo.num, mm.num from (select count(*) as num from mw_app.mwt_ud_sjgl h where sj_zt = '??' and h.sj_hgjssj >= to_date(:1, 'yyyy-mm-dd') and h.sj_hgjssj < to_date(:2, 'yyyy-MM-DD hh24:mi:ss') and h.SJGL_SLJSSJ >= to_date(:3, 'yyyy-mm-dd') and h.SJGL_SLJSSJ < to_date(:4, 'yyyy-MM-DD hh24:mi:ss') and h.OBJ_ID in (select ydlp.obj_id from dictdba.dt_corporation t, mw_sys.mwt_pd_deps n, mw_sys.mwt_om_link r, mw_sys.mwt_pd_emps m, (select g.OBJ_ID, o.CUSER_ID from mw_app.mwt_ud_sjgl g left join mw_sys.MWT_OM_OBJ o on g.OBJ_ID = o.OBJ_ID) ydlp where to_char(t.corp_code) = n.areacode and n.obj_id = r.src_obj_id and r.tgt_obj_id = m.obj_id and m.SYSUSERID = ydlp.CUSER_ID and t.corp_code = :5)) oo, (select count(*) as num from mw_app.mwt_ud_sjgl h where h.SJGL_SLJSSJ>=to_date(:6, 'yyyy-mm-dd') and h.SJGL_SLJSSJ <to_date(:7, 'yyyy-MM-DD hh24:mi:ss') and h.OBJ_ID in (select ydlp.obj_id from dictdba.dt_corporation t, mw_sys.mwt_pd_deps n, mw_sys.mwt_om_link r, mw_sys.mwt_pd_emps m, (select g.OBJ_ID, o.CUSER_ID from mw_app.mwt_ud_sjgl g left join mw_sys.MWT_OM_OBJ o on g.OBJ_ID = o.OBJ_ID) ydlp where to_char(t.corp_code) = n.areacode and n.obj_id = r.src_obj_id and r.tgt_obj_id = m.obj_id and m.SYSUSERID = ydlp.CUSER_ID and t.corp_code=:8)) mm

g62gnq4cka5qt select computersy0_.ObjectId as col_0_0_ from RESOURCEDBA.ComputerSystem computersy0_ inner join RESOURCEDBA.CIMSystem computersy0_1_ on computersy0_.ObjectId=computersy0_1_.ObjectId inner join RESOURCEDBA.LogicalElement computersy0_2_ on computersy0_.ObjectId=computersy0_2_.ObjectId inner join RESOURCEDBA.ManagedElement computersy0_3_ on computersy0_.ObjectId=computersy0_3_.ObjectId inner join RESOURCEDBA.Object computersy0_4_ on computersy0_.ObjectId=computersy0_4_.OBJECTID where computersy0_4_.OriginalKey='NARI00-0F-E2-A6-30-D3' and computersy0_4_.NetRegion=4

gbna6926q30s2 UPDATE PERFORMANCEDBA.CPULOAD5MIN SET V0645 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')

SQL Id	SQL Text
03sv01x3w9s61	select mm.num, gg.num from (select count() as num from mw_app.mwt_ud_sjgl h where (h.sj_hgjssj - h.SJGL_SLJSSJ) 24 < 8 and h.sj_hgjssj>=to_date(:1, 'yyyy-mm-dd') and h.sj_hgjssj < to_date(:2, 'yyyy-MM-DD hh24:mi:ss') and h.SJGL_SLJSSJ>=to_date(:3, 'yyyy-mm-dd') and h.SJGL_SLJSSJ < to_date(:4, 'yyyy-MM-DD hh24:mi:ss') and h.sj_zt = '??' and h.OBJ_ID in (select ydlp.obj_id from dictdba.dt_corporation t, mw_sys.mwt_pd_deps n, mw_sys.mwt_om_link r, mw_sys.mwt_pd_emps m, (select g.OBJ_ID, o.CUSER_ID from mw_app.mwt_ud_sjgl g left join mw_sys.MWT_OM_OBJ o on g.OBJ_ID = o.OBJ_ID) ydlp where to_char(t.corp_code) = n.areacode and n.obj_id = r.src_obj_id and r.tgt_obj_id = m.obj_id and m.SYSUSERID = ydlp.CUSER_ID and t.corp_name = (select t.corp_name from dictdba.dt_corporation t where t.corp_code = :5))) mm, (select count(*) as num from mw_app.mwt_ud_sjgl h where h.sj_hgjssj>=to_date(:6, 'yyyy-mm-dd') and h.sj_hgjssj< to_date(:7, 'yyyy-MM-DD hh24:mi:ss') and h.SJ_ZT = '??' and h.OBJ_ID in (select ydlp.obj_id from dictdba.dt_corporation t, mw_sys.mwt_pd_deps n, mw_sys.mwt_om_link r, mw_sys.mwt_pd_emps m, (select g.OBJ_ID, o.CUSER_ID from mw_app.mwt_ud_sjgl g left join mw_sys.MWT_OM_OBJ o on g.OBJ_ID = o.OBJ_ID) ydlp where to_char(t.corp_code) = n.areacode and n.obj_id = r.src_obj_id and r.tgt_obj_id = m.obj_id and m.SYSUSERID = ydlp.CUSER_ID and t.corp_name = (select t.corp_name from dictdba.dt_corporation t where t.corp_code = :8))) gg
0dwr2vd6vbqzs	SELECT count() over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash., evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe., nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap. FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count() as cnt FROM (SELECT t1. FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0fpr7xfqgftjh	SELECT V0645, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.CPULOAD5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
0pp31sac8s8dh	select * from all_tables where owner='RESOURCEDBA' and table_name = 'CORPORATION_FOLDERMAP'
14b5qj9pfsh53	SELECT V0630, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.CPULOAD5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
16c15j5bv8gy0	select a.V0640, a.resourceid, c.typeid from performancedba.CPUSAVGLOAD5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='Computersystem' and a.V0640 != -9999?
1bvka5z986kcv	select a.V0635, a.resourceid, c.typeid from performancedba.L2LinkOutDropPacketRate5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='L2Link' and a.V0635 != -9999?
1wgnaj5cb47zn	SELECT COUNT(*) FROM MW_SYS.MWT_IS_LOGIN WHERE USER_ID=:1 AND LOGIN_IP=:2
2jdn220qbx0kq	select a.V0635, a.resourceid, c.typeid from performancedba.L2LinkTotalBandwidthUR5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='L2Link' and a.V0635 != -9999?
2kwvpwwtvu8g3	select distinct b.ruleid, b.corporationid, c.departmentid, c.roleid, c.userid, b.countnumber from performancedba.alertinformtemp c, ( select a.ruleid, a.corporationid, count(*) countnumber from performancedba.alertinformtemp a where a.status = 1 and a.needpop = 1 group by a.ruleid, a.corporationid) b where c.ruleid=b.ruleid and c.corporationid = b.corporationid
2v9mrz12gust7	INSERT INTO STATDBA.T_BUSINESSDAYLOGINNUM (CORPORATIONID, TIME, DIMENSION_COLUMN1, VALUE, DIMENSION_COLUMN0, FLAG, flag_rz) values (:1, to_date(:2, 'yyyy-mm-dd hh24:mi:ss'), :3, :4, :5, :6, :7)
2wbazma7kv2hd	select a.V0635, a.resourceid, c.typeid from performancedba.L2LinkTotalFlow5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='L2Link' and a.V0635 != -9999?
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
4zbzjuu5h34dn	select a.spaceName, a.status, NVL (b.total_bytes, 0) total_bytes, a.free_bytes, a.free_blocks, b.phyrds, b.phywrts, b.readtim, b.writetim, a.fsfi from (SELECT t.tablespace_name spaceName, t.contents, t.status status, NVL (f.free_bytes, 0) free_bytes, NVL (f.free_blocks, 0) free_blocks, fsfi FROM sys.dba_tablespaces t, (SELECT tablespace_name, SUM(bytes) free_bytes, SUM(blocks) free_blocks, sqrt(max(blocks)/sum(blocks))*(100/SQRT(SQRT(COUNT(BLOCKS)))) fsfi FROM sys.dba_free_space GROUP BY tablespace_name) f WHERE t.tablespace_name = f.tablespace_name(+) ORDER BY t.tablespace_name) a left outer join (SELECT d.tablespace_name spaceName, SUM(d.bytes) total_bytes, SUM(f.phyrds) phyrds, SUM(f.phywrts) phywrts, SUM(f.readtim) readtim, SUM(f.writetim) writetim FROM sys.dba_data_files d, V$filestat f WHERE d.file_id = f.file# GROUP BY d.tablespace_name) b on a.SPACENAME = b.SPACENAME
520mkxqpf15q8	select 1 from dual
53txd0pcdmkhx	INSERT INTO QRTZ_FIRED_TRIGGERS (ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, IS_VOLATILE, INSTANCE_NAME, FIRED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_STATEFUL, REQUESTS_RECOVERY, PRIORITY) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
591qw5jhtkfp9	SELECT MW_SYS.MWQ_OBJ_DISPIDX.NEXTVAL FROM DUAL
5vru3bs9hfb4j	INSERT INTO STATDBA.T_ONLINECOUNTREAL (CORPORATIONID, TIME, DIMENSION_COLUMN1, VALUE, DIMENSION_COLUMN0, FLAG, flag_rz) values (:1, to_date(:2, 'yyyy-mm-dd hh24:mi:ss'), :3, :4, :5, :6, :7)
5xnhn40m7fhxf	UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = :1 WHERE TRIGGER_NAME = :2 AND TRIGGER_GROUP = :3 AND TRIGGER_STATE = :4
6769wyy3yf66f	select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6zfband4zby21	select a.V0640, a.resourceid, c.typeid from performancedba.L2LinkTotalFlow5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='L2Link' and a.V0640 != -9999?
7d62wzbkw42dj	select dictdba.SEQ_RESOURCE_VISU.Nextval as ID from dual
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7rkmxtb5f7xfb	SELECT VALUE FROM STATDBA.T_BUSINESSDAYLOGINNUM WHERE CORPORATIONID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd hh24:mi:ss') AND DIMENSION_COLUMN1 = :3 AND DIMENSION_COLUMN0 = :4
7tc7jsq9rgr3m	select a.V0635, a.resourceid, c.typeid from performancedba.CPUSAVGLOAD5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='Computersystem' and a.V0635 != -9999?
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8fxyfk78hv8my	select a.V0640, a.resourceid, c.typeid from performancedba.MEMLOAD5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='Computersystem' and a.V0640 != -9999?
8m1k4p1m18jtp	INSERT INTO STATDBA.T_BSSESSIONNUM (CORPORATIONID, TIME, DIMENSION_COLUMN1, VALUE, DIMENSION_COLUMN0, FLAG, flag_rz) values (:1, to_date(:2, 'yyyy-mm-dd hh24:mi:ss'), :3, :4, :5, :6, :7)
8q9a707ycxbu0	select a.V0640, a.resourceid, c.typeid from performancedba.L2LinkOutDropPacketRate5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='L2Link' and a.V0640 != -9999?
8qaurqkq4p6wq	SELECT VALUE FROM STATDBA.T_ONLINECOUNTREAL WHERE CORPORATIONID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd hh24:mi:ss') AND DIMENSION_COLUMN1 = :3 AND DIMENSION_COLUMN0 = :4
8t59gz6p9vh9b	SELECT V0600, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.COMPUTERSYSTEMSTATUS5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
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
a3z8qwbhx7p91	SELECT V0600, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.COMPUTERSYSTEMRUNNINGTIME5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
a676tfuwm597g	UPDATE PERFORMANCEDBA.CPULOAD5MIN SET V0630 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
a8gqd7rwbm8yv	select f.tablespace_name as name, sum(f.bytes) as used from SYS.Dba_Segments f group by f.tablespace_name
aqv4p9q9urgpg	INSERT INTO MW_SYS.MWT_IS_MDLADT (OBJ_ID, MDLADT_OPERATOR, MDLADT_IP, MDLADT_EXT, MDLADT_TIME, MDLADT_TYPE, OBJ_DISPIDX, MDLADT_ID, MDLADT_ACTION) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9)
auuqn7zfjumj5	select a.V0640, a.resourceid, c.typeid from performancedba.L2LinkTotalBandwidthUR5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='L2Link' and a.V0640 != -9999?
az33m61ym46y4	SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name
ba14hks4vuy6y	UPDATE PERFORMANCEDBA.COMPUTERSYSTEMSTATUS5MIN SET V0600 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
bfbttf5chb890	select a.V0635, a.resourceid, c.typeid from performancedba.MEMLOAD5MIN a, dictdba.visu_typemap c where a.time like sysdate and c.classname='Computersystem' and a.V0635 != -9999?
bhczqay9abvbf	SELECT CLASSNAME, CLASSPROPERTY FROM performancedba.MESSAGEKEYWORD WHERE SCENE='SGEPRI' AND ORIGINALCLASS='IpInterface' AND KEYWORD='OriginalKey'
c1hf0t989bpyt	select computersy0_.ObjectId as col_0_0_ from RESOURCEDBA.ComputerSystem computersy0_ inner join RESOURCEDBA.CIMSystem computersy0_1_ on computersy0_.ObjectId=computersy0_1_.ObjectId inner join RESOURCEDBA.LogicalElement computersy0_2_ on computersy0_.ObjectId=computersy0_2_.ObjectId inner join RESOURCEDBA.ManagedElement computersy0_3_ on computersy0_.ObjectId=computersy0_3_.ObjectId inner join RESOURCEDBA.Object computersy0_4_ on computersy0_.ObjectId=computersy0_4_.OBJECTID where computersy0_4_.OriginalKey='NARI00-0F-E2-A6-30-92' and computersy0_4_.NetRegion=4
d8p3qw80pv9fp	update MW_SYS.mwt_is_ulog set ulog_offtime=:1 where id=(select max(id) from MW_SYS.mwt_is_ulog where user_id=:2 and ulog_ip=:3 and ulog_type=:4)
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dpyv0xg8zm9u8	select * from (select t.DIMENSION_COLUMN0, t.DIMENSION_COLUMN1, t.DIMENSION_COLUMN2, t.time, t.value, ROWID from statdba.T_AltTypNumSta t where t.corporationid=17 and t.flag is null order by time desc ) where rownum<=100
dyb6b6fy5vn4p	select computersy0_.ObjectId as col_0_0_ from RESOURCEDBA.ComputerSystem computersy0_ inner join RESOURCEDBA.CIMSystem computersy0_1_ on computersy0_.ObjectId=computersy0_1_.ObjectId inner join RESOURCEDBA.LogicalElement computersy0_2_ on computersy0_.ObjectId=computersy0_2_.ObjectId inner join RESOURCEDBA.ManagedElement computersy0_3_ on computersy0_.ObjectId=computersy0_3_.ObjectId inner join RESOURCEDBA.Object computersy0_4_ on computersy0_.ObjectId=computersy0_4_.OBJECTID where computersy0_4_.OriginalKey='NARI00-0F-E2-A6-31-1E' and computersy0_4_.NetRegion=4
dzwnckwmd4xqr	select computersy0_.ObjectId as col_0_0_ from RESOURCEDBA.ComputerSystem computersy0_ inner join RESOURCEDBA.CIMSystem computersy0_1_ on computersy0_.ObjectId=computersy0_1_.ObjectId inner join RESOURCEDBA.LogicalElement computersy0_2_ on computersy0_.ObjectId=computersy0_2_.ObjectId inner join RESOURCEDBA.ManagedElement computersy0_3_ on computersy0_.ObjectId=computersy0_3_.ObjectId inner join RESOURCEDBA.Object computersy0_4_ on computersy0_.ObjectId=computersy0_4_.OBJECTID where computersy0_4_.OriginalKey='NARI00-0F-E2-A6-31-00' and computersy0_4_.NetRegion=4
f9cgpd7yp5s01	SELECT TRIGGER_NAME FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2
g2hg5ta2f3s1z	select oo.num, mm.num from (select count() as num from mw_app.mwt_ud_sjgl h where sj_zt = '??' and h.sj_hgjssj >= to_date(:1, 'yyyy-mm-dd') and h.sj_hgjssj < to_date(:2, 'yyyy-MM-DD hh24:mi:ss') and h.SJGL_SLJSSJ >= to_date(:3, 'yyyy-mm-dd') and h.SJGL_SLJSSJ < to_date(:4, 'yyyy-MM-DD hh24:mi:ss') and h.OBJ_ID in (select ydlp.obj_id from dictdba.dt_corporation t, mw_sys.mwt_pd_deps n, mw_sys.mwt_om_link r, mw_sys.mwt_pd_emps m, (select g.OBJ_ID, o.CUSER_ID from mw_app.mwt_ud_sjgl g left join mw_sys.MWT_OM_OBJ o on g.OBJ_ID = o.OBJ_ID) ydlp where to_char(t.corp_code) = n.areacode and n.obj_id = r.src_obj_id and r.tgt_obj_id = m.obj_id and m.SYSUSERID = ydlp.CUSER_ID and t.corp_code = :5)) oo, (select count() as num from mw_app.mwt_ud_sjgl h where h.SJGL_SLJSSJ>=to_date(:6, 'yyyy-mm-dd') and h.SJGL_SLJSSJ <to_date(:7, 'yyyy-MM-DD hh24:mi:ss') and h.OBJ_ID in (select ydlp.obj_id from dictdba.dt_corporation t, mw_sys.mwt_pd_deps n, mw_sys.mwt_om_link r, mw_sys.mwt_pd_emps m, (select g.OBJ_ID, o.CUSER_ID from mw_app.mwt_ud_sjgl g left join mw_sys.MWT_OM_OBJ o on g.OBJ_ID = o.OBJ_ID) ydlp where to_char(t.corp_code) = n.areacode and n.obj_id = r.src_obj_id and r.tgt_obj_id = m.obj_id and m.SYSUSERID = ydlp.CUSER_ID and t.corp_code=:8)) mm
g62gnq4cka5qt	select computersy0_.ObjectId as col_0_0_ from RESOURCEDBA.ComputerSystem computersy0_ inner join RESOURCEDBA.CIMSystem computersy0_1_ on computersy0_.ObjectId=computersy0_1_.ObjectId inner join RESOURCEDBA.LogicalElement computersy0_2_ on computersy0_.ObjectId=computersy0_2_.ObjectId inner join RESOURCEDBA.ManagedElement computersy0_3_ on computersy0_.ObjectId=computersy0_3_.ObjectId inner join RESOURCEDBA.Object computersy0_4_ on computersy0_.ObjectId=computersy0_4_.OBJECTID where computersy0_4_.OriginalKey='NARI00-0F-E2-A6-30-D3' and computersy0_4_.NetRegion=4
gbna6926q30s2	UPDATE PERFORMANCEDBA.CPULOAD5MIN SET V0645 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')

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

Statistic	Total	per Second	per Trans
CPU used by this session	150,717	41.69	0.39
CPU used when call started	154,961	42.87	0.40
CR blocks created	11,558	3.20	0.03
Cached Commit SCN referenced	1,178	0.33	0.00
Commit SCN cached	1	0.00	0.00
DB time	961,988	266.11	2.49
DBWR checkpoint buffers written	84,900	23.49	0.22
DBWR checkpoints	1	0.00	0.00
DBWR fusion writes	7,320	2.02	0.02
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	676	0.19	0.00
DBWR undo block writes	13,048	3.61	0.03
DFO trees parallelized	99	0.03	0.00
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	169,981	47.02	0.44
PX local messages sent	169,981	47.02	0.44
PX remote messages recv'd	104,016	28.77	0.27
PX remote messages sent	153,665	42.51	0.40
Parallel operations downgraded 1 to 25 pct	5	0.00	0.00
Parallel operations downgraded 25 to 50 pct	0	0.00	0.00
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	94	0.03	0.00
RowCR - row contention	41	0.01	0.00
RowCR attempts	2,778	0.77	0.01
RowCR hits	717	0.20	0.00
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment shrink	3	0.00	0.00
SQL*Net roundtrips to/from client	2,763,694	764.52	7.14
SQL*Net roundtrips to/from dblink	0	0.00	0.00
active txn count during cleanout	4,399	1.22	0.01
application wait time	262	0.07	0.00
background checkpoints completed	1	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	14,007	3.87	0.04
branch node splits	5	0.00	0.00
buffer is not pinned count	21,927,418	6,065.75	56.65
buffer is pinned count	15,882,996	4,393.69	41.04
bytes received via SQL*Net from client	428,152,646	118,439.31	1,106.19
bytes received via SQL*Net from dblink	0	0.00	0.00
bytes sent via SQL*Net to client	370,505,876	102,492.56	957.25
bytes sent via SQL*Net to dblink	0	0.00	0.00
calls to get snapshot scn: kcmgss	3,544,213	980.43	9.16
calls to kcmgas	605,078	167.38	1.56
calls to kcmgcs	1,363	0.38	0.00
change write time	1,953	0.54	0.01
cleanout - number of ktugct calls	8,306	2.30	0.02
cleanouts and rollbacks - consistent read gets	1,164	0.32	0.00
cleanouts only - consistent read gets	3,859	1.07	0.01
cluster key scan block gets	104,525	28.91	0.27
cluster key scans	67,896	18.78	0.18
cluster wait time	13,978	3.87	0.04
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	92	0.03	0.00
commit batch/immediate requested	92	0.03	0.00
commit cleanout failures: block lost	18	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	2,006	0.55	0.01
commit cleanout failures: cannot pin	863	0.24	0.00
commit cleanouts	419,392	116.02	1.08
commit cleanouts successfully completed	416,505	115.22	1.08
commit immediate performed	92	0.03	0.00
commit immediate requested	92	0.03	0.00
commit txn count during cleanout	38,593	10.68	0.10
concurrency wait time	12,739	3.52	0.03
consistent changes	50,918	14.09	0.13
consistent gets	108,422,608	29,992.80	280.12
consistent gets - examination	4,287,182	1,185.96	11.08
consistent gets direct	731	0.20	0.00
consistent gets from cache	108,378,776	29,980.68	280.01
current blocks converted for CR	0	0.00	0.00
cursor authentications	2,661	0.74	0.01
data blocks consistent reads - undo records applied	46,209	12.78	0.12
db block changes	1,958,600	541.80	5.06
db block gets	1,660,316	459.29	4.29
db block gets direct	319	0.09	0.00
db block gets from cache	1,659,997	459.20	4.29
deferred (CURRENT) block cleanout applications	176,890	48.93	0.46
dirty buffers inspected	0	0.00	0.00
enqueue conversions	4,722	1.31	0.01
enqueue releases	724,279	200.36	1.87
enqueue requests	725,327	200.65	1.87
enqueue timeouts	1,049	0.29	0.00
enqueue waits	3,651	1.01	0.01
exchange deadlocks	42	0.01	0.00
execute count	1,562,700	432.29	4.04
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	1,738,787	481.00	4.49
free buffer requested	1,777,430	491.69	4.59
gc CPU used by this session	40,362	11.17	0.10
gc blocks corrupt	0	0.00	0.00
gc blocks lost	0	0.00	0.00
gc cr block build time	649	0.18	0.00
gc cr block flush time	744	0.21	0.00
gc cr block receive time	438	0.12	0.00
gc cr block send time	1,058	0.29	0.00
gc cr blocks received	9,084	2.51	0.02
gc cr blocks served	217,883	60.27	0.56
gc current block flush time	1	0.00	0.00
gc current block pin time	738	0.20	0.00
gc current block receive time	20,327	5.62	0.05
gc current block send time	12,696	3.51	0.03
gc current blocks received	257,801	71.32	0.67
gc current blocks served	1,098,554	303.89	2.84
gc local grants	631,033	174.56	1.63
gc remote grants	869,956	240.65	2.25
gcs messages sent	4,043,799	1,118.63	10.45
ges messages sent	152,855	42.28	0.39
global enqueue get time	4,460	1.23	0.01
global enqueue gets async	15,741	4.35	0.04
global enqueue gets sync	398,799	110.32	1.03
global enqueue releases	398,793	110.32	1.03
heap block compress	82,719	22.88	0.21
hot buffers moved to head of LRU	19,351	5.35	0.05
immediate (CR) block cleanout applications	5,023	1.39	0.01
immediate (CURRENT) block cleanout applications	6,254	1.73	0.02
index crx upgrade (found)	3	0.00	0.00
index crx upgrade (positioned)	10,754	2.97	0.03
index fast full scans (full)	0	0.00	0.00
index fetch by key	2,081,689	575.85	5.38
index scans kdiixs1	140,538	38.88	0.36
leaf node 90-10 splits	51	0.01	0.00
leaf node splits	700	0.19	0.00
lob reads	226	0.06	0.00
lob writes	5,783	1.60	0.01
lob writes unaligned	5,724	1.58	0.01
logons cumulative	2,605	0.72	0.01
messages received	257,075	71.11	0.66
messages sent	256,883	71.06	0.66
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	102,034,380	28,225.64	263.62
opened cursors cumulative	1,437,325	397.61	3.71
parse count (failures)	0	0.00	0.00
parse count (hard)	9,242	2.56	0.02
parse count (total)	1,425,127	394.23	3.68
parse time cpu	3,442	0.95	0.01
parse time elapsed	14,537	4.02	0.04
physical read IO requests	488,144	135.03	1.26
physical read bytes	12,123,947,008	3,353,831.61	31,323.90
physical read total IO requests	542,786	150.15	1.40
physical read total bytes	13,277,326,336	3,672,889.43	34,303.82
physical read total multi block requests	163,500	45.23	0.42
physical reads	1,479,685	409.32	3.82
physical reads cache	1,479,153	409.18	3.82
physical reads cache prefetch	1,014,189	280.55	2.62
physical reads direct	821	0.23	0.00
physical reads direct (lob)	451	0.12	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	64,305	17.79	0.17
physical write bytes	760,102,912	210,266.28	1,963.83
physical write total IO requests	612,720	169.50	1.58
physical write total bytes	2,004,126,720	554,398.96	5,177.94
physical write total multi block requests	439,004	121.44	1.13
physical writes	92,786	25.67	0.24
physical writes direct	396	0.11	0.00
physical writes direct (lob)	293	0.08	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	92,390	25.56	0.24
physical writes non checkpoint	22,152	6.13	0.06
pinned buffers inspected	1,445	0.40	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	4,430	1.23	0.01
process last non-idle time	3,610	1.00	0.01
queries parallelized	99	0.03	0.00
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	1,818,405	503.02	4.70
recursive cpu usage	8,691	2.40	0.02
redo blocks read for recovery	0	0.00	0.00
redo blocks written	685,079	189.51	1.77
redo buffer allocation retries	2	0.00	0.00
redo entries	1,009,549	279.27	2.61
redo log space requests	2	0.00	0.00
redo log space wait time	7	0.00	0.00
redo ordering marks	10,985	3.04	0.03
redo size	293,566,448	81,208.90	758.47
redo subscn max counts	3,818	1.06	0.01
redo synch time	50,844	14.06	0.13
redo synch writes	315,729	87.34	0.82
redo wastage	45,924,924	12,704.15	118.65
redo write time	18,582	5.14	0.05
redo writer latching time	28	0.01	0.00
redo writes	208,649	57.72	0.54
rollback changes - undo records applied	316	0.09	0.00
rollbacks only - consistent read gets	7,557	2.09	0.02
rows fetched via callback	738,127	204.19	1.91
session connect time	0	0.00	0.00
session cursor cache hits	1,129,424	312.43	2.92
session logical reads	110,082,762	30,452.05	284.41
session pga memory	1,109,976,216	307,051.27	2,867.78
session pga memory max	13,203,827,160	3,652,557.45	34,113.92
session uga memory	8,672,577,888	2,399,083.89	22,406.81
session uga memory max	1,747,301,672	483,353.78	4,514.40
shared hash latch upgrades - no wait	319,570	88.40	0.83
shared hash latch upgrades - wait	186	0.05	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	44,626	12.34	0.12
sorts (rows)	2,839,959	785.61	7.34
sql area evicted	13,231	3.66	0.03
sql area purged	0	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	772	0.21	0.00
table fetch by rowid	12,391,975	3,427.98	32.02
table fetch continued row	4,261,487	1,178.85	11.01
table scan blocks gotten	81,031,762	22,415.71	209.36
table scan rows gotten	6,041,465,453	1,671,242.69	15,608.96
table scans (long tables)	24,745	6.85	0.06
table scans (rowid ranges)	24,730	6.84	0.06
table scans (short tables)	593,884	164.29	1.53
total number of times SMON posted	32	0.01	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction lock foreground wait time	0	0.00	0.00
transaction rollbacks	92	0.03	0.00
transaction tables consistent read rollbacks	6	0.00	0.00
transaction tables consistent reads - undo records applied	1,361	0.38	0.00
undo change vector size	94,928,500	26,259.95	245.26
user I/O wait time	37,358	10.33	0.10
user calls	3,881,622	1,073.77	10.03
user commits	314,395	86.97	0.81
user rollbacks	72,656	20.10	0.19
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	39,791	11.01	0.10
write clones created in background	0	0.00	0.00
write clones created in foreground	13	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	290,855,481	290,862,826
opened cursors current	2,774	2,807
logons current	424	425

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	1	1.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
PERFORMANCE	459,224	127	0.83	3.16	42,846	12	604	0.13
MWS_APP	25,118	7	0.45	1.00	4	0	0	0.00
STATDATA	2,330	1	4.24	1.08	18,100	5	440	0.36
UNDOTBS2	8	0	7.50	1.00	1,557	0	84	0.00
MWS_RTM	65	0	6.31	1.00	572	0	651	0.05
SYSTEMDATA	617	0	0.60	1.00	9	0	0	0.00
SYSAUX	230	0	5.57	1.00	377	0	0	0.00
MWS_SYS	114	0	6.14	1.00	444	0	510	0.02
MWS_FILE	331	0	0.36	1.00	1	0	0	0.00
SYSTEM	18	0	5.56	1.00	267	0	215	0.65
RESOURCEDATA	56	0	0.71	1.00	1	0	0	0.00
USERS	13	0	4.62	1.00	2	0	0	0.00
UNDOTBS1	4	0	5.00	1.00	3	0	0	0.00
RECALCULATEDATA	3	0	6.67	1.00	2	0	0	0.00
CONFIGURATIONDATA	1	0	20.00	1.00	1	0	0	0.00
COSS3	1	0	20.00	1.00	1	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
CONFIGURATIONDATA	/dev/rlv_imscfgdata_1	1	0	20.00	1.00	1	0	0	0.00
COSS3	/dev/rlv_imscoss3_1g	1	0	20.00	1.00	1	0	0	0.00
MWS_APP	/dev/rims_d1g_03	25,081	7	0.44	1.00	1	0	0	0.00
MWS_APP	/dev/rims_d1g_06	36	0	1.11	1.00	2	0	0	0.00
MWS_APP	/dev/rims_d1g_12	1	0	20.00	1.00	1	0	0	0.00
MWS_FILE	/dev/rims_d5g_04	331	0	0.36	1.00	1	0	0	0.00
MWS_RTM	/dev/rims_d1g_02	1	0	20.00	1.00	74	0	1	0.00
MWS_RTM	/dev/rims_d1g_04	3	0	6.67	1.00	79	0	85	0.12
MWS_RTM	/dev/rims_d1g_05	3	0	6.67	1.00	52	0	500	0.04
MWS_RTM	/dev/rims_d5g_05	58	0	6.03	1.00	367	0	65	0.00
MWS_SYS	/dev/rims_d1g_01	23	0	0.87	1.00	24	0	283	0.00
MWS_SYS	/dev/rims_d1g_07	3	0	6.67	1.00	3	0	0	0.00
MWS_SYS	/dev/rims_d1g_09	1	0	10.00	1.00	1	0	0	0.00
MWS_SYS	/dev/rims_d1g_10	1	0	20.00	1.00	1	0	0	0.00
MWS_SYS	/dev/rims_d1g_11	1	0	20.00	1.00	1	0	0	0.00
MWS_SYS	/dev/rims_d1g_13	1	0	10.00	1.00	7	0	0	0.00
MWS_SYS	/dev/rims_d1g_14	1	0	10.00	1.00	19	0	8	0.00
MWS_SYS	/dev/rims_d5g_06	83	0	7.11	1.00	388	0	219	0.05
PERFORMANCE	/dev/rims_d10g_01	8,956	2	1.34	5.00	394	0	3	0.00
PERFORMANCE	/dev/rims_d10g_02	6,974	2	1.40	6.35	324	0	5	0.00
PERFORMANCE	/dev/rims_d10g_04	3,802	1	1.13	6.64	42	0	0	0.00
PERFORMANCE	/dev/rims_d10g_13	13,833	4	0.53	1.90	514	0	8	0.00
PERFORMANCE	/dev/rims_d20g_01	10,724	3	1.33	6.20	385	0	0	0.00
PERFORMANCE	/dev/rims_d20g_02	11,928	3	1.07	5.29	532	0	5	0.00
PERFORMANCE	/dev/rims_d20g_04	9,874	3	1.08	5.31	41	0	0	0.00
PERFORMANCE	/dev/rims_d20g_06	6,046	2	1.06	4.98	26	0	0	0.00
PERFORMANCE	/dev/rims_d20g_07	6,622	2	1.02	5.50	49	0	0	0.00
PERFORMANCE	/dev/rims_d20g_08	47,450	13	0.88	3.36	306	0	6	0.00
PERFORMANCE	/dev/rims_d20g_10	74,331	21	0.82	3.13	1,010	0	11	0.00
PERFORMANCE	/dev/rims_d20g_11	88,199	24	0.79	2.80	8,578	2	75	0.00
PERFORMANCE	/dev/rims_d20g_12	80,470	22	0.77	2.70	18,031	5	293	0.20
PERFORMANCE	/dev/rims_d20g_15	65,384	18	0.78	2.43	7,356	2	31	0.00
PERFORMANCE	/dev/rims_d20g_16	24,631	7	0.57	1.88	5,258	1	167	0.12
RECALCULATEDATA	/dev/rims_d10g_05	3	0	6.67	1.00	2	0	0	0.00
RESOURCEDATA	/dev/rims_d5g_01	56	0	0.71	1.00	1	0	0	0.00
STATDATA	/dev/rims_d10g_03	562	0	0.60	1.00	1	0	0	0.00
STATDATA	/dev/rims_d10g_11	39	0	5.13	1.31	147	0	0	0.00
STATDATA	/dev/rims_d20g_03	233	0	4.08	1.25	45	0	0	0.00
STATDATA	/dev/rims_d20g_05	325	0	5.48	1.19	2,677	1	82	0.61
STATDATA	/dev/rims_d20g_09	303	0	5.45	1.11	3,661	1	23	0.87
STATDATA	/dev/rims_d20g_13	271	0	5.83	1.03	3,195	1	91	0.00
STATDATA	/dev/rims_d20g_14	295	0	5.42	1.01	3,614	1	30	0.33
STATDATA	/dev/rims_d20g_17	302	0	5.86	1.00	4,760	1	214	0.37
SYSAUX	/dev/rims_sysaux4g	230	0	5.57	1.00	377	0	0	0.00
SYSTEM	/dev/rims_system4g	18	0	5.56	1.00	267	0	215	0.65
SYSTEMDATA	/dev/rims_d10g_08	3	0	6.67	1.00	2	0	0	0.00
SYSTEMDATA	/dev/rims_d10g_09	14	0	2.14	1.00	2	0	0	0.00
SYSTEMDATA	/dev/rims_d10g_10	452	0	0.40	1.00	1	0	0	0.00
SYSTEMDATA	/dev/rims_d10g_12	1	0	20.00	1.00	1	0	0	0.00
SYSTEMDATA	/dev/rims_d1g_08	3	0	6.67	1.00	2	0	0	0.00
SYSTEMDATA	/dev/rims_d5g_02	144	0	0.69	1.00	1	0	0	0.00
UNDOTBS1	/dev/rims_d10g_06	3	0	0.00	1.00	2	0	0	0.00
UNDOTBS1	/dev/rims_undotbs1	1	0	20.00	1.00	1	0	0	0.00
UNDOTBS2	/dev/rims_d10g_07	4	0	5.00	1.00	397	0	16	0.00
UNDOTBS2	/dev/rims_undotbs2	4	0	10.00	1.00	1,160	0	68	0.00
USERS	/dev/rims_d5g_03	12	0	3.33	1.00	1	0	0	0.00
USERS	/dev/rims_users01	1	0	20.00	1.00	1	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	1,195,104	99	109,923,392	1,479,161	92,254	0	0	2,510

Advisory Statistics

Instance Recovery Stats
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	5	5838	53596	338152	943650	338152
E	0	5	6766	65765	342610	943650	342610

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	992	0.10	118,978	1.33	50,360,322,188
D	1,984	0.20	237,956	1.29	48,961,054,322
D	2,976	0.30	356,934	1.25	47,565,682,097
D	3,968	0.40	475,912	1.22	46,182,390,612
D	4,960	0.50	594,890	1.18	44,810,000,245
D	5,952	0.60	713,868	1.14	43,446,615,086
D	6,944	0.70	832,846	1.11	42,090,567,132
D	7,936	0.79	951,824	1.07	40,740,452,511
D	8,928	0.89	1,070,802	1.04	39,395,122,426
D	9,920	0.99	1,189,780	1.00	38,053,632,980
D	9,984	1.00	1,197,456	1.00	37,967,282,150
D	10,912	1.09	1,308,758	0.97	36,715,194,994
D	11,904	1.19	1,427,736	0.93	35,379,153,128
D	12,896	1.29	1,546,714	0.90	34,044,938,461
D	13,888	1.39	1,665,692	0.86	32,712,081,128
D	14,880	1.49	1,784,670	0.83	31,380,158,177
D	15,872	1.59	1,903,648	0.79	30,048,791,567
D	16,864	1.69	2,022,626	0.76	28,717,643,317
D	17,856	1.79	2,141,604	0.72	27,386,422,691
D	18,848	1.89	2,260,582	0.69	26,054,921,574
D	19,840	1.99	2,379,560	0.65	24,723,005,741

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	3,211	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	3,000	2,057	1,571.66	0.00	0.00	0.00	0.00	307,200
E	3,000	2,035	1,549.45	0.00	0.00	0.00	0.00	307,200

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	35,990	35,990
64K	128K	97	97
128K	256K	147	147
256K	512K	310	310
512K	1024K	2,711	2,711
1M	2M	451	451
2M	4M	26	26
4M	8M	28	28

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
375	0.13	146,444,535.76	238,235,695.88	38.00	1,607,559
750	0.25	146,444,535.76	1,949,657.83	99.00	39
1,500	0.50	146,444,535.76	241,430.98	100.00	0
2,250	0.75	146,444,535.76	224,642.85	100.00	0
3,000	1.00	146,444,535.76	223,449.32	100.00	0
3,600	1.20	146,444,535.76	62,770.67	100.00	0
4,200	1.40	146,444,535.76	62,770.67	100.00	0
4,800	1.60	146,444,535.76	62,770.67	100.00	0
5,400	1.80	146,444,535.76	62,770.67	100.00	0
6,000	2.00	146,444,535.76	62,770.67	100.00	0
9,000	3.00	146,444,535.76	62,770.67	100.00	0
12,000	4.00	146,444,535.76	62,770.67	100.00	0
18,000	6.00	146,444,535.76	62,770.67	100.00	0
24,000	8.00	146,444,535.76	62,770.67	100.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
752	0.19	451	24,040	130,062,148	0.92	21,827,141	2.19	4,025,028,787
1,152	0.29	834	49,743	131,758,105	0.93	20,131,184	2.02	4,027,560,616
1,552	0.39	1,232	81,024	133,387,020	0.94	18,502,269	1.86	4,030,063,727
1,952	0.49	1,631	113,474	134,944,034	0.95	16,945,255	1.70	4,032,548,908
2,352	0.60	2,030	145,152	136,444,989	0.96	15,444,300	1.55	4,035,022,061
2,752	0.70	2,429	176,166	137,883,409	0.97	14,005,880	1.40	4,037,489,880
3,152	0.80	2,828	204,601	139,274,459	0.98	12,614,830	1.27	4,039,958,324
3,552	0.90	3,225	229,028	140,616,940	0.99	11,272,349	1.13	4,042,430,931
3,952	1.00	3,619	250,153	141,917,677	1.00	9,971,612	1.00	4,044,907,569
4,352	1.10	4,015	273,934	143,181,332	1.01	8,707,957	0.87	4,047,385,701
4,752	1.20	4,413	295,756	144,407,625	1.02	7,481,664	0.75	4,049,884,220
5,152	1.30	4,808	312,117	145,601,075	1.03	6,288,214	0.63	4,052,379,907
5,552	1.40	5,207	330,573	146,765,564	1.03	5,123,725	0.51	4,054,843,531
5,952	1.51	5,606	361,496	147,905,327	1.04	3,983,962	0.40	4,057,317,236
6,352	1.61	6,005	387,749	149,024,589	1.05	2,864,700	0.29	4,059,771,023
6,752	1.71	6,404	407,783	150,128,559	1.06	1,760,730	0.18	4,062,218,881
7,152	1.81	6,803	431,339	151,222,632	1.07	666,657	0.07	4,064,683,824
7,552	1.91	7,201	449,744	152,311,494	1.07	1	0.00	4,067,130,908
7,952	2.01	7,952	518,310	153,399,543	1.08	1	0.00	4,069,572,468

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
3,500	0.25	122,711,537	45,427,852,548
7,000	0.50	110,449,496	45,427,852,548
10,500	0.75	104,272,911	42,906,825,044
14,000	1.00	101,255,496	37,967,281,695
17,500	1.25	97,731,806	34,246,488,089
21,000	1.50	94,147,362	29,508,171,333
24,500	1.75	91,899,491	25,905,076,300
28,000	2.00	91,747,608	22,301,981,268

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	2,370	0	0
1st level bmb	55	0	0
undo header	51	0	0
undo block	33	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data
ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
PS-PX Process Reservation	8,862	7,795	1,048	2,572	3	1.15
TX-Transaction (row lock contention)	681	654	0	617	3	4.31
TX-Transaction (index contention)	336	328	0	226	1	2.74
CF-Controlfile Transaction	8,618	8,618	0	99	0	0.49
FB-Format Block	121	121	0	83	0	0.53
HW-Segment High Water Mark	749	749	0	6	0	1.67
WF-AWR Flush	19	19	0	14	0	0.36
TA-Instance Undo	24	24	0	11	0	0.45
IR-Instance Recovery	14	14	0	6	0	0.50
TM-DML	318,065	317,504	0	6	0	0.50
US-Undo Segment	3	3	0	3	0	1.00
PE-Parameter	2,951	2,951	0	2	0	1.00
PG-Global Parameter	6	6	0	2	0	0.50
DR-Distributed Recovery	2	2	0	1	0	1.00
PW-Buffer Cache PreWarm (flush prewarm buffers)	1	0	1	1	0	1.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
5	15.50	379,487	173	28	5760/5760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
02-Aug 07:03	2,516	65,303	68	17	5,760	0/0	0/0/0/0/0/0
02-Aug 06:53	2,103	53,282	173	28	5,760	0/0	0/0/0/0/0/0
02-Aug 06:43	2,469	49,200	36	8	5,760	0/0	0/0/0/0/0/0
02-Aug 06:33	2,078	52,590	0	12	5,760	0/0	0/0/0/0/0/0
02-Aug 06:23	1,966	51,211	52	17	5,760	0/0	0/0/0/0/0/0
02-Aug 06:13	2,028	51,875	68	8	5,760	0/0	0/0/0/0/0/0
02-Aug 06:03	2,338	56,026	63	13	5,760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	3,356	0.00		0	0
AWR Alerted Metric Element list	38,833	0.00		0	0
Consistent RBA	208,566	0.00	0.00	0	0
FAL request queue	74	0.00		0	0
FAL subheap alocation	74	0.00		0	0
FIB s.o chain latch	22	0.00		0	0
FOB s.o list latch	2,860	0.49	0.00	0	0
JS broadcast add buf latch	828	0.00		0	0
JS broadcast drop buf latch	829	0.00		0	0
JS broadcast load blnc latch	725	0.00		0	0
JS mem alloc latch	35	0.00		0	0
JS queue access latch	35	0.00		0	0
JS queue state obj latch	26,134	0.00		0	0
JS slv state obj latch	12	0.00		0	0
KCL gc element parent latch	9,535,563	0.01	0.01	0	19,109	0.25
KJC message pool free list	328,408	0.02	0.00	0	69,694	0.02
KJCT flow control latch	3,039,090	0.01	0.00	0	0
KMG MMAN ready and startup request latch	1,250	0.00		0	0
KMG resize request state object freelist	12	0.00		0	0
KTF sga latch	24	0.00		0	1,062	0.00
KWQMN job cache list latch	265	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	117	2.56	0.00	0	1,244	0.00
OS process	5,547	0.00		0	0
OS process allocation	4,851	0.19	0.00	0	0
OS process: request allocation	2,542	0.55	0.00	0	0
PL/SQL warning settings	2,941	0.00		0	0
SGA IO buffer pool latch	52,747	0.00		0	52,747	0.00
SQL memory manager latch	1	0.00		0	1,204	0.00
SQL memory manager workarea list latch	123,931	0.12	0.00	0	0
Shared B-Tree	127	0.00		0	0
active checkpoint queue latch	17,727	0.06	0.00	0	0
active service list	21,507	4.86	0.11	0	1,318	0.00
archive control	134	0.00		0	0
archive process latch	1,354	0.00		0	0
begin backup scn array	256	0.00		0	0
buffer pool	9	0.00		0	0
business card	194	0.00		0	0
cache buffer handles	4,075	0.00		0	0
cache buffers chains	224,596,743	1.79	0.00	36	10,484,988	0.01
cache buffers lru chain	1,400,129	0.03	0.00	0	6,922,800	0.02
cache table scan latch	0			0	163,123	0.04
channel handle pool latch	2,588	0.35	0.00	0	0
channel operations parent latch	803,079	0.00	0.00	0	0
checkpoint queue latch	536,716	0.00	0.00	0	100,609	0.03
client/application info	13,260	0.00		0	0
compile environment latch	2,938	0.00		0	0
dml lock allocation	636,712	1.90	0.00	0	0
dummy allocation	5,875	4.09	0.00	0	0
enqueue hash chains	2,166,428	0.65	0.00	0	567	0.35
enqueues	633,107	1.20	0.00	0	0
error message lists	4,003	0.87	0.00	0	0
event group latch	1,245	0.00		0	0
file cache latch	884	0.00		0	0
gcs opaque info freelist	493,962	0.08	0.00	0	0
gcs partitioned table hash	31,455,120	0.00		0	0
gcs remaster request queue	7	0.00		0	0
gcs remastering latch	7,344,484	0.00	14.00	0	0
gcs resource freelist	2,246,824	0.01	0.00	0	1,690,901	0.00
gcs resource hash	10,265,173	0.02	0.00	0	0
gcs shadows freelist	1,920,385	0.00	0.00	0	1,876,724	0.00
ges caches resource lists	660,732	0.09	0.00	0	509,606	0.02
ges deadlock list	27,216	0.01	0.00	0	15	0.00
ges domain table	782,316	0.01	0.00	0	0
ges enqueue table freelist	887,942	0.09	0.00	0	0
ges group table	1,169,493	0.06	0.00	0	0
ges process hash list	116,259	0.00		0	0
ges process parent latch	1,745,730	0.00	0.00	0	0
ges process table freelist	2,542	0.39	0.00	0	0
ges resource hash list	1,341,917	1.37	0.01	1	43,008	0.10
ges resource scan list	1,688	0.00		0	0
ges resource table freelist	146,828	0.00	0.00	0	0
ges synchronous data	192	1.56	0.00	0	13,085	0.09
ges timeout list	14,972	0.00		0	15,311	0.00
global KZLD latch for mem in SGA	969	0.00		0	0
global hanganlyze operation	2	0.00		0	0
hash table column usage latch	1,246	0.48	0.00	0	377,104	0.00
hash table modification latch	234	0.00		0	0
job workq parent latch	0			0	4	0.00
job_queue_processes parameter latch	62	0.00		0	0
kks stats	65,819	0.23	0.00	0	0
kokc descriptor allocation latch	2	0.00		0	0
ksuosstats global area	243	0.00		0	0
ktm global data	774	0.00		0	0
kwqbsn:qsga	127	0.00		0	0
lgwr LWN SCN	214,288	0.04	0.00	0	0
library cache	2,250,671	0.80	0.00	0	76,245	0.06
library cache load lock	6,887	0.54	0.00	0	1	0.00
library cache lock	1,390,320	0.29	0.00	0	0
library cache lock allocation	6,241	0.00		0	0
library cache pin	222,157	0.06	0.00	0	2	0.00
library cache pin allocation	4,107	0.02	0.00	0	0
list of block allocation	283	0.35	0.00	0	0
loader state object freelist	1,218	0.00		0	0
longop free list parent	14	0.00		0	14	0.00
message pool operations parent latch	1,395	0.00		0	0
messages	877,603	0.25	0.01	0	0
mostly latch-free SCN	217,622	0.93	0.01	0	0
multiblock read objects	576,330	0.01	0.00	0	0
name-service memory objects	23,726	0.09	0.00	0	1	0.00
name-service namespace bucket	43,335	0.00		0	0
name-service pending queue	17,020	0.00		0	0
name-service request	1,856	1.99	0.00	0	0
name-service request queue	52,463	0.05	0.00	0	0
ncodef allocation latch	64	0.00		0	0
object queue header heap	8,235	0.00		0	8,210	0.00
object queue header operation	4,116,072	0.01	0.16	0	2,865	0.10
object stats modification	1	0.00		0	0
parallel query alloc buffer	403,537	7.28	0.00	1	0
parallel query stats	1,929	17.73	0.00	0	0
parallel txn reco latch	4,209	0.00		0	0
parameter list	7,514	0.00		0	0
parameter table allocation management	2,946	32.96	0.07	0	0
post/wait queue	368,316	0.36	0.00	0	318,641	0.68
process allocation	30,174	0.01	0.00	0	1,245	0.00
process group creation	2,542	0.24	0.00	0	0
process queue	161,183	0.09	0.01	0	0
process queue reference	47,907,465	0.00	0.01	0	448,451	2.38
qmn task queue latch	520	0.00		0	0
query server freelists	191,762	20.17	0.00	0	0
query server process	274	0.00		0	297	10.10
queued dump request	17,213	0.00		0	0
redo allocation	657,198	0.34	0.00	0	1,003,779	1.83
redo copy	0			0	1,009,314	0.94
redo writing	660,894	0.00	0.00	0	0
resmgr group change latch	2,887	0.00		0	0
resmgr:active threads	5,872	0.00		0	0
resmgr:actses change group	2,603	0.00		0	0
resmgr:free threads list	5,871	6.52	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	4,224,616	0.68	0.00	0	10,407	0.08
sequence cache	83,836	0.03	0.00	0	0
session allocation	1,002,546	1.65	0.00	0	0
session idle bit	8,201,690	0.06	0.00	0	0
session state list latch	5,932	3.42	0.00	0	0
session switching	64	0.00		0	0
session timer	1,318	0.00		0	0
shared pool	817,249	2.32	0.01	1	0
shared pool simulator	1,606,743	0.01	0.04	0	0
simulator hash latch	7,299,088	0.01	0.02	0	0
simulator lru latch	495	0.00		0	7,116,519	2.45
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	0	0
sort extent pool	868	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
threshold alerts latch	274	0.00		0	0
transaction allocation	316,268	0.00		0	0
transaction branch allocation	1,318	0.00		0	0
undo global data	1,109,950	0.11	0.00	0	0
user lock	4,360	0.30	0.00	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	224,596,743	4,015,264	4,554	4,011,028
parallel query alloc buffer	403,537	29,381	121	29,261
shared pool	817,249	18,926	213	18,719
ges resource hash list	1,341,917	18,336	142	18,196
library cache	2,250,671	18,031	12	18,019
session allocation	1,002,546	16,523	24	16,499
enqueue hash chains	2,166,428	14,020	7	14,013
dml lock allocation	636,712	12,127	7	12,120
session idle bit	8,201,690	4,609	19	4,591
library cache lock	1,390,320	4,009	1	4,008
redo allocation	657,198	2,261	2	2,259
messages	877,603	2,153	11	2,142
mostly latch-free SCN	217,622	2,023	22	2,001
gcs resource hash	10,265,173	1,703	3	1,700
KCL gc element parent latch	9,535,563	1,381	8	1,374
active service list	21,507	1,046	117	934
parameter table allocation management	2,946	971	71	902
simulator hash latch	7,299,088	402	8	395
process queue reference	47,907,465	337	4	334
object queue header operation	4,116,072	268	44	231
process queue	161,183	143	1	142
shared pool simulator	1,606,743	98	4	94
gcs remastering latch	7,344,484	3	42	1
slave class create	8	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
KCL gc element parent latch	kclliter	274	0
KCL gc element parent latch	kclrwrite	4	0
KCL gc element parent latch	kclnfndnewm	3	96
KCL gc element parent latch	KCLUNLNK	2	81
KCL gc element parent latch	kclevict	1	0
KCL gc element parent latch	kclplz	1	2
Memory Management Latch	kmgs_perform_parameter_updates1	2	0
active service list	ksws_event: ksws event	115	116
active service list	kswsgsnp: get service name ptr	53	50
cache buffers chains	kcbgtcr: kslbegin excl	5,472	5,789
cache buffers chains	kcbrls: kslbegin	1,550	1,288
cache buffers chains	kcbchg: kslbegin: bufs not pinned	266	213
cache buffers chains	kcbgtcr: fast path	105	14
cache buffers chains	kcbgcur: kslbegin	55	26
cache buffers chains	kcbget: pin buffer	26	12
cache buffers chains	kcbzwb	15	7
cache buffers chains	kclexpand	11	0
cache buffers chains	kclobj_1	10	0
cache buffers chains	kcbnlc	5	21
cache buffers chains	kclwrt	3	0
cache buffers chains	kcbget: exchange rls	2	2
cache buffers chains	kcbcge	1	12
cache buffers chains	kcbchg: kslbegin: call CR func	1	129
cache buffers chains	kcbzgb: scan from tail. nowait	1	0
cache buffers chains	kcbzib: multi-block read: nowait	1	0
cache buffers chains	kclgrantlk_1	1	0
dml lock allocation	ktaidm	4	1
dml lock allocation	ktaiam	3	6
enqueue hash chains	ksqcmi: if lk mode requested	4	0
enqueue hash chains	ksqgtl3	3	4
gcs remastering latch	59	41	0
gcs remastering latch	69	1	0
gcs resource hash	kjbmpopen	2	0
gcs resource hash	kjbcropen	1	0
ges resource hash list	kjucvl: lock convert request	57	11
ges resource hash list	kjlrlr: remove lock from resource queue	37	56
ges resource hash list	kjrref: find matched resource	22	75
ges resource hash list	kjrmas1: lookup master node	20	0
ges resource hash list	kjakcai: search for resp by resname	5	0
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	1	0
library cache	kglLockCursor	4	0
library cache	kqlmbinv: parent	3	0
library cache	kgldte: child 0	1	5
library cache	kglic	1	0
library cache lock	kgllkal: child: multiinstance	1	1
library cache lock	kgllkdl: child: no lock handle	1	1
messages	ksaamb: after wakeup	10	10
messages	ksarcv	1	1
mostly latch-free SCN	kcslcu3	22	22
object queue header operation	kclobj_1	53	26
object queue header operation	kcbo_switch_cq	3	8
object queue header operation	kcbo_switch_mq_bg	2	16
parallel query alloc buffer	kxfpbfre	114	109
parallel query alloc buffer	kxfpbalo	7	12
parameter table allocation management	ksp_param_table_free	71	71
process queue	kxfpqsnd: KSLBEGIN	1	1
process queue reference	kxfpqrsnd	4	0
redo allocation	kcrfw_redo_gen: redo allocation 3	1	1
redo allocation	kcrfw_redo_write: before write	1	1
session allocation	ksursi	16	16
session allocation	ksuxds: KSUSFCLC not set	6	7
session allocation	kxfpqidqr	2	0
session idle bit	ksupuc: clear busy	14	14
session idle bit	ksupuc: set busy	11	10
session idle bit	ksuxds	5	6
shared pool	kghfre	135	185
shared pool	kghalo	74	14
shared pool	kghfrunp: clatch: nowait	2	0
shared pool	kghupr1	2	11
shared pool	kghalp	1	3
shared pool	kghfrunp: alloc: wait	1	0
shared pool simulator	kglsim_unpin_simhp	3	0
shared pool simulator	kglsim_scan_lru: scan	1	2
simulator hash latch	kcbsacc: lookup dba	8	8
slave class create	ksvcreate	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits
Segments by Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received

Segments by Logical Reads

Total Logical Reads: 110,082,762
Captured Segments account for 94.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
RESOURCEDBA	RESOURCEDATA	OBJECT	TABLE	51,080,240	46.40
MW_SYS	MWS_RTM	MWT_IS_ULOG	TABLE	21,758,416	19.77
PERFORMANCEDBA	PERFORMANCE	MESSAGEKEYWORD	TABLE	3,566,816	3.24
PERFORMANCEDBA	PERFORMANCE	CPUSAVGLOAD5MIN	TABLE	3,374,480	3.07
PERFORMANCEDBA	PERFORMANCE	MEMLOAD5MIN	TABLE	3,371,296	3.06

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 1,479,685
Captured Segments account for 98.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
PERFORMANCEDBA	PERFORMANCE	MEMLOAD5MIN	TABLE	465,885	31.49
PERFORMANCEDBA	PERFORMANCE	L2LINKTOTALFLOW5MIN	TABLE	395,906	26.76
PERFORMANCEDBA	PERFORMANCE	L2LINKTOTALBANDWIDTHUR5MIN	TABLE	312,443	21.12
PERFORMANCEDBA	PERFORMANCE	CPUSAVGLOAD5MIN	TABLE	270,888	18.31
PERFORMANCEDBA	PERFORMANCE	ALERTINFORMTEMP	TABLE	2,901	0.20

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
MW_SYS	MWS_RTM	MWT_IS_ULOG	TABLE	714	43.78
MW_SYS	MWS_SYS	MWT_IS_LOGIN	TABLE	584	35.81
MW_SYS	MWS_SYS	PK_MWT_IS_MDLADT	INDEX	122	7.48
STATDBA	STATDATA	P_T_PROTALHOMECODE	INDEX	93	5.70
MW_SYS	MWS_RTM	MWT_ULOG_USERID	INDEX	39	2.39

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
MW_SYS	MWS_RTM	MWT_IS_ULOG	TABLE	501	23.68
MW_SYS	MWS_SYS	MWT_IS_LOGIN	TABLE	283	13.37
PERFORMANCEDBA	PERFORMANCE	CPUSAVGLOAD5MIN	TABLE	253	11.96
MW_SYS	MWS_SYS	PK_MWT_IS_MDLADT	INDEX	219	10.35
STATDBA	STATDATA	P_T_PROTALHOMECODE	INDEX	184	8.70

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

% of Capture shows % of GC Buffer Busy for each top segment compared
with GC Buffer Busy for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	GC Buffer Busy	% of Capture
SYS	SYSTEM	I_OBJ2	INDEX	215	86.69
STATDBA	STATDATA	T_ONLINECOUNTREAL	TABLE	19	7.66
STATDBA	STATDATA	T_BUSINESSDAYLOGINNUM	TABLE	6	2.42
STATDBA	STATDATA	T_BUSINESSVISITCOUNT	TABLE	5	2.02
STATDBA	STATDATA	P_T_ONLINECOUNTREAL	INDEX	1	0.40

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 9,084
Captured Segments account for 69.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSTEM	HIST_HEAD$	TABLE	846	9.31
STATDBA	STATDATA	T_BSRUNNINGTIME	TABLE	555	6.11
STATDBA	STATDATA	T_ONLINECOUNTREAL	TABLE	537	5.91
STATDBA	STATDATA	T_PROTALHOMESTATUS	TABLE	414	4.56
SYS	SYSTEM	TAB$	TABLE	413	4.55

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 257,801
Captured Segments account for 98.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
PERFORMANCEDBA	PERFORMANCE	L2LINKOUTDROPPACKETRATE5MIN	TABLE	133,664	51.85
PERFORMANCEDBA	PERFORMANCE	L2LINKTOTALBANDWIDTHUR5MIN	TABLE	76,793	29.79
PERFORMANCEDBA	PERFORMANCE	CPUSAVGLOAD5MIN	TABLE	11,279	4.38
STATDBA	STATDATA	T_ALTTYPNUMSTA	TABLE	10,964	4.25
PERFORMANCEDBA	PERFORMANCE	ALERTINFORMTEMP	TABLE	9,523	3.69

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Dictionary Cache Stats
Dictionary Cache Stats (RAC)

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	62	3.23	0	1
dc_database_links	1,940	0.00	0	1
dc_files	4,503	0.00	0	57
dc_global_oids	6	0.00	0	0
dc_histogram_data	374,774	1.70	0	7,964
dc_histogram_defs	93,948	9.51	0	8,402
dc_object_ids	546,911	0.21	0	2,205
dc_objects	24,464	2.09	5	1,482
dc_profiles	973	0.00	0	1
dc_rollback_segments	6,790	0.00	0	185
dc_segments	336,104	0.53	4	2,657
dc_sequences	1,327	0.75	1,327	6
dc_tablespace_quotas	1	100.00	1	0
dc_tablespaces	96,211	0.00	0	17
dc_usernames	5,974	0.07	0	46
dc_users	140,575	0.00	0	77
outstanding_alerts	102	88.24	0	16

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts	GES Releases
dc_awr_control	2	2	0
dc_histogram_defs	8,938	972	3,966
dc_object_ids	1,127	0	870
dc_objects	521	0	610
dc_segments	1,771	0	463
dc_sequences	2,654	10	0
dc_tablespace_quotas	2	0	2
dc_tablespaces	4	0	4
dc_usernames	4	0	4
outstanding_alerts	204	90	0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Library Cache Activity
Library Cache Activity (RAC)

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	24	0.00	36	0.00	0	0
CLUSTER	12	0.00	30	0.00	0	0
INDEX	5	60.00	15	26.67	1	0
SQL AREA	322,488	5.22	1,629,455	1.52	819	38
TABLE/PROCEDURE	14,670	3.11	129,444	2.66	1,073	0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases	GES Inval Requests
CLUSTER	30	6	5	2
INDEX	15	3	6	7
TABLE/PROCEDURE	33,973	560	644	722

Back to Library Cache Statistics
Back to Top

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

B: Begin snap E: End snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	1,048.05		1.82	9.28	200	200	575	575
	Freeable	369.69	0.00	0.86	1.02	13		430	430
	SQL	152.90	115.56	0.28	6.19	146	146	554	356
	PL/SQL	1.13	0.31	0.00	0.00	0	0	573	425
E	Other	1,060.00		2.03	12.20	262	262	523	523
	Freeable	332.94	0.00	0.85	1.11	13		391	391
	SQL	152.59	114.96	0.30	6.50	146	146	503	320
	PL/SQL	1.13	0.31	0.00	0.00	0	0	521	426

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	10,468,982,784
Fixed Size	2,110,064
Redo Buffers	14,663,680
Variable Size	4,513,074,576

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	0.00
large	PX msg pool	19.24	20.52	6.67
large	free memory	12.76	11.48	-10.05
shared	CCursor	84.72	63.79	-24.70
shared	Cursor Stats	81.74	81.74	0.00
shared	KGH: NO ACCESS	93.65	93.65	0.00
shared	PCursor	65.21	51.04	-21.74
shared	db_block_hash_buckets	45.00	45.00	0.00
shared	free memory	2,171.28	2,182.64	0.52
shared	gcs resources	221.17	221.17	0.00
shared	gcs shadows	393.71	397.69	1.01
shared	ges enqueues	48.48	48.48	0.00
shared	ges resource		46.06
shared	kglsim heap	78.49	78.49	0.00
shared	kglsim object batch	137.77	137.77	0.00
shared	library cache	59.03	48.58	-17.69
shared	sql area	323.05	322.87	-0.06
	buffer_cache	9,984.00	9,984.00	0.00
	fixed_sga	2.01	2.01	0.00
	log_buffer	13.98	13.98	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Apply
Buffered Queues
Buffered Subscribers
Rule Set

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

only rows with Current or Maximum Utilization > 80% of Limit are shown
ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
gcs_resources	858,420	1,076,909	913174	913174
gcs_shadows	913,174	4,221,365	913174	913174
ges_procs	523	997	1001	1001
processes	524	1,000	1000	1000

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/product/10.2.0/db_1/admin/imscmdb/adump
background_dump_dest	/oracle/product/10.2.0/db_1/admin/imscmdb/bdump
cluster_database	TRUE
cluster_database_instances	2
compatible	10.2.0.3.0
control_files	/dev/rims_control01, /dev/rims_control02, /dev/rims_control03
core_dump_dest	/oracle/product/10.2.0/db_1/admin/imscmdb/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	imscmdb
dispatchers	(PROTOCOL=TCP) (SERVICE=imscmdbXDB)
instance_number	2
job_queue_processes	10
local_listener	LISTENER_IMSCMDB
log_archive_dest_1	location=/imsarch2
open_cursors	300
pga_aggregate_target	3145728000
processes	1000
remote_login_passwordfile	EXCLUSIVE
sessions	1105
sga_max_size	14998831104
sga_target	14680064000
spfile	/dev/rims_spfile
thread	2
undo_management	AUTO
undo_retention	0
undo_tablespace	UNDOTBS2
user_dump_dest	/oracle/product/10.2.0/db_1/admin/imscmdb/udump

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	38,351	10.61	0.10
acks for commit broadcast(logical)	51,155	14.15	0.13
broadcast msgs on commit(actual)	208,333	57.63	0.54
broadcast msgs on commit(logical)	208,650	57.72	0.54
broadcast msgs on commit(wasted)	9,060	2.51	0.02
broadcast on commit wait time(ms)	12,009	3.32	0.03
broadcast on commit waits	27,097	7.50	0.07
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	43,008	11.90	0.11
false posts waiting for scn acks	1	0.00	0.00
flow control messages received	4	0.00	0.00
flow control messages sent	2	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	167,484	46.33	0.43
gcs ast xid	0	0.00	0.00
gcs blocked converts	5,961	1.65	0.02
gcs blocked cr converts	89,331	24.71	0.23
gcs compatible basts	32	0.01	0.00
gcs compatible cr basts (global)	1,800	0.50	0.00
gcs compatible cr basts (local)	254,397	70.37	0.66
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	6,162	1.70	0.02
gcs dbwr write request msgs	4,735	1.31	0.01
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	2,440	0.67	0.01
gcs immediate (null) converts	14,381	3.98	0.04
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	1,752,347	484.75	4.53
gcs indirect ast	197,423	54.61	0.51
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	191	0.05	0.00
gcs msgs process time(ms)	234,985	65.00	0.61
gcs msgs received	5,423,241	1,500.22	14.01
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	0	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs queued converts	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	18,036	4.99	0.05
gcs side channel msgs actual	10,884	3.01	0.03
gcs side channel msgs logical	358,629	99.21	0.93
gcs stale cr	118,003	32.64	0.30
gcs undo cr	172	0.05	0.00
gcs write notification msgs	479	0.13	0.00
gcs writes refused	2	0.00	0.00
ges msgs process time(ms)	7,871	2.18	0.02
ges msgs received	140,205	38.78	0.36
global posts dropped	0	0.00	0.00
global posts queue time	0	0.00	0.00
global posts queued	0	0.00	0.00
global posts requested	0	0.00	0.00
global posts sent	0	0.00	0.00
implicit batch messages received	158,758	43.92	0.41
implicit batch messages sent	127,662	35.31	0.33
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	220,249	60.93	0.57
messages queue sent actual	653,086	180.66	1.69
messages queue sent logical	1,526,264	422.21	3.94
messages received actual	1,842,085	509.57	4.76
messages received logical	5,563,473	1,539.02	14.37
messages sent directly	183,124	50.66	0.47
messages sent indirectly	1,180,818	326.65	3.05
messages sent not implicit batched	525,456	145.36	1.36
messages sent pbatched	2,782,107	769.61	7.19
msgs causing lmd to send msgs	106,836	29.55	0.28
msgs causing lms(s) to send msgs	1,707,675	472.39	4.41
msgs received queue time (ms)	1,949,092	539.17	5.04
msgs received queued	5,563,431	1,539.00	14.37
msgs sent queue time (ms)	73,961	20.46	0.19
msgs sent queue time on ksxp (ms)	302,244	83.61	0.78
msgs sent queued	1,507,599	417.05	3.90
msgs sent queued on ksxp	1,203,772	333.00	3.11
process batch messages received	727,738	201.31	1.88
process batch messages sent	643,890	178.12	1.66

Global CR Served Stats

Statistic	Total
CR Block Requests	200,354
CURRENT Block Requests	17,468
Data Block Requests	200,354
Undo Block Requests	157
TX Block Requests	1,154
Current Results	214,202
Private results	0
Zero Results	3,608
Disk Read Results	3
Fail Results	0
Fairness Down Converts	41,393
Fairness Clears	0
Free GC Elements	0
Flushes	5,867
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	442
Errors	0

Global CURRENT Served Stats

Pins = CURRENT Block Pin Operations
Flushes = Redo Flush before CURRENT Block Served Operations
Writes = CURRENT Block Fusion Write Operations

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	1,098,452	100.00	0.00	0.00	0.00	0.00
Flushes	5	60.00	40.00	0.00	0.00	0.00
Writes	7,320	4.45	88.14	6.34	0.11	0.96

Global Cache Transfer Stats

Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays
Busy (Busy) - Block Transfer impacted by Remote Contention
Congested (Congst) - Block Transfer impacted by Remote System Load
ordered by CR + Current Blocks Received desc

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
1	data block	8,231	97.86	2.14	0.00	258,260	99.98	0.00	0.02
1	undo header	792	98.99	1.01	0.00	3	100.00	0.00	0.00
1	Others	70	100.00	0.00	0.00	122	100.00	0.00	0.00

End of Report

% Blocks changed per Read:	1.78	Recursive Call %:	31.90
Rollback per transaction %:	18.77	Rows per Sort:	63.64

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	98.66	In-memory Sort %:	100.00
Library Hit %:	98.40	Soft Parse %:	99.35
Execute to Parse %:	8.80	Latch Hit %:	98.91
Parse CPU to Parse Elapsd %:	23.68	% Non-Parse CPU:	98.46

Buffer access - local cache %:	98.41
Buffer access - remote cache %:	0.24
Buffer access - disk %:	1.34

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.5
Avg global cache current block receive time (ms):	0.8
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 %:	2.7
Avg global cache cr block flush time (ms):	1.3
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.1
Global cache log flushes for current blocks served %:	0.0
Avg global cache current block flush time (ms):	2.0

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.3
Avg message received queue time (ms):	0.4
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.1
% of direct sent messages:	11.56
% of indirect sent messages:	74.54
% of flow controlled messages:	13.90