WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

ODSDB 3367537179 odsdb1 1 10.2.0.4.0 YES cwgkdb1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ODSDB	3367537179	odsdb1	1	10.2.0.4.0	YES	cwgkdb1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 12890 02-3月 -12 03:00:01 131 13.9

End Snap: 12891 02-3月 -12 04:00:54 137 4.7

Elapsed: 60.89 (mins)

DB Time: 1,947.90 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	12890	02-3月 -12 03:00:01	131	13.9
End Snap:	12891	02-3月 -12 04:00:54	137	4.7
Elapsed:		60.89 (mins)
DB Time:		1,947.90 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 8,192M 8,192M Std Block Size: 16K

Shared Pool Size: 4,096M 4,096M Log Buffer: 14,324K

	Begin	End
Buffer Cache:	8,192M	8,192M	Std Block Size:	16K
Shared Pool Size:	4,096M	4,096M	Log Buffer:	14,324K

Load Profile

Per Second Per Transaction

Redo size: 14,725.51 6,414.57

Logical reads: 977.56 425.83

Block changes: 106.85 46.54

Physical reads: 0.07 0.03

Physical writes: 1.01 0.44

User calls: 34.50 15.03

Parses: 59.23 25.80

Hard parses: 1.70 0.74

Sorts: 4.74 2.06

Logons: 0.17 0.07

Executes: 64.35 28.03

Transactions: 2.30

	Per Second	Per Transaction
Redo size:	14,725.51	6,414.57
Logical reads:	977.56	425.83
Block changes:	106.85	46.54
Physical reads:	0.07	0.03
Physical writes:	1.01	0.44
User calls:	34.50	15.03
Parses:	59.23	25.80
Hard parses:	1.70	0.74
Sorts:	4.74	2.06
Logons:	0.17	0.07
Executes:	64.35	28.03
Transactions:	2.30

% Blocks changed per Read: 10.93 Recursive Call %: 86.44

Rollback per transaction %: 55.22 Rows per Sort: 142.81

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 100.00

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

Library Hit %: 95.78 Soft Parse %: 97.13

Execute to Parse %: 7.94 Latch Hit %: 99.90

Parse CPU to Parse Elapsd %: 0.08 % Non-Parse CPU: 92.35

Shared Pool Statistics

Begin End

Memory Usage %: 88.90 89.81

% SQL with executions>1: 78.35 88.51

% Memory for SQL w/exec>1: 81.60 90.43

	Begin	End
Memory Usage %:	88.90	89.81
% SQL with executions>1:	78.35	88.51
% Memory for SQL w/exec>1:	81.60	90.43

Top 5 Timed Events

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

library cache lock 178,417 82,309 461 70.4 Concurrency

library cache load lock 10,072 29,402 2,919 25.2 Concurrency

DFS lock handle 20,192 5,901 292 5.0 Other

enq: CF - contention 4,442 2,104 474 1.8 Other

enq: SQ - contention 714 2,079 2,912 1.8 Configuration

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
library cache lock	178,417	82,309	461	70.4	Concurrency
library cache load lock	10,072	29,402	2,919	25.2	Concurrency
DFS lock handle	20,192	5,901	292	5.0	Other
enq: CF - contention	4,442	2,104	474	1.8	Other
enq: SQ - contention	714	2,079	2,912	1.8	Configuration

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: 2.94 1.28

Global Cache blocks served: 0.89 0.39

GCS/GES messages received: 193.82 84.43

GCS/GES messages sent: 32.85 14.31

DBWR Fusion writes: 0.03 0.01

Estd Interconnect traffic (KB) 105.57

	Per Second	Per Transaction
Global Cache blocks received:	2.94	1.28
Global Cache blocks served:	0.89	0.39
GCS/GES messages received:	193.82	84.43
GCS/GES messages sent:	32.85	14.31
DBWR Fusion writes:	0.03	0.01
Estd Interconnect traffic (KB)	105.57

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

Buffer access - local cache %: 99.69

Buffer access - remote cache %: 0.30

Buffer access - disk %: 0.01

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 808.8

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

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

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

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

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

Global cache log flushes for current blocks served %: 0.1

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0

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

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 31.95

% of indirect sent messages: 31.33

