WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

SFCDB 4266373347 sfcdb 1 10.2.0.5.0 NO GZPSDB1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
SFCDB	4266373347	sfcdb	1	10.2.0.5.0	NO	GZPSDB1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 6757 28-Mar-14 11:00:43 203 23.7

End Snap: 6758 28-Mar-14 12:00:56 156 24.8

Elapsed: 60.21 (mins)

DB Time: 33.23 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	6757	28-Mar-14 11:00:43	203	23.7
End Snap:	6758	28-Mar-14 12:00:56	156	24.8
Elapsed:		60.21 (mins)
DB Time:		33.23 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 1,856M 1,856M Std Block Size: 8K

Shared Pool Size: 560M 560M Log Buffer: 14,348K

	Begin	End
Buffer Cache:	1,856M	1,856M	Std Block Size:	8K
Shared Pool Size:	560M	560M	Log Buffer:	14,348K

Load Profile

Per Second Per Transaction

Redo size: 192,606.91 5,518.39

Logical reads: 6,291.00 180.24

Block changes: 1,300.17 37.25

Physical reads: 9.53 0.27

Physical writes: 37.05 1.06

User calls: 313.37 8.98

Parses: 144.43 4.14

Hard parses: 0.30 0.01

Sorts: 12.64 0.36

Logons: 0.11 0.00

Executes: 665.13 19.06

Transactions: 34.90

	Per Second	Per Transaction
Redo size:	192,606.91	5,518.39
Logical reads:	6,291.00	180.24
Block changes:	1,300.17	37.25
Physical reads:	9.53	0.27
Physical writes:	37.05	1.06
User calls:	313.37	8.98
Parses:	144.43	4.14
Hard parses:	0.30	0.01
Sorts:	12.64	0.36
Logons:	0.11	0.00
Executes:	665.13	19.06
Transactions:	34.90

% Blocks changed per Read: 20.67 Recursive Call %: 71.15

Rollback per transaction %: 0.36 Rows per Sort: 15.25

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.93 Soft Parse %: 99.79

Execute to Parse %: 78.29 Latch Hit %: 99.98

Parse CPU to Parse Elapsd %: 25.97 % Non-Parse CPU: 97.90

Shared Pool Statistics

Begin End

Memory Usage %: 79.85 78.79

% SQL with executions>1: 93.86 93.98

% Memory for SQL w/exec>1: 92.43 91.87

	Begin	End
Memory Usage %:	79.85	78.79
% SQL with executions>1:	93.86	93.98
% Memory for SQL w/exec>1:	92.43	91.87

Top 5 Timed Events

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

CPU time 649 32.5

SQL*Net message from dblink 9,218 540 59 27.1 Network

db file sequential read 32,460 198 6 9.9 User I/O

log file sync 119,809 89 1 4.4 Commit

