WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

BHPSFCDB 2412701613 bhpsfcdb 1 10.2.0.5.0 NO BHP11DB10

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
BHPSFCDB	2412701613	bhpsfcdb	1	10.2.0.5.0	NO	BHP11DB10

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 6083 10-Sep-14 13:00:05 374 30.4

End Snap: 6084 10-Sep-14 14:00:51 428 32.8

Elapsed: 60.77 (mins)

DB Time: 597.79 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	6083	10-Sep-14 13:00:05	374	30.4
End Snap:	6084	10-Sep-14 14:00:51	428	32.8
Elapsed:		60.77 (mins)
DB Time:		597.79 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 3,200M 3,200M Std Block Size: 8K

Shared Pool Size: 704M 704M Log Buffer: 14,344K

	Begin	End
Buffer Cache:	3,200M	3,200M	Std Block Size:	8K
Shared Pool Size:	704M	704M	Log Buffer:	14,344K

Load Profile

Per Second Per Transaction

Redo size: 1,608,443.66 25,546.40

Logical reads: 38,639.30 613.70

Block changes: 11,348.65 180.25

Physical reads: 44.43 0.71

Physical writes: 147.08 2.34

User calls: 1,466.28 23.29

Parses: 505.54 8.03

Hard parses: 0.32 0.01

Sorts: 34.97 0.56

Logons: 0.15 0.00

Executes: 1,739.03 27.62

Transactions: 62.96

	Per Second	Per Transaction
Redo size:	1,608,443.66	25,546.40
Logical reads:	38,639.30	613.70
Block changes:	11,348.65	180.25
Physical reads:	44.43	0.71
Physical writes:	147.08	2.34
User calls:	1,466.28	23.29
Parses:	505.54	8.03
Hard parses:	0.32	0.01
Sorts:	34.97	0.56
Logons:	0.15	0.00
Executes:	1,739.03	27.62
Transactions:	62.96

% Blocks changed per Read: 29.37 Recursive Call %: 53.46

Rollback per transaction %: 3.71 Rows per Sort: 27.44

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.96 Soft Parse %: 99.94

Execute to Parse %: 70.93 Latch Hit %: 99.94

Parse CPU to Parse Elapsd %: 47.21 % Non-Parse CPU: 97.11

Shared Pool Statistics

Begin End

Memory Usage %: 47.96 55.03

% SQL with executions>1: 72.43 83.09

% Memory for SQL w/exec>1: 75.66 78.14

	Begin	End
Memory Usage %:	47.96	55.03
% SQL with executions>1:	72.43	83.09
% Memory for SQL w/exec>1:	75.66	78.14

Top 5 Timed Events

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

log file sync 224,468 10,463 47 29.2 Commit

CPU time 8,615 24.0

latch free 52,565 5,842 111 16.3 Other

db file sequential read 144,680 2,946 20 8.2 User I/O

