WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

FEYY 2144061258 feyy 1 10.2.0.1.0 NO feyyhis1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
FEYY	2144061258	feyy	1	10.2.0.1.0	NO	feyyhis1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 95475 13-Nov-13 10:30:21 1157 44.3

End Snap: 95476 13-Nov-13 10:45:39 1212 44.4

Elapsed: 15.30 (mins)

DB Time: 1,347.96 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	95475	13-Nov-13 10:30:21	1157	44.3
End Snap:	95476	13-Nov-13 10:45:39	1212	44.4
Elapsed:		15.30 (mins)
DB Time:		1,347.96 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 8,944M 8,944M Std Block Size: 8K

Shared Pool Size: 3,008M 3,008M Log Buffer: 14,416K

	Begin	End
Buffer Cache:	8,944M	8,944M	Std Block Size:	8K
Shared Pool Size:	3,008M	3,008M	Log Buffer:	14,416K

Load Profile

Per Second Per Transaction

Redo size: 75,896.89 5,287.78

Logical reads: 78,750.72 5,486.61

Block changes: 410.00 28.57

Physical reads: 536.35 37.37

Physical writes: 67.15 4.68

User calls: 5,034.96 350.79

Parses: 1,069.80 74.53

Hard parses: 52.34 3.65

Sorts: 87.11 6.07

Logons: 1.81 0.13

Executes: 1,156.61 80.58

Transactions: 14.35

	Per Second	Per Transaction
Redo size:	75,896.89	5,287.78
Logical reads:	78,750.72	5,486.61
Block changes:	410.00	28.57
Physical reads:	536.35	37.37
Physical writes:	67.15	4.68
User calls:	5,034.96	350.79
Parses:	1,069.80	74.53
Hard parses:	52.34	3.65
Sorts:	87.11	6.07
Logons:	1.81	0.13
Executes:	1,156.61	80.58
Transactions:	14.35

% Blocks changed per Read: 0.52 Recursive Call %: 14.61

Rollback per transaction %: 9.72 Rows per Sort: 126.80

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 97.38 Soft Parse %: 95.11

Execute to Parse %: 7.51 Latch Hit %: 99.69

Parse CPU to Parse Elapsd %: 2.49 % Non-Parse CPU: 50.54

Shared Pool Statistics

Begin End

Memory Usage %: 79.16 77.03

% SQL with executions>1: 80.86 77.72

% Memory for SQL w/exec>1: 79.36 78.09

	Begin	End
Memory Usage %:	79.16	77.03
% SQL with executions>1:	80.86	77.72
% Memory for SQL w/exec>1:	79.36	78.09

Top 5 Timed Events

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

latch: library cache 334,217 24,117 72 29.8 Concurrency

cursor: mutex X 38,692,704 16,522 0 20.4 Concurrency

library cache pin 102,178 11,803 116 14.6 Concurrency

kksfbc child completion 136,565 8,066 59 10.0 Other

CPU time 3,423 4.2

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
latch: library cache	334,217	24,117	72	29.8	Concurrency
cursor: mutex X	38,692,704	16,522	0	20.4	Concurrency
library cache pin	102,178	11,803	116	14.6	Concurrency
kksfbc child completion	136,565	8,066	59	10.0	Other
CPU time		3,423		4.2

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): 80877.4s
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
parse time elapsed	67,664.31	83.66
failed parse elapsed time	15,713.72	19.43
sql execute elapsed time	11,664.59	14.42
DB CPU	3,423.01	4.23
hard parse elapsed time	2,644.23	3.27
PL/SQL execution elapsed time	1,239.26	1.53
connection management call elapsed time	1,162.11	1.44
inbound PL/SQL rpc elapsed time	25.97	0.03
hard parse (sharing criteria) elapsed time	24.92	0.03
sequence load elapsed time	6.63	0.01
PL/SQL compilation elapsed time	5.75	0.01
repeated bind elapsed time	0.70	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
DB time	80,877.38
background elapsed time	176.65
background cpu time	13.18

Back to Wait Events Statistics
Back to Top

Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
Concurrency	39,678,957	0.00	56,098	1	3,012.14
Other	147,990	92.44	8,293	56	11.23
User I/O	95,195	0.00	290	3	7.23
Application	73,937	0.00	280	4	5.61
Commit	11,543	0.03	64	6	0.88
Network	4,902,692	0.00	49	0	372.18
System I/O	37,663	0.00	33	1	2.86
Configuration	16	0.00	1	41	0.00

Back to Wait Events Statistics
Back to Top

Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
latch: library cache	334,217	0.00	24,117	72	25.37
cursor: mutex X	38,692,704	0.00	16,522	0	2,937.27
library cache pin	102,178	0.89	11,803	116	7.76
kksfbc child completion	136,565	99.91	8,066	59	10.37
latch: shared pool	13,909	0.06	1,469	106	1.06
latch: library cache pin	31,615	0.00	894	28	2.40
cursor: mutex S	492,689	0.00	749	2	37.40
latch: library cache lock	9,937	0.00	276	28	0.75
SQL*Net break/reset to client	73,912	0.00	265	4	5.61
db file sequential read	61,154	0.00	197	3	4.64
latch: cache buffers chains	1,133	0.00	161	142	0.09
latch free	5,432	0.00	105	19	0.41
latch: row cache objects	496	0.00	104	210	0.04
db file scattered read	30,800	0.00	93	3	2.34
log file sync	11,543	0.03	64	6	0.88
wait list latch free	2,813	0.00	53	19	0.21
inactive session	26	100.00	31	1175	0.00
SQL*Net more data from client	10,464	0.00	28	3	0.79
log file parallel write	12,942	0.00	26	2	0.98
enq: CU - contention	2,262	0.00	18	8	0.17
enq: TX - row lock contention	23	8.70	15	634	0.00
SQL*Net more data to client	334,527	0.00	12	0	25.39
SQL*Net message to client	4,557,627	0.00	9	0	345.98
latch: cache buffers lru chain	33	0.00	5	143	0.00
control file parallel write	1,004	0.00	4	4	0.08
kkshgnc reloop	197	100.00	4	19	0.01
latch: object queue header operation	15	0.00	3	204	0.00
LGWR wait for redo copy	218	60.09	3	13	0.02
latch: session allocation	303	0.00	2	8	0.02
buffer busy waits	63	0.00	2	32	0.00
latch: redo allocation	12	0.00	2	145	0.00
latch: enqueue hash chains	114	0.00	2	14	0.01
Log archive I/O	82	0.00	2	19	0.01
LNS wait on SENDREQ	74	0.00	1	17	0.01
os thread startup	11	0.00	1	90	0.00
control file sequential read	23,534	0.00	1	0	1.79
enq: SQ - contention	10	0.00	0	47	0.00
log file sequential read	95	0.00	0	3	0.01
log file switch completion	5	0.00	0	35	0.00
db file single write	6	0.00	0	10	0.00
row cache lock	5	0.00	0	3	0.00
direct path read temp	1,377	0.00	0	0	0.10
direct path write temp	1,377	0.00	0	0	0.10
log file single write	6	0.00	0	0	0.00
local write wait	3	0.00	0	0	0.00
enq: RO - fast object reuse	2	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
direct path read	246	0.00	0	0	0.02
direct path write	232	0.00	0	0	0.02
SQL*Net message from client	4,557,511	0.00	664,519	146	345.97
pipe get	1,643	88.13	6,997	4258	0.12
Streams AQ: waiting for time management or cleanup tasks	5	60.00	1,560	312034	0.00
LNS ASYNC end of log	906	100.00	893	986	0.07
virtual circuit status	30	100.00	879	29297	0.00
Streams AQ: qmn slave idle wait	32	0.00	875	27353	0.00
Streams AQ: qmn coordinator idle wait	32	100.00	875	27353	0.00
jobq slave wait	302	96.03	870	2882	0.02
PL/SQL lock timer	90	100.00	860	9555	0.01
class slave wait	2	100.00	10	4890	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
latch: library cache	133	8.27	72	543	0.01
log file parallel write	12,941	0.00	26	2	0.98
latch: shared pool	41	21.95	19	465	0.00
events in waitclass Other	275	47.64	7	24	0.02
control file parallel write	1,004	0.00	4	4	0.08
Log archive I/O	82	0.00	2	19	0.01
LNS wait on SENDREQ	74	0.00	1	17	0.01
os thread startup	11	0.00	1	90	0.00
db file sequential read	162	0.00	1	3	0.01
latch: library cache pin	4	0.00	0	99	0.00
control file sequential read	9,997	0.00	0	0	0.76
log file sequential read	95	0.00	0	3	0.01
latch: library cache lock	1	0.00	0	222	0.00
db file single write	6	0.00	0	10	0.00
log file single write	6	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
log file sync	1	0.00	0	0	0.00
direct path read	246	0.00	0	0	0.02
direct path write	180	0.00	0	0	0.01
rdbms ipc message	15,832	18.12	15,498	979	1.20
Streams AQ: waiting for time management or cleanup tasks	5	60.00	1,560	312034	0.00
smon timer	6	50.00	1,134	188946	0.00
LNS ASYNC end of log	906	100.00	893	986	0.07
pmon timer	313	97.44	893	2853	0.02
Streams AQ: qmn slave idle wait	32	0.00	875	27353	0.00
Streams AQ: qmn coordinator idle wait	32	100.00	875	27353	0.00
class slave wait	1	100.00	5	4890	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