log file parallel write 125,990 68 1 3.4 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		649		32.5
SQL*Net message from dblink	9,218	540	59	27.1	Network
db file sequential read	32,460	198	6	9.9	User I/O
log file sync	119,809	89	1	4.4	Commit
log file parallel write	125,990	68	1	3.4	System 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): 1994.1s
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	1,803.65	90.45
DB CPU	648.95	32.54
parse time elapsed	75.79	3.80
PL/SQL execution elapsed time	55.79	2.80
hard parse elapsed time	2.62	0.13
failed parse elapsed time	1.24	0.06
connection management call elapsed time	0.86	0.04
repeated bind elapsed time	0.67	0.03
PL/SQL compilation elapsed time	0.08	0.00
sequence load elapsed time	0.04	0.00
hard parse (sharing criteria) elapsed time	0.04	0.00
hard parse (bind mismatch) elapsed time	0.03	0.00
DB time	1,994.05
background elapsed time	124.60
background cpu time	33.54

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
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%Total Call Time
CPU time			649		32.54
Network	872,833		550	1	27.59
User I/O	32,893		199	6	9.96
Commit	119,809	0	89	1	4.44
System I/O	154,963		86	1	4.29
Concurrency	624		2	3	0.08
Application	1,502		1	1	0.06
Configuration	5	20	0	25	0.01
Other	399	2	0	0	0.01

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)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
SQL*Net message from dblink	9,218		540	59	0.07
db file sequential read	32,460		198	6	0.26
log file sync	119,809	0	89	1	0.95
log file parallel write	125,990		68	1	1.00
control file sequential read	16,258		9	1	0.13
SQL*Net more data from client	38,376		4	0	0.30
SQL*Net message to client	785,676		4	0	6.23
Log archive I/O	962		3	3	0.01
log file sequential read	976		3	3	0.01
control file parallel write	1,721		2	1	0.01
SQL*Net more data from dblink	149		2	10	0.00
SQL*Net break/reset to client	1,496		1	1	0.01
db file parallel write	9,048		1	0	0.07
enq: TX - index contention	112		1	10	0.00
SQL*Net more data to client	30,154		1	0	0.24
os thread startup	75		0	7	0.00
db file parallel read	56		0	9	0.00
db file scattered read	194		0	2	0.00
undo segment extension	1	100	0	102	0.00
rdbms ipc reply	103		0	1	0.00
direct path read	90		0	0	0.00
SQL*Net message to dblink	9,198		0	0	0.07
LGWR wait for redo copy	255	0	0	0	0.00
log file switch completion	4		0	5	0.00
enq: TX - row lock contention	3		0	7	0.00
buffer busy waits	209		0	0	0.00
latch: In memory undo latch	208		0	0	0.00
reliable message	20		0	0	0.00
latch free	9		0	1	0.00
TCP Socket (KGAS)	40		0	0	0.00
read by other session	1		0	6	0.00
enq: RO - fast object reuse	3		0	1	0.00
log file single write	8		0	0	0.00
SQL*Net more data to dblink	22		0	0	0.00
direct path write	92		0	0	0.00
latch: cache buffers chains	11		0	0	0.00
latch: library cache	7		0	0	0.00
latch: cache buffers lru chain	2		0	0	0.00
latch: enqueue hash chains	1		0	0	0.00
latch: session allocation	3		0	0	0.00
latch: row cache objects	1		0	0	0.00
latch: library cache pin	1		0	0	0.00
buffer deadlock	6	100	0	0	0.00
virtual circuit status	549,915	1	179,397	326	4.36
SQL*Net message from client	785,782		137,668	175	6.23
Streams AQ: waiting for messages in the queue	1,446	100	7,217	4991	0.01
jobq slave wait	2,340	97	6,958	2974	0.02
Streams AQ: qmn slave idle wait	129		3,591	27838	0.00
Streams AQ: qmn coordinator idle wait	258	50	3,591	13919	0.00
Streams AQ: waiting for time management or cleanup tasks	35	77	2,812	80346	0.00
single-task message	20		10	489	0.00
class slave wait	8		0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	125,990		68	1	1.00
control file sequential read	3,605		5	1	0.03
Log archive I/O	962		3	3	0.01
log file sequential read	976		3	3	0.01
control file parallel write	1,721		2	1	0.01
db file parallel write	9,048		1	0	0.07
os thread startup	75		0	7	0.00
events in waitclass Other	357	0	0	0	0.00
direct path read	90		0	0	0.00
log file single write	8		0	0	0.00
direct path write	90		-0	-0	0.00
rdbms ipc message	137,749	8	39,451	286	1.09
smon timer	18	61	3,719	206621	0.00
pmon timer	1,450	100	3,610	2490	0.01
Streams AQ: qmn slave idle wait	129		3,591	27838	0.00
Streams AQ: qmn coordinator idle wait	258	50	3,591	13919	0.00
Streams AQ: waiting for time management or cleanup tasks	35	77	2,812	80346	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	13,332
AVG_IDLE_TIME	347,749
AVG_SYS_TIME	4,767
AVG_USER_TIME	8,451
BUSY_TIME	107,507
IDLE_TIME	2,782,825
SYS_TIME	39,035
USER_TIME	68,472
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	6.8E+18
VM_OUT_BYTES	-7.9E+15
PHYSICAL_MEMORY_BYTES	8,418,492,416
NUM_CPUS	8
NUM_CPU_CORES	8

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	1,202.50	138.20	870	2,078,924
sfcdb.liteonit.com	791.80	510.90	32,498	20,619,556
SFCDB.GZP.LITEONIT.COM	0.00	0.00	0	0
SYS$BACKGROUND	0.00	0.00	1,044	35,082

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

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	1579	3	29	0	34865	541
sfcdb.liteonit.com	30175	194	520	1	836871	8
SYS$BACKGROUND	1142	2	75	1	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
Total DB Time (s): 1,994
Captured SQL account for 114.4% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
552	44	2	276.03	27.69	7d4mkdpgcsmf5		DECLARE job BINARY_INTEGER := ...
464	2	41	11.33	23.29	bphcr26f123xf	SajetApserver_ODAC.exe	SELECT WE.WIP_ENTITY_NAME, XXS...
455	2	3,957	0.12	22.82	f262pwx3ykaru		SELECT MSI.SEGMENT1 FROM MTL_S...
147	111	36,159	0.00	7.36	c1q6wm0mcn8rg	TGS_Server_ODAC.exe	begin SAJET.XXSFC_COMMAND_CODE...
79	61	7,392	0.01	3.94	4xxfcdzfg79yp	SajetApserver_ODAC.exe	begin SAJET.XXSFC_COMMAND_CODE...
53	15	30,165	0.00	2.65	1v2vfv48zxw31	SajetApserver_ODAC.exe	INSERT INTO SAJET.G_SN_TRAVEL ...
48	26	17,815	0.00	2.42	0jg3v6fp09wwp	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE_FCT(:...
43	20	37,900	0.00	2.16	8mmsd4pcwrrt1	SajetApserver_ODAC.exe	Insert Into SAJET.G_SN_STATUS ...
33	27	8,354	0.00	1.67	6s67zypjyzzwq	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE(:TSAJ...
29	9	27,155	0.00	1.44	4rsnfarj3sv18	SajetApserver_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET P...
23	10	2,687	0.01	1.18	fvja4ruj5yc6w	SajetApserver_ODAC.exe	begin SAJET.SJ_PACKING_GO(:TTE...
22	21	3,943	0.01	1.08	6dpw7ja9hyzqk		SELECT COUNT(*) FROM SAJET.G_W...
20	10	66,986	0.00	1.01	f4wa2482ba90u	TGS_Server_ODAC.exe	INSERT INTO SAJET.G_TEST_RESUL...
20	21	3,826	0.01	1.00	0swgap5h781vw		UPDATE SAJET.G_WO_PICK_LIST SE...

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 is the CPU Time divided into the Total CPU Time times 100
Total CPU Time (s): 649
Captured SQL account for 86.4% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
111	147	36,159	0.00	17.16	7.36	c1q6wm0mcn8rg	TGS_Server_ODAC.exe	begin SAJET.XXSFC_COMMAND_CODE...
61	79	7,392	0.01	9.43	3.94	4xxfcdzfg79yp	SajetApserver_ODAC.exe	begin SAJET.XXSFC_COMMAND_CODE...
44	552	2	22.23	6.85	27.69	7d4mkdpgcsmf5		DECLARE job BINARY_INTEGER := ...
27	33	8,354	0.00	4.22	1.67	6s67zypjyzzwq	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE(:TSAJ...
26	48	17,815	0.00	4.05	2.42	0jg3v6fp09wwp	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE_FCT(:...
21	22	3,943	0.01	3.20	1.08	6dpw7ja9hyzqk		SELECT COUNT(*) FROM SAJET.G_W...
21	20	3,826	0.01	3.17	1.00	0swgap5h781vw		UPDATE SAJET.G_WO_PICK_LIST SE...
20	43	37,900	0.00	3.06	2.16	8mmsd4pcwrrt1	SajetApserver_ODAC.exe	Insert Into SAJET.G_SN_STATUS ...
20	20	1,191	0.02	3.04	0.99	6xf2sz3zbgt3k	SajetApserver_ODAC.exe	SELECT PARAME_VALUE FROM SAJET...
18	19	431,188	0.00	2.85	0.96	3b5c2gdzvqw9v		SELECT SPA.PART_ID FROM SYS_PA...
15	53	30,165	0.00	2.36	2.65	1v2vfv48zxw31	SajetApserver_ODAC.exe	INSERT INTO SAJET.G_SN_TRAVEL ...
10	23	2,687	0.00	1.56	1.18	fvja4ruj5yc6w	SajetApserver_ODAC.exe	begin SAJET.SJ_PACKING_GO(:TTE...
10	20	66,986	0.00	1.55	1.01	f4wa2482ba90u	TGS_Server_ODAC.exe	INSERT INTO SAJET.G_TEST_RESUL...
9	9	48,940	0.00	1.45	0.46	65yr7qa3d30mr	SajetApserver_ODAC.exe	SELECT NEXT_PROCESS_ID FROM SA...
9	29	27,155	0.00	1.39	1.44	4rsnfarj3sv18	SajetApserver_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET P...
9	13	2,823	0.00	1.36	0.66	1yfmpc4d0457j	TGS_Server_ODAC.exe	begin SAJET.LITEONIT_SMTTEST_G...
8	8	247	0.03	1.19	0.39	bggamr1xt3w3j	Realtime Connection	SELECT event#, sql_id, sql_pla...
7	14	32,300	0.00	1.10	0.72	3fufs6k2wt4u2	SajetApserver_ODAC.exe	Insert Into SAJET.G_WO_CUSTOME...
7	7	66	0.11	1.07	0.35	1p9y3cfg68da1	SajetApserver_ODAC.exe	Select EMP_NO, EMP_NAME, PASSW...

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: 22,728,729
Captured SQL account for 65.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
4,680,347	36,159	129.44	20.59	111.38	146.74	c1q6wm0mcn8rg	TGS_Server_ODAC.exe	begin SAJET.XXSFC_COMMAND_CODE...
4,159,751	7,392	562.74	18.30	61.21	78.59	4xxfcdzfg79yp	SajetApserver_ODAC.exe	begin SAJET.XXSFC_COMMAND_CODE...
2,226,046	37,900	58.73	9.79	19.87	43.01	8mmsd4pcwrrt1	SajetApserver_ODAC.exe	Insert Into SAJET.G_SN_STATUS ...
2,167,549	1,191	1,819.94	9.54	19.75	19.80	6xf2sz3zbgt3k	SajetApserver_ODAC.exe	SELECT PARAME_VALUE FROM SAJET...
1,798,673	2	899,336.50	7.91	44.46	552.06	7d4mkdpgcsmf5		DECLARE job BINARY_INTEGER := ...
1,735,413	30,165	57.53	7.64	15.29	52.89	1v2vfv48zxw31	SajetApserver_ODAC.exe	INSERT INTO SAJET.G_SN_TRAVEL ...
1,724,752	431,188	4.00	7.59	18.47	19.23	3b5c2gdzvqw9v		SELECT SPA.PART_ID FROM SYS_PA...
1,154,992	8,354	138.26	5.08	27.39	33.24	6s67zypjyzzwq	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE(:TSAJ...
975,071	66,986	14.56	4.29	10.03	20.21	f4wa2482ba90u	TGS_Server_ODAC.exe	INSERT INTO SAJET.G_TEST_RESUL...
945,336	17,815	53.06	4.16	26.25	48.22	0jg3v6fp09wwp	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE_FCT(:...
939,641	27,155	34.60	4.13	9.00	28.65	4rsnfarj3sv18	SajetApserver_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET P...
906,868	3,943	229.99	3.99	20.75	21.63	6dpw7ja9hyzqk		SELECT COUNT(*) FROM SAJET.G_W...
868,018	3,826	226.87	3.82	20.59	19.96	0swgap5h781vw		UPDATE SAJET.G_WO_PICK_LIST SE...
612,541	344	1,780.64	2.70	6.38	8.20	1c82697f4svzp	SajetApserver_ODAC.exe	begin SAJET.SJ_QC_INSP_SN(:TTE...
557,529	2,687	207.49	2.45	10.16	23.44	fvja4ruj5yc6w	SajetApserver_ODAC.exe	begin SAJET.SJ_PACKING_GO(:TTE...
462,283	2,823	163.76	2.03	8.80	13.12	1yfmpc4d0457j	TGS_Server_ODAC.exe	begin SAJET.LITEONIT_SMTTEST_G...
432,495	32,300	13.39	1.90	7.13	14.42	3fufs6k2wt4u2	SajetApserver_ODAC.exe	Insert Into SAJET.G_WO_CUSTOME...
341,510	73,318	4.66	1.50	4.93	6.41	1khtknq18qj38	TGS_Server_ODAC.exe	SELECT WORK_ORDER, WORK_FLAG, ...
311,126	103,671	3.00	1.37	5.79	6.13	4kpkf8n2qah1a	SajetApserver_ODAC.exe	SELECT WO_STATUS, WO_TYPE FROM...
290,087	41,441	7.00	1.28	6.33	6.20	3fcwy3hymmgxh	SajetApserver_ODAC.exe	SELECT SHIFT_ID FROM SAJET.SYS...
281,084	48,940	5.74	1.24	9.41	9.24	65yr7qa3d30mr	SajetApserver_ODAC.exe	SELECT NEXT_PROCESS_ID FROM SA...
270,386	1,469	184.06	1.19	5.27	5.60	frt92rd53nrn5	TGS_Server_ODAC.exe	begin SAJET.LITEONIT_SMTTEST_C...
239,755	885	270.91	1.05	6.04	11.43	6cgyg2dp15rqs	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE_ICT(:...
236,175	83,406	2.83	1.04	5.26	4.87	3qkct39k22ay3	TGS_Server_ODAC.exe	SELECT SPC_ID FROM SAJET.SYS_S...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 34,424
Captured SQL account for 53.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
5,549	30,165	0.18	16.12	15.29	52.89	1v2vfv48zxw31	SajetApserver_ODAC.exe	INSERT INTO SAJET.G_SN_TRAVEL ...
5,040	36,159	0.14	14.64	111.38	146.74	c1q6wm0mcn8rg	TGS_Server_ODAC.exe	begin SAJET.XXSFC_COMMAND_CODE...
4,319	37,900	0.11	12.55	19.87	43.01	8mmsd4pcwrrt1	SajetApserver_ODAC.exe	Insert Into SAJET.G_SN_STATUS ...
2,486	17,815	0.14	7.22	26.25	48.22	0jg3v6fp09wwp	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE_FCT(:...
2,185	7,392	0.30	6.35	61.21	78.59	4xxfcdzfg79yp	SajetApserver_ODAC.exe	begin SAJET.XXSFC_COMMAND_CODE...
2,170	27,155	0.08	6.30	9.00	28.65	4rsnfarj3sv18	SajetApserver_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET P...
2,030	11,463	0.18	5.90	2.00	15.42	9uh89n4h38q0z	TGS_Server_ODAC.exe	SELECT PDLINE_ID, STAGE_ID, PR...
1,967	66,986	0.03	5.71	10.03	20.21	f4wa2482ba90u	TGS_Server_ODAC.exe	INSERT INTO SAJET.G_TEST_RESUL...
1,895	8	236.88	5.50	2.39	9.57	gjwsm7v34yygu	SajetApserver_ODAC.exe	begin SAJET.SJ_QC_TRANSFER(:TQ...
1,608	2,687	0.60	4.67	10.16	23.44	fvja4ruj5yc6w	SajetApserver_ODAC.exe	begin SAJET.SJ_PACKING_GO(:TTE...
1,031	32,300	0.03	3.00	7.13	14.42	3fufs6k2wt4u2	SajetApserver_ODAC.exe	Insert Into SAJET.G_WO_CUSTOME...
924	8,354	0.11	2.68	27.39	33.24	6s67zypjyzzwq	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE(:TSAJ...
807	885	0.91	2.34	6.04	11.43	6cgyg2dp15rqs	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE_ICT(:...
696	571	1.22	2.02	1.79	7.58	b2sn62zwpvd8k	TGS_Server_ODAC.exe	begin SAJET.SJ_PSN_TRANSFER(:T...
636	2,823	0.23	1.85	8.80	13.12	1yfmpc4d0457j	TGS_Server_ODAC.exe	begin SAJET.LITEONIT_SMTTEST_G...
545	3,618	0.15	1.58	0.62	4.58	gsy215jmd1jk8	SajetApserver_ODAC.exe	SELECT SERIAL_NUMBER, WORK_OR...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 2,403,051
Captured SQL account for 59.2% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
431,188	431,188	1.00	3b5c2gdzvqw9v		SELECT SPA.PART_ID FROM SYS_PA...
103,671	103,671	1.00	4kpkf8n2qah1a	SajetApserver_ODAC.exe	SELECT WO_STATUS, WO_TYPE FROM...
83,406	67,065	0.80	3qkct39k22ay3	TGS_Server_ODAC.exe	SELECT SPC_ID FROM SAJET.SYS_S...
73,318	47,084	0.64	1khtknq18qj38	TGS_Server_ODAC.exe	SELECT WORK_ORDER, WORK_FLAG, ...
66,986	66,986	1.00	f4wa2482ba90u	TGS_Server_ODAC.exe	INSERT INTO SAJET.G_TEST_RESUL...
66,809	66,809	1.00	cpd449q0d5f1u	TGS_Server_ODAC.exe	select sysdate from dual
55,437	55,437	1.00	8s29k8ahmsgpk	TGS_Server_ODAC.exe	SELECT COUNT(*) FROM XXSFC_SAM...
48,940	45,930	0.94	65yr7qa3d30mr	SajetApserver_ODAC.exe	SELECT NEXT_PROCESS_ID FROM SA...
41,441	39,176	0.95	3fcwy3hymmgxh	SajetApserver_ODAC.exe	SELECT SHIFT_ID FROM SAJET.SYS...
37,900	37,900	1.00	8mmsd4pcwrrt1	SajetApserver_ODAC.exe	Insert Into SAJET.G_SN_STATUS ...
36,159	36,159	1.00	c1q6wm0mcn8rg	TGS_Server_ODAC.exe	begin SAJET.XXSFC_COMMAND_CODE...
32,300	32,300	1.00	3fufs6k2wt4u2	SajetApserver_ODAC.exe	Insert Into SAJET.G_WO_CUSTOME...
30,165	30,165	1.00	1v2vfv48zxw31	SajetApserver_ODAC.exe	INSERT INTO SAJET.G_SN_TRAVEL ...
28,208	28,128	1.00	f4z7fb7tyawz5	SajetApserver_ODAC.exe	SELECT NEXT_PROCESS_ID FROM SA...
27,155	27,155	1.00	4rsnfarj3sv18	SajetApserver_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET P...
26,857	26,857	1.00	djbd7su62hwd4	SajetApserver_ODAC.exe	SELECT B.WORK_ORDER, B.MODEL_I...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 521,795
Captured SQL account for 67.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
66,809	66,809	12.80	cpd449q0d5f1u	TGS_Server_ODAC.exe	select sysdate from dual
37,900	37,900	7.26	8mmsd4pcwrrt1	SajetApserver_ODAC.exe	Insert Into SAJET.G_SN_STATUS ...
32,300	32,300	6.19	3fufs6k2wt4u2	SajetApserver_ODAC.exe	Insert Into SAJET.G_WO_CUSTOME...
20,493	20,493	3.93	4r3wnh0fn8y08	SajetApserver_ODAC.exe	SELECT SYSDATE FROM DUAL
17,627	17,627	3.38	9rrw9gqg56vg5	SajetApserver_ODAC.exe	Select Param_value from sajet....
12,655	55,437	2.43	8s29k8ahmsgpk	TGS_Server_ODAC.exe	SELECT COUNT(*) FROM XXSFC_SAM...
10,497	10,783	2.01	d01p78wgmw8vw	SajetApserver_ODAC.exe	begin SAJET.SJ_CKRT_ROUTE(:TER...
7,754	7,754	1.49	7hrdx2x8yag1p	SajetApserver_ODAC.exe	SELECT NVL(SST.PART_NO, 'N/A')...
7,716	7,716	1.48	1vcd4qt23hddz	SajetApserver_ODAC.exe	SELECT SERIAL_NUMBER FROM SAJE...
7,392	7,392	1.42	263t0pad9wmyy	SajetApserver_ODAC.exe	SELECT EMP_NO FROM SAJET.SYS_E...
7,380	7,380	1.41	4sx0725zgmxdm	SajetApserver_ODAC.exe	SELECT END_PROCESS_ID, WO_TYPE...
7,379	7,379	1.41	cfzjs2hcrw6uk	SajetApserver_ODAC.exe	SELECT PARAM_VALUE From SAJET....
7,374	7,392	1.41	4xxfcdzfg79yp	SajetApserver_ODAC.exe	begin SAJET.XXSFC_COMMAND_CODE...
6,741	36,159	1.29	c1q6wm0mcn8rg	TGS_Server_ODAC.exe	begin SAJET.XXSFC_COMMAND_CODE...
6,409	6,409	1.23	338txu6dx9j86	SajetApserver_ODAC.exe	SELECT WORK_ORDER , MODEL_ID F...
6,409	6,409	1.23	a2mx3y69x7g87	SajetApserver_ODAC.exe	SELECT NVL(SUM(ITEM_COUNT), 0...
6,409	6,409	1.23	cz03w7zkvpwcd	SajetApserver_ODAC.exe	SELECT NVL(SUM(ITEM_COUNT), 0...
6,409	6,409	1.23	fsj3w38cj2asb	SajetApserver_ODAC.exe	SELECT PROCESS_ID FROM SAJET....
5,415	5,415	1.04	78n1a9j26hsmj	SajetApserver_ODAC.exe	select parame_value from SAJET...
5,410	5,410	1.04	gf5zutqgpkh6y	SajetApserver_ODAC.exe	SELECT SERIAL_NUMBER, WORK_ORD...
5,408	5,408	1.04	brc7a8kf81mu2	SajetApserver_ODAC.exe	SELECT * FROM SAJET.SYS_BASE ...
5,408	5,408	1.04	d1v56jd70qfk8	SajetApserver_ODAC.exe	SELECT SSD.DEPT_NAME FROM SAJ...
5,278	8,354	1.01	6s67zypjyzzwq	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE(:TSAJ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0jg3v6fp09wwp begin SAJET.COMMAND_CODE_FCT(:TSAJET1, :TSAJET2, :TSAJET3, :TSAJET4, :TSAJET5, :TSAJET4TON, :TSAJET5TON, :TSAJET6TON, :TLINEID, :TSTAGEID, :TPROCESSID, :TTERMINALID, :TNOW, :TREV, :TRES, :TNEXTPROC); end;

0swgap5h781vw UPDATE SAJET.G_WO_PICK_LIST SET REQUEST_QTY = :B4 , UNIT = :B3 WHERE WORK_ORDER = :B2 AND PART_ID = XXSFC_DOWNLOAD_WRO_PKG.GET_PART_ID(:B1 ) AND ROWNUM = 1

1c82697f4svzp begin SAJET.SJ_QC_INSP_SN(:TTERMINALID, :TQCLOTNO, :TEMPID, :TPALLETNO, :TCARTONNO, :TCURRENTSTATUS, :TROUTEID, :TSN, :TQCCNT, :TSAMPLING_TYPE, :TSAMPLING_LEVEL, :TDEFECTDATA, :TCHECKPART, :TITEMDATA, :TRES); end;

1khtknq18qj38 SELECT WORK_ORDER, WORK_FLAG, SERIAL_NUMBER FROM SAJET.G_SN_STATUS WHERE SERIAL_NUMBER = :B1 AND ROWNUM = 1

1p9y3cfg68da1 Select EMP_NO, EMP_NAME, PASSWD, ENABLED, NVL(TO_CHAR(QUIT_DATE, 'yyyy/mm/dd'), 'N/A') QUIT_DATE From SAJET.SYS_EMP Where Upper(EMP_ID) = :EMP_ID

1v2vfv48zxw31 INSERT INTO SAJET.G_SN_TRAVEL SELECT * FROM SAJET.G_SN_STATUS WHERE SERIAL_NUMBER = :B1 AND ROWNUM = 1

1vcd4qt23hddz SELECT SERIAL_NUMBER FROM SAJET.G_SN_STATUS WHERE SERIAL_NUMBER=:sSN AND ROWNUM=1

1yfmpc4d0457j begin SAJET.LITEONIT_SMTTEST_GO(:TTERMINALID, :TNOW, :TEMP, :PSN, :TTDATA, :TRES, :TNEXTPROC); end;

263t0pad9wmyy SELECT EMP_NO FROM SAJET.SYS_EMP WHERE EMP_ID=:EmpID AND ROWNUM=1

338txu6dx9j86 SELECT WORK_ORDER , MODEL_ID FROM SAJET.G_WO_BASE WHERE WORK_ORDER = :sSNWO AND ROWNUM = 1

3b5c2gdzvqw9v SELECT SPA.PART_ID FROM SYS_PART SPA WHERE SPA.PART_NO = :B1 AND ROWNUM = 1

3fcwy3hymmgxh SELECT SHIFT_ID FROM SAJET.SYS_PDLINE_SHIFT_BASE WHERE PDLINE_ID = :B1 AND ACTIVE_FLAG = 'Y'

3fufs6k2wt4u2 Insert Into SAJET.G_WO_CUSTOMER_SN(WORK_ORDER, CUSTOMER_SN, UPDATE_USERID ) Values (:WORK_ORDER, :LABEL_NO, :UPDATE_USERID)

3qkct39k22ay3 SELECT SPC_ID FROM SAJET.SYS_SPC WHERE SPC_ITEM = :B2 AND TP_ID = :B1 AND ROWNUM=1

4kpkf8n2qah1a SELECT WO_STATUS, WO_TYPE FROM SAJET.G_WO_BASE WHERE WORK_ORDER = :B1 AND ROWNUM = 1

4r3wnh0fn8y08 SELECT SYSDATE FROM DUAL

4rsnfarj3sv18 UPDATE SAJET.G_SN_STATUS SET PDLINE_ID=:B11 , STAGE_ID=:B10 , PROCESS_ID=:B9 , TERMINAL_ID=:B8 , NEXT_PROCESS=0, CURRENT_STATUS=:B7 , IN_PROCESS_TIME=OUT_PROCESS_TIME, OUT_PROCESS_TIME=:B6 , IN_PDLINE_TIME = :B5 , OUT_PDLINE_TIME = :B4 , EMP_ID=:B3 , WIP_PROCESS=:B2 WHERE SERIAL_NUMBER = :B1 AND ROWNUM = 1

4sx0725zgmxdm SELECT END_PROCESS_ID, WO_TYPE FROM SAJET.G_WO_BASE WHERE WORK_ORDER=:sW AND ROWNUM=1

4xxfcdzfg79yp begin SAJET.XXSFC_COMMAND_CODE(:TSAJET1, :TSAJET2, :TSAJET3, :TSAJET4, :TSAJET5, :TSAJET4TON, :TSAJET5TON, :TSAJET6TON, :TDRIVEID, :TLINEID, :TSTAGEID, :TPROCESSID, :TTERMINALID, :TNOW, :TRES, :TNEXTPROC, :TCOMMAND); end;

65yr7qa3d30mr SELECT NEXT_PROCESS_ID FROM SAJET.SYS_ROUTE_DETAIL WHERE RESULT = :B4 AND ROUTE_ID = :B3 AND PROCESS_ID = :B2 AND NEXT_PROCESS_ID = :B1 AND ROWNUM = 1

6cgyg2dp15rqs begin SAJET.COMMAND_CODE_ICT(:TSAJET1, :TSAJET2, :TSAJET3, :TSAJET4, :TSAJET5, :TSAJET4TON, :TSAJET5TON, :TSAJET6TON, :TLINEID, :TSTAGEID, :TPROCESSID, :TTERMINALID, :TNOW, :TREV, :TRES, :TNEXTPROC); end;

6dpw7ja9hyzqk SELECT COUNT(*) FROM SAJET.G_WO_PICK_LIST WHERE WORK_ORDER = :B2 AND PART_ID = XXSFC_DOWNLOAD_WRO_PKG.GET_PART_ID(:B1 ) AND ROWNUM = 1

6s67zypjyzzwq begin SAJET.COMMAND_CODE(:TSAJET1, :TSAJET2, :TSAJET3, :TSAJET4, :TSAJET5, :TSAJET4TON, :TSAJET5TON, :TSAJET6TON, :TLINEID, :TSTAGEID, :TPROCESSID, :TTERMINALID, :TNOW, :TREV, :TRES, :TNEXTPROC); end;

6xf2sz3zbgt3k SELECT PARAME_VALUE FROM SAJET.SYS_MODULE_PARAM WHERE MODULE_NAME = 'CDM SFCS' AND FUNCTION_NAME = 'Work Station Configuration' AND PARAME_ITEM = 'AE Handover ProcessCount' AND PARAME_NAME = :B1

78n1a9j26hsmj select parame_value from SAJET.SYS_MODULE_PARAM where PARAME_ITEM='Check Repaired SN'and parame_name=:Terminal

7d4mkdpgcsmf5 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN XXSFC_AUTODOWNLOAD_WO_WRO; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

7hrdx2x8yag1p SELECT NVL(SST.PART_NO, 'N/A') PART_NO, NVL(SGB.WO_TYPE, 'N/A') WO_TYPE, NVL(SSR.ROUTE_NAME, 'N/A') ROUTE_NAME, NVL(SSP.PDLINE_NAME, 'N/A') PDLINE_NAME, NVl(SGB.TARGET_QTY, 0) TARGET_QTY, NVL(SGB.START_PROCESS_ID, 0) START_PROCESS_ID, NVL(SGB.WO_RULE, 'N/A') WO_RULE, DECODE(SGB.WO_STATUS, 0, 'INITIAL', 1, 'PREPARE', 2, 'RELEASE', 3, 'WIP', 4, 'HOLD', 5, 'CANCEL', 6, 'COMPLETE') WO_STATUS FROM SAJET.G_WO_BASE SGB, SAJET.SYS_ROUTE SSR, SAJET.SYS_PDLINE SSP, SAJET.SYS_PART SST, SAJET.SYS_FACTORY SSF WHERE SGB.ROUTE_ID = SSR.ROUTE_ID(+) AND SGB.DEFAULT_PDLINE_ID = SSP.PDLINE_ID(+) AND SGB.MODEL_ID = SST.PART_ID(+) AND SSP.FACTORY_ID=SSF.FACTORY_ID AND SSP.ENABLED='Y' AND SGB.WORK_ORDER = :sWo AND SSF.FACTORY_ID=:sFc AND Rownum = 1

8mmsd4pcwrrt1 Insert Into SAJET.G_SN_STATUS (WORK_ORDER, MODEL_ID, SERIAL_NUMBER, ROUTE_ID, Version, EMP_ID) Values (:WORK_ORDER, :MODEL_ID, :SERIAL_NUMBER, :ROUTE_ID, :Version, :EMP_ID)

8s29k8ahmsgpk SELECT COUNT(*) FROM XXSFC_SAMPLE_SETUP WHERE SN = :B1 AND ENABLED = 'Y' AND ROWNUM = 1

9rrw9gqg56vg5 Select Param_value from sajet.sys_base where param_name =:Parameter

9uh89n4h38q0z SELECT PDLINE_ID, STAGE_ID, PROCESS_ID, OUT_PROCESS_TIME, CURRENT_STATUS FROM SAJET.G_SN_TRAVEL WHERE SERIAL_NUMBER = :B3 AND WORK_ORDER = :B2 AND MODEL_ID = :B1 ORDER BY OUT_PROCESS_TIME DESC

a2mx3y69x7g87 SELECT NVL(SUM(ITEM_COUNT), 0) C_KPCNTB FROM (SELECT ITEM_GROUP, ITEM_COUNT FROM SAJET.G_WO_BOM WHERE WORK_ORDER =:s_WO AND PART_ID =:s_PartID AND PROCESS_ID=:s_Process AND ITEM_GROUP = 0 )

b2sn62zwpvd8k begin SAJET.SJ_PSN_TRANSFER(:TTERMINALID, :PSN, :TDEFECT, :TNOW, :TEMP, :TRES, :TNEXTPROC); end;

bggamr1xt3w3j SELECT event#, sql_id, sql_plan_hash_value, sql_opcode, session_id, session_serial#, module, action, client_id, DECODE(wait_time, 0, 'W', 'C'), 1, time_waited, service_hash, user_id, program, sample_time, p1, p2, p3, current_file#, current_obj#, current_block#, qc_session_id, qc_instance_id, plsql_object_id, plsql_subprogram_id FROM v$active_session_history WHERE sample_time > :1 AND sample_time <= :2

bphcr26f123xf SELECT WE.WIP_ENTITY_NAME, XXSFC_DOWNLOAD_WRO_PKG.GET_ITEM_NO(WRO.INVENTORY_ITEM_ID) INVENTORY_ITEM, SUM(WRO.QUANTITY_PER_ASSEMBLY) QUANTITY_PER_ASSEMBLY, SUM(WRO.REQUIRED_QUANTITY) REQUIRED_QUANTITY FROM WIP_ENTITIES@ERP_PROD WE, WIP_REQUIREMENT_OPERATIONS@ERP_PROD WRO, WIP_DISCRETE_JOBS@ERP_PROD WDJ WHERE WE.ORGANIZATION_ID = WRO.ORGANIZATION_ID AND WE.ORGANIZATION_ID = WDJ.ORGANIZATION_ID AND WE.ORGANIZATION_ID IN (282, 1041, 1743, 1704, 2123, 2644, 2763, 2923) AND WE.WIP_ENTITY_ID = WRO.WIP_ENTITY_ID AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID AND (WDJ.JOB_TYPE = 1 OR (WDJ.JOB_TYPE = 3 AND WDJ.BOM_REFERENCE_ID IS NOT NULL)) AND WRO.OPERATION_SEQ_NUM > 0 AND WE.WIP_ENTITY_ID = :B1 GROUP BY WE.WIP_ENTITY_NAME, WRO.INVENTORY_ITEM_ID

brc7a8kf81mu2 SELECT * FROM SAJET.SYS_BASE WHERE PARAM_NAME=:s_Para AND PARAM_VALUE=:s_Dept AND ROWNUM=1

c1q6wm0mcn8rg begin SAJET.XXSFC_COMMAND_CODE(:TSAJET1, :TSAJET2, :TSAJET3, :TSAJET4, :TSAJET5, :TSAJET4TON, :TSAJET5TON, :TSAJET6TON, :TDRIVEID, :TLINEID, :TSTAGEID, :TPROCESSID, :TTERMINALID, :TNOW, :TRES, :TNEXTPROC, :TCOMMAND); end;

cfzjs2hcrw6uk SELECT PARAM_VALUE From SAJET.SYS_BASE Where PARAM_NAME='CHECK_MI_QTY' AND ROWNUM=1

cpd449q0d5f1u select sysdate from dual

cz03w7zkvpwcd SELECT NVL(SUM(ITEM_COUNT), 0) C_KPCNTA FROM (SELECT ITEM_GROUP, ITEM_COUNT FROM SAJET.G_WO_BOM WHERE WORK_ORDER =:sWO AND PART_ID =:sPARTID AND PROCESS_ID =:sProcess AND ITEM_GROUP <> 0 GROUP BY ITEM_GROUP, ITEM_COUNT )

d01p78wgmw8vw begin SAJET.SJ_CKRT_ROUTE(:TERMINALID, :TSN, :TRES); end;

d1v56jd70qfk8 SELECT SSD.DEPT_NAME FROM SAJET.SYS_PDLINE SSP, SAJET.SYS_DEPT SSD WHERE SSP.DEPT_ID=SSD.DEPT_ID AND SSP.FACTORY_ID=SSD.FACTORY_ID AND SSP.PDLINE_ID=:s_Lid AND ROWNUM=1

djbd7su62hwd4 SELECT B.WORK_ORDER, B.MODEL_ID, IN_PDLINE_TIME, OUT_PDLINE_TIME FROM SAJET.G_SN_STATUS B WHERE B.SERIAL_NUMBER = :B1 AND ROWNUM = 1

f262pwx3ykaru SELECT MSI.SEGMENT1 FROM MTL_SYSTEM_ITEMS_B@ERP_PROD MSI WHERE MSI.ORGANIZATION_ID = 45 AND MSI.INVENTORY_ITEM_ID = :B1

f4wa2482ba90u INSERT INTO SAJET.G_TEST_RESULT (TEST_ID, SERIAL_NUMBER, UPDATE_TIME, TEST_RESULT, PDLINE_ID, STAGE_ID, PROCESS_ID, TERMINAL_ID, WORK_ORDER, PART_ID, EMP_ID) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 , 0)

f4z7fb7tyawz5 SELECT NEXT_PROCESS_ID FROM SAJET.SYS_ROUTE_DETAIL WHERE ROUTE_ID = :B3 AND PROCESS_ID = :B2 AND RESULT = :B1 AND NECESSARY = 'Y' AND ENABLED = 'Y' AND ROWNUM = 1

frt92rd53nrn5 begin SAJET.LITEONIT_SMTTEST_CHK_MSL_TOP_Q(:PSN, :TTEMPDATA, :TLINEID, :TPROCESSID, :TTDATA, :TTEMPEC, :TLC, :TTEMPLC, :TEC, :TRES, :TTRES); end;

fsj3w38cj2asb SELECT PROCESS_ID FROM SAJET.SYS_PROCESS WHERE PROCESS_NAME=:sProcess AND ENABLED='Y'

fvja4ruj5yc6w begin SAJET.SJ_PACKING_GO(:TTERMINALID, :TSN, :TNOW, :TRES, :TEMP, :PACKACTION, :PALLETNO, :CARTONNO, :BOXNO, :CUSTOMERSN); end;

gf5zutqgpkh6y SELECT SERIAL_NUMBER, WORK_ORDER FROM SAJET.G_SN_KEYPARTS WHERE ITEM_PART_SN=:sMac

gjwsm7v34yygu begin SAJET.SJ_QC_TRANSFER(:TQCNO, :TTERMINALID, :TEMPID, :TQCCNT, :TQCRESULT, :TSAMPLINGID, :TPALLETNODATA, :TSPLITSNDATA, :TPASSCLEAR, :TREJECTCLEAR, :TLOTMEMO, :TSAMPLINGLEVEL, :TRES); end;

gsy215jmd1jk8 SELECT SERIAL_NUMBER, WORK_ORDER FROM SAJET.G_SN_STATUS WHERE SERIAL_NUMBER=:sSN

SQL Id	SQL Text
0jg3v6fp09wwp	begin SAJET.COMMAND_CODE_FCT(:TSAJET1, :TSAJET2, :TSAJET3, :TSAJET4, :TSAJET5, :TSAJET4TON, :TSAJET5TON, :TSAJET6TON, :TLINEID, :TSTAGEID, :TPROCESSID, :TTERMINALID, :TNOW, :TREV, :TRES, :TNEXTPROC); end;
0swgap5h781vw	UPDATE SAJET.G_WO_PICK_LIST SET REQUEST_QTY = :B4 , UNIT = :B3 WHERE WORK_ORDER = :B2 AND PART_ID = XXSFC_DOWNLOAD_WRO_PKG.GET_PART_ID(:B1 ) AND ROWNUM = 1
1c82697f4svzp	begin SAJET.SJ_QC_INSP_SN(:TTERMINALID, :TQCLOTNO, :TEMPID, :TPALLETNO, :TCARTONNO, :TCURRENTSTATUS, :TROUTEID, :TSN, :TQCCNT, :TSAMPLING_TYPE, :TSAMPLING_LEVEL, :TDEFECTDATA, :TCHECKPART, :TITEMDATA, :TRES); end;
1khtknq18qj38	SELECT WORK_ORDER, WORK_FLAG, SERIAL_NUMBER FROM SAJET.G_SN_STATUS WHERE SERIAL_NUMBER = :B1 AND ROWNUM = 1
1p9y3cfg68da1	Select EMP_NO, EMP_NAME, PASSWD, ENABLED, NVL(TO_CHAR(QUIT_DATE, 'yyyy/mm/dd'), 'N/A') QUIT_DATE From SAJET.SYS_EMP Where Upper(EMP_ID) = :EMP_ID
1v2vfv48zxw31	INSERT INTO SAJET.G_SN_TRAVEL SELECT * FROM SAJET.G_SN_STATUS WHERE SERIAL_NUMBER = :B1 AND ROWNUM = 1
1vcd4qt23hddz	SELECT SERIAL_NUMBER FROM SAJET.G_SN_STATUS WHERE SERIAL_NUMBER=:sSN AND ROWNUM=1
1yfmpc4d0457j	begin SAJET.LITEONIT_SMTTEST_GO(:TTERMINALID, :TNOW, :TEMP, :PSN, :TTDATA, :TRES, :TNEXTPROC); end;
263t0pad9wmyy	SELECT EMP_NO FROM SAJET.SYS_EMP WHERE EMP_ID=:EmpID AND ROWNUM=1
338txu6dx9j86	SELECT WORK_ORDER , MODEL_ID FROM SAJET.G_WO_BASE WHERE WORK_ORDER = :sSNWO AND ROWNUM = 1
3b5c2gdzvqw9v	SELECT SPA.PART_ID FROM SYS_PART SPA WHERE SPA.PART_NO = :B1 AND ROWNUM = 1
3fcwy3hymmgxh	SELECT SHIFT_ID FROM SAJET.SYS_PDLINE_SHIFT_BASE WHERE PDLINE_ID = :B1 AND ACTIVE_FLAG = 'Y'
3fufs6k2wt4u2	Insert Into SAJET.G_WO_CUSTOMER_SN(WORK_ORDER, CUSTOMER_SN, UPDATE_USERID ) Values (:WORK_ORDER, :LABEL_NO, :UPDATE_USERID)
3qkct39k22ay3	SELECT SPC_ID FROM SAJET.SYS_SPC WHERE SPC_ITEM = :B2 AND TP_ID = :B1 AND ROWNUM=1
4kpkf8n2qah1a	SELECT WO_STATUS, WO_TYPE FROM SAJET.G_WO_BASE WHERE WORK_ORDER = :B1 AND ROWNUM = 1
4r3wnh0fn8y08	SELECT SYSDATE FROM DUAL
4rsnfarj3sv18	UPDATE SAJET.G_SN_STATUS SET PDLINE_ID=:B11 , STAGE_ID=:B10 , PROCESS_ID=:B9 , TERMINAL_ID=:B8 , NEXT_PROCESS=0, CURRENT_STATUS=:B7 , IN_PROCESS_TIME=OUT_PROCESS_TIME, OUT_PROCESS_TIME=:B6 , IN_PDLINE_TIME = :B5 , OUT_PDLINE_TIME = :B4 , EMP_ID=:B3 , WIP_PROCESS=:B2 WHERE SERIAL_NUMBER = :B1 AND ROWNUM = 1
4sx0725zgmxdm	SELECT END_PROCESS_ID, WO_TYPE FROM SAJET.G_WO_BASE WHERE WORK_ORDER=:sW AND ROWNUM=1
4xxfcdzfg79yp	begin SAJET.XXSFC_COMMAND_CODE(:TSAJET1, :TSAJET2, :TSAJET3, :TSAJET4, :TSAJET5, :TSAJET4TON, :TSAJET5TON, :TSAJET6TON, :TDRIVEID, :TLINEID, :TSTAGEID, :TPROCESSID, :TTERMINALID, :TNOW, :TRES, :TNEXTPROC, :TCOMMAND); end;
65yr7qa3d30mr	SELECT NEXT_PROCESS_ID FROM SAJET.SYS_ROUTE_DETAIL WHERE RESULT = :B4 AND ROUTE_ID = :B3 AND PROCESS_ID = :B2 AND NEXT_PROCESS_ID = :B1 AND ROWNUM = 1
6cgyg2dp15rqs	begin SAJET.COMMAND_CODE_ICT(:TSAJET1, :TSAJET2, :TSAJET3, :TSAJET4, :TSAJET5, :TSAJET4TON, :TSAJET5TON, :TSAJET6TON, :TLINEID, :TSTAGEID, :TPROCESSID, :TTERMINALID, :TNOW, :TREV, :TRES, :TNEXTPROC); end;
6dpw7ja9hyzqk	SELECT COUNT(*) FROM SAJET.G_WO_PICK_LIST WHERE WORK_ORDER = :B2 AND PART_ID = XXSFC_DOWNLOAD_WRO_PKG.GET_PART_ID(:B1 ) AND ROWNUM = 1
6s67zypjyzzwq	begin SAJET.COMMAND_CODE(:TSAJET1, :TSAJET2, :TSAJET3, :TSAJET4, :TSAJET5, :TSAJET4TON, :TSAJET5TON, :TSAJET6TON, :TLINEID, :TSTAGEID, :TPROCESSID, :TTERMINALID, :TNOW, :TREV, :TRES, :TNEXTPROC); end;
6xf2sz3zbgt3k	SELECT PARAME_VALUE FROM SAJET.SYS_MODULE_PARAM WHERE MODULE_NAME = 'CDM SFCS' AND FUNCTION_NAME = 'Work Station Configuration' AND PARAME_ITEM = 'AE Handover ProcessCount' AND PARAME_NAME = :B1
78n1a9j26hsmj	select parame_value from SAJET.SYS_MODULE_PARAM where PARAME_ITEM='Check Repaired SN'and parame_name=:Terminal
7d4mkdpgcsmf5	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN XXSFC_AUTODOWNLOAD_WO_WRO; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
7hrdx2x8yag1p	SELECT NVL(SST.PART_NO, 'N/A') PART_NO, NVL(SGB.WO_TYPE, 'N/A') WO_TYPE, NVL(SSR.ROUTE_NAME, 'N/A') ROUTE_NAME, NVL(SSP.PDLINE_NAME, 'N/A') PDLINE_NAME, NVl(SGB.TARGET_QTY, 0) TARGET_QTY, NVL(SGB.START_PROCESS_ID, 0) START_PROCESS_ID, NVL(SGB.WO_RULE, 'N/A') WO_RULE, DECODE(SGB.WO_STATUS, 0, 'INITIAL', 1, 'PREPARE', 2, 'RELEASE', 3, 'WIP', 4, 'HOLD', 5, 'CANCEL', 6, 'COMPLETE') WO_STATUS FROM SAJET.G_WO_BASE SGB, SAJET.SYS_ROUTE SSR, SAJET.SYS_PDLINE SSP, SAJET.SYS_PART SST, SAJET.SYS_FACTORY SSF WHERE SGB.ROUTE_ID = SSR.ROUTE_ID(+) AND SGB.DEFAULT_PDLINE_ID = SSP.PDLINE_ID(+) AND SGB.MODEL_ID = SST.PART_ID(+) AND SSP.FACTORY_ID=SSF.FACTORY_ID AND SSP.ENABLED='Y' AND SGB.WORK_ORDER = :sWo AND SSF.FACTORY_ID=:sFc AND Rownum = 1
8mmsd4pcwrrt1	Insert Into SAJET.G_SN_STATUS (WORK_ORDER, MODEL_ID, SERIAL_NUMBER, ROUTE_ID, Version, EMP_ID) Values (:WORK_ORDER, :MODEL_ID, :SERIAL_NUMBER, :ROUTE_ID, :Version, :EMP_ID)
8s29k8ahmsgpk	SELECT COUNT(*) FROM XXSFC_SAMPLE_SETUP WHERE SN = :B1 AND ENABLED = 'Y' AND ROWNUM = 1
9rrw9gqg56vg5	Select Param_value from sajet.sys_base where param_name =:Parameter
9uh89n4h38q0z	SELECT PDLINE_ID, STAGE_ID, PROCESS_ID, OUT_PROCESS_TIME, CURRENT_STATUS FROM SAJET.G_SN_TRAVEL WHERE SERIAL_NUMBER = :B3 AND WORK_ORDER = :B2 AND MODEL_ID = :B1 ORDER BY OUT_PROCESS_TIME DESC
a2mx3y69x7g87	SELECT NVL(SUM(ITEM_COUNT), 0) C_KPCNTB FROM (SELECT ITEM_GROUP, ITEM_COUNT FROM SAJET.G_WO_BOM WHERE WORK_ORDER =:s_WO AND PART_ID =:s_PartID AND PROCESS_ID=:s_Process AND ITEM_GROUP = 0 )
b2sn62zwpvd8k	begin SAJET.SJ_PSN_TRANSFER(:TTERMINALID, :PSN, :TDEFECT, :TNOW, :TEMP, :TRES, :TNEXTPROC); end;
bggamr1xt3w3j	SELECT event#, sql_id, sql_plan_hash_value, sql_opcode, session_id, session_serial#, module, action, client_id, DECODE(wait_time, 0, 'W', 'C'), 1, time_waited, service_hash, user_id, program, sample_time, p1, p2, p3, current_file#, current_obj#, current_block#, qc_session_id, qc_instance_id, plsql_object_id, plsql_subprogram_id FROM v$active_session_history WHERE sample_time > :1 AND sample_time <= :2
bphcr26f123xf	SELECT WE.WIP_ENTITY_NAME, XXSFC_DOWNLOAD_WRO_PKG.GET_ITEM_NO(WRO.INVENTORY_ITEM_ID) INVENTORY_ITEM, SUM(WRO.QUANTITY_PER_ASSEMBLY) QUANTITY_PER_ASSEMBLY, SUM(WRO.REQUIRED_QUANTITY) REQUIRED_QUANTITY FROM WIP_ENTITIES@ERP_PROD WE, WIP_REQUIREMENT_OPERATIONS@ERP_PROD WRO, WIP_DISCRETE_JOBS@ERP_PROD WDJ WHERE WE.ORGANIZATION_ID = WRO.ORGANIZATION_ID AND WE.ORGANIZATION_ID = WDJ.ORGANIZATION_ID AND WE.ORGANIZATION_ID IN (282, 1041, 1743, 1704, 2123, 2644, 2763, 2923) AND WE.WIP_ENTITY_ID = WRO.WIP_ENTITY_ID AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID AND (WDJ.JOB_TYPE = 1 OR (WDJ.JOB_TYPE = 3 AND WDJ.BOM_REFERENCE_ID IS NOT NULL)) AND WRO.OPERATION_SEQ_NUM > 0 AND WE.WIP_ENTITY_ID = :B1 GROUP BY WE.WIP_ENTITY_NAME, WRO.INVENTORY_ITEM_ID
brc7a8kf81mu2	SELECT * FROM SAJET.SYS_BASE WHERE PARAM_NAME=:s_Para AND PARAM_VALUE=:s_Dept AND ROWNUM=1
c1q6wm0mcn8rg	begin SAJET.XXSFC_COMMAND_CODE(:TSAJET1, :TSAJET2, :TSAJET3, :TSAJET4, :TSAJET5, :TSAJET4TON, :TSAJET5TON, :TSAJET6TON, :TDRIVEID, :TLINEID, :TSTAGEID, :TPROCESSID, :TTERMINALID, :TNOW, :TRES, :TNEXTPROC, :TCOMMAND); end;
cfzjs2hcrw6uk	SELECT PARAM_VALUE From SAJET.SYS_BASE Where PARAM_NAME='CHECK_MI_QTY' AND ROWNUM=1
cpd449q0d5f1u	select sysdate from dual
cz03w7zkvpwcd	SELECT NVL(SUM(ITEM_COUNT), 0) C_KPCNTA FROM (SELECT ITEM_GROUP, ITEM_COUNT FROM SAJET.G_WO_BOM WHERE WORK_ORDER =:sWO AND PART_ID =:sPARTID AND PROCESS_ID =:sProcess AND ITEM_GROUP <> 0 GROUP BY ITEM_GROUP, ITEM_COUNT )
d01p78wgmw8vw	begin SAJET.SJ_CKRT_ROUTE(:TERMINALID, :TSN, :TRES); end;
d1v56jd70qfk8	SELECT SSD.DEPT_NAME FROM SAJET.SYS_PDLINE SSP, SAJET.SYS_DEPT SSD WHERE SSP.DEPT_ID=SSD.DEPT_ID AND SSP.FACTORY_ID=SSD.FACTORY_ID AND SSP.PDLINE_ID=:s_Lid AND ROWNUM=1
djbd7su62hwd4	SELECT B.WORK_ORDER, B.MODEL_ID, IN_PDLINE_TIME, OUT_PDLINE_TIME FROM SAJET.G_SN_STATUS B WHERE B.SERIAL_NUMBER = :B1 AND ROWNUM = 1
f262pwx3ykaru	SELECT MSI.SEGMENT1 FROM MTL_SYSTEM_ITEMS_B@ERP_PROD MSI WHERE MSI.ORGANIZATION_ID = 45 AND MSI.INVENTORY_ITEM_ID = :B1
f4wa2482ba90u	INSERT INTO SAJET.G_TEST_RESULT (TEST_ID, SERIAL_NUMBER, UPDATE_TIME, TEST_RESULT, PDLINE_ID, STAGE_ID, PROCESS_ID, TERMINAL_ID, WORK_ORDER, PART_ID, EMP_ID) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 , 0)
f4z7fb7tyawz5	SELECT NEXT_PROCESS_ID FROM SAJET.SYS_ROUTE_DETAIL WHERE ROUTE_ID = :B3 AND PROCESS_ID = :B2 AND RESULT = :B1 AND NECESSARY = 'Y' AND ENABLED = 'Y' AND ROWNUM = 1
frt92rd53nrn5	begin SAJET.LITEONIT_SMTTEST_CHK_MSL_TOP_Q(:PSN, :TTEMPDATA, :TLINEID, :TPROCESSID, :TTDATA, :TTEMPEC, :TLC, :TTEMPLC, :TEC, :TRES, :TTRES); end;
fsj3w38cj2asb	SELECT PROCESS_ID FROM SAJET.SYS_PROCESS WHERE PROCESS_NAME=:sProcess AND ENABLED='Y'
fvja4ruj5yc6w	begin SAJET.SJ_PACKING_GO(:TTERMINALID, :TSN, :TNOW, :TRES, :TEMP, :PACKACTION, :PALLETNO, :CARTONNO, :BOXNO, :CUSTOMERSN); end;
gf5zutqgpkh6y	SELECT SERIAL_NUMBER, WORK_ORDER FROM SAJET.G_SN_KEYPARTS WHERE ITEM_PART_SN=:sMac
gjwsm7v34yygu	begin SAJET.SJ_QC_TRANSFER(:TQCNO, :TTERMINALID, :TEMPID, :TQCCNT, :TQCRESULT, :TSAMPLINGID, :TPALLETNODATA, :TSPLITSNDATA, :TPASSCLEAR, :TREJECTCLEAR, :TLOTMEMO, :TSAMPLINGLEVEL, :TRES); end;
gsy215jmd1jk8	SELECT SERIAL_NUMBER, WORK_ORDER FROM SAJET.G_SN_STATUS WHERE SERIAL_NUMBER=:sSN

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	55,140	15.26	0.44
CPU used when call started	50,042	13.85	0.40
CR blocks created	410	0.11	0.00
Cached Commit SCN referenced	4,066	1.13	0.03
Commit SCN cached	6	0.00	0.00
DB time	1,560,387	431.89	12.37
DBWR checkpoint buffers written	133,585	36.97	1.06
DBWR checkpoints	5	0.00	0.00
DBWR object drop buffers written	6	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 transaction table writes	476	0.13	0.00
DBWR undo block writes	41,614	11.52	0.33
IMU CR rollbacks	143	0.04	0.00
IMU Flushes	19,576	5.42	0.16
IMU Redo allocation size	156,782,192	43,395.13	1,243.32
IMU commits	106,271	29.41	0.84
IMU contention	700	0.19	0.01
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	1,347	0.37	0.01
IMU recursive-transaction flush	766	0.21	0.01
IMU undo allocation size	949,948,840	262,932.65	7,533.30
IMU- failed to get a private strand	1,347	0.37	0.01
RowCR - row contention	0	0.00	0.00
RowCR attempts	100,798	27.90	0.80
RowCR hits	96,824	26.80	0.77
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	7	0.00	0.00
SQL*Net roundtrips to/from client	1,288,463	356.63	10.22
SQL*Net roundtrips to/from dblink	9,198	2.55	0.07
active txn count during cleanout	3,034	0.84	0.02
application wait time	130	0.04	0.00
background checkpoints completed	2	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	11,560	3.20	0.09
branch node splits	15	0.00	0.00
buffer is not pinned count	5,943,203	1,645.00	47.13
buffer is pinned count	9,854,104	2,727.48	78.15
bytes received via SQL*Net from client	267,697,290	74,094.89	2,122.90
bytes received via SQL*Net from dblink	1,481,654	410.10	11.75
bytes sent via SQL*Net to client	1,507,202,612	417,172.75	11,952.44
bytes sent via SQL*Net to dblink	2,048,476	566.99	16.24
calls to get snapshot scn: kcmgss	2,891,798	800.41	22.93
calls to kcmgas	165,621	45.84	1.31
calls to kcmgcs	34,987	9.68	0.28
change write time	1,279	0.35	0.01
cleanout - number of ktugct calls	11,426	3.16	0.09
cleanouts and rollbacks - consistent read gets	279	0.08	0.00
cleanouts only - consistent read gets	487	0.13	0.00
cluster key scan block gets	10,728	2.97	0.09
cluster key scans	4,644	1.29	0.04
commit batch performed	54	0.01	0.00
commit batch requested	54	0.01	0.00
commit batch/immediate performed	207	0.06	0.00
commit batch/immediate requested	207	0.06	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	1,513	0.42	0.01
commit cleanout failures: cannot pin	336	0.09	0.00
commit cleanouts	1,580,933	437.58	12.54
commit cleanouts successfully completed	1,579,084	437.07	12.52
commit immediate performed	153	0.04	0.00
commit immediate requested	153	0.04	0.00
commit txn count during cleanout	95,135	26.33	0.75
concurrency wait time	164	0.05	0.00
consistent changes	532	0.15	0.00
consistent gets	15,590,588	4,315.26	123.64
consistent gets - examination	7,203,462	1,993.82	57.12
consistent gets direct	0	0.00	0.00
consistent gets from cache	15,590,588	4,315.26	123.64
current blocks converted for CR	0	0.00	0.00
cursor authentications	94	0.03	0.00
data blocks consistent reads - undo records applied	390	0.11	0.00
db block changes	4,697,375	1,300.17	37.25
db block gets	7,138,172	1,975.75	56.61
db block gets direct	5	0.00	0.00
db block gets from cache	7,138,167	1,975.75	56.61
deferred (CURRENT) block cleanout applications	898,493	248.69	7.13
dirty buffers inspected	127	0.04	0.00
enqueue conversions	27,330	7.56	0.22
enqueue releases	403,160	111.59	3.20
enqueue requests	403,172	111.59	3.20
enqueue timeouts	6	0.00	0.00
enqueue waits	114	0.03	0.00
exchange deadlocks	6	0.00	0.00
execute count	2,403,051	665.13	19.06
failed probes on index block reclamation	3	0.00	0.00
free buffer inspected	73,660	20.39	0.58
free buffer requested	77,311	21.40	0.61
heap block compress	14,593	4.04	0.12
hot buffers moved to head of LRU	123,310	34.13	0.98
immediate (CR) block cleanout applications	766	0.21	0.01
immediate (CURRENT) block cleanout applications	115,617	32.00	0.92
index crx upgrade (found)	723	0.20	0.01
index crx upgrade (positioned)	16,788	4.65	0.13
index fast full scans (full)	6	0.00	0.00
index fetch by key	1,753,344	485.30	13.90
index scans kdiixs1	1,130,653	312.95	8.97
leaf node 90-10 splits	348	0.10	0.00
leaf node splits	5,485	1.52	0.04
lob reads	12	0.00	0.00
lob writes	149	0.04	0.00
lob writes unaligned	149	0.04	0.00
logons cumulative	415	0.11	0.00
messages received	135,469	37.50	1.07
messages sent	135,469	37.50	1.07
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	7,598,186	2,103.07	60.26
opened cursors cumulative	522,006	144.48	4.14
parse count (failures)	727	0.20	0.01
parse count (hard)	1,085	0.30	0.01
parse count (total)	521,795	144.43	4.14
parse time cpu	1,362	0.38	0.01
parse time elapsed	5,244	1.45	0.04
physical read IO requests	32,200	8.91	0.26
physical read bytes	282,001,408	78,054.07	2,236.33
physical read total IO requests	50,199	13.89	0.40
physical read total bytes	1,560,204,800	431,843.02	12,372.76
physical read total multi block requests	1,154	0.32	0.01
physical reads	34,424	9.53	0.27
physical reads cache	34,334	9.50	0.27
physical reads cache prefetch	2,375	0.66	0.02
physical reads direct	90	0.02	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	75,478	20.89	0.60
physical write bytes	1,096,441,856	303,479.88	8,695.02
physical write total IO requests	334,073	92.47	2.65
physical write total bytes	3,696,698,880	1,023,194.92	29,315.61
physical write total multi block requests	266,664	73.81	2.11
physical writes	133,843	37.05	1.06
physical writes direct	95	0.03	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	133,748	37.02	1.06
physical writes non checkpoint	67,143	18.58	0.53
pinned buffers inspected	6	0.00	0.00
pinned cursors current	6	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	3,589	0.99	0.03
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	2,792,646	772.97	22.15
recursive cpu usage	30,874	8.55	0.24
redo blocks written	1,475,306	408.34	11.70
redo buffer allocation retries	4	0.00	0.00
redo entries	923,900	255.72	7.33
redo log space requests	4	0.00	0.00
redo log space wait time	2	0.00	0.00
redo ordering marks	22,311	6.18	0.18
redo size	695,869,136	192,606.91	5,518.39
redo subscn max counts	45,344	12.55	0.36
redo synch time	10,768	2.98	0.09
redo synch writes	120,729	33.42	0.96
redo wastage	35,356,796	9,786.27	280.39
redo write time	9,482	2.62	0.08
redo writer latching time	3	0.00	0.00
redo writes	125,988	34.87	1.00
rollback changes - undo records applied	1,966	0.54	0.02
rollbacks only - consistent read gets	83	0.02	0.00
root node splits	0	0.00	0.00
rows fetched via callback	1,422,203	393.65	11.28
session connect time	0	0.00	0.00
session cursor cache hits	422,869	117.04	3.35
session logical reads	22,728,729	6,291.00	180.24
shared hash latch upgrades - no wait	188,831	52.27	1.50
shared hash latch upgrades - wait	723	0.20	0.01
sorts (disk)	0	0.00	0.00
sorts (memory)	45,665	12.64	0.36
sorts (rows)	696,298	192.73	5.52
sql area evicted	284	0.08	0.00
sql area purged	780	0.22	0.01
summed dirty queue length	243	0.07	0.00
switch current to new buffer	5,179	1.43	0.04
table fetch by rowid	7,420,445	2,053.88	58.85
table fetch continued row	232,910	64.47	1.85
table scan blocks gotten	4,125,639	1,141.92	32.72
table scan rows gotten	401,413,834	111,105.78	3,183.30
table scans (long tables)	0	0.00	0.00
table scans (short tables)	234,598	64.93	1.86
total number of times SMON posted	7	0.00	0.00
transaction rollbacks	207	0.06	0.00
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	260,169,884	72,011.41	2,063.20
user I/O wait time	19,872	5.50	0.16
user calls	1,132,176	313.37	8.98
user commits	125,645	34.78	1.00
user rollbacks	455	0.13	0.00
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	44,976	12.45	0.36
write clones created in background	0	0.00	0.00
write clones created in foreground	6	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session uga memory max	1.9E+11	1.9E+11
session pga memory	54,082,627,424	54,096,423,336
session pga memory max	87,985,451,488	84,736,831,208
session cursor cache count	4,133,169	4,137,983
session uga memory	3.2E+14	3.2E+14
opened cursors current	4,814	3,865
logons current	203	156

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)	2	1.99

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)
SYSSNIDX	8,264	2	7.21	1.00	24,394	7	56	0.00
SYSTRAVELIDX	6,040	2	6.98	1.00	24,491	7	45	0.00
SYSSN	2,868	1	3.54	1.00	4,284	1	23	0.00
SYSSPCIDX	1,500	0	5.74	1.00	5,238	1	29	0.00
SYSKPIDX	1,826	1	8.94	1.00	3,953	1	4	0.00
SYSTRAVEL	3,972	1	5.81	1.00	1,319	0	1	0.00
SYSRTIDX	1,343	0	7.01	1.00	2,172	1	0	0.00
UNDOTBS1	4	0	0.00	1.00	3,112	1	24	0.00
SYSSPC	1,378	0	4.50	1.00	1,286	0	5	2.00
SYSRT	1,016	0	5.77	1.05	1,349	0	5	0.00
SYSREPAIRIDX	311	0	8.01	1.00	1,424	0	0	0.00
SMTRTIDX	402	0	7.24	1.00	943	0	0	0.00
SYSAUX	914	0	2.06	1.06	283	0	2	0.00
SYSKP	446	0	6.50	1.00	358	0	4	0.00
SMTRT	462	0	2.88	1.00	173	0	0	0.00
SYSTEM	293	0	3.72	1.00	180	0	12	0.00
TBSXXWB	345	0	1.04	7.07	10	0	0	0.00
SYSBSIDX	173	0	8.27	1.00	161	0	0	0.00
SYSBS	231	0	5.37	1.08	85	0	0	0.00
SYSREPAIR	71	0	6.06	1.00	225	0	0	0.00
TBSSTATS	242	0	0.41	1.00	2	0	0	0.00
TBSXXWBIDX	80	0	2.25	1.15	22	0	0	0.00
SMTBS	3	0	3.33	1.00	3	0	0	0.00
SMTBSIDX	2	0	15.00	1.00	2	0	0	0.00
SYSMISC	2	0	0.00	1.00	2	0	0	0.00
SYSMISCIDX	2	0	5.00	1.00	2	0	0	0.00
USERS	2	0	0.00	1.00	2	0	0	0.00
TEMP	0	0	0.00		3	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)
SMTBS	T:\ORACLE\ORADATA\SFCDB\SMTBS01.DBF	3	0	3.33	1.00	3	0	0	0.00
SMTBSIDX	U:\ORADATA\SMTBSIDX01.DBF	2	0	15.00	1.00	2	0	0	0.00
SMTRT	T:\ORACLE\ORADATA\SFCDB\SMTRT01.DBF	462	0	2.88	1.00	173	0	0	0.00
SMTRTIDX	U:\ORADATA\SMTRTIDX01.DBF	402	0	7.24	1.00	943	0	0	0.00
SYSAUX	T:\ORACLE\ORADATA\SFCDB\SYSAUX01.DBF	914	0	2.06	1.06	283	0	2	0.00
SYSBS	T:\ORACLE\ORADATA\SFCDB\SYSBS01.DBF	104	0	4.81	1.04	33	0	0	0.00
SYSBS	T:\ORACLE\ORADATA\SFCDB\SYSBS02.DBF	127	0	5.83	1.11	52	0	0	0.00
SYSBSIDX	U:\ORADATA\SYSBSIDX01.DBF	173	0	8.27	1.00	161	0	0	0.00
SYSKP	T:\ORACLE\ORADATA\SFCDB\SYSKP01.DBF	446	0	6.50	1.00	358	0	4	0.00
SYSKPIDX	U:\ORADATA\SYSKPIDX01.DBF	1,826	1	8.94	1.00	3,953	1	4	0.00
SYSMISC	T:\ORACLE\ORADATA\SFCDB\SYSMISC01.DBF	2	0	0.00	1.00	2	0	0	0.00
SYSMISCIDX	U:\ORADATA\SYSMISCIDX01.DBF	2	0	5.00	1.00	2	0	0	0.00
SYSREPAIR	T:\ORACLE\ORADATA\SFCDB\SYSREPAIR01.DBF	71	0	6.06	1.00	225	0	0	0.00
SYSREPAIRIDX	U:\ORADATA\SYSREPAIRIDX01.DBF	311	0	8.01	1.00	1,424	0	0	0.00
SYSRT	T:\ORACLE\ORADATA\SFCDB\SYSRT01.DBF	1,016	0	5.77	1.05	1,349	0	5	0.00
SYSRTIDX	U:\ORADATA\SYSRTIDX01.DBF	452	0	7.54	1.00	1,052	0	0	0.00
SYSRTIDX	U:\ORADATA\SYSRTIDX02.DBF	891	0	6.73	1.00	1,120	0	0	0.00
SYSSN	T:\ORACLE\ORADATA\SFCDB\SYSSN01.DBF	312	0	5.48	1.00	594	0	1	0.00
SYSSN	T:\ORACLE\ORADATA\SFCDB\SYSSN02.DBF	778	0	4.50	1.00	1,022	0	5	0.00
SYSSN	T:\ORACLE\ORADATA\SFCDB\SYSSN03.DBF	1,778	0	2.78	1.00	2,668	1	17	0.00
SYSSNIDX	U:\ORADATA\SYSSNIDX01.DBF	2,866	1	7.54	1.00	10,272	3	37	0.00
SYSSNIDX	U:\ORADATA\SYSSNIDX02.DBF	2,634	1	7.18	1.00	7,426	2	16	0.00
SYSSNIDX	U:\ORADATA\SYSSNIDX03.DBF	2,764	1	6.89	1.00	6,696	2	3	0.00
SYSSPC	T:\ORACLE\ORADATA\SFCDB\SYSSPC01.DBF	692	0	4.16	1.00	635	0	5	2.00
SYSSPC	T:\ORACLE\ORADATA\SFCDB\SYSSPC02.DBF	686	0	4.84	1.00	651	0	0	0.00
SYSSPCIDX	U:\ORADATA\SYSSPCIDX01.DBF	1,021	0	5.48	1.00	3,542	1	28	0.00
SYSSPCIDX	U:\ORADATA\SYSSPCIDX02.DBF	266	0	6.95	1.00	897	0	0	0.00
SYSSPCIDX	U:\ORADATA\SYSSPCIDX03.DBF	213	0	5.45	1.00	799	0	1	0.00
SYSTEM	T:\ORACLE\ORADATA\SFCDB\SYSTEM01.DBF	293	0	3.72	1.00	180	0	12	0.00
SYSTRAVEL	T:\ORACLE\ORADATA\SFCDB\SYSTRAVEL01.DBF	1,040	0	6.17	1.00	582	0	0	0.00
SYSTRAVEL	T:\ORACLE\ORADATA\SFCDB\SYSTRAVEL02.DBF	759	0	6.43	1.00	35	0	0	0.00
SYSTRAVEL	T:\ORACLE\ORADATA\SFCDB\SYSTRAVEL03.DBF	865	0	6.40	1.00	64	0	0	0.00
SYSTRAVEL	T:\ORACLE\ORADATA\SFCDB\SYSTRAVEL04.DBF	1,308	0	4.77	1.00	638	0	1	0.00
SYSTRAVELIDX	U:\ORADATA\SYSTRAVELIDX01.DBF	869	0	6.95	1.00	3,773	1	2	0.00
SYSTRAVELIDX	U:\ORADATA\SYSTRAVELIDX02.DBF	1,191	0	7.20	1.00	5,108	1	6	0.00
SYSTRAVELIDX	U:\ORADATA\SYSTRAVELIDX03.DBF	1,348	0	7.31	1.00	5,450	2	12	0.00
SYSTRAVELIDX	U:\ORADATA\SYSTRAVELIDX04.DBF	996	0	5.83	1.00	4,055	1	15	0.00
SYSTRAVELIDX	U:\ORADATA\SYSTRAVELIDX05.DBF	852	0	8.03	1.00	3,161	1	8	0.00
SYSTRAVELIDX	U:\ORADATA\SYSTRAVELIDX06.DBF	784	0	6.42	1.00	2,944	1	2	0.00
TBSSTATS	T:\ORACLE\ORADATA\SFCDB\TBSSTATS01.DBF	242	0	0.41	1.00	2	0	0	0.00
TBSXXWB	T:\ORACLE\ORADATA\SFCDB\TBSXXWB01.DBF	345	0	1.04	7.07	10	0	0	0.00
TBSXXWBIDX	U:\ORADATA\TBSXXWBIDX01.DBF	80	0	2.25	1.15	22	0	0	0.00
TEMP	T:\ORACLE\ORADATA\SFCDB\TEMP01.DBF	0	0			3	0	0
UNDOTBS1	T:\ORACLE\ORADATA\SFCDB\UNDOTBS01.DBF	2	0	0.00	1.00	2,639	1	24	0.00
UNDOTBS1	U:\ORADATA\UNDOTBS02.DBF	2	0	0.00	1.00	473	0	0	0.00
USERS	T:\ORACLE\ORADATA\SFCDB\USERS01.DBF	2	0	0.00	1.00	2	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	229,093	100	22,728,125	34,330	133,748	0	0	210

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	29	14452	262350	790857	3686400	790857
E	0	13	2649	14847	333969	3686400	333969

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	176	0.09	21,769	2.36	470,674,589
D	352	0.19	43,538	2.01	400,786,675
D	528	0.28	65,307	1.89	376,674,285
D	704	0.38	87,076	1.80	358,371,337
D	880	0.47	108,845	1.69	336,754,441
D	1,056	0.57	130,614	1.52	302,328,594
D	1,232	0.66	152,383	1.28	254,398,576
D	1,408	0.76	174,152	1.11	221,732,365
D	1,584	0.85	195,921	1.05	208,814,597
D	1,760	0.95	217,690	1.02	202,354,705
D	1,856	1.00	229,564	1.00	199,324,248
D	1,936	1.04	239,459	0.99	196,798,362
D	2,112	1.14	261,228	0.96	192,183,669
D	2,288	1.23	282,997	0.95	188,768,352
D	2,464	1.33	304,766	0.93	185,719,553
D	2,640	1.42	326,535	0.92	183,223,565
D	2,816	1.52	348,304	0.91	181,236,179
D	2,992	1.61	370,073	0.90	179,676,019
D	3,168	1.71	391,842	0.89	178,279,598
D	3,344	1.80	413,611	0.89	177,049,465
D	3,520	1.90	435,380	0.88	175,474,758

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	4,118	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	750	562	243.64	0.00	0.00	0.00	0.00	102,400
E	750	563	244.27	0.00	0.00	0.00	0.00	102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	39,767	39,767
64K	128K	279	279
128K	256K	222	222
512K	1024K	4,576	4,576
1M	2M	134	134

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
94	0.13	3,892,861.04	389,249.92	91.00	12,666
188	0.25	3,892,861.04	240,530.37	94.00	16
375	0.50	3,892,861.04	94,714.58	98.00	0
563	0.75	3,892,861.04	93,818.93	98.00	0
750	1.00	3,892,861.04	87,864.90	98.00	0
900	1.20	3,892,861.04	78,888.87	98.00	0
1,050	1.40	3,892,861.04	78,888.87	98.00	0
1,200	1.60	3,892,861.04	78,888.87	98.00	0
1,350	1.80	3,892,861.04	78,888.87	98.00	0
1,500	2.00	3,892,861.04	78,888.87	98.00	0
2,250	3.00	3,892,861.04	78,888.87	98.00	0
3,000	4.00	3,892,861.04	78,888.87	98.00	0
4,500	6.00	3,892,861.04	78,888.87	98.00	0
6,000	8.00	3,892,861.04	78,888.87	98.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 (K)
304	0.54	74	5,157	22,467,938	1.00	52,927	1.12	1,675,590
368	0.66	130	7,918	22,469,734	1.00	51,131	1.08	1,675,699
432	0.77	193	11,837	22,471,281	1.00	49,584	1.04	1,675,793
496	0.89	256	14,772	22,472,506	1.00	48,359	1.02	1,675,867
560	1.00	320	17,226	22,473,403	1.00	47,462	1.00	1,675,922
624	1.11	383	20,101	22,474,020	1.00	46,845	0.99	1,675,961
688	1.23	446	24,310	22,474,424	1.00	46,441	0.98	1,675,986
752	1.34	509	26,482	22,474,678	1.00	46,187	0.97	1,676,003
816	1.46	572	29,594	22,474,835	1.00	46,030	0.97	1,676,013
880	1.57	635	33,001	22,474,933	1.00	45,932	0.97	1,676,020
944	1.69	698	36,185	22,474,995	1.00	45,870	0.97	1,676,024
1,008	1.80	761	39,241	22,475,036	1.00	45,829	0.97	1,676,027
1,072	1.91	824	41,926	22,475,064	1.00	45,801	0.97	1,676,029
1,136	2.03	887	44,738	22,475,084	1.00	45,781	0.96	1,676,031

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
640	0.25	2,644,024	488,164,501
1,280	0.50	2,174,398	371,679,534
1,920	0.75	1,607,280	229,980,075
2,560	1.00	1,486,158	199,324,038
3,200	1.25	1,440,682	187,962,568
3,840	1.50	1,418,686	182,002,779
4,480	1.75	1,411,404	182,002,779
5,120	2.00	1,411,404	182,002,779

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	186	0	0
undo header	20	0	0
undo block	4	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	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (index contention)	108	108	108	1	11.44
RO-Multiple Object Reuse (fast object reuse)	27	27	3	0	5.33
TX-Transaction (row lock contention)	3	3	3	0	5.33

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	43.61	147,661	141	7	180/180	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
28-Mar 12:02	992	2,119	0	7	180	0/0	0/0/0/0/0/0
28-Mar 11:52	2,735	8,025	0	5	180	0/0	0/0/0/0/0/0
28-Mar 11:42	4,103	13,048	0	6	180	0/0	0/0/0/0/0/0
28-Mar 11:32	6,043	22,990	0	7	180	0/0	0/0/0/0/0/0
28-Mar 11:22	14,702	74,702	0	7	180	0/0	0/0/0/0/0/0
28-Mar 11:12	4,703	13,036	0	5	180	0/0	0/0/0/0/0/0
28-Mar 11:02	10,333	13,741	141	6	180	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	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,513	0.00		0
AWR Alerted Metric Element list	31,324	0.00		0
Consistent RBA	125,997	0.00		0
FAL request queue	76	0.00		0
FAL subheap alocation	76	0.00		0
FIB s.o chain latch	20	0.00		0
FOB s.o list latch	787	0.00		0
In memory undo latch	1,905,001	0.01	0.80	129,315	0.01
JS mem alloc latch	6	0.00		0
JS queue access latch	6	0.00		0
JS queue state obj latch	26,062	0.00		0
JS slv state obj latch	271	1.48	0.00	0
KMG MMAN ready and startup request latch	1,200	0.00		0
KTF sga latch	8	0.00		1,207	0.00
KWQMN job cache list latch	53	0.00		0
KWQP Prop Status	24	0.00		0
MQL Tracking Latch	0			71	0.00
Memory Management Latch	0			1,200	0.00
OS process	993	0.00		0
OS process allocation	1,862	0.00		0
OS process: request allocation	362	0.00		0
PL/SQL warning settings	66,784	0.00		0
SGA IO buffer pool latch	194	0.00		194	0.00
SQL memory manager latch	1	0.00		1,199	0.00
SQL memory manager workarea list latch	118,344	0.00		0
Shared B-Tree	273	0.00		0
active checkpoint queue latch	10,285	0.00		0
active service list	17,227	0.03	0.00	34,180	0.00
address list	158	0.00		0
alert log latch	4	0.00		0
archive control	246	0.00		0
archive process latch	1,355	0.00		0
begin backup scn array	2	0.00		0
cache buffer handles	12,422	0.00		0
cache buffers chains	55,610,414	0.01	0.00	76,215	0.00
cache buffers lru chain	278,650	0.01	0.13	77,681	0.01
cache table scan latch	0			194	0.00
channel handle pool latch	363	0.00		0
channel operations parent latch	18,160	0.00		0
checkpoint queue latch	376,577	0.00		117,062	0.00
client/application info	20,716	0.00		0
commit callback allocation	24	0.00		0
compile environment latch	415	0.00		0
database property service latch	34	0.00		0
dictionary lookup	5	0.00		0
dml lock allocation	433,519	0.29	0.00	0
dummy allocation	877	0.11	0.00	0
enqueue hash chains	833,769	0.10	0.00	1	0.00
enqueues	316,730	0.01	0.00	0
event group latch	181	0.00		0
file cache latch	1,418	0.00		0
global KZLD latch for mem in SGA	264	0.00		0
global tx hash mapping	14,937	0.00		0
hash table column usage latch	212	0.00		13,023	0.00
hash table modification latch	105	0.00		0
interrupt manipulation	25	0.00		0
job workq parent latch	0			141	5.67
job_queue_processes parameter latch	115	0.00		0
kks stats	2,027	0.00		0
kmcptab latch	1,009	0.00		0
kmcpvec latch	0			1,009	0.00
kokc descriptor allocation latch	28	0.00		0
ksuosstats global area	242	0.00		0
ktm global data	32	0.00		0
kwqbsn:qsga	249	0.00		0
lgwr LWN SCN	126,251	0.00		0
library cache	3,106,172	0.06	0.00	307	0.00
library cache load lock	332	0.00		0
library cache lock	5,681,480	0.00	0.00	0
library cache lock allocation	3,838	0.00		0
library cache pin	1,662,593	0.03	0.00	0
library cache pin allocation	64,588	0.00	0.00	0
list of block allocation	15,072	0.01	0.00	0
loader state object freelist	26	0.00		0
message pool operations parent latch	60	0.00		0
messages	423,827	0.00	0.00	0
mostly latch-free SCN	126,438	0.01	0.17	0
multiblock read objects	798	0.00		0
ncodef allocation latch	69	0.00		0
object queue header heap	609	0.00		580	0.00
object queue header operation	548,143	0.00	0.00	0
object stats modification	21	0.00		0
parallel query alloc buffer	480	0.00		0
parameter list	957	0.00		0
parameter table management	889	0.00		0
post/wait queue	180,192	0.00		119,814	0.00
process allocation	362	0.00		181	0.00
process group creation	362	0.00		0
qmn task queue latch	516	0.00		0
redo allocation	637,755	0.01	0.00	923,752	0.04
redo copy	0			923,843	0.03
redo writing	390,919	0.00	0.00	0
resmgr group change latch	4,076	0.00		0
resmgr:active threads	862	0.00		0
resmgr:actses change group	340	0.00		0
resmgr:free threads list	861	0.23	0.00	0
resmgr:resource group CPU method	387	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	701,714	0.06	0.00	105	0.00
rules engine aggregate statistics	2	0.00		0
rules engine rule set statistics	4	0.00		0
sequence cache	3,658	0.16	0.00	0
session allocation	438,073	0.01	0.10	0
session idle bit	2,482,736	0.00	0.00	0
session state list latch	911	0.00		0
session switching	974	0.00		0
session timer	1,450	0.00		0
shared pool	198,374	0.02	0.00	0
shared pool simulator	2,442	0.00		0
simulator hash latch	1,659,238	0.00	0.00	0
simulator lru latch	133,742	0.01	0.00	1,518,384	0.04
slave class	8	0.00		0
slave class create	32	3.13	1.00	0
sort extent pool	111	0.00		0
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
temp lob duration state obj allocation	2	0.00		0
threshold alerts latch	763	0.00		0
transaction allocation	221,265	0.00	0.00	0
transaction branch allocation	3,515	0.00		0
undo global data	748,252	0.00	0.00	0
user lock	1,302	0.31	0.00	0
virtual circuit buffers	4,814,114	0.11	0.00	0
virtual circuit queues	2,091,780	0.00	0.00	0
virtual circuits	1,009,071	0.02	0.00	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	55,610,414	7,910	11	7,899
virtual circuit buffers	4,814,114	5,220	4	5,216
library cache	3,106,172	1,718	7	1,711
dml lock allocation	433,519	1,244	1	1,243
enqueue hash chains	833,769	875	1	874
library cache pin	1,662,593	501	1	500
row cache objects	701,714	397	1	396
In memory undo latch	1,905,001	260	208	52
session allocation	438,073	29	3	26
mostly latch-free SCN	126,438	18	3	15
cache buffers lru chain	278,650	15	2	13
slave class create	32	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
In memory undo latch	ktiFlush: child	181	46
In memory undo latch	kticmt: child	40	16
In memory undo latch	ktichg: child	3	160
active service list	kswslogon: session logout	4	4
cache buffers chains	kcbgtcr: fast path	75	2
cache buffers chains	kcbgtcr: kslbegin excl	25	68
cache buffers chains	kcbgcur: kslbegin	6	4
cache buffers chains	kcbchg: kslbegin: bufs not pinned	1	2
cache buffers chains	kcbzwb	1	0
cache buffers lru chain	kcbzgws	2	0
dml lock allocation	ktaiam	1	1
enqueue hash chains	ksqrcl	1	1
lgwr LWN SCN	kcs023	3	0
library cache	kglic	4	1
library cache	kglpndl: child: after processing	2	0
library cache	kglobpn: child:	1	2
library cache pin	kglpndl	1	0
object queue header operation	kcbo_switch_mq_bg	1	0
object queue header operation	kcbw_link_q	1	0
row cache objects	kqreqd: reget	1	0
session allocation	ksuxds: KSUSFCLC not set	2	2
session allocation	ksufap: active sessions	1	0
slave class create	ksvcreate	1	0
virtual circuits	kmcmbf	4	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: 22,728,729
Captured Segments account for 81.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SAJET	SYSSNIDX	G_SN_STATUS_IDX	INDEX	2,411,744	10.61
SAJET	SYSBS	SYS_MODULE_PARAM	TABLE	2,373,392	10.44
SAJET	SYSSN	G_SN_STATUS	TABLE	1,632,224	7.18
SAJET	SYSBSIDX	BS_PART_NO_IDX	INDEX	1,326,592	5.84
SAJET	SYSRT	G_SN_COUNT	TABLE	634,880	2.79

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 34,424
Captured Segments account for 82.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SAJET	SYSTRAVEL	G_SN_TRAVEL	TABLE	3,964	11.52
SAJET	SYSSN	G_SN_STATUS	TABLE	2,862	8.31
XXWB	TBSXXWB	XXWB_RMA_REQ_LINES	TABLE	2,182	6.34
SAJET	SYSSNIDX	G_SN_STATUS_OUT_PROCESS_IDX	INDEX	1,429	4.15
SAJET	SYSSPC	G_TEST_RESULT	TABLE	1,374	3.99

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
SAJET	SYSSNIDX	G_SN_STATUS_OUT_PROCESS_IDX	INDEX	50	43.86
SAJET	SYSTRAVELIDX	G_SN_TRAVEL_OUT_PROCESS_IDX	INDEX	33	28.95
SAJET	SYSSPCIDX	G_TEST_RESULT_UPDATE_IDX	INDEX	15	13.16
SAJET	SYSRT	G_SN_COUNT	TABLE	4	3.51
SAJET	SYSSPCIDX	G_TEST_RESULT_IDX	INDEX	4	3.51

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
SAJET	SYSSNIDX	G_SN_STATUS_OUT_PROCESS_IDX	INDEX	52	28.11
SAJET	SYSTRAVELIDX	G_SN_TRAVEL_OUT_PROCESS_IDX	INDEX	37	20.00
SAJET	SYSSPCIDX	G_TEST_RESULT_UPDATE_IDX	INDEX	27	14.59
SAJET	SYSSN	G_SN_STATUS	TABLE	23	12.43
SYS	SYSTEM	JOB$	TABLE	12	6.49

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	65	0.00	2	1
dc_database_links	18,566	0.00	0	11
dc_files	2,700	0.00	0	45
dc_global_oids	35	11.43	0	73
dc_histogram_data	6,974	0.17	0	6,651
dc_histogram_defs	3,651	3.81	0	4,650
dc_object_grants	87,249	0.02	0	355
dc_object_ids	8,911	0.77	3	1,659
dc_objects	31,093	0.26	88	995
dc_profiles	442	0.00	0	2
dc_rollback_segments	1,490	0.00	0	66
dc_segments	1,400	1.14	20	807
dc_sequences	176	15.91	176	52
dc_table_scns	3	100.00	0	0
dc_tablespace_quotas	6	16.67	6	4
dc_tablespaces	28,361	0.00	0	29
dc_usernames	61,828	0.00	0	49
dc_users	44,399	0.00	0	81
kqlsubheap_object	4	25.00	0	1
outstanding_alerts	340	0.29	2	57

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	255	0.78	17,109	0.01	0	0
CLUSTER	37	2.70	72	1.39	0	0
INDEX	2	0.00	16	0.00	0	0
SQL AREA	50,236	0.90	2,507,225	0.09	819	84
TABLE/PROCEDURE	2,472	3.88	836,908	0.03	75	0
TRIGGER	491	0.00	32,809	0.00	0	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	131.57		0.93	0.91	7	9	142	142
	Freeable	103.56	0.00	1.08	0.52	4		96	96
	SQL	4.65	0.29	0.04	0.07	0	108	124	70
	PL/SQL	3.90	1.41	0.03	0.04	0	6	132	132
E	Other	132.26		0.93	0.94	7	9	142	142
	Freeable	103.81	0.00	1.08	0.52	4		96	96
	SQL	4.40	0.14	0.04	0.06	0	108	124	70
	PL/SQL	3.82	1.42	0.03	0.04	0	6	132	132

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,946,157,056
Fixed Size	2,081,024
Redo Buffers	14,692,352
Variable Size	1,258,295,040

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	free memory	46.72	68.48	46.58
large	session heap	64.25	42.49	-33.87
shared	ASH buffers	15.50	15.50	0.00
shared	CCursor	40.39	40.61	0.54
shared	KGH: NO ACCESS	12.33	12.33	0.00
shared	KTI-UNDO	14.78	14.78	0.00
shared	NETWORK BUFFER	14.21	9.31	-34.46
shared	PCursor	18.18	18.36	1.00
shared	XDB Schema Cac	8.96	8.96	0.00
shared	db_block_hash_buckets	11.25	11.25	0.00
shared	event statistics per sess	18.07	18.07	0.00
shared	free memory	112.82	118.75	5.26
shared	kglsim object batch	6.89	6.89	0.00
shared	library cache	25.21	25.24	0.11
shared	private strands	13.96	13.96	0.00
shared	row cache	7.16	7.16	0.00
shared	sessions	10.50	10.50	0.00
shared	sql area	126.67	126.84	0.13
	buffer_cache	1,856.00	1,856.00	0.00
	fixed_sga	1.98	1.98	0.00
	log_buffer	14.01	14.01	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	T:\ORACLE\ADMIN\SFCDB\BDUMP\ADUMP
background_dump_dest	T:\ORACLE\ADMIN\SFCDB\BDUMP
compatible	10.2.0.5.0
control_files	T:\ORACLE\ORADATA\SFCDB\CONTROL01.CTL, T:\ORACLE\ORADATA\SFCDB\CONTROL02.CTL, U:\ORADATA\CONTROL03.CTL
core_dump_dest	T:\ORACLE\ADMIN\SFCDB\CDUMP
db_block_size	8192
db_cache_size	637534208
db_domain	GZP.LITEONIT.COM
db_file_multiblock_read_count	16
db_name	SFCDB
dispatchers	(protocol=tcp)(dispatchers=10)(service=sfcdb.liteonit.com)
instance_name	SFCDB
job_queue_processes	10
large_pool_size	117440512
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=10.168.33.44)(PORT=1521))
log_archive_dest_1	location=U:\ORADATA\archive
log_archive_format	ARC%s_%r.%T
max_dispatchers	20
max_shared_servers	200
nls_language	ENGLISH
nls_territory	AMERICA
open_cursors	300
pga_aggregate_target	786432000
processes	500
remote_login_passwordfile	EXCLUSIVE
sessions	2000
sga_max_size	3221225472
sga_target	2684354560
shared_pool_size	587202560
shared_servers	50
streams_pool_size	0
undo_management	AUTO
undo_retention	10800
undo_tablespace	UNDOTBS1
user_dump_dest	T:\ORACLE\ADMIN\SFCDB\UDUMP

End of Report

% Blocks changed per Read:	20.67	Recursive Call %:	71.15
Rollback per transaction %:	0.36	Rows per Sort:	15.25

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.85	In-memory Sort %:	100.00
Library Hit %:	99.93	Soft Parse %:	99.79
Execute to Parse %:	78.29	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	25.97	% Non-Parse CPU:	97.90