% of flow controlled messages: 36.72

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): 116874.3s
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	76,982.59	65.87
PL/SQL execution elapsed time	71,848.72	61.48
connection management call elapsed time	39,573.82	33.86
parse time elapsed	8,245.05	7.05
sequence load elapsed time	2,968.56	2.54
hard parse elapsed time	670.73	0.57
DB CPU	79.87	0.07
PL/SQL compilation elapsed time	7.26	0.01
repeated bind elapsed time	0.04	0.00
hard parse (sharing criteria) elapsed time	0.03	0.00
failed parse elapsed time	0.00	0.00
DB time	116,874.28
background elapsed time	8,667.14
background cpu time	91.88

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
Concurrency	206,402	86.49	111,993	543	24.61
Other	534,765	91.26	11,268	21	63.76
Configuration	714	99.30	2,079	2912	0.09
System I/O	24,454	0.00	14	1	2.92
Commit	4,448	0.00	7	2	0.53
Cluster	11,231	0.04	5	0	1.34
Application	2,548	0.00	5	2	0.30
User I/O	311	0.00	2	6	0.04
Network	102,438	0.00	0	0	12.21

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
library cache lock	178,417	94.39	82,309	461	21.27
library cache load lock	10,072	99.31	29,402	2919	1.20
DFS lock handle	20,192	59.69	5,901	292	2.41
enq: CF - contention	4,442	96.98	2,104	474	0.53
enq: SQ - contention	714	99.30	2,079	2912	0.09
rdbms ipc reply	12,970	7.56	1,921	148	1.55
enq: DR - contention	2,376	99.92	1,159	488	0.28
row cache lock	12,984	0.65	259	20	1.55
reliable message	226	64.16	141	626	0.03
enq: TD - KTF dump entries	331	15.11	27	83	0.04
latch: library cache	344	0.00	18	51	0.04
log file sync	4,448	0.00	7	2	0.53
log file parallel write	5,769	0.00	6	1	0.69
control file sequential read	15,731	0.00	5	0	1.88
enq: TX - row lock contention	376	0.00	4	12	0.04
enq: WF - contention	27	22.22	4	134	0.00
latch: ges resource hash list	1,102	0.00	4	3	0.13
CGS wait for IPC msg	437,626	100.00	3	0	52.18
library cache pin	4,047	0.00	2	1	0.48
db file sequential read	211	0.00	2	8	0.03
control file parallel write	1,091	0.00	2	1	0.13
enq: TT - contention	128	1.56	1	11	0.02
gc cr block 2-way	3,458	0.00	1	0	0.41
db file parallel write	1,863	0.00	1	1	0.22
latch: row cache objects	40	0.00	1	28	0.00
gc current block busy	32	0.00	1	31	0.00
gc cr multi block request	5,012	0.00	1	0	0.60
gc current block 2-way	2,181	0.00	1	0	0.26
gc buffer busy	36	11.11	1	19	0.00
ksxr poll remote instances	51,916	56.55	0	0	6.19
cursor: pin S wait on X	33	100.00	0	13	0.00
name-service call wait	4	0.00	0	101	0.00
global enqueue expand wait	38	100.00	0	10	0.00
latch: shared pool	263	0.00	0	1	0.03
os thread startup	8	0.00	0	43	0.00
ges inquiry response	1,113	0.00	0	0	0.13
latch free	328	0.00	0	1	0.04
enq: RO - fast object reuse	1,088	0.00	0	0	0.13
gcs log flush sync	430	15.58	0	1	0.05
SQL*Net break/reset to client	920	0.00	0	0	0.11
gc current grant busy	308	0.00	0	0	0.04
SQL*Net message to client	96,378	0.00	0	0	11.49
read by other session	3	0.00	0	29	0.00
enq: TM - contention	164	0.00	0	0	0.02
SQL*Net more data to client	5,182	0.00	0	0	0.62
direct path read	19	0.00	0	3	0.00
buffer busy waits	163	0.00	0	0	0.02
wait for scn ack	44	0.00	0	1	0.01
gc current grant 2-way	87	0.00	0	0	0.01
enq: PI - contention	1	0.00	0	36	0.00
db file scattered read	38	0.00	0	1	0.00
direct path write	40	0.00	0	1	0.00
gc cr grant 2-way	35	0.00	0	1	0.00
LGWR wait for redo copy	296	0.00	0	0	0.04
latch: cache buffers chains	26	0.00	0	1	0.00
enq: PS - contention	27	0.00	0	1	0.00
gc cr block busy	39	0.00	0	1	0.00
enq: TX - index contention	4	0.00	0	4	0.00
IPC send completion sync	55	100.00	0	0	0.01
PX Deq: reap credit	994	97.48	0	0	0.12
enq: MW - contention	2	0.00	0	5	0.00
PX Deq Credit: send blkd	15	73.33	0	1	0.00
SQL*Net more data from client	878	0.00	0	0	0.10
enq: TO - contention	8	0.00	0	0	0.00
gc current multi block request	43	0.00	0	0	0.01
KJC: Wait for msg sends to complete	38	0.00	0	0	0.00
latch: cache buffers lru chain	3	0.00	0	1	0.00
enq: US - contention	3	0.00	0	0	0.00
enq: FB - contention	3	0.00	0	0	0.00
enq: DL - contention	2	0.00	0	1	0.00
enq: TA - contention	1	0.00	0	1	0.00
enq: AF - task serialization	1	0.00	0	1	0.00
latch: object queue header operation	14	0.00	0	0	0.00
PX Deq: Signal ACK	7	28.57	0	0	0.00
latch: undo global data	1	0.00	0	0	0.00
latch: library cache pin	1	0.00	0	0	0.00
latch: KCL gc element parent latch	1	0.00	0	0	0.00
SQL*Net message from client	96,371	0.00	327,810	3402	11.49
gcs remote message	262,899	97.75	7,135	27	31.35
DIAG idle wait	18,269	0.00	3,569	195	2.18
Streams AQ: qmn slave idle wait	129	0.00	3,560	27594	0.02
Streams AQ: qmn coordinator idle wait	279	47.67	3,560	12758	0.03
ges remote message	170,083	83.14	3,545	21	20.28
Streams AQ: waiting for messages in the queue	274	100.00	2,591	9455	0.03
jobq slave wait	512	100.00	1,500	2930	0.06
PX Idle Wait	448	94.64	1,052	2348	0.05
PX Deq: Parse Reply	208	94.71	470	2261	0.02
PX Deq: Join ACK	17	52.94	13	760	0.00
PX Deq: Execution Msg	118	32.20	8	67	0.01
PX Deq: Execute Reply	10	30.00	0	1	0.00
PX Deq: Msg Fragment	23	17.39	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	279	100.00	0	0	0.03
class slave wait	4	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
events in waitclass Other	526,516	91.36	6,761	13	62.78
library cache lock	4,519	44.55	985	218	0.54
row cache lock	11,987	0.10	38	3	1.43
log file parallel write	5,769	0.00	6	1	0.69
control file sequential read	9,266	0.00	3	0	1.10
library cache pin	3,962	0.00	2	1	0.47
control file parallel write	1,039	0.00	2	1	0.12
db file parallel write	1,863	0.00	1	1	0.22
gc cr block 2-way	3,217	0.00	1	0	0.38
gc cr multi block request	4,994	0.00	1	0	0.60
gc current block 2-way	1,915	0.00	1	0	0.23
gc current block busy	22	0.00	1	33	0.00
os thread startup	8	0.00	0	43	0.00
enq: RO - fast object reuse	1,088	0.00	0	0	0.13
enq: TM - contention	148	0.00	0	0	0.02
gc current grant busy	202	0.00	0	0	0.02
db file sequential read	4	0.00	0	10	0.00
gc cr block busy	39	0.00	0	1	0.00
latch: shared pool	5	0.00	0	2	0.00
gc current multi block request	40	0.00	0	0	0.00
direct path write	2	0.00	0	1	0.00
gc current grant 2-way	7	0.00	0	0	0.00
gc buffer busy	17	0.00	0	0	0.00
buffer busy waits	4	0.00	0	0	0.00
latch: cache buffers chains	3	0.00	0	0	0.00
latch: row cache objects	2	0.00	0	0	0.00
rdbms ipc message	114,580	43.23	42,081	367	13.66
gcs remote message	262,903	97.75	7,135	27	31.35
DIAG idle wait	18,269	0.00	3,569	195	2.18
pmon timer	1,257	100.00	3,567	2838	0.15
Streams AQ: qmn slave idle wait	129	0.00	3,560	27594	0.02
Streams AQ: qmn coordinator idle wait	279	47.67	3,560	12758	0.03
ges remote message	170,091	83.14	3,545	21	20.28
smon timer	1,127	0.89	2,729	2422	0.13
PX Deq: Parse Reply	208	94.71	470	2261	0.02
PX Deq: Join ACK	17	52.94	13	760	0.00
PX Deq: Execute Reply	10	30.00	0	1	0.00
Streams AQ: RAC qmn coordinator idle wait	279	100.00	0	0	0.03

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	5,131
AVG_IDLE_TIME	361,034
AVG_IOWAIT_TIME	203
AVG_SYS_TIME	2,244
AVG_USER_TIME	2,783
BUSY_TIME	41,908
IDLE_TIME	2,889,115
IOWAIT_TIME	2,377
SYS_TIME	18,839
USER_TIME	23,069
LOAD	0
OS_CPU_WAIT_TIME	67,100
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,353,105,408
NUM_CPUS	8
NUM_CPU_CORES	4

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
SYS$USERS	116,727.20	72.20	209	755,166
odsdb	147.10	7.70	1	304,709
SYS$BACKGROUND	0.00	0.00	29	2,511,090
ods	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
SYS$USERS	144	43	185120	11055953	92737	14
odsdb	1	1	43	7772	7360	1
SYS$BACKGROUND	165	142	21229	135538	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
71,138	7	12,131	5.86	60.87	a16hu5wzwq421		BEGIN vPD_PKG.SET_CONTEXT_COMP...
7,586	3	588	12.90	6.49	bvskgnk4p3x2w	racgimon@cwgkdb1 (TNS V1-V3)	DECLARE V_PROGRAM VARCHA...
2,021	0	10	202.12	1.73	6aasuxzxky1gh		SELECT HZ_SEQ.NEXTVAL SEQVALUE...
1,440	0	10	143.96	1.23	dqmvgn5svxvcm		BEGIN PA_FMIS_BASE.NEWENTITY(:...
815	3	3	271.59	0.70	gm1wjg2cvyqtv		BEGIN KMDETAILQUERY(:1, :2, :3...
811	0	12	67.62	0.69	d3c7d056xt3cg		INSERT INTO HZ_LOG (LOG_NO, US...
773	0	2	386.72	0.66	c2aw4fq306q4k		INSERT /+ APPEND / INTO WRH$...
692	0	289	2.39	0.59	f67hktj85gdrc		BEGIN vPD_PKG.SET_CONTEXT_COMP...
658	0	1	657.60	0.56	g73tzgnm4722f		select u.name, o.name, trigg...
297	0	3	99.09	0.25	5jxwda6s8nvc7		select tablespace_id, rfno, ...

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
18	20	80	0.23	0.02	gfjvxb25b773h		select o.owner#, o.obj#, decod...
7	71,138	12,131	0.00	60.87	a16hu5wzwq421		BEGIN vPD_PKG.SET_CONTEXT_COMP...
5	7	309	0.02	0.01	0jn5hzudm8han		select * from ( select logeven...
4	4	8	0.52	0.00	628xjv289t0rp		SELECT IID, COMPID, BLOCKCOD...
3	7,586	588	0.01	6.49	bvskgnk4p3x2w	racgimon@cwgkdb1 (TNS V1-V3)	DECLARE V_PROGRAM VARCHA...
3	815	3	0.98	0.70	gm1wjg2cvyqtv		BEGIN KMDETAILQUERY(:1, :2, :3...
3	3	5	0.51	0.00	7n4sgk14ydkst		SELECT IID, COMPID, BLOCKCOD...
2	4	153	0.01	0.00	0jbc3ny0twdry		select * from ( select logeven...
2	2	8	0.28	0.00	atcygnsmnjys0		select FLGID, ITEMCODE, CAPTIO...
2	2	7	0.30	0.00	7qs695t2jkdpa		select distinct a.itemcode fro...
0	1,440	10	0.03	1.23	dqmvgn5svxvcm		BEGIN PA_FMIS_BASE.NEWENTITY(:...
0	2,021	10	0.00	1.73	6aasuxzxky1gh		SELECT HZ_SEQ.NEXTVAL SEQVALUE...

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: 3,571,460
Captured SQL account for 91.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
2,037,059	80	25,463.24	57.04	18.23	19.94	gfjvxb25b773h	select o.owner#, o.obj#, decod...
194,682	309	630.04	5.45	4.70	6.74	0jn5hzudm8han	select * from ( select logeven...
115,440	481	240.00	3.23	1.13	1.13	4wfs884q6datz	Select A.MSG_ID, A.MSG_TOPIC,...
114,000	475	240.00	3.19	1.15	1.15	bk4zdy7ksxag7	SELECT MSG_ID, MSG_CONSUME FRO...
96,399	153	630.06	2.70	2.29	3.67	0jbc3ny0twdry	select * from ( select logeven...
71,444	20	3,572.20	2.00	1.45	1.87	5p6jc91q68nj0	UPDATE XTYHXX SET STOPED = 1 W...
62,360	2	31,180.00	1.75	0.93	1.89	cfz686a6qp0kg	select o.obj#, u.name, o.nam...
48,809	3	16,269.67	1.37	2.94	814.78	gm1wjg2cvyqtv	BEGIN KMDETAILQUERY(:1, :2, :3...
39,887	42	949.69	1.12	1.74	1.94	f6ynnf6u0cmv4	UPDATE XTYHXX SET XSMC = :1, ...
39,765	3,947	10.07	1.11	1.13	1.13	59vjj34vugaav	delete from obj$ where obj# = ...
39,529	3,947	10.01	1.11	0.44	0.44	6hh57rs9wtbd0	delete from vtable$ where obj#...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 253
Captured SQL account for 0.4% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
153	3	51.00	60.47	2.94	814.78	gm1wjg2cvyqtv	BEGIN KMDETAILQUERY(:1, :2, :3...
14	2	7.00	5.53	1.68	2.08	dpy0rv0dz6kgb	BEGIN KMSUMQUERY_FBQS(:1, :2,...
1	1	1.00	0.40	0.26	1.34	7vgmvmy8vvb9s	insert into wrh$_tempstatxs ...
0	3,981	0.00	0.00	0.33	0.33	04xtrk7uyhknh	select obj#, type#, ctime, mti...
0	10	0.00	0.00	0.57	0.63	05z87gdmpjk3b	SELECT /*+ NO_MERGE(YWZD) NO_...
0	153	0.00	0.00	2.29	3.67	0jbc3ny0twdry	select * from ( select logeven...
0	309	0.00	0.00	4.70	6.74	0jn5hzudm8han	select * from ( select logeven...
0	3,965	0.00	0.00	0.18	0.18	1gfaj4z5hn1kf	delete from dependency$ where ...
0	17	0.00	0.00	0.00	0.00	1gu8t96d0bdmu	select t.ts#, t.file#, t.block...
0	26	0.00	0.00	0.83	0.89	1gu98ju99nrax	INSERT INTO HZBB_DXLIST (DXLXI...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 235,082
Captured SQL account for 78.9% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Text
12,131	12,128	1.00	5.86	a16hu5wzwq421	BEGIN vPD_PKG.SET_CONTEXT_COMP...
11,841	0	0.00	0.00	9y7s2afnkqs9d	delete from idl_ub2$ where obj...
11,841	0	0.00	0.00	d5jd9b2xct7xz	delete from idl_char$ where ob...
11,841	0	0.00	0.00	dvpfc386d6dmm	delete from idl_sb4$ where obj...
11,841	0	0.00	0.00	gdhz78y24tvnz	delete from ncomp_dll$ where o...
11,841	0	0.00	0.00	gsqxm6zz3w2by	delete from idl_ub1$ where obj...
7,894	0	0.00	0.00	dhx4hx5kz79bf	delete from javaobj$ where obj...
5,989	5,986	1.00	0.00	6pgaqa2kcx6vs	SELECT SYS_CONTEXT('VPD_CONTEX...
4,045	3,959	0.98	0.00	5ngzsfstg8tmy	select o.owner#, o.name, o.nam...
3,981	3,853	0.97	0.00	04xtrk7uyhknh	select obj#, type#, ctime, mti...
3,965	0	0.00	0.00	1gfaj4z5hn1kf	delete from dependency$ where ...
3,965	0	0.00	0.00	20vv6ttajyjzq	delete from access$ where d_ob...
3,947	0	0.00	0.00	1vpham7m95msd	delete from error$ where obj#=...
3,947	0	0.00	0.00	29qw6v6846pds	delete from procedurec$ where ...
3,947	0	0.00	0.00	3zqk646c0847g	delete from type_misc$ where o...
3,947	0	0.00	0.00	4fkbtysdca10f	delete from argument$ where ob...
3,947	3,947	1.00	0.00	59vjj34vugaav	delete from obj$ where obj# = ...
3,947	0	0.00	0.00	5t480bb4uh8hw	delete from source$ where obj#...
3,947	0	0.00	0.00	60g50k2kcvqs2	delete from oparg$ where obj# ...
3,947	0	0.00	0.00	6fk1mrrz830p1	delete from com$ where obj#=:1
3,947	0	0.00	0.00	6hh57rs9wtbd0	delete from vtable$ where obj#...
3,947	0	0.00	0.00	6xn2s57zw4m5b	delete from opancillary$ where...
3,947	0	0.00	0.00	7a1j63zh85ubk	delete from procedureinfo$ whe...
3,947	0	0.00	0.00	8h60j55jzkkb9	delete from procedurejava$ whe...
3,947	0	0.00	0.00	8hkh4yxcygxj6	delete from procedureplsql$ wh...
3,947	0	0.00	0.00	8pn2d8msd9v06	delete from dir$ where obj#=:1
3,947	0	0.00	0.00	ahf8czff1p9f9	delete from settings$ where ob...
3,947	0	0.00	0.00	av0kjjbhc642q	delete from objauth$ where obj...
3,947	0	0.00	0.00	bdx6s0wp1dh3t	delete from context$ where obj...
3,947	0	0.00	0.00	c3uk9spac8d28	delete from library$ where obj...
3,947	0	0.00	0.00	ght3kqjqw74ff	delete from procedure$ where o...
3,947	0	0.00	0.00	gmhmap859gq7y	delete from opbinding$ where o...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 216,411
Captured SQL account for 79.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
12,130	12,131	5.61	a16hu5wzwq421	BEGIN vPD_PKG.SET_CONTEXT_COMP...
11,841	11,841	5.47	9y7s2afnkqs9d	delete from idl_ub2$ where obj...
11,841	11,841	5.47	d5jd9b2xct7xz	delete from idl_char$ where ob...
11,841	11,841	5.47	dvpfc386d6dmm	delete from idl_sb4$ where obj...
11,841	11,841	5.47	gdhz78y24tvnz	delete from ncomp_dll$ where o...
11,841	11,841	5.47	gsqxm6zz3w2by	delete from idl_ub1$ where obj...
5,988	5,989	2.77	6pgaqa2kcx6vs	SELECT SYS_CONTEXT('VPD_CONTEX...
3,965	3,965	1.83	1gfaj4z5hn1kf	delete from dependency$ where ...
3,965	3,965	1.83	20vv6ttajyjzq	delete from access$ where d_ob...
3,947	3,947	1.82	1vpham7m95msd	delete from error$ where obj#=...
3,947	3,947	1.82	29qw6v6846pds	delete from procedurec$ where ...
3,947	3,947	1.82	3zqk646c0847g	delete from type_misc$ where o...
3,947	3,947	1.82	4fkbtysdca10f	delete from argument$ where ob...
3,947	3,947	1.82	59vjj34vugaav	delete from obj$ where obj# = ...
3,947	3,947	1.82	5t480bb4uh8hw	delete from source$ where obj#...
3,947	3,947	1.82	60g50k2kcvqs2	delete from oparg$ where obj# ...
3,947	3,947	1.82	6fk1mrrz830p1	delete from com$ where obj#=:1
3,947	3,947	1.82	6hh57rs9wtbd0	delete from vtable$ where obj#...
3,947	3,947	1.82	6xn2s57zw4m5b	delete from opancillary$ where...
3,947	3,947	1.82	7a1j63zh85ubk	delete from procedureinfo$ whe...
3,947	3,947	1.82	8h60j55jzkkb9	delete from procedurejava$ whe...
3,947	3,947	1.82	8hkh4yxcygxj6	delete from procedureplsql$ wh...
3,947	3,947	1.82	8pn2d8msd9v06	delete from dir$ where obj#=:1
3,947	3,947	1.82	ahf8czff1p9f9	delete from settings$ where ob...
3,947	3,947	1.82	av0kjjbhc642q	delete from objauth$ where obj...
3,947	3,947	1.82	bdx6s0wp1dh3t	delete from context$ where obj...
3,947	3,947	1.82	c3uk9spac8d28	delete from library$ where obj...
3,947	7,894	1.82	dhx4hx5kz79bf	delete from javaobj$ where obj...
3,947	3,947	1.82	ght3kqjqw74ff	delete from procedure$ where o...
3,947	3,947	1.82	gmhmap859gq7y	delete from opbinding$ where o...

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

No data exists for this section of the report.

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 Text
1.84	9.20	19.94	18.23	80	gfjvxb25b773h	select o.owner#, o.obj#, decod...
1.20	63.51	1.89	0.93	2	cfz686a6qp0kg	select o.obj#, u.name, o.nam...
0.14	12.60	1.13	1.13	3,947	59vjj34vugaav	delete from obj$ where obj# = ...
0.13	40.71	0.33	0.33	3,981	04xtrk7uyhknh	select obj#, type#, ctime, mti...
0.09	35.74	0.25	0.25	4,045	5ngzsfstg8tmy	select o.owner#, o.name, o.nam...
0.06	0.01	814.78	2.94	3	gm1wjg2cvyqtv	BEGIN KMDETAILQUERY(:1, :2, :3...
0.03	17.11	0.18	0.18	3,965	1gfaj4z5hn1kf	delete from dependency$ where ...
0.03	0.00	1,439.55	0.28	10	dqmvgn5svxvcm	BEGIN PA_FMIS_BASE.NEWENTITY(:...
0.02	1.18	2.08	1.68	2	dpy0rv0dz6kgb	BEGIN KMSUMQUERY_FBQS(:1, :2,...
0.02	0.00	773.44	0.28	2	c2aw4fq306q4k	INSERT /+ APPEND / INTO WRH$...
0.01	6.86	0.15	0.15	3,947	3zqk646c0847g	delete from type_misc$ where o...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

04xtrk7uyhknh select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

05z87gdmpjk3b SELECT /*+ NO_MERGE(YWZD) NO_MERGE(ZDSX) USER_HASH(YWZD) */ YWZD.ISYSX, ZDSX.DXLXID, ZDSX.ITEMCODE, YWZD.YWLXID, YWZD.ZDBH, YWZD.ZDDM, YWZD.KMDM, YWZD.JDFX, YWZD.ZDFX, YWZD.ZDNAME, 0 AS QXLX FROM (SELECT /*+ NO_MERGE(XTGLYWZD) USER_HASH(XTGLYWZD) */ DECODE(SIGN(NVL(ZDYSXJ, 0) + NVL(ZDYSXD, 0) + NVL(ZDGROUPJ, 0) + NVL(ZDGROUPD, 0)), 1, 1, 0) AS ISYSX, YWLXID, ZDBH, ZDFX, ZDDM, KMDM, DECODE(ZDFX, 1, 1, 3, 1, 4, 1, 2) JDFX, DECODE(ZDFX, 1, ZDNAMEJ, 3, ZDNAMEJ, 4, ZDNAMEJ, ZDNAMED) ZDNAME FROM XTGLYWZD UNION SELECT /*+ NO_MERGE(XTGLYWZD) USER_HASH(XTGLYWZD) */ DECODE(SIGN(NVL(ZDYSXJ, 0) + NVL(ZDYSXD, 0) + NVL(ZDGROUPJ, 0) + NVL(ZDGROUPD, 0)), 1, 1, 0) AS ISYSX, YWLXID, ZDBH, ZDFX, ZDDM, KMDM, 2 AS JDFX, ZDNAMED AS ZDNAME FROM XTGLYWZD WHERE ZDFX IN (3, 4)) YWZD, (SELECT /*+ NO_MERGE(ZWITEMSYW) USER_HASH(ZWITEMSYW) */ S.DXLX AS DXLXID , Z.ITEMCODE, S.YWLX AS YWLXID, ', ' || RTRIM(RZDBH) || ', ' AS SJZD, 0 QXLX FROM XTCAC S, ZWITEMSYW Z WHERE Z.LEAF = 1 AND S.KMID = Z.IID ) ZDSX WHERE ZDSX.YWLXID = YWZD.YWLXID AND INSTR(ZDSX.SJZD, ', '||trim(cast(ywzd.zdbh as varchar2(10)))||', ') > 0

0jbc3ny0twdry select * from ( select logevent0_.ID_ as ID1_31_, logevent0_.TIME_ as TIME2_31_, logevent0_.TYPE_ as TYPE3_31_, logevent0_.MSG_ as MSG4_31_, logevent0_.STATUS_ as STATUS5_31_, logevent0_.INTRULE_ID_ as INTRULE6_31_, logevent0_.INTRULE_NAME_ as INTRULE7_31_, logevent0_.DATA_ as DATA8_31_, logevent0_.HANDLED_ as HANDLED9_31_ from NBI_LOG_EVENT logevent0_ where logevent0_.TIME_<:1 and logevent0_.HANDLED_=0 and logevent0_.STATUS_='INFO' ) where rownum <= :2

0jn5hzudm8han select * from ( select logevent0_.ID_ as ID1_31_, logevent0_.TIME_ as TIME2_31_, logevent0_.TYPE_ as TYPE3_31_, logevent0_.MSG_ as MSG4_31_, logevent0_.STATUS_ as STATUS5_31_, logevent0_.INTRULE_ID_ as INTRULE6_31_, logevent0_.INTRULE_NAME_ as INTRULE7_31_, logevent0_.DATA_ as DATA8_31_, logevent0_.HANDLED_ as HANDLED9_31_ from NBI_LOG_EVENT logevent0_ where logevent0_.HANDLED_=1 ) where rownum <= :1

1gfaj4z5hn1kf delete from dependency$ where d_obj#=:1

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

1gu98ju99nrax INSERT INTO HZBB_DXLIST (DXLXID, DXID, XH) SELECT A.DXLXID, A.DXID, :B1 FROM XTGLDXGX A, HZBB_DXLIST B WHERE :B2 BETWEEN A.STIME AND NVL(A.ETIME, SYSDATE+1000) AND B.DXID=A.DXID1 AND B.XH=:B1 -1

1vpham7m95msd delete from error$ where obj#=:1

20vv6ttajyjzq delete from access$ where d_obj#=:1

29qw6v6846pds delete from procedurec$ where obj#=:1

3zqk646c0847g delete from type_misc$ where obj#=:1

4fkbtysdca10f delete from argument$ where obj#=:1

4wfs884q6datz Select A.MSG_ID, A.MSG_TOPIC, A.MSG_RECV, A.MSG_SEND, A.MSG_SENDCOUNT, A.MSG_CONSUME, A.MSG_SUCCEED, A.MSG_KEY, A.MSG_GENERATECONTENT From MSG_QUEUE A Where A.MSG_KEY Is Not Null AND ROWNUM <= 50 order by A.MSG_RECV DESC

59vjj34vugaav delete from obj$ where obj# = :1

5jxwda6s8nvc7 select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :w or (changescn_wrap = :w and changescn_base >= :b))

5ngzsfstg8tmy select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1

5p6jc91q68nj0 UPDATE XTYHXX SET STOPED = 1 WHERE YHMC IN (SELECT B.YHMC FROM USERPOSTEXCHANGE A , XTYHXX B WHERE UPPER(B.YHMC) = UPPER(A.YHMC(+)) AND B.USERTYPE = 1 AND A.YHMC IS NULL)

5t480bb4uh8hw delete from source$ where obj#=:1

60g50k2kcvqs2 delete from oparg$ where obj# = :1

628xjv289t0rp SELECT IID, COMPID, BLOCKCODE, SUBSTR(A.ITEMCODE, -4, 4) AS ITEMCODE, SUBSTR(POSITION, -4, 4) AS POSITION, DECODE(ITEMLEVEL, 1, CAP1, 2, CAP2, 3, CAP3, 4, CAP4, 5, CAP5, 6, CAP6, 7, CAP7, 8, CAP8, 9, CAP9, CAP10) AS CAPTION, DECODE(ITEMLEVEL, 1, CODE1, 2, CODE2, 3, CODE3, 4, CODE4, 5, CODE5, 6, CODE6, 7, CODE7, 8, CODE8, 9, CODE9, CODE10) AS CODE, STOPED, 0 HASSECURE, A.ITEMCODE FULLITEMCODE, STIME, STOPCOUNT, FLGID, MINSTIME, KIND, LEAF FROM (SELECT IID, COMPID, BLOCKCODE, ITEMCODE, POSITION, ITEMLEVEL, CAP1, CAP2, CAP3, CAP4, CAP5, CAP6, CAP7, CAP8, CAP9, CAP10, CODE1, CODE2, CODE3, CODE4, CODE5, CODE6, CODE7, CODE8, CODE9, CODE10, STOPED, ITEMCODE FULLITEMCODE, STIME, STOPCOUNT, FLGID, KIND, LEAF FROM (SELECT /*+ NO_MERGE(A) NO_MERGE(B)*/ A.FLGID, A.BLOCKCODE, A.ITEMCODE, A.POSITION, A.ITEMLEVEL, A.LEAF, A.IID, A.CAPTION, A.CODE, A.ZJM, A.STIME, DECODE(B.ISSTOP, 1, NVL(A.ETIME, A.STIME), A.ETIME) ETIME, A.CAP1, A.CAP2, A.CAP3, A.CAP4, A.CAP5, A.CAP6, A.CAP7, A.CAP8, A.CAP9, A.CAP10, A.CODE1, A.CODE2, A.CODE3, A.CODE4, A.CODE5, A.CODE6, A.CODE7, A.CODE8, A.CODE9, A.CODE10, B.ISSTOP AS STOPED, A.KIND, A.STOPCOUNT, A.COMPID FROM FMIS0400.ZWITEMSYW A, (SELECT A.IID, A.ITEMCODE, MIN(SIGN(A.STOPED+B.ISSTOP)) AS ISSTOP, A.STOPED FROM (SELECT IID, ITEMCODE, LEAF, LEVEL, STOPED, ETIME, DECODE(INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>'), 0, SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3, INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>')-1)) AS START_ID FROM (SELECT * FROM FMIS0400.ZWITEMSYW WHERE STIME <= TO_DATE('2012-03-01', 'YYYY-MM-DD') AND ETIME > TO_DATE('2012-03-01', 'YYYY-MM-DD')) CONNECT BY TRIM(ITEMCODE)=PRIOR SUBSTR(ITEMCODE, 1, LENGTH(TRIM(ITEMCODE))-4) START WITH LEAF=1) A, FMIS0400.ZWITEMSYWASSIGN B WHERE B.KMID=A.START_ID AND B.COMPID= '0401' GROUP BY A.IID, A.ITEMCODE, A.STOPED) B WHERE A.STIME <= TO_DATE('2012-03-01', 'YYYY-MM-DD') AND A.ETIME > TO_DATE('2012-03-01', 'YYYY-MM-DD') AND B.ITEMCODE=A.ITEMCODE AND B.STOPED=A.STOPED ) Where ( STIME<=to_date('2012-03-01', 'yyyy-mm-dd') and ETIME>to_date('2012-03-01', 'yyyy-mm-dd') ) ) A, (SELECT ITEMCODE, MIN(STIME) MINSTIME FROM (SELECT /*+ NO_MERGE(A) NO_MERGE(B)*/ A.FLGID, A.BLOCKCODE, A.ITEMCODE, A.POSITION, A.ITEMLEVEL, A.LEAF, A.IID, A.CAPTION, A.CODE, A.ZJM, A.STIME, DECODE(B.ISSTOP, 1, NVL(A.ETIME, A.STIME), A.ETIME) ETIME, A.CAP1, A.CAP2, A.CAP3, A.CAP4, A.CAP5, A.CAP6, A.CAP7, A.CAP8, A.CAP9, A.CAP10, A.CODE1, A.CODE2, A.CODE3, A.CODE4, A.CODE5, A.CODE6, A.CODE7, A.CODE8, A.CODE9, A.CODE10, B.ISSTOP AS STOPED, A.KIND, A.STOPCOUNT, A.COMPID FROM FMIS0400.ZWITEMSYW A, (SELECT A.IID, A.ITEMCODE, MIN(SIGN(A.STOPED+B.ISSTOP)) AS ISSTOP, A.STOPED FROM (SELECT IID, ITEMCODE, LEAF, LEVEL, STOPED, ETIME, DECODE(INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>'), 0, SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3, INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>')-1)) AS START_ID FROM (SELECT * FROM FMIS0400.ZWITEMSYW WHERE STIME <= TO_DATE('2012-03-01', 'YYYY-MM-DD') AND ETIME > TO_DATE('2012-03-01', 'YYYY-MM-DD')) CONNECT BY TRIM(ITEMCODE)=PRIOR SUBSTR(ITEMCODE, 1, LENGTH(TRIM(ITEMCODE))-4) START WITH LEAF=1) A, FMIS0400.ZWITEMSYWASSIGN B WHERE B.KMID=A.START_ID AND B.COMPID= '0401' GROUP BY A.IID, A.ITEMCODE, A.STOPED) B WHERE A.STIME <= TO_DATE('2012-03-01', 'YYYY-MM-DD') AND A.ETIME > TO_DATE('2012-03-01', 'YYYY-MM-DD') AND B.ITEMCODE=A.ITEMCODE AND B.STOPED=A.STOPED ) GROUP BY ITEMCODE) B WHERE A.ITEMCODE = B.ITEMCODE ORDER BY BLOCKCODE, CODE, POSITION

6aasuxzxky1gh SELECT HZ_SEQ.NEXTVAL SEQVALUE FROM DUAL

6fk1mrrz830p1 delete from com$ where obj#=:1

6hh57rs9wtbd0 delete from vtable$ where obj#=:1

6pgaqa2kcx6vs SELECT SYS_CONTEXT('VPD_CONTEXT', 'COMPID') AS VPD_CONTEXT FROM DUAL

6xn2s57zw4m5b delete from opancillary$ where obj#=:1

7a1j63zh85ubk delete from procedureinfo$ where obj#=:1

7n4sgk14ydkst SELECT IID, COMPID, BLOCKCODE, SUBSTR(A.ITEMCODE, -4, 4) AS ITEMCODE, SUBSTR(POSITION, -4, 4) AS POSITION, DECODE(ITEMLEVEL, 1, CAP1, 2, CAP2, 3, CAP3, 4, CAP4, 5, CAP5, 6, CAP6, 7, CAP7, 8, CAP8, 9, CAP9, CAP10) AS CAPTION, DECODE(ITEMLEVEL, 1, CODE1, 2, CODE2, 3, CODE3, 4, CODE4, 5, CODE5, 6, CODE6, 7, CODE7, 8, CODE8, 9, CODE9, CODE10) AS CODE, STOPED, 0 HASSECURE, A.ITEMCODE FULLITEMCODE, STIME, STOPCOUNT, FLGID, MINSTIME, KIND, LEAF FROM (SELECT IID, COMPID, BLOCKCODE, ITEMCODE, POSITION, ITEMLEVEL, CAP1, CAP2, CAP3, CAP4, CAP5, CAP6, CAP7, CAP8, CAP9, CAP10, CODE1, CODE2, CODE3, CODE4, CODE5, CODE6, CODE7, CODE8, CODE9, CODE10, STOPED, ITEMCODE FULLITEMCODE, STIME, STOPCOUNT, FLGID, KIND, LEAF FROM (SELECT /*+ NO_MERGE(A) NO_MERGE(B)*/ A.FLGID, A.BLOCKCODE, A.ITEMCODE, A.POSITION, A.ITEMLEVEL, A.LEAF, A.IID, A.CAPTION, A.CODE, A.ZJM, A.STIME, DECODE(B.ISSTOP, 1, NVL(A.ETIME, A.STIME), A.ETIME) ETIME, A.CAP1, A.CAP2, A.CAP3, A.CAP4, A.CAP5, A.CAP6, A.CAP7, A.CAP8, A.CAP9, A.CAP10, A.CODE1, A.CODE2, A.CODE3, A.CODE4, A.CODE5, A.CODE6, A.CODE7, A.CODE8, A.CODE9, A.CODE10, B.ISSTOP AS STOPED, A.KIND, A.STOPCOUNT, A.COMPID FROM FMIS0400.ZWITEMSYW A, (SELECT A.IID, A.ITEMCODE, MIN(SIGN(A.STOPED+B.ISSTOP)) AS ISSTOP, A.STOPED FROM (SELECT IID, ITEMCODE, LEAF, LEVEL, STOPED, ETIME, DECODE(INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>'), 0, SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3, INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>')-1)) AS START_ID FROM (SELECT * FROM FMIS0400.ZWITEMSYW WHERE STIME <= TO_DATE('2012-01-01', 'YYYY-MM-DD') AND ETIME > TO_DATE('2012-01-01', 'YYYY-MM-DD')) CONNECT BY TRIM(ITEMCODE)=PRIOR SUBSTR(ITEMCODE, 1, LENGTH(TRIM(ITEMCODE))-4) START WITH LEAF=1) A, FMIS0400.ZWITEMSYWASSIGN B WHERE B.KMID=A.START_ID AND B.COMPID= '0401' GROUP BY A.IID, A.ITEMCODE, A.STOPED) B WHERE A.STIME <= TO_DATE('2012-01-01', 'YYYY-MM-DD') AND A.ETIME > TO_DATE('2012-01-01', 'YYYY-MM-DD') AND B.ITEMCODE=A.ITEMCODE AND B.STOPED=A.STOPED ) Where ( STIME<=to_date('2012-01-01', 'yyyy-mm-dd') and ETIME>to_date('2012-01-01', 'yyyy-mm-dd') ) ) A, (SELECT ITEMCODE, MIN(STIME) MINSTIME FROM (SELECT /*+ NO_MERGE(A) NO_MERGE(B)*/ A.FLGID, A.BLOCKCODE, A.ITEMCODE, A.POSITION, A.ITEMLEVEL, A.LEAF, A.IID, A.CAPTION, A.CODE, A.ZJM, A.STIME, DECODE(B.ISSTOP, 1, NVL(A.ETIME, A.STIME), A.ETIME) ETIME, A.CAP1, A.CAP2, A.CAP3, A.CAP4, A.CAP5, A.CAP6, A.CAP7, A.CAP8, A.CAP9, A.CAP10, A.CODE1, A.CODE2, A.CODE3, A.CODE4, A.CODE5, A.CODE6, A.CODE7, A.CODE8, A.CODE9, A.CODE10, B.ISSTOP AS STOPED, A.KIND, A.STOPCOUNT, A.COMPID FROM FMIS0400.ZWITEMSYW A, (SELECT A.IID, A.ITEMCODE, MIN(SIGN(A.STOPED+B.ISSTOP)) AS ISSTOP, A.STOPED FROM (SELECT IID, ITEMCODE, LEAF, LEVEL, STOPED, ETIME, DECODE(INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>'), 0, SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3, INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>')-1)) AS START_ID FROM (SELECT * FROM FMIS0400.ZWITEMSYW WHERE STIME <= TO_DATE('2012-01-01', 'YYYY-MM-DD') AND ETIME > TO_DATE('2012-01-01', 'YYYY-MM-DD')) CONNECT BY TRIM(ITEMCODE)=PRIOR SUBSTR(ITEMCODE, 1, LENGTH(TRIM(ITEMCODE))-4) START WITH LEAF=1) A, FMIS0400.ZWITEMSYWASSIGN B WHERE B.KMID=A.START_ID AND B.COMPID= '0401' GROUP BY A.IID, A.ITEMCODE, A.STOPED) B WHERE A.STIME <= TO_DATE('2012-01-01', 'YYYY-MM-DD') AND A.ETIME > TO_DATE('2012-01-01', 'YYYY-MM-DD') AND B.ITEMCODE=A.ITEMCODE AND B.STOPED=A.STOPED ) GROUP BY ITEMCODE) B WHERE A.ITEMCODE = B.ITEMCODE ORDER BY BLOCKCODE, CODE, POSITION

7qs695t2jkdpa select distinct a.itemcode from ZWITEMSYWQX a, xtpostop b where b.yhdm=1111156303 and instr(a.qx, b.postid) > 0 order by itemCode

7vgmvmy8vvb9s insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)

8h60j55jzkkb9 delete from procedurejava$ where obj#=:1

8hkh4yxcygxj6 delete from procedureplsql$ where obj#=:1

8pn2d8msd9v06 delete from dir$ where obj#=:1

9y7s2afnkqs9d delete from idl_ub2$ where obj#=:1 and part=:2

a16hu5wzwq421 BEGIN vPD_PKG.SET_CONTEXT_COMPID('0400'); END;

ahf8czff1p9f9 delete from settings$ where obj# = :1

atcygnsmnjys0 select FLGID, ITEMCODE, CAPTION, CODE, IID, ZJM, BLOCKCODE from (SELECT /*+ NO_MERGE(A) NO_MERGE(B)*/ A.FLGID, A.BLOCKCODE, A.ITEMCODE, A.POSITION, A.ITEMLEVEL, A.LEAF, A.IID, A.CAPTION, A.CODE, A.ZJM, A.STIME, DECODE(B.ISSTOP, 1, NVL(A.ETIME, A.STIME), A.ETIME) ETIME, A.CAP1, A.CAP2, A.CAP3, A.CAP4, A.CAP5, A.CAP6, A.CAP7, A.CAP8, A.CAP9, A.CAP10, A.CODE1, A.CODE2, A.CODE3, A.CODE4, A.CODE5, A.CODE6, A.CODE7, A.CODE8, A.CODE9, A.CODE10, B.ISSTOP AS STOPED, A.KIND, A.STOPCOUNT, A.COMPID FROM FMIS0400.ZWITEMSYW A, (SELECT A.IID, A.ITEMCODE, MIN(SIGN(A.STOPED+B.ISSTOP)) AS ISSTOP, A.STOPED FROM (SELECT IID, ITEMCODE, LEAF, LEVEL, STOPED, ETIME, DECODE(INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>'), 0, SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3, INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>')-1)) AS START_ID FROM (SELECT * FROM FMIS0400.ZWITEMSYW WHERE STIME <= TO_DATE('2012-03-01', 'YYYY-MM-DD') AND ETIME > TO_DATE('2012-03-01', 'YYYY-MM-DD')) CONNECT BY TRIM(ITEMCODE)=PRIOR SUBSTR(ITEMCODE, 1, LENGTH(TRIM(ITEMCODE))-4) START WITH LEAF=1) A, FMIS0400.ZWITEMSYWASSIGN B WHERE B.KMID=A.START_ID AND B.COMPID= '0401' GROUP BY A.IID, A.ITEMCODE, A.STOPED) B WHERE A.STIME <= TO_DATE('2012-03-01', 'YYYY-MM-DD') AND A.ETIME > TO_DATE('2012-03-01', 'YYYY-MM-DD') AND B.ITEMCODE=A.ITEMCODE AND B.STOPED=A.STOPED ) where IsNull(STOPCOUNT, 0) = 0 and LEAF=1 and STIME <= to_date('2012-03-01', 'yyyy-mm-dd') and ETIME > to_date('2012-03-01', 'yyyy-mm-dd') order by POSITION