No data exists for this section of the report.

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
feyy	80,350.50	3,375.60	490,814	72,104,204
SYS$USERS	613.30	49.40	17	207,057
SYS$BACKGROUND	0.00	0.00	1,519	18,577
feyyXDB	0.00	0.00	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
feyy	93383	28331	39664141	5514794	4870743	4571
SYS$USERS	17	15	9957	48952	24949	23
SYS$BACKGROUND	1791	645	4233	10031	74	125

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
3,844	122	168,363	0.02	4.75	f8pmzwz7mmjua	EGYJGL.exe	SELECT VVALUE From SYSVAR Wher...
1,844	10	42,057	0.04	2.28	4r3wnh0fn8y08	egpdhj_disp.exe	SELECT SYSDATE FROM DUAL
687	3	7,190	0.10	0.85	dk8b8tk4xuk0y	EGPDHJ.exe	Select Count ( *) FROM PDHJ_PH...
565	63	1,617	0.35	0.70	687pj3d0pk2a7	EGMZYS.exe	declare WHO_ERROR except...
564	101	3	187.92	0.70	f95ar85c9c72r	EGCRYGL.exe	SELECT SUM ( JE ) , SUM ( ZFJ...
544	62	1,617	0.34	0.67	265s5md6h9nqt	EGMZYS.exe	begin Tlgcheck.lgcheck; end;
439	15	21,758	0.02	0.54	97znsa32k928r	ZSGL.exe	begin :con := ASSETCHECK.QUERY...
415	81	30,198	0.01	0.51	9aqw9x9fx0dvu	EGMZSF.exe	SELECT VVALUE FROM SYSVAR WHER...
337	8	18,516	0.02	0.42	gb21rmwra3102	w3wp.exe	SELECT DATA_LENGTH FROM USER_T...
327	1	2,165	0.15	0.40	78f5c2b4t5srg	EGFMS.exe	SELECT NVL ( SUM ( DECODE ( TS...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
122	3,844	168,363	0.00	4.75	f8pmzwz7mmjua	EGYJGL.exe	SELECT VVALUE From SYSVAR Wher...
101	564	3	33.59	0.70	f95ar85c9c72r	EGCRYGL.exe	SELECT SUM ( JE ) , SUM ( ZFJ...
81	415	30,198	0.00	0.51	9aqw9x9fx0dvu	EGMZSF.exe	SELECT VVALUE FROM SYSVAR WHER...
73	282	1,405	0.05	0.35	b9u7d295c8fcm	egzyys.exe	declare -- local variables h...
72	249	1,405	0.05	0.31	902dk0b134jkv	egzyys.exe	begin logoffcheck.logoffaudit;...
70	131	583	0.12	0.16	266m0a50g9x4r	EGZYYS.exe	SELECT ZYH , HYXK , HYTZ , ...
63	565	1,617	0.04	0.70	687pj3d0pk2a7	EGMZYS.exe	declare WHO_ERROR except...
62	544	1,617	0.04	0.67	265s5md6h9nqt	EGMZYS.exe	begin Tlgcheck.lgcheck; end;
57	96	5,563	0.01	0.12	7dcrb0t176d19	egzyys.exe	SELECT C.VALUE FROM V$SESSTAT ...
48	293	154	0.31	0.36	d0uxjp6nd5m9r	EGFMS.exe	SELECT "YJ_HIJK_RBDA"."SBXH...
10	1,844	42,057	0.00	2.28	4r3wnh0fn8y08	egpdhj_disp.exe	SELECT SYSDATE FROM DUAL

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: 72,275,129
Captured SQL account for 47.6% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
7,584,203	154	49,248.07	10.49	47.82	292.81	d0uxjp6nd5m9r	EGFMS.exe	SELECT "YJ_HIJK_RBDA"."SBXH...
4,080,772	139	29,358.07	5.65	12.19	31.37	b3qg1rgb30j4u	EGZYHS.exe	SELECT * FROM EVTZYBR WHERE BQ...
3,861,053	30	128,701.77	5.34	11.48	21.71	1gggftd9hvxw0	EGMZYS.exe	SELECT "MZYSCFXX"."MZH", ...
3,540,064	583	6,072.15	4.90	69.87	130.88	266m0a50g9x4r	EGZYYS.exe	SELECT ZYH , HYXK , HYTZ , ...
2,185,006	3	728,335.33	3.02	100.77	563.77	f95ar85c9c72r	EGCRYGL.exe	SELECT SUM ( JE ) , SUM ( ZFJ...
2,084,835	605	3,446.01	2.88	10.90	50.64	bm7mx7h4nv3vn	EGPDHJ.exe	SELECT "PDHJ_DLB_TMP"."LX" ...
1,834,059	72	25,473.04	2.54	12.89	66.58	7y31qdc9az6t9	EGZYHS.exe	SELECT /+ FIRST_ROWS / ...
1,174,877	30,198	38.91	1.63	81.22	415.01	9aqw9x9fx0dvu	EGMZSF.exe	SELECT VVALUE FROM SYSVAR WHER...
1,169,964	1,101	1,062.64	1.62	19.43	112.62	4c5m2as8kv7ag	dllhost.exe	UPDATE ZYBRXX SET ZFZE = ZFZE ...
1,012,274	9	112,474.89	1.40	6.22	142.00	5220a5v2hnu6p	EGMZSF.exe	SELECT FPNO FROM MZFPHMMX WHER...
977,800	111	8,809.01	1.35	26.44	191.73	4rb30rzdhjvhw	TOAD 8.5.3.2	SELECT A.OWNER, A.OBJECT_NAME,...
855,184	793	1,078.42	1.18	15.84	149.28	d18dmmshv3770	EGFMS.exe	INSERT INTO ZYFY ( ZYH , XH ,...
826,621	1,095	754.91	1.14	13.45	52.93	3cg6fwmnrmx0n	dllhost.exe	SELECT COUNT(1) FROM YMJZ_YESC...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 492,247
Captured SQL account for 49.9% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
179,873	1	179,873.00	36.54	10.02	163.44	bpnuwmvwavhkz	EGZYYS.exe	SELECT "HYTS"."NO" , ...
41,212	2	20,606.00	8.37	11.72	50.58	afr8r0vqs4ttx	EGZYYS.exe	SELECT "ZYBRXX"."ZYH", ...
20,611	9	2,290.11	4.19	6.22	142.00	5220a5v2hnu6p	EGMZSF.exe	SELECT FPNO FROM MZFPHMMX WHER...
1,746	9,165	0.19	0.35	6.12	61.01	3x9q5fmc6fmfd	EGYBGL.exe	SELECT MAX ( ZZRQ ) FROM ZYJZX...
1,432	154	9.30	0.29	47.82	292.81	d0uxjp6nd5m9r	EGFMS.exe	SELECT "YJ_HIJK_RBDA"."SBXH...
422	111	3.80	0.09	26.44	191.73	4rb30rzdhjvhw	TOAD 8.5.3.2	SELECT A.OWNER, A.OBJECT_NAME,...
204	1,617	0.13	0.04	61.81	543.93	265s5md6h9nqt	EGMZYS.exe	begin Tlgcheck.lgcheck; end;
204	1,617	0.13	0.04	62.55	564.96	687pj3d0pk2a7	EGMZYS.exe	declare WHO_ERROR except...
124	43	2.88	0.03	0.16	1.14	468jhc35q9qqy	ORACLE.EXE	DELETE FROM MC$LG_EUSER_LOGIN ...
76	793	0.10	0.02	15.84	149.28	d18dmmshv3770	EGFMS.exe	INSERT INTO ZYFY ( ZYH , XH ,...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 1,061,500
Captured SQL account for 55.3% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
168,363	144,586	0.86	0.02	f8pmzwz7mmjua	EGYJGL.exe	SELECT VVALUE From SYSVAR Wher...
42,057	42,054	1.00	0.04	4r3wnh0fn8y08	egpdhj_disp.exe	SELECT SYSDATE FROM DUAL
37,657	37,655	1.00	0.00	0fk206q858j4u	EGZYYS.exe	SELECT count ( *) FROM HYSQD W...
36,578	36,577	1.00	0.00	55n2y5at03341	egzyys.exe	SELECT COUNT ( *) FROM SYSVAR ...
30,198	30,198	1.00	0.01	9aqw9x9fx0dvu	EGMZSF.exe	SELECT VVALUE FROM SYSVAR WHER...
23,716	23,711	1.00	0.01	djsrgdvba5c0q	egpdhj_disp.exe	SELECT RESHOW FROM PDHJ_PHB WH...
21,758	21,757	1.00	0.02	97znsa32k928r	ZSGL.exe	begin :con := ASSETCHECK.QUERY...
18,516	0	0.00	0.02	gb21rmwra3102	w3wp.exe	SELECT DATA_LENGTH FROM USER_T...
15,897	87	0.01	0.00	1drvvwnar5vrs	egpdhj_disp.exe	SELECT VAR FROM PDHJ_GYB WHERE...
11,793	11,793	1.00	0.01	5k20gj1sw0wr4	EGFMS.exe	SELECT To_Number ( TRUNC ( MON...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 981,828
Captured SQL account for 55.5% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
168,360	168,363	17.15	f8pmzwz7mmjua	EGYJGL.exe	SELECT VVALUE From SYSVAR Wher...
42,057	42,057	4.28	4r3wnh0fn8y08	egpdhj_disp.exe	SELECT SYSDATE FROM DUAL
37,656	37,657	3.84	0fk206q858j4u	EGZYYS.exe	SELECT count ( *) FROM HYSQD W...
36,578	36,578	3.73	55n2y5at03341	egzyys.exe	SELECT COUNT ( *) FROM SYSVAR ...
30,199	30,198	3.08	9aqw9x9fx0dvu	EGMZSF.exe	SELECT VVALUE FROM SYSVAR WHER...
23,716	23,716	2.42	djsrgdvba5c0q	egpdhj_disp.exe	SELECT RESHOW FROM PDHJ_PHB WH...
21,758	21,758	2.22	97znsa32k928r	ZSGL.exe	begin :con := ASSETCHECK.QUERY...
18,516	18,516	1.89	gb21rmwra3102	w3wp.exe	SELECT DATA_LENGTH FROM USER_T...
15,897	15,897	1.62	1drvvwnar5vrs	egpdhj_disp.exe	SELECT VAR FROM PDHJ_GYB WHERE...
11,793	11,793	1.20	5k20gj1sw0wr4	EGFMS.exe	SELECT To_Number ( TRUNC ( MON...

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,307,769	1	0.04	31a13pnjps7j3		SELECT source, (case w...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
135	605	bm7mx7h4nv3vn	EGPDHJ.exe	SELECT "PDHJ_DLB_TMP"."LX" ...
32	9,607	bt6jm5m4bfm62	ZSGL.exe	SELECT /+ first_rows /RULE_V...
23	69	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
21	8,090	g2cvz8zqq6h8n	EGYJGL.exe	SELECT TABLE_NAME NAME FROM DB...
21	8,090	g2cvz8zqq6h8n	EGYJGL.exe	SELECT TABLE_NAME NAME FROM DB...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0fk206q858j4u SELECT count ( *) FROM HYSQD WHERE ZYH =:1 AND SFJJ ='Y' AND BGDBH > 0 AND SFCY <> 'Y'

1drvvwnar5vrs SELECT VAR FROM PDHJ_GYB WHERE XM =:1 AND DM =:2

1gggftd9hvxw0 SELECT "MZYSCFXX"."MZH", "MZYSCFXX"."XH", "MZYSCFXX"."JLSJ", "MZYSCFXX"."LX", "MZYSCFXX"."YSBH" FROM "MZYSCFXX", "MZGHXX" WHERE "MZGHXX"."MZH" ="MZYSCFXX"."MZH" AND "MZGHXX"."BRBH" = :BRBH AND "MZYSCFXX"."MZH" BETWEEN :mzh1 AND :mzh2 AND "MZYSCFXX"."LX" =:CFLX ORDER BY "MZYSCFXX"."JLSJ"

265s5md6h9nqt begin Tlgcheck.lgcheck; end;

266m0a50g9x4r SELECT ZYH , HYXK , HYTZ , HYWC , HYWCZS , JCXK , JCTZ , JCWC , JCWCZS FROM EVTZYBR WHERE EVTZYBR.BQDM =:1

31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC

3cg6fwmnrmx0n SELECT COUNT(1) FROM YMJZ_YESCXX WHERE YFZYH = :B1

3x9q5fmc6fmfd SELECT MAX ( ZZRQ ) FROM ZYJZXX WHERE ZYH =:1 AND ZFJSBH IS NULL

468jhc35q9qqy DELETE FROM MC$LG_EUSER_LOGIN WHERE MACADDR=:B2 AND IPADDR=:B1

4c5m2as8kv7ag UPDATE ZYBRXX SET ZFZE = ZFZE + :B2 , FYZE = FYZE + :B1 WHERE ZYH = :B3

4r3wnh0fn8y08 SELECT SYSDATE FROM DUAL

4rb30rzdhjvhw SELECT A.OWNER, A.OBJECT_NAME, A.OBJECT_TYPE, C.PROGRAM, C.TERMINAL, B.OS_USER_NAME, B.SESSION_ID SID, C.SERIAL#, B.LOCKED_MODE, C.TYPE, C.SQL_ADDRESS, C.LOGON_TIME, D.START_TIME FROM dba_objects a, v$locked_object b , v$session c, sys.v_$transaction d WHERE a.OBJECT_ID=b.OBJECT_ID AND b.SESSION_ID=c.SID AND c.TADDR=d.ADDR ORDER BY D.START_TIME

5220a5v2hnu6p SELECT FPNO FROM MZFPHMMX WHERE LYRY =:1 AND SYBZ ='3' AND SYRQ >= :2 And SYRQ <= :3

55n2y5at03341 SELECT COUNT ( *) FROM SYSVAR where prog =:1 and vname =:2

5k20gj1sw0wr4 SELECT To_Number ( TRUNC ( MONTHS_BETWEEN ( :1 , :2 ) ) ) FROM DUAL

687pj3d0pk2a7 declare WHO_ERROR exception; WHO_NONERROR exception; WHERE_ERROR exception; WHERE_NONERROR exception; APP_ERROR exception; APP_NONERROR exception; WHEN_ERROR exception; WHEN_NONERROR exception; NORMAL_ERROR exception; BYPASS_ERROR exception; CONFLICT_ERROR exception; USER_ERROR exception; USER_NONERROR exception; VERSION_ERROR exception; LG_ERROR exception; PRIVS_ERROR exception; pragma exception_init(WHO_ERROR, -20001); pragma exception_init(WHERE_ERROR, -20002); pragma exception_init(APP_ERROR, -20003); pragma exception_init(WHEN_ERROR, -20004); pragma exception_init(WHO_NONERROR, -20005); pragma exception_init(WHERE_NONERROR, -20006); pragma exception_init(APP_NONERROR, -20007); pragma exception_init(WHEN_NONERROR, -20008); pragma exception_init(CONFLICT_ERROR, -20009); pragma exception_init(USER_ERROR, -20010); pragma exception_init(USER_NONERROR, -20011); pragma exception_init(VERSION_ERROR, -20012); --?????????????????????????? pragma exception_init(LG_ERROR, -1017); pragma exception_init(PRIVS_ERROR, -1031); begin execute immediate 'begin Tlgcheck.lgcheck; end;'; --dbms_lock.sleep(30); exception when WHO_ERROR then raise; when WHERE_ERROR then raise; when APP_ERROR then raise; when WHEN_ERROR then raise; when WHO_NONERROR then raise; when WHERE_NONERROR then raise; when APP_NONERROR then raise; when WHEN_NONERROR then raise; when CONFLICT_ERROR then raise; when VERSION_ERROR then raise; when LG_ERROR then raise; when PRIVS_ERROR then raise; when others then null; end LogonEvent;

78f5c2b4t5srg SELECT NVL ( SUM ( DECODE ( TSLX , 1 , 1 , 0 ) ) , 0 ) , NVL ( SUM ( DECODE ( TSLX , 2 , 1 , 0 ) ) , 0 ) FROM HYTS WHERE TSSJ BETWEEN :1 AND :2 AND BQH =:3 AND QRRY IS NULL AND ( TSFW ='A' OR TSFW ='H' )

7dcrb0t176d19 SELECT C.VALUE FROM V$SESSTAT C, V$STATNAME B, V$SESSION A WHERE A.SID=C.SID AND B.STATISTIC#=C.STATISTIC# AND B.NAME IN (:B2 ) AND A.AUDSID=:B1

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

7y31qdc9az6t9 SELECT /*+ FIRST_ROWS */ "YJ_HIJK_RBDA"."SBXH", "YJ_HIJK_RBDA"."SERIALNO", "YJ_HIJK_RBDA"."RECEIVEFLAG", "YJ_HIJK_RBDA"."SAMPLETYPENO", "YJ_HIJK_RBDA"."PATNO", "YJ_HIJK_RBDA"."CNAME", "YJ_HIJK_RBDA"."BIRTHDAY", "YJ_HIJK_RBDA"."AGE", "YJ_HIJK_RBDA"."BED", "YJ_HIJK_RBDA"."DEPTNO", "YJ_HIJK_RBDA"."DOCTOR", "YJ_HIJK_RBDA"."DIAG", "YJ_HIJK_RBDA"."COLLECTTIME", "YJ_HIJK_RBDA"."QDSJ", "YJ_HIJK_RBDA"."QDDD", "YJ_HIJK_RBDA"."SAMPLETYPENO", "YJ_HIJK_RBDA"."CHARGEFLAG", "YJ_HIJK_RBDA"."SENDER", "YJ_HIJK_RBDA"."SENDTIME", "YJ_HIJK_RBDA"."EMERGENCYFLAG", "YJ_HIJK_RBDA"."RECEIVER", "YJ_HIJK_RBDA"."RECEIVETIME", "YJ_HIJK_RBDA"."RECEIPTER", "YJ_HIJK_RBDA"."RECEIPTTIME", "YJ_HIJK_RBDA"."COLLECTER", "YJ_HIJK_RBDA"."STATEFLAG", "YJ_HIJK_RBDA"."REPEALER", "YJ_HIJK_RBDA"."REPEALTIME", "YJ_HIJK_RBDA"."REPEALCAUSE", "YJ_HIJK_RBDA"."STATION", ' ' disp, 0 jszt, decode(trim(bed), null, 'M', '', 'M', 'Z')||deptno ksdm, trim(wardno) wardno, "YJ_HIJK_RBDA"."FROMTYPE", "YJ_HIJK_RBDA"."CREATETIME", "YJ_HIJK_RBDA"."COLLECTDATE", "YJ_HIJK_RBDA"."BBRQDM", ' ' yzmclx FROM "YJ_HIJK_RBDA" WHERE ( ( "YJ_HIJK_RBDA"."WARDNO" = :as_bqh ) AND ( "YJ_HIJK_RBDA"."STATEFLAG" in ('S', 'N') ) AND ( "YJ_HIJK_RBDA"."RECEIVEFLAG" = 0 ) AND ( "YJ_HIJK_RBDA"."FROMTYPE" = 'Z' ) AND ( "YJ_HIJK_RBDA"."CREATETIME" >= sysdate + :days ) )

902dk0b134jkv begin logoffcheck.logoffaudit;end;

97znsa32k928r begin :con := ASSETCHECK.QUERYPOLICY(:sn, :on); end;

9aqw9x9fx0dvu SELECT VVALUE FROM SYSVAR WHERE UPPER ( PROG ) =:1 AND UPPER ( VNAME ) =:2

afr8r0vqs4ttx SELECT "ZYBRXX"."ZYH", "ZYBRXX"."BRXM", "ZYBRXX"."ZYYSBH", "ZYBRXX"."ZYRQ", "ZYBRXX"."CYSJ", "ZYBRXX"."RYKS", "ZYBRXX"."KSBH", "ZYBRXX"."JZBZ", "ZYBRBASY"."BAZL", "ZYBRBASY"."ZKYS", "ZYBRBASY"."DCBZ", "ZYBRBASY"."BAGD", (trunc("ZYBRXX"."CYRQ") - trunc(DECODE("ZYBRXX"."RYSJ", NULL, DECODE("ZYBRXX"."RYRQ", null, "ZYBRXX"."ZYRQ", "ZYBRXX"."RYRQ"), "ZYBRXX"."RYSJ"))) ZYRS_SJ, (trunc("ZYBRXX"."CYRQ") - trunc(DECODE("ZYBRXX"."RYRQ", NULL, DECODE("ZYBRXX"."RYSJ", null, "ZYBRXX"."ZYRQ", "ZYBRXX"."RYSJ"), "ZYBRXX"."RYRQ"))) ZYRS, "ZYBRXX"."RYZD", "ZYBRXX"."SFZH", T3.SSMC, "ZYBRXX"."ZYBAH", "ZYBRXX"."ADDR", "ZYBRFZXX"."ZZ_PROVINCE", "ZYBRFZXX"."ZZ_CITY", "ZYBRFZXX"."ZZ_COUNTY", "ZYBRFZXX"."ZZ_TOWN" FROM "ZYBRBASY", "ZYBRXX", (SELECT T2.ZYH AS ZYH, LTRIM (MAX (SYS_CONNECT_BY_PATH (T2.SSMC, ';')), ';') AS SSMC FROM (SELECT T1.ZYH, T1.SSMC, rnFirst, LEAD (rnFirst) OVER (PARTITION BY T1.ZYH ORDER BY rnFirst) rnNext FROM (SELECT A.ZYH, A.SSMC, ROW_NUMBER () OVER (ORDER BY A.ZYH, A.XH) rnFirst FROM ZYBRSSSQ A) T1) T2 START WITH rnNext IS NULL CONNECT BY rnNext = PRIOR rnFirst GROUP BY T2.ZYH) T3, "ZYBRFZXX" WHERE ( "ZYBRXX"."ZYH" = "ZYBRBASY"."ZYH"(+) ) and ( ( "ZYBRXX"."CYRQ" is not null ) ) and ( "ZYBRXX"."BQH"= :BQH) and ( "ZYBRXX"."CYRQ" between :rq1 and :rq2) and ("ZYBRXX"."ZYH" = T3.ZYH(+)) AND ("ZYBRXX"."ZYH" = "ZYBRFZXX"."ZYH"(+)) ORDER BY "ZYBRXX"."CYRQ"

b3qg1rgb30j4u SELECT * FROM EVTZYBR WHERE BQDM = :ARG_1 AND ZYH IN (SELECT ZYH FROM ZYBRXX WHERE BQH=EVTZYBR.BQDM AND CYRQ IS NULL)

b9u7d295c8fcm declare -- local variables here begin --null; execute immediate 'begin logoffcheck.logoffaudit;end;'; exception when others then null; end trg_logoffevent;

bm7mx7h4nv3vn SELECT "PDHJ_DLB_TMP"."LX" , "PDHJ_DLB_TMP"."DYBH" , "PDHJ_DLB_TMP"."DLBH" , "PDHJ_DLB_TMP"."LSH" , "PDHJ_DLB_TMP"."NO" , "PDHJ_DLB_TMP"."XM" , "PDHJ_DLB_TMP"."FSSJ" , "PDHJ_DLB_TMP"."NEWLSH" , "PDHJ_DLMCB_TMP"."DLMC" , "PDHJ_DLMCB_TMP"."DBZDFP" , "PDHJ_DLB_TMP"."RYBH" , "PDHJ_DLB_TMP"."PXH" , "PDHJ_DLB_TMP"."ZDRY" , "PDHJ_DLB_TMP"."SJBZ" , "PDHJ_DLLXB"."BZ" , DECODE(DLXZ, '1', DECODE(XZZT, '0', 3, DECODE((SELECT NVL(ZBLSH, 0) FROM PDHJ_DLB_TMP_EXT WHERE LX = PDHJ_DLB_TMP.LX AND DYBH = PDHJ_DLB_TMP.DYBH AND LSH=PDHJ_DLB_TMP.LSH), 0, 1, 2)), 0) ZT, "PDHJ_DLB_TMP"."YXLX" , "PDHJ_RYXXB"."KH" FROM "PDHJ_DLB_TMP" , "PDHJ_DLMCB_TMP" , "PDHJ_DLLXB" , "PDHJ_RYXXB" WHERE ( "PDHJ_DLB_TMP"."LX" = "PDHJ_DLMCB_TMP"."LX" ) and ( "PDHJ_DLB_TMP"."DYBH" = "PDHJ_DLMCB_TMP"."DLBH" ) and ( "PDHJ_DLLXB"."DM" = "PDHJ_DLB_TMP"."LX" ) and ( "PDHJ_DLB_TMP"."RYBH" = "PDHJ_RYXXB"."RYBH" ) and ("PDHJ_DLB_TMP"."NEWLSH" = 0 or ( "PDHJ_DLB_TMP"."NEWLSH" is null) ) and ( instrb( :as_dybh, "PDHJ_DLB_TMP"."LX"||'_'||"PDHJ_DLB_TMP"."DYBH") > 0 ) and ( "PDHJ_DLB_TMP"."FSSJ" >= (SYSDATE - :an_day) ) ORDER BY "PDHJ_DLB_TMP"."LX" ASC, "PDHJ_DLB_TMP"."DYBH" ASC, "PDHJ_DLB_TMP"." NO" ASC

bpnuwmvwavhkz SELECT "HYTS"."NO" , "HYTS"."BQH" , "HYTS"."TSSJ" , "HYTS"."TSRY" , "HYTS"."TSLX" , "HYTS"."TSNR" , "HYTS"."ZYH" , "HYTS"."QRRY" , "HYTS"."QRSJ" , "HYTS"."QRCL" , "HYTS"."BRBH" , "ZYBRXX"."BRXM" , "ZYBRXX"."CWH" , "YJ_HIJK_RBDA"."DOCTOR" , "HYTS"."QRFW" , "HYTS"."HSQRRY" , "HYTS"."HSQRSJ" , "HYTS"."TXM" FROM "HYTS" , "ZYBRXX" , "YJ_HIJK_RBDA" WHERE ( "HYTS"."ZYH" = "ZYBRXX"."ZYH" ) and ( "HYTS"."TXM" = "YJ_HIJK_RBDA"."SERIALNO" ) and ( ( "HYTS"."BQH" = :as_bqh ) And ( "HYTS"."TSSJ" between :adt_sj1 and :adt_sj2 ) and ( "HYTS"."TSLX" = :ai_tslx ) )

bt6jm5m4bfm62 SELECT /*+ first_rows */RULE_VALUE, FAUDIT, F_ACTION_ID, SAUDIT, S_ACTION_ID, SQLTYPE, PRIV_RULEVALUE, ENABLED FROM MC$ASSET_SQL_RULE WHERE CMDTYPE=:B2 AND REPLACE(REPLACE(REPLACE(REPLACE(UPPER(TRIM(:B1 )), CHR(10), CHR(32)), CHR(32), ''), CHR(13), ''), CHR(9), '') LIKE '%'||REPLACE(REPLACE(REPLACE(REPLACE(UPPER(TRIM(SQL_TEXT)), CHR(10), CHR(32)), CHR(32), ''), CHR(13), ''), CHR(9), '') AND LENGTHB(REPLACE(REPLACE(REPLACE(REPLACE(UPPER(TRIM(:B1 )), CHR(10), CHR(32)), CHR(32), ''), CHR(13), ''), CHR(9), ''))>= LENGTHB(REPLACE(REPLACE(REPLACE(REPLACE(UPPER(TRIM(SQL_TEXT)), CHR(10), CHR(32)), CHR(32), ''), CHR(13), ''), CHR(9), '')) AND ROWNUM=1

d0uxjp6nd5m9r SELECT "YJ_HIJK_RBDA"."SBXH" , "YJ_HIJK_RBDA"."SERIALNO" , "YJ_HIJK_RBDA"."RECEIVEFLAG" , "YJ_HIJK_RBDA"."SAMPLETYPENO" , "YJ_HIJK_RBDA"."PATNO" , "YJ_HIJK_RBDA"."CNAME" , "YJ_HIJK_RBDA"."BIRTHDAY" , "YJ_HIJK_RBDA"."AGE" , "YJ_HIJK_RBDA"."BED" , "YJ_HIJK_RBDA"."DEPTNO" , "YJ_HIJK_RBDA"."DOCTOR" , "YJ_HIJK_RBDA"."DIAG" , "YJ_HIJK_RBDA"."COLLECTTIME" , "YJ_HIJK_RBDA"."QDSJ" , "YJ_HIJK_RBDA"."QDDD" , "HYBBZLB"."MC" , "YJ_HIJK_RBDA"."CHARGEFLAG" , "YJ_HIJK_RBDA"."SENDER" , "YJ_HIJK_RBDA"."SENDTIME" , "YJ_HIJK_RBDA"."EMERGENCYFLAG" , "KSMC"."MC" , "YJ_HIJK_RBDA"."RECEIVER" , "YJ_HIJK_RBDA"."RECEIVETIME" , "YJ_HIJK_RBDA"."RECEIPTER" , "YJ_HIJK_RBDA"."RECEIPTTIME" , "YJ_HIJK_RBDA"."COLLECTER" , "YJ_HIJK_RBDA"."STATEFLAG" , "YJ_HIJK_RBDA"."REPEALER" , "YJ_HIJK_RBDA"."REPEALTIME" , "YJ_HIJK_RBDA"."REPEALCAUSE" , "YJ_HIJK_RBDA"."STATION" , ' ' disp, 0 jszt, decode(trim(bed), null, 'M', '', 'M', 'Z')||deptno ksdm, trim(wardno) wardno, "YJ_HIJK_RBDA"."FROMTYPE" , "YJ_HIJK_RBDA"."CREATETIME" , "YJ_HIJK_RBDA"."COLLECTDATE" , "YJ_HIJK_RBDA"."BBRQDM" , ' ' yzmclx, "YJ_HIJK_RBDA"."PRINTTIME" , DECODE(FROMTYPE, 'M', (SELECT BLBH FROM MZBRXX WHERE BRBH = TO_NUMBER(YJ_HIJK_RBDA.PATNO) ), YJ_HIJK_RBDA.PATNO) BLBH FROM "YJ_HIJK_RBDA" , "HYBBZLB" , "KSMC" , "HYBBFSJL" WHERE ( "YJ_HIJK_RBDA"."SAMPLETYPENO" = "HYBBZLB"."DM" (+)) and ( "YJ_HIJK_RBDA"."DEPTNO" = "KSMC"."NO" (+)) and ( "YJ_HIJK_RBDA"."SERIALNO" = "HYBBFSJL"."TXM" ) and ( ( "HYBBFSJL"."FSDZ" = :as_fsdz ) and ( "HYBBFSJL"."ID" = :ai_id ) and ( "HYBBFSJL"."ZT" = :as_zt ) and ( "YJ_HIJK_RBDA"."STATEFLAG" in ('C', 'N') ) )

d18dmmshv3770 INSERT INTO ZYFY ( ZYH , XH , BQH , FBLX , RQ , DM , YPNO , SL , JE , ZFJE , XFJE , SRRY , SRRYZH , KSBH , FYTJDM , YEBZ , SRKSBH , YSBH , YSZH , YBZFJE , YPJJ , HDRY ) VALUES ( :1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 )

djsrgdvba5c0q SELECT RESHOW FROM PDHJ_PHB WHERE PH =:1

dk8b8tk4xuk0y Select Count ( *) FROM PDHJ_PHB WHERE Instr ( :1 , '|' || Upper ( Ph ) || '|' ) > 0 And ReShow1 =1

f8pmzwz7mmjua SELECT VVALUE From SYSVAR Where PROG =:1 And VNAME =:2

f95ar85c9c72r SELECT SUM ( JE ) , SUM ( ZFJE ) FROM ZYJZFY WHERE ZYH =:1 OR ZYH LIKE :2

g2cvz8zqq6h8n SELECT TABLE_NAME NAME FROM DBA_TABLES WHERE OWNER= :B2 AND TABLE_NAME=:B1

gb21rmwra3102 SELECT DATA_LENGTH FROM USER_TAB_COLUMNS WHERE TABLE_NAME = :tname AND COLUMN_NAME = :cname

SQL Id	SQL Text
0fk206q858j4u	SELECT count ( *) FROM HYSQD WHERE ZYH =:1 AND SFJJ ='Y' AND BGDBH > 0 AND SFCY <> 'Y'
1drvvwnar5vrs	SELECT VAR FROM PDHJ_GYB WHERE XM =:1 AND DM =:2
1gggftd9hvxw0	SELECT "MZYSCFXX"."MZH", "MZYSCFXX"."XH", "MZYSCFXX"."JLSJ", "MZYSCFXX"."LX", "MZYSCFXX"."YSBH" FROM "MZYSCFXX", "MZGHXX" WHERE "MZGHXX"."MZH" ="MZYSCFXX"."MZH" AND "MZGHXX"."BRBH" = :BRBH AND "MZYSCFXX"."MZH" BETWEEN :mzh1 AND :mzh2 AND "MZYSCFXX"."LX" =:CFLX ORDER BY "MZYSCFXX"."JLSJ"
265s5md6h9nqt	begin Tlgcheck.lgcheck; end;
266m0a50g9x4r	SELECT ZYH , HYXK , HYTZ , HYWC , HYWCZS , JCXK , JCTZ , JCWC , JCWCZS FROM EVTZYBR WHERE EVTZYBR.BQDM =:1
31a13pnjps7j3	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
3cg6fwmnrmx0n	SELECT COUNT(1) FROM YMJZ_YESCXX WHERE YFZYH = :B1
3x9q5fmc6fmfd	SELECT MAX ( ZZRQ ) FROM ZYJZXX WHERE ZYH =:1 AND ZFJSBH IS NULL
468jhc35q9qqy	DELETE FROM MC$LG_EUSER_LOGIN WHERE MACADDR=:B2 AND IPADDR=:B1
4c5m2as8kv7ag	UPDATE ZYBRXX SET ZFZE = ZFZE + :B2 , FYZE = FYZE + :B1 WHERE ZYH = :B3
4r3wnh0fn8y08	SELECT SYSDATE FROM DUAL
4rb30rzdhjvhw	SELECT A.OWNER, A.OBJECT_NAME, A.OBJECT_TYPE, C.PROGRAM, C.TERMINAL, B.OS_USER_NAME, B.SESSION_ID SID, C.SERIAL#, B.LOCKED_MODE, C.TYPE, C.SQL_ADDRESS, C.LOGON_TIME, D.START_TIME FROM dba_objects a, v$locked_object b , v$session c, sys.v_$transaction d WHERE a.OBJECT_ID=b.OBJECT_ID AND b.SESSION_ID=c.SID AND c.TADDR=d.ADDR ORDER BY D.START_TIME
5220a5v2hnu6p	SELECT FPNO FROM MZFPHMMX WHERE LYRY =:1 AND SYBZ ='3' AND SYRQ >= :2 And SYRQ <= :3
55n2y5at03341	SELECT COUNT ( *) FROM SYSVAR where prog =:1 and vname =:2
5k20gj1sw0wr4	SELECT To_Number ( TRUNC ( MONTHS_BETWEEN ( :1 , :2 ) ) ) FROM DUAL
687pj3d0pk2a7	declare WHO_ERROR exception; WHO_NONERROR exception; WHERE_ERROR exception; WHERE_NONERROR exception; APP_ERROR exception; APP_NONERROR exception; WHEN_ERROR exception; WHEN_NONERROR exception; NORMAL_ERROR exception; BYPASS_ERROR exception; CONFLICT_ERROR exception; USER_ERROR exception; USER_NONERROR exception; VERSION_ERROR exception; LG_ERROR exception; PRIVS_ERROR exception; pragma exception_init(WHO_ERROR, -20001); pragma exception_init(WHERE_ERROR, -20002); pragma exception_init(APP_ERROR, -20003); pragma exception_init(WHEN_ERROR, -20004); pragma exception_init(WHO_NONERROR, -20005); pragma exception_init(WHERE_NONERROR, -20006); pragma exception_init(APP_NONERROR, -20007); pragma exception_init(WHEN_NONERROR, -20008); pragma exception_init(CONFLICT_ERROR, -20009); pragma exception_init(USER_ERROR, -20010); pragma exception_init(USER_NONERROR, -20011); pragma exception_init(VERSION_ERROR, -20012); --?????????????????????????? pragma exception_init(LG_ERROR, -1017); pragma exception_init(PRIVS_ERROR, -1031); begin execute immediate 'begin Tlgcheck.lgcheck; end;'; --dbms_lock.sleep(30); exception when WHO_ERROR then raise; when WHERE_ERROR then raise; when APP_ERROR then raise; when WHEN_ERROR then raise; when WHO_NONERROR then raise; when WHERE_NONERROR then raise; when APP_NONERROR then raise; when WHEN_NONERROR then raise; when CONFLICT_ERROR then raise; when VERSION_ERROR then raise; when LG_ERROR then raise; when PRIVS_ERROR then raise; when others then null; end LogonEvent;
78f5c2b4t5srg	SELECT NVL ( SUM ( DECODE ( TSLX , 1 , 1 , 0 ) ) , 0 ) , NVL ( SUM ( DECODE ( TSLX , 2 , 1 , 0 ) ) , 0 ) FROM HYTS WHERE TSSJ BETWEEN :1 AND :2 AND BQH =:3 AND QRRY IS NULL AND ( TSFW ='A' OR TSFW ='H' )
7dcrb0t176d19	SELECT C.VALUE FROM V$SESSTAT C, V$STATNAME B, V$SESSION A WHERE A.SID=C.SID AND B.STATISTIC#=C.STATISTIC# AND B.NAME IN (:B2 ) AND A.AUDSID=:B1
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7y31qdc9az6t9	SELECT /+ FIRST_ROWS / "YJ_HIJK_RBDA"."SBXH", "YJ_HIJK_RBDA"."SERIALNO", "YJ_HIJK_RBDA"."RECEIVEFLAG", "YJ_HIJK_RBDA"."SAMPLETYPENO", "YJ_HIJK_RBDA"."PATNO", "YJ_HIJK_RBDA"."CNAME", "YJ_HIJK_RBDA"."BIRTHDAY", "YJ_HIJK_RBDA"."AGE", "YJ_HIJK_RBDA"."BED", "YJ_HIJK_RBDA"."DEPTNO", "YJ_HIJK_RBDA"."DOCTOR", "YJ_HIJK_RBDA"."DIAG", "YJ_HIJK_RBDA"."COLLECTTIME", "YJ_HIJK_RBDA"."QDSJ", "YJ_HIJK_RBDA"."QDDD", "YJ_HIJK_RBDA"."SAMPLETYPENO", "YJ_HIJK_RBDA"."CHARGEFLAG", "YJ_HIJK_RBDA"."SENDER", "YJ_HIJK_RBDA"."SENDTIME", "YJ_HIJK_RBDA"."EMERGENCYFLAG", "YJ_HIJK_RBDA"."RECEIVER", "YJ_HIJK_RBDA"."RECEIVETIME", "YJ_HIJK_RBDA"."RECEIPTER", "YJ_HIJK_RBDA"."RECEIPTTIME", "YJ_HIJK_RBDA"."COLLECTER", "YJ_HIJK_RBDA"."STATEFLAG", "YJ_HIJK_RBDA"."REPEALER", "YJ_HIJK_RBDA"."REPEALTIME", "YJ_HIJK_RBDA"."REPEALCAUSE", "YJ_HIJK_RBDA"."STATION", ' ' disp, 0 jszt, decode(trim(bed), null, 'M', '', 'M', 'Z')\|\|deptno ksdm, trim(wardno) wardno, "YJ_HIJK_RBDA"."FROMTYPE", "YJ_HIJK_RBDA"."CREATETIME", "YJ_HIJK_RBDA"."COLLECTDATE", "YJ_HIJK_RBDA"."BBRQDM", ' ' yzmclx FROM "YJ_HIJK_RBDA" WHERE ( ( "YJ_HIJK_RBDA"."WARDNO" = :as_bqh ) AND ( "YJ_HIJK_RBDA"."STATEFLAG" in ('S', 'N') ) AND ( "YJ_HIJK_RBDA"."RECEIVEFLAG" = 0 ) AND ( "YJ_HIJK_RBDA"."FROMTYPE" = 'Z' ) AND ( "YJ_HIJK_RBDA"."CREATETIME" >= sysdate + :days ) )
902dk0b134jkv	begin logoffcheck.logoffaudit;end;
97znsa32k928r	begin :con := ASSETCHECK.QUERYPOLICY(:sn, :on); end;
9aqw9x9fx0dvu	SELECT VVALUE FROM SYSVAR WHERE UPPER ( PROG ) =:1 AND UPPER ( VNAME ) =:2
afr8r0vqs4ttx	SELECT "ZYBRXX"."ZYH", "ZYBRXX"."BRXM", "ZYBRXX"."ZYYSBH", "ZYBRXX"."ZYRQ", "ZYBRXX"."CYSJ", "ZYBRXX"."RYKS", "ZYBRXX"."KSBH", "ZYBRXX"."JZBZ", "ZYBRBASY"."BAZL", "ZYBRBASY"."ZKYS", "ZYBRBASY"."DCBZ", "ZYBRBASY"."BAGD", (trunc("ZYBRXX"."CYRQ") - trunc(DECODE("ZYBRXX"."RYSJ", NULL, DECODE("ZYBRXX"."RYRQ", null, "ZYBRXX"."ZYRQ", "ZYBRXX"."RYRQ"), "ZYBRXX"."RYSJ"))) ZYRS_SJ, (trunc("ZYBRXX"."CYRQ") - trunc(DECODE("ZYBRXX"."RYRQ", NULL, DECODE("ZYBRXX"."RYSJ", null, "ZYBRXX"."ZYRQ", "ZYBRXX"."RYSJ"), "ZYBRXX"."RYRQ"))) ZYRS, "ZYBRXX"."RYZD", "ZYBRXX"."SFZH", T3.SSMC, "ZYBRXX"."ZYBAH", "ZYBRXX"."ADDR", "ZYBRFZXX"."ZZ_PROVINCE", "ZYBRFZXX"."ZZ_CITY", "ZYBRFZXX"."ZZ_COUNTY", "ZYBRFZXX"."ZZ_TOWN" FROM "ZYBRBASY", "ZYBRXX", (SELECT T2.ZYH AS ZYH, LTRIM (MAX (SYS_CONNECT_BY_PATH (T2.SSMC, ';')), ';') AS SSMC FROM (SELECT T1.ZYH, T1.SSMC, rnFirst, LEAD (rnFirst) OVER (PARTITION BY T1.ZYH ORDER BY rnFirst) rnNext FROM (SELECT A.ZYH, A.SSMC, ROW_NUMBER () OVER (ORDER BY A.ZYH, A.XH) rnFirst FROM ZYBRSSSQ A) T1) T2 START WITH rnNext IS NULL CONNECT BY rnNext = PRIOR rnFirst GROUP BY T2.ZYH) T3, "ZYBRFZXX" WHERE ( "ZYBRXX"."ZYH" = "ZYBRBASY"."ZYH"(+) ) and ( ( "ZYBRXX"."CYRQ" is not null ) ) and ( "ZYBRXX"."BQH"= :BQH) and ( "ZYBRXX"."CYRQ" between :rq1 and :rq2) and ("ZYBRXX"."ZYH" = T3.ZYH(+)) AND ("ZYBRXX"."ZYH" = "ZYBRFZXX"."ZYH"(+)) ORDER BY "ZYBRXX"."CYRQ"
b3qg1rgb30j4u	SELECT * FROM EVTZYBR WHERE BQDM = :ARG_1 AND ZYH IN (SELECT ZYH FROM ZYBRXX WHERE BQH=EVTZYBR.BQDM AND CYRQ IS NULL)
b9u7d295c8fcm	declare -- local variables here begin --null; execute immediate 'begin logoffcheck.logoffaudit;end;'; exception when others then null; end trg_logoffevent;
bm7mx7h4nv3vn	SELECT "PDHJ_DLB_TMP"."LX" , "PDHJ_DLB_TMP"."DYBH" , "PDHJ_DLB_TMP"."DLBH" , "PDHJ_DLB_TMP"."LSH" , "PDHJ_DLB_TMP"."NO" , "PDHJ_DLB_TMP"."XM" , "PDHJ_DLB_TMP"."FSSJ" , "PDHJ_DLB_TMP"."NEWLSH" , "PDHJ_DLMCB_TMP"."DLMC" , "PDHJ_DLMCB_TMP"."DBZDFP" , "PDHJ_DLB_TMP"."RYBH" , "PDHJ_DLB_TMP"."PXH" , "PDHJ_DLB_TMP"."ZDRY" , "PDHJ_DLB_TMP"."SJBZ" , "PDHJ_DLLXB"."BZ" , DECODE(DLXZ, '1', DECODE(XZZT, '0', 3, DECODE((SELECT NVL(ZBLSH, 0) FROM PDHJ_DLB_TMP_EXT WHERE LX = PDHJ_DLB_TMP.LX AND DYBH = PDHJ_DLB_TMP.DYBH AND LSH=PDHJ_DLB_TMP.LSH), 0, 1, 2)), 0) ZT, "PDHJ_DLB_TMP"."YXLX" , "PDHJ_RYXXB"."KH" FROM "PDHJ_DLB_TMP" , "PDHJ_DLMCB_TMP" , "PDHJ_DLLXB" , "PDHJ_RYXXB" WHERE ( "PDHJ_DLB_TMP"."LX" = "PDHJ_DLMCB_TMP"."LX" ) and ( "PDHJ_DLB_TMP"."DYBH" = "PDHJ_DLMCB_TMP"."DLBH" ) and ( "PDHJ_DLLXB"."DM" = "PDHJ_DLB_TMP"."LX" ) and ( "PDHJ_DLB_TMP"."RYBH" = "PDHJ_RYXXB"."RYBH" ) and ("PDHJ_DLB_TMP"."NEWLSH" = 0 or ( "PDHJ_DLB_TMP"."NEWLSH" is null) ) and ( instrb( :as_dybh, "PDHJ_DLB_TMP"."LX"\|\|'_'\|\|"PDHJ_DLB_TMP"."DYBH") > 0 ) and ( "PDHJ_DLB_TMP"."FSSJ" >= (SYSDATE - :an_day) ) ORDER BY "PDHJ_DLB_TMP"."LX" ASC, "PDHJ_DLB_TMP"."DYBH" ASC, "PDHJ_DLB_TMP"." NO" ASC
bpnuwmvwavhkz	SELECT "HYTS"."NO" , "HYTS"."BQH" , "HYTS"."TSSJ" , "HYTS"."TSRY" , "HYTS"."TSLX" , "HYTS"."TSNR" , "HYTS"."ZYH" , "HYTS"."QRRY" , "HYTS"."QRSJ" , "HYTS"."QRCL" , "HYTS"."BRBH" , "ZYBRXX"."BRXM" , "ZYBRXX"."CWH" , "YJ_HIJK_RBDA"."DOCTOR" , "HYTS"."QRFW" , "HYTS"."HSQRRY" , "HYTS"."HSQRSJ" , "HYTS"."TXM" FROM "HYTS" , "ZYBRXX" , "YJ_HIJK_RBDA" WHERE ( "HYTS"."ZYH" = "ZYBRXX"."ZYH" ) and ( "HYTS"."TXM" = "YJ_HIJK_RBDA"."SERIALNO" ) and ( ( "HYTS"."BQH" = :as_bqh ) And ( "HYTS"."TSSJ" between :adt_sj1 and :adt_sj2 ) and ( "HYTS"."TSLX" = :ai_tslx ) )
bt6jm5m4bfm62	SELECT /+ first_rows /RULE_VALUE, FAUDIT, F_ACTION_ID, SAUDIT, S_ACTION_ID, SQLTYPE, PRIV_RULEVALUE, ENABLED FROM MC$ASSET_SQL_RULE WHERE CMDTYPE=:B2 AND REPLACE(REPLACE(REPLACE(REPLACE(UPPER(TRIM(:B1 )), CHR(10), CHR(32)), CHR(32), ''), CHR(13), ''), CHR(9), '') LIKE '%'\|\|REPLACE(REPLACE(REPLACE(REPLACE(UPPER(TRIM(SQL_TEXT)), CHR(10), CHR(32)), CHR(32), ''), CHR(13), ''), CHR(9), '') AND LENGTHB(REPLACE(REPLACE(REPLACE(REPLACE(UPPER(TRIM(:B1 )), CHR(10), CHR(32)), CHR(32), ''), CHR(13), ''), CHR(9), ''))>= LENGTHB(REPLACE(REPLACE(REPLACE(REPLACE(UPPER(TRIM(SQL_TEXT)), CHR(10), CHR(32)), CHR(32), ''), CHR(13), ''), CHR(9), '')) AND ROWNUM=1
d0uxjp6nd5m9r	SELECT "YJ_HIJK_RBDA"."SBXH" , "YJ_HIJK_RBDA"."SERIALNO" , "YJ_HIJK_RBDA"."RECEIVEFLAG" , "YJ_HIJK_RBDA"."SAMPLETYPENO" , "YJ_HIJK_RBDA"."PATNO" , "YJ_HIJK_RBDA"."CNAME" , "YJ_HIJK_RBDA"."BIRTHDAY" , "YJ_HIJK_RBDA"."AGE" , "YJ_HIJK_RBDA"."BED" , "YJ_HIJK_RBDA"."DEPTNO" , "YJ_HIJK_RBDA"."DOCTOR" , "YJ_HIJK_RBDA"."DIAG" , "YJ_HIJK_RBDA"."COLLECTTIME" , "YJ_HIJK_RBDA"."QDSJ" , "YJ_HIJK_RBDA"."QDDD" , "HYBBZLB"."MC" , "YJ_HIJK_RBDA"."CHARGEFLAG" , "YJ_HIJK_RBDA"."SENDER" , "YJ_HIJK_RBDA"."SENDTIME" , "YJ_HIJK_RBDA"."EMERGENCYFLAG" , "KSMC"."MC" , "YJ_HIJK_RBDA"."RECEIVER" , "YJ_HIJK_RBDA"."RECEIVETIME" , "YJ_HIJK_RBDA"."RECEIPTER" , "YJ_HIJK_RBDA"."RECEIPTTIME" , "YJ_HIJK_RBDA"."COLLECTER" , "YJ_HIJK_RBDA"."STATEFLAG" , "YJ_HIJK_RBDA"."REPEALER" , "YJ_HIJK_RBDA"."REPEALTIME" , "YJ_HIJK_RBDA"."REPEALCAUSE" , "YJ_HIJK_RBDA"."STATION" , ' ' disp, 0 jszt, decode(trim(bed), null, 'M', '', 'M', 'Z')\|\|deptno ksdm, trim(wardno) wardno, "YJ_HIJK_RBDA"."FROMTYPE" , "YJ_HIJK_RBDA"."CREATETIME" , "YJ_HIJK_RBDA"."COLLECTDATE" , "YJ_HIJK_RBDA"."BBRQDM" , ' ' yzmclx, "YJ_HIJK_RBDA"."PRINTTIME" , DECODE(FROMTYPE, 'M', (SELECT BLBH FROM MZBRXX WHERE BRBH = TO_NUMBER(YJ_HIJK_RBDA.PATNO) ), YJ_HIJK_RBDA.PATNO) BLBH FROM "YJ_HIJK_RBDA" , "HYBBZLB" , "KSMC" , "HYBBFSJL" WHERE ( "YJ_HIJK_RBDA"."SAMPLETYPENO" = "HYBBZLB"."DM" (+)) and ( "YJ_HIJK_RBDA"."DEPTNO" = "KSMC"."NO" (+)) and ( "YJ_HIJK_RBDA"."SERIALNO" = "HYBBFSJL"."TXM" ) and ( ( "HYBBFSJL"."FSDZ" = :as_fsdz ) and ( "HYBBFSJL"."ID" = :ai_id ) and ( "HYBBFSJL"."ZT" = :as_zt ) and ( "YJ_HIJK_RBDA"."STATEFLAG" in ('C', 'N') ) )
d18dmmshv3770	INSERT INTO ZYFY ( ZYH , XH , BQH , FBLX , RQ , DM , YPNO , SL , JE , ZFJE , XFJE , SRRY , SRRYZH , KSBH , FYTJDM , YEBZ , SRKSBH , YSBH , YSZH , YBZFJE , YPJJ , HDRY ) VALUES ( :1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 )
djsrgdvba5c0q	SELECT RESHOW FROM PDHJ_PHB WHERE PH =:1
dk8b8tk4xuk0y	Select Count ( *) FROM PDHJ_PHB WHERE Instr ( :1 , '\|' \|\| Upper ( Ph ) \|\| '\|' ) > 0 And ReShow1 =1
f8pmzwz7mmjua	SELECT VVALUE From SYSVAR Where PROG =:1 And VNAME =:2
f95ar85c9c72r	SELECT SUM ( JE ) , SUM ( ZFJE ) FROM ZYJZFY WHERE ZYH =:1 OR ZYH LIKE :2
g2cvz8zqq6h8n	SELECT TABLE_NAME NAME FROM DBA_TABLES WHERE OWNER= :B2 AND TABLE_NAME=:B1
gb21rmwra3102	SELECT DATA_LENGTH FROM USER_TAB_COLUMNS WHERE TABLE_NAME = :tname AND COLUMN_NAME = :cname

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	300,999	327.97	22.85
CPU used when call started	300,394	327.31	22.80
CR blocks created	7,831	8.53	0.59
Cached Commit SCN referenced	131,937	143.76	10.02
Commit SCN cached	2	0.00	0.00
DB time	8,807,643	9,596.78	668.61
DBWR checkpoint buffers written	15,430	16.81	1.17
DBWR checkpoints	4	0.00	0.00
DBWR object drop buffers written	8	0.01	0.00
DBWR revisited being-written buffer	2	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	62	0.07	0.00
DBWR undo block writes	4,608	5.02	0.35
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	0	0.00	0.00
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	0	0.00	0.00
IMU Redo allocation size	0	0.00	0.00
IMU commits	0	0.00	0.00
IMU contention	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	0	0.00	0.00
IMU- failed to get a private strand	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for supplemental logging cleanup	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	4,541,957	4,948.90	344.79
active txn count during cleanout	7,418	8.08	0.56
application wait time	27,606	30.08	2.10
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	3	0.00	0.00
background checkpoints started	3	0.00	0.00
background timeouts	2,913	3.17	0.22
branch node splits	1	0.00	0.00
buffer is not pinned count	46,519,571	50,687.56	3,531.43
buffer is pinned count	152,353,693	166,004.04	11,565.60
bytes received via SQL*Net from client	273,102,229	297,571.21	20,731.97
bytes sent via SQL*Net to client	1,381,004,702	1,504,737.79	104,836.01
calls to get snapshot scn: kcmgss	1,477,962	1,610.38	112.20
calls to kcmgas	32,633	35.56	2.48
calls to kcmgcs	1,261	1.37	0.10
change write time	1,295	1.41	0.10
cleanout - number of ktugct calls	6,841	7.45	0.52
cleanouts and rollbacks - consistent read gets	5,561	6.06	0.42
cleanouts only - consistent read gets	163	0.18	0.01
cluster key scan block gets	519,972	566.56	39.47
cluster key scans	162,875	177.47	12.36
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	449	0.49	0.03
commit batch/immediate requested	449	0.49	0.03
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	119	0.13	0.01
commit cleanout failures: cannot pin	16	0.02	0.00
commit cleanouts	62,980	68.62	4.78
commit cleanouts successfully completed	62,845	68.48	4.77
commit immediate performed	449	0.49	0.03
commit immediate requested	449	0.49	0.03
commit txn count during cleanout	2,395	2.61	0.18
concurrency wait time	5,571,549	6,070.74	422.95
consistent changes	19,567	21.32	1.49
consistent gets	71,608,289	78,024.14	5,435.99
consistent gets - examination	13,864,371	15,106.57	1,052.48
consistent gets direct	20	0.02	0.00
consistent gets from cache	71,608,231	78,024.07	5,435.99
current blocks converted for CR	0	0.00	0.00
cursor authentications	2,319	2.53	0.18
data blocks consistent reads - undo records applied	19,488	21.23	1.48
db block changes	376,289	410.00	28.57
db block gets	665,844	725.50	50.55
db block gets direct	211	0.23	0.02
db block gets from cache	665,633	725.27	50.53
deferred (CURRENT) block cleanout applications	28,828	31.41	2.19
dirty buffers inspected	2,284	2.49	0.17
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	1,582	1.72	0.12
enqueue deadlocks	0	0.00	0.00
enqueue releases	144,109	157.02	10.94
enqueue requests	144,088	157.00	10.94
enqueue timeouts	8	0.01	0.00
enqueue waits	2,289	2.49	0.17
exchange deadlocks	0	0.00	0.00
execute count	1,061,500	1,156.61	80.58
frame signature mismatch	0	0.00	0.00
free buffer inspected	595,215	648.54	45.18
free buffer requested	467,247	509.11	35.47
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	2,094	2.28	0.16
hot buffers moved to head of LRU	1,123,209	1,223.84	85.27
immediate (CR) block cleanout applications	5,724	6.24	0.43
immediate (CURRENT) block cleanout applications	2,410	2.63	0.18
index fast full scans (full)	331	0.36	0.03
index fetch by key	6,431,087	7,007.29	488.20
index scans kdiixs1	827,618	901.77	62.83
leaf node 90-10 splits	95	0.10	0.01
leaf node splits	307	0.33	0.02
lob reads	101	0.11	0.01
lob writes	54	0.06	0.00
lob writes unaligned	54	0.06	0.00
local undo segment hints helped	0	0.00	0.00
local undo segment hints were stale	0	0.00	0.00
logons cumulative	1,663	1.81	0.13
messages received	13,065	14.24	0.99
messages sent	13,065	14.24	0.99
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	56,352,441	61,401.42	4,277.87
opened cursors cumulative	257,443	280.51	19.54
parse count (failures)	36,579	39.86	2.78
parse count (hard)	48,038	52.34	3.65
parse count (total)	981,828	1,069.80	74.53
parse time cpu	169,297	184.47	12.85
parse time elapsed	6,805,801	7,415.58	516.65
physical read IO requests	93,398	101.77	7.09
physical read bytes	4,032,487,424	4,393,783.88	306,117.62
physical read total IO requests	117,850	128.41	8.95
physical read total bytes	4,572,459,008	4,982,134.99	347,108.40
physical read total multi block requests	33,073	36.04	2.51
physical reads	492,247	536.35	37.37
physical reads cache	450,062	490.39	34.17
physical reads cache prefetch	358,307	390.41	27.20
physical reads direct	42,185	45.96	3.20
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	41,919	45.67	3.18
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	14,309	15.59	1.09
physical write bytes	504,856,576	550,089.92	38,325.10
physical write total IO requests	30,091	32.79	2.28
physical write total bytes	708,767,744	772,270.80	53,804.58
physical write total multi block requests	12,520	13.64	0.95
physical writes	61,628	67.15	4.68
physical writes direct	42,310	46.10	3.21
physical writes direct (lob)	20	0.02	0.00
physical writes direct temporary tablespace	41,919	45.67	3.18
physical writes from cache	19,318	21.05	1.47
physical writes non checkpoint	52,830	57.56	4.01
pinned buffers inspected	59	0.06	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	916	1.00	0.07
recovery blocks read	0	0.00	0.00
recursive calls	790,378	861.19	60.00
recursive cpu usage	46,121	50.25	3.50
redo blocks read for recovery	0	0.00	0.00
redo blocks written	76,149	82.97	5.78
redo buffer allocation retries	5	0.01	0.00
redo entries	194,455	211.88	14.76
redo log space requests	5	0.01	0.00
redo log space wait time	16	0.02	0.00
redo ordering marks	3,611	3.93	0.27
redo size	69,655,968	75,896.89	5,287.78
redo synch time	5,834	6.36	0.44
redo synch writes	24,925	27.16	1.89
redo wastage	7,063,552	7,696.42	536.21
redo write time	2,642	2.88	0.20
redo writer latching time	284	0.31	0.02
redo writes	12,740	13.88	0.97
rollback changes - undo records applied	5,245	5.71	0.40
rollbacks only - consistent read gets	2,362	2.57	0.18
rows fetched via callback	4,117,473	4,486.38	312.57
session connect time	0	0.00	0.00
session cursor cache hits	617,659	673.00	46.89
session logical reads	72,275,129	78,750.72	5,486.61
session pga memory	107,009,776	116,597.47	8,123.42
session pga memory max	84,740,976	92,333.46	6,432.93
session uga memory	81,688,992,720	89,008,034.38	6,201,244.42
session uga memory max	2,528,216,000	2,754,735.11	191,924.09
shared hash latch upgrades - no wait	920,289	1,002.74	69.86
shared hash latch upgrades - wait	36	0.04	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	79,947	87.11	6.07
sorts (rows)	10,137,485	11,045.77	769.57
space was found by tune down	0	0.00	0.00
space was not found by tune down	0	0.00	0.00
sql area purged	18,016	19.63	1.37
steps of tune down ret. in space pressure	0	0.00	0.00
summed dirty queue length	2,433	2.65	0.18
switch current to new buffer	4,780	5.21	0.36
table fetch by rowid	92,429,852	100,711.24	7,016.61
table fetch continued row	1,563,132	1,703.18	118.66
table scan blocks gotten	19,257,058	20,982.42	1,461.86
table scan rows gotten	1,315,641,959	1,433,518.77	99,874.13
table scans (cache partitions)	0	0.00	0.00
table scans (long tables)	5	0.01	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	174,105	189.70	13.22
total number of times SMON posted	3	0.00	0.00
transaction rollbacks	449	0.49	0.03
transaction tables consistent read rollbacks	2	0.00	0.00
transaction tables consistent reads - undo records applied	45	0.05	0.00
tune down retentions in space pressure	0	0.00	0.00
undo change vector size	24,533,008	26,731.08	1,862.37
user I/O wait time	28,960	31.55	2.20
user calls	4,620,940	5,034.96	350.79
user commits	11,892	12.96	0.90
user rollbacks	1,281	1.40	0.10
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	4	0.00	0.00
workarea executions - optimal	96,853	105.53	7.35
write clones created in background	3	0.00	0.00
write clones created in foreground	5	0.01	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	182,068,008	182,093,950
opened cursors current	51,250	53,860
workarea memory allocated	45,498	27,083
logons current	1,157	1,212

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	3	11.77

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)
KT_HMISW2003	65,924	72	3.22	3.50	7,721	8	8	0.00
KT_ZYFQXX	13,973	15	2.30	14.86	339	0	0	0.00
KT_HYJCXX	6,290	7	2.66	1.00	1,328	1	0	0.00
TEMP	1,377	2	6.77	30.44	1,377	2	0	0.00
KT_MZFQXX	1,464	2	4.10	1.00	334	0	2	0.00
KT_JKXX	636	1	5.86	1.00	963	1	0	0.00
SYSAUX	1,127	1	5.37	1.03	358	0	0	0.00
KT_MZFQINDEX	760	1	6.13	1.00	434	0	0	0.00
KT_ZYFQINDEX	685	1	5.71	1.00	427	0	0	0.00
SYSTEM	854	1	3.01	1.00	41	0	0	0.00
UNDOTBS1	14	0	0.00	1.00	680	1	53	38.11
CAPAATPS	312	0	5.93	1.00	276	0	0	0.00
KT_YBXX	25	0	4.00	1.00	77	0	0	0.00
UNDOTBS2	17	0	2.94	1.00	3	0	0	0.00
KT_TRAN	12	0	2.50	1.00	7	0	0	0.00
USERS	6	0	1.67	2.83	5	0	0	0.00
KTSMS	6	0	0.00	1.00	3	0	0	0.00
KT_HISQUERY	6	0	0.00	1.00	3	0	0	0.00
KT_NBXX	5	0	2.00	1.00	3	0	0	0.00
KTHW_DATA	3	0	0.00	1.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)
CAPAATPS	/data/feyy/oradata/feyy/capaa01.dbf	312	0	5.93	1.00	276	0	0	0.00
KTHW_DATA	/data/feyy/oradata/feyy/KTHW_data.dbf	3	0	0.00	1.00	3	0	0	0.00
KTSMS	/data/feyy/oradata/feyy/KTSMS.dbf	6	0	0.00	1.00	3	0	0	0.00
KT_HISQUERY	/data/feyy/oradata/feyy/HISQUERY.dbf	6	0	0.00	1.00	3	0	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW01.dbf	2,837	3	3.15	1.10	118	0	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW02.dbf	2,715	3	3.01	1.08	273	0	3	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW03.dbf	2,583	3	2.93	1.15	185	0	2	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW04.dbf	2,527	3	4.25	1.21	142	0	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW06.dbf	4,785	5	3.38	6.46	56	0	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW10.dbf	6,153	7	2.28	5.22	64	0	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW11.dbf	7,140	8	2.51	5.84	75	0	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW12.dbf	10,614	12	3.05	3.44	692	1	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW13.dbf	5,233	6	4.51	5.15	81	0	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW14.dbf	6,609	7	2.68	4.25	68	0	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW15.dbf	3,264	4	2.47	3.03	101	0	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW16.dbf	385	0	4.65	1.00	55	0	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW17.dbf	3,926	4	4.62	1.01	2,753	3	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW18.dbf	938	1	6.48	1.00	2,292	2	3	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW19.dbf	130	0	5.54	1.00	519	1	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW20.dbf	3	0	0.00	1.00	0	0	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW2003.dbf	2,151	2	2.98	1.08	134	0	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW200301.dbf	2,217	2	3.51	1.16	72	0	0	0.00
KT_HMISW2003	/data/feyy/oradata/feyy/KT_HMISW200302.dbf	1,714	2	3.65	1.07	41	0	0	0.00
KT_HYJCXX	/data/feyy/oradata/feyy/KT_HYJCXX.dbf	11	0	1.82	1.00	5	0	0	0.00
KT_HYJCXX	/data/feyy/oradata/feyy/KT_HYJCXX01.dbf	7	0	4.29	1.00	4	0	0	0.00
KT_HYJCXX	/data/feyy/oradata/feyy/KT_HYJCXX02.dbf	6	0	0.00	1.00	4	0	0	0.00
KT_HYJCXX	/data/feyy/oradata/feyy/KT_HYJCXX03.dbf	6	0	0.00	1.00	3	0	0	0.00
KT_HYJCXX	/data/feyy/oradata/feyy/KT_HYJCXX04.dbf	568	1	2.06	1.00	17	0	0	0.00
KT_HYJCXX	/data/feyy/oradata/feyy/KT_HYJCXX05.dbf	152	0	4.54	1.00	22	0	0	0.00
KT_HYJCXX	/data/feyy/oradata/feyy/KT_HYJCXX06.dbf	2,048	2	1.93	1.00	263	0	0	0.00
KT_HYJCXX	/data/feyy/oradata/feyy/KT_HYJCXX07.dbf	1,623	2	2.78	1.00	232	0	0	0.00
KT_HYJCXX	/data/feyy/oradata/feyy/KT_HYJCXX08.dbf	1,497	2	2.95	1.00	426	0	0	0.00
KT_HYJCXX	/data/feyy/oradata/feyy/KT_HYJCXX09.dbf	372	0	5.11	1.00	352	0	0	0.00
KT_JKXX	/data/feyy/oradata/feyy/KT_JKXX.dbf	218	0	7.02	1.00	270	0	0	0.00
KT_JKXX	/data/feyy/oradata/feyy/KT_JKXX01.dbf	183	0	5.68	1.00	256	0	0	0.00
KT_JKXX	/data/feyy/oradata/feyy/KT_JKXX02.dbf	6	0	0.00	1.00	3	0	0	0.00
KT_JKXX	/data/feyy/oradata/feyy/KT_JKXX03.dbf	14	0	3.57	1.00	15	0	0	0.00
KT_JKXX	/data/feyy/oradata/feyy/KT_JKXX04.dbf	12	0	0.83	1.00	13	0	0	0.00
KT_JKXX	/data/feyy/oradata/feyy/KT_JKXX05.dbf	7	0	1.43	1.00	5	0	0	0.00
KT_JKXX	/data/feyy/oradata/feyy/KT_JKXX06.dbf	7	0	2.86	1.00	8	0	0	0.00
KT_JKXX	/data/feyy/oradata/feyy/KT_JKXX07.dbf	65	0	3.69	1.00	200	0	0	0.00
KT_JKXX	/data/feyy/oradata/feyy/KT_JKXX08.dbf	35	0	8.57	1.00	45	0	0	0.00
KT_JKXX	/data/feyy/oradata/feyy/KT_JKXX09.dbf	89	0	5.96	1.00	148	0	0	0.00
KT_MZFQINDEX	/data/feyy/oradata/feyy/KT_MZFQINDEX.dbf	260	0	6.54	1.00	175	0	0	0.00
KT_MZFQINDEX	/data/feyy/oradata/feyy/KT_MZFQINDEX01.dbf	500	1	5.92	1.00	259	0	0	0.00
KT_MZFQXX	/data/feyy/oradata/feyy/KT_MZFQXX.dbf	120	0	6.25	1.00	16	0	0	0.00
KT_MZFQXX	/data/feyy/oradata/feyy/KT_MZFQXX01.dbf	150	0	5.60	1.00	6	0	0	0.00
KT_MZFQXX	/data/feyy/oradata/feyy/KT_MZFQXX02.dbf	1,194	1	3.69	1.00	312	0	2	0.00
KT_NBXX	/data/feyy/oradata/feyy/KT_NBXX.dbf	5	0	2.00	1.00	3	0	0	0.00
KT_TRAN	/data/feyy/oradata/feyy/KT_TRAN01.dbf	12	0	2.50	1.00	7	0	0	0.00
KT_YBXX	/data/feyy/oradata/feyy/KT_YBXX.dbf	14	0	5.00	1.00	53	0	0	0.00
KT_YBXX	/data/feyy/oradata/feyy/KT_YBXX01.dbf	11	0	2.73	1.00	24	0	0	0.00
KT_ZYFQINDEX	/data/feyy/oradata/feyy/KT_ZYFQINDEX.dbf	21	0	3.33	1.00	17	0	0	0.00
KT_ZYFQINDEX	/data/feyy/oradata/feyy/KT_ZYFQINDEX01.dbf	664	1	5.78	1.00	410	0	0	0.00
KT_ZYFQXX	/data/feyy/oradata/feyy/KT_ZYFQXX.dbf	4,431	5	2.50	15.63	4	0	0	0.00
KT_ZYFQXX	/data/feyy/oradata/feyy/KT_ZYFQXX01.dbf	4,624	5	2.75	15.74	3	0	0	0.00
KT_ZYFQXX	/data/feyy/oradata/feyy/KT_ZYFQXX02.dbf	4,918	5	1.68	13.35	332	0	0	0.00
SYSAUX	/data/feyy/oradata/feyy/sysaux01.dbf	1,127	1	5.37	1.03	358	0	0	0.00
SYSTEM	/data/feyy/oradata/feyy/system01.dbf	854	1	3.01	1.00	41	0	0	0.00
TEMP	/data/feyy/oradata/feyy/temp01.dbf	1,377	2	6.77	30.44	1,377	2	0
UNDOTBS1	/data/feyy/oradata/feyy/undotbs01.dbf	14	0	0.00	1.00	680	1	53	38.11
UNDOTBS2	/data/feyy/oradata/feyy/undotbs02.dbf	17	0	2.94	1.00	3	0	0	0.00
USERS	/data/feyy/oradata/feyy/users01.dbf	6	0	1.67	2.83	5	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	1,109,054	99	71,991,675	450,158	19,318	0	0	63

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	25	7487	41396	165748	3774870	165748
E	0	22	5729	35913	187806	3774870	187806

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	880	0.10	109,120	2.53	7,033,396,046
D	1,760	0.20	218,240	1.97	5,469,118,469
D	2,640	0.30	327,360	1.73	4,822,616,753
D	3,520	0.39	436,480	1.62	4,495,898,555
D	4,400	0.49	545,600	1.36	3,773,998,191
D	5,280	0.59	654,720	1.25	3,477,195,400
D	6,160	0.69	763,840	1.15	3,206,533,375
D	7,040	0.79	872,960	1.09	3,023,132,660
D	7,920	0.89	982,080	1.04	2,890,606,919
D	8,800	0.98	1,091,200	1.00	2,795,687,097
D	8,944	1.00	1,109,056	1.00	2,782,242,246
D	9,680	1.08	1,200,320	0.98	2,718,835,508
D	10,560	1.18	1,309,440	0.95	2,652,843,352
D	11,440	1.28	1,418,560	0.93	2,591,945,596
D	12,320	1.38	1,527,680	0.91	2,537,720,681
D	13,200	1.48	1,636,800	0.90	2,497,498,462
D	14,080	1.57	1,745,920	0.88	2,460,884,761
D	14,960	1.67	1,855,040	0.87	2,427,844,800
D	15,840	1.77	1,964,160	0.86	2,397,476,421
D	16,720	1.87	2,073,280	0.85	2,370,506,717
D	17,600	1.97	2,182,400	0.83	2,317,623,155

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
93.26	9,485	686

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,000	125	2,843.94	17.56	0.62	100.00	0.00	204,800
E	2,000	125	2,956.60	1.20	0.04	100.00	0.00	204,800

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs
2K	4K	86,783	86,783	0
64K	128K	325	325	0
128K	256K	1,626	1,626	0
256K	512K	239	239	0
512K	1024K	3,930	3,930	0
1M	2M	3,840	3,840	0
2M	4M	37	37	0
4M	8M	52	52	0
8M	16M	7	5	2
16M	32M	14	14	0
256M	512M	2	0	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
250	0.13	32,668,487.09	5,534,886.46	86.00	249,600
500	0.25	32,668,487.09	5,534,030.58	86.00	249,563
1,000	0.50	32,668,487.09	5,454,868.32	86.00	246,762
1,500	0.75	32,668,487.09	3,710,955.87	90.00	177,904
2,000	1.00	32,668,487.09	259,735.21	99.00	46,176
2,400	1.20	32,668,487.09	234,453.16	99.00	28,408
2,800	1.40	32,668,487.09	234,178.09	99.00	25,026
3,200	1.60	32,668,487.09	234,160.23	99.00	24,979
3,600	1.80	32,668,487.09	234,160.23	99.00	24,834
4,000	2.00	32,668,487.09	234,160.23	99.00	24,786
6,000	3.00	32,668,487.09	233,761.99	99.00	23,467
8,000	4.00	32,668,487.09	233,068.15	99.00	20,293
12,000	6.00	32,668,487.09	231,657.03	99.00	13,229
16,000	8.00	32,668,487.09	231,634.40	99.00	4,856

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
1,792	0.60	319	28,052	112,533,151	1.00	2,046,754	1.26	3,006,474,831
2,096	0.70	618	58,998	112,896,935	1.00	1,682,970	1.04	3,030,661,868
2,400	0.80	921	92,263	112,931,750	1.00	1,648,155	1.01	3,032,940,666
2,704	0.90	1,224	126,270	112,947,232	1.00	1,632,673	1.01	3,034,049,038
3,008	1.00	1,527	160,685	112,955,347	1.00	1,624,558	1.00	3,034,689,833
3,312	1.10	1,830	194,532	112,960,776	1.00	1,619,129	1.00	3,035,132,581
3,616	1.20	2,133	227,146	112,964,531	1.00	1,615,374	0.99	3,035,483,381
3,920	1.30	2,436	262,935	112,967,646	1.00	1,612,259	0.99	3,035,786,508
4,224	1.40	2,739	289,174	112,970,590	1.00	1,609,315	0.99	3,036,057,664
4,528	1.51	3,042	319,778	112,973,289	1.00	1,606,616	0.99	3,036,303,774
4,832	1.61	3,345	357,276	112,975,616	1.00	1,604,289	0.99	3,036,516,263
5,136	1.71	3,648	394,279	112,977,827	1.00	1,602,078	0.99	3,036,707,399
5,440	1.81	3,951	430,302	112,979,569	1.00	1,600,336	0.99	3,036,879,178
5,744	1.91	4,254	466,490	112,981,219	1.00	1,598,686	0.98	3,037,021,046
6,048	2.01	4,557	501,781	112,982,527	1.00	1,597,378	0.98	3,037,135,390

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
3,000	0.25	17,215,613	7,197,379,991
6,000	0.50	12,677,781	4,600,714,195
9,000	0.75	10,099,815	3,093,574,089
12,000	1.00	9,509,287	2,782,241,289
15,000	1.25	9,233,519	2,596,944,019
18,000	1.50	9,205,943	2,596,944,019
21,000	1.75	9,205,943	2,484,541,471
24,000	2.00	9,205,945	2,371,582,475

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

Java Pool Size(M)	JP 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
16	1.00	0	206	4	1.00	1,624,558	1.00	206
32	2.00	0	206	4	1.00	1,624,558	1.00	206

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)
undo block	25	2	77
undo header	28	0	4
data block	10	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)
CU-Cursor	66,361	66,354	2,262	19	8.33
TX-Transaction (row lock contention)	21	21	21	15	711.57
SQ-Sequence Cache	302	302	10	0	48.30
RO-Multiple Object Reuse (fast object reuse)	9	9	1	0	1.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	5.32	22,064	586	19	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
13-Nov 10:44	2,301	9,625	586	19	180	0/0	0/0/0/0/0/0
13-Nov 10:34	3,016	12,439	41	15	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
AWR Alerted Metric Element list	22,625	0.00		0	0
Consistent RBA	12,949	0.00		0	0
FAL request queue	29	0.00		0	0
FAL subheap alocation	29	0.00		0	0
FIB s.o chain latch	36	0.00		0	0
FOB s.o list latch	12,536	0.01	0.00	0	0
JS queue state obj latch	6,120	0.00		0	0
JS slv state obj latch	17	0.00		0	0
KMG MMAN ready and startup request latch	305	0.00		0	0
KTF sga latch	0			0	289	0.00
KWQMN job cache list latch	17	0.00		0	0
LGWR NS Write	198	0.00		0	0
MQL Tracking Latch	0			0	20	0.00
Memory Management Latch	0			0	305	0.00
OS process	4,854	0.00		0	0
OS process allocation	3,601	0.00		0	0
OS process: request allocation	3,252	0.00		0	0
PL/SQL warning settings	49,637	0.00		0	0
SGA IO buffer pool latch	144	0.00		0	144	0.00
SQL memory manager latch	2	0.00		0	304	0.00
SQL memory manager workarea list latch	142,944	0.00	1.00	1	0
Shared B-Tree	32	0.00		0	0
active checkpoint queue latch	630	0.00		0	0
active service list	10,479	0.00		0	313	0.00
alert log latch	3	0.00		0	0
archive control	5,923	0.00		0	0
archive process latch	333	0.30	1.00	0	0
begin backup scn array	36	0.00		0	0
cache buffer handles	54,970	0.00	0.00	0	0
cache buffers chains	132,253,232	0.01	0.06	161	1,003,970	0.01
cache buffers lru chain	68,427	0.11	0.46	5	923,988	0.32
cache table scan latch	0			0	30,800	0.00
channel handle pool latch	3,259	0.00		0	0
channel operations parent latch	9,236	0.00		0	0
checkpoint queue latch	39,594	0.00		0	17,497	0.01
client/application info	14,262	0.00		0	0
commit callback allocation	20	0.00		0	0
compile environment latch	38,592	0.00		0	0
dictionary lookup	1	0.00		0	0
dml lock allocation	88,454	0.03	0.59	1	0
dummy allocation	3,289	0.03	0.00	0	0
enqueue hash chains	294,620	0.06	0.64	2	2,029	0.00
enqueues	204,028	0.53	0.73	20	0
event group latch	1,656	0.00		0	0
file cache latch	131	0.00		0	0
global KZLD latch for mem in SGA	1,643	0.00		0	0
global ctx hash table latch	42,876	0.00		0	0
global tx hash mapping	1,847	0.00		0	0
hash table column usage latch	235	0.00		0	697,660	0.00
hash table modification latch	13	0.00		0	0
job workq parent latch	0			0	38	0.00
job_queue_processes parameter latch	33	0.00		0	0
kks stats	32,919	0.43	0.96	9	0
ksuosstats global area	63	0.00		0	0
ktm global data	6	0.00		0	0
kwqbsn:qsga	32	0.00		0	0
lgwr LWN SCN	12,972	0.17	0.05	0	0
library cache	7,138,409	5.71	0.82	24117	23,968	18.14
library cache load lock	754	0.00		0	0
library cache lock	2,799,586	0.59	0.60	276	0
library cache lock allocation	62,108	0.01	0.38	1	0
library cache pin	4,796,928	1.00	0.66	894	24,169	2.64
library cache pin allocation	21,099	0.01	1.00	0	0
list of block allocation	2,064	0.00		0	0
loader state object freelist	206	0.00		0	0
longop free list parent	45	0.00		0	42	0.00
message pool operations parent latch	9	0.00		0	0
messages	47,218	0.00		0	0
mostly latch-free SCN	12,983	0.23	0.13	0	0
multiblock read objects	74,480	0.00	0.00	0	0
ncodef allocation latch	21	0.00		0	0
object queue header heap	421	0.00		0	444	0.00
object queue header operation	977,472	0.00	0.44	3	0
object stats modification	3	0.00		0	0
parallel query alloc buffer	124	0.00		0	0
parameter list	6,719	0.00		0	0
parameter table allocation management	1,689	0.12	0.50	0	0
post/wait queue	17,663	0.01	1.00	0	11,598	0.01
process allocation	3,252	0.12	0.75	0	1,656	0.00
process group creation	3,252	0.00		0	0
qmn task queue latch	128	25.00	1.00	0	0
redo allocation	42,665	0.05	0.57	2	195,807	0.07
redo copy	0			0	195,852	0.17
redo writing	40,235	0.00	1.00	0	0
resmgr group change latch	2,186	0.00		0	0
resmgr:actses active list	3,295	0.00		0	0
resmgr:actses change group	1,663	0.00		0	0
resmgr:actses change state	7	0.00		0	0
resmgr:free threads list	3,281	0.03	1.00	0	0
resmgr:resource group CPU method	7	0.00		0	0
row cache objects	4,717,039	0.17	0.06	104	791	0.00
rules engine aggregate statistics	8	0.00		0	0
rules engine rule set statistics	16	0.00		0	0
sequence cache	62,320	0.02	0.69	0	0
session allocation	545,299	0.17	0.32	2	0
session idle bit	9,300,076	0.06	0.36	8	0
session state list latch	12,062	0.12	0.53	0	0
session switching	40	0.00		0	0
session timer	313	0.00		0	0
shared pool	1,406,022	2.08	0.47	1469	0
simulator hash latch	3,942,370	0.00	0.11	1	0
simulator lru latch	3,891,196	0.42	0.14	55	28,434	0.21
slave class	4	0.00		0	0
slave class create	16	6.25	1.00	0	0
sort extent pool	381	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	140	0.00		0	0
threshold alerts latch	106	0.00		0	0
transaction allocation	6,015,555	0.00	0.19	2	0
transaction branch allocation	1,196	0.00		0	0
undo global data	299,131	0.00	0.00	0	0
user lock	6,498	0.94	0.98	8	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
library cache	7,138,409	407,678	334,255	84,985
library cache pin	4,796,928	48,040	31,615	16,661
shared pool	1,406,022	29,302	13,914	15,928
cache buffers chains	132,253,232	18,488	1,134	17,361
library cache lock	2,799,586	16,576	9,937	6,682
simulator lru latch	3,891,196	16,249	2,213	14,040
row cache objects	4,717,039	7,906	496	7,423
session idle bit	9,300,076	5,923	2,126	3,808
enqueues	204,028	1,072	780	296
session allocation	545,299	936	303	634
enqueue hash chains	294,620	178	114	64
kks stats	32,919	142	136	17
simulator hash latch	3,942,370	110	12	98
transaction allocation	6,015,555	95	18	78
cache buffers lru chain	68,427	72	33	39
user lock	6,498	61	60	2
object queue header operation	977,472	34	15	19
qmn task queue latch	128	32	32	0
mostly latch-free SCN	12,983	30	4	26
dml lock allocation	88,454	29	17	12
lgwr LWN SCN	12,972	22	1	21
redo allocation	42,665	21	12	9
session state list latch	12,062	15	8	8
sequence cache	62,320	13	9	5
library cache lock allocation	62,108	8	3	5
process allocation	3,252	4	3	1
SQL memory manager workarea list latch	142,944	3	3	0
library cache pin allocation	21,099	2	2	0
parameter table allocation management	1,689	2	1	1
archive process latch	333	1	1	0
post/wait queue	17,663	1	1	0
redo writing	40,235	1	1	0
resmgr:free threads list	3,281	1	1	0
slave class create	16	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
archive process latch	kcrrsarc	1	0
cache buffers chains	kcbgtcr: kslbegin excl	659	781
cache buffers chains	kcbgtcr: fast path	311	235
cache buffers chains	kcbrls: kslbegin	153	166
cache buffers chains	kcbzib: multi-block read: nowait	26	0
cache buffers chains	kcbchg: kslbegin: bufs not pinned	19	3
cache buffers chains	kcbgcur: kslbegin	13	8
cache buffers chains	kcbzgb: scan from tail. nowait	10	0
cache buffers chains	kcbzib: finish free bufs	6	1
cache buffers chains	kcbget: pin buffer	3	1
cache buffers chains	kcbgtcr: kslbegin shared	2	0
cache buffers chains	kcbnew: new latch again	2	0
cache buffers chains	kcbchg: kslbegin: call CR func	1	3
cache buffers chains	kcbzwb	1	2
cache buffers lru chain	kcbzgws	24	1
cache buffers lru chain	kcbzar: KSLNBEGIN	2	0
cache buffers lru chain	kcbzgb: posted for free bufs	2	28
cache buffers lru chain	kcbbwlru	1	1
cache buffers lru chain	kcbbxsv: move to being written	1	0
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	1	0
cache buffers lru chain	kcbzgm	1	0
cache buffers lru chain	kcbzswcu	1	0
cost function	kzulgt: find user res	48	52
cost function	kzulrl	12	8
dml lock allocation	ktaiam	15	12
dml lock allocation	ktaidm	2	5
enqueue hash chains	ksqgtl3	87	72
enqueue hash chains	ksqrcl	26	42
enqueue hash chains	ksqcmi: get hash chain latch after wait	1	0
enqueues	ksqgel: create enqueue	460	401
enqueues	ksqdel	253	286
enqueues	ksqies	67	93
event range base latch	No latch	32	32
kks stats	kks stats alloc/free	136	136
lgwr LWN SCN	kcs023	3	0
library cache	kglpndl: child: before processing	86,065	99,134
library cache	kglpin: child: heap processing	56,377	65,921
library cache	kglhdgc: child:	48,049	43,455
library cache	kglhdgn: child:	23,728	36,067
library cache	kglobpn: child:	19,261	28,254
library cache	kgldti: 2child	18,842	9,883
library cache	kglpnp: child	10,908	13,980
library cache	kglrtl	5,377	2,814
library cache	kglpndl: child: after processing	5,130	877
library cache	kglobld	5,001	6,504
library cache	kglpnc: child	2,768	3,624
library cache	kglpin	2,092	1,317
library cache	kglpur: child	2,015	4,500
library cache	kglukp: child	1,636	1,906
library cache	kgldte: child 0	1,403	2,097
library cache	kglic	882	426
library cache	kglati	139	16
library cache	kglprg: child	71	8
library cache	kglini: child	55	6
library cache	kgldtld: 2child	30	24
library cache	kglhdiv: child	2	0
library cache	kglpin: child: KGLMX	2	1
library cache	kglivl: child	1	0
library cache lock	kgllkdl: child: no lock handle	35,113	11,139
library cache lock	kgllkdl: child: cleanup	5,735	6,302
library cache lock	kgllkal: child: multiinstance	4,202	3,635
library cache lock allocation	kgllkget	3	2
library cache pin	kglpndl	13,994	7,788
library cache pin	kglpnal: child: alloc space	9,068	8,933
library cache pin	kglpnal: child: check granted	7,615	13,955
library cache pin	kglpnp: child	761	765
library cache pin	kglpnc: child	143	143
library cache pin	kgldnp: child	24	31
library cache pin	ksucallcbksafely: kqlphng	10	0
library cache pin allocation	kglpnget	2	1
mostly latch-free SCN	kcs024	1	0
mostly latch-free SCN	kcslcu3	1	5
object queue header operation	kcbw_unlink_q	6	2
object queue header operation	kcbw_link_q	5	0
object queue header operation	kcbo_swap_buf	2	0
object queue header operation	kcbo_switch_cq	2	13
parameter table allocation management	ksp_param_table_free	1	1
post/wait queue	ksliwat:add:nowait	1	0
process allocation	ksucrp	3	0
redo allocation	kcrfw_redo_gen: redo allocation 1	11	0
redo allocation	kcrfw_redo_write: before write	1	6
redo writing	kcrfsr: rba scn pair	1	0
resmgr:free threads list	kgskthrcreate	1	1
row cache objects	kqreqd: reget	226	4
row cache objects	kqrpre: find obj	159	462
row cache objects	kqreqd	63	24
row cache objects	kqrso	48	6
sequence cache	kdnnxt: cached seq	4	0
sequence cache	kdnssd	3	1
sequence cache	kdnss	2	8
session allocation	ksufap: active sessions	168	4
session allocation	ksudlc	47	98
session allocation	ksuprc	35	43
session allocation	ksucri	32	116
session allocation	ksuxds: KSUSFCLC not set	11	5
session allocation	ksuxds: not user session	6	27
session allocation	ksudlp	2	4
session allocation	ksucrp	1	5
session allocation	ksusroll	1	1
session idle bit	ksupuc: set busy	1,363	999
session idle bit	ksupuc: clear busy	815	1,156
session idle bit	ksuxds	7	31
session state list latch	kpseqd	5	0
session state list latch	kpscad	2	0
session state list latch	kpseqa	1	6
shared pool	kghalo	5,855	6,102
shared pool	kghfrunp: clatch: nowait	5,598	0
shared pool	kghfrunp: clatch: wait	3,647	2,301
shared pool	kghfrunp: alloc: cursor dur	2,640	434
shared pool	kghfre	2,001	1,477
shared pool	kghupr1	1,948	3,938
shared pool	kghalp	1,102	1,805
shared pool	kghfrunp: alloc: session dur	187	123
shared pool	kghfrh	133	10
shared pool	kghasp	39	11
shared pool	kghfree_extents: scan	8	12
shared pool	kghfen: not perm alloc class	2	3
simulator hash latch	kcbsacc: lookup dba	10	12
simulator hash latch	kcbs_lookup_setid: lookup dba	2	0
simulator lru latch	kcbs_simulate: simulate set	2,199	2,213
simulator lru latch	kcbs_lookup_setid	14	0
slave class create	ksvcreate	1	0
transaction allocation	ktcxbr	18	14

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: 72,275,129
Captured Segments account for 84.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
HMISW2003	KT_HMISW2003	ZYBRXX		TABLE	8,578,240	11.87
HMISW2003	KT_HMISW2003	HYBBFSJL_NEW		TABLE	7,561,072	10.46
HMISW2003	KT_MZFQINDEX	PK_MZGHXX		INDEX	5,623,744	7.78
HMISW2003	KT_MZFQXX	MZGHXX	ZGHXX20132	TABLE PARTITION	5,320,656	7.36
HMISW2003	KT_HMISW2003	EVTZYBR		TABLE	4,541,872	6.28

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 492,247
Captured Segments account for 49.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
HMISW2003	KT_HMISW2003	YJ_HIJK_RBDA		TABLE	181,085	36.79
HMISW2003	KT_HMISW2003	MZFPHMMX		TABLE	21,230	4.31
HMISW2003	KT_ZYFQXX	ZYYPYZXX_H	ZXX_H20132	TABLE PARTITION	18,716	3.80
HMISW2003	KT_HMISW2003	GHFPHMMX		TABLE	10,275	2.09
HMISW2003	KT_HMISW2003	ZYYJKHMMX		TABLE	2,946	0.60

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
HMISW2003	KT_HMISW2003	BHCKB	TABLE	14	20.59
HMISW2003	KT_HMISW2003	PJ_PJJG	TABLE	8	11.76
HMISW2003	KT_HYJCXX	IND_NEW_HYJGB_SQDBH	INDEX	6	8.82
HMISW2003	KT_ZYFQINDEX	IDX_ZYFY_RQ	INDEX	5	7.35
HMISW2003	KT_ZYFQINDEX	IDX_ZYYPYZXX_H_RQ	INDEX	4	5.88

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
HMISW2003	KT_HMISW2003	PDHJ_PHB		TABLE	3	27.27
HMISW2003	KT_MZFQXX	MZGHXX	ZGHXX20132	TABLE PARTITION	2	18.18
HMISW2003	KT_HMISW2003	ZYBRXX		TABLE	2	18.18
HMISW2003	KT_HMISW2003	PK_MZYSCFMXXX		INDEX	1	9.09
HMISW2003	KT_HMISW2003	PK_YZZXTMXX		INDEX	1	9.09

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	23	0.00	2	1
dc_global_oids	28	0.00	0	373
dc_histogram_data	476,663	0.00	0	19,837
dc_histogram_defs	115,050	0.05	0	28,178
dc_object_grants	52	0.00	0	5,973
dc_object_ids	157,874	0.00	0	4,482
dc_objects	29,289	0.03	1	4,985
dc_profiles	1,662	0.00	0	1
dc_rollback_segments	6,479	0.00	0	352
dc_segments	49,948	0.00	21	5,623
dc_sequences	1,606	0.00	1,606	34
dc_tablespace_quotas	2	0.00	2	12
dc_tablespaces	152,380	0.00	0	21
dc_usernames	87,456	0.00	0	68
dc_users	1,080,180	0.00	0	105
outstanding_alerts	48	8.33	8	40

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	2,126	0.00	187,154	0.00	5	0
CLUSTER	47	0.00	101	1.98	2	0
INDEX	3	0.00	27	0.00	0	0
PIPE	33,222	0.00	33,417	-0.00	0	0
SQL AREA	7,256	97.66	1,454,134	3.79	40,781	4
TABLE/PROCEDURE	9,547	0.24	374,390	0.13	404	0
TRIGGER	6,936	0.00	74,779	0.00	5	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	2,235.67		1.93	5.95	131	131	1,160	1,160
	Freeable	356.81	0.00	0.65	0.35	1		553	553
	SQL	181.58	95.98	0.16	0.52	18	99	1,144	1,141
	PL/SQL	85.87	31.92	0.07	0.02	0	2	1,158	1,158
E	Other	2,325.77		1.92	5.82	131	131	1,213	1,213
	Freeable	367.38	0.00	0.63	0.33	1		587	587
	SQL	174.66	84.35	0.15	0.05	1	99	1,197	1,192
	PL/SQL	89.34	33.39	0.07	0.02	0	2	1,211	1,211

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	9,378,463,744
Fixed Size	2,015,096
Redo Buffers	14,761,984
Variable Size	3,187,671,176

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	9.62	9.62	0.00
java	joxlod exec hp	6.14	6.14	0.00
java	joxs heap	0.24	0.24	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	CCursor	279.96	283.15	1.14
shared	PCursor	117.22	116.38	-0.71
shared	db_block_hash_buckets	67.25	67.25	0.00
shared	free memory	626.80	691.05	10.25
shared	kglsim heap	52.33	52.33	0.00
shared	kglsim object batch	51.74	51.74	0.00
shared	library cache	315.55	313.05	-0.79
shared	private strands	30.72	30.72	0.00
shared	sql area	936.24	870.30	-7.04
	buffer_cache	8,944.00	8,944.00	0.00
	fixed_sga	1.92	1.92	0.00
	log_buffer	14.08	14.08	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)
archive_lag_target	300
audit_file_dest	/u01/oracle/product/10.2.0/db_1/admin/feyy/adump
background_dump_dest	/u01/oracle/product/10.2.0/db_1/admin/feyy/bdump
compatible	10.2.0.1.0
control_files	/data/feyy/oradata/feyy/control01.ctl, /data/feyy/oradata/feyy/control02.ctl, /data/feyy/oradata/feyy/control03.ctl
core_dump_dest	/u01/oracle/product/10.2.0/db_1/admin/feyy/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_file_name_convert	/Tbackup/feyy/oradata, /data/feyy/oradata/feyy
db_name	feyy
db_recovery_file_dest	/u01/oracle/product/10.2.0/db_1/flash_recovery_area
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=feyyXDB)
event	10871 trace name context forever, level 1
fal_client	FEYY
fal_server	RZFEYY
job_queue_processes	10
log_archive_dest_1	location=/archive/feyy
log_archive_dest_2	service=rzfeyy lgwr async reopen=15 max_failure=10 optional noaffirm
log_archive_dest_state_2	ENABLE
log_archive_max_processes	8
log_archive_start	TRUE
log_file_name_convert	/Tbackup/feyy/oradata, /data/feyy/oradata/feyy
open_cursors	1000
optimizer_mode	ALL_ROWS
pga_aggregate_target	2097152000
processes	2000
remote_login_passwordfile	EXCLUSIVE
sga_max_size	12582912000
sga_target	12582912000
shared_pool_size	3154116608
standby_archive_dest	/archive/feyy
standby_file_management	AUTO
undo_management	AUTO
undo_retention	10800
undo_tablespace	UNDOTBS1
user_dump_dest	/u01/oracle/product/10.2.0/db_1/admin/feyy/udump

End of Report

% Blocks changed per Read:	0.52	Recursive Call %:	14.61
Rollback per transaction %:	9.72	Rows per Sort:	126.80

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.38	In-memory Sort %:	100.00
Library Hit %:	97.38	Soft Parse %:	95.11
Execute to Parse %:	7.51	Latch Hit %:	99.69
Parse CPU to Parse Elapsd %:	2.49	% Non-Parse CPU:	50.54