cursor: pin S 24,293,081 1,868 0 5.2 Other

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
log file sync	224,468	10,463	47	29.2	Commit
CPU time		8,615		24.0
latch free	52,565	5,842	111	16.3	Other
db file sequential read	144,680	2,946	20	8.2	User I/O
cursor: pin S	24,293,081	1,868	0	5.2	Other

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): 35867.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	20,312.11	56.63
DB CPU	8,615.00	24.02
PL/SQL execution elapsed time	1,592.07	4.44
parse time elapsed	621.15	1.73
hard parse elapsed time	65.76	0.18
connection management call elapsed time	23.71	0.07
hard parse (sharing criteria) elapsed time	4.34	0.01
repeated bind elapsed time	3.45	0.01
PL/SQL compilation elapsed time	3.12	0.01
sequence load elapsed time	2.46	0.01
hard parse (bind mismatch) elapsed time	0.53	0.00
failed parse elapsed time	0.04	0.00
DB time	35,867.14
background elapsed time	4,608.80
background cpu time	434.70

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
Commit	224,468	15	10,463	47	29.17
CPU time			8,615		24.02
Other	24,363,494	0	7,992	0	22.28
Concurrency	59,929	0	3,385	56	9.44
User I/O	148,025		2,988	20	8.33
System I/O	401,934		2,451	6	6.83
Network	3,898,093		1,271	0	3.54
Application	940	9	513	545	1.43
Configuration	415	2	27	66	0.08

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
log file sync	224,468	15	10,463	47	0.98
latch free	52,565		5,842	111	0.23
db file sequential read	144,680		2,946	20	0.63
cursor: pin S	24,293,081		1,868	0	105.82
latch: library cache	16,161		1,760	109	0.07
log file parallel write	145,841		1,111	8	0.64
SQL*Net message from dblink	11,576		1,080	93	0.05
db file parallel write	236,632		887	4	1.03
enq: TX - row lock contention	844	10	511	605	0.00
latch: cache buffers chains	12,351		456	37	0.05
latch: In memory undo latch	7,866		282	36	0.03
buffer busy waits	6,755	1	233	34	0.03
latch: shared pool	8,898		227	25	0.04
enq: TX - index contention	2,592		220	85	0.01
Log archive I/O	5,813		178	31	0.03
log file sequential read	5,851		165	28	0.03
SQL*Net message to client	3,773,368		128	0	16.44
latch: library cache lock	2,381		82	34	0.01
latch: enqueue hash chains	601		65	108	0.00
control file sequential read	5,925		59	10	0.03
SQL*Net more data to client	101,106		57	1	0.44
LGWR wait for redo copy	5,968	12	55	9	0.03
control file parallel write	1,848		51	28	0.01
os thread startup	81	23	44	540	0.00
latch: library cache pin	1,625		41	25	0.01
latch: session allocation	694		41	59	0.00
latch: row cache objects	1,219		39	32	0.01
db file scattered read	2,138		32	15	0.01
latch: object queue header operation	2,195		29	13	0.01
latch: virtual circuit queues	4,830		28	6	0.02
log file switch completion	169		23	138	0.00
latch: cache buffers lru chain	1,796		21	12	0.01
rdbms ipc reply	295		17	57	0.00
latch: redo allocation	927		11	12	0.00
latch: messages	130		7	56	0.00
SQL*Net more data from client	329		5	16	0.00
read by other session	100		5	49	0.00
latch: checkpoint queue latch	123		4	36	0.00
db file parallel read	155		3	22	0.00
latch: undo global data	97		2	24	0.00
latch: redo writing	235		2	9	0.00
SQL*Net break/reset to client	90		2	20	0.00
wait list latch free	58		2	29	0.00
direct path write	480		1	2	0.00
undo segment extension	10	70	1	108	0.00
enq: SQ - contention	1		1	882	0.00
SQL*Net more data from dblink	97		1	7	0.00
SQL*Net message to dblink	11,541		0	0	0.05
direct path read	472		0	1	0.00
log file single write	24		0	8	0.00
TCP Socket (KGAS)	47		0	1	0.00
enq: CF - contention	3		0	15	0.00
latch: cache buffer handles	1		0	13	0.00
SQL*Net more data to dblink	29		0	0	0.00
buffer deadlock	130	94	0	0	0.00
SQL*Net break/reset to dblink	6		0	0	0.00
SQL*Net message from client	3,773,375		503,004	133	16.44
virtual circuit status	2,961,298	0	152,436	51	12.90
jobq slave wait	2,020	97	5,994	2967	0.01
Streams AQ: waiting for time management or cleanup tasks	16	63	4,376	273475	0.00
Streams AQ: qmn slave idle wait	130		3,636	27968	0.00
Streams AQ: qmn coordinator idle wait	260	50	3,636	13984	0.00
Streams AQ: waiting for messages in the queue	726	100	3,623	4991	0.00
single-task message	36		15	423	0.00
class slave wait	9		0	46	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	145,832		1,111	8	0.64
db file parallel write	236,632		887	4	1.03
Log archive I/O	5,813		178	31	0.03
log file sequential read	5,851		165	28	0.03
events in waitclass Other	10,929	6	106	10	0.05
control file parallel write	1,848		51	28	0.01
control file sequential read	4,146		49	12	0.02
os thread startup	81	23	44	540	0.00
latch: redo writing	235		2	9	0.00
latch: library cache	11		2	179	0.00
db file scattered read	37		1	30	0.00
latch: row cache objects	1		1	546	0.00
direct path read	470		0	1	0.00
buffer busy waits	4		0	57	0.00
log file single write	24		0	8	0.00
direct path write	471		0	0	0.00
latch: cache buffers chains	5		0	0	0.00
rdbms ipc message	143,433	7	33,848	236	0.62
Streams AQ: waiting for time management or cleanup tasks	16	63	4,376	273475	0.00
Streams AQ: qmn slave idle wait	130		3,636	27968	0.00
Streams AQ: qmn coordinator idle wait	260	50	3,636	13984	0.00
pmon timer	1,870	100	3,625	1939	0.01
smon timer	42	19	3,367	80159	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	316,834
AVG_IDLE_TIME	44,715
AVG_SYS_TIME	69,527
AVG_USER_TIME	247,215
BUSY_TIME	1,267,685
IDLE_TIME	179,175
SYS_TIME	278,485
USER_TIME	989,200
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	1.0E+19
VM_OUT_BYTES	-1.8E+19
PHYSICAL_MEMORY_BYTES	10,735,874,048
NUM_CPUS	4
NUM_CPU_CORES	4

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
BHPSFCDB.BHP.LITEONIT.com	23,077.10	5,936.20	102,237	121,851,820
SYS$USERS	12,806.20	2,685.40	57,860	18,989,273
SYS$BACKGROUND	0.00	0.00	2,365	45,370

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
BHPSFCDB.BHP.LITEONIT.com	96090	2253	36011	2162	3304476	827
SYS$USERS	50011	714	23688	1172	592056	439
SYS$BACKGROUND	1953	21	182	47	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): 35,867
Captured SQL account for 73.7% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
3,308	685	34,933	0.09	9.22	fvja4ruj5yc6w	SajetApserver_ODAC.exe	begin SAJET.SJ_PACKING_GO(:TTE...
2,400	1,007	25	95.98	6.69	4ug7thvumuq38	SajetApserver_ODAC.exe	begin SAJET.LITEONIT_WAREHOUSE...
2,168	630	46,762	0.05	6.05	9r7c9az4q3ptc	TGS_Server_ODAC.exe	begin SAJET.XXSFC_ATE_INPUT(:T...
1,550	225	99,683	0.02	4.32	4rsnfarj3sv18	TGS_Server_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET P...
1,442	152	142,382	0.01	4.02	5qkg9khf38pg1	TGS_Server_ODAC.exe	SELECT ROWID FROM SAJET.G_SN_C...
1,313	288	99,679	0.01	3.66	1v2vfv48zxw31	TGS_Server_ODAC.exe	INSERT INTO SAJET.G_SN_TRAVEL ...
1,256	758	21,736	0.06	3.50	df2j8jfcxqq3x	SajetApserver_ODAC.exe	SELECT NVL(COUNT(*), 0) FROM S...
1,170	541	7,679	0.15	3.26	1c82697f4svzp	SajetApserver_ODAC.exe	begin SAJET.SJ_QC_INSP_SN(:TTE...
1,029	277	27,884	0.04	2.87	6s67zypjyzzwq	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE(:TSAJ...
784	95	269,227	0.00	2.19	4kpkf8n2qah1a	TGS_Server_ODAC.exe	SELECT WO_STATUS, WO_TYPE FROM...
637	80	42	15.18	1.78	gjwsm7v34yygu	SajetApserver_ODAC.exe	begin SAJET.SJ_QC_TRANSFER(:TQ...
560	323	7,679	0.07	1.56	bs867h3gzj3kb	SajetApserver_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET Q...
556	84	156,074	0.00	1.55	3fcwy3hymmgxh	TGS_Server_ODAC.exe	SELECT SHIFT_ID FROM SAJET.SYS...
530	159	15,939	0.03	1.48	ahzrdg1bwwxvu	SajetApserver_ODAC.exe	begin SAJET.LITEONIT_WO_INPUT_...
510	203	14,046	0.04	1.42	8u5w8zd1ztb27	SajetApserver_ODAC.exe	begin SAJET.BC_SERIAL_NUMBER(:...
495	33	42,962	0.01	1.38	3ru7x2ysh9bvh	TGS_Server_ODAC.exe	UPDATE SAJET.G_WO_BASE SET INP...
385	137	101,368	0.00	1.07	an39btr6jjf54	SajetApserver_ODAC.exe	INSERT INTO SAJET.G_SN_STATUS ...
378	137	8,416	0.04	1.05	4n3urc0x5knsx	TGS_Server_ODAC.exe	begin SAJET.SJ_PSN_TRANSFER_QT...
361	88	35,245	0.01	1.01	61uzzf0wukcq8	SajetApserver_ODAC.exe	begin SAJET.SJ_CKRT_SN_PSN(:TR...

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): 8,615
Captured SQL account for 94.7% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
1,007	2,400	25	40.29	11.69	6.69	4ug7thvumuq38	SajetApserver_ODAC.exe	begin SAJET.LITEONIT_WAREHOUSE...
758	1,256	21,736	0.03	8.80	3.50	df2j8jfcxqq3x	SajetApserver_ODAC.exe	SELECT NVL(COUNT(*), 0) FROM S...
685	3,308	34,933	0.02	7.95	9.22	fvja4ruj5yc6w	SajetApserver_ODAC.exe	begin SAJET.SJ_PACKING_GO(:TTE...
630	2,168	46,762	0.01	7.31	6.05	9r7c9az4q3ptc	TGS_Server_ODAC.exe	begin SAJET.XXSFC_ATE_INPUT(:T...
541	1,170	7,679	0.07	6.28	3.26	1c82697f4svzp	SajetApserver_ODAC.exe	begin SAJET.SJ_QC_INSP_SN(:TTE...
323	560	7,679	0.04	3.75	1.56	bs867h3gzj3kb	SajetApserver_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET Q...
288	1,313	99,679	0.00	3.34	3.66	1v2vfv48zxw31	TGS_Server_ODAC.exe	INSERT INTO SAJET.G_SN_TRAVEL ...
277	1,029	27,884	0.01	3.21	2.87	6s67zypjyzzwq	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE(:TSAJ...
225	1,550	99,683	0.00	2.61	4.32	4rsnfarj3sv18	TGS_Server_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET P...
203	510	14,046	0.01	2.35	1.42	8u5w8zd1ztb27	SajetApserver_ODAC.exe	begin SAJET.BC_SERIAL_NUMBER(:...
159	530	15,939	0.01	1.85	1.48	ahzrdg1bwwxvu	SajetApserver_ODAC.exe	begin SAJET.LITEONIT_WO_INPUT_...
152	1,442	142,382	0.00	1.76	4.02	5qkg9khf38pg1	TGS_Server_ODAC.exe	SELECT ROWID FROM SAJET.G_SN_C...
146	316	5,368	0.03	1.70	0.88	8700tc54uj1a8	TGS_Server_ODAC.exe	begin SAJET.LITEONIT_PACK_GROU...
137	385	101,368	0.00	1.59	1.07	an39btr6jjf54	SajetApserver_ODAC.exe	INSERT INTO SAJET.G_SN_STATUS ...
137	378	8,416	0.02	1.59	1.05	4n3urc0x5knsx	TGS_Server_ODAC.exe	begin SAJET.SJ_PSN_TRANSFER_QT...
124	196	8,119	0.02	1.44	0.55	0xr2w2mxnqfw3	SajetApserver_ODAC.exe	Select PALLET_NO, CARTON_NO, C...
117	306	5,225	0.02	1.35	0.85	6j0m635kj1p3z	TGS_Server_ODAC.exe	begin SAJET.XXSFC_COMMAND_CODE...
110	238	43,010	0.00	1.28	0.66	d01p78wgmw8vw	SajetApserver_ODAC.exe	begin SAJET.SJ_CKRT_ROUTE(:TER...
100	227	34,969	0.00	1.16	0.63	56m8yha4vt5fy	SajetApserver_ODAC.exe	begin SAJET.XXSFC_PACKING_CHEC...
96	329	3,479	0.03	1.11	0.92	4hk9wjgabmyad	SajetApserver_ODAC.exe	begin SMT.SJ_DIP_LOAD_GO_BOXID...
95	784	269,227	0.00	1.10	2.19	4kpkf8n2qah1a	TGS_Server_ODAC.exe	SELECT WO_STATUS, WO_TYPE FROM...
91	298	20,193	0.00	1.05	0.83	grj717r05jsc2	SajetApserver_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET W...
90	176	247,717	0.00	1.04	0.49	9rrw9gqg56vg5	SajetApserver_ODAC.exe	Select Param_value from sajet....
88	361	35,245	0.00	1.02	1.01	61uzzf0wukcq8	SajetApserver_ODAC.exe	begin SAJET.SJ_CKRT_SN_PSN(:TR...

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: 140,884,875
Captured SQL account for 81.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
56,185,050	25	2,247,402.00	39.88	1007.13	2399.61	4ug7thvumuq38	SajetApserver_ODAC.exe	begin SAJET.LITEONIT_WAREHOUSE...
51,532,260	21,736	2,370.83	36.58	758.42	1255.79	df2j8jfcxqq3x	SajetApserver_ODAC.exe	SELECT NVL(COUNT(*), 0) FROM S...
20,631,126	7,679	2,686.69	14.64	540.91	1170.03	1c82697f4svzp	SajetApserver_ODAC.exe	begin SAJET.SJ_QC_INSP_SN(:TTE...
16,229,870	7,679	2,113.54	11.52	323.33	559.54	bs867h3gzj3kb	SajetApserver_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET Q...
7,475,429	7,776	961.35	5.31	67.38	119.09	4rk3jrj3j55hh	SajetApserver_ODAC.exe	Select A.SERIAL_NUMBER, to_ch...
7,129,546	34,933	204.09	5.06	684.89	3308.22	fvja4ruj5yc6w	SajetApserver_ODAC.exe	begin SAJET.SJ_PACKING_GO(:TTE...
6,205,249	14,046	441.78	4.40	202.56	509.54	8u5w8zd1ztb27	SajetApserver_ODAC.exe	begin SAJET.BC_SERIAL_NUMBER(:...
5,989,867	101,368	59.09	4.25	137.16	385.13	an39btr6jjf54	SajetApserver_ODAC.exe	INSERT INTO SAJET.G_SN_STATUS ...
5,669,156	99,679	56.87	4.02	288.06	1312.67	1v2vfv48zxw31	TGS_Server_ODAC.exe	INSERT INTO SAJET.G_SN_TRAVEL ...
4,937,196	46,762	105.58	3.50	629.73	2168.28	9r7c9az4q3ptc	TGS_Server_ODAC.exe	begin SAJET.XXSFC_ATE_INPUT(:T...
3,744,376	8,119	461.19	2.66	123.77	195.85	0xr2w2mxnqfw3	SajetApserver_ODAC.exe	Select PALLET_NO, CARTON_NO, C...
3,664,238	99,683	36.76	2.60	224.97	1550.14	4rsnfarj3sv18	TGS_Server_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET P...
3,642,704	7,679	474.37	2.59	75.36	127.69	9b6awwm0g3sbz	SajetApserver_ODAC.exe	SELECT COUNT(SERIAL_NUMBER) FR...
2,261,302	3,479	649.99	1.61	95.67	329.47	4hk9wjgabmyad	SajetApserver_ODAC.exe	begin SMT.SJ_DIP_LOAD_GO_BOXID...
2,258,397	27,884	80.99	1.60	276.89	1029.13	6s67zypjyzzwq	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE(:TSAJ...
2,256,824	5,368	420.42	1.60	146.08	315.82	8700tc54uj1a8	TGS_Server_ODAC.exe	begin SAJET.LITEONIT_PACK_GROU...
2,189,241	142,382	15.38	1.55	152.02	1441.92	5qkg9khf38pg1	TGS_Server_ODAC.exe	SELECT ROWID FROM SAJET.G_SN_C...
1,916,207	15,939	120.22	1.36	159.17	530.06	ahzrdg1bwwxvu	SajetApserver_ODAC.exe	begin SAJET.LITEONIT_WO_INPUT_...
1,683,975	20,193	83.39	1.20	90.88	298.19	grj717r05jsc2	SajetApserver_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET W...
1,631,372	42	38,842.19	1.16	80.27	637.48	gjwsm7v34yygu	SajetApserver_ODAC.exe	begin SAJET.SJ_QC_TRANSFER(:TQ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 161,991
Captured SQL account for 46.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
27,801	46,762	0.59	17.16	629.73	2168.28	9r7c9az4q3ptc	TGS_Server_ODAC.exe	begin SAJET.XXSFC_ATE_INPUT(:T...
22,370	99,679	0.22	13.81	288.06	1312.67	1v2vfv48zxw31	TGS_Server_ODAC.exe	INSERT INTO SAJET.G_SN_TRAVEL ...
19,292	25	771.68	11.91	1007.13	2399.61	4ug7thvumuq38	SajetApserver_ODAC.exe	begin SAJET.LITEONIT_WAREHOUSE...
13,996	42	333.24	8.64	80.27	637.48	gjwsm7v34yygu	SajetApserver_ODAC.exe	begin SAJET.SJ_QC_TRANSFER(:TQ...
13,297	99,683	0.13	8.21	224.97	1550.14	4rsnfarj3sv18	TGS_Server_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET P...
11,580	34,933	0.33	7.15	684.89	3308.22	fvja4ruj5yc6w	SajetApserver_ODAC.exe	begin SAJET.SJ_PACKING_GO(:TTE...
9,326	21,736	0.43	5.76	758.42	1255.79	df2j8jfcxqq3x	SajetApserver_ODAC.exe	SELECT NVL(COUNT(*), 0) FROM S...
8,162	14,046	0.58	5.04	202.56	509.54	8u5w8zd1ztb27	SajetApserver_ODAC.exe	begin SAJET.BC_SERIAL_NUMBER(:...
7,900	101,368	0.08	4.88	137.16	385.13	an39btr6jjf54	SajetApserver_ODAC.exe	INSERT INTO SAJET.G_SN_STATUS ...
7,358	42	175.19	4.54	18.83	240.50	5wh5j5v0pktys	SajetApserver_ODAC.exe	INSERT INTO SAJET.G_SN_TRAVEL ...
6,365	3,479	1.83	3.93	95.67	329.47	4hk9wjgabmyad	SajetApserver_ODAC.exe	begin SMT.SJ_DIP_LOAD_GO_BOXID...
5,861	20,193	0.29	3.62	90.88	298.19	grj717r05jsc2	SajetApserver_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET W...
5,622	15,939	0.35	3.47	159.17	530.06	ahzrdg1bwwxvu	SajetApserver_ODAC.exe	begin SAJET.LITEONIT_WO_INPUT_...
5,336	27,884	0.19	3.29	276.89	1029.13	6s67zypjyzzwq	TGS_Server_ODAC.exe	begin SAJET.COMMAND_CODE(:TSAJ...
3,552	7,679	0.46	2.19	540.91	1170.03	1c82697f4svzp	SajetApserver_ODAC.exe	begin SAJET.SJ_QC_INSP_SN(:TTE...
2,776	7,679	0.36	1.71	323.33	559.54	bs867h3gzj3kb	SajetApserver_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET Q...
2,447	5,368	0.46	1.51	146.08	315.82	8700tc54uj1a8	TGS_Server_ODAC.exe	begin SAJET.LITEONIT_PACK_GROU...
1,868	142,376	0.01	1.15	31.84	121.47	a324mp0rxs36f	TGS_Server_ODAC.exe	SELECT ROWID FROM SAJET.G_SN_T...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 6,340,764
Captured SQL account for 51.3% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
269,227	269,228	1.00	0.00	4kpkf8n2qah1a	TGS_Server_ODAC.exe	SELECT WO_STATUS, WO_TYPE FROM...
247,717	247,717	1.00	0.00	9rrw9gqg56vg5	SajetApserver_ODAC.exe	Select Param_value from sajet....
156,074	115,072	0.74	0.00	3fcwy3hymmgxh	TGS_Server_ODAC.exe	SELECT SHIFT_ID FROM SAJET.SYS...
142,382	141,730	1.00	0.01	5qkg9khf38pg1	TGS_Server_ODAC.exe	SELECT ROWID FROM SAJET.G_SN_C...
142,376	553	0.00	0.00	a324mp0rxs36f	TGS_Server_ODAC.exe	SELECT ROWID FROM SAJET.G_SN_T...
122,627	75,542	0.62	0.00	75zns59wnsun5	TGS_Server_ODAC.exe	SELECT EMP_ID FROM SAJET.SYS_E...
114,900	114,899	1.00	0.00	cpd449q0d5f1u	TGS_Server_ODAC.exe	select sysdate from dual
101,368	101,368	1.00	0.00	an39btr6jjf54	SajetApserver_ODAC.exe	INSERT INTO SAJET.G_SN_STATUS ...
99,684	99,684	1.00	0.00	8as8q1t607n43	TGS_Server_ODAC.exe	SELECT B.WORK_ORDER, START_PRO...
99,683	99,683	1.00	0.02	4rsnfarj3sv18	TGS_Server_ODAC.exe	UPDATE SAJET.G_SN_STATUS SET P...
99,682	99,683	1.00	0.00	fd4r77pjv5m4q	TGS_Server_ODAC.exe	SELECT ROUTE_ID FROM SAJET.G_S...
99,679	99,679	1.00	0.01	1v2vfv48zxw31	TGS_Server_ODAC.exe	INSERT INTO SAJET.G_SN_TRAVEL ...
99,556	99,556	1.00	0.00	1du1709vn8k44	TGS_Server_ODAC.exe	SELECT B.WORK_ORDER, START_PRO...
97,754	82,389	0.84	0.00	1khtknq18qj38	SajetApserver_ODAC.exe	SELECT WORK_ORDER, WORK_FLAG, ...
75,437	16,282	0.22	0.00	brc7a8kf81mu2	SajetApserver_ODAC.exe	SELECT * FROM SAJET.SYS_BASE ...
75,431	75,431	1.00	0.00	d1v56jd70qfk8	SajetApserver_ODAC.exe	SELECT SSD.DEPT_NAME FROM SAJ...
70,123	70,123	1.00	0.00	78n1a9j26hsmj	SajetApserver_ODAC.exe	select parame_value from SAJET...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,843,277
Captured SQL account for 78.3% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
247,716	247,717	13.44	9rrw9gqg56vg5	SajetApserver_ODAC.exe	Select Param_value from sajet....
114,899	114,900	6.23	cpd449q0d5f1u	TGS_Server_ODAC.exe	select sysdate from dual
75,437	75,437	4.09	brc7a8kf81mu2	SajetApserver_ODAC.exe	SELECT * FROM SAJET.SYS_BASE ...
75,431	75,431	4.09	d1v56jd70qfk8	SajetApserver_ODAC.exe	SELECT SSD.DEPT_NAME FROM SAJ...
70,123	70,123	3.80	78n1a9j26hsmj	SajetApserver_ODAC.exe	select parame_value from SAJET...
42,957	43,010	2.33	d01p78wgmw8vw	SajetApserver_ODAC.exe	begin SAJET.SJ_CKRT_ROUTE(:TER...
38,577	38,577	2.09	6w32rpu5racxm	MAP.exe	select work_time, free_time1,...
38,577	38,577	2.09	fc2ya9u3y8mjv	MAP.exe	select a1.attribute2 model_id ...
35,317	35,317	1.92	9cz8ugdaupp1z	SajetApserver_ODAC.exe	SELECT 1 FROM sajet.SYS_TERMIN...
35,085	35,085	1.90	aghr6mrqgz9k1	SajetApserver_ODAC.exe	SELECT A.WORK_ORDER, A.WORK_FL...
35,075	35,245	1.90	61uzzf0wukcq8	SajetApserver_ODAC.exe	begin SAJET.SJ_CKRT_SN_PSN(:TR...
35,028	35,028	1.90	5bgdu9akk8g7u	SajetApserver_ODAC.exe	SELECT XBR.FIX_CODE, XBR.CODE...
34,983	34,983	1.90	ghwctacrmmas7	SajetApserver_ODAC.exe	SELECT BOX_NO, CARTON_NO, PALL...
34,982	34,982	1.90	4r3wnh0fn8y08	SajetApserver_ODAC.exe	SELECT SYSDATE FROM DUAL
34,982	34,981	1.90	7nqdv7gfn9m5h	SajetApserver_ODAC.exe	SELECT STL.TERMINAL_ID FROM S...
34,970	34,969	1.90	gyqd8ncfrnja6	SajetApserver_ODAC.exe	SELECT WORK_ORDER FROM SAJET....
34,969	34,969	1.90	56m8yha4vt5fy	SajetApserver_ODAC.exe	begin SAJET.XXSFC_PACKING_CHEC...
34,965	34,965	1.90	bffgkt5cn40rv	SajetApserver_ODAC.exe	SELECT SDT.DEPT_NAME FROM SAJ...
34,959	34,959	1.90	fm1k49q9qs8tc	SajetApserver_ODAC.exe	SELECT PALLET_NO FROM SAJET.G_...
34,934	34,934	1.90	6z85w3z5hwjxz	SajetApserver_ODAC.exe	SELECT CARTON_NO FROM SAJET.G_...
34,933	34,933	1.90	fvja4ruj5yc6w	SajetApserver_ODAC.exe	begin SAJET.SJ_PACKING_GO(:TTE...
33,515	33,515	1.82	17w409pwk4w4q	SajetApserver_ODAC.exe	SELECT STL.TERMINAL_ID FROM S...
31,929	31,929	1.73	ccn6904ssp56b	MAP.exe	select * from sajet.sys_pdlin...
31,929	31,929	1.73	gbgf5b8nt17uh	MAP.exe	select * from sajet.sys_kb_pa...
22,622	22,622	1.23	7fudb35btggy9	SajetApserver_ODAC.exe	SELECT SDT.MODEL_ID FROM SAJE...
19,118	19,118	1.04	51jpzq33u16ya	SajetApserver_ODAC.exe	select a.work_order from sajet...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,340,423	1	0.18	fqmpmkfr6pqyk	plsqldev.exe	select s.synonym_name object_n...

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

0xr2w2mxnqfw3 Select PALLET_NO, CARTON_NO, Count(SERIAL_NUMBER) QTY From SAJET.G_SN_STATUS Where QC_NO = :QC_NO Group By Pallet_No, CARTON_NO

17w409pwk4w4q SELECT STL.TERMINAL_ID FROM SAJET.SYS_TERMINAL STL, SAJET.SYS_PDLINE SPE, SAJET.SYS_DEPT SDT WHERE STL.PDLINE_ID = SPE.PDLINE_ID AND SPE.DEPT_ID = SDT.DEPT_ID AND EXISTS (SELECT PARAM_NAME FROM SAJET.SYS_BASE WHERE PARAM_NAME = 'CHECK_CARTON_WEEKCODE' AND PARAM_VALUE = 'Y' AND ATTRIBUTE1 LIKE '%' || SDT.DEPT_NAME || '%') AND NOT EXISTS (SELECT PARAM_NAME FROM SAJET.SYS_BASE WHERE PARAM_NAME = 'CHECK_CARTON_WEEKCODE' AND PARAM_VALUE = 'Y' AND ATTRIBUTE2 LIKE '%' || SPE.PDLINE_NAME || '%') AND STL.TERMINAL_ID = :sTerminalID

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;

1du1709vn8k44 SELECT B.WORK_ORDER, START_PROCESS_ID, END_PROCESS_ID, WO_STATUS, TARGET_QTY, OUTPUT_QTY, IN_PDLINE_TIME, OUT_PDLINE_TIME FROM SAJET.G_WO_BASE A, SAJET.G_SN_STATUS B WHERE B.SERIAL_NUMBER = :B1 AND A.WORK_ORDER = B.WORK_ORDER AND ROWNUM = 1

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

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

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

3ru7x2ysh9bvh UPDATE SAJET.G_WO_BASE SET INPUT_QTY = INPUT_QTY + 1 WHERE WORK_ORDER = :B1 AND ROWNUM = 1

4hk9wjgabmyad begin SMT.SJ_DIP_LOAD_GO_BOXID_TEST_JX(:TWO, :TREV, :TPARTNO, :TLINEID, :TPROCESSID, :TVC, :TDC, :TQTY, :TEMP, :TNOW, :TSSTSUSER, :TUNION_SLIP_NO, :TRES); end;

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

4n3urc0x5knsx begin SAJET.SJ_PSN_TRANSFER_QTY(:TTERMINALID, :PSN, :TDEFECT, :TNOW, :TEMP, :TTRES, :TRES, :TNEXTPROC); end;

4r3wnh0fn8y08 SELECT SYSDATE FROM DUAL

4rk3jrj3j55hh Select A.SERIAL_NUMBER, to_char(A.INSP_TIME, 'yyyy/mm/dd hh24:mi:ss') INSP_TIME, B.EMP_NAME, C.CUSTOMER_SN, A.QC_RESULT, c.Carton_No, c.Pallet_No From SAJET.G_QC_SN A , SAJET.G_SN_STATUS C , SAJET.SYS_EMP B Where A.QC_LOTNO = :QC_NO and A.QC_CNT =:QC_CNT and A.INSP_EMP_ID = B.EMP_ID and A.SERIAL_NUMBER = C.SERIAL_NUMBER Order By Insp_Time DESC

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

4ug7thvumuq38 begin SAJET.LITEONIT_WAREHOUSE_GO(:TREV, :TERMINALID, :TNOW, :TEMP, :TRES); end;

51jpzq33u16ya select a.work_order from sajet.g_sn_status a, sajet.g_wo_base b where a.serial_number=:sn and b.wo_status in('2', '3') AND A.WORK_ORDER = B.WORK_ORDER

56m8yha4vt5fy begin SAJET.XXSFC_PACKING_CHECK(:TERMINAL_ID, :CHK_TYPE, :SN, :CSN, :WO, :TRES); end;

5bgdu9akk8g7u SELECT XBR.FIX_CODE, XBR.CODE_TYPE, XBR.FROM1, XBR.TO1, XBR.FROM2, XBR.TO2 FROM SAJET.XXSFC_BARCODE_RULE XBR WHERE XBR.CODE_TYPE='CUSTOMER SN' AND XBR.ENABLED = 'Y'

5qkg9khf38pg1 SELECT ROWID FROM SAJET.G_SN_COUNT WHERE PDLINE_ID = :B8 AND STAGE_ID = :B7 AND PROCESS_ID = :B6 AND SHIFT_ID = :B5 AND WORK_ORDER = :B4 AND MODEL_ID = :B3 AND WORK_DATE = :B2 AND WORK_TIME = :B1 AND ROWNUM = 1

5wh5j5v0pktys INSERT INTO SAJET.G_SN_TRAVEL SELECT * FROM SAJET.G_SN_STATUS WHERE QC_NO = :B1

61uzzf0wukcq8 begin SAJET.SJ_CKRT_SN_PSN(:TREV, :TRES, :PSN); end;

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

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

6w32rpu5racxm select work_time, free_time1, free_time2, shift_id from sajet.SYS_KB_SHIFT_PARAM where shift_type =:SShiftType and Dept_iD = :SDeptID

6z85w3z5hwjxz SELECT CARTON_NO FROM SAJET.G_PACK_CARTON WHERE CARTON_NO = :CARTON_NO and rownum = 1

75zns59wnsun5 SELECT EMP_ID FROM SAJET.SYS_EMP WHERE EMP_NO = :B1 AND ROWNUM = 1

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

7fudb35btggy9 SELECT SDT.MODEL_ID FROM SAJET.G_SN_STATUS SDT , SAJET.XXSFC_PART_BASE XPB, SAJET.SYS_PART SP WHERE SDT.SERIAL_NUMBER =:sSN AND XPB.PARAM_NAME = 'PACKING NO DEFECT' AND XPB.ENABLED= 'Y' AND SP.PART_ID= SDT.MODEL_ID AND XPB.PART_NO =SP.PART_NO

7nqdv7gfn9m5h SELECT STL.TERMINAL_ID FROM SAJET.SYS_TERMINAL STL, SAJET.SYS_PDLINE SPE, SAJET.SYS_DEPT SDT WHERE STL.PDLINE_ID = SPE.PDLINE_ID AND SPE.DEPT_ID = SDT.DEPT_ID AND EXISTS (SELECT PARAM_NAME FROM SAJET.XXSFC_PART_BASE WHERE PARAM_NAME = 'PACKING NO DEFECT' AND ENABLED = 'Y' AND ATTRIBUTE1 LIKE '%' || SDT.DEPT_NAME || '%') AND STL.TERMINAL_ID = :sTerminalID

8700tc54uj1a8 begin SAJET.LITEONIT_PACK_GROUP_SN(:TTERMINALID, :TPROCESSID, :TREV, :TMODELID, :TCQTY, :TPQTY, :TDEFECT, :TNOW, :TEMP, :TPALLET, :TCARTON, :TFLAG, :TRES, :TNEXTPROC, :TCOMMAND); end;

8as8q1t607n43 SELECT B.WORK_ORDER, START_PROCESS_ID, END_PROCESS_ID, WO_STATUS, IN_PDLINE_TIME, OUT_PDLINE_TIME, NEXT_PROCESS FROM SAJET.G_WO_BASE A, SAJET.G_SN_STATUS B WHERE B.SERIAL_NUMBER = :B1 AND A.WORK_ORDER = B.WORK_ORDER AND ROWNUM = 1

8u5w8zd1ztb27 begin SAJET.BC_SERIAL_NUMBER(:TWO, :TBOX, :IQTY, :TEMPID, :TRES); end;

9b6awwm0g3sbz SELECT COUNT(SERIAL_NUMBER) FROM SAJET.G_SN_STATUS WHERE QC_NO = :B1

9cz8ugdaupp1z SELECT 1 FROM sajet.SYS_TERMINAL A, sajet.SYS_PDLINE B, sajet.SYS_DEPT C WHERE A.PDLINE_ID=B.PDLINE_ID AND B.DEPT_ID=C.DEPT_ID AND C.DEPT_NAME IN (SELECT PARAM_VALUE FROM sajet.SYS_BASE D WHERE PARAM_NAME='RE_CHECK_DEPT') AND A.TERMINAL_ID=:terminalid

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

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

a324mp0rxs36f SELECT ROWID FROM SAJET.G_SN_TRAVEL WHERE WORK_ORDER = :B3 AND SERIAL_NUMBER = :B2 AND PROCESS_ID = :B1 AND ROWNUM = 1

aghr6mrqgz9k1 SELECT A.WORK_ORDER, A.WORK_FLAG, A.MODEL_ID , A.CUSTOMER_SN, A.SERIAL_NUMBER, B.PART_NO , NVL(A.PALLET_NO, 'N/A') PALLET_NO, NVL(A.CARTON_NO, 'N/A') CARTON_NO , NVL(A.BOX_NO, 'N/A') BOX_NO FROM SAJET.G_SN_STATUS A , SAJET.SYS_PART B WHERE A.SERIAL_NUMBER = :SERIAL_NUMBER AND A.MODEL_ID = B.PART_ID(+) and rownum = 1

ahzrdg1bwwxvu begin SAJET.LITEONIT_WO_INPUT_CHK_SN(:TREV, :TPROCESSID, :TTERMINALID, :TWO, :TNOW, :TEMP, :TRES); end;

an39btr6jjf54 INSERT INTO SAJET.G_SN_STATUS (WORK_ORDER, SERIAL_NUMBER, MODEL_ID, ROUTE_ID, VERSION, EMP_ID, BOX_NO) VALUES(:B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

bffgkt5cn40rv SELECT SDT.DEPT_NAME FROM SAJET.SYS_PDLINE SPE, SAJET.SYS_DEPT SDT WHERE SPE.DEPT_ID = SDT.DEPT_ID AND SPE.PDLINE_ID = :s_Lid AND EXISTS (SELECT PARAM_NAME FROM SAJET.SYS_BASE SBE WHERE SBE.PARAM_NAME = :s_Para AND SBE.PARAM_VALUE = 'Y' AND SBE.ATTRIBUTE1 LIKE '%' || SDT.DEPT_NAME || '%') AND NOT EXISTS (SELECT PARAM_NAME FROM SAJET.SYS_BASE SBE WHERE SBE.PARAM_NAME = :s_Para AND SBE.PARAM_VALUE = 'Y' AND SBE.ATTRIBUTE2 LIKE '%' || SPE.PDLINE_NAME || '%')

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

bs867h3gzj3kb UPDATE SAJET.G_SN_STATUS SET QC_NO = :B2 , QC_RESULT ='N/A' WHERE PALLET_NO = :B1

ccn6904ssp56b select * from sajet.sys_pdline where pdline_id =:LineID

cpd449q0d5f1u select sysdate from dual

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

df2j8jfcxqq3x SELECT NVL(COUNT(*), 0) FROM SAJET.G_SN_STATUS WHERE WORK_ORDER = :B1 AND WORK_FLAG='1'

fc2ya9u3y8mjv select a1.attribute2 model_id from xxsfc_item_FG_model a1, sys_part b1 where a1.part_no = b1.part_no and b1.part_id =:PID

fd4r77pjv5m4q SELECT ROUTE_ID FROM SAJET.G_SN_STATUS WHERE SERIAL_NUMBER = :B1 AND ROWNUM = 1

fm1k49q9qs8tc SELECT PALLET_NO FROM SAJET.G_PACK_PALLET WHERE PALLET_NO = :PALLET_NO and rownum = 1

fqmpmkfr6pqyk select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

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

gbgf5b8nt17uh select * from sajet.sys_kb_param where param_type = 'C/T' and param_name =:NAME and param_name_type = 'LINE'

ghwctacrmmas7 SELECT BOX_NO, CARTON_NO, PALLET_NO FROM SAJET.G_SN_STATUS Where CARTON_NO=:sField and rownum=1

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

grj717r05jsc2 UPDATE SAJET.G_SN_STATUS SET WORK_ORDER = :B6 , VERSION = :B5 , MODEL_ID = :B4 , PDLINE_ID = 0 , STAGE_ID = 0, PROCESS_ID =0, TERMINAL_ID = 0, CUSTOMER_SN = 'N/A', ROUTE_ID = :B3 , PALLET_NO = 'N/A', CARTON_NO = 'N/A', BOX_NO = 'N/A', NEXT_PROCESS = 0, QC_NO = 'N/A', QC_RESULT = 'N/A' , CUSTOMER_ID = :B2 , IN_PDLINE_TIME = NULL, OUT_PDLINE_TIME = NULL WHERE SERIAL_NUMBER= :B1 AND ROWNUM=1

gyqd8ncfrnja6 SELECT WORK_ORDER FROM SAJET.XXSFC_WO_FAI_SN WHERE WORK_ORDER=:sW AND ROWNUM=1

SQL Id	SQL Text
0xr2w2mxnqfw3	Select PALLET_NO, CARTON_NO, Count(SERIAL_NUMBER) QTY From SAJET.G_SN_STATUS Where QC_NO = :QC_NO Group By Pallet_No, CARTON_NO
17w409pwk4w4q	SELECT STL.TERMINAL_ID FROM SAJET.SYS_TERMINAL STL, SAJET.SYS_PDLINE SPE, SAJET.SYS_DEPT SDT WHERE STL.PDLINE_ID = SPE.PDLINE_ID AND SPE.DEPT_ID = SDT.DEPT_ID AND EXISTS (SELECT PARAM_NAME FROM SAJET.SYS_BASE WHERE PARAM_NAME = 'CHECK_CARTON_WEEKCODE' AND PARAM_VALUE = 'Y' AND ATTRIBUTE1 LIKE '%' \|\| SDT.DEPT_NAME \|\| '%') AND NOT EXISTS (SELECT PARAM_NAME FROM SAJET.SYS_BASE WHERE PARAM_NAME = 'CHECK_CARTON_WEEKCODE' AND PARAM_VALUE = 'Y' AND ATTRIBUTE2 LIKE '%' \|\| SPE.PDLINE_NAME \|\| '%') AND STL.TERMINAL_ID = :sTerminalID
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;
1du1709vn8k44	SELECT B.WORK_ORDER, START_PROCESS_ID, END_PROCESS_ID, WO_STATUS, TARGET_QTY, OUTPUT_QTY, IN_PDLINE_TIME, OUT_PDLINE_TIME FROM SAJET.G_WO_BASE A, SAJET.G_SN_STATUS B WHERE B.SERIAL_NUMBER = :B1 AND A.WORK_ORDER = B.WORK_ORDER AND ROWNUM = 1
1khtknq18qj38	SELECT WORK_ORDER, WORK_FLAG, SERIAL_NUMBER FROM SAJET.G_SN_STATUS WHERE SERIAL_NUMBER = :B1 AND ROWNUM = 1
1v2vfv48zxw31	INSERT INTO SAJET.G_SN_TRAVEL SELECT * FROM SAJET.G_SN_STATUS WHERE SERIAL_NUMBER = :B1 AND ROWNUM = 1
3fcwy3hymmgxh	SELECT SHIFT_ID FROM SAJET.SYS_PDLINE_SHIFT_BASE WHERE PDLINE_ID = :B1 AND ACTIVE_FLAG = 'Y'
3ru7x2ysh9bvh	UPDATE SAJET.G_WO_BASE SET INPUT_QTY = INPUT_QTY + 1 WHERE WORK_ORDER = :B1 AND ROWNUM = 1
4hk9wjgabmyad	begin SMT.SJ_DIP_LOAD_GO_BOXID_TEST_JX(:TWO, :TREV, :TPARTNO, :TLINEID, :TPROCESSID, :TVC, :TDC, :TQTY, :TEMP, :TNOW, :TSSTSUSER, :TUNION_SLIP_NO, :TRES); end;
4kpkf8n2qah1a	SELECT WO_STATUS, WO_TYPE FROM SAJET.G_WO_BASE WHERE WORK_ORDER = :B1 AND ROWNUM = 1
4n3urc0x5knsx	begin SAJET.SJ_PSN_TRANSFER_QTY(:TTERMINALID, :PSN, :TDEFECT, :TNOW, :TEMP, :TTRES, :TRES, :TNEXTPROC); end;
4r3wnh0fn8y08	SELECT SYSDATE FROM DUAL
4rk3jrj3j55hh	Select A.SERIAL_NUMBER, to_char(A.INSP_TIME, 'yyyy/mm/dd hh24:mi:ss') INSP_TIME, B.EMP_NAME, C.CUSTOMER_SN, A.QC_RESULT, c.Carton_No, c.Pallet_No From SAJET.G_QC_SN A , SAJET.G_SN_STATUS C , SAJET.SYS_EMP B Where A.QC_LOTNO = :QC_NO and A.QC_CNT =:QC_CNT and A.INSP_EMP_ID = B.EMP_ID and A.SERIAL_NUMBER = C.SERIAL_NUMBER Order By Insp_Time DESC
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
4ug7thvumuq38	begin SAJET.LITEONIT_WAREHOUSE_GO(:TREV, :TERMINALID, :TNOW, :TEMP, :TRES); end;
51jpzq33u16ya	select a.work_order from sajet.g_sn_status a, sajet.g_wo_base b where a.serial_number=:sn and b.wo_status in('2', '3') AND A.WORK_ORDER = B.WORK_ORDER
56m8yha4vt5fy	begin SAJET.XXSFC_PACKING_CHECK(:TERMINAL_ID, :CHK_TYPE, :SN, :CSN, :WO, :TRES); end;
5bgdu9akk8g7u	SELECT XBR.FIX_CODE, XBR.CODE_TYPE, XBR.FROM1, XBR.TO1, XBR.FROM2, XBR.TO2 FROM SAJET.XXSFC_BARCODE_RULE XBR WHERE XBR.CODE_TYPE='CUSTOMER SN' AND XBR.ENABLED = 'Y'
5qkg9khf38pg1	SELECT ROWID FROM SAJET.G_SN_COUNT WHERE PDLINE_ID = :B8 AND STAGE_ID = :B7 AND PROCESS_ID = :B6 AND SHIFT_ID = :B5 AND WORK_ORDER = :B4 AND MODEL_ID = :B3 AND WORK_DATE = :B2 AND WORK_TIME = :B1 AND ROWNUM = 1
5wh5j5v0pktys	INSERT INTO SAJET.G_SN_TRAVEL SELECT * FROM SAJET.G_SN_STATUS WHERE QC_NO = :B1
61uzzf0wukcq8	begin SAJET.SJ_CKRT_SN_PSN(:TREV, :TRES, :PSN); end;
6j0m635kj1p3z	begin SAJET.XXSFC_COMMAND_CODE_BD(:TSAJET1, :TSAJET2, :TSAJET3, :TSAJET4, :TSAJET5, :TSAJET4TON, :TSAJET5TON, :TSAJET6TON, :TLINEID, :TSTAGEID, :TPROCESSID, :TTERMINALID, :TNOW, :TREV, :TRES, :TNEXTPROC); end;
6s67zypjyzzwq	begin SAJET.COMMAND_CODE(:TSAJET1, :TSAJET2, :TSAJET3, :TSAJET4, :TSAJET5, :TSAJET4TON, :TSAJET5TON, :TSAJET6TON, :TLINEID, :TSTAGEID, :TPROCESSID, :TTERMINALID, :TNOW, :TREV, :TRES, :TNEXTPROC); end;
6w32rpu5racxm	select work_time, free_time1, free_time2, shift_id from sajet.SYS_KB_SHIFT_PARAM where shift_type =:SShiftType and Dept_iD = :SDeptID
6z85w3z5hwjxz	SELECT CARTON_NO FROM SAJET.G_PACK_CARTON WHERE CARTON_NO = :CARTON_NO and rownum = 1
75zns59wnsun5	SELECT EMP_ID FROM SAJET.SYS_EMP WHERE EMP_NO = :B1 AND ROWNUM = 1
78n1a9j26hsmj	select parame_value from SAJET.SYS_MODULE_PARAM where PARAME_ITEM='Check Repaired SN'and parame_name=:Terminal
7fudb35btggy9	SELECT SDT.MODEL_ID FROM SAJET.G_SN_STATUS SDT , SAJET.XXSFC_PART_BASE XPB, SAJET.SYS_PART SP WHERE SDT.SERIAL_NUMBER =:sSN AND XPB.PARAM_NAME = 'PACKING NO DEFECT' AND XPB.ENABLED= 'Y' AND SP.PART_ID= SDT.MODEL_ID AND XPB.PART_NO =SP.PART_NO
7nqdv7gfn9m5h	SELECT STL.TERMINAL_ID FROM SAJET.SYS_TERMINAL STL, SAJET.SYS_PDLINE SPE, SAJET.SYS_DEPT SDT WHERE STL.PDLINE_ID = SPE.PDLINE_ID AND SPE.DEPT_ID = SDT.DEPT_ID AND EXISTS (SELECT PARAM_NAME FROM SAJET.XXSFC_PART_BASE WHERE PARAM_NAME = 'PACKING NO DEFECT' AND ENABLED = 'Y' AND ATTRIBUTE1 LIKE '%' \|\| SDT.DEPT_NAME \|\| '%') AND STL.TERMINAL_ID = :sTerminalID
8700tc54uj1a8	begin SAJET.LITEONIT_PACK_GROUP_SN(:TTERMINALID, :TPROCESSID, :TREV, :TMODELID, :TCQTY, :TPQTY, :TDEFECT, :TNOW, :TEMP, :TPALLET, :TCARTON, :TFLAG, :TRES, :TNEXTPROC, :TCOMMAND); end;
8as8q1t607n43	SELECT B.WORK_ORDER, START_PROCESS_ID, END_PROCESS_ID, WO_STATUS, IN_PDLINE_TIME, OUT_PDLINE_TIME, NEXT_PROCESS FROM SAJET.G_WO_BASE A, SAJET.G_SN_STATUS B WHERE B.SERIAL_NUMBER = :B1 AND A.WORK_ORDER = B.WORK_ORDER AND ROWNUM = 1
8u5w8zd1ztb27	begin SAJET.BC_SERIAL_NUMBER(:TWO, :TBOX, :IQTY, :TEMPID, :TRES); end;
9b6awwm0g3sbz	SELECT COUNT(SERIAL_NUMBER) FROM SAJET.G_SN_STATUS WHERE QC_NO = :B1
9cz8ugdaupp1z	SELECT 1 FROM sajet.SYS_TERMINAL A, sajet.SYS_PDLINE B, sajet.SYS_DEPT C WHERE A.PDLINE_ID=B.PDLINE_ID AND B.DEPT_ID=C.DEPT_ID AND C.DEPT_NAME IN (SELECT PARAM_VALUE FROM sajet.SYS_BASE D WHERE PARAM_NAME='RE_CHECK_DEPT') AND A.TERMINAL_ID=:terminalid
9r7c9az4q3ptc	begin SAJET.XXSFC_ATE_INPUT(:TSAJET1, :TSAJET2, :TSAJET3, :TSAJET4, :TSAJET5, :TSAJET4TON, :TSAJET5TON, :TSAJET6TON, :TLINEID, :TSTAGEID, :TPROCESSID, :TTERMINALID, :TNOW, :TREV, :TRES, :TNEXTPROC); end;
9rrw9gqg56vg5	Select Param_value from sajet.sys_base where param_name =:Parameter
a324mp0rxs36f	SELECT ROWID FROM SAJET.G_SN_TRAVEL WHERE WORK_ORDER = :B3 AND SERIAL_NUMBER = :B2 AND PROCESS_ID = :B1 AND ROWNUM = 1
aghr6mrqgz9k1	SELECT A.WORK_ORDER, A.WORK_FLAG, A.MODEL_ID , A.CUSTOMER_SN, A.SERIAL_NUMBER, B.PART_NO , NVL(A.PALLET_NO, 'N/A') PALLET_NO, NVL(A.CARTON_NO, 'N/A') CARTON_NO , NVL(A.BOX_NO, 'N/A') BOX_NO FROM SAJET.G_SN_STATUS A , SAJET.SYS_PART B WHERE A.SERIAL_NUMBER = :SERIAL_NUMBER AND A.MODEL_ID = B.PART_ID(+) and rownum = 1
ahzrdg1bwwxvu	begin SAJET.LITEONIT_WO_INPUT_CHK_SN(:TREV, :TPROCESSID, :TTERMINALID, :TWO, :TNOW, :TEMP, :TRES); end;
an39btr6jjf54	INSERT INTO SAJET.G_SN_STATUS (WORK_ORDER, SERIAL_NUMBER, MODEL_ID, ROUTE_ID, VERSION, EMP_ID, BOX_NO) VALUES(:B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
bffgkt5cn40rv	SELECT SDT.DEPT_NAME FROM SAJET.SYS_PDLINE SPE, SAJET.SYS_DEPT SDT WHERE SPE.DEPT_ID = SDT.DEPT_ID AND SPE.PDLINE_ID = :s_Lid AND EXISTS (SELECT PARAM_NAME FROM SAJET.SYS_BASE SBE WHERE SBE.PARAM_NAME = :s_Para AND SBE.PARAM_VALUE = 'Y' AND SBE.ATTRIBUTE1 LIKE '%' \|\| SDT.DEPT_NAME \|\| '%') AND NOT EXISTS (SELECT PARAM_NAME FROM SAJET.SYS_BASE SBE WHERE SBE.PARAM_NAME = :s_Para AND SBE.PARAM_VALUE = 'Y' AND SBE.ATTRIBUTE2 LIKE '%' \|\| SPE.PDLINE_NAME \|\| '%')
brc7a8kf81mu2	SELECT * FROM SAJET.SYS_BASE WHERE PARAM_NAME=:s_Para AND PARAM_VALUE=:s_Dept AND ROWNUM=1
bs867h3gzj3kb	UPDATE SAJET.G_SN_STATUS SET QC_NO = :B2 , QC_RESULT ='N/A' WHERE PALLET_NO = :B1
ccn6904ssp56b	select * from sajet.sys_pdline where pdline_id =:LineID
cpd449q0d5f1u	select sysdate from dual
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
df2j8jfcxqq3x	SELECT NVL(COUNT(*), 0) FROM SAJET.G_SN_STATUS WHERE WORK_ORDER = :B1 AND WORK_FLAG='1'
fc2ya9u3y8mjv	select a1.attribute2 model_id from xxsfc_item_FG_model a1, sys_part b1 where a1.part_no = b1.part_no and b1.part_id =:PID
fd4r77pjv5m4q	SELECT ROUTE_ID FROM SAJET.G_SN_STATUS WHERE SERIAL_NUMBER = :B1 AND ROWNUM = 1
fm1k49q9qs8tc	SELECT PALLET_NO FROM SAJET.G_PACK_PALLET WHERE PALLET_NO = :PALLET_NO and rownum = 1
fqmpmkfr6pqyk	select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
fvja4ruj5yc6w	begin SAJET.SJ_PACKING_GO(:TTERMINALID, :TSN, :TNOW, :TRES, :TEMP, :PACKACTION, :PALLETNO, :CARTONNO, :BOXNO, :CUSTOMERSN); end;
gbgf5b8nt17uh	select * from sajet.sys_kb_param where param_type = 'C/T' and param_name =:NAME and param_name_type = 'LINE'
ghwctacrmmas7	SELECT BOX_NO, CARTON_NO, PALLET_NO FROM SAJET.G_SN_STATUS Where CARTON_NO=:sField and rownum=1
gjwsm7v34yygu	begin SAJET.SJ_QC_TRANSFER(:TQCNO, :TTERMINALID, :TEMPID, :TQCCNT, :TQCRESULT, :TSAMPLINGID, :TPALLETNODATA, :TSPLITSNDATA, :TPASSCLEAR, :TREJECTCLEAR, :TLOTMEMO, :TSAMPLINGLEVEL, :TRES); end;
grj717r05jsc2	UPDATE SAJET.G_SN_STATUS SET WORK_ORDER = :B6 , VERSION = :B5 , MODEL_ID = :B4 , PDLINE_ID = 0 , STAGE_ID = 0, PROCESS_ID =0, TERMINAL_ID = 0, CUSTOMER_SN = 'N/A', ROUTE_ID = :B3 , PALLET_NO = 'N/A', CARTON_NO = 'N/A', BOX_NO = 'N/A', NEXT_PROCESS = 0, QC_NO = 'N/A', QC_RESULT = 'N/A' , CUSTOMER_ID = :B2 , IN_PDLINE_TIME = NULL, OUT_PDLINE_TIME = NULL WHERE SERIAL_NUMBER= :B1 AND ROWNUM=1
gyqd8ncfrnja6	SELECT WORK_ORDER FROM SAJET.XXSFC_WO_FAI_SN WHERE WORK_ORDER=:sW AND ROWNUM=1

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	786,828	215.80	3.43
CPU used when call started	774,507	212.42	3.37
CR blocks created	504,756	138.44	2.20
Cached Commit SCN referenced	722,890	198.26	3.15
Commit SCN cached	61	0.02	0.00
DB time	4,351,556	1,193.46	18.96
DBWR checkpoint buffers written	533,595	146.34	2.32
DBWR checkpoints	12	0.00	0.00
DBWR thread checkpoint buffers written	417	0.11	0.00
DBWR transaction table writes	645	0.18	0.00
DBWR undo block writes	235,614	64.62	1.03
IMU CR rollbacks	27,985	7.68	0.12
IMU Flushes	59,374	16.28	0.26
IMU Redo allocation size	1,335,270,464	366,213.30	5,816.45
IMU commits	156,983	43.05	0.68
IMU contention	12,599	3.46	0.05
IMU ktichg flush	2	0.00	0.00
IMU pool not allocated	5,676	1.56	0.02
IMU recursive-transaction flush	2,211	0.61	0.01
IMU undo allocation size	3,017,219,968	827,507.32	13,143.03
IMU- failed to get a private strand	5,676	1.56	0.02
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
RowCR - row contention	52	0.01	0.00
RowCR attempts	394,708	108.25	1.72
RowCR hits	378,786	103.89	1.65
SMON posted for undo segment shrink	34	0.01	0.00
SQL*Net roundtrips to/from client	6,888,554	1,889.27	30.01
SQL*Net roundtrips to/from dblink	11,541	3.17	0.05
active txn count during cleanout	207,768	56.98	0.91
application wait time	51,272	14.06	0.22
background checkpoints completed	10	0.00	0.00
background checkpoints started	12	0.00	0.00
background timeouts	11,114	3.05	0.05
branch node splits	73	0.02	0.00
buffer is not pinned count	75,765,404	20,779.53	330.03
buffer is pinned count	446,552,781	122,472.24	1,945.19
bytes received via SQL*Net from client	716,971,396	196,637.66	3,123.13
bytes received via SQL*Net from dblink	1,762,589	483.41	7.68
bytes sent via SQL*Net to client	1,366,641,526	374,817.18	5,953.10
bytes sent via SQL*Net to dblink	61,638,198	16,904.99	268.50
calls to get snapshot scn: kcmgss	8,570,016	2,350.43	37.33
calls to kcmgas	1,011,332	277.37	4.41
calls to kcmgcs	205,605	56.39	0.90
change write time	35,020	9.60	0.15
cleanout - number of ktugct calls	229,087	62.83	1.00
cleanouts and rollbacks - consistent read gets	144,742	39.70	0.63
cleanouts only - consistent read gets	6,677	1.83	0.03
cluster key scan block gets	11,218	3.08	0.05
cluster key scans	2,115	0.58	0.01
commit batch performed	34	0.01	0.00
commit batch requested	34	0.01	0.00
commit batch/immediate performed	1,027	0.28	0.00
commit batch/immediate requested	1,027	0.28	0.00
commit cleanout failures: block lost	10	0.00	0.00
commit cleanout failures: buffer being written	19	0.01	0.00
commit cleanout failures: callback failure	10,117	2.77	0.04
commit cleanout failures: cannot pin	8,912	2.44	0.04
commit cleanouts	5,949,216	1,631.64	25.91
commit cleanouts successfully completed	5,930,158	1,626.41	25.83
commit immediate performed	993	0.27	0.00
commit immediate requested	993	0.27	0.00
commit txn count during cleanout	470,411	129.02	2.05
concurrency wait time	337,972	92.69	1.47
consistent changes	3,431,098	941.02	14.95
consistent gets	104,214,000	28,581.89	453.96
consistent gets - examination	26,859,310	7,366.48	117.00
consistent gets direct	8	0.00	0.00
consistent gets from cache	104,213,993	28,581.89	453.96
cursor authentications	688	0.19	0.00
data blocks consistent reads - undo records applied	3,309,370	907.63	14.42
db block changes	41,378,926	11,348.65	180.25
db block gets	36,671,571	10,057.60	159.74
db block gets direct	99	0.03	0.00
db block gets from cache	36,671,472	10,057.57	159.74
deferred (CURRENT) block cleanout applications	3,511,762	963.14	15.30
dirty buffers inspected	1,827	0.50	0.01
enqueue conversions	21,346	5.85	0.09
enqueue releases	881,773	241.84	3.84
enqueue requests	881,784	241.84	3.84
enqueue timeouts	7	0.00	0.00
enqueue waits	3,029	0.83	0.01
exchange deadlocks	130	0.04	0.00
execute count	6,340,764	1,739.03	27.62
failed probes on index block reclamation	45	0.01	0.00
free buffer inspected	491,434	134.78	2.14
free buffer requested	1,011,813	277.50	4.41
heap block compress	180,166	49.41	0.78
hot buffers moved to head of LRU	381,138	104.53	1.66
immediate (CR) block cleanout applications	151,419	41.53	0.66
immediate (CURRENT) block cleanout applications	467,577	128.24	2.04
index crx upgrade (found)	2,121	0.58	0.01
index crx upgrade (positioned)	917,791	251.71	4.00
index fast full scans (full)	74	0.02	0.00
index fetch by key	6,015,921	1,649.94	26.21
index scans kdiixs1	4,203,122	1,152.75	18.31
leaf node 90-10 splits	390	0.11	0.00
leaf node splits	22,363	6.13	0.10
lob reads	30,865	8.47	0.13
lob writes	26,215	7.19	0.11
lob writes unaligned	26,215	7.19	0.11
logons cumulative	538	0.15	0.00
messages received	382,646	104.95	1.67
messages sent	382,646	104.95	1.67
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	72,940,253	20,004.70	317.73
opened cursors cumulative	1,845,518	506.15	8.04
parse count (failures)	9	0.00	0.00
parse count (hard)	1,167	0.32	0.01
parse count (total)	1,843,277	505.54	8.03
parse time cpu	24,855	6.82	0.11
parse time elapsed	52,646	14.44	0.23
physical read IO requests	147,574	40.47	0.64
physical read bytes	1,327,030,272	363,953.33	5,780.55
physical read total IO requests	159,402	43.72	0.69
physical read total bytes	7,499,284,480	2,056,765.13	32,666.94
physical read total multi block requests	7,895	2.17	0.03
physical reads	161,991	44.43	0.71
physical reads cache	161,513	44.30	0.70
physical reads cache prefetch	14,808	4.06	0.06
physical reads direct	478	0.13	0.00
physical reads direct (lob)	2	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	5,202	1.43	0.02
physical write IO requests	238,627	65.45	1.04
physical write bytes	4,393,140,224	1,204,869.30	19,136.55
physical write total IO requests	434,695	119.22	1.89
physical write total bytes	16,668,994,560	4,571,663.73	72,610.27
physical write total multi block requests	232,804	63.85	1.01
physical writes	536,272	147.08	2.34
physical writes direct	569	0.16	0.00
physical writes direct (lob)	6	0.00	0.00
physical writes from cache	535,703	146.92	2.33
physical writes non checkpoint	361,631	99.18	1.58
pinned buffers inspected	51	0.01	0.00
pinned cursors current	5	0.00	0.00
prefetch warmup blocks aged out before use	66,943	18.36	0.29
prefetched blocks aged out before use	8	0.00	0.00
process last non-idle time	3,638	1.00	0.02
recovery blocks read	0	0.00	0.00
recursive calls	6,140,737	1,684.17	26.75
recursive cpu usage	445,841	122.28	1.94
redo blocks read for recovery	0	0.00	0.00
redo blocks written	11,934,084	3,273.06	51.98
redo buffer allocation retries	174	0.05	0.00
redo entries	17,285,368	4,740.71	75.30
redo log space requests	234	0.06	0.00
redo log space wait time	2,320	0.64	0.01
redo ordering marks	235,463	64.58	1.03
redo size	5,864,634,900	1,608,443.66	25,546.40
redo subscn max counts	339,021	92.98	1.48
redo synch time	1,051,040	288.26	4.58
redo synch writes	187,711	51.48	0.82
redo wastage	45,853,372	12,575.82	199.74
redo write time	123,139	33.77	0.54
redo writer latching time	5,505	1.51	0.02
redo writes	145,753	39.97	0.63
rollback changes - undo records applied	13,526	3.71	0.06
rollbacks only - consistent read gets	358,934	98.44	1.56
rows fetched via callback	5,250,895	1,440.12	22.87
session connect time	0	0.00	0.00
session cursor cache hits	1,827,096	501.10	7.96
session logical reads	140,884,875	38,639.30	613.70
shared hash latch upgrades - no wait	1,471,978	403.71	6.41
shared hash latch upgrades - wait	2,123	0.58	0.01
sorts (memory)	127,491	34.97	0.56
sorts (rows)	3,498,656	959.55	15.24
sql area evicted	40	0.01	0.00
sql area purged	51	0.01	0.00
summed dirty queue length	251,436	68.96	1.10
switch current to new buffer	16,592	4.55	0.07
table fetch by rowid	249,705,205	68,484.53	1,087.72
table fetch continued row	18,660,170	5,117.77	81.28
table scan blocks gotten	5,868,530	1,609.51	25.56
table scan rows gotten	711,210,743	195,057.74	3,098.04
table scans (long tables)	0	0.00	0.00
table scans (short tables)	1,136,886	311.80	4.95
total number of times SMON posted	34	0.01	0.00
transaction rollbacks	1,027	0.28	0.00
undo change vector size	2,163,689,916	593,416.88	9,425.05
user I/O wait time	298,480	81.86	1.30
user calls	5,346,279	1,466.28	23.29
user commits	221,059	60.63	0.96
user rollbacks	8,509	2.33	0.04
workarea executions - optimal	107,000	29.35	0.47
write clones created in background	1	0.00	0.00
write clones created in foreground	83	0.02	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 pga memory max	982,943,592	1,737,314,224
session cursor cache count	17,387	31,249
session uga memory	2.0E+11	5.2E+11
opened cursors current	11,373	14,045
workarea memory allocated	0	196
logons current	374	428
session uga memory max	536,572,248	822,756,400
session pga memory	330,037,160	444,889,712

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)	12	11.85

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	53,286	15	22.31	1.03	113,877	31	1,206	32.02
SYSTRAVELIDX	29,667	8	22.48	1.04	56,114	15	983	60.60
SYSSN	23,860	7	12.13	1.05	22,874	6	794	26.89
UNDOTBS1	17	0	19.41	1.00	15,668	4	2,534	27.84
SYSTRAVEL	8,538	2	24.79	1.04	5,147	1	123	92.76
SYSRTIDX	7,115	2	23.05	1.02	6,443	2	3	6.67
SYSKPIDX	4,727	1	17.22	1.03	6,701	2	1	230.00
SYSRT	7,687	2	14.18	1.00	2,429	1	1,200	30.54
SMTRTIDX	4,035	1	22.65	1.03	4,722	1	1	80.00
SMTRT	3,751	1	20.87	1.63	754	0	7	30.00
SYSBS	841	0	16.69	6.50	851	0	0	0.00
SYSSPCIDX	441	0	14.74	1.05	1,149	0	5	0.00
SYSAUX	1,037	0	30.25	1.81	305	0	0	0.00
SYSTEM	1,179	0	13.49	1.42	147	0	2	10.00
SYSREPAIRIDX	525	0	18.00	1.04	631	0	0	0.00
SYSBSIDX	538	0	34.42	1.08	611	0	0	0.00
SYSKP	243	0	18.85	1.06	470	0	0	0.00
SYSREPAIR	207	0	31.06	1.04	192	0	0	0.00
SYSSPC	142	0	16.20	1.13	174	0	0	0.00
SMTBS	161	0	10.06	9.70	44	0	0	0.00
T_TEMP1	1	0	10.00	1.00	83	0	0	0.00
SMTBSIDX	26	0	23.85	1.00	21	0	0	0.00
SYSMISC	11	0	18.18	1.00	10	0	0	0.00
SYSMISCIDX	11	0	19.09	1.00	10	0	0	0.00
TBSSTATS	11	0	18.18	1.00	10	0	0	0.00
USERS	11	0	29.09	1.00	10	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\BHPSFCDB\ORADATA\SMTBS01.DBF	161	0	10.06	9.70	44	0	0	0.00
SMTBSIDX	T:\ORACLE\BHPSFCDB\ORADATA\SMTBSIDX01.DBF	26	0	23.85	1.00	21	0	0	0.00
SMTRT	T:\ORACLE\BHPSFCDB\ORADATA\SMTRT01.DBF	3,751	1	20.87	1.63	754	0	7	30.00
SMTRTIDX	T:\ORACLE\BHPSFCDB\ORADATA\SMTRTIDX01.DBF	4,035	1	22.65	1.03	4,722	1	1	80.00
SYSAUX	T:\ORACLE\BHPSFCDB\ORADATA\SYSAUX01.DBF	1,037	0	30.25	1.81	305	0	0	0.00
SYSBS	T:\ORACLE\BHPSFCDB\ORADATA\SYSBS01.DBF	841	0	16.69	6.50	851	0	0	0.00
SYSBSIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSBSIDX01.DBF	538	0	34.42	1.08	611	0	0	0.00
SYSKP	T:\ORACLE\BHPSFCDB\ORADATA\SYSKP01.DBF	243	0	18.85	1.06	470	0	0	0.00
SYSKPIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSKPIDX01.DBF	4,727	1	17.22	1.03	6,701	2	1	230.00
SYSMISC	T:\ORACLE\BHPSFCDB\ORADATA\SYSMISC01.DBF	11	0	18.18	1.00	10	0	0	0.00
SYSMISCIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSMISCIDX01.DBF	11	0	19.09	1.00	10	0	0	0.00
SYSREPAIR	T:\ORACLE\BHPSFCDB\ORADATA\SYSREPAIR01.DBF	207	0	31.06	1.04	192	0	0	0.00
SYSREPAIRIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSREPAIRIDX01.DBF	525	0	18.00	1.04	631	0	0	0.00
SYSRT	T:\ORACLE\BHPSFCDB\ORADATA\SYSRT01.DBF	7,687	2	14.18	1.00	2,429	1	1,200	30.54
SYSRTIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSRTIDX01.DBF	3,947	1	25.75	1.02	3,236	1	2	5.00
SYSRTIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSRTIDX02.DBF	3,168	1	19.68	1.03	3,207	1	1	10.00
SYSSN	T:\ORACLE\BHPSFCDB\ORADATA\SYSSN01.DBF	13,034	4	12.18	1.05	13,509	4	461	15.97
SYSSN	T:\ORACLE\BHPSFCDB\ORADATA\SYSSN02.DBF	10,826	3	12.07	1.05	9,365	3	333	42.01
SYSSNIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSSNIDX01.DBF	9,608	3	21.39	1.02	18,866	5	428	8.74
SYSSNIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSSNIDX02.DBF	9,531	3	19.62	1.02	18,717	5	400	19.18
SYSSNIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSSNIDX03.DBF	12,952	4	20.79	1.03	25,204	7	328	77.50
SYSSNIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSSNIDX04.DBF	14,383	4	26.21	1.05	35,479	10	42	15.71
SYSSNIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSSNIDX05.DBF	6,812	2	22.05	1.03	15,611	4	8	141.25
SYSSPC	T:\ORACLE\BHPSFCDB\ORADATA\SYSSPC01.DBF	142	0	16.20	1.13	174	0	0	0.00
SYSSPCIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSSPCIDX01.DBF	441	0	14.74	1.05	1,149	0	5	0.00
SYSTEM	T:\ORACLE\BHPSFCDB\ORADATA\SYSTEM01.DBF	1,179	0	13.49	1.42	147	0	2	10.00
SYSTRAVEL	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVEL01.DBF	441	0	25.96	1.04	288	0	1	230.00
SYSTRAVEL	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVEL02.DBF	560	0	39.46	1.04	481	0	0	0.00
SYSTRAVEL	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVEL03.DBF	779	0	18.28	1.06	332	0	1	40.00
SYSTRAVEL	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVEL04.DBF	1,569	0	24.26	1.09	1,405	0	29	304.48
SYSTRAVEL	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVEL05.DBF	3,328	1	25.31	1.03	1,914	1	88	26.25
SYSTRAVEL	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVEL06.DBF	1,705	0	21.99	1.00	475	0	4	0.00
SYSTRAVEL	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVEL07.DBF	156	0	26.03	1.00	252	0	0	0.00
SYSTRAVELIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVELIDX01.DBF	3,699	1	22.87	1.05	8,055	2	57	24.74
SYSTRAVELIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVELIDX02.DBF	1,786	0	19.47	1.03	3,143	1	48	7.50
SYSTRAVELIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVELIDX03.DBF	1,820	0	17.43	1.01	3,214	1	0	0.00
SYSTRAVELIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVELIDX04.DBF	2,587	1	23.19	1.02	4,180	1	54	15.93
SYSTRAVELIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVELIDX05.DBF	3,284	1	18.30	1.06	6,012	2	66	8.33
SYSTRAVELIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVELIDX06.DBF	3,896	1	26.62	1.07	9,302	3	149	18.99
SYSTRAVELIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVELIDX07.DBF	2,691	1	21.27	1.04	2,334	1	575	91.11
SYSTRAVELIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVELIDX08.DBF	1,702	0	23.45	1.01	3,248	1	11	10.91
SYSTRAVELIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVELIDX09.DBF	6,177	2	24.12	1.03	12,101	3	23	45.65
SYSTRAVELIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVELIDX10.DBF	2,007	1	22.79	1.06	4,515	1	0	0.00
SYSTRAVELIDX	T:\ORACLE\BHPSFCDB\ORADATA\SYSTRAVELIDX11.DBF	18	0	15.00	1.00	10	0	0	0.00
TBSSTATS	T:\ORACLE\BHPSFCDB\ORADATA\TBSSTATS01.DBF	11	0	18.18	1.00	10	0	0	0.00
T_TEMP1	T:\ORACLE\BHPSFCDB\ORADATA\T_TEMP5	0	0			77	0	0
T_TEMP1	T:\ORACLE\BHPSFCDB\ORADATA\T_TEMP6	1	0	10.00	1.00	6	0	0
UNDOTBS1	T:\ORACLE\BHPSFCDB\ORADATA\UNDOTBS01.DBF	17	0	19.41	1.00	15,668	4	2,534	27.84
USERS	T:\ORACLE\BHPSFCDB\ORADATA\USERS01.DBF	11	0	29.09	1.00	10	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	395,800	100	140,853,387	161,808	536,387	0	0	6,858

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	42	32402	394443	3675532	3686400	3675532
E	0	103	96006	2663108	3686400	3686400	7568052

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	320	0.10	39,580	4.47	1,866,114
D	640	0.20	79,160	2.48	1,034,023
D	960	0.30	118,740	1.48	618,488
D	1,280	0.40	158,320	1.23	512,448
D	1,600	0.50	197,900	1.13	470,106
D	1,920	0.60	237,480	1.08	449,366
D	2,240	0.70	277,060	1.05	437,956
D	2,560	0.80	316,640	1.03	429,446
D	2,880	0.90	356,220	1.01	422,760
D	3,200	1.00	395,800	1.00	417,174
D	3,520	1.10	435,380	0.99	413,641
D	3,840	1.20	474,960	0.98	410,218
D	4,160	1.30	514,540	0.98	407,784
D	4,480	1.40	554,120	0.97	406,432
D	4,800	1.50	593,700	0.97	405,308
D	5,120	1.60	633,280	0.97	404,902
D	5,440	1.70	672,860	0.97	404,742
D	5,760	1.80	712,440	0.97	404,547
D	6,080	1.90	752,020	0.97	404,531
D	6,400	2.00	791,600	0.97	404,531

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	24,358	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	2,048	1,684	317.16	0.07	0.02	100.00	0.00	209,710
E	2,048	1,651	371.76	0.09	0.02	100.00	0.00	209,710

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	75,347	75,347
64K	128K	1,557	1,557
128K	256K	134	134
256K	512K	78	78
512K	1024K	29,812	29,812
1M	2M	73	73
2M	4M	54	54
4M	8M	6	6

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 PGA Cache Hit %
256	0.13	38,261.10	100.00
512	0.25	38,261.10	100.00
1,024	0.50	38,261.10	100.00
1,536	0.75	38,261.10	100.00
2,048	1.00	38,261.10	100.00
2,458	1.20	38,261.10	100.00
2,867	1.40	38,261.10	100.00
3,277	1.60	38,261.10	100.00
3,686	1.80	38,261.10	100.00
4,096	2.00	38,261.10	100.00
6,144	3.00	38,261.10	100.00
8,192	4.00	38,261.10	100.00
12,288	6.00	38,261.10	100.00
16,384	8.00	38,261.10	100.00

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)
384	0.55	90	7,509	111,423	1.00	894	1.00	7,066
464	0.66	90	7,509	111,423	1.00	894	1.00	7,066
544	0.77	90	7,509	111,423	1.00	894	1.00	7,066
624	0.89	90	7,509	111,423	1.00	894	1.00	7,066
704	1.00	90	7,509	111,423	1.00	894	1.00	7,066
784	1.11	90	7,509	111,423	1.00	894	1.00	7,066
864	1.23	90	7,509	111,423	1.00	894	1.00	7,066
944	1.34	90	7,509	111,423	1.00	894	1.00	7,066
1,024	1.45	90	7,509	111,423	1.00	894	1.00	7,066
1,104	1.57	90	7,509	111,423	1.00	894	1.00	7,066
1,184	1.68	90	7,509	111,423	1.00	894	1.00	7,066
1,264	1.80	90	7,509	111,423	1.00	894	1.00	7,066
1,344	1.91	90	7,509	111,423	1.00	894	1.00	7,066
1,424	2.02	90	7,509	111,423	1.00	894	1.00	7,066

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,024	0.25	67,691	1,884,052
2,048	0.50	44,899	516,093
3,072	0.75	43,503	432,410
4,096	1.00	43,239	416,540
5,120	1.25	43,118	409,292
6,144	1.50	43,088	407,459
7,168	1.75	43,089	407,459
8,192	2.00	43,090	407,459

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	4,314	168	39
undo block	1,527	52	34
undo header	1,006	18	18
1st level bmb	8	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 (row lock contention)	660	660	658	511	777.30
TX-Transaction (index contention)	2,374	2,374	2,366	220	93.17
SQ-Sequence Cache	432	432	1	1	891.00
CF-Controlfile Transaction	1,944	1,944	2	0	23.50

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	323.61	289,511	2,564	72	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
10-Sep 14:01	109,176	49,552	132	20	180	0/0	0/0/0/0/0/0
10-Sep 13:51	76,800	57,865	107	22	180	0/0	0/0/0/0/0/0
10-Sep 13:41	27,066	39,419	122	72	180	0/0	0/0/0/0/0/0
10-Sep 13:31	24,109	40,934	2,564	53	180	0/0	0/0/0/0/0/0
10-Sep 13:21	36,754	35,752	1,960	50	180	0/0	0/0/0/0/0/0
10-Sep 13:11	26,339	33,050	1,355	19	180	0/0	0/0/0/0/0/0
10-Sep 13:01	23,366	32,939	82	12	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	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,600	0.00		0	0
AWR Alerted Metric Element list	44,662	0.00		0	0
Consistent RBA	145,972	0.04	0.03	0	0
FAL request queue	93	0.00		0	0
FAL subheap alocation	93	0.00		0	0
FIB s.o chain latch	84	0.00		0	0
FOB s.o list latch	2,353	0.00		0	0
In memory undo latch	4,876,367	0.17	0.93	282	225,910	0.00
JS mem alloc latch	6	0.00		0	0
JS queue access latch	6	0.00		0	0
JS queue state obj latch	21,450	0.00		0	0
JS slv state obj latch	106	0.00		0	0
KMG MMAN ready and startup request latch	1,197	0.00		0	0
KTF sga latch	4,616	0.00		0	1,219	0.00
KWQMN job cache list latch	28	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	0			0	1,197	0.00
NLS data objects	1	0.00		0	0
OS process	597	0.00		0	0
OS process allocation	1,620	0.00		0	0
OS process: request allocation	170	0.00		0	0
PL/SQL warning settings	330,524	0.00		0	0
SGA IO buffer pool latch	2,130	0.14	1.00	0	2,130	0.14
SQL memory manager latch	1	0.00		0	1,149	0.00
SQL memory manager workarea list latch	212,828	0.00	0.00	0	0
Shared B-Tree	130	0.00		0	0
active checkpoint queue latch	237,211	0.00		0	0
active service list	9,286	0.00		0	2,329	0.00
address list	368	0.00		0	0
alert log latch	24	0.00		0	0
archive control	156	0.00		0	0
archive process latch	1,359	0.00		0	0
begin backup scn array	12	0.00		0	0
cache buffer handles	74,633	0.01	0.20	0	0
cache buffers chains	355,933,980	0.02	0.19	456	1,001,811	0.13
cache buffers lru chain	1,144,454	0.31	0.50	21	1,507,314	1.21
cache table scan latch	0			0	803	0.00
channel handle pool latch	170	0.00		0	0
channel operations parent latch	18,051	0.00		0	0
checkpoint queue latch	2,668,418	0.03	0.18	4	565,984	0.19
client/application info	2,839	0.00		0	0
commit callback allocation	12	0.00		0	0
compile environment latch	538	0.00		0	0
dml lock allocation	1,150,308	0.22	0.30	62	0
dummy allocation	1,022	0.00		0	0
enqueue hash chains	1,789,477	0.11	0.29	65	655	0.00
enqueues	691,195	0.03	0.32	1	0
event group latch	95	0.00		0	0
event range base latch	1	0.00		0	0
file cache latch	894	0.00		0	0
global KZLD latch for mem in SGA	398	0.00		0	0
global tx hash mapping	18,154	0.00		0	0
hash table column usage latch	943	0.00		0	106,485	0.00
hash table modification latch	86	0.00		0	0
internal temp table object number allocation latc	18	0.00		0	0
interrupt manipulation	36	0.00		0	0
job workq parent latch	0			0	150	0.00
job_queue_processes free list latch	1	0.00		0	0
job_queue_processes parameter latch	127	0.00		0	0
kks stats	2,359	0.00		0	0
kmcptab latch	5,464	0.00		0	0
kmcpvec latch	0			0	5,460	0.07
kokc descriptor allocation latch	4,612	0.00		0	0
ksuosstats global area	244	0.00		0	0
ktm global data	111	0.00		0	0
kwqbsn:qsga	130	0.00		0	0
lgwr LWN SCN	146,191	0.06	0.03	0	0
library cache	7,938,228	0.55	0.37	1760	31	0.00
library cache load lock	1,864	0.00		0	0
library cache lock	14,144,139	0.07	0.23	82	0
library cache lock allocation	7,462	0.01	0.00	0	0
library cache pin	4,611,111	0.24	0.15	41	0
library cache pin allocation	209,235	0.04	0.28	0	0
list of block allocation	221,783	0.02	0.22	0	0
loader state object freelist	162	0.00		0	0
longop free list parent	9	0.00		0	9	0.00
messages	945,840	0.05	0.26	7	0
mostly latch-free SCN	147,889	0.70	0.09	1	0
multiblock read objects	5,966	0.00		0	0
ncodef allocation latch	90	0.00		0	0
object queue header heap	474,998	0.00		0	708	0.00
object queue header operation	3,158,693	0.19	0.36	29	0
object stats modification	171	0.00		0	0
parallel query alloc buffer	468	0.00		0	0
parameter list	1,317	0.00		0	0
parameter table management	1,027	0.00		0	0
post/wait queue	241,408	0.10	0.30	9	224,625	0.08
process allocation	170	0.00		0	95	0.00
process group creation	170	0.00		0	0
qmn task queue latch	520	0.00		0	0
redo allocation	941,050	0.39	0.25	11	17,279,581	0.22
redo copy	0			0	17,288,955	0.08
redo writing	715,606	0.08	0.40	2	0
resmgr group change latch	498	0.00		0	0
resmgr:active threads	1,005	0.00		0	0
resmgr:actses change group	476	0.00		0	0
resmgr:free threads list	1,004	0.00		0	0
resmgr:resource group CPU method	422	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	3,138,296	0.16	0.24	39	2	0.00
rules engine aggregate statistics	1	0.00		0	0
rules engine rule set statistics	2	0.00		0	0
sequence cache	28,238	0.01	0.00	0	0
session allocation	1,175,834	0.21	0.28	41	0
session idle bit	11,289,449	0.03	0.23	31	0
session state list latch	1,470	0.00		0	0
session switching	465	0.00		0	0
session timer	1,870	0.00		0	0
shared pool	976,187	1.18	0.77	227	0
shared pool sim alloc	95	0.00		0	0
shared pool simulator	4,132	0.00		0	0
simulator hash latch	8,494,718	0.01	0.26	3	0
simulator lru latch	536,275	0.97	0.26	10	7,902,367	1.57
slave class	9	0.00		0	0
slave class create	36	2.78	1.00	0	0
sort extent pool	180	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	336	0.00		0	0
temp lob duration state obj allocation	1	0.00		0	0
temporary table state object allocation	2	0.00		0	0
threshold alerts latch	679	0.00		0	0
trace latch	23	0.00		0	0
transaction allocation	11,418	0.01	1.00	0	0
transaction branch allocation	3,542	0.06	0.50	0	0
undo global data	2,369,872	0.03	0.15	2	0
user lock	1,640	0.24	0.75	0	0
virtual circuit buffers	29,725,010	0.12	0.81	4221	0
virtual circuit queues	12,880,517	0.16	0.24	28	0
virtual circuits	6,249,420	0.96	0.34	1503	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	355,933,980	65,030	12,351	53,252
virtual circuits	6,249,420	59,720	20,312	40,396
library cache	7,938,228	43,520	16,161	28,284
virtual circuit buffers	29,725,010	35,788	28,965	8,193
virtual circuit queues	12,880,517	20,030	4,830	15,326
shared pool	976,187	11,516	8,894	3,105
library cache pin	4,611,111	10,993	1,625	9,428
library cache lock	14,144,139	10,389	2,380	8,101
In memory undo latch	4,876,367	8,466	7,865	1,024
object queue header operation	3,158,693	6,152	2,195	4,146
simulator lru latch	536,275	5,212	1,333	4,045
row cache objects	3,138,296	5,135	1,219	3,958
redo allocation	941,050	3,647	927	2,747
cache buffers lru chain	1,144,454	3,574	1,796	1,928
session idle bit	11,289,449	3,264	766	2,516
dml lock allocation	1,150,308	2,533	756	1,811
session allocation	1,175,834	2,450	694	1,791
enqueue hash chains	1,789,477	2,054	601	1,490
mostly latch-free SCN	147,889	1,036	98	942
checkpoint queue latch	2,668,418	676	123	572
undo global data	2,369,872	626	97	542
redo writing	715,606	587	235	374
simulator hash latch	8,494,718	527	135	406
messages	945,840	504	130	381
post/wait queue	241,408	249	75	175
enqueues	691,195	233	74	162
lgwr LWN SCN	146,191	95	3	92
library cache pin allocation	209,235	87	24	64
Consistent RBA	145,972	58	2	56
list of block allocation	221,783	51	11	41
cache buffer handles	74,633	5	1	4
user lock	1,640	4	3	1
SGA IO buffer pool latch	2,130	3	3	0
transaction branch allocation	3,542	2	1	1
slave class create	36	1	1	0
transaction allocation	11,418	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	5,380	2,514
In memory undo latch	kticmt: child	1,969	864
In memory undo latch	ktichg: child	639	4,049
In memory undo latch	kturbk	381	931
In memory undo latch	ktiTxnPoolFree	7	17
In memory undo latch	ktiBRacquire	1	0
SGA IO buffer pool latch	ksfd_free_sgabuffer	2	3
SGA IO buffer pool latch	ksfd_alloc_sgabuffer	1	0
cache buffer handles	kcbzgs	1	1
cache buffers chains	kcbgtcr: fast path	8,301	2,161
cache buffers chains	kcbgtcr: kslbegin excl	6,594	6,070
cache buffers chains	kcbgcur: kslbegin	1,340	1,406
cache buffers chains	kcbchg: kslbegin: bufs not pinned	1,088	1,745
cache buffers chains	kcbrls: kslbegin	979	4,939
cache buffers chains	kcbget: pin buffer	781	527
cache buffers chains	kcbzgb: scan from tail. nowait	506	0
cache buffers chains	kcbnlc	221	328
cache buffers chains	kcbzwb	211	44
cache buffers chains	kcbget: exchange rls	183	372
cache buffers chains	kcbget: exchange	68	642
cache buffers chains	kcbchg: kslbegin: call CR func	58	1,668
cache buffers chains	kcbcge	26	38
cache buffers chains	kcbnew: new latch again	26	8
cache buffers chains	kcbbic1	18	2
cache buffers chains	kcbbxsv	15	1
cache buffers chains	kcb_pre_apply: kcbhq61	6	294
cache buffers chains	kcbbic2	4	3
cache buffers chains	kcbgkcbcr	3	38
cache buffers chains	kcbzhngcbk1: get hash chain latch no wait	3	0
cache buffers chains	kcb_post_apply: kcbhq62	2	59
cache buffers chains	kcbgtcr: kslbegin shared	2	0
cache buffers chains	kcbnew_1	2	1
cache buffers chains	kcb_is_private	1	117
cache buffers chains	kcbesc: escalate	1	3
cache buffers chains	kcbgtcr	1	0
cache buffers chains	kcbso1: set no access	1	0
cache buffers lru chain	kcbzgws	1,630	90
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	76	0
cache buffers lru chain	kcbzib	24	6
cache buffers lru chain	kcbzgb: posted for free bufs	19	80
cache buffers lru chain	kcbbxsv: move to being written	18	695
cache buffers lru chain	kcbzswcu	16	37
cache buffers lru chain	kcbzgpwb: KSLBEGIN use prewarm buffers	8	43
cache buffers lru chain	kcbbic2	4	804
cache buffers lru chain	kcbibr	1	36
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	99	0
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	13	41
checkpoint queue latch	kcbkubc	5	51
checkpoint queue latch	kcbbcthc: check thread queue	3	26
checkpoint queue latch	kcbswcu: Switch buffers	2	19
checkpoint queue latch	kcbkllrba: compute lowest lrba	1	7
cost function	kzulgt: find user res	3	3
dml lock allocation	ktaiam	475	557
dml lock allocation	ktaidm	281	199
enqueue hash chains	ksqgtl3	325	387
enqueue hash chains	ksqrcl	256	204
enqueue hash chains	ksqcnl	12	5
enqueue hash chains	ksqcmi: get hash chain latch after wait	7	4
enqueue hash chains	ksucallcbksafely: ksqhngcbk1	1	0
enqueues	ksqies	31	59
enqueues	ksqgel: create enqueue	27	8
enqueues	ksqdel	16	7
event range base latch	No latch	1,665	2,195
lgwr LWN SCN	kcs023	68	0
library cache	kglpndl: child: after processing	6,876	670
library cache	kglpnp: child	3,988	5,898
library cache	kgldte: child 0	2,283	1,919
library cache	kglpndl: child: before processing	1,733	5,126
library cache	kglobpn: child:	996	2,309
library cache	kglLockCursor	56	31
library cache	kglic	56	7
library cache	kglhdgn: child:	47	114
library cache	kgldti: 2child	36	25
library cache	kglpin	31	18
library cache	kglukp: child	10	11
library cache	kgldtld: 2child	8	4
library cache	kglhdgc: child:	4	3
library cache	kglnti	4	0
library cache	kglati	2	1
library cache	kglrtl	2	4
library cache	kglini: child	1	1
library cache	kglobld	1	6
library cache	kglpur: child	1	1
library cache lock	kgllkal: child: multiinstance	387	134
library cache lock	kgllkdl: child: cleanup	327	51
library cache lock	kgllkdl: child: no lock handle	25	13
library cache lock	kglhdcb: child	1	0
library cache pin	kglpndl	1,069	892
library cache pin	kglpnp: child	498	611
library cache pin	kglpnal: child: alloc space	58	122
library cache pin allocation	kglpnrel	15	15
library cache pin allocation	kglpnget	9	9
list of block allocation	ktlabl	8	7
list of block allocation	ktlbbl	3	5
messages	ksaamb: after wakeup	53	65
messages	ksarcv	52	46
messages	ksarcv: after wait	25	19
mostly latch-free SCN	kcslcu3	30	101
mostly latch-free SCN	kcs024	3	0
mostly latch-free SCN	kcsnew_scn_rba	2	0
object queue header operation	kcbo_switch_cq	1,486	1,492
object queue header operation	kcbw_unlink_q	911	522
object queue header operation	kcbw_link_q	577	304
object queue header operation	kcbo_switch_mq_bg	537	810
object queue header operation	kcbo_switch_q_bg	256	185
object queue header operation	kcbo_swap_buf_bg	30	480
object queue header operation	kcbo_swap_buf	12	16
post/wait queue	ksliwat:remove	35	66
post/wait queue	ksliwat:add:nowait	21	0
post/wait queue	kslpstevent:get	10	6
post/wait queue	kslpstevent:reget	9	2
redo allocation	kcrfw_redo_gen: redo allocation 1	880	0
redo allocation	kcrfw_redo_write: before write	17	396
redo allocation	kcrfw_redo_gen: redo allocation 3	15	150
redo allocation	kcrfw_redo_gen: redo allocation 2	10	0
redo allocation	kcrfw_redo_write: more space	5	381
redo writing	kcrfwcr	121	112
redo writing	kcrfw_post: rba scn pair	53	1
redo writing	kcrfw_cal_target_rba	39	60
redo writing	kcrfw_post: after write	21	59
redo writing	kcrfsr: rba scn pair	1	3
row cache objects	kqreqd: reget	727	73
row cache objects	kqrpre: find obj	381	902
row cache objects	kqreqd	106	229
row cache objects	kqrso	5	15
session allocation	ksuxds: not user session	335	246
session allocation	ksucri	302	447
session allocation	ksufap: active sessions	34	0
session allocation	ksuxds: KSUSFCLC not set	13	0
session allocation	ksuprc	7	1
session allocation	ksudlc	2	0
session allocation	ksuxds: KSUSFCLC set	1	0
session idle bit	ksupuc: set busy	552	351
session idle bit	ksupuc: clear busy	258	442
session idle bit	ksuxds	61	78
shared pool	kghalo	3,699	2,457
shared pool	kghfre	2,710	2,687
shared pool	kghupr1	2,416	3,691
shared pool	kghalp	65	47
shared pool	kghasp	1	10
shared pool	kghfnd: get next extent	1	0
simulator hash latch	kcbsacc: lookup dba	95	125
simulator hash latch	kcbs_get_or_extract_simbufseq	24	7
simulator hash latch	kcbs_lookup_setid: lookup dba	14	2
simulator hash latch	kcbsacc: insert dba	2	0
simulator lru latch	kcbs_simulate: simulate set	1,329	0
simulator lru latch	kcbs_lookup_setid	4	0
slave class create	ksvcreate	1	0
transaction allocation	ktcdso	1	0
transaction branch allocation	ktcbba	1	1
undo global data	ktudba: KSLBEGIN	51	45
undo global data	ktudnx:child	32	18
undo global data	ktubnd:child	10	4
undo global data	ktufrbs: child	4	30
virtual circuit queues	kmcadq	2,930	3,480
virtual circuit queues	kmcfsq	1,900	1,350
virtual circuits	kmcmbuf: move ckt	13,191	6,547
virtual circuits	kmcgms: if shared server	12,754	27,824
virtual circuits	kmcgms	7,113	13,754
virtual circuits	kmcfms	7,052	498
virtual circuits	kmcgms: if called with non-zero ckt	4,918	21
virtual circuits	kmcmbf	3,087	82
virtual circuits	kmcgbf	693	39
virtual circuits	kmcgms: if not shared server	459	501
virtual circuits	kmcfre	2	5
virtual circuits	kmcdvc	1	0
virtual circuits	kmcrst	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: 140,884,875
Captured Segments account for 88.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SAJET	SYSSN	G_SN_STATUS	TABLE	75,594,800	53.66
SAJET	SYSSNIDX	G_SN_STATUS_IDX	INDEX	9,333,664	6.63
SAJET	SYSSNIDX	G107_WO	INDEX	2,069,184	1.47
SAJET	SYSBS	XXSFC_PART_BASE	TABLE	1,768,704	1.26
SAJET	SYSRTIDX	RT_WO_IDX	INDEX	1,645,664	1.17

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 161,991
Captured Segments account for 75.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SAJET	SYSSN	G_SN_STATUS	TABLE	23,775	14.68
SAJET	SYSTRAVELIDX	G_SN_TRAVEL_IDX	INDEX	12,196	7.53
SAJET	SYSTRAVEL	G_SN_TRAVEL	TABLE	7,814	4.82
SAJET	SYSSNIDX	G_SN_STATUS_IN_PROCESS_IDX	INDEX	6,580	4.06
SAJET	SYSSNIDX	G_SN_STATUS_OUT_PROCESS_IDX	INDEX	6,179	3.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
SAJET	SYSTRAVELIDX	G_SN_TRAVEL_OUT_PROCESS_IDX	INDEX	1,245	33.33
SAJET	SYSSNIDX	G_SN_STATUS_OUT_PROCESS_IDX	INDEX	1,086	29.08
SAJET	SYSRT	G_WO_BASE	TABLE	862	23.08
SAJET	SYSRT	G_SN_COUNT	TABLE	456	12.21
SAJET	SYSTRAVELIDX	G_SN_TRAVEL_SHIP_ID_IDX	INDEX	19	0.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	1,091	25.89
SAJET	SYSRT	G_WO_BASE	TABLE	958	22.73
SAJET	SYSTRAVELIDX	G_SN_TRAVEL_OUT_PROCESS_IDX	INDEX	927	22.00
SAJET	SYSSN	G_SN_STATUS	TABLE	776	18.41
SAJET	SYSRT	G_SN_COUNT	TABLE	236	5.60

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	68	0.00	2	1
dc_database_links	17,153	0.00	0	3
dc_files	47	100.00	0	47
dc_global_oids	2,402	0.21	0	136
dc_histogram_data	9,098	5.94	0	1,515
dc_histogram_defs	17,002	7.65	0	5,382
dc_object_grants	633,973	0.00	0	167
dc_object_ids	30,416	0.65	0	1,680
dc_objects	216,147	0.16	55	1,453
dc_profiles	475	0.00	0	2
dc_rollback_segments	3,017	0.00	0	101
dc_segments	7,580	4.26	5	1,880
dc_sequences	603	2.65	603	26
dc_tablespace_quotas	1	100.00	1	1
dc_tablespaces	103,987	0.00	0	27
dc_usernames	329,388	0.00	0	47
dc_users	102,447	0.02	0	74
outstanding_alerts	304	0.33	1	52

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	1,015	1.28	41,126	0.03	0	0
CLUSTER	51	1.96	80	1.25	0	0
INDEX	46	26.09	137	8.76	0	0
SQL AREA	15,464	14.14	6,686,065	0.05	63	42
TABLE/PROCEDURE	3,527	12.39	2,578,091	0.03	39	0
TRIGGER	248	6.05	11,689	0.13	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	182.85		0.85	0.63	5	5	216	216
	Freeable	106.50	0.00	0.83	0.60	4		128	128
	SQL	19.28	0.85	0.10	0.12	1	10	197	147
	PL/SQL	8.58	2.61	0.04	0.03	0	0	206	206
E	Other	209.78		0.89	0.66	5	9	236	236
	Freeable	129.69	0.00	0.86	0.56	4		150	150
	SQL	23.25	0.96	0.11	0.13	1	16	218	168
	PL/SQL	9.17	3.06	0.04	0.04	0	0	226	226

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	3,355,443,200
Fixed Size	2,085,136
Redo Buffers	14,688,256
Variable Size	1,996,492,528

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	74.22	52.73	-28.96
large	session heap	84.75	106.25	25.36
shared	ASH buffers	8.00	8.00	0.00
shared	CCursor	13.26	18.33	38.30
shared	FileOpenBlock	15.20	15.20	0.00
shared	KTI-UNDO	16.12	16.12	0.00
shared	NETWORK BUFFER	24.42	28.25	15.67
shared	PCursor		8.94
shared	XDB Schema Cac	8.96	8.96	0.00
shared	db_block_hash_buckets	22.50	22.50	0.00
shared	event statistics per sess	19.76	19.76	0.00
shared	free memory	366.35	316.62	-13.57
shared	library cache	16.62	21.48	29.25
shared	private strands	15.23	15.23	0.00
shared	row cache	7.16	7.16	0.00
shared	sessions	11.48	11.48	0.00
shared	sql area	41.00	63.72	55.41
	buffer_cache	3,200.00	3,200.00	0.00
	fixed_sga	1.99	1.99	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\BHPSFCDB\ADMIN\ADUMP
background_dump_dest	T:\ORACLE\BHPSFCDB\ADMIN\BDUMP
compatible	10.2.0.5.0
control_files	T:\ORACLE\BHPSFCDB\ORADATA\CONTROL01.CTL, T:\ORACLE\BHPSFCDB\ORADATA\CONTROL02.CTL, T:\ORACLE\BHPSFCDB\ORADATA\CONTROL03.CTL
core_dump_dest	T:\ORACLE\BHPSFCDB\ADMIN\CDUMP
db_block_size	8192
db_cache_size	1073741824
db_domain	BHP.LITEONIT.com
db_file_multiblock_read_count	16
db_name	BHPSFCDB
dispatchers	(PROTOCOL=TCP)(dispatchers=10)(service=BHPSFCDB.BHP.LITEONIT.com)
job_queue_processes	10
large_pool_size	167772160
local_listener	(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.169.33.33)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.133.98.25)(PORT=1521)))
log_archive_dest_1	LOCATION=T:\archive\
log_archive_format	ARC%S_%R.%T
max_dispatchers	20
max_shared_servers	200
nls_language	SIMPLIFIED CHINESE
nls_territory	CHINA
open_cursors	1000
pga_aggregate_target	2147483648
processes	1985
remote_login_passwordfile	EXCLUSIVE
session_cached_cursors	200
sga_max_size	5368709120
sga_target	4294967296
shared_pool_size	738197504
shared_servers	50
timed_statistics	TRUE
undo_management	AUTO
undo_retention	10800
undo_tablespace	UNDOTBS1
user_dump_dest	T:\ORACLE\BHPSFCDB\ADMIN\UDUMP

End of Report

% Blocks changed per Read:	29.37	Recursive Call %:	53.46
Rollback per transaction %:	3.71	Rows per Sort:	27.44

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.89	In-memory Sort %:	100.00
Library Hit %:	99.96	Soft Parse %:	99.94
Execute to Parse %:	70.93	Latch Hit %:	99.94
Parse CPU to Parse Elapsd %:	47.21	% Non-Parse CPU:	97.11