av0kjjbhc642q delete from objauth$ where obj#=:1

bdx6s0wp1dh3t delete from context$ where obj#=:1

bk4zdy7ksxag7 SELECT MSG_ID, MSG_CONSUME FROM MSG_QUEUE WHERE MSG_SUCCEED=0 AND MSG_KEY IS NULL AND ROWNUM <= 100 ORDER BY MSG_RECV

bvskgnk4p3x2w DECLARE V_PROGRAM VARCHAR2(100); V_SESSIONID NUMBER(10); V_CONTEXT VARCHAR2(32); BEGIN SELECT MAX(TRIM(UPPER(PROGRAM))), MAX(TRIM(UPPER(USERNAME))) INTO V_PROGRAM, V_CONTEXT FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID'); IF SUBSTR(V_PROGRAM, 1, 3) IN ('EXP', 'IMP') THEN VPD_PKG.SET_CONTEXT_COMPID('-1'); VPD_PKG.SET_CONTEXT_VPD_YEAR('-1'); VPD_PKG.SET_CONTEXT_ACCBOOKID('-1'); ELSE VPD_PKG.SET_CONTEXT_COMPID(REPLACE(SUBSTR(V_CONTEXT, 5), '_TOP', '9999')); VPD_PKG.SET_CONTEXT_VPD_YEAR(TO_CHAR(SYSDATE, 'YYYYMMDD')); VPD_PKG.SET_CONTEXT_ACCBOOKID('0'); END IF; END;

