WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

PRM 809122493 prm 1 10.2.0.4.0 NO pachj.yyhj.com.cn

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
PRM	809122493	prm	1	10.2.0.4.0	NO	pachj.yyhj.com.cn

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 14917 21-Mar-12 08:00:17 119 6.7

End Snap: 14919 21-Mar-12 10:00:33 240 10.0

Elapsed: 120.27 (mins)

DB Time: 271.33 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	14917	21-Mar-12 08:00:17	119	6.7
End Snap:	14919	21-Mar-12 10:00:33	240	10.0
Elapsed:		120.27 (mins)
DB Time:		271.33 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 2,208M 2,288M Std Block Size: 8K

Shared Pool Size: 1,712M 1,632M Log Buffer: 14,340K

	Begin	End
Buffer Cache:	2,208M	2,288M	Std Block Size:	8K
Shared Pool Size:	1,712M	1,632M	Log Buffer:	14,340K

Load Profile

Per Second Per Transaction

Redo size: 20,940.14 22,839.52

Logical reads: 30,490.93 33,256.62

Block changes: 203.22 221.65

Physical reads: 3,750.65 4,090.85

Physical writes: 18.20 19.85

User calls: 116.98 127.59

Parses: 39.23 42.79

Hard parses: 5.06 5.52

Sorts: 16.96 18.50

Logons: 1.82 1.99

Executes: 253.23 276.20

Transactions: 0.92

	Per Second	Per Transaction
Redo size:	20,940.14	22,839.52
Logical reads:	30,490.93	33,256.62
Block changes:	203.22	221.65
Physical reads:	3,750.65	4,090.85
Physical writes:	18.20	19.85
User calls:	116.98	127.59
Parses:	39.23	42.79
Hard parses:	5.06	5.52
Sorts:	16.96	18.50
Logons:	1.82	1.99
Executes:	253.23	276.20
Transactions:	0.92

% Blocks changed per Read: 0.67 Recursive Call %: 82.57

Rollback per transaction %: 3.25 Rows per Sort: 335.21

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.73 Redo NoWait %: 100.00

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

Library Hit %: 94.94 Soft Parse %: 87.11

Execute to Parse %: 84.51 Latch Hit %: 99.92

Parse CPU to Parse Elapsd %: 68.30 % Non-Parse CPU: 87.86

Shared Pool Statistics

Begin End

Memory Usage %: 26.52 22.56

% SQL with executions>1: 69.33 66.32

% Memory for SQL w/exec>1: 72.98 68.87

	Begin	End
Memory Usage %:	26.52	22.56
% SQL with executions>1:	69.33	66.32
% Memory for SQL w/exec>1:	72.98	68.87

Top 5 Timed Events

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

db file scattered read 3,179,323 5,830 2 35.8 User I/O

CPU time 4,597 28.2

db file sequential read 2,372,714 3,204 1 19.7 User I/O

SQL*Net more data to client 3,259,640 1,205 0 7.4 Network

read by other session 598,303 625 1 3.8 User I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file scattered read	3,179,323	5,830	2	35.8	User I/O
CPU time		4,597		28.2
db file sequential read	2,372,714	3,204	1	19.7	User I/O
SQL*Net more data to client	3,259,640	1,205	0	7.4	Network
read by other session	598,303	625	1	3.8	User I/O

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

Time Model Statistics

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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	15,620.09	95.95
DB CPU	4,596.87	28.24
parse time elapsed	827.32	5.08
hard parse elapsed time	802.40	4.93
PL/SQL execution elapsed time	15.81	0.10
PL/SQL compilation elapsed time	11.21	0.07
hard parse (sharing criteria) elapsed time	6.19	0.04
connection management call elapsed time	3.17	0.02
hard parse (bind mismatch) elapsed time	0.98	0.01
failed parse elapsed time	0.79	0.00
sequence load elapsed time	0.48	0.00
repeated bind elapsed time	0.41	0.00
DB time	16,279.85
background elapsed time	333.16
background cpu time	21.25

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
User I/O	6,164,686	0.00	9,742	2	931.78
Network	4,215,143	0.00	1,688	0	637.11
Other	147,055	29.50	551	4	22.23
System I/O	29,664	0.00	258	9	4.48
Commit	7,246	0.00	108	15	1.10
Concurrency	2,968	7.31	8	3	0.45
Application	6,430	0.00	3	0	0.97
Configuration	12	0.00	2	186	0.00