c2aw4fq306q4k INSERT /*+ APPEND */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)

c3uk9spac8d28 delete from library$ where obj#=:1

cfz686a6qp0kg select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#

d3c7d056xt3cg INSERT INTO HZ_LOG (LOG_NO, USER_NAME, BEGIN_TIME, END_TIME, LOG_LEVEL, LOG_TYPE, SQL_TEXT, SQL_TEXT1, SQL_TEXT2, LOG_DETAIL, IP_ADDRESS, TIMES) VALUES (HZ_SEQ.NEXTVAL, SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA'), SYSDATE, SYSDATE, :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , SYS_CONTEXT('USERENV', 'IP_ADDRESS'), :B1 )

d5jd9b2xct7xz delete from idl_char$ where obj#=:1 and part=:2

dhx4hx5kz79bf delete from javaobj$ where obj#=:1

dpy0rv0dz6kgb BEGIN KMSUMQUERY_FBQS(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13); END;

dqmvgn5svxvcm BEGIN PA_FMIS_BASE.NEWENTITY(:1, :2); END;

dvpfc386d6dmm delete from idl_sb4$ where obj#=:1 and part=:2

f67hktj85gdrc BEGIN vPD_PKG.SET_CONTEXT_COMPID('-1'); END;

f6ynnf6u0cmv4 UPDATE XTYHXX SET XSMC = :1, EMAIL = :2, STOPED = :3 WHERE UPPER(YHMC) = UPPER(:4)

g73tzgnm4722f select u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o, user$ u, trigger$ where bitand(trigger$.property, 16) = 16 and trigger$.baseobject = :1 and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj#

gdhz78y24tvnz delete from ncomp_dll$ where obj#=:1 returning dllname into :2

gfjvxb25b773h select o.owner#, o.obj#, decode(o.linkname, null, decode(u.name, null, 'SYS', u.name), o.remoteowner), o.name, o.linkname, o.namespace, o.subname from user$ u, obj$ o where u.user#(+)=o.owner# and o.type#=:1 and not exists (select p_obj# from dependency$ where p_obj# = o.obj#) order by o.obj# for update

ght3kqjqw74ff delete from procedure$ where obj#=:1

gm1wjg2cvyqtv BEGIN KMDETAILQUERY(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23); END;

gmhmap859gq7y delete from opbinding$ where obj#=:1

gsqxm6zz3w2by delete from idl_ub1$ where obj#=:1 and part=:2

SQL Id	SQL Text
04xtrk7uyhknh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
05z87gdmpjk3b	SELECT /+ NO_MERGE(YWZD) NO_MERGE(ZDSX) USER_HASH(YWZD) / YWZD.ISYSX, ZDSX.DXLXID, ZDSX.ITEMCODE, YWZD.YWLXID, YWZD.ZDBH, YWZD.ZDDM, YWZD.KMDM, YWZD.JDFX, YWZD.ZDFX, YWZD.ZDNAME, 0 AS QXLX FROM (SELECT /+ NO_MERGE(XTGLYWZD) USER_HASH(XTGLYWZD) / DECODE(SIGN(NVL(ZDYSXJ, 0) + NVL(ZDYSXD, 0) + NVL(ZDGROUPJ, 0) + NVL(ZDGROUPD, 0)), 1, 1, 0) AS ISYSX, YWLXID, ZDBH, ZDFX, ZDDM, KMDM, DECODE(ZDFX, 1, 1, 3, 1, 4, 1, 2) JDFX, DECODE(ZDFX, 1, ZDNAMEJ, 3, ZDNAMEJ, 4, ZDNAMEJ, ZDNAMED) ZDNAME FROM XTGLYWZD UNION SELECT /+ NO_MERGE(XTGLYWZD) USER_HASH(XTGLYWZD) / DECODE(SIGN(NVL(ZDYSXJ, 0) + NVL(ZDYSXD, 0) + NVL(ZDGROUPJ, 0) + NVL(ZDGROUPD, 0)), 1, 1, 0) AS ISYSX, YWLXID, ZDBH, ZDFX, ZDDM, KMDM, 2 AS JDFX, ZDNAMED AS ZDNAME FROM XTGLYWZD WHERE ZDFX IN (3, 4)) YWZD, (SELECT /+ NO_MERGE(ZWITEMSYW) USER_HASH(ZWITEMSYW) / S.DXLX AS DXLXID , Z.ITEMCODE, S.YWLX AS YWLXID, ', ' \|\| RTRIM(RZDBH) \|\| ', ' AS SJZD, 0 QXLX FROM XTCAC S, ZWITEMSYW Z WHERE Z.LEAF = 1 AND S.KMID = Z.IID ) ZDSX WHERE ZDSX.YWLXID = YWZD.YWLXID AND INSTR(ZDSX.SJZD, ', '\|\|trim(cast(ywzd.zdbh as varchar2(10)))\|\|', ') > 0
0jbc3ny0twdry	select * from ( select logevent0_.ID_ as ID1_31_, logevent0_.TIME_ as TIME2_31_, logevent0_.TYPE_ as TYPE3_31_, logevent0_.MSG_ as MSG4_31_, logevent0_.STATUS_ as STATUS5_31_, logevent0_.INTRULE_ID_ as INTRULE6_31_, logevent0_.INTRULE_NAME_ as INTRULE7_31_, logevent0_.DATA_ as DATA8_31_, logevent0_.HANDLED_ as HANDLED9_31_ from NBI_LOG_EVENT logevent0_ where logevent0_.TIME_<:1 and logevent0_.HANDLED_=0 and logevent0_.STATUS_='INFO' ) where rownum <= :2
0jn5hzudm8han	select * from ( select logevent0_.ID_ as ID1_31_, logevent0_.TIME_ as TIME2_31_, logevent0_.TYPE_ as TYPE3_31_, logevent0_.MSG_ as MSG4_31_, logevent0_.STATUS_ as STATUS5_31_, logevent0_.INTRULE_ID_ as INTRULE6_31_, logevent0_.INTRULE_NAME_ as INTRULE7_31_, logevent0_.DATA_ as DATA8_31_, logevent0_.HANDLED_ as HANDLED9_31_ from NBI_LOG_EVENT logevent0_ where logevent0_.HANDLED_=1 ) where rownum <= :1
1gfaj4z5hn1kf	delete from dependency$ where d_obj#=:1
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1gu98ju99nrax	INSERT INTO HZBB_DXLIST (DXLXID, DXID, XH) SELECT A.DXLXID, A.DXID, :B1 FROM XTGLDXGX A, HZBB_DXLIST B WHERE :B2 BETWEEN A.STIME AND NVL(A.ETIME, SYSDATE+1000) AND B.DXID=A.DXID1 AND B.XH=:B1 -1
1vpham7m95msd	delete from error$ where obj#=:1
20vv6ttajyjzq	delete from access$ where d_obj#=:1
29qw6v6846pds	delete from procedurec$ where obj#=:1
3zqk646c0847g	delete from type_misc$ where obj#=:1
4fkbtysdca10f	delete from argument$ where obj#=:1
4wfs884q6datz	Select A.MSG_ID, A.MSG_TOPIC, A.MSG_RECV, A.MSG_SEND, A.MSG_SENDCOUNT, A.MSG_CONSUME, A.MSG_SUCCEED, A.MSG_KEY, A.MSG_GENERATECONTENT From MSG_QUEUE A Where A.MSG_KEY Is Not Null AND ROWNUM <= 50 order by A.MSG_RECV DESC
59vjj34vugaav	delete from obj$ where obj# = :1
5jxwda6s8nvc7	select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :w or (changescn_wrap = :w and changescn_base >= :b))
5ngzsfstg8tmy	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
5p6jc91q68nj0	UPDATE XTYHXX SET STOPED = 1 WHERE YHMC IN (SELECT B.YHMC FROM USERPOSTEXCHANGE A , XTYHXX B WHERE UPPER(B.YHMC) = UPPER(A.YHMC(+)) AND B.USERTYPE = 1 AND A.YHMC IS NULL)
5t480bb4uh8hw	delete from source$ where obj#=:1
60g50k2kcvqs2	delete from oparg$ where obj# = :1
628xjv289t0rp	SELECT IID, COMPID, BLOCKCODE, SUBSTR(A.ITEMCODE, -4, 4) AS ITEMCODE, SUBSTR(POSITION, -4, 4) AS POSITION, DECODE(ITEMLEVEL, 1, CAP1, 2, CAP2, 3, CAP3, 4, CAP4, 5, CAP5, 6, CAP6, 7, CAP7, 8, CAP8, 9, CAP9, CAP10) AS CAPTION, DECODE(ITEMLEVEL, 1, CODE1, 2, CODE2, 3, CODE3, 4, CODE4, 5, CODE5, 6, CODE6, 7, CODE7, 8, CODE8, 9, CODE9, CODE10) AS CODE, STOPED, 0 HASSECURE, A.ITEMCODE FULLITEMCODE, STIME, STOPCOUNT, FLGID, MINSTIME, KIND, LEAF FROM (SELECT IID, COMPID, BLOCKCODE, ITEMCODE, POSITION, ITEMLEVEL, CAP1, CAP2, CAP3, CAP4, CAP5, CAP6, CAP7, CAP8, CAP9, CAP10, CODE1, CODE2, CODE3, CODE4, CODE5, CODE6, CODE7, CODE8, CODE9, CODE10, STOPED, ITEMCODE FULLITEMCODE, STIME, STOPCOUNT, FLGID, KIND, LEAF FROM (SELECT /+ NO_MERGE(A) NO_MERGE(B)/ A.FLGID, A.BLOCKCODE, A.ITEMCODE, A.POSITION, A.ITEMLEVEL, A.LEAF, A.IID, A.CAPTION, A.CODE, A.ZJM, A.STIME, DECODE(B.ISSTOP, 1, NVL(A.ETIME, A.STIME), A.ETIME) ETIME, A.CAP1, A.CAP2, A.CAP3, A.CAP4, A.CAP5, A.CAP6, A.CAP7, A.CAP8, A.CAP9, A.CAP10, A.CODE1, A.CODE2, A.CODE3, A.CODE4, A.CODE5, A.CODE6, A.CODE7, A.CODE8, A.CODE9, A.CODE10, B.ISSTOP AS STOPED, A.KIND, A.STOPCOUNT, A.COMPID FROM FMIS0400.ZWITEMSYW A, (SELECT A.IID, A.ITEMCODE, MIN(SIGN(A.STOPED+B.ISSTOP)) AS ISSTOP, A.STOPED FROM (SELECT IID, ITEMCODE, LEAF, LEVEL, STOPED, ETIME, DECODE(INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>'), 0, SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3, INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>')-1)) AS START_ID FROM (SELECT * FROM FMIS0400.ZWITEMSYW WHERE STIME <= TO_DATE('2012-03-01', 'YYYY-MM-DD') AND ETIME > TO_DATE('2012-03-01', 'YYYY-MM-DD')) CONNECT BY TRIM(ITEMCODE)=PRIOR SUBSTR(ITEMCODE, 1, LENGTH(TRIM(ITEMCODE))-4) START WITH LEAF=1) A, FMIS0400.ZWITEMSYWASSIGN B WHERE B.KMID=A.START_ID AND B.COMPID= '0401' GROUP BY A.IID, A.ITEMCODE, A.STOPED) B WHERE A.STIME <= TO_DATE('2012-03-01', 'YYYY-MM-DD') AND A.ETIME > TO_DATE('2012-03-01', 'YYYY-MM-DD') AND B.ITEMCODE=A.ITEMCODE AND B.STOPED=A.STOPED ) Where ( STIME<=to_date('2012-03-01', 'yyyy-mm-dd') and ETIME>to_date('2012-03-01', 'yyyy-mm-dd') ) ) A, (SELECT ITEMCODE, MIN(STIME) MINSTIME FROM (SELECT /+ NO_MERGE(A) NO_MERGE(B)/ A.FLGID, A.BLOCKCODE, A.ITEMCODE, A.POSITION, A.ITEMLEVEL, A.LEAF, A.IID, A.CAPTION, A.CODE, A.ZJM, A.STIME, DECODE(B.ISSTOP, 1, NVL(A.ETIME, A.STIME), A.ETIME) ETIME, A.CAP1, A.CAP2, A.CAP3, A.CAP4, A.CAP5, A.CAP6, A.CAP7, A.CAP8, A.CAP9, A.CAP10, A.CODE1, A.CODE2, A.CODE3, A.CODE4, A.CODE5, A.CODE6, A.CODE7, A.CODE8, A.CODE9, A.CODE10, B.ISSTOP AS STOPED, A.KIND, A.STOPCOUNT, A.COMPID FROM FMIS0400.ZWITEMSYW A, (SELECT A.IID, A.ITEMCODE, MIN(SIGN(A.STOPED+B.ISSTOP)) AS ISSTOP, A.STOPED FROM (SELECT IID, ITEMCODE, LEAF, LEVEL, STOPED, ETIME, DECODE(INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>'), 0, SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3, INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>')-1)) AS START_ID FROM (SELECT * FROM FMIS0400.ZWITEMSYW WHERE STIME <= TO_DATE('2012-03-01', 'YYYY-MM-DD') AND ETIME > TO_DATE('2012-03-01', 'YYYY-MM-DD')) CONNECT BY TRIM(ITEMCODE)=PRIOR SUBSTR(ITEMCODE, 1, LENGTH(TRIM(ITEMCODE))-4) START WITH LEAF=1) A, FMIS0400.ZWITEMSYWASSIGN B WHERE B.KMID=A.START_ID AND B.COMPID= '0401' GROUP BY A.IID, A.ITEMCODE, A.STOPED) B WHERE A.STIME <= TO_DATE('2012-03-01', 'YYYY-MM-DD') AND A.ETIME > TO_DATE('2012-03-01', 'YYYY-MM-DD') AND B.ITEMCODE=A.ITEMCODE AND B.STOPED=A.STOPED ) GROUP BY ITEMCODE) B WHERE A.ITEMCODE = B.ITEMCODE ORDER BY BLOCKCODE, CODE, POSITION
6aasuxzxky1gh	SELECT HZ_SEQ.NEXTVAL SEQVALUE FROM DUAL
6fk1mrrz830p1	delete from com$ where obj#=:1
6hh57rs9wtbd0	delete from vtable$ where obj#=:1
6pgaqa2kcx6vs	SELECT SYS_CONTEXT('VPD_CONTEXT', 'COMPID') AS VPD_CONTEXT FROM DUAL
6xn2s57zw4m5b	delete from opancillary$ where obj#=:1
7a1j63zh85ubk	delete from procedureinfo$ where obj#=:1
7n4sgk14ydkst	SELECT IID, COMPID, BLOCKCODE, SUBSTR(A.ITEMCODE, -4, 4) AS ITEMCODE, SUBSTR(POSITION, -4, 4) AS POSITION, DECODE(ITEMLEVEL, 1, CAP1, 2, CAP2, 3, CAP3, 4, CAP4, 5, CAP5, 6, CAP6, 7, CAP7, 8, CAP8, 9, CAP9, CAP10) AS CAPTION, DECODE(ITEMLEVEL, 1, CODE1, 2, CODE2, 3, CODE3, 4, CODE4, 5, CODE5, 6, CODE6, 7, CODE7, 8, CODE8, 9, CODE9, CODE10) AS CODE, STOPED, 0 HASSECURE, A.ITEMCODE FULLITEMCODE, STIME, STOPCOUNT, FLGID, MINSTIME, KIND, LEAF FROM (SELECT IID, COMPID, BLOCKCODE, ITEMCODE, POSITION, ITEMLEVEL, CAP1, CAP2, CAP3, CAP4, CAP5, CAP6, CAP7, CAP8, CAP9, CAP10, CODE1, CODE2, CODE3, CODE4, CODE5, CODE6, CODE7, CODE8, CODE9, CODE10, STOPED, ITEMCODE FULLITEMCODE, STIME, STOPCOUNT, FLGID, KIND, LEAF FROM (SELECT /+ NO_MERGE(A) NO_MERGE(B)/ A.FLGID, A.BLOCKCODE, A.ITEMCODE, A.POSITION, A.ITEMLEVEL, A.LEAF, A.IID, A.CAPTION, A.CODE, A.ZJM, A.STIME, DECODE(B.ISSTOP, 1, NVL(A.ETIME, A.STIME), A.ETIME) ETIME, A.CAP1, A.CAP2, A.CAP3, A.CAP4, A.CAP5, A.CAP6, A.CAP7, A.CAP8, A.CAP9, A.CAP10, A.CODE1, A.CODE2, A.CODE3, A.CODE4, A.CODE5, A.CODE6, A.CODE7, A.CODE8, A.CODE9, A.CODE10, B.ISSTOP AS STOPED, A.KIND, A.STOPCOUNT, A.COMPID FROM FMIS0400.ZWITEMSYW A, (SELECT A.IID, A.ITEMCODE, MIN(SIGN(A.STOPED+B.ISSTOP)) AS ISSTOP, A.STOPED FROM (SELECT IID, ITEMCODE, LEAF, LEVEL, STOPED, ETIME, DECODE(INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>'), 0, SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3, INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>')-1)) AS START_ID FROM (SELECT * FROM FMIS0400.ZWITEMSYW WHERE STIME <= TO_DATE('2012-01-01', 'YYYY-MM-DD') AND ETIME > TO_DATE('2012-01-01', 'YYYY-MM-DD')) CONNECT BY TRIM(ITEMCODE)=PRIOR SUBSTR(ITEMCODE, 1, LENGTH(TRIM(ITEMCODE))-4) START WITH LEAF=1) A, FMIS0400.ZWITEMSYWASSIGN B WHERE B.KMID=A.START_ID AND B.COMPID= '0401' GROUP BY A.IID, A.ITEMCODE, A.STOPED) B WHERE A.STIME <= TO_DATE('2012-01-01', 'YYYY-MM-DD') AND A.ETIME > TO_DATE('2012-01-01', 'YYYY-MM-DD') AND B.ITEMCODE=A.ITEMCODE AND B.STOPED=A.STOPED ) Where ( STIME<=to_date('2012-01-01', 'yyyy-mm-dd') and ETIME>to_date('2012-01-01', 'yyyy-mm-dd') ) ) A, (SELECT ITEMCODE, MIN(STIME) MINSTIME FROM (SELECT /+ NO_MERGE(A) NO_MERGE(B)/ A.FLGID, A.BLOCKCODE, A.ITEMCODE, A.POSITION, A.ITEMLEVEL, A.LEAF, A.IID, A.CAPTION, A.CODE, A.ZJM, A.STIME, DECODE(B.ISSTOP, 1, NVL(A.ETIME, A.STIME), A.ETIME) ETIME, A.CAP1, A.CAP2, A.CAP3, A.CAP4, A.CAP5, A.CAP6, A.CAP7, A.CAP8, A.CAP9, A.CAP10, A.CODE1, A.CODE2, A.CODE3, A.CODE4, A.CODE5, A.CODE6, A.CODE7, A.CODE8, A.CODE9, A.CODE10, B.ISSTOP AS STOPED, A.KIND, A.STOPCOUNT, A.COMPID FROM FMIS0400.ZWITEMSYW A, (SELECT A.IID, A.ITEMCODE, MIN(SIGN(A.STOPED+B.ISSTOP)) AS ISSTOP, A.STOPED FROM (SELECT IID, ITEMCODE, LEAF, LEVEL, STOPED, ETIME, DECODE(INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>'), 0, SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3, INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>')-1)) AS START_ID FROM (SELECT * FROM FMIS0400.ZWITEMSYW WHERE STIME <= TO_DATE('2012-01-01', 'YYYY-MM-DD') AND ETIME > TO_DATE('2012-01-01', 'YYYY-MM-DD')) CONNECT BY TRIM(ITEMCODE)=PRIOR SUBSTR(ITEMCODE, 1, LENGTH(TRIM(ITEMCODE))-4) START WITH LEAF=1) A, FMIS0400.ZWITEMSYWASSIGN B WHERE B.KMID=A.START_ID AND B.COMPID= '0401' GROUP BY A.IID, A.ITEMCODE, A.STOPED) B WHERE A.STIME <= TO_DATE('2012-01-01', 'YYYY-MM-DD') AND A.ETIME > TO_DATE('2012-01-01', 'YYYY-MM-DD') AND B.ITEMCODE=A.ITEMCODE AND B.STOPED=A.STOPED ) GROUP BY ITEMCODE) B WHERE A.ITEMCODE = B.ITEMCODE ORDER BY BLOCKCODE, CODE, POSITION
7qs695t2jkdpa	select distinct a.itemcode from ZWITEMSYWQX a, xtpostop b where b.yhdm=1111156303 and instr(a.qx, b.postid) > 0 order by itemCode
7vgmvmy8vvb9s	insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)
8h60j55jzkkb9	delete from procedurejava$ where obj#=:1
8hkh4yxcygxj6	delete from procedureplsql$ where obj#=:1
8pn2d8msd9v06	delete from dir$ where obj#=:1
9y7s2afnkqs9d	delete from idl_ub2$ where obj#=:1 and part=:2
a16hu5wzwq421	BEGIN vPD_PKG.SET_CONTEXT_COMPID('0400'); END;
ahf8czff1p9f9	delete from settings$ where obj# = :1
atcygnsmnjys0	select FLGID, ITEMCODE, CAPTION, CODE, IID, ZJM, BLOCKCODE from (SELECT /+ NO_MERGE(A) NO_MERGE(B)/ A.FLGID, A.BLOCKCODE, A.ITEMCODE, A.POSITION, A.ITEMLEVEL, A.LEAF, A.IID, A.CAPTION, A.CODE, A.ZJM, A.STIME, DECODE(B.ISSTOP, 1, NVL(A.ETIME, A.STIME), A.ETIME) ETIME, A.CAP1, A.CAP2, A.CAP3, A.CAP4, A.CAP5, A.CAP6, A.CAP7, A.CAP8, A.CAP9, A.CAP10, A.CODE1, A.CODE2, A.CODE3, A.CODE4, A.CODE5, A.CODE6, A.CODE7, A.CODE8, A.CODE9, A.CODE10, B.ISSTOP AS STOPED, A.KIND, A.STOPCOUNT, A.COMPID FROM FMIS0400.ZWITEMSYW A, (SELECT A.IID, A.ITEMCODE, MIN(SIGN(A.STOPED+B.ISSTOP)) AS ISSTOP, A.STOPED FROM (SELECT IID, ITEMCODE, LEAF, LEVEL, STOPED, ETIME, DECODE(INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>'), 0, SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3, INSTR(SUBSTR(SYS_CONNECT_BY_PATH(IID, '=>'), 3), '=>')-1)) AS START_ID FROM (SELECT * FROM FMIS0400.ZWITEMSYW WHERE STIME <= TO_DATE('2012-03-01', 'YYYY-MM-DD') AND ETIME > TO_DATE('2012-03-01', 'YYYY-MM-DD')) CONNECT BY TRIM(ITEMCODE)=PRIOR SUBSTR(ITEMCODE, 1, LENGTH(TRIM(ITEMCODE))-4) START WITH LEAF=1) A, FMIS0400.ZWITEMSYWASSIGN B WHERE B.KMID=A.START_ID AND B.COMPID= '0401' GROUP BY A.IID, A.ITEMCODE, A.STOPED) B WHERE A.STIME <= TO_DATE('2012-03-01', 'YYYY-MM-DD') AND A.ETIME > TO_DATE('2012-03-01', 'YYYY-MM-DD') AND B.ITEMCODE=A.ITEMCODE AND B.STOPED=A.STOPED ) where IsNull(STOPCOUNT, 0) = 0 and LEAF=1 and STIME <= to_date('2012-03-01', 'yyyy-mm-dd') and ETIME > to_date('2012-03-01', 'yyyy-mm-dd') order by POSITION
av0kjjbhc642q	delete from objauth$ where obj#=:1
bdx6s0wp1dh3t	delete from context$ where obj#=:1
bk4zdy7ksxag7	SELECT MSG_ID, MSG_CONSUME FROM MSG_QUEUE WHERE MSG_SUCCEED=0 AND MSG_KEY IS NULL AND ROWNUM <= 100 ORDER BY MSG_RECV
bvskgnk4p3x2w	DECLARE V_PROGRAM VARCHAR2(100); V_SESSIONID NUMBER(10); V_CONTEXT VARCHAR2(32); BEGIN SELECT MAX(TRIM(UPPER(PROGRAM))), MAX(TRIM(UPPER(USERNAME))) INTO V_PROGRAM, V_CONTEXT FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID'); IF SUBSTR(V_PROGRAM, 1, 3) IN ('EXP', 'IMP') THEN VPD_PKG.SET_CONTEXT_COMPID('-1'); VPD_PKG.SET_CONTEXT_VPD_YEAR('-1'); VPD_PKG.SET_CONTEXT_ACCBOOKID('-1'); ELSE VPD_PKG.SET_CONTEXT_COMPID(REPLACE(SUBSTR(V_CONTEXT, 5), '_TOP', '9999')); VPD_PKG.SET_CONTEXT_VPD_YEAR(TO_CHAR(SYSDATE, 'YYYYMMDD')); VPD_PKG.SET_CONTEXT_ACCBOOKID('0'); END IF; END;
c2aw4fq306q4k	INSERT /+ APPEND / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
c3uk9spac8d28	delete from library$ where obj#=:1
cfz686a6qp0kg	select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#
d3c7d056xt3cg	INSERT INTO HZ_LOG (LOG_NO, USER_NAME, BEGIN_TIME, END_TIME, LOG_LEVEL, LOG_TYPE, SQL_TEXT, SQL_TEXT1, SQL_TEXT2, LOG_DETAIL, IP_ADDRESS, TIMES) VALUES (HZ_SEQ.NEXTVAL, SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA'), SYSDATE, SYSDATE, :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , SYS_CONTEXT('USERENV', 'IP_ADDRESS'), :B1 )
d5jd9b2xct7xz	delete from idl_char$ where obj#=:1 and part=:2
dhx4hx5kz79bf	delete from javaobj$ where obj#=:1
dpy0rv0dz6kgb	BEGIN KMSUMQUERY_FBQS(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13); END;
dqmvgn5svxvcm	BEGIN PA_FMIS_BASE.NEWENTITY(:1, :2); END;
dvpfc386d6dmm	delete from idl_sb4$ where obj#=:1 and part=:2
f67hktj85gdrc	BEGIN vPD_PKG.SET_CONTEXT_COMPID('-1'); END;
f6ynnf6u0cmv4	UPDATE XTYHXX SET XSMC = :1, EMAIL = :2, STOPED = :3 WHERE UPPER(YHMC) = UPPER(:4)
g73tzgnm4722f	select u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o, user$ u, trigger$ where bitand(trigger$.property, 16) = 16 and trigger$.baseobject = :1 and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj#
gdhz78y24tvnz	delete from ncomp_dll$ where obj#=:1 returning dllname into :2
gfjvxb25b773h	select o.owner#, o.obj#, decode(o.linkname, null, decode(u.name, null, 'SYS', u.name), o.remoteowner), o.name, o.linkname, o.namespace, o.subname from user$ u, obj$ o where u.user#(+)=o.owner# and o.type#=:1 and not exists (select p_obj# from dependency$ where p_obj# = o.obj#) order by o.obj# for update
ght3kqjqw74ff	delete from procedure$ where obj#=:1
gm1wjg2cvyqtv	BEGIN KMDETAILQUERY(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23); END;
gmhmap859gq7y	delete from opbinding$ where obj#=:1
gsqxm6zz3w2by	delete from idl_ub1$ where obj#=:1 and part=:2

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	10,001	2.74	1.19
CPU used when call started	5,651	1.55	0.67
CR blocks created	810	0.22	0.10
Cached Commit SCN referenced	180	0.05	0.02
Commit SCN cached	3	0.00	0.00
DB time	14,034,197	3,841.35	1,673.33
DBWR checkpoint buffers written	3,318	0.91	0.40
DBWR checkpoints	1,082	0.30	0.13
DBWR fusion writes	120	0.03	0.01
DBWR object drop buffers written	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	178	0.05	0.02
DBWR undo block writes	1,526	0.42	0.18
DFO trees parallelized	6	0.00	0.00
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	15	0.00	0.00
PX local messages sent	15	0.00	0.00
PX remote messages recv'd	75	0.02	0.01
PX remote messages sent	63	0.02	0.01
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	6	0.00	0.00
RowCR - row contention	0	0.00	0.00
RowCR attempts	3	0.00	0.00
RowCR hits	3	0.00	0.00
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment shrink	4	0.00	0.00
SQL*Net roundtrips to/from client	94,063	25.75	11.22
active txn count during cleanout	1,030	0.28	0.12
application wait time	486	0.13	0.06
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	12,579	3.44	1.50
branch node splits	0	0.00	0.00
buffer is not pinned count	1,054,064	288.51	125.68
buffer is pinned count	783,064	214.33	93.37
bytes received via SQL*Net from client	10,555,929	2,889.30	1,258.61
bytes sent via SQL*Net to client	21,486,240	5,881.07	2,561.85
calls to get snapshot scn: kcmgss	297,760	81.50	35.50
calls to kcmgas	14,454	3.96	1.72
calls to kcmgcs	377	0.10	0.04
change write time	689	0.19	0.08
cleanout - number of ktugct calls	1,087	0.30	0.13
cleanouts and rollbacks - consistent read gets	491	0.13	0.06
cleanouts only - consistent read gets	109	0.03	0.01
cluster key scan block gets	1,966	0.54	0.23
cluster key scans	848	0.23	0.10
cluster wait time	500	0.14	0.06
commit batch/immediate performed	198	0.05	0.02
commit batch/immediate requested	198	0.05	0.02
commit cleanout failures: block lost	111	0.03	0.01
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	14	0.00	0.00
commit cleanout failures: cannot pin	63	0.02	0.01
commit cleanouts	21,491	5.88	2.56
commit cleanouts successfully completed	21,303	5.83	2.54
commit immediate performed	198	0.05	0.02
commit immediate requested	198	0.05	0.02
commit txn count during cleanout	414	0.11	0.05
concurrency wait time	11,199,262	3,065.39	1,335.31
consistent changes	2,481	0.68	0.30
consistent gets	3,182,862	871.19	379.50
consistent gets - examination	221,229	60.55	26.38
consistent gets direct	19	0.01	0.00
consistent gets from cache	3,182,841	871.19	379.50
current blocks converted for CR	0	0.00	0.00
cursor authentications	164	0.04	0.02
data blocks consistent reads - undo records applied	1,241	0.34	0.15
db block changes	390,363	106.85	46.54
db block gets	388,598	106.36	46.33
db block gets direct	271	0.07	0.03
db block gets from cache	388,330	106.29	46.30
deferred (CURRENT) block cleanout applications	12,374	3.39	1.48
dirty buffers inspected	0	0.00	0.00
enqueue conversions	2,740	0.75	0.33
enqueue deadlocks	0	0.00	0.00
enqueue releases	59,398	16.26	7.08
enqueue requests	58,099	15.90	6.93
enqueue timeouts	22	0.01	0.00
enqueue waits	1,963	0.54	0.23
exchange deadlocks	4	0.00	0.00
execute count	235,082	64.35	28.03
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	5,205	1.42	0.62
free buffer requested	14,972	4.10	1.79
gc CPU used by this session	1,116	0.31	0.13
gc blocks lost	0	0.00	0.00
gc cr block build time	9	0.00	0.00
gc cr block flush time	23	0.01	0.00
gc cr block receive time	487	0.13	0.06
gc cr block send time	12	0.00	0.00
gc cr blocks received	7,408	2.03	0.88
gc cr blocks served	2,470	0.68	0.29
gc current block flush time	0	0.00	0.00
gc current block pin time	11	0.00	0.00
gc current block receive time	275	0.08	0.03
gc current block send time	5	0.00	0.00
gc current blocks received	3,327	0.91	0.40
gc current blocks served	793	0.22	0.09
gc local grants	596	0.16	0.07
gc remote grants	422	0.12	0.05
gcs messages sent	28,265	7.74	3.37
ges messages sent	91,751	25.11	10.94
global enqueue get time	9,250,404	2,531.96	1,102.95
global enqueue gets async	21,602	5.91	2.58
global enqueue gets sync	92,766	25.39	11.06
global enqueue releases	93,812	25.68	11.19
heap block compress	153	0.04	0.02
hot buffers moved to head of LRU	403	0.11	0.05
immediate (CR) block cleanout applications	603	0.17	0.07
immediate (CURRENT) block cleanout applications	3,214	0.88	0.38
index crx upgrade (found)	6	0.00	0.00
index crx upgrade (positioned)	38,346	10.50	4.57
index fast full scans (full)	42	0.01	0.01
index fetch by key	54,714	14.98	6.52
index scans kdiixs1	841,534	230.34	100.34
leaf node 90-10 splits	21	0.01	0.00
leaf node splits	51	0.01	0.01
lob reads	19	0.01	0.00
lob writes	198	0.05	0.02
lob writes unaligned	198	0.05	0.02
logons cumulative	621	0.17	0.07
messages received	49,063	13.43	5.85
messages sent	49,063	13.43	5.85
no buffer to keep pinned count	2	0.00	0.00
no work - consistent read gets	2,842,469	778.02	338.91
opened cursors cumulative	119,611	32.74	14.26
parse count (failures)	1	0.00	0.00
parse count (hard)	6,211	1.70	0.74
parse count (total)	216,411	59.23	25.80
parse time cpu	611	0.17	0.07
parse time elapsed	777,133	212.71	92.66
physical read IO requests	149	0.04	0.02
physical read bytes	4,145,152	1,134.58	494.24
physical read total IO requests	16,012	4.38	1.91
physical read total bytes	264,044,544	72,272.48	31,482.60
physical read total multi block requests	38	0.01	0.00
physical reads	253	0.07	0.03
physical reads cache	234	0.06	0.03
physical reads cache prefetch	104	0.03	0.01
physical reads direct	19	0.01	0.00
physical reads direct (lob)	19	0.01	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	1,969	0.54	0.23
physical write bytes	60,571,648	16,579.26	7,222.09
physical write total IO requests	16,934	4.64	2.02
physical write total bytes	227,863,552	62,369.26	27,168.66
physical write total multi block requests	11,089	3.04	1.32
physical writes	3,697	1.01	0.44
physical writes direct	271	0.07	0.03
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	3,426	0.94	0.41
physical writes non checkpoint	1,550	0.42	0.18
pinned buffers inspected	0	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	21,677	5.93	2.58
queries parallelized	6	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	803,804	220.01	95.84
recursive cpu usage	1,350	0.37	0.16
redo blocks written	111,051	30.40	13.24
redo buffer allocation retries	0	0.00	0.00
redo entries	200,554	54.89	23.91
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	1,492	0.41	0.18
redo size	53,799,036	14,725.51	6,414.57
redo subscn max counts	1,370	0.37	0.16
redo synch time	771	0.21	0.09
redo synch writes	5,016	1.37	0.60
redo wastage	1,448,776	396.55	172.74
redo write time	650	0.18	0.08
redo writer latching time	2	0.00	0.00
redo writes	5,769	1.58	0.69
rollback changes - undo records applied	208	0.06	0.02
rollbacks only - consistent read gets	311	0.09	0.04
rows fetched via callback	13,300	3.64	1.59
session connect time	0	0.00	0.00
session cursor cache hits	95,880	26.24	11.43
session logical reads	3,571,460	977.56	425.83
session uga memory max	318,134,920	87,077.73	37,931.91
shared hash latch upgrades - no wait	50,301	13.77	6.00
shared hash latch upgrades - wait	6	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	17,304	4.74	2.06
sorts (rows)	2,471,128	676.38	294.64
sql area evicted	4,176	1.14	0.50
sql area purged	29	0.01	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	2,487	0.68	0.30
table fetch by rowid	52,646	14.41	6.28
table fetch continued row	37	0.01	0.00
table scan blocks gotten	1,271,251	347.96	151.57
table scan rows gotten	222,572,589	60,921.06	26,537.81
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	32,259	8.83	3.85
total number of times SMON posted	1,117	0.31	0.13
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	198	0.05	0.02
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	20,097,896	5,501.06	2,396.32
user I/O wait time	197	0.05	0.02
user calls	126,041	34.50	15.03
user commits	3,756	1.03	0.45
user rollbacks	4,631	1.27	0.55
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	10,176	2.79	1.21
write clones created in background	0	0.00	0.00
write clones created in foreground	0	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	194,087	199,797
opened cursors current	1,822	642
logons current	131	137

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)	0	0.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 Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
SYSTEM	17	10.59	1.00	733	92	1.63
UNDOTBS1	0	0.00	0.00	538	10	0.00
FMIS0400	68	1.18	2.53	310	72	1.81
SYSAUX	27	7.78	1.00	248	0	0.00
CWGK_IMS	1	10.00	1.00	84	0	0.00
FMIS_LARGE	0	0.00	0.00	35	0	0.00
FMISINDEX	2	5.00	1.00	20	8	21.25
FMIS_LOB	19	2.63	1.00	1	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
CWGK_IMS	/dev/rlv_vpd_CWGK_IMS	1	10.00	1.00	84	0	0.00
FMIS0400	/dev/rlv_VPD0400_20	1	0.00	4.00	6	0	0.00
FMIS0400	/dev/rlv_VPD0400_21	1	0.00	3.00	3	0	0.00
FMIS0400	/dev/rlv_VPD0400_23	2	5.00	1.00	4	0	0.00
FMIS0400	/dev/rlv_VPD0400_24	7	0.00	1.29	24	0	0.00
FMIS0400	/dev/rlv_VPD0400_25	1	10.00	4.00	12	0	0.00
FMIS0400	/dev/rlv_VPD0400_26	1	0.00	4.00	7	0	0.00
FMIS0400	/dev/rlv_VPD0400_27	1	0.00	4.00	3	0	0.00
FMIS0400	/dev/rlv_VPD0400_28	1	0.00	4.00	3	0	0.00
FMIS0400	/dev/rlv_VPD0400_29	1	0.00	4.00	3	0	0.00
FMIS0400	/dev/rlv_VPD0400_30	8	1.25	1.63	30	0	0.00
FMIS0400	/dev/rlv_vpd0400_01	2	5.00	4.00	40	23	0.43
FMIS0400	/dev/rlv_vpd0400_02	8	2.50	1.88	53	49	2.45
FMIS0400	/dev/rlv_vpd0400_03	2	0.00	4.00	10	0	0.00
FMIS0400	/dev/rlv_vpd0400_04	2	0.00	4.00	7	0	0.00
FMIS0400	/dev/rlv_vpd0400_05	2	0.00	3.50	7	0	0.00
FMIS0400	/dev/rlv_vpd0400_06	1	0.00	4.00	9	0	0.00
FMIS0400	/dev/rlv_vpd0400_07	1	0.00	4.00	3	0	0.00
FMIS0400	/dev/rlv_vpd0400_08	1	10.00	4.00	1	0	0.00
FMIS0400	/dev/rlv_vpd0400_09	1	0.00	4.00	2	0	0.00
FMIS0400	/dev/rlv_vpd0400_10	8	0.00	1.63	31	0	0.00
FMIS0400	/dev/rlv_vpd0400_11	2	0.00	3.50	2	0	0.00
FMIS0400	/dev/rlv_vpd0400_12	1	0.00	4.00	3	0	0.00
FMIS0400	/dev/rlv_vpd0400_13	1	0.00	4.00	1	0	0.00
FMIS0400	/dev/rlv_vpd0400_14	1	0.00	4.00	3	0	0.00
FMIS0400	/dev/rlv_vpd0400_15	1	0.00	4.00	3	0	0.00
FMIS0400	/dev/rlv_vpd0400_16	1	0.00	4.00	5	0	0.00
FMIS0400	/dev/rlv_vpd0400_17	1	10.00	4.00	3	0	0.00
FMIS0400	/dev/rlv_vpd0400_18	7	0.00	1.57	28	0	0.00
FMIS0400	/dev/rlv_vpd0400_19	1	0.00	4.00	4	0	0.00
FMISINDEX	/dev/rlv_vpdindex1	0			20	8	21.25
FMISINDEX	/dev/rlv_vpdindex3	1	0.00	1.00	0	0	0.00
FMISINDEX	/dev/rlv_vpdindex6	1	10.00	1.00	0	0	0.00
FMIS_LARGE	/dev/rlv_vpd_large3	0			35	0	0.00
FMIS_LOB	/dev/rlv_vpd_lob1	18	2.22	1.00	1	0	0.00
FMIS_LOB	/dev/rlv_vpd_lob4	1	10.00	1.00	0	0	0.00
SYSAUX	/dev/rlv_vpdsysaux01	27	7.78	1.00	248	0	0.00
SYSTEM	/dev/rlv_vpdsystem01	13	10.77	1.00	341	57	2.11
SYSTEM	/dev/rlv_vpdsystem02	4	10.00	1.00	392	35	0.86
UNDOTBS1	/dev/rlv_vpdundo1_1	0			161	1	0.00
UNDOTBS1	/dev/rlv_vpdundo1_2	0			141	3	0.00
UNDOTBS1	/dev/rlv_vpdundo1_3	0			125	3	0.00
UNDOTBS1	/dev/rlv_vpdundo1_4	0			111	3	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	Buffer Busy Waits
D	506,880	100	3,571,102	228	3,426	181
K	24,750		0	0	0	0
R	24,750	100	15	0	0	0

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	0	237	1665	32744	2764800	32744
E	0	0	543	5173	14845	2764800	14845

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	816	0.10	50,490	2.95	936,779,527
D	1,632	0.20	100,980	1.51	477,914,386
D	2,448	0.30	151,470	1.22	387,057,468
D	3,264	0.40	201,960	1.11	352,378,345
D	4,080	0.50	252,450	1.06	334,955,457
D	4,896	0.60	302,940	1.03	327,352,061
D	5,712	0.70	353,430	1.02	323,236,927
D	6,528	0.80	403,920	1.01	320,554,549
D	7,344	0.90	454,410	1.00	318,764,010
D	8,160	1.00	504,900	1.00	317,538,876
D	8,192	1.00	506,880	1.00	317,496,971
D	8,976	1.10	555,390	1.00	316,754,229
D	9,792	1.20	605,880	1.00	316,168,083
D	10,608	1.29	656,370	0.99	315,530,814
D	11,424	1.39	706,860	0.99	315,078,580
D	12,240	1.49	757,350	0.99	314,731,010
D	13,056	1.59	807,840	0.99	314,440,061
D	13,872	1.69	858,330	0.99	314,168,999
D	14,688	1.79	908,820	0.99	313,955,567
D	15,504	1.89	959,310	0.99	313,718,101
D	16,320	1.99	1,009,800	0.94	298,334,753

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	1,299	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	1,958	1,413	824.47	0.00	0.00	0.00	0.00	200,490
E	1,958	1,545	638.21	0.00	0.00	0.00	0.00	200,490

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	8,393	8,393
64K	128K	16	16
128K	256K	49	49
256K	512K	268	268
512K	1024K	1,292	1,292
1M	2M	157	157

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
245	0.13	10,126,519.27	553,971.13	95.00	73,918
490	0.25	10,126,519.27	33,129.80	100.00	4,656
979	0.50	10,126,519.27	11,533.76	100.00	1,337
1,469	0.75	10,126,519.27	6,092.67	100.00	0
1,958	1.00	10,126,519.27	5,032.78	100.00	0
2,350	1.20	10,126,519.27	643.26	100.00	0
2,741	1.40	10,126,519.27	643.26	100.00	0
3,133	1.60	10,126,519.27	643.26	100.00	0
3,524	1.80	10,126,519.27	643.26	100.00	0
3,916	2.00	10,126,519.27	643.26	100.00	0
5,874	3.00	10,126,519.27	643.26	100.00	0
7,832	4.00	10,126,519.27	643.26	100.00	0
11,748	6.00	10,126,519.27	643.26	100.00	0
15,664	8.00	10,126,519.27	643.26	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
2,848	0.70	469	59,246	6,633,229	0.96	449,293	2.77	1,228,385,295
3,264	0.80	882	83,205	6,731,221	0.97	351,301	2.16	1,232,752,750
3,680	0.90	1,296	115,647	6,797,911	0.98	284,611	1.75	1,234,481,784
4,096	1.00	1,711	139,476	6,920,095	1.00	162,427	1.00	1,236,783,984
4,512	1.10	2,125	162,987	7,032,905	1.02	49,617	0.31	1,238,110,637
4,928	1.20	2,540	186,000	7,150,231	1.03	1	0.00	1,239,148,492
5,344	1.30	2,955	213,840	7,225,088	1.04	1	0.00	1,239,930,940
5,760	1.41	3,370	244,175	7,305,510	1.06	1	0.00	1,240,759,697
6,176	1.51	3,785	272,199	7,373,630	1.07	1	0.00	1,241,432,449
6,592	1.61	4,199	299,447	7,450,110	1.08	1	0.00	1,242,065,641
7,008	1.71	4,614	327,171	7,529,590	1.09	1	0.00	1,242,719,424
7,424	1.81	5,029	357,285	7,604,256	1.10	1	0.00	1,243,259,268
7,840	1.91	5,444	385,958	7,690,248	1.11	1	0.00	1,243,838,437
8,256	2.02	5,859	416,237	7,740,684	1.12	1	0.00	1,244,270,653

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	1.00	0	0	0	0
32	2.00	0	0	0	0
48	3.00	0	0	0	0
64	4.00	0	0	0	0
80	5.00	0	0	0	0
96	6.00	0	0	0	0
112	7.00	0	0	0	0
128	8.00	0	0	0	0
144	9.00	0	0	0	0
160	10.00	0	0	0	0
176	11.00	0	0	0	0
192	12.00	0	0	0	0
208	13.00	0	0	0	0
224	14.00	0	0	0	0
240	15.00	0	0	0	0
256	16.00	0	0	0	0
272	17.00	0	0	0	0
288	18.00	0	0	0	0
304	19.00	0	0	0	0
320	20.00	0	0	0	0

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	Avg Time (ms)
data block	171	3
undo block	7	0
undo header	3	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)
CF-Controlfile Transaction	8,444	8,434	10	132	2,155	16,323.95
SQ-Sequence Cache	26	26	0	5	2,129	425,863.60
DR-Distributed Recovery	2	2	0	2	1,187	593,607.00
TD-KTF map table enqueue (KTF dump entries)	8	2	6	8	29	3,564.88
TX-Transaction (row lock contention)	403	389	0	376	5	12.06
WF-AWR Flush	29	28	1	21	4	177.48
TT-Tablespace	291	291	0	124	1	11.63
RO-Multiple Object Reuse (fast object reuse)	4,328	4,328	0	1,082	0	0.34
TM-DML	10,957	10,957	0	161	0	0.48
PI-Remote PX Process Spawn Status	3	3	0	1	0	37.00
PS-PX Process Reservation	50	49	1	27	0	1.00
TX-Transaction (index contention)	9	7	0	4	0	4.75
MW-MWIN Schedule	2	2	0	2	0	5.00
TO-Temp Object	22	22	0	8	0	0.75
FB-Format Block	11	11	0	3	0	1.00
US-Undo Segment	5	5	0	3	0	1.00
DL-Direct Loader Index Creation	4	4	0	2	0	1.00
AF-Advisor Framework (task serialization)	7	7	0	1	0	1.00
TA-Instance Undo	14	14	0	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
1	1.51	7,015	413	10	15/58.3	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-3月 04:01	182	1,012	413	3	21	0/0	0/0/0/0/0/0
02-3月 03:51	61	1,224	363	9	20	0/0	0/0/0/0/0/0
02-3月 03:41	47	850	357	3	20	0/0	0/0/0/0/0/0
02-3月 03:31	39	962	0	10	15	0/0	0/0/0/0/0/0
02-3月 03:21	25	530	0	5	15	0/0	0/0/0/0/0/0
02-3月 03:11	1,098	1,471	0	3	58	0/0	0/0/0/0/0/0
02-3月 03:01	57	966	0	3	48	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	9,616	0.00		0	0
AWR Alerted Metric Element list	33,248	0.00		0	0
Consistent RBA	5,769	0.00		0	0
FAL request queue	55	0.00		0	0
FAL subheap alocation	55	0.00		0	0
FOB s.o list latch	4,577	0.98	0.00	0	0
JS broadcast add buf latch	607	0.00		0	0
JS broadcast drop buf latch	607	0.00		0	0
JS broadcast load blnc latch	530	0.00		0	0
JS queue state obj latch	19,080	0.00		0	0
JS slv state obj latch	5	0.00		0	0
KCL gc element parent latch	47,122	0.03	0.06	0	96	0.00
KJC message pool free list	37,864	0.03	0.00	0	2,389	0.04
KJCT flow control latch	187,274	0.03	0.00	0	0
KMG MMAN ready and startup request latch	1,218	0.00		0	0
KSXR large replies	80	0.00		0	0
KTF sga latch	10	0.00		0	997	0.00
KWQMN job cache list latch	306	0.00		0	0
KWQP Prop Status	2	0.00		0	0
MQL Tracking Latch	0			0	73	0.00
Memory Management Latch	0			0	1,218	0.00
OS process	1,827	0.00		0	0
OS process allocation	2,443	0.12	0.00	0	0
OS process: request allocation	1,197	0.33	0.00	0	0
PL/SQL warning settings	20,608	0.00		0	0
SGA IO buffer pool latch	3	0.00		0	3	0.00
SQL memory manager latch	1	0.00		0	990	0.00
SQL memory manager workarea list latch	70,381	0.00		0	0
Shared B-Tree	133	0.00		0	0
active checkpoint queue latch	18,569	1.44	0.00	0	0
active service list	8,810	0.05	0.00	0	1,257	0.00
archive control	45	0.00		0	0
archive process latch	1,100	0.00		0	0
begin backup scn array	81	0.00		0	0
business card	12	0.00		0	0
cache buffer handles	569	0.00		0	0
cache buffers chains	7,774,162	0.05	0.01	0	76,427	0.00
cache buffers lru chain	29,738	0.42	0.02	0	88,051	0.01
cache table scan latch	0			0	38	0.00
channel handle pool latch	1,436	0.21	0.00	0	0
channel operations parent latch	1,496,612	0.01	0.16	0	0
checkpoint queue latch	346,712	0.00		0	3,957	0.00
client/application info	3,179	0.00		0	0
commit callback allocation	164	0.00		0	0
compile environment latch	622	0.00		0	0
dictionary lookup	99	0.00		0	0
dml lock allocation	22,060	0.05	0.64	0	0
dummy allocation	1,238	0.08	0.00	0	0
enqueue hash chains	155,737	0.04	0.00	0	5,658	0.00
enqueues	106,443	0.05	0.00	0	0
error message lists	24	0.00		0	0
event group latch	602	0.00		0	0
file cache latch	1,160	0.60	0.00	0	0
gcs opaque info freelist	4,962	0.00		0	0
gcs partitioned table hash	68,898	0.00		0	0
gcs remastering latch	14	0.00		0	0
gcs resource freelist	1,584	0.00		0	927	0.00
gcs resource hash	42,432	0.13	0.00	0	54	0.00
gcs resource scan list	108	0.00		0	0
gcs shadows freelist	1,299	0.00		0	1,298	0.00
ges caches resource lists	983,647	0.23	0.00	0	1,011,514	0.16
ges deadlock list	20,826	0.00		0	1,467	0.00
ges domain table	124,297	0.00	0.00	0	0
ges enqueue table freelist	679,702	0.01	0.04	0	0
ges group table	186,927	0.01	0.00	0	0
ges process hash list	133,492	0.20	0.98	0	0
ges process parent latch	946,793	0.00	0.00	0	1	0.00
ges process table freelist	1,197	0.33	0.00	0	0
ges resource hash list	2,063,869	0.10	0.54	4	723,074	0.00
ges resource scan list	788	0.00		0	0
ges resource table freelist	598,203	0.00	0.00	0	0
ges timeout list	32,084	0.00		0	105,814	0.00
global KZLD latch for mem in SGA	589	0.00		0	0
global ctx hash table latch	1,178	0.00		0	0
hash table column usage latch	303	0.00		0	9,623	0.00
hash table modification latch	94	0.00		0	0
job_queue_processes parameter latch	45	0.00		0	0
kks stats	28,090	0.24	0.36	0	0
kokc descriptor allocation latch	354	0.00		0	0
ksuosstats global area	246	0.00		0	0
ktm global data	1,137	0.00		0	0
kwqbsn:qsga	132	0.00		0	0
lgwr LWN SCN	6,246	0.10	0.00	0	0
library cache	1,247,971	0.20	0.14	18	95,480	0.06
library cache load lock	10,383	0.18	0.00	0	30,993	0.00
library cache lock	782,460	0.06	0.00	0	0
library cache lock allocation	5,316	0.00		0	0
library cache pin	382,491	0.07	0.00	0	1	0.00
library cache pin allocation	18,156	0.02	0.00	0	0
list of block allocation	2,253	0.00		0	0
loader state object freelist	112	0.00		0	0
logminer context allocation	1	0.00		0	0
message pool operations parent latch	8,545	0.01	0.00	0	0
messages	327,732	0.25	0.00	0	0
mostly latch-free SCN	6,253	0.27	0.00	0	0
multiblock read objects	8,620	0.00		0	0
name-service memory objects	2,509	0.00		0	0
name-service namespace bucket	36,789	0.00		0	0
name-service namespace objects	2	0.00		0	0
name-service pending queue	2,034	0.00		0	0
name-service request	8	0.00		0	0
name-service request queue	37,781	0.00		0	0
ncodef allocation latch	60	0.00		0	0
object queue header heap	352	0.00		0	976	0.00
object queue header operation	109,959	0.32	0.04	0	0
object stats modification	2,496	0.00		0	0
parallel query alloc buffer	615	0.00		0	0
parallel query stats	39	0.00		0	0
parallel txn reco latch	3,178	0.00		0	0
parameter list	42	0.00		0	0
parameter table allocation management	624	1.28	0.00	0	0
post/wait queue	7,044	0.00		0	4,941	0.06
process allocation	36,389	0.00	0.00	0	601	0.17
process group creation	1,197	0.25	0.00	0	0
process queue	99	0.00		0	0
process queue reference	2,120	0.00		0	168	0.00
qmn task queue latch	520	0.00		0	0
query server freelists	81	0.00		0	0
query server process	2	50.00	1.00	0	1	0.00
queued dump request	18,269	0.00		0	0
redo allocation	18,343	0.07	0.00	0	200,385	0.04
redo copy	0			0	200,424	0.20
redo writing	31,291	0.26	0.00	0	0
resmgr group change latch	622	0.00		0	0
resmgr:active threads	1,231	0.00		0	0
resmgr:actses change group	610	0.00		0	0
resmgr:free threads list	1,230	0.33	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	553,803	0.74	0.01	1	1,219	0.00
rules engine aggregate statistics	17	0.00		0	0
rules engine rule set statistics	134	0.00		0	0
sequence cache	3,109	0.29	0.00	0	0
session allocation	98,594	0.16	0.00	0	0
session idle bit	275,706	0.01	0.00	0	0
session state list latch	1,382	0.43	0.00	0	0
session switching	60	0.00		0	0
session timer	1,257	0.00		0	0
shared pool	447,666	0.54	0.11	0	0
shared pool simulator	560,110	0.00	0.09	0	0
simulator hash latch	186,635	0.00		0	0
simulator lru latch	0			0	186,551	0.07
slave class	4	0.00		0	0
slave class create	16	6.25	1.00	0	0
sort extent pool	4,119	1.75	0.00	0	0
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
temp lob duration state obj allocation	70	1.43	0.00	0	0
temporary table state object allocation	85	0.00		0	0
threshold alerts latch	323	0.00		0	0
trace latch	37	0.00		0	0
transaction allocation	1,357	0.00		0	0
transaction branch allocation	1,257	0.00		0	0
undo global data	27,940	0.03	0.11	0	0
user lock	2,396	1.04	0.16	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
row cache objects	553,803	4,081	40	4,041
cache buffers chains	7,774,162	3,997	26	3,971
library cache	1,247,971	2,541	344	2,202
shared pool	447,666	2,404	263	2,157
ges caches resource lists	983,647	2,260	1	2,259
ges resource hash list	2,063,869	2,061	1,103	960
object queue header operation	109,959	357	14	343
library cache pin	382,491	279	1	278
ges process hash list	133,492	263	259	4
channel operations parent latch	1,496,612	171	27	145
cache buffers lru chain	29,738	124	3	121
kks stats	28,090	67	24	44
ges enqueue table freelist	679,702	54	2	52
user lock	2,396	25	4	22
shared pool simulator	560,110	22	2	20
KCL gc element parent latch	47,122	16	1	15
dml lock allocation	22,060	11	7	4
undo global data	27,940	9	1	8
query server process	2	1	1	0
slave class create	16	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	kclrwrite	1	0
active service list	ksws_event: ksws event	1	1
cache buffers chains	kcbgtcr: kslbegin excl	32	24
cache buffers chains	kcbchg: kslbegin: bufs not pinned	21	18
cache buffers chains	kcbgcur: kslbegin	15	12
cache buffers chains	kcbgtcr: fast path	11	0
cache buffers chains	kclbla	2	0
cache buffers chains	kclebs_1	2	0
cache buffers chains	kcbrls: kslbegin	1	17
cache buffers lru chain	kcbo_ivd_proc	2	2
cache buffers lru chain	kcbzswcu	1	0
channel operations parent latch	ksrchdelete()	22	2
channel operations parent latch	ksrwait()	19	6
channel operations parent latch	ksrapublish()	1	33
cost function	kzulrl	4	4
dml lock allocation	ktaidm	5	4
dml lock allocation	ktaiam	2	3
ges enqueue table freelist	kjlalc: lock allocation	1	1
ges enqueue table freelist	kjlfr: remove lock from parent object	1	1
ges process hash list	kjakiqa: set inquiry response	259	0
ges resource hash list	kjakcai: search for resp by resname	666	0
ges resource hash list	kjrmas1: lookup master node	143	1
ges resource hash list	kjucvl: lock convert request	103	615
ges resource hash list	kjrref: find matched resource	69	201
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	68	4
ges resource hash list	kjlrlr: remove lock from resource queue	37	285
ges resource hash list	kjcvscn: remove from scan queue	18	0
ges resource hash list	kjtscn: try lock res with nowait	2	0
ges resource table freelist	kjruch: cached obj cleanup	1	0
kks stats	kks stats alloc/free	24	24
library cache	kglobpn: child:	142	212
library cache	kglpndl: child: after processing	69	4
library cache	kgldte: child 0	68	60
library cache	kglpin	17	3
library cache	kgldti: 2child	13	10
library cache	kglLockCursor	7	1
library cache	kglukp: child	5	5
library cache	kglrtl	3	5
library cache	kglhdgn: child:	2	15
library cache	kglpndl: child: before processing	2	23
library cache lock	kgllkdl: child: no lock handle	11	4
library cache pin	kglpnal: child: alloc space	1	0
object queue header operation	kcbo_ivbo	69	68
query server process	kxfpcrer	1	0
row cache objects	kqreqd: reget	38	0
row cache objects	ksucallcbksafely: kqrhngc	2	0
shared pool	kghalo	187	150
shared pool	kghupr1	28	50
shared pool	kghalp	18	22
shared pool	kghfre	15	29
shared pool	kghfrunp: alloc: wait	13	3
shared pool	kghfrunp: clatch: wait	4	2
shared pool	kghasp	2	9
shared pool	kghfrunp: clatch: nowait	1	0
shared pool simulator	kglsim_unpin_simhp	2	0
slave class create	ksvcreate	1	0
undo global data	ktudnx:child	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: 3,571,460
Captured Segments account for 89.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	I_DEPENDENCY2	INDEX	1,430,064	40.04
SYS	SYSTEM	OBJ$	TABLE	453,120	12.69
CWGK_IMS	CWGK_IMS	NBI_LOG_EVENT	TABLE	295,440	8.27
FMIS0400	FMIS0400	MSG_QUEUE	TABLE	229,952	6.44
SYS	SYSTEM	USER$	TABLE	178,928	5.01

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 253
Captured Segments account for 12.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	AUD$	TABLE	13	5.14
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	5	1.98
SYS	SYSTEM	I_AUD1	INDEX	3	1.19
SYS	SYSAUX	WRH$_SQLTEXT	TABLE	2	0.79
SYS	SYSAUX	WRH$_SYSMETRIC_SUMMARY	TABLE	2	0.79

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
FMIS0400	FMIS0400	QRTZ_LOCKS	TABLE	702	93.35
FMIS0400	FMISINDEX	IDU060712193340934	INDEX	33	4.39
FMIS0400	FMIS0400	XTCLUSTERUSER	TABLE	8	1.06
SYS	SYSTEM	I_AUD1	INDEX	5	0.66
SYS	SYSTEM	I_COL1	INDEX	2	0.27

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
FMIS0400	FMIS0400	XTCLUSTERLOCK	TABLE	45	29.22
SYS	SYSTEM	AUD$	TABLE	43	27.92
SYS	SYSTEM	I_AUD1	INDEX	33	21.43
FMIS0400	FMIS0400	XTCLUSTERUSER	TABLE	17	11.04
FMIS0400	FMIS0400	QRTZ_LOCKS	TABLE	6	3.90

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
FMIS0400	FMISINDEX	IDU060712193340934	INDEX	7	46.67
FMIS0400	FMIS0400	XTCLUSTERLOCK	TABLE	4	26.67
SYS	SYSTEM	USER$	TABLE	3	20.00
SYS	SYSTEM	AUD$	TABLE	1	6.67

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 7,408
Captured Segments account for 99.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSTEM	OBJ$	TABLE	3,575	48.26
SYS	SYSTEM	TAB$	TABLE	2,510	33.88
SYS	SYSTEM	I_OBJ2	INDEX	350	4.72
SYS	SYSTEM	I_OBJ1	INDEX	328	4.43
SYS	SYSTEM	I_DEPENDENCY2	INDEX	111	1.50

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 3,327
Captured Segments account for 93.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSTEM	OBJ$	TABLE	1,138	34.20
SYS	SYSTEM	TAB$	TABLE	1,130	33.96
SYS	SYSTEM	I_OBJ2	INDEX	288	8.66
SYS	SYSTEM	I_DEPENDENCY2	INDEX	174	5.23
SYS	SYSTEM	I_OBJ1	INDEX	85	2.55

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	30	3.33	1	1
dc_constraints	34	50.00	34	303
dc_database_links	1,186	0.00	0	1
dc_global_oids	226	0.00	0	22
dc_histogram_data	15,803	0.65	0	8,625
dc_histogram_defs	22,152	1.31	0	19,494
dc_object_ids	17,636	22.94	83	3,153
dc_objects	20,034	19.98	4,058	4,533
dc_profiles	589	0.00	0	1
dc_rollback_segments	4,810	0.00	0	229
dc_segments	6,910	1.01	174	3,274
dc_sequences	22	13.64	22	5
dc_tablespace_quotas	98	7.14	96	1
dc_tablespaces	3,270	0.00	0	23
dc_usernames	22,560	0.00	0	28
dc_users	48,090	0.00	0	53
outstanding_alerts	163	58.28	17	44

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts	GES Releases
dc_awr_control	3	1	0
dc_constraints	66	11	80
dc_histogram_defs	291	30	0
dc_object_ids	4,191	83	0
dc_objects	8,135	95	252
dc_segments	352	87	49
dc_sequences	71	7	0
dc_tablespace_quotas	188	7	0
outstanding_alerts	304	89	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	245	0.00	47,411	0.00	0	0
CLUSTER	3	0.00	7	0.00	0	0
INDEX	16	12.50	37	5.41	0	0
SQL AREA	131,386	7.21	383,279	4.84	13	1,622
TABLE/PROCEDURE	5,637	71.60	107,562	3.92	36	0
TRIGGER	169	0.00	788	0.00	0	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	7	0	0	0
INDEX	37	4	0	0
TABLE/PROCEDURE	25,923	8,069	4,060	8,151

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	589.84		4.47	13.08	111	111	132	132
	Freeable	222.06	0.00	2.20	9.51	91		101	101
	PL/SQL	8.02	4.43	0.06	0.05	0	8	132	131
	SQL	4.55	2.02	0.04	0.02	0	95	115	113
E	Other	472.93		3.40	12.98	112	112	139	139
	Freeable	157.81	0.00	5.26	17.27	91		30	30
	PL/SQL	4.41	2.84	0.03	0.02	0	0	139	137
	SQL	3.07	1.78	0.02	0.02	0	30	123	119

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	9,428,795,392
Fixed Size	2,108,080
Redo Buffers	14,667,776
Variable Size	4,513,072,464

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	160.00	160.00	0.00
large	free memory	32.00	32.00	0.00
shared	CCursor	235.71	247.88	5.16
shared	Cursor Stats	47.24	47.24	0.00
shared	PCursor	233.51	244.91	4.88
shared	db_block_hash_buckets	45.00	45.00	0.00
shared	free memory	454.74	417.54	-8.18
shared	gcs resources	97.41	97.41	0.00
shared	gcs shadows	58.33	58.33	0.00
shared	ges enqueues	526.38	526.84	0.09
shared	ges resource	741.85	735.96	-0.79
shared	kglsim heap	63.41	63.41	0.00
shared	kglsim object batch	99.93	99.93	0.00
shared	library cache	154.39	160.60	4.02
shared	obj stat memo	119.55	119.55	0.00
shared	sql area	824.99	808.47	-2.00
shared	sql area:PLSQL	138.64	161.43	16.44
streams	free memory	16.00	16.00	0.00
	buffer_cache	8,992.00	8,992.00	0.00
	fixed_sga	2.01	2.01	0.00
	log_buffer	13.99	13.99	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

Streams processes ordered by CPU usage
CPU and I/O Time in micro seconds

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Coordinator	19,076	0	0
QMON Slaves	7,496	0	0

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

Rule Sets ordered by Evaluations

Ruleset Name	Evals	Fast Evals	SQL Execs	CPU Time	Elapsed Time
SYS.ALERT_QUE_R	17	0	0	0	0

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	386,442	608,477	630378	630378
gcs_shadows	472,374	610,221	630378	630378
ges_procs	139	398	401	401
processes	140	400	400	400
sessions	148	414	445	445

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/opt/app/oracle/admin/odsdb/adump
audit_sys_operations	TRUE
audit_trail	DB_EXTENDED
background_dump_dest	/opt/app/oracle/admin/odsdb/bdump
bitmap_merge_area_size	65536
cluster_database	TRUE
cluster_database_instances	2
compatible	10.2.0.3.0
control_files	/dev/rlv_vpdctrl01, /dev/rlv_vpdctrl02, /dev/rlv_vpdctrl03
core_dump_dest	/opt/app/oracle/admin/odsdb/cdump
create_bitmap_area_size	65536
db_block_size	16384
db_cache_size	8589934592
db_domain
db_file_multiblock_read_count	16
db_files	2000
db_keep_cache_size	419430400
db_name	odsdb
db_recycle_cache_size	419430400
db_writer_processes	2
hash_area_size	1048576
instance_number	1
java_pool_size	167772160
job_queue_processes	5
large_pool_size	33554432
local_listener	(address=(protocol=tcp)(host=10.122.7.192)(port=1521))
log_archive_dest_1	LOCATION=/oraarch
open_cursors	500
optimizer_mode	CHOOSE
pga_aggregate_target	2053111808
processes	400
recyclebin	OFF
remote_listener	LISTENERS_ODSDB
remote_login_passwordfile	EXCLUSIVE
service_names	ods
sessions	445
sga_max_size	13958643712
sga_target	0
shared_pool_reserved_size	419430400
shared_pool_size	4294967296
sort_area_size	1048576
spfile	/dev/rlv_vpdspfile
sql92_security	TRUE
streams_pool_size	16777216
thread	1
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/opt/app/oracle/admin/odsdb/udump

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	8,350	2.29	1.00
acks for commit broadcast(logical)	8,898	2.44	1.06
broadcast msgs on commit(actual)	5,767	1.58	0.69
broadcast msgs on commit(logical)	5,769	1.58	0.69
broadcast msgs on commit(wasted)	73	0.02	0.01
broadcast on commit wait time(ms)	50	0.01	0.01
broadcast on commit waits	44	0.01	0.01
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
false posts waiting for scn acks	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	20	0.01	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	521	0.14	0.06
gcs ast xid	0	0.00	0.00
gcs blocked converts	1,319	0.36	0.16
gcs blocked cr converts	5,598	1.53	0.67
gcs compatible basts	0	0.00	0.00
gcs compatible cr basts (global)	101	0.03	0.01
gcs compatible cr basts (local)	1,265	0.35	0.15
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	92	0.03	0.01
gcs dbwr write request msgs	86	0.02	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	405	0.11	0.05
gcs immediate (null) converts	430	0.12	0.05
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	690	0.19	0.08
gcs indirect ast	1,538	0.42	0.18
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	54	0.01	0.01
gcs msgs process time(ms)	382	0.10	0.05
gcs msgs received	22,586	6.18	2.69
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	9	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	0	0.00	0.00
gcs side channel msgs actual	511	0.14	0.06
gcs side channel msgs logical	10,941	2.99	1.30
gcs stale cr	64	0.02	0.01
gcs undo cr	29	0.01	0.00
gcs write notification msgs	10	0.00	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	21,147	5.79	2.52
ges msgs received	685,516	187.63	81.74
global posts dropped	0	0.00	0.00
global posts queue time	2	0.00	0.00
global posts queued	17	0.00	0.00
global posts requested	17	0.00	0.00
global posts sent	17	0.00	0.00
implicit batch messages received	32,401	8.87	3.86
implicit batch messages sent	2,218	0.61	0.26
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	30,184	8.26	3.60
messages queue sent actual	59,208	16.21	7.06
messages queue sent logical	64,218	17.58	7.66
messages received actual	147,037	40.25	17.53
messages received logical	708,102	193.82	84.43
messages sent directly	26,265	7.19	3.13
messages sent indirectly	25,753	7.05	3.07
messages sent not implicit batched	56,990	15.60	6.80
messages sent pbatched	61,478	16.83	7.33
msgs causing lmd to send msgs	23,733	6.50	2.83
msgs causing lms(s) to send msgs	703	0.19	0.08
msgs received queue time (ms)	6,595	1.81	0.79
msgs received queued	708,102	193.82	84.43
msgs sent queue time (ms)	2,901	0.79	0.35
msgs sent queue time on ksxp (ms)	135,077	36.97	16.11
msgs sent queued	62,863	17.21	7.50
msgs sent queued on ksxp	95,409	26.11	11.38
process batch messages received	49,939	13.67	5.95
process batch messages sent	40,458	11.07	4.82

Global CR Served Stats

Statistic	Total
CR Block Requests	1,724
CURRENT Block Requests	731
Data Block Requests	1,724
Undo Block Requests	29
TX Block Requests	494
Current Results	2,184
Private results	244
Zero Results	27
Disk Read Results	0
Fail Results	0
Fairness Down Converts	194
Fairness Clears	0
Free GC Elements	0
Flushes	296
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	0
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	785	99.62	0.00	0.38	0.00	0.00
Flushes	1	0.00	100.00	0.00	0.00	0.00
Writes	120	70.83	25.83	0.83	0.83	1.67

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
2	data block	7,338	99.16	0.44	0.41	3,217	99.29	0.62	0.09
2	Others	68	100.00	0.00	0.00	130	100.00	0.00	0.00
2	undo header	15	86.67	13.33	0.00	3	100.00	0.00	0.00

End of Report

% Blocks changed per Read:	10.93	Recursive Call %:	86.44
Rollback per transaction %:	55.22	Rows per Sort:	142.81

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	95.78	Soft Parse %:	97.13
Execute to Parse %:	7.94	Latch Hit %:	99.90
Parse CPU to Parse Elapsd %:	0.08	% Non-Parse CPU:	92.35

Buffer access - local cache %:	99.69
Buffer access - remote cache %:	0.30
Buffer access - disk %:	0.01

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

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	1.4
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	31.95
% of indirect sent messages:	31.33
% of flow controlled messages:	36.72