Back to Wait Events Statistics
Back to Top

Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file scattered read	3,179,323	0.00	5,830	2	480.55
db file sequential read	2,372,714	0.00	3,204	1	358.63
SQL*Net more data to client	3,259,640	0.00	1,205	0	492.69
read by other session	598,303	0.00	625	1	90.43
PX Deq Credit: send blkd	81,123	0.08	548	7	12.26
SQL*Net more data from client	43,519	0.00	468	11	6.58
log file parallel write	8,314	0.00	134	16	1.26
log file sync	7,246	0.00	108	15	1.10
db file parallel write	11,928	0.00	60	5	1.80
direct path write temp	6,663	0.00	49	7	1.01
control file parallel write	2,631	0.00	41	16	0.40
direct path read temp	6,663	0.00	28	4	1.01
control file sequential read	6,501	0.00	14	2	0.98
SQL*Net more data from dblink	151	0.00	14	92	0.02
log file sequential read	148	0.00	8	55	0.02
db file parallel read	213	0.00	3	14	0.03
os thread startup	113	0.00	2	21	0.02
cursor: pin S wait on X	258	84.11	2	9	0.04
log file switch completion	12	0.00	2	186	0.00
library cache load lock	17	0.00	2	114	0.00
SQL*Net break/reset to client	6,426	0.00	2	0	0.97
direct path read	716	0.00	2	2	0.11
latch: shared pool	251	0.00	1	5	0.04
kksfbc child completion	33	54.55	1	27	0.00
enq: TX - row lock contention	2	0.00	1	408	0.00
PX Deq: Signal ACK	15,208	6.47	1	0	2.30
direct path write	91	0.00	1	7	0.01
SQL*Net message to client	765,795	0.00	0	0	115.75
TCP Socket (KGAS)	87	0.00	0	3	0.01
log file single write	11	0.00	0	23	0.00
enq: PS - contention	6,580	0.00	0	0	0.99
latch: cache buffers chains	2,141	0.00	0	0	0.32
Log archive I/O	131	0.00	0	1	0.02
SGA: allocation forcing component growth	19	42.11	0	10	0.00
PX qref latch	43,067	98.24	0	0	6.51
latch free	690	0.00	0	0	0.10
SQL*Net message to dblink	145,902	0.00	0	0	22.05
latch: library cache	62	0.00	0	1	0.01
latch: session allocation	212	0.00	0	0	0.03
latch: row cache objects	70	0.00	0	0	0.01
row cache lock	1	0.00	0	5	0.00
latch: cache buffers lru chain	13	0.00	0	0	0.00
latch: library cache lock	16	0.00	0	0	0.00
rdbms ipc reply	33	0.00	0	0	0.00
LGWR wait for redo copy	27	0.00	0	0	0.00
latch: enqueue hash chains	18	0.00	0	0	0.00
buffer busy waits	5	0.00	0	0	0.00
SQL*Net more data to dblink	49	0.00	0	0	0.01
cursor: pin S	32	0.00	0	0	0.00
cursor: mutex X	31	0.00	0	0	0.00
latch: In memory undo latch	3	0.00	0	0	0.00
SQL*Net break/reset to dblink	2	0.00	0	0	0.00
SQL*Net message from client	765,671	0.00	891,774	1165	115.73
PX Idle Wait	49,412	73.88	73,507	1488	7.47
ASM background timer	1,471	0.00	7,043	4788	0.22
Streams AQ: qmn coordinator idle wait	733	37.24	7,022	9579	0.11
Streams AQ: qmn slave idle wait	509	0.00	7,020	13792	0.08
class slave wait	75	69.33	6,954	92726	0.01
Streams AQ: waiting for time management or cleanup tasks	1	100.00	4,069	4069179	0.00
jobq slave wait	1,102	98.09	3,210	2913	0.17
PX Deq: Execution Msg	204,468	0.27	1,505	7	30.91
PX Deq: Table Q Normal	774,138	0.06	1,122	1	117.01
SQL*Net message from dblink	145,901	0.00	500	3	22.05
PX Deq: Execute Reply	127,974	0.00	36	0	19.34
single-task message	60	0.00	29	483	0.01
PX Deq Credit: need buffer	18,401	0.00	21	1	2.78
PX Deq: Parse Reply	8,912	0.00	2	0	1.35
PX Deq: Join ACK	8,219	0.00	2	0	1.24
PX Deq: Msg Fragment	11,702	0.00	1	0	1.77
SGA: MMAN sleep for component shrink	313	17.25	1	4	0.05
KSV master wait	20	0.00	1	44	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	8,313	0.00	134	16	1.26
db file parallel write	11,928	0.00	60	5	1.80
control file parallel write	2,631	0.00	41	16	0.40
db file sequential read	2,975	0.00	21	7	0.45
control file sequential read	5,169	0.00	13	3	0.78
log file sequential read	148	0.00	8	55	0.02
db file scattered read	199	0.00	2	8	0.03
os thread startup	57	0.00	1	23	0.01
log file single write	11	0.00	0	23	0.00
Log archive I/O	131	0.00	0	1	0.02
direct path write	49	0.00	0	3	0.01
latch: shared pool	7	0.00	0	13	0.00
events in waitclass Other	67	0.00	0	0	0.01
direct path read	48	0.00	0	0	0.01
latch: library cache	1	0.00	0	0	0.00
rdbms ipc message	33,434	76.40	83,792	2506	5.05
smon timer	158	0.63	7,086	44851	0.02
pmon timer	2,595	100.00	7,043	2714	0.39
ASM background timer	1,471	0.00	7,043	4788	0.22
Streams AQ: qmn coordinator idle wait	733	37.24	7,022	9579	0.11
Streams AQ: qmn slave idle wait	509	0.00	7,020	13792	0.08
class slave wait	71	73.24	6,954	97950	0.01
Streams AQ: waiting for time management or cleanup tasks	1	100.00	4,069	4069179	0.00
SGA: MMAN sleep for component shrink	313	17.25	1	4	0.05
KSV master wait	20	0.00	1	44	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	490,367
IDLE_TIME	5,283,627
IOWAIT_TIME	398,083
NICE_TIME	74
SYS_TIME	52,752
USER_TIME	410,249
LOAD	0
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	8,345,681,920
NUM_CPUS	8
NUM_CPU_SOCKETS	2

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	16,276.30	4,596.90	27,052,546	219,969,727
SYS$BACKGROUND	0.00	0.00	7,261	124,110
prm.yyhj.com.cn	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	6158776	969975	2865	687	4214074	168753
SYS$BACKGROUND	5900	4251	68	140	0	0
prm.yyhj.com.cn	0	0	0	0	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
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
434	302	2	216.94	2.67	8pwvfc62gtt0b	pms.exe	SELECT "MPTM"."FO_NO", ...
346	12	8	43.26	2.13	8kq64vdtspp3h	pms.exe	Select Max ( Substr ( mov_lot ...
215	46	89	2.42	1.32	2530ps0dtppv7	pms.exe	Select Count ( *) , mptm.qty_...
173	25	13	13.32	1.06	f2gu31xz3d4f0	pms.exe	SELECT '' as_kd, "OAM"."OO...
135	8	13	10.42	0.83	fuzdrmbvrbs9c	pms.exe	SELECT "GS_STORE_CHANGED"."F...
125	28	9	13.92	0.77	4h4brvdap07wf	pms.exe	SELECT "CLAIMM"."CLAIM_NO", ...
117	25	9	12.99	0.72	9aqjqcwbqaztn	pms.exe	SELECT m.ooa_no, d.oa_seq, ...
108	6	39	2.76	0.66	15btbtbny5y2t	pms.exe	select count ( *) from hk_plm ...
103	39	60,541	0.00	0.63	db78fxqxwxt7r		select /+ rule / bucket, en...
99	10	91	1.09	0.61	6g12w2buu9rn7	pms.exe	SELECT A.COMPUTE_BY FROM CUST_...

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
302	434	2	150.99	2.67	8pwvfc62gtt0b	pms.exe	SELECT "MPTM"."FO_NO", ...
96	96	2,044	0.05	0.59	f8h20ksw1bbw5	pms.exe	SELECT "MATM"."MAT_NO", ...
46	215	89	0.52	1.32	2530ps0dtppv7	pms.exe	Select Count ( *) , mptm.qty_...
39	103	60,541	0.00	0.63	db78fxqxwxt7r		select /+ rule / bucket, en...
38	57	1	37.97	0.35	9bgxxhyqbhcad	pms.exe	BEGIN pro_history_wbst...
37	55	1	37.32	0.34	81mrqpz189mm9	pms.exe	UPDATE TEMP_HISTORY_WBSTOCKM A...
28	125	9	3.06	0.77	4h4brvdap07wf	pms.exe	SELECT "CLAIMM"."CLAIM_NO", ...
28	97	158	0.17	0.60	6rwmvwtjpdfa5	pms.exe	SELECT COUNT(*) FROM MPTM_MUST...
25	117	9	2.75	0.72	9aqjqcwbqaztn	pms.exe	SELECT m.ooa_no, d.oa_seq, ...
25	173	13	1.90	1.06	f2gu31xz3d4f0	pms.exe	SELECT '' as_kd, "OAM"."OO...
12	346	8	1.44	2.13	8kq64vdtspp3h	pms.exe	Select Max ( Substr ( mov_lot ...

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: 220,025,772
Captured SQL account for 36.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
30,054,685	2	15,027,342.50	13.66	301.98	433.89	8pwvfc62gtt0b	pms.exe	SELECT "MPTM"."FO_NO", ...
6,996,262	1	6,996,262.00	3.18	37.97	56.84	9bgxxhyqbhcad	pms.exe	BEGIN pro_history_wbst...
6,920,874	1	6,920,874.00	3.15	37.32	54.54	81mrqpz189mm9	pms.exe	UPDATE TEMP_HISTORY_WBSTOCKM A...
4,151,772	68	61,055.47	1.89	16.40	17.77	cuk07gar1gara	pms.exe	SELECT '' c_s, "COLOR...
3,872,244	44	88,005.55	1.76	23.60	89.57	d8f9pd0rv5x2b	pms.exe	SELECT '' c_s, "COLOR...
3,863,733	2,044	1,890.28	1.76	95.63	95.63	f8h20ksw1bbw5	pms.exe	SELECT "MATM"."MAT_NO", ...
2,770,648	158	17,535.75	1.26	27.54	97.42	6rwmvwtjpdfa5	pms.exe	SELECT COUNT(*) FROM MPTM_MUST...
2,239,577	380	5,893.62	1.02	10.95	13.74	2w2t09wcjqh5q	pms.exe	SELECT SUM(NVL(D.MOD_QTY, 0)) ...
1,736,708	9	192,967.56	0.79	24.74	116.88	9aqjqcwbqaztn	pms.exe	SELECT m.ooa_no, d.oa_seq, ...
1,678,567	89	18,860.30	0.76	46.35	215.32	2530ps0dtppv7	pms.exe	Select Count ( *) , mptm.qty_...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 27,065,068
Captured SQL account for 20.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
421,744	9	46,860.44	1.56	27.55	125.26	4h4brvdap07wf	pms.exe	SELECT "CLAIMM"."CLAIM_NO", ...
417,736	89	4,693.66	1.54	46.35	215.32	2530ps0dtppv7	pms.exe	Select Count ( *) , mptm.qty_...
385,037	13	29,618.23	1.42	24.72	173.16	f2gu31xz3d4f0	pms.exe	SELECT '' as_kd, "OAM"."OO...
344,737	2	172,368.50	1.27	301.98	433.89	8pwvfc62gtt0b	pms.exe	SELECT "MPTM"."FO_NO", ...
328,278	91	3,607.45	1.21	10.18	99.35	6g12w2buu9rn7	pms.exe	SELECT A.COMPUTE_BY FROM CUST_...
284,147	39	7,285.82	1.05	5.60	107.52	15btbtbny5y2t	pms.exe	select count ( *) from hk_plm ...
265,390	13	20,414.62	0.98	8.36	135.49	fuzdrmbvrbs9c	pms.exe	SELECT "GS_STORE_CHANGED"."F...
237,959	53	4,489.79	0.88	6.17	71.62	5nbmry2010kar	pms.exe	select etd_date from hk_plm wh...
225,287	44	5,120.16	0.83	23.60	89.57	d8f9pd0rv5x2b	pms.exe	SELECT '' c_s, "COLOR...
220,952	35	6,312.91	0.82	10.41	76.24	b327z4z9pq2nd	pms.exe	SELECT "HK_CIM"."COM_NO", ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 1,827,323
Captured SQL account for 9.8% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
60,541	1,074,229	17.74	db78fxqxwxt7r		select /+ rule / bucket, en...
24,481	22,574	0.92	96g93hntrzjtr		select /+ rule / bucket_cnt,...
11,699	87	0.01	1d7g2ywggnr50	pms.exe	SELECT M.ORD_KD, M.BL_FAC, M.T...
6,661	0	0.00	3r6wkwxmdykwc	pms.exe	SELECT GD_NO, STK_QTY, GD_SF F...
5,449	0	0.00	abuba2mfz1qv7	cms.exe	Select usekd From syscolpri Wh...
5,258	9,373	1.78	6769wyy3yf66f		select pos#, intcol#, col#, sp...
4,369	4,369	1.00	f0wzs9nc663bn	pms.exe	select sysdate from dual
4,311	5,499	1.28	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
3,471	10,921	3.15	1hkt4zqtg4mkq	pms.exe	SELECT DISTINCT SV_LOT_NO FROM...
3,356	3,356	1.00	cx9nxvmg6pb17	sqlplus@pachj.yyhj.com.cn (TNS V1-V3)	declare message varchar2(1...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 283,081
Captured SQL account for 22.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
5,447	5,449	1.92	abuba2mfz1qv7	cms.exe	Select usekd From syscolpri Wh...
4,369	4,369	1.54	f0wzs9nc663bn	pms.exe	select sysdate from dual
3,356	3,356	1.19	cx9nxvmg6pb17	sqlplus@pachj.yyhj.com.cn (TNS V1-V3)	declare message varchar2(1...
2,805	2,805	0.99	2ym6hhaq30r73		select type#, blocks, extents,...
2,637	2,637	0.93	5wstnc4n9xt52	pms.exe	SELECT "WIP_MOVEOUTM"."FO_NO"...
2,554	24,481	0.90	96g93hntrzjtr		select /+ rule / bucket_cnt,...
2,451	3,187	0.87	2q93zsrvbdw48		select grantee#, privilege#, n...
2,247	3,301	0.79	a73wbv1yu8x5c		select con#, type#, condlength...
2,206	5,258	0.78	6769wyy3yf66f		select pos#, intcol#, col#, sp...
2,164	60,541	0.76	db78fxqxwxt7r		select /+ rule / bucket, en...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
499	760	8gt03avs2y5pp	pms.exe	SELECT A."FO_NO", ...
53	281	ajq6uyr9f6azw		SELECT FACT_FEN, FACT_CW, FACT...
47	798	6aq34nj2zb2n7		select col#, grantee#, privi...
47	1,110	f8pavn1bvsj7t		select con#, obj#, rcon#, enab...
44	1,216	83taa7kaw59c1		select name, intcol#, segcol#,...
41	4,311	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
41	912	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
40	3,187	2q93zsrvbdw48		select grantee#, privilege#, n...
40	60,541	db78fxqxwxt7r		select /+ rule / bucket, en...
38	24,481	96g93hntrzjtr		select /+ rule / bucket_cnt,...
37	3,301	a73wbv1yu8x5c		select con#, type#, condlength...
36	5,258	6769wyy3yf66f		select pos#, intcol#, col#, sp...
33	7	0g91p8bnsrwcg	pms.exe	SELECT OP_GRADE FROM EMPM0 WHE...
25	505	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
25	728	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
25	2,042	c6awqs517jpj0		select /*+ index(idl_char$ i_i...
24	2,042	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
22	2,042	ga9j9xk5cy9s0		select /*+ index(idl_sb4$ i_id...
21	2,805	2ym6hhaq30r73		select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0g91p8bnsrwcg SELECT OP_GRADE FROM EMPM0 WHERE EMP_NO=:B1

15btbtbny5y2t select count ( *) from hk_plm where ci_no =:1 and void_mk ='Y'

1d7g2ywggnr50 SELECT M.ORD_KD, M.BL_FAC, M.TERMS, C.REGION_NO, C.COMPUTE_BY, DECODE(M.FACT_NO, '0001', '0', '0002', '0', '0003', '1'), M.CF_NO, D.BRA_NO FROM OAM M, CUST_FACTM C, OAD D WHERE M.CF_NO = C.CF_NO(+) AND M.OA_SNO = :B2 AND D.OA_SEQ = :B1 AND M.OA_SNO = D.OA_SNO

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# (+)

1hkt4zqtg4mkq SELECT DISTINCT SV_LOT_NO FROM SHAV_RECEIVED WHERE FO_NO =:B1

2530ps0dtppv7 Select Count ( *) , mptm.qty_ut , matm.mat_enm , mptm.oa_exw From mptm , matm Where rtrim ( mptm.fo_no ) =rtrim ( :1 ) And mptm.mat_no =matm.mat_no ( + ) Group by mptm.qty_ut , matm.mat_enm , mptm.oa_exw

2q93zsrvbdw48 select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#

2w2t09wcjqh5q SELECT SUM(NVL(D.MOD_QTY, 0)) FROM WIP_MODIFYD D, WIP_MODIFYM M WHERE D.MOM_NO = M.MOM_NO AND M.MOM_RMK LIKE '%�ެD��%' AND SUBSTR(M.OP_WS, 1, 2)= '04' AND D.OFO_NO = :B1

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

39m4sx9k63ba2 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#

3r6wkwxmdykwc SELECT GD_NO, STK_QTY, GD_SF FROM WIP_STOCKM_INSPECTIONM WHERE FO_NO =:B2 AND PKG_NO =:B1

4h4brvdap07wf SELECT "CLAIMM"."CLAIM_NO", "CLAIMM"."CLAIM_D", "CLAIMM"."PRE_PER", "OPERATERM"."OPERATER_ENM", "CLAIMD"."CLAIMD_SEQ", "CLAIMD"."PO_NO", "TYPEM"."TYPE_EDC", "COLORM"."CLR_EDC", "SPECM"."SP_EDC", "CLAIMD"."SHIP_D", "CLAIMD"."SHIP_SF", "CLAIMD"."SHIP_FROM", "BRANDM"."BRA_ENM", "CLAIMD"."OOA_NO", "CLAIMD"."FO_NO", "CLAIMM"."CLAIMM_RMK", "CLAIMD"."CLAIMD_RMK", "CLAIMD"."CLAIM_SF", "CUST_FACTM"."CF_ESN", "CUST_FACTM"."CF_LPER", "CUST_FACTM"."CF_LTEL", "CUST_FACTM"."CF_FAX", "CUST_FACTM"."CF_CWN", "CLAIMM"."CF_LPER", "CLAIMM"."CF_TEL", "CLAIMM"."CF_FAX", "CLAIMM"."CUST_NO", "CLAIMM"."DELI_ADD", "CLAIMD"."INVOICE_NO", "CLAIMD"."PRICE", "CLAIMD"."CLR_CARD", fun_claimd_fo("CLAIMM"."CLAIM_NO") v_fo, fun_get_claim_modver("CLAIMM"."CLAIM_NO") v_mod_ver, mat_no_path, nvl(claimd.vat, 0) vat FROM "BRANDM", "CLAIMD", "CLAIMM", "COLORM", "SPECM", "TYPEM", "OPERATERM", "CUST_FACTM", (select claim_no, claimd_seq, mat_no_path from( select claim _no, claimd_seq, mat_no_path, row_number() over(partition by claim_no, claimd_seq order by claim_no, claimd_seq) mat_no_path_rank from (select claim_no, claimd_seq, cust_mat_no, rank, level as curr_level, ltrim(sys_connect_by_path(cust_mat_no, '@'), '@') mat_no_path from ( select claim_no, claimd_seq, cust_mat_no, row_number() over(partition by claim_no, claimd_seq order by claim_no, claimd_seq ) rank from ( select distinct p.claim_no, p.claimd_seq, pl.cust_mat_no from claim_pl_lookup p, (select hkpl_no pl_no, hkpl_seq pl_seq, oad.cust_mat_no from hk_pld, oad where hk_pld.oa_sno=oad.oa_sno and hk_pld.oa_seq= oad.oa_seq and oad.cust_mat_no is not null union select pl_no, pl_seq , oad.cust_mat_no from pld, oad where pld.oa_sno=oad.oa_sno and pld.oa_seq=oad.oa_seq and oad.cust_mat_no is not null ) pl where TRIM(pl.pl_no)=TRIM(p.pl_no(+)) and TRIM(pl.pl_seq)=TRIM(p.pl_seq(+)) ) ) connect by claim_no=prior claim_no and claimd_seq=prior claimd_seq and rank -1=prior rank ) ) where mat_no_path_rank =1) claim_pld WHERE ( claimm.bra_no = brandm.bra_no (+)) and ( colorm.clr_no (+) = claimd.clr_no) and ( specm.sp_no (+) = claimd.sp_no) and ( typem.type_no (+) = claimd.type_no) and ( operaterm.operater_no (+) = claimm.operater_no) and ( "CLAIMM"."CLAIM_NO" = "CLAIMD"."CLAIM_NO" ) and ( "CLAIMM"."CF_NO" = "CUST_FACTM"."CF_NO" ) and ( ( "CLAIMM"."CLAIM_NO" = :as_no ) ) and "CLAIMD"."CLAIM_NO" =claim_pld.claim_no(+) and "CLAIMD"."CLAIMD_SEQ" =claim_pld.claimd_seq(+)

53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1

5nbmry2010kar select etd_date from hk_plm where ci_no =:1

5wstnc4n9xt52 SELECT "WIP_MOVEOUTM"."FO_NO", "WIP_MOVEOUTM"."MO_WS", "WIP_MOVEOUTM"."MI_WS", substr("WIP_MOVEOUTM"."MOV_D", 3, 6)||"WIP_MOVEOUTM"."MOV_T" dt, "WIP_MOVEOUTM"."MOV_QTY", "WIP_MOVEOUTM"."QTY_UT", "WIP_MOVEOUTM"."MOV_WGT", "WIP_MOVEOUTM"."MOV_SF", "WIP_MOVEOUTM"."MOV_LOT", fun_fonostring("WIP_MOVEOUTM"."FO_NO") xl, mptm.oa_exw, mptm.clr_card, decode(nvl("WIP_MOVEOUTM"."RMK_NO", 'Z'), 'Z', "WIP_MOVEOUTM"."MO_RMK", "WIP_MOVEOUTM"."MO_RMK"||G.RMK_EDC) mo_rmk, matm.mat_enm, oad.rv_exw FROM "WIP_MOVEOUTM", mptm, matm, "REMARKM" G, oad where "WIP_MOVEOUTM"."FO_NO" = :as_fo and "WIP_MOVEOUTM"."FO_NO" = mptm.fo_no and mptm.mat_no = matm.mat_no and "WIP_MOVEOUTM"."RMK_NO" =G.RMK_NO(+) and mptm.oa_sno =oad.oa_sno(+) and mptm.oa_seq =oad.oa_seq(+)

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

6aq34nj2zb2n7 select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

6g12w2buu9rn7 SELECT A.COMPUTE_BY FROM CUST_FACTM A, HK_PLM B WHERE B.CI_NO = :B1 AND TRIM(A.CF_NO) = TRIM(B.C_SHIP_TO_NO )

6rwmvwtjpdfa5 SELECT COUNT(*) FROM MPTM_MUSTERM A, MPTM B WHERE A.FO_NO =B.FO_NO AND SUBSTR(B.MAT_NO, 6, 4) =:B2 AND A.BRA_NO=:B1

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

81mrqpz189mm9 UPDATE TEMP_HISTORY_WBSTOCKM A SET A.MAT_NO =(SELECT MAX(D.EBOX_MAT_NO) FROM WB_RECEIPTD D, WB_RECEIPTM M WHERE A.WB_STK_LOT = M.WB_RT_LOT AND M.WB_RTM_NO=D.WB_RTM_NO AND D.WB_PS_NO = A.WB_PS_NO AND D.WB_GD_NO = A.WB_GD_NO AND D.WB_LK_NO = A.WB_LK_NO AND D.WB_FP_NO = A.WB_FP_NO AND D.WB_SP_NO = A.WB_SP_NO ) WHERE WB_SORT_MK='N'

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

8gt03avs2y5pp SELECT A."FO_NO", m.ws_enm, A."MOV_D"||A."MOV_T" dt, A."MOV_QTY", A."QTY_UT", A."MOV_WGT", A."MOV_SF", A."MOV_LOT", mptm.oa_exw, decode(nvl(a.rmk_no, 'Z'), 'Z', a.mo_rmk, a.mo_rmk||G.RMK_EDC) mo_rmk, oad.rv_exw FROM "WIP_MOVEOUTM" a , mptm, wip_workstationm m, "REMARKM" G, oad where a."MOV_D"||a."MOV_T" = (select max(b."MOV_D"||b."MOV_T") from "WIP_MOVEOUTM" b where a."FO_NO" = b.fo_no) AND MPTM.FO_NO = A.FO_NO and mptm.po_no = :as_1 and a.mi_ws = m.ws_no and a.RMK_NO =G.RMK_NO(+) and mptm.oa_sno =oad.oa_sno(+) and mptm.oa_seq =oad.oa_seq(+) union SELECT mptm."FO_NO", n.ws_enm, c."MOV_D"||c."MOV_T" dt, c."MOV_QTY", c."QTY_UT", c."MOV_WGT", c."MOV_SF", c."MOV_LOT", mptm.oa_exw, decode(nvl(c.rmk_no, 'Z'), 'Z', c.mo_rmk, c.mo_rmk||G.RMK_EDC) mo_rmk , oad.rv_exw FROM "WIP_MOVEOUTM" c , mptm, wip_workstationm n, "REMARKM" G , oad where MPTM.FO_NO =c.fo_no(+) and c.fo_no is null and mptm.po_no = :as_1 and n.ws_no = c.mi_ws and c.RMK_NO =G.RMK_NO(+) and mptm.oa_sno =oad.oa_sno(+) and mptm.oa_seq =oad.oa_seq(+)

8kq64vdtspp3h Select Max ( Substr ( mov_lot , 8 , 3 ) ) From wip_moveoutm Where mo_ws Like Substr ( :1 , 1 , 2 ) || '%' And mi_ws Like Substr ( :2 , 1 , 2 ) || '%' And mov_lot Like Substr ( :3 , 1 , 2 ) || '%' And Substr ( mov_lot , 3 , 2 ) =Substr ( :4 , 1 , 2 ) And Substr ( mov_d , 1 , 6 ) =Substr ( :5 , 1 , 6 )

8pwvfc62gtt0b SELECT "MPTM"."FO_NO", "CUSTM"."CUST_ESN", "MATM"."MAT_ENM", "BRANDM"."BRA_ENM", "MPTM"."CLR_CARD", "MPTM"."OA_EXW", "MPTM"."PO_NO", "MPTM"."PM_SF" , b.ws_enm, max(a.mov_d||a.mov_t) dt, b.ws_seq, mptm.send_d, oad.conserve_d, mptm.mptm_rmk, transferm.trm_d, plm.ship_d FROM WIP_Moveoutm a, wip_workstationm b, "MPTM", "MATM", "CUSTM", "BRANDM", transferm, transferd, plm, pld, oad , (select m.fo_no fo_no , m.mi_ws mi_ws from wip_moveoutm m, mptm mm where m.fo_no=mm.fo_no and substr(mi_ws, 1, 2) in ('08', '09')) c WHERE ( "CUSTM"."CUST_NO"(+) = "MPTM"."CUST_NO" ) and ( "MPTM"."MAT_NO" = "MATM"."MAT_NO"(+) ) and ( "BRANDM"."BRA_NO"(+) = "MPTM"."BRA_NO" ) and a.mi_ws=b.ws_no and b.mws_yn = 'Y' and a.fo_no(+) = mptm.fo_no and mptm.fo_no =oad.fo_no(+) and transferm.trm_no(+) =transferd.trm_no and mptm.fo_no =transferd.fo_no(+) and plm.pl_no(+) =pld.pl_no and a.fo_no=c.fo_no(+) and mptm.fo_no =pld.fo_no(+) and mptm.fo_no=c.fo_no and mptm.fo_kd in ('4') and mptm.gmk_no in ( 'A1', 'A2', 'A3' ) and MPTM.MF_MK in('1', '5', '7') GROUP BY "MPTM"."FO_NO", "CUSTM"."CUST_ESN", "MATM"."MAT_ ENM", "BRANDM"."BRA_ENM", "MPTM"."CLR_CARD", "MPTM"."OA_EXW", "MPTM"."PO_NO", "MPTM"."PM_SF", b.ws_enm, b.ws_seq, mptm.send_d, oad.conserve_d, mptm.mptm_rmk, transferm.trm_d, plm.ship_d UNION SELECT "MPTM"."FO_NO", "CUSTM"."CUST_ESN", "MATM"."MAT_ENM", "BRANDM"."BRA_ENM", "MPTM"."CLR_CARD", "MPTM"."OA_EXW", "MPTM"."PO_NO", "MPTM"."PM_SF" , '', a.mov_d||a.mov_t dt, 1000, mptm.send_d, oad.conserve_d, mptm.mptm_rmk, '' as trm_d, '' as ship_d FROM WIP_Moveoutm a, "MPTM", "MATM", "CUSTM", "BRANDM", oad WHERE ( "CUSTM"."CUST_NO"(+) = "MPTM"."CUST_NO" ) and ( "MPTM"."MAT_NO" = "MATM"."MAT_NO"(+) ) and ( "BRANDM"."BRA_NO"(+) = "MPTM"."BRA_NO" ) and a.fo_no(+) = mptm.fo_no AND A.FO_NO IS NULL and mptm.fo_no =oad.fo_no(+) AND mptm.fo_no in( select fo_no from mptm minus select oad.fo_no fo_no from oad, mptm where oad.fo_no=mptm.fo_no and oad.ship_status in('3', '4')) and mptm.fo_kd in ('4') and mptm.gmk_no in ( 'A1', 'A2', 'A3' ) and MPTM.MF_MK in('1', '5', '7')

96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2

9aqjqcwbqaztn SELECT m.ooa_no, d.oa_seq, m.po_date, d.po_no, d.oa_qty, ma.mat_enm, d.clr_card , a.loi_qty loi_sf, d.oa_qty -NVL(a.loi_qty, 0)bal_sf FROM OAD d, OAM m , MATM ma , ( SELECT a.oa_sno, a.oa_seq, sum( oad.loi_qty) loi_qty FROM OAD, OAM , ( SELECT d.oa_sno, d.po_no, d.mat_no, d.oa_seq FROM OAD d, oam m WHERE m.oa_sno=d.oa_sno and m.ord_kd in('A', 'B') and d.ship_status <>'4' )a WHERE ( oam.oa_sno = oad.oa_sno ) and (( trim(oad.loi_no) =a.po_no and oad.mat_no =a.mat_no and nvl(oad.loi_no_seq, '0') = '0') OR (trim(oad.loi_no) =a.po_no and oad.mat_no <>a.mat_no AND oad.loi_no_seq=a.oa_seq) OR (trim(oad.loi_no) =a.po_no and oad.mat_no = a.mat_no AND oad.loi_no_seq=a.oa_seq)) and oad.ship_status <>'4' and Trim(oam.bl_fac) = 'PAC' group by a.oa_sno, a.oa_seq )a WHERE ( m.OA_SNO = d.OA_SNO ) AND ( d.MAT_NO = ma.MAT_NO) AND d.OA_QTY >0 AND d.SHIP_STATUS NOT IN ('3', '4') AND ( m.ORD_KD IN ('A', 'B')) AND m.bl_fac='PAC' and d.oa_sno=a.oa_sno(+) and d.oa_seq=a.oa_seq(+)

9bgxxhyqbhcad BEGIN pro_history_wbstockm( '20120321' ); END;

a73wbv1yu8x5c select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1

abuba2mfz1qv7 Select usekd From syscolpri Where userid =:1 And workname =:2 And dwname =:3 And columnname =:4

ajq6uyr9f6azw SELECT FACT_FEN, FACT_CW, FACT_COMP, FACT_PUR, FACT_G2 FROM PMS.FACTM WHERE FACT_NO=:B1

b327z4z9pq2nd SELECT "HK_CIM"."COM_NO", "HK_CIM"."CI_NO", "HK_CIM"."CI_D", "HK_CIM"."HKPL_NO", "HK_CIM"."VERSION", "HK_CIM"."GUI_NO", "HK_CIM"."VOID", "HK_CIM"."POST_MK", "HK_CIM"."CUST_NO", "HK_CIM"."C_SOLD_TO_NO", "HK_CIM"."CURRENCY", "HK_CIM"."EXCHANGE_RATE", "HK_CIM"."CUSTOM_D", "HK_CIM"."PAYMENT_TERM", "HK_CIM"."CH_NO_1", "HK_CIM"."CH_AMT_1", "HK_CIM"."CH_NO_2", "HK_CIM"."CH_AMT_2", "HK_CIM"."CH_NO_3", "HK_CIM"."CH_AMT_3", "HK_CIM"."HEADER_RMK", "HK_CIM"."FOOTER_RMK", "HK_CIM"."CRE_PER", "HK_CIM"."CRE_TIME", "HK_CIM"."TX_PER", "HK_CIM"."TX_TIME", "HK_CIM"."SHIP_TERM", "HK_CIM"."CH_DESC_1", "HK_CIM"."CH_DESC_2", "HK_CIM"."CH_DESC_3", "HK_CIM"."INV_TYPE_DESC", "HK_CIM"."CH_AC_1", "HK_CIM"."CH_AC_2", "HK_CIM"."CH_AC_3", "HK_CIM"."SEND_DOC_DATE", "HK_CIM"."CRE_TOOL", "HK_CIM"."OVERDUE_REASON", "HK_CIM"."REASON_RMK", "HK_CIM"."SURCHARGE" , DUE_DATE , OVER_DATE , REST_QTY, "HK_CIM"."SAL_RMK" FROM "HK_CIM" , v_hkinv_overdue WHERE ( "HK_CIM"."COM_NO" = :as_com ) AND ( "HK_CIM"."CI_NO" = :as_no ) and "HK_CIM"."CI_NO" not like 'FOC%' and hk_cim.ci_no=v_hkinv_overdue.INVOICE_NO

c6awqs517jpj0 select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#

cuk07gar1gara SELECT '' c_s, "COLOR_PSCTM"."PSCT_NO", "COLOR_PSCTM"."FO_NO", "COLOR_PSCTM"."TYPE_NO", "COLOR_PSCTM"."CLR_NO", "TYPEM"."TYPE_EDC", "COLORM"."CLR_EDC", "COLOR_PSCTM"."GMK_NO", "COLOR_PSCTM"."MODEL_NO", "COLOR_PSCTM"."COLOR_SF", "COLOR_PSCTM"."COLOR_CARD", "COLOR_PSCTM"."PERSF1_WGT", "COLOR_PSCTM"."PERSF2_WGT", "COLOR_PSCTM"."PERSF3_WGT", "COLOR_PSCTM"."PERSF4_WGT", "COLOR_PSCTM"."PERSF5_WGT", "COLOR_PSCTM"."PERSF6_WGT", "COLOR_PSCTM"."PERSF7_WGT", "COLOR_PSCTM"."PERSF8_WGT" FROM "COLOR_PSCTM", "TYPEM", "COLORM", "MODEL_FINISHM", mptm WHERE "COLOR_PSCTM"."TYPE_NO" = "TYPEM"."TYPE_NO" AND "COLOR_PSCTM"."CLR_NO" = "COLORM"."CLR_NO" AND "COLOR_PSCTM"."MODEL_NO" = "MODEL_FINISHM"."FINISH_NO" AND "COLOR_PSCTM"."FO_NO" =mptm.fo_no AND "COLOR_PSCTM"."CRE_TIME" >=to_char(add_months(sysdate, -6), 'yyyymmdd') AND SUBSTR("COLOR_PSCTM"."CRE_TIME", 1, 4) <= to_char(sysdate, 'yyyy') AND ((mptm.mf_mk <>'4') or (mptm.mf_mk ='4' AND NVL(substr(mptm.close_d, 1, 6), to_char(sysdate, 'yyyymm'))=to_char(sysdate, 'yyyymm')) or (mptm.mf_mk ='4' AND NVL(substr(mptm.close_d, 1, 6), to_char(sysdate, 'yyyymm')) <to_char(sysdate, 'yyyymm') AND NVL(substr(mptm.close_d, 1, 8), to_char(sysdate, 'yyyymmdd')) >=to_char(sysdate -3, 'yyyymmdd')) ) And color_psctm.fo_n o Like '12%'

cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#

cx9nxvmg6pb17 declare message varchar2(120); IP varchar2(15); v_os_user varchar2(80); v_module varchar2(50); v_action varchar2(50); v_pid varchar2(10); v_sid number; begin IF (ora_is_servererror(1017)) THEN if sys_context('userenv', 'network_protocol') = 'tcp' then IP := sys_context('userenv', 'ip_address'); else select distinct sid into v_sid from sys.v_$mystat; SELECT p.SPID into v_pid FROM V$PROCESS p, V$SESSION v WHERE p.ADDR = v.PADDR AND v.sid = v_sid; end if; v_os_user := sys_context('userenv', 'os_user'); dbms_application_info.READ_MODULE(v_module, v_action); message := to_char(sysdate, 'Dy Mon dd HH24:MI:SS YYYY') || ' logon denied from ' || nvl(IP, v_pid) || ' ' || v_os_user || ' with ' || v_module || ' ' || v_action; sys.dbms_system.ksdwrt(2, message); end if; end;

d8f9pd0rv5x2b SELECT '' c_s, "COLOR_PSCTM"."PSCT_NO", "COLOR_PSCTM"."FO_NO", "COLOR_PSCTM"."TYPE_NO", "COLOR_PSCTM"."CLR_NO", "TYPEM"."TYPE_EDC", "COLORM"."CLR_EDC", "COLOR_PSCTM"."GMK_NO", "COLOR_PSCTM"."MODEL_NO", "COLOR_PSCTM"."COLOR_SF", "COLOR_PSCTM"."COLOR_CARD", "COLOR_PSCTM"."PERSF1_WGT", "COLOR_PSCTM"."PERSF2_WGT", "COLOR_PSCTM"."PERSF3_WGT", "COLOR_PSCTM"."PERSF4_WGT", "COLOR_PSCTM"."PERSF5_WGT", "COLOR_PSCTM"."PERSF6_WGT", "COLOR_PSCTM"."PERSF7_WGT", "COLOR_PSCTM"."PERSF8_WGT" FROM "COLOR_PSCTM", "TYPEM", "COLORM", "MODEL_FINISHM", mptm WHERE "COLOR_PSCTM"."TYPE_NO" = "TYPEM"."TYPE_NO" AND "COLOR_PSCTM"."CLR_NO" = "COLORM"."CLR_NO" AND "COLOR_PSCTM"."MODEL_NO" = "MODEL_FINISHM"."FINISH_NO" AND "COLOR_PSCTM"."FO_NO" =mptm.fo_no AND "COLOR_PSCTM"."CRE_TIME" >=to_char(add_months(sysdate, -6), 'yyyymmdd') AND SUBSTR("COLOR_PSCTM"."CRE_TIME", 1, 4) <= to_char(sysdate, 'yyyy') AND ((mptm.mf_mk <>'4') or (mptm.mf_mk ='4' AND NVL(substr(mptm.close_d, 1, 6), to_char(sysdate, 'yyyymm'))=to_char(sysdate, 'yyyymm')) or (mptm.mf_mk ='4' AND NVL(substr(mptm.close_d, 1, 6), to_char(sysdate, 'yyyymm')) <to_char(sysdate, 'yyyymm') AND NVL(substr(mptm.close_d, 1, 8), to_char(sysdate, 'yyyymmdd')) >=to_char(sysdate -3, 'yyyymmdd')) ) And color_psctm.fo_n o Like '1%'

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

f0wzs9nc663bn select sysdate from dual

f2gu31xz3d4f0 SELECT '' as_kd, "OAM"."OOA_NO" "OOA_NO", DECODE("OAM"."ORD_KD", '7', '1', '8', '1', '0', '1', '0') "ORD_KD", "PLD"."PO_NO", "PLM"."GMK_NO", "MATM"."MAT_NO", "MATM"."MAT_ENM", "PLD"."FO_NO", 'PAC' "BL_FAC", "M"."CI_NO" "CI_NO", "PLM"."CUST_NO", "PLM"."PL_NO", "PLM"."SHIP_D", SUM("PLD"."CUTO_SF") SHIP_QTY, NVL("OAD"."SAL_PRI", 0)sal_pri, NVL("OAD"."VAT", 0)vat, "PLD"."CLR_CARD", "PLD"."PL_SEQ" FROM PLD , PLM , "MATM", "OAM", "OAD", CIM M, CID D WHERE "PLM"."PL_NO" = "PLD"."PL_NO" AND "PLD"."MAT_NO" = "MATM"."MAT_NO" AND "PLM"."FACT_NO" ='0003' AND NVL(PLD.CLAIM_FLG, 'N') = 'N' AND ship_mk = 'Y' AND ( RTRIM("PLM"."FACT_NO") = RTRIM("OAM"."FACT_NO") ) AND ( "PLD"."OA_SNO" = "OAM"."OA_SNO" ) and ( "PLD"."OA_SEQ" = "OAD"."OA_SEQ" ) and ( "OAM"."OA_SNO" = "OAD"."OA_SNO" ) AND M.CI_NO(+)=D.CI_NO AND D.PL_NO(+)= PLD.PL_NO AND D.PL_SEQ(+)=PLD.PL_SEQ GROUP BY "OAM"."OOA_NO", DECODE("OAM"."ORD_KD", '7', '1', '8', '1', '0', '1', '0'), "PLD"."PO_NO", "PLM"."GMK_NO", "MATM"."MAT_NO", "MATM"."MAT_ENM", "PLD"."FO_NO", "M"."CI _NO" , "PLM"."CUST_NO", "PLM"."PL_NO", "PLM"."SHIP_D", "OAD"."SAL_PRI", "PLD"."CLR_CARD", "PLD"."PL_SEQ", NVL("OAD"."VAT", 0)

f8h20ksw1bbw5 SELECT "MATM"."MAT_NO", "MATM"."MAT_ENM", "MATM"."MAT_CNM" FROM "MATM" WHERE "MATM"."MAT_STA" <> 'S'

f8pavn1bvsj7t select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1

fuzdrmbvrbs9c SELECT "GS_STORE_CHANGED"."FO_NO", "GS_STORE_CHANGED"."GS_SCM_NO", "GS_STORE_CHANGED"."GS_SCD_SEQ", "GS_STORE_CHANGEM"."GS_SCM_DT", "GS_STORE_CHANGEM"."GS_SCM_KD", "GS_STORE_CHANGEM"."UPRACK_RESN", "GS_STORE_CHANGEM"."DOWNRACK_RESN", "GS_STORE_CHANGEM"."WORK_CLASS", "GS_STORE_CHANGED"."GWH_KD", "GS_STORE_CHANGED"."IN_D", "GS_STORE_CHANGED"."PKG_NO", "WHMANM"."WHMAN_CNM", "GS_STORE_CHANGED"."NSTORE_POS", "GS_STORE_CHANGED"."STK_QTY", "GS_STORE_CHANGED"."STK_SF", "GS_STORE_CHANGED"."CLOSE_MK" FROM "GS_STORE_CHANGED", "GS_STORE_CHANGEM", "WHMANM" WHERE ( gs_store_changem.whman_no = whmanm.whman_no (+)) and ( "GS_STORE_CHANGEM"."GS_SCM_NO" = "GS_STORE_CHANGED"."GS_SCM_NO" ) and ( ( "GS_STORE_CHANGED"."FO_NO" = :as_fono ) )

ga9j9xk5cy9s0 select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#

SQL Id	SQL Text
0g91p8bnsrwcg	SELECT OP_GRADE FROM EMPM0 WHERE EMP_NO=:B1
15btbtbny5y2t	select count ( *) from hk_plm where ci_no =:1 and void_mk ='Y'
1d7g2ywggnr50	SELECT M.ORD_KD, M.BL_FAC, M.TERMS, C.REGION_NO, C.COMPUTE_BY, DECODE(M.FACT_NO, '0001', '0', '0002', '0', '0003', '1'), M.CF_NO, D.BRA_NO FROM OAM M, CUST_FACTM C, OAD D WHERE M.CF_NO = C.CF_NO(+) AND M.OA_SNO = :B2 AND D.OA_SEQ = :B1 AND M.OA_SNO = D.OA_SNO
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# (+)
1hkt4zqtg4mkq	SELECT DISTINCT SV_LOT_NO FROM SHAV_RECEIVED WHERE FO_NO =:B1
2530ps0dtppv7	Select Count ( *) , mptm.qty_ut , matm.mat_enm , mptm.oa_exw From mptm , matm Where rtrim ( mptm.fo_no ) =rtrim ( :1 ) And mptm.mat_no =matm.mat_no ( + ) Group by mptm.qty_ut , matm.mat_enm , mptm.oa_exw
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2w2t09wcjqh5q	SELECT SUM(NVL(D.MOD_QTY, 0)) FROM WIP_MODIFYD D, WIP_MODIFYM M WHERE D.MOM_NO = M.MOM_NO AND M.MOM_RMK LIKE '%�ެD��%' AND SUBSTR(M.OP_WS, 1, 2)= '04' AND D.OFO_NO = :B1
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3r6wkwxmdykwc	SELECT GD_NO, STK_QTY, GD_SF FROM WIP_STOCKM_INSPECTIONM WHERE FO_NO =:B2 AND PKG_NO =:B1
4h4brvdap07wf	SELECT "CLAIMM"."CLAIM_NO", "CLAIMM"."CLAIM_D", "CLAIMM"."PRE_PER", "OPERATERM"."OPERATER_ENM", "CLAIMD"."CLAIMD_SEQ", "CLAIMD"."PO_NO", "TYPEM"."TYPE_EDC", "COLORM"."CLR_EDC", "SPECM"."SP_EDC", "CLAIMD"."SHIP_D", "CLAIMD"."SHIP_SF", "CLAIMD"."SHIP_FROM", "BRANDM"."BRA_ENM", "CLAIMD"."OOA_NO", "CLAIMD"."FO_NO", "CLAIMM"."CLAIMM_RMK", "CLAIMD"."CLAIMD_RMK", "CLAIMD"."CLAIM_SF", "CUST_FACTM"."CF_ESN", "CUST_FACTM"."CF_LPER", "CUST_FACTM"."CF_LTEL", "CUST_FACTM"."CF_FAX", "CUST_FACTM"."CF_CWN", "CLAIMM"."CF_LPER", "CLAIMM"."CF_TEL", "CLAIMM"."CF_FAX", "CLAIMM"."CUST_NO", "CLAIMM"."DELI_ADD", "CLAIMD"."INVOICE_NO", "CLAIMD"."PRICE", "CLAIMD"."CLR_CARD", fun_claimd_fo("CLAIMM"."CLAIM_NO") v_fo, fun_get_claim_modver("CLAIMM"."CLAIM_NO") v_mod_ver, mat_no_path, nvl(claimd.vat, 0) vat FROM "BRANDM", "CLAIMD", "CLAIMM", "COLORM", "SPECM", "TYPEM", "OPERATERM", "CUST_FACTM", (select claim_no, claimd_seq, mat_no_path from( select claim _no, claimd_seq, mat_no_path, row_number() over(partition by claim_no, claimd_seq order by claim_no, claimd_seq) mat_no_path_rank from (select claim_no, claimd_seq, cust_mat_no, rank, level as curr_level, ltrim(sys_connect_by_path(cust_mat_no, '@'), '@') mat_no_path from ( select claim_no, claimd_seq, cust_mat_no, row_number() over(partition by claim_no, claimd_seq order by claim_no, claimd_seq ) rank from ( select distinct p.claim_no, p.claimd_seq, pl.cust_mat_no from claim_pl_lookup p, (select hkpl_no pl_no, hkpl_seq pl_seq, oad.cust_mat_no from hk_pld, oad where hk_pld.oa_sno=oad.oa_sno and hk_pld.oa_seq= oad.oa_seq and oad.cust_mat_no is not null union select pl_no, pl_seq , oad.cust_mat_no from pld, oad where pld.oa_sno=oad.oa_sno and pld.oa_seq=oad.oa_seq and oad.cust_mat_no is not null ) pl where TRIM(pl.pl_no)=TRIM(p.pl_no(+)) and TRIM(pl.pl_seq)=TRIM(p.pl_seq(+)) ) ) connect by claim_no=prior claim_no and claimd_seq=prior claimd_seq and rank -1=prior rank ) ) where mat_no_path_rank =1) claim_pld WHERE ( claimm.bra_no = brandm.bra_no (+)) and ( colorm.clr_no (+) = claimd.clr_no) and ( specm.sp_no (+) = claimd.sp_no) and ( typem.type_no (+) = claimd.type_no) and ( operaterm.operater_no (+) = claimm.operater_no) and ( "CLAIMM"."CLAIM_NO" = "CLAIMD"."CLAIM_NO" ) and ( "CLAIMM"."CF_NO" = "CUST_FACTM"."CF_NO" ) and ( ( "CLAIMM"."CLAIM_NO" = :as_no ) ) and "CLAIMD"."CLAIM_NO" =claim_pld.claim_no(+) and "CLAIMD"."CLAIMD_SEQ" =claim_pld.claimd_seq(+)
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5nbmry2010kar	select etd_date from hk_plm where ci_no =:1
5wstnc4n9xt52	SELECT "WIP_MOVEOUTM"."FO_NO", "WIP_MOVEOUTM"."MO_WS", "WIP_MOVEOUTM"."MI_WS", substr("WIP_MOVEOUTM"."MOV_D", 3, 6)\|\|"WIP_MOVEOUTM"."MOV_T" dt, "WIP_MOVEOUTM"."MOV_QTY", "WIP_MOVEOUTM"."QTY_UT", "WIP_MOVEOUTM"."MOV_WGT", "WIP_MOVEOUTM"."MOV_SF", "WIP_MOVEOUTM"."MOV_LOT", fun_fonostring("WIP_MOVEOUTM"."FO_NO") xl, mptm.oa_exw, mptm.clr_card, decode(nvl("WIP_MOVEOUTM"."RMK_NO", 'Z'), 'Z', "WIP_MOVEOUTM"."MO_RMK", "WIP_MOVEOUTM"."MO_RMK"\|\|G.RMK_EDC) mo_rmk, matm.mat_enm, oad.rv_exw FROM "WIP_MOVEOUTM", mptm, matm, "REMARKM" G, oad where "WIP_MOVEOUTM"."FO_NO" = :as_fo and "WIP_MOVEOUTM"."FO_NO" = mptm.fo_no and mptm.mat_no = matm.mat_no and "WIP_MOVEOUTM"."RMK_NO" =G.RMK_NO(+) and mptm.oa_sno =oad.oa_sno(+) and mptm.oa_seq =oad.oa_seq(+)
6769wyy3yf66f	select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6g12w2buu9rn7	SELECT A.COMPUTE_BY FROM CUST_FACTM A, HK_PLM B WHERE B.CI_NO = :B1 AND TRIM(A.CF_NO) = TRIM(B.C_SHIP_TO_NO )
6rwmvwtjpdfa5	SELECT COUNT(*) FROM MPTM_MUSTERM A, MPTM B WHERE A.FO_NO =B.FO_NO AND SUBSTR(B.MAT_NO, 6, 4) =:B2 AND A.BRA_NO=:B1
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
81mrqpz189mm9	UPDATE TEMP_HISTORY_WBSTOCKM A SET A.MAT_NO =(SELECT MAX(D.EBOX_MAT_NO) FROM WB_RECEIPTD D, WB_RECEIPTM M WHERE A.WB_STK_LOT = M.WB_RT_LOT AND M.WB_RTM_NO=D.WB_RTM_NO AND D.WB_PS_NO = A.WB_PS_NO AND D.WB_GD_NO = A.WB_GD_NO AND D.WB_LK_NO = A.WB_LK_NO AND D.WB_FP_NO = A.WB_FP_NO AND D.WB_SP_NO = A.WB_SP_NO ) WHERE WB_SORT_MK='N'
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8gt03avs2y5pp	SELECT A."FO_NO", m.ws_enm, A."MOV_D"\|\|A."MOV_T" dt, A."MOV_QTY", A."QTY_UT", A."MOV_WGT", A."MOV_SF", A."MOV_LOT", mptm.oa_exw, decode(nvl(a.rmk_no, 'Z'), 'Z', a.mo_rmk, a.mo_rmk\|\|G.RMK_EDC) mo_rmk, oad.rv_exw FROM "WIP_MOVEOUTM" a , mptm, wip_workstationm m, "REMARKM" G, oad where a."MOV_D"\|\|a."MOV_T" = (select max(b."MOV_D"\|\|b."MOV_T") from "WIP_MOVEOUTM" b where a."FO_NO" = b.fo_no) AND MPTM.FO_NO = A.FO_NO and mptm.po_no = :as_1 and a.mi_ws = m.ws_no and a.RMK_NO =G.RMK_NO(+) and mptm.oa_sno =oad.oa_sno(+) and mptm.oa_seq =oad.oa_seq(+) union SELECT mptm."FO_NO", n.ws_enm, c."MOV_D"\|\|c."MOV_T" dt, c."MOV_QTY", c."QTY_UT", c."MOV_WGT", c."MOV_SF", c."MOV_LOT", mptm.oa_exw, decode(nvl(c.rmk_no, 'Z'), 'Z', c.mo_rmk, c.mo_rmk\|\|G.RMK_EDC) mo_rmk , oad.rv_exw FROM "WIP_MOVEOUTM" c , mptm, wip_workstationm n, "REMARKM" G , oad where MPTM.FO_NO =c.fo_no(+) and c.fo_no is null and mptm.po_no = :as_1 and n.ws_no = c.mi_ws and c.RMK_NO =G.RMK_NO(+) and mptm.oa_sno =oad.oa_sno(+) and mptm.oa_seq =oad.oa_seq(+)
8kq64vdtspp3h	Select Max ( Substr ( mov_lot , 8 , 3 ) ) From wip_moveoutm Where mo_ws Like Substr ( :1 , 1 , 2 ) \|\| '%' And mi_ws Like Substr ( :2 , 1 , 2 ) \|\| '%' And mov_lot Like Substr ( :3 , 1 , 2 ) \|\| '%' And Substr ( mov_lot , 3 , 2 ) =Substr ( :4 , 1 , 2 ) And Substr ( mov_d , 1 , 6 ) =Substr ( :5 , 1 , 6 )
8pwvfc62gtt0b	SELECT "MPTM"."FO_NO", "CUSTM"."CUST_ESN", "MATM"."MAT_ENM", "BRANDM"."BRA_ENM", "MPTM"."CLR_CARD", "MPTM"."OA_EXW", "MPTM"."PO_NO", "MPTM"."PM_SF" , b.ws_enm, max(a.mov_d\|\|a.mov_t) dt, b.ws_seq, mptm.send_d, oad.conserve_d, mptm.mptm_rmk, transferm.trm_d, plm.ship_d FROM WIP_Moveoutm a, wip_workstationm b, "MPTM", "MATM", "CUSTM", "BRANDM", transferm, transferd, plm, pld, oad , (select m.fo_no fo_no , m.mi_ws mi_ws from wip_moveoutm m, mptm mm where m.fo_no=mm.fo_no and substr(mi_ws, 1, 2) in ('08', '09')) c WHERE ( "CUSTM"."CUST_NO"(+) = "MPTM"."CUST_NO" ) and ( "MPTM"."MAT_NO" = "MATM"."MAT_NO"(+) ) and ( "BRANDM"."BRA_NO"(+) = "MPTM"."BRA_NO" ) and a.mi_ws=b.ws_no and b.mws_yn = 'Y' and a.fo_no(+) = mptm.fo_no and mptm.fo_no =oad.fo_no(+) and transferm.trm_no(+) =transferd.trm_no and mptm.fo_no =transferd.fo_no(+) and plm.pl_no(+) =pld.pl_no and a.fo_no=c.fo_no(+) and mptm.fo_no =pld.fo_no(+) and mptm.fo_no=c.fo_no and mptm.fo_kd in ('4') and mptm.gmk_no in ( 'A1', 'A2', 'A3' ) and MPTM.MF_MK in('1', '5', '7') GROUP BY "MPTM"."FO_NO", "CUSTM"."CUST_ESN", "MATM"."MAT_ ENM", "BRANDM"."BRA_ENM", "MPTM"."CLR_CARD", "MPTM"."OA_EXW", "MPTM"."PO_NO", "MPTM"."PM_SF", b.ws_enm, b.ws_seq, mptm.send_d, oad.conserve_d, mptm.mptm_rmk, transferm.trm_d, plm.ship_d UNION SELECT "MPTM"."FO_NO", "CUSTM"."CUST_ESN", "MATM"."MAT_ENM", "BRANDM"."BRA_ENM", "MPTM"."CLR_CARD", "MPTM"."OA_EXW", "MPTM"."PO_NO", "MPTM"."PM_SF" , '', a.mov_d\|\|a.mov_t dt, 1000, mptm.send_d, oad.conserve_d, mptm.mptm_rmk, '' as trm_d, '' as ship_d FROM WIP_Moveoutm a, "MPTM", "MATM", "CUSTM", "BRANDM", oad WHERE ( "CUSTM"."CUST_NO"(+) = "MPTM"."CUST_NO" ) and ( "MPTM"."MAT_NO" = "MATM"."MAT_NO"(+) ) and ( "BRANDM"."BRA_NO"(+) = "MPTM"."BRA_NO" ) and a.fo_no(+) = mptm.fo_no AND A.FO_NO IS NULL and mptm.fo_no =oad.fo_no(+) AND mptm.fo_no in( select fo_no from mptm minus select oad.fo_no fo_no from oad, mptm where oad.fo_no=mptm.fo_no and oad.ship_status in('3', '4')) and mptm.fo_kd in ('4') and mptm.gmk_no in ( 'A1', 'A2', 'A3' ) and MPTM.MF_MK in('1', '5', '7')
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9aqjqcwbqaztn	SELECT m.ooa_no, d.oa_seq, m.po_date, d.po_no, d.oa_qty, ma.mat_enm, d.clr_card , a.loi_qty loi_sf, d.oa_qty -NVL(a.loi_qty, 0)bal_sf FROM OAD d, OAM m , MATM ma , ( SELECT a.oa_sno, a.oa_seq, sum( oad.loi_qty) loi_qty FROM OAD, OAM , ( SELECT d.oa_sno, d.po_no, d.mat_no, d.oa_seq FROM OAD d, oam m WHERE m.oa_sno=d.oa_sno and m.ord_kd in('A', 'B') and d.ship_status <>'4' )a WHERE ( oam.oa_sno = oad.oa_sno ) and (( trim(oad.loi_no) =a.po_no and oad.mat_no =a.mat_no and nvl(oad.loi_no_seq, '0') = '0') OR (trim(oad.loi_no) =a.po_no and oad.mat_no <>a.mat_no AND oad.loi_no_seq=a.oa_seq) OR (trim(oad.loi_no) =a.po_no and oad.mat_no = a.mat_no AND oad.loi_no_seq=a.oa_seq)) and oad.ship_status <>'4' and Trim(oam.bl_fac) = 'PAC' group by a.oa_sno, a.oa_seq )a WHERE ( m.OA_SNO = d.OA_SNO ) AND ( d.MAT_NO = ma.MAT_NO) AND d.OA_QTY >0 AND d.SHIP_STATUS NOT IN ('3', '4') AND ( m.ORD_KD IN ('A', 'B')) AND m.bl_fac='PAC' and d.oa_sno=a.oa_sno(+) and d.oa_seq=a.oa_seq(+)
9bgxxhyqbhcad	BEGIN pro_history_wbstockm( '20120321' ); END;
a73wbv1yu8x5c	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1
abuba2mfz1qv7	Select usekd From syscolpri Where userid =:1 And workname =:2 And dwname =:3 And columnname =:4
ajq6uyr9f6azw	SELECT FACT_FEN, FACT_CW, FACT_COMP, FACT_PUR, FACT_G2 FROM PMS.FACTM WHERE FACT_NO=:B1
b327z4z9pq2nd	SELECT "HK_CIM"."COM_NO", "HK_CIM"."CI_NO", "HK_CIM"."CI_D", "HK_CIM"."HKPL_NO", "HK_CIM"."VERSION", "HK_CIM"."GUI_NO", "HK_CIM"."VOID", "HK_CIM"."POST_MK", "HK_CIM"."CUST_NO", "HK_CIM"."C_SOLD_TO_NO", "HK_CIM"."CURRENCY", "HK_CIM"."EXCHANGE_RATE", "HK_CIM"."CUSTOM_D", "HK_CIM"."PAYMENT_TERM", "HK_CIM"."CH_NO_1", "HK_CIM"."CH_AMT_1", "HK_CIM"."CH_NO_2", "HK_CIM"."CH_AMT_2", "HK_CIM"."CH_NO_3", "HK_CIM"."CH_AMT_3", "HK_CIM"."HEADER_RMK", "HK_CIM"."FOOTER_RMK", "HK_CIM"."CRE_PER", "HK_CIM"."CRE_TIME", "HK_CIM"."TX_PER", "HK_CIM"."TX_TIME", "HK_CIM"."SHIP_TERM", "HK_CIM"."CH_DESC_1", "HK_CIM"."CH_DESC_2", "HK_CIM"."CH_DESC_3", "HK_CIM"."INV_TYPE_DESC", "HK_CIM"."CH_AC_1", "HK_CIM"."CH_AC_2", "HK_CIM"."CH_AC_3", "HK_CIM"."SEND_DOC_DATE", "HK_CIM"."CRE_TOOL", "HK_CIM"."OVERDUE_REASON", "HK_CIM"."REASON_RMK", "HK_CIM"."SURCHARGE" , DUE_DATE , OVER_DATE , REST_QTY, "HK_CIM"."SAL_RMK" FROM "HK_CIM" , v_hkinv_overdue WHERE ( "HK_CIM"."COM_NO" = :as_com ) AND ( "HK_CIM"."CI_NO" = :as_no ) and "HK_CIM"."CI_NO" not like 'FOC%' and hk_cim.ci_no=v_hkinv_overdue.INVOICE_NO
c6awqs517jpj0	select /+ index(idl_char$ i_idl_char1) +/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
cuk07gar1gara	SELECT '' c_s, "COLOR_PSCTM"."PSCT_NO", "COLOR_PSCTM"."FO_NO", "COLOR_PSCTM"."TYPE_NO", "COLOR_PSCTM"."CLR_NO", "TYPEM"."TYPE_EDC", "COLORM"."CLR_EDC", "COLOR_PSCTM"."GMK_NO", "COLOR_PSCTM"."MODEL_NO", "COLOR_PSCTM"."COLOR_SF", "COLOR_PSCTM"."COLOR_CARD", "COLOR_PSCTM"."PERSF1_WGT", "COLOR_PSCTM"."PERSF2_WGT", "COLOR_PSCTM"."PERSF3_WGT", "COLOR_PSCTM"."PERSF4_WGT", "COLOR_PSCTM"."PERSF5_WGT", "COLOR_PSCTM"."PERSF6_WGT", "COLOR_PSCTM"."PERSF7_WGT", "COLOR_PSCTM"."PERSF8_WGT" FROM "COLOR_PSCTM", "TYPEM", "COLORM", "MODEL_FINISHM", mptm WHERE "COLOR_PSCTM"."TYPE_NO" = "TYPEM"."TYPE_NO" AND "COLOR_PSCTM"."CLR_NO" = "COLORM"."CLR_NO" AND "COLOR_PSCTM"."MODEL_NO" = "MODEL_FINISHM"."FINISH_NO" AND "COLOR_PSCTM"."FO_NO" =mptm.fo_no AND "COLOR_PSCTM"."CRE_TIME" >=to_char(add_months(sysdate, -6), 'yyyymmdd') AND SUBSTR("COLOR_PSCTM"."CRE_TIME", 1, 4) <= to_char(sysdate, 'yyyy') AND ((mptm.mf_mk <>'4') or (mptm.mf_mk ='4' AND NVL(substr(mptm.close_d, 1, 6), to_char(sysdate, 'yyyymm'))=to_char(sysdate, 'yyyymm')) or (mptm.mf_mk ='4' AND NVL(substr(mptm.close_d, 1, 6), to_char(sysdate, 'yyyymm')) <to_char(sysdate, 'yyyymm') AND NVL(substr(mptm.close_d, 1, 8), to_char(sysdate, 'yyyymmdd')) >=to_char(sysdate -3, 'yyyymmdd')) ) And color_psctm.fo_n o Like '12%'
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
cx9nxvmg6pb17	declare message varchar2(120); IP varchar2(15); v_os_user varchar2(80); v_module varchar2(50); v_action varchar2(50); v_pid varchar2(10); v_sid number; begin IF (ora_is_servererror(1017)) THEN if sys_context('userenv', 'network_protocol') = 'tcp' then IP := sys_context('userenv', 'ip_address'); else select distinct sid into v_sid from sys.v_$mystat; SELECT p.SPID into v_pid FROM V$PROCESS p, V$SESSION v WHERE p.ADDR = v.PADDR AND v.sid = v_sid; end if; v_os_user := sys_context('userenv', 'os_user'); dbms_application_info.READ_MODULE(v_module, v_action); message := to_char(sysdate, 'Dy Mon dd HH24:MI:SS YYYY') \|\| ' logon denied from ' \|\| nvl(IP, v_pid) \|\| ' ' \|\| v_os_user \|\| ' with ' \|\| v_module \|\| ' ' \|\| v_action; sys.dbms_system.ksdwrt(2, message); end if; end;
d8f9pd0rv5x2b	SELECT '' c_s, "COLOR_PSCTM"."PSCT_NO", "COLOR_PSCTM"."FO_NO", "COLOR_PSCTM"."TYPE_NO", "COLOR_PSCTM"."CLR_NO", "TYPEM"."TYPE_EDC", "COLORM"."CLR_EDC", "COLOR_PSCTM"."GMK_NO", "COLOR_PSCTM"."MODEL_NO", "COLOR_PSCTM"."COLOR_SF", "COLOR_PSCTM"."COLOR_CARD", "COLOR_PSCTM"."PERSF1_WGT", "COLOR_PSCTM"."PERSF2_WGT", "COLOR_PSCTM"."PERSF3_WGT", "COLOR_PSCTM"."PERSF4_WGT", "COLOR_PSCTM"."PERSF5_WGT", "COLOR_PSCTM"."PERSF6_WGT", "COLOR_PSCTM"."PERSF7_WGT", "COLOR_PSCTM"."PERSF8_WGT" FROM "COLOR_PSCTM", "TYPEM", "COLORM", "MODEL_FINISHM", mptm WHERE "COLOR_PSCTM"."TYPE_NO" = "TYPEM"."TYPE_NO" AND "COLOR_PSCTM"."CLR_NO" = "COLORM"."CLR_NO" AND "COLOR_PSCTM"."MODEL_NO" = "MODEL_FINISHM"."FINISH_NO" AND "COLOR_PSCTM"."FO_NO" =mptm.fo_no AND "COLOR_PSCTM"."CRE_TIME" >=to_char(add_months(sysdate, -6), 'yyyymmdd') AND SUBSTR("COLOR_PSCTM"."CRE_TIME", 1, 4) <= to_char(sysdate, 'yyyy') AND ((mptm.mf_mk <>'4') or (mptm.mf_mk ='4' AND NVL(substr(mptm.close_d, 1, 6), to_char(sysdate, 'yyyymm'))=to_char(sysdate, 'yyyymm')) or (mptm.mf_mk ='4' AND NVL(substr(mptm.close_d, 1, 6), to_char(sysdate, 'yyyymm')) <to_char(sysdate, 'yyyymm') AND NVL(substr(mptm.close_d, 1, 8), to_char(sysdate, 'yyyymmdd')) >=to_char(sysdate -3, 'yyyymmdd')) ) And color_psctm.fo_n o Like '1%'
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
f0wzs9nc663bn	select sysdate from dual
f2gu31xz3d4f0	SELECT '' as_kd, "OAM"."OOA_NO" "OOA_NO", DECODE("OAM"."ORD_KD", '7', '1', '8', '1', '0', '1', '0') "ORD_KD", "PLD"."PO_NO", "PLM"."GMK_NO", "MATM"."MAT_NO", "MATM"."MAT_ENM", "PLD"."FO_NO", 'PAC' "BL_FAC", "M"."CI_NO" "CI_NO", "PLM"."CUST_NO", "PLM"."PL_NO", "PLM"."SHIP_D", SUM("PLD"."CUTO_SF") SHIP_QTY, NVL("OAD"."SAL_PRI", 0)sal_pri, NVL("OAD"."VAT", 0)vat, "PLD"."CLR_CARD", "PLD"."PL_SEQ" FROM PLD , PLM , "MATM", "OAM", "OAD", CIM M, CID D WHERE "PLM"."PL_NO" = "PLD"."PL_NO" AND "PLD"."MAT_NO" = "MATM"."MAT_NO" AND "PLM"."FACT_NO" ='0003' AND NVL(PLD.CLAIM_FLG, 'N') = 'N' AND ship_mk = 'Y' AND ( RTRIM("PLM"."FACT_NO") = RTRIM("OAM"."FACT_NO") ) AND ( "PLD"."OA_SNO" = "OAM"."OA_SNO" ) and ( "PLD"."OA_SEQ" = "OAD"."OA_SEQ" ) and ( "OAM"."OA_SNO" = "OAD"."OA_SNO" ) AND M.CI_NO(+)=D.CI_NO AND D.PL_NO(+)= PLD.PL_NO AND D.PL_SEQ(+)=PLD.PL_SEQ GROUP BY "OAM"."OOA_NO", DECODE("OAM"."ORD_KD", '7', '1', '8', '1', '0', '1', '0'), "PLD"."PO_NO", "PLM"."GMK_NO", "MATM"."MAT_NO", "MATM"."MAT_ENM", "PLD"."FO_NO", "M"."CI _NO" , "PLM"."CUST_NO", "PLM"."PL_NO", "PLM"."SHIP_D", "OAD"."SAL_PRI", "PLD"."CLR_CARD", "PLD"."PL_SEQ", NVL("OAD"."VAT", 0)
f8h20ksw1bbw5	SELECT "MATM"."MAT_NO", "MATM"."MAT_ENM", "MATM"."MAT_CNM" FROM "MATM" WHERE "MATM"."MAT_STA" <> 'S'
f8pavn1bvsj7t	select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1
fuzdrmbvrbs9c	SELECT "GS_STORE_CHANGED"."FO_NO", "GS_STORE_CHANGED"."GS_SCM_NO", "GS_STORE_CHANGED"."GS_SCD_SEQ", "GS_STORE_CHANGEM"."GS_SCM_DT", "GS_STORE_CHANGEM"."GS_SCM_KD", "GS_STORE_CHANGEM"."UPRACK_RESN", "GS_STORE_CHANGEM"."DOWNRACK_RESN", "GS_STORE_CHANGEM"."WORK_CLASS", "GS_STORE_CHANGED"."GWH_KD", "GS_STORE_CHANGED"."IN_D", "GS_STORE_CHANGED"."PKG_NO", "WHMANM"."WHMAN_CNM", "GS_STORE_CHANGED"."NSTORE_POS", "GS_STORE_CHANGED"."STK_QTY", "GS_STORE_CHANGED"."STK_SF", "GS_STORE_CHANGED"."CLOSE_MK" FROM "GS_STORE_CHANGED", "GS_STORE_CHANGEM", "WHMANM" WHERE ( gs_store_changem.whman_no = whmanm.whman_no (+)) and ( "GS_STORE_CHANGEM"."GS_SCM_NO" = "GS_STORE_CHANGED"."GS_SCM_NO" ) and ( ( "GS_STORE_CHANGED"."FO_NO" = :as_fono ) )
ga9j9xk5cy9s0	select /+ index(idl_sb4$ i_idl_sb41) +/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#

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	461,110	63.90	69.70
CPU used when call started	467,656	64.81	70.69
CR blocks created	4,729	0.66	0.71
Cached Commit SCN referenced	2,750,385	381.15	415.72
Commit SCN cached	47	0.01	0.01
DB time	2,295,741	318.14	347.00
DBWR checkpoint buffers written	13,980	1.94	2.11
DBWR checkpoints	3	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	376	0.05	0.06
DBWR undo block writes	12,503	1.73	1.89
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	2,823	0.39	0.43
IMU CR rollbacks	2,406	0.33	0.36
IMU Flushes	865	0.12	0.13
IMU Redo allocation size	6,970,956	966.03	1,053.65
IMU commits	5,103	0.71	0.77
IMU contention	17	0.00	0.00
IMU ktichg flush	8	0.00	0.00
IMU pool not allocated	525	0.07	0.08
IMU recursive-transaction flush	7	0.00	0.00
IMU undo allocation size	25,868,208	3,584.79	3,909.95
IMU- failed to get a private strand	525	0.07	0.08
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	1,241,406	172.03	187.64
PX local messages sent	1,241,406	172.03	187.64
Parallel operations downgraded 1 to 25 pct	0	0.00	0.00
Parallel operations not downgraded	2,823	0.39	0.43
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	2	0.00	0.00
SQL*Net roundtrips to/from client	764,840	105.99	115.60
SQL*Net roundtrips to/from dblink	145,903	20.22	22.05
active txn count during cleanout	22,584	3.13	3.41
application wait time	267	0.04	0.04
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	4	0.00	0.00
background checkpoints started	3	0.00	0.00
background timeouts	25,609	3.55	3.87
branch node splits	0	0.00	0.00
buffer is not pinned count	38,115,498	5,282.00	5,761.11
buffer is pinned count	77,544,623	10,746.05	11,720.77
bytes received via SQL*Net from client	199,103,908	27,591.60	30,094.30
bytes received via SQL*Net from dblink	29,068,605	4,028.30	4,393.68
bytes sent via SQL*Net to client	7,103,064,008	984,334.90	1,073,619.11
bytes sent via SQL*Net to dblink	17,132,332	2,374.18	2,589.53
calls to get snapshot scn: kcmgss	2,418,542	335.16	365.56
calls to kcmgas	90,834	12.59	13.73
calls to kcmgcs	17,062	2.36	2.58
change write time	470	0.07	0.07
cleanout - number of ktugct calls	26,689	3.70	4.03
cleanouts and rollbacks - consistent read gets	2,797	0.39	0.42
cleanouts only - consistent read gets	3,038	0.42	0.46
cluster key scan block gets	163,381	22.64	24.69
cluster key scans	88,174	12.22	13.33
commit batch performed	12	0.00	0.00
commit batch requested	12	0.00	0.00
commit batch/immediate performed	93	0.01	0.01
commit batch/immediate requested	93	0.01	0.01
commit cleanout failures: block lost	6,816	0.94	1.03
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	195	0.03	0.03
commit cleanout failures: cannot pin	2	0.00	0.00
commit cleanouts	35,690	4.95	5.39
commit cleanouts successfully completed	28,677	3.97	4.33
commit immediate performed	81	0.01	0.01
commit immediate requested	81	0.01	0.01
commit txn count during cleanout	9,374	1.30	1.42
concurrency wait time	828	0.11	0.13
consistent changes	634,204	87.89	95.86
consistent gets	218,773,052	30,317.33	33,067.27
consistent gets - examination	42,233,777	5,852.71	6,383.58
consistent gets direct	707	0.10	0.11
consistent gets from cache	218,772,342	30,317.23	33,067.16
current blocks converted for CR	1	0.00	0.00
cursor authentications	11,285	1.56	1.71
data blocks consistent reads - undo records applied	12,778	1.77	1.93
db block changes	1,466,463	203.22	221.65
db block gets	1,252,699	173.60	189.34
db block gets direct	81	0.01	0.01
db block gets from cache	1,252,618	173.59	189.33
deferred (CURRENT) block cleanout applications	18,288	2.53	2.76
dirty buffers inspected	11,234	1.56	1.70
enqueue conversions	344,665	47.76	52.10
enqueue deadlocks	0	0.00	0.00
enqueue releases	217,254	30.11	32.84
enqueue requests	219,905	30.47	33.24
enqueue timeouts	2,637	0.37	0.40
enqueue waits	2,842	0.39	0.43
exchange deadlocks	0	0.00	0.00
execute count	1,827,323	253.23	276.20
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	27,150,676	3,762.51	4,103.79
free buffer requested	27,046,267	3,748.04	4,088.01
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	39,359	5.45	5.95
hot buffers moved to head of LRU	1,306,220	181.01	197.43
immediate (CR) block cleanout applications	5,835	0.81	0.88
immediate (CURRENT) block cleanout applications	7,851	1.09	1.19
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	17,093	2.37	2.58
index fast full scans (full)	1,167	0.16	0.18
index fetch by key	30,066,635	4,166.60	4,544.53
index scans kdiixs1	3,434,749	475.98	519.16
leaf node 90-10 splits	174	0.02	0.03
leaf node splits	1,777	0.25	0.27
lob reads	743	0.10	0.11
lob writes	283	0.04	0.04
lob writes unaligned	283	0.04	0.04
logons cumulative	13,133	1.82	1.99
messages received	20,453	2.83	3.09
messages sent	20,453	2.83	3.09
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	175,562,187	24,329.22	26,536.00
opened cursors cumulative	213,672	29.61	32.30
parse count (failures)	3,110	0.43	0.47
parse count (hard)	36,498	5.06	5.52
parse count (total)	283,081	39.23	42.79
parse time cpu	55,821	7.74	8.44
parse time elapsed	81,728	11.33	12.35
physical read IO requests	5,561,929	770.77	840.68
physical read bytes	###############	30,725,306.39	33,512,248.65
physical read total IO requests	5,568,839	771.72	841.72
physical read total bytes	###############	30,758,565.26	33,548,524.27
physical read total multi block requests	3,187,181	441.68	481.74
physical reads	27,065,068	3,750.65	4,090.85
physical reads cache	26,964,192	3,736.67	4,075.60
physical reads cache prefetch	21,410,645	2,967.06	3,236.19
physical reads direct	100,876	13.98	15.25
physical reads direct (lob)	672	0.09	0.10
physical reads direct temporary tablespace	100,121	13.87	15.13
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	26,294	3.64	3.97
physical write bytes	1,075,994,624	149,110.17	162,635.22
physical write total IO requests	45,467	6.30	6.87
physical write total bytes	1,570,034,688	217,573.70	237,308.75
physical write total multi block requests	23,921	3.31	3.62
physical writes	131,347	18.20	19.85
physical writes direct	100,250	13.89	15.15
physical writes direct (lob)	40	0.01	0.01
physical writes direct temporary tablespace	100,121	13.87	15.13
physical writes from cache	31,097	4.31	4.70
physical writes non checkpoint	126,761	17.57	19.16
pinned buffers inspected	30,176	4.18	4.56
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	1	0.00	0.00
process last non-idle time	7,176	0.99	1.08
queries parallelized	2,815	0.39	0.43
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	3,999,979	554.31	604.59
recursive cpu usage	111,511	15.45	16.85
redo blocks read for recovery	0	0.00	0.00
redo blocks written	310,488	43.03	46.93
redo buffer allocation retries	7	0.00	0.00
redo entries	704,273	97.60	106.45
redo log space requests	12	0.00	0.00
redo log space wait time	229	0.03	0.03
redo ordering marks	11,718	1.62	1.77
redo size	151,106,252	20,940.14	22,839.52
redo subscn max counts	14,095	1.95	2.13
redo synch time	11,119	1.54	1.68
redo synch writes	7,194	1.00	1.09
redo wastage	2,239,768	310.38	338.54
redo write time	13,784	1.91	2.08
redo writer latching time	0	0.00	0.00
redo writes	8,314	1.15	1.26
rollback changes - undo records applied	1,033	0.14	0.16
rollbacks only - consistent read gets	1,259	0.17	0.19
rows fetched via callback	7,860,560	1,089.31	1,188.11
session connect time	0	0.00	0.00
session cursor cache hits	246,462	34.15	37.25
session logical reads	220,025,772	30,490.93	33,256.62
session pga memory	33,374,770,224	4,625,039.44	5,044,554.15
session pga memory max	###############	15,654,853.56	17,074,828.75
session uga memory	###############	24,466,189.69	26,685,398.09
session uga memory max	11,741,643,360	1,627,144.19	1,774,734.49
shared hash latch upgrades - no wait	156,729	21.72	23.69
shared hash latch upgrades - wait	2	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	122,417	16.96	18.50
sorts (rows)	41,035,916	5,686.71	6,202.53
sql area evicted	34,683	4.81	5.24
sql area purged	3,112	0.43	0.47
summed dirty queue length	87,210	12.09	13.18
switch current to new buffer	60,705	8.41	9.18
table fetch by rowid	37,209,175	5,156.41	5,624.12
table fetch continued row	390,951	54.18	59.09
table scan blocks gotten	153,728,407	21,303.52	23,235.85
table scan rows gotten	5,457,017,487	756,227.56	824,821.26
table scans (cache partitions)	0	0.00	0.00
table scans (direct read)	0	0.00	0.00
table scans (long tables)	140,847	19.52	21.29
table scans (rowid ranges)	132,681	18.39	20.05
table scans (short tables)	102,304	14.18	15.46
total number of times SMON posted	157	0.02	0.02
transaction rollbacks	93	0.01	0.01
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	82,325,188	11,408.54	12,443.35
user I/O wait time	974,406	135.03	147.28
user calls	844,116	116.98	127.59
user commits	6,401	0.89	0.97
user rollbacks	215	0.03	0.03
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	108	0.01	0.02
workarea executions - optimal	96,098	13.32	14.53
write clones created in background	0	0.00	0.00
write clones created in foreground	3	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
opened cursors current	802	2,398
workarea memory allocated	33,164	33,845
logons current	119	240
session cursor cache count	16,918,341	16,925,071

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)	3	1.50

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
PMS	5,135,819	712	1.52	4.61	7,600	1	595,109	1.07
USERS	384,569	53	2.55	8.29	2,582	0	3,180	4.44
SYSTEM	24,436	3	7.46	1.11	398	0	8	6.25
TEMP	6,693	1	0.02	14.96	9,197	1	0	0.00
NCS	6,546	1	6.13	12.19	324	0	0	0.00
UNDOTBS1	300	0	8.37	1.00	5,489	1	1	0.00
SYSAUX	2,042	0	7.02	1.03	673	0	0	0.00
PAMIS	39	0	4.87	1.54	10	0	0	0.00
PCS	18	0	5.00	1.83	4	0	0	0.00
IDX_PCS	7	0	1.43	1.00	4	0	0	0.00
OEM_PMS	4	0	0.00	1.00	4	0	0	0.00
PERFSTAT	4	0	0.00	1.00	4	0	0	0.00
USERS_CLOB	4	0	0.00	1.00	4	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
IDX_PCS	+DATA1/prm/datafile/idx_pcs.274.723979987	7	0	1.43	1.00	4	0	0	0.00
NCS	+DATA1/prm/datafile/ncs.273.723979987	6,546	1	6.13	12.19	324	0	0	0.00
OEM_PMS	+DATA1/prm/datafile/oem_pms.270.723979977	4	0	0.00	1.00	4	0	0	0.00
PAMIS	+DATA1/prm/datafile/pamis	39	0	4.87	1.54	10	0	0	0.00
PCS	+DATA1/prm/datafile/pcs.271.723979981	18	0	5.00	1.83	4	0	0	0.00
PERFSTAT	+DATA1/prm/datafile/perfstat.276.723979991	4	0	0.00	1.00	4	0	0	0.00
PMS	+DATA1/prm/datafile/pms.272.723979983	5,135,819	712	1.52	4.61	7,600	1	595,109	1.07
SYSAUX	+DATA1/prm/datafile/sysaux.266.723809305	2,042	0	7.02	1.03	673	0	0	0.00
SYSTEM	+DATA1/prm/datafile/system.264.723809293	24,436	3	7.46	1.11	398	0	8	6.25
TEMP	+DATA1/prm/tempfile/temp.267.723809309	6,693	1	0.02	14.96	9,197	1	0
UNDOTBS1	+DATA1/prm/datafile/undotbs1.265.723809303	300	0	8.37	1.00	5,489	1	1	0.00
USERS	+DATA1/prm/datafile/users.268.723809313	384,569	53	2.55	8.29	2,582	0	3,180	4.44
USERS_CLOB	+DATA1/prm/datafile/users_clob.275.723979989	4	0	0.00	1.00	4	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	278,757	88	219,979,877	26,960,278	31,097	0	0	598,307

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	16	574	3703	66120	276480	66120
E	0	16	570	13492	43145	276480	43145

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	224	0.10	27,706	1.25	41,363,779,978
D	448	0.20	55,412	1.22	40,462,757,388
D	672	0.29	83,118	1.19	39,564,028,558
D	896	0.39	110,824	1.17	38,667,630,657
D	1,120	0.49	138,530	1.14	37,773,199,761
D	1,344	0.59	166,236	1.11	36,880,450,769
D	1,568	0.69	193,942	1.09	35,989,160,246
D	1,792	0.78	221,648	1.06	35,099,152,377
D	2,016	0.88	249,354	1.03	34,210,299,405
D	2,240	0.98	277,060	1.01	33,322,501,115
D	2,288	1.00	282,997	1.00	33,132,316,705
D	2,464	1.08	304,766	0.98	32,435,669,187
D	2,688	1.17	332,472	0.95	31,549,737,587
D	2,912	1.27	360,178	0.93	30,664,654,430
D	3,136	1.37	387,884	0.90	29,791,158,077
D	3,360	1.47	415,590	0.87	28,917,465,456
D	3,584	1.57	443,296	0.85	28,043,414,276
D	3,808	1.66	471,002	0.82	27,168,870,380
D	4,032	1.76	498,708	0.79	26,293,852,962
D	4,256	1.86	526,414	0.77	25,418,601,725
D	4,480	1.96	554,120	0.74	24,543,342,710

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
93.69	31,039	2,090

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,581	1,151	795.30	6.26	0.79	100.00	0.00	161,890
E	1,581	853	1,290.28	6.92	0.54	100.00	0.00	161,890

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	1-Pass Execs
2K	4K	70,998	70,998	0
64K	128K	745	745	0
128K	256K	1,174	1,174	0
256K	512K	805	805	0
512K	1024K	13,066	13,066	0
1M	2M	7,054	7,054	0
2M	4M	1,650	1,646	4
4M	8M	254	252	2
8M	16M	249	193	56
16M	32M	82	48	34
32M	64M	35	25	10
64M	128M	4	2	2

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
198	0.13	61,421,711.79	22,167,559.27	73.00	663,274
395	0.25	61,421,711.79	14,157,264.89	81.00	374,374
791	0.50	61,421,711.79	3,104,185.86	95.00	52,711
1,186	0.75	61,421,711.79	592,348.03	99.00	0
1,581	1.00	61,421,711.79	590,346.92	99.00	0
1,897	1.20	61,421,711.79	192,381.54	100.00	0
2,213	1.40	61,421,711.79	192,381.54	100.00	0
2,530	1.60	61,421,711.79	192,381.54	100.00	0
2,846	1.80	61,421,711.79	192,381.54	100.00	0
3,162	2.00	61,421,711.79	192,381.54	100.00	0
4,743	3.00	61,421,711.79	192,381.54	100.00	0
6,324	4.00	61,421,711.79	192,381.54	100.00	0
9,486	6.00	61,421,711.79	192,381.54	100.00	0
12,648	8.00	61,421,711.79	192,381.54	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
400	0.25	202	11,536	75,731,330	0.80	23,629,852	4.89	3,509,382,336
576	0.35	374	19,601	78,428,578	0.83	20,932,604	4.33	3,511,640,607
752	0.46	548	27,861	81,125,472	0.86	18,235,710	3.77	3,513,898,345
928	0.57	723	37,501	83,817,850	0.89	15,543,332	3.21	3,516,154,528
1,104	0.68	898	46,042	86,504,573	0.92	12,856,609	2.66	3,518,408,729
1,280	0.78	1,073	55,054	89,184,433	0.94	10,176,749	2.10	3,520,660,786
1,456	0.89	1,248	64,268	91,857,783	0.97	7,503,399	1.55	3,522,910,987
1,632	1.00	1,423	73,457	94,525,833	1.00	4,835,349	1.00	3,525,159,631
1,808	1.11	1,598	80,832	97,189,732	1.03	2,171,450	0.45	3,527,407,060
1,984	1.22	1,773	87,913	99,850,265	1.06	1	0.00	3,529,653,468
2,160	1.32	1,948	94,732	102,507,944	1.08	1	0.00	3,531,898,935
2,336	1.43	2,123	102,969	105,163,116	1.11	1	0.00	3,534,143,506
2,512	1.54	2,298	110,396	107,816,006	1.14	1	0.00	3,536,387,133
2,688	1.65	2,473	118,678	110,466,770	1.17	1	0.00	3,538,629,810
2,864	1.75	2,648	126,841	113,115,629	1.20	1	0.00	3,540,871,556
3,040	1.86	2,823	134,621	115,762,988	1.22	1	0.00	3,543,112,540
3,216	1.97	2,998	143,207	118,409,387	1.25	1	0.00	3,545,353,029
3,392	2.08	3,173	151,646	121,055,310	1.28	1	0.00	3,547,593,249

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,000	0.25	70,060,097	40,060,281,460
2,000	0.50	52,316,219	40,060,281,460
3,000	0.75	42,916,023	37,449,455,077
4,000	1.00	36,182,460	33,132,314,498
5,000	1.25	30,827,461	29,699,806,716
6,000	1.50	29,477,855	25,465,496,923
7,000	1.75	29,412,727	23,769,122,421
8,000	2.00	29,412,727	23,769,122,421

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	0.50	0	0	0	0
32	1.00	0	0	0	0
48	1.50	0	0	0	0
64	2.00	0	0	0	0
80	2.50	0	0	0	0
96	3.00	0	0	0	0
112	3.50	0	0	0	0
128	4.00	0	0	0	0
144	4.50	0	0	0	0
160	5.00	0	0	0	0
176	5.50	0	0	0	0
192	6.00	0	0	0	0
208	6.50	0	0	0	0
224	7.00	0	0	0	0
240	7.50	0	0	0	0
256	8.00	0	0	0	0
272	8.50	0	0	0	0
288	9.00	0	0	0	0
304	9.50	0	0	0	0
320	10.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	Total Wait Time (s)	Avg Time (ms)
data block	598,300	648	1
undo header	1	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	1	1	0	1	1	840.00
PS-PX Process Reservation	53,624	50,987	2,636	2,841	0	0.08

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	11.61	13,656	2,192	10	16.25/51.5333333333333333333333333333333333333	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
21-Mar 09:54	620	790	2,192	7	52	0/0	0/0/0/0/0/0
21-Mar 09:44	170	341	1,593	10	42	0/0	0/0/0/0/0/0
21-Mar 09:34	92	737	993	8	32	0/0	0/0/0/0/0/0
21-Mar 09:24	489	378	1,415	9	39	0/0	0/0/0/0/0/0
21-Mar 09:14	2,379	1,753	815	10	29	0/0	0/0/0/0/0/0
21-Mar 09:04	2,480	1,700	215	10	19	0/0	0/0/0/0/0/0
21-Mar 08:54	141	448	516	10	24	0/0	0/0/0/0/0/0
21-Mar 08:44	149	1,043	148	9	17	0/0	0/0/0/0/0/0
21-Mar 08:34	2,461	3,850	242	9	19	0/0	0/0/0/0/0/0
21-Mar 08:24	2,339	1,247	146	10	17	0/0	0/0/0/0/0/0
21-Mar 08:14	90	884	92	6	17	0/0	0/0/0/0/0/0
21-Mar 08:04	204	485	76	7	16	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 allocation	108	0.00		0	0
ASM db client latch	4,817	0.00		0	0
ASM map headers	60	0.00		0	0
ASM map load waiting list	10	0.00		0	0
ASM map operation freelist	2,681	0.52	0.00	0	0
ASM map operation hash table	11,605,247	0.00	0.02	0	0
ASM network background latch	2,945	0.00		0	0
AWR Alerted Metric Element list	48,706	0.00		0	0
Consistent RBA	8,317	0.00		0	0
FAL request queue	150	0.00		0	0
FAL subheap alocation	150	0.00		0	0
FIB s.o chain latch	174	0.00		0	0
FOB s.o list latch	1,552	0.52	0.00	0	0
In memory undo latch	51,938	0.00	1.50	0	8,065	0.00
JS queue state obj latch	43,290	0.00		0	0
JS slv state obj latch	159	0.63	0.00	0	0
KFK SGA context latch	6,494	0.02	0.00	0	0
KFMD SGA	1,617	0.68	0.09	0	0
KMG MMAN ready and startup request latch	2,736	0.00		0	0
KMG resize request state object freelist	89	0.00		0	0
KTF sga latch	20	0.00		0	1,900	0.00
KWQMN job cache list latch	1	0.00		0	0
KWQP Prop Status	4	0.00		0	0
MQL Tracking Latch	0			0	146	0.00
Memory Management Latch	1,105	0.00		0	2,726	0.00
OS process	1,551	0.00		0	0
OS process allocation	3,552	0.08	0.00	0	0
OS process: request allocation	711	0.42	0.00	0	0
PL/SQL warning settings	19,922	0.00		0	0
SGA IO buffer pool latch	645	0.00		0	796	0.00
SQL memory manager latch	2	0.00		0	2,390	0.00
SQL memory manager workarea list latch	566,021	0.18	0.00	0	0
Shared B-Tree	262	0.00		0	0
active checkpoint queue latch	14,372	0.00		0	0
active service list	78,352	6.77	0.01	0	2,595	0.00
archive control	145	0.00		0	0
archive process latch	2,696	0.00		0	0
begin backup scn array	48	0.00		0	0
buffer pool	1,589	0.00		0	0
cache buffer handles	54,166	0.01	0.00	0	0
cache buffers chains	428,279,347	0.06	0.01	0	103,345,726	0.00
cache buffers lru chain	413,092	0.20	0.02	0	179,471,064	0.18
cache table scan latch	0			0	3,175,907	0.11
channel handle pool latch	1,047	0.19	0.00	0	0
channel operations parent latch	36,397	0.02	0.00	0	0
checkpoint queue latch	472,018	0.00	0.00	0	170,537	0.01
client/application info	65,757	0.00		0	0
compile environment latch	13,080	0.00		0	0
dml lock allocation	34,292	0.00	0.00	0	0
dummy allocation	26,265	15.79	0.00	0	0
enqueue hash chains	788,559	0.36	0.01	0	1,039	0.00
enqueues	382,954	2.42	0.00	0	0
error message lists	28,279	12.21	0.00	0	0
event group latch	412	0.00		0	0
file cache latch	386	0.00		0	0
global KZLD latch for mem in SGA	303	0.00		0	0
global tx hash mapping	40,663	0.00		0	0
hash table column usage latch	2,787	0.04	0.00	0	18,827,666	0.00
hash table modification latch	356	0.00		0	0
job workq parent latch	0			0	82	0.00
job_queue_processes parameter latch	138	0.00		0	0
kks stats	160,045	0.00	0.00	0	0
kokc descriptor allocation latch	30	0.00		0	0
ksuosstats global area	485	0.00		0	0
ktm global data	162	0.00		0	0
kwqbsn:qsga	260	0.00		0	0
lgwr LWN SCN	8,406	0.02	0.00	0	0
library cache	2,346,707	1.09	0.00	0	132,695	0.03
library cache load lock	27,486	0.00		0	96	0.00
library cache lock	1,050,842	1.45	0.00	0	0
library cache lock allocation	17,092	0.00		0	0
library cache pin	645,727	0.55	0.00	0	0
library cache pin allocation	9,986	0.00		0	0
list of block allocation	819	0.00		0	0
loader state object freelist	440	0.00		0	0
logminer context allocation	2	0.00		0	0
longop free list parent	385	0.00		0	332	0.00
message pool operations parent latch	338	0.00		0	0
messages	100,554	0.01	0.00	0	0
mostly latch-free SCN	8,400	0.00		0	0
msg queue	20	0.00		0	20	0.00
multiblock read objects	10,233,574	0.01	0.01	0	0
ncodef allocation latch	124	0.00		0	0
object queue header heap	7,671	0.00		0	7,812	0.00
object queue header operation	54,012,504	0.00	0.00	0	144,837	0.00
object stats modification	19	0.00		0	0
parallel query alloc buffer	162,836	0.52	0.00	0	0
parallel query stats	21,193	23.32	0.00	0	0
parallel txn reco latch	32	0.00		0	0
parameter list	190	0.00		0	0
parameter table allocation management	13,324	45.61	0.08	0	0
post/wait queue	10,771	0.00		0	7,259	0.00
process allocation	3,526	0.00		0	412	0.00
process group creation	711	0.42	0.00	0	0
process queue	105,196	3.00	0.00	0	0
process queue reference	26,542,613	0.02	0.01	0	1,428,379	3.02
qmn task queue latch	1,789	0.00		0	0
query server freelists	82,549	6.23	0.00	0	0
query server process	52	0.00		0	60	0.00
redo allocation	41,132	0.02	0.00	0	704,301	0.00
redo copy	0			0	704,316	0.00
redo writing	44,417	0.00		0	0
resmgr group change latch	12,923	0.00		0	0
resmgr:active threads	26,259	0.00		0	0
resmgr:actses change group	13,076	0.00		0	0
resmgr:free threads list	26,257	27.89	0.00	0	0
resmgr:schema config	2	0.00		0	0
row cache objects	35,916,286	0.08	0.00	0	16,815	0.06
rules engine rule set statistics	200	0.00		0	0
segmented array pool	20	0.00		0	0
sequence cache	2,895	0.07	0.00	0	0
session allocation	1,403,394	1.52	0.01	0	0
session idle bit	1,705,873	0.03	0.00	0	0
session state list latch	25,981	25.66	0.00	0	0
session switching	124	0.00		0	0
session timer	2,595	0.00		0	0
shared pool	2,389,497	1.62	0.01	1	0
shared pool simulator	2,878,131	0.00	0.02	0	0
simulator hash latch	34,599,369	0.00	0.01	0	0
simulator lru latch	35,229	0.09	0.32	0	23,456,468	0.23
slave class	64	0.00		0	0
slave class create	68	1.47	1.00	0	0
sort extent pool	2,248	0.22	0.00	0	0
state object free list	4	0.00		0	0
statistics aggregation	672	0.00		0	0
temp lob duration state obj allocation	4	0.00		0	0
temporary table state object allocation	9	0.00		0	0
threshold alerts latch	477	0.00		0	0
transaction allocation	568	0.00		0	0
transaction branch allocation	41,004	0.00		0	0
undo global data	98,970	0.00		0	0
user lock	1,790	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	428,279,347	274,157	2,141	272,086
shared pool	2,389,497	38,692	251	38,450
row cache objects	35,916,286	29,502	70	29,435
library cache	2,346,707	25,559	62	25,501
session allocation	1,403,394	21,331	212	21,127
library cache lock	1,050,842	15,212	16	15,197
enqueues	382,954	9,268	28	9,240
resmgr:free threads list	26,257	7,324	8	7,316
session state list latch	25,981	6,666	8	6,658
parameter table allocation management	13,324	6,077	500	5,583
active service list	78,352	5,307	36	5,273
process queue reference	26,542,613	5,205	32	5,178
query server freelists	82,549	5,143	6	5,137
parallel query stats	21,193	4,943	14	4,929
dummy allocation	26,265	4,146	4	4,142
error message lists	28,279	3,454	6	3,449
process queue	105,196	3,159	6	3,153
enqueue hash chains	788,559	2,809	18	2,791
multiblock read objects	10,233,574	1,425	19	1,406
cache buffers lru chain	413,092	831	13	818
simulator hash latch	34,599,369	670	6	665
ASM map operation hash table	11,605,247	175	4	171
shared pool simulator	2,878,131	47	1	46
simulator lru latch	35,229	31	10	22
KFMD SGA	1,617	11	1	10
In memory undo latch	51,938	2	3	0
slave class create	68	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
ASM map operation hash table	kffmDoDone_1	3	3
ASM map operation hash table	kffmTranslate	1	1
In memory undo latch	ktiFlush: child	3	0
KFMD SGA	kfmdSlvJoinFetch	1	0
active service list	ksws_event: ksws event	880	879
active service list	kswsgsnp: get service name ptr	2	3
cache buffers chains	kcbgtcr: kslbegin excl	10,706	10,417
cache buffers chains	kcbrls: kslbegin	969	1,252
cache buffers chains	kcbzwb	37	64
cache buffers chains	kcbzib: multi-block read: nowait	28	0
cache buffers chains	kcbchg: kslbegin: bufs not pinned	6	3
cache buffers chains	kcbgtcr: fast path	4	6
cache buffers chains	kcbgcur: kslbegin	3	1
cache buffers chains	kcbzgb: scan from tail. nowait	3	0
cache buffers chains	kcbzib: finish free bufs	3	16
cache buffers chains	kcbgtcr: kslbegin shared	1	0
cache buffers lru chain	kcbzgws	9	0
cache buffers lru chain	kcbzar: KSLNBEGIN	3	0
cache buffers lru chain	kcbw_quiesce_granule	1	0
channel handle pool latch	ksrchconnect()	1	1
dummy allocation	ktcdod	2	2
dummy allocation	ktcscnfy	2	2
enqueue hash chains	ksqgtl3	14	15
enqueue hash chains	ksqrcl	3	3
enqueue hash chains	ksqcnl	1	0
enqueues	ksqdel	16	16
enqueues	ksqgel: create enqueue	12	11
error message lists	kxfpqsnd	5	4
error message lists	kxfpqidqr: KSLBEGIN	1	2
library cache	kglpin	15	12
library cache	kglpndl: child: after processing	12	1
library cache	kgldte: child 0	7	7
library cache	kglLockCursor	4	4
library cache	kglhdgn: child:	4	5
library cache	kglobpn: child:	3	16
library cache	kgldti: 2child	1	2
library cache	kglpndl: child: before processing	1	3
library cache	kglukp: child	1	1
library cache lock	kgllkdl: child: cleanup	11	9
library cache lock	kgllkal: child: multiinstance	5	7
library cache lock	kgllkdl: child: no lock handle	2	2
multiblock read objects	kcbzib: mbr get	12	2
multiblock read objects	kcbzib: normal mbr free	7	17
object queue header operation	kcbo_switch_cq	2	0
object queue header operation	kcbo_ivbo	1	1
parallel query stats	kxfprst: KSLBEGIN:1	14	14
parameter table allocation management	ksp_param_table_free	500	500
process queue	kxfpqsnd: KSLBEGIN	4	6
process queue	kxfpqidqr: KSLBEGIN	2	0
process queue reference	kxfpqrsnd	32	0
query server freelists	kxfpobadf	5	5
query server freelists	kxfpobrmf	1	1
resmgr:free threads list	kgskthrcreate	6	6
resmgr:free threads list	kgskthrsod	2	2
row cache objects	kqreqd: reget	54	1
row cache objects	kqreqd	4	5
row cache objects	kqrpre: find obj	2	57
row cache objects	kqrso	1	1
session allocation	ksuxds: KSUSFCLC not set	138	95
session allocation	kxfprdp	21	4
session allocation	kxfpqidqr	19	27
session allocation	ksursi	13	44
session allocation	ksucri	12	11
session allocation	ksudlc	5	17
session allocation	ksusin	2	2
session allocation	ksudlp	1	0
session allocation	ksuprc	1	12
session state list latch	kpseqd	5	3
session state list latch	kpseqa	3	5
shared pool	kghalo	179	138
shared pool	kghfre	30	35
shared pool	kghfrunp: alloc: wait	25	0
shared pool	kghfrunp: clatch: nowait	17	0
shared pool	kghfrunp: alloc: session dur	7	0
shared pool	kghupr1	6	47
shared pool	kghfrunp: clatch: wait	4	7
shared pool	kghalp	2	22
shared pool	kghasp	1	4
shared pool	kghfrh	1	0
shared pool simulator	kglsim_unpin_simhp	1	0
simulator hash latch	kcbsacc: lookup dba	3	4
simulator hash latch	kcbsacc: insert dba	2	0
simulator hash latch	kcbs_lookup_setid: lookup dba	1	2
simulator lru latch	kcbs_grow_pool	5	0
simulator lru latch	kcbs_shrink_pool	3	0
simulator lru latch	kcbs_free_granule_sim_buffers	1	0
simulator lru latch	kcbs_simulate: simulate set	1	0
slave class create	ksvcreate	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 220,025,772
Captured Segments account for 88.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
PMS	PMS	OAD	TABLE	57,002,672	25.91
PMS	PMS	OAM	TABLE	20,193,872	9.18
PMS	PMS	MPTM	TABLE	19,226,608	8.74
PMS	PMS	MATM	TABLE	8,612,752	3.91
PMS	PMS	PK_MPTM	INDEX	8,258,512	3.75

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 27,065,068
Captured Segments account for 84.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
PMS	PMS	OAD	TABLE	3,899,843	14.41
PMS	PMS	OAM	TABLE	2,864,928	10.59
PMS	PMS	HK_PLD	TABLE	2,343,230	8.66
PMS	PMS	MPTM	TABLE	2,178,200	8.05
PMS	PMS	PLD	TABLE	1,843,592	6.81

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
CENTER	USERS	PK_PLM	INDEX	11	28.21
PMS	PMS	PK_CUTPKGD	INDEX	5	12.82
CENTER	USERS	PK_CLAIMD	INDEX	4	10.26
PMS	PMS	PK_CLAIMD	INDEX	3	7.69
PAY	USERS	PK_MATM	INDEX	2	5.13

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	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	JOB$		TABLE	4	100.00

Back to Segment Statistics
Back to Top

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	130	0.00	4	1
dc_database_links	78,936	0.03	0	8
dc_global_oids	179	25.70	0	14
dc_histogram_data	2,771,287	2.18	0	15,336
dc_histogram_defs	447,644	5.29	0	4,405
dc_object_grants	281	22.78	0	16
dc_object_ids	842,396	0.39	0	935
dc_objects	97,320	3.25	2	783
dc_profiles	344	0.29	0	1
dc_rollback_segments	2,976	0.00	0	57
dc_segments	293,943	1.51	16	1,118
dc_sequences	639	0.78	639	1
dc_tablespace_quotas	1	100.00	1	0
dc_tablespaces	4,587,588	0.00	0	13
dc_usernames	6,148	1.04	0	15
dc_users	4,661,823	0.00	0	28
outstanding_alerts	168	53.57	0	13

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	188	6.38	20,810	0.27	43	0
CLUSTER	254	1.18	625	1.76	8	0
INDEX	48	58.33	137	20.44	0	0
JAVA RESOURCE	2	50.00	2	50.00	0	0
JAVA SOURCE	2	50.00	2	50.00	0	0
SQL AREA	148,906	30.99	1,983,158	5.46	15,795	4,891
TABLE/PROCEDURE	22,883	5.53	375,091	3.41	6,751	0
TRIGGER	6,198	2.68	27,981	2.66	572	0

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	668.79		4.68	4.50	36	85	143	143
	Freeable	113.69	0.00	1.00	0.57	6		114	114
	SQL	9.80	7.87	0.08	0.41	4	74	130	108
	PL/SQL	3.11	2.55	0.02	0.01	0	0	139	119
E	Other	1,103.00		4.31	3.41	36	85	256	256
	Freeable	160.00	0.00	0.72	0.36	2		223	223
	SQL	20.51	12.92	0.08	0.40	6	170	243	229
	PL/SQL	6.97	5.69	0.03	0.01	0	0	252	240

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	2,315,255,808	2,399,141,888
Fixed Size	2,091,296
Redo Buffers	14,684,160
Variable Size	2,919,237,344	2,835,351,264

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	0.00
large	ASM map operations hashta	0.38	0.38	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.60	14.60	0.00
shared	CCursor	32.78	24.18	-26.22
shared	Cursor Stats	40.78	40.78	0.00
shared	KGH: NO ACCESS	63.48	79.01	24.47
shared	KQR X PO	42.52	42.58	0.15
shared	PCursor	29.08	20.92	-28.08
shared	free memory	1,257.98	1,263.89	0.47
shared	kglsim heap	22.52	22.52	0.00
shared	kglsim object batch	39.85	39.85	0.00
shared	library cache	29.39	25.54	-13.12
shared	sql area	146.70	81.26	-44.61
streams	KGH: NO ACCESS	15.98	15.98	0.00
streams	Sender info	56.70	56.70	0.00
streams	free memory	25.51	25.51	0.00
streams	kgqmsub	1.58	1.58	0.00
streams	kwqbcqini:spilledovermsgs	9.04	9.04	0.00
streams	recov_kgqmsub	4.22	4.22	0.00
	buffer_cache	2,208.00	2,288.00	3.62
	fixed_sga	1.99	1.99	0.00
	log_buffer	14.00	14.00	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	39,809	0	0
QMON Slaves	25,641	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	0	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
processes	257	398	400	400
sessions	249	402	445	445

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/admin/prm/adump
background_dump_dest	/oracle/admin/prm/bdump
compatible	10.2.0.3.0
control_files	+DATA1/prm/controlfile/current.256.723809281, +DATA1/prm/controlfile/current.257.723809281
core_dump_dest	/oracle/admin/prm/cdump
db_block_size	8192
db_create_file_dest	+DATA1
db_domain	yyhj.com.cn
db_file_multiblock_read_count	16
db_name	prm
db_recovery_file_dest	+DATA1
db_recovery_file_dest_size	8589934592
job_queue_processes	30
log_archive_dest_10	location=/backup/arch/prm
open_cursors	300
pga_aggregate_target	1657798656
processes	400
remote_login_passwordfile	EXCLUSIVE
sessions	445
sga_max_size	5251268608
sga_target	4194304000
smtp_out_server	YYHJMAIL.YYHJ.COM.CN
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/admin/prm/udump

End of Report

% Blocks changed per Read:	0.67	Recursive Call %:	82.57
Rollback per transaction %:	3.25	Rows per Sort:	335.21

Buffer Nowait %:	99.73	Redo NoWait %:	100.00
Buffer Hit %:	87.75	In-memory Sort %:	100.00
Library Hit %:	94.94	Soft Parse %:	87.11
Execute to Parse %:	84.51	Latch Hit %:	99.92
Parse CPU to Parse Elapsd %:	68.30	% Non-Parse CPU:	87.86