WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release Cluster Host

DB1 1167341725 DB1 1 10.1.0.4.0 NO s21a033

DB Name	DB Id	Instance	Inst num	Release	Cluster	Host
DB1	1167341725	DB1	1	10.1.0.4.0	NO	s21a033

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1063 20-Feb-06 08:30:56 82 30.8

End Snap: 1064 20-Feb-06 09:00:26 384 95.7

Elapsed: 29.49 (mins)

DB Time: 5,987.26 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1063	20-Feb-06 08:30:56	82	30.8
End Snap:	1064	20-Feb-06 09:00:26	384	95.7
Elapsed:		29.49 (mins)
DB Time:		5,987.26 (mins)

Report Summary

Cache Sizes (end)

Buffer Cache: 5,680M Std Block Size: 8K

Shared Pool Size: 1,264M Log Buffer: 10,240K

Load Profile

Per Second Per Transaction

Redo size: 19,394.25 23,344.36

Logical reads: 81,625.92 98,251.00

Block changes: 89.20 107.37

Physical reads: 465.74 560.60

Physical writes: 9.64 11.61

User calls: 251.94 303.26

Parses: 46.38 55.83

Hard parses: 1.14 1.37

Sorts: 22.52 27.11

Logons: 0.27 0.33

Executes: 280.41 337.53

Transactions: 0.83

	Per Second	Per Transaction
Redo size:	19,394.25	23,344.36
Logical reads:	81,625.92	98,251.00
Block changes:	89.20	107.37
Physical reads:	465.74	560.60
Physical writes:	9.64	11.61
User calls:	251.94	303.26
Parses:	46.38	55.83
Hard parses:	1.14	1.37
Sorts:	22.52	27.11
Logons:	0.27	0.33
Executes:	280.41	337.53
Transactions:	0.83

% Blocks changed per Read: 0.11 Recursive Call %: 70.45

Rollback per transaction %: 21.09 Rows per Sort: 160.99

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.66 Soft Parse %: 97.55

Execute to Parse %: 83.46 Latch Hit %: 98.47

Parse CPU to Parse Elapsd %: 0.12 % Non-Parse CPU: 98.99

Shared Pool Statistics

Begin End

Memory Usage %: 23.32 31.88

% SQL with executions>1: 87.74 86.79

% Memory for SQL w/exec>1: 82.12 84.06

	Begin	End
Memory Usage %:	23.32	31.88
% SQL with executions>1:	87.74	86.79
% Memory for SQL w/exec>1:	82.12	84.06

Top 5 Timed Events

Event Waits Time(s) Percent Total DB Time Wait Class

latch: shared pool 1,614,751 185,879 51.74 Configuration

latch: library cache 483,753 107,221 29.85 Concurrency

library cache pin 21,950 52,740 14.68 Concurrency

enq: CU - contention 2,195 5,499 1.53 Other

CPU time 5,233 1.46

Event	Waits	Time(s)	Percent Total DB Time	Wait Class
latch: shared pool	1,614,751	185,879	51.74	Configuration
latch: library cache	483,753	107,221	29.85	Concurrency
library cache pin	21,950	52,740	14.68	Concurrency
enq: CU - contention	2,195	5,499	1.53	Other
CPU time		5,233	1.46

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
SGA Statistics
Resource Limit Statistics
init.ora Parameters

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	Timeouts	Total Wait Time (s)	Avg wait (ms)	Waits /txn
latch: shared pool	1,614,751	0	185,879	115	1,098.47
latch: library cache	483,753	0	107,221	222	329.08
library cache pin	21,950	15,376	52,740	2,403	14.93
enq: CU - contention	2,195	1,607	5,499	2,505	1.49
db file scattered read	52,097	0	1,235	24	35.44
db file sequential read	136,937	0	1,029	8	93.15
latch: row cache objects	4,442	0	319	72	3.02
library cache load lock	77	63	202	2,623	0.05
kksfbc child completion	3,128	3,128	172	55	2.13
row cache lock	163	8	130	796	0.11
latch free	1,079	20	114	105	0.73
process startup	385	3	106	275	0.26
latch: cache buffers chains	13,175	13,145	76	6	8.96
wait for resize request completion	420	8	66	157	0.29
enq: US - contention	139	4	58	417	0.09
enq: SQ - contention	48	10	52	1,077	0.03
SQL*Net break/reset to client	3,362	1	47	14	2.29
read by other session	2,375	0	41	17	1.62
latch: enqueue hash chains	212	0	37	175	0.14
Queue Monitor Task Wait	7	5	34	4,886	0.00
buffer busy waits	403	5	19	47	0.27
latch: session allocation	147	0	11	74	0.10
wait list latch free	660	0	10	16	0.45
db file parallel write	11,527	0	6	0	7.84
SQL*Net more data to client	3,535	0	4	1	2.40
SQL*Net message to client	450,906	0	3	0	306.74
enq: HW - contention	1	0	2	1,586	0.00
log file parallel write	3,975	0	2	0	2.70
enq: JD - contention	1	0	1	1,227	0.00
enq: TX - row lock contention	2	0	1	547	0.00
db file parallel read	12	0	1	82	0.01
log file sync	901	0	1	1	0.61
latch: library cache pin	653	0	1	1	0.44
control file sequential read	435	0	1	2	0.30
control file parallel write	753	0	1	1	0.51
enq: TX - index contention	70	0	1	9	0.05
enq: PR - contention	1	0	0	356	0.00
control file single write	54	0	0	0	0.04
latch: library cache lock	26	0	0	1	0.02
latch: undo global data	10	0	0	1	0.01
latch: virtual circuit queues	9	0	0	0	0.01
SQL*Net more data from client	27	0	0	0	0.02
LGWR wait for redo copy	23	0	0	0	0.02
latch: cache buffers lru chain	9	0	0	0	0.01
latch: In memory undo latch	2	0	0	1	0.00
rdbms ipc reply	16	0	0	0	0.01
enq: FB - contention	1	0	0	0	0.00
direct path write	20	0	0	0	0.01
buffer deadlock	15	15	0	0	0.01
virtual circuit status	311,249	870	38,273	123	211.73
SQL*Net message from client	450,627	0	5,671	13	306.55
Queue Monitor Wait	58	58	1,700	29,306	0.04
queue messages	340	329	1,619	4,763	0.23
wait for unread message on broadcast channel	1,527	1,522	1,501	983	1.04
wakeup time manager	19	10	1,342	70,613	0.01
jobq slave wait	466	445	1,335	2,865	0.32
Queue Monitor Slave Wait	1	1	59	58,603	0.00
class slave wait	9	9	44	4,887	0.01

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	Timeouts	Total Wait Time (s)	Avg wait (ms)	Waits /txn
latch: library cache	1,019	0	266	261	0.69
latch: shared pool	1,036	0	114	110	0.70
Queue Monitor Task Wait	7	5	34	4,886	0.00
db file sequential read	582	0	6	11	0.40
db file parallel write	11,527	0	6	0	7.84
process startup	17	2	4	250	0.01
log file parallel write	3,975	0	2	0	2.70
latch: row cache objects	8	0	1	179	0.01
row cache lock	1	0	1	1,331	0.00
enq: JD - contention	1	0	1	1,227	0.00
latch: session allocation	1	0	1	643	0.00
db file scattered read	27	0	1	24	0.02
control file parallel write	754	0	1	1	0.51
control file sequential read	302	0	1	2	0.21
enq: PR - contention	1	0	0	356	0.00
latch free	3	0	0	60	0.00
log file sync	27	0	0	3	0.02
control file single write	54	0	0	0	0.04
latch: cache buffers chains	3	3	0	4	0.00
wait list latch free	1	0	0	11	0.00
LGWR wait for redo copy	23	0	0	0	0.02
latch: cache buffers lru chain	2	0	0	1	0.00
latch: library cache pin	2	0	0	1	0.00
rdbms ipc reply	16	0	0	0	0.01
enq: US - contention	1	0	0	1	0.00
latch: undo global data	1	0	0	0	0.00
direct path write	20	0	0	0	0.01
rdbms ipc message	7,951	5,583	15,351	1,931	5.41
Queue Monitor Wait	58	58	1,700	29,306	0.04
smon timer	10	2	1,440	144,027	0.01
wakeup time manager	1	1	67	67,384	0.00
class slave wait	1	1	5	4,888	0.00

Back to Wait Events Statistics
Back to Top

Time Model Statistics

ordered by Time (seconds) desc

Statistic Name	Time (seconds)	% Total DB Time
DB time	359,235.35	100.00
sql execute elapsed time	265,852.14	74.01
inbound PL/SQL rpc elapsed time	119,765.04	33.34
PL/SQL execution elapsed time	55,205.44	15.37
parse time elapsed	49,257.55	13.71
hard parse elapsed time	9,035.11	2.52
failed parse elapsed time	6,628.82	1.85
DB CPU	5,233.12	1.46
connection management call elapsed time	3,671.99	1.02
background elapsed time	611.98	0.17
PL/SQL compilation elapsed time	350.73	0.10
sequence load elapsed time	92.15	0.03
background cpu time	18.26	0.01
hard parse (sharing criteria) elapsed time	10.92	0.00
hard parse (bind mismatch) elapsed time	6.82	0.00
failed parse (out of shared memory) elapsed t	0.00	0.00
Java execution elapsed time	0.00	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Name	Value
AVG_BUSY_TICKS	4,426
AVG_FS_IN_BYTES	6,144
AVG_FS_OUT_BYTES	0
AVG_IDLE_TICKS	6,697
AVG_IN_BYTES	6,144
AVG_IOWAIT_TICKS	949
AVG_OUT_BYTES	0
AVG_SYS_TICKS	153
AVG_USER_TICKS	4,248
BUSY_TICKS	70,422
FS_IN_BYTES	49,152
FS_OUT_BYTES	0
IDLE_TICKS	109,009
IN_BYTES	57,344
IOWAIT_TICKS	15,298
OS_CPU_WAIT_TIME	30,700
OUT_BYTES	0
RSRC_MGR_CPU_WAIT_TIME	0
SYS_TICKS	2,778
USER_TICKS	67,644

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	353,617.50	5,137.60	819,537	143,804,141
DB1	3,944.50	67.90	1,341	33,282
SYS$BACKGROUND	0.00	0.00	2,419	24,643

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	189,217	228,815	510,783	15,780,824	448,037	354
DB1	745	838	0	0	5,228	367
SYS$BACKGROUND	1,366	906	1,119	30,276	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Text
43,265	1,002	123,522	0.35	12.04	4ubf0xz92w3kt	SELECT * FROM MNAPAT WHERE P...
16,233	160	3,988	4.07	4.52	f4xf8228tsuzv	INSERT INTO NAPLO(AZON, SZMAZ...
11,134	96	2,379	4.68	3.10	5a6zvw6bgk28y	INSERT INTO TTERIT ( TTERAZON,...
9,547	42	45,124	0.21	2.66	01wdkj7jhwf8a	SELECT * FROM MNAPAT WHERE M...
7,050	83	2,442	2.89	1.96	9mfw46w0bzx09	INSERT INTO NAPLO(AZON, SZMAZ...
7,000	56	944	7.41	1.95	4tuv9t25jutcm	INSERT INTO TAVOL TAVO(KOD, KE...
6,377	50	1,018	6.26	1.78	60bt08y455bs8	UPDATE TAVOL TAVO SET TAVO.KOD...
5,868	48	1,000	5.87	1.63	62bc3djway77z	UPDATE TAVOL SET TBELLATAS=TBE...
5,694	61	893	6.38	1.59	441129zwf3wvr	UPDATE EVESTENY SET NNAP08=NVL...
5,487	44	958	5.73	1.53	fhpcj88szp7r9	UPDATE TAVOL SET ROGZITES=:b1 ...
5,002	43	869	5.76	1.39	cg2k37y9rbrpq	INSERT INTO TBTETEL ( TBTETAZO...
4,998	51	1,343	3.72	1.39	4czuhzpsqzjwr	INSERT INTO NAPLO(AZON, SZMAZ...
4,956	51	564	8.79	1.38	2vuqztfak9qvz	UPDATE ATLAGOK SET OSZTO08=NVL...
4,017	159	4,764	0.84	1.12	4b26spmmjd279	SELECT KF.ALLASJEL, KT.KIADASN...
3,927	40	406	9.67	1.09	7jnz6jg4nn3tq	UPDATE TB SET TIBSZ=NVL(TIBSZ,...
3,660	14	9,705	0.38	1.02	7sa4v2c8a5jtv	SELECT NAPLO_SEQ.NEXTVAL FROM ...

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 Text
1,002	43,265	123,522	0.01	12.04	4ubf0xz92w3kt	SELECT * FROM MNAPAT WHERE P...
802	1,009	11	72.88	0.28	5fx1bgfqq95pg	SELECT VRG.RESZ_NEV, VRG.RESZ_...
230	2,146	206	1.12	0.60	1rtq4uuu1hnzt	SELECT VRG.RESZ_NEV, VRG...
210	290	2	104.78	0.08	cw2y0qwa9sfgp	SELECT VRG.RESZ_NEV, VRG...
169	280	6	28.15	0.08	f5d5rmc57ttcj	SELECT VRG.RESZ_NEV, VRG...
160	16,233	3,988	0.04	4.52	f4xf8228tsuzv	INSERT INTO NAPLO(AZON, SZMAZ...
159	4,017	4,764	0.03	1.12	4b26spmmjd279	SELECT KF.ALLASJEL, KT.KIADASN...
116	1,589	528	0.22	0.44	axm5005kdufpd	select ROLE GRPNAME , FLAG GRP...
105	2,262	4,322	0.02	0.63	3v9v8ujzm4whb	SELECT * FROM TBTETEL WHERE...
96	11,134	2,379	0.04	3.10	5a6zvw6bgk28y	INSERT INTO TTERIT ( TTERAZON,...
83	7,050	2,442	0.03	1.96	9mfw46w0bzx09	INSERT INTO NAPLO(AZON, SZMAZ...
61	5,694	893	0.07	1.59	441129zwf3wvr	UPDATE EVESTENY SET NNAP08=NVL...
56	7,000	944	0.06	1.95	4tuv9t25jutcm	INSERT INTO TAVOL TAVO(KOD, KE...
51	4,956	564	0.09	1.38	2vuqztfak9qvz	UPDATE ATLAGOK SET OSZTO08=NVL...
51	4,998	1,343	0.04	1.39	4czuhzpsqzjwr	INSERT INTO NAPLO(AZON, SZMAZ...
50	6,377	1,018	0.05	1.78	60bt08y455bs8	UPDATE TAVOL TAVO SET TAVO.KOD...
48	5,868	1,000	0.05	1.63	62bc3djway77z	UPDATE TAVOL SET TBELLATAS=TBE...
44	5,487	958	0.05	1.53	fhpcj88szp7r9	UPDATE TAVOL SET ROGZITES=:b1 ...
43	5,002	869	0.05	1.39	cg2k37y9rbrpq	INSERT INTO TBTETEL ( TBTETAZO...
42	9,547	45,124	0.00	2.66	01wdkj7jhwf8a	SELECT * FROM MNAPAT WHERE M...
40	3,927	406	0.10	1.09	7jnz6jg4nn3tq	UPDATE TB SET TIBSZ=NVL(TIBSZ,...
14	3,660	9,705	0.00	1.02	7sa4v2c8a5jtv	SELECT NAPLO_SEQ.NEXTVAL FROM ...

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: 144,428,977
Captured SQL accounts for 102.0% of Total Buffer Gets

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
97,414,181	11	8,855,834.64	67.45	801.72	1,009.36	5fx1bgfqq95pg	SELECT VRG.RESZ_NEV, VRG.RESZ_...
21,659,269	2	10,829,634.50	15.00	209.57	290.02	cw2y0qwa9sfgp	SELECT VRG.RESZ_NEV, VRG...
12,078,259	6	2,013,043.17	8.36	168.88	280.46	f5d5rmc57ttcj	SELECT VRG.RESZ_NEV, VRG...
6,670,222	206	32,379.72	4.62	230.23	2,146.21	1rtq4uuu1hnzt	SELECT VRG.RESZ_NEV, VRG...
3,452,302	70	49,318.60	2.39	71.21	312.68	28ykwc28c0vay	SELECT VRG.RESZ_NEV, VRG...
2,591,849	123,522	20.98	1.79	1,001.97	43,265.21	4ubf0xz92w3kt	SELECT * FROM MNAPAT WHERE P...
677,904	169,731	3.99	0.47	37.18	1,700.07	aq0cxnrqcrwym	SELECT * FROM MUNKAREND WHER...
592,886	2,175	272.59	0.41	51.01	1,683.79	c8gd0a0gx2szj	SELECT SUM(NVL(A.TERITMENY, 0)...
390,689	2,166	180.37	0.27	54.39	1,615.45	4ftasyybktj9j	SELECT TAVKEZD FROM TKODOK T...
275,427	1,085	253.85	0.19	72.79	1,777.89	d67xbu2yw4jcf	SELECT A.KEZD, A.VEGE, NVL(A.E...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 824,079
Captured SQL accounts for 79.3% of Total Disk Reads

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
193,194	1,085	178.06	23.44	72.79	1,777.89	d67xbu2yw4jcf	SELECT A.KEZD, A.VEGE, NVL(A.E...
128,632	2,175	59.14	15.61	51.01	1,683.79	c8gd0a0gx2szj	SELECT SUM(NVL(A.TERITMENY, 0)...
90,540	206	439.51	10.99	230.23	2,146.21	1rtq4uuu1hnzt	SELECT VRG.RESZ_NEV, VRG...
76,242	2,166	35.20	9.25	54.39	1,615.45	4ftasyybktj9j	SELECT TAVKEZD FROM TKODOK T...
60,385	70	862.64	7.33	71.21	312.68	28ykwc28c0vay	SELECT VRG.RESZ_NEV, VRG...
19,054	3,466	5.50	2.31	51.24	1,734.56	8v0s8g8hbd8tz	SELECT NVL(KULCSSZAM, 'XX'), S...
15,475	11	1,406.82	1.88	801.72	1,009.36	5fx1bgfqq95pg	SELECT VRG.RESZ_NEV, VRG.RESZ_...
8,419	6	1,403.17	1.02	168.88	280.46	f5d5rmc57ttcj	SELECT VRG.RESZ_NEV, VRG...
8,183	3,547	2.31	0.99	20.58	1,475.17	f59xssgpjr9jp	SELECT * FROM TB WHERE DJOG...
6,497	2	3,248.50	0.79	209.57	290.02	cw2y0qwa9sfgp	SELECT VRG.RESZ_NEV, VRG...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 496,165
Captured SQL accounts for 87.8% of Total Executions

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Text
169,731	169,489	1.00	0.00	0.01	aq0cxnrqcrwym	SELECT * FROM MUNKAREND WHER...
123,522	82	0.00	0.01	0.35	4ubf0xz92w3kt	SELECT * FROM MNAPAT WHERE P...
45,124	84	0.00	0.00	0.21	01wdkj7jhwf8a	SELECT * FROM MNAPAT WHERE M...
9,705	9,706	1.00	0.00	0.38	7sa4v2c8a5jtv	SELECT NAPLO_SEQ.NEXTVAL FROM ...
7,469	7,469	1.00	0.00	0.23	14msddhc9d4rm	SELECT * FROM TKODOK WHERE ...
4,764	4,764	1.00	0.03	0.84	4b26spmmjd279	SELECT KF.ALLASJEL, KT.KIADASN...
4,375	4,375	1.00	0.01	0.26	6jkcmz3n85trq	SELECT MAX(TAVVEGE) FROM TTE...
4,322	5,376	1.24	0.02	0.52	3v9v8ujzm4whb	SELECT * FROM TBTETEL WHERE...
3,988	3,987	1.00	0.04	4.07	f4xf8228tsuzv	INSERT INTO NAPLO(AZON, SZMAZ...
3,547	3,547	1.00	0.01	0.42	f59xssgpjr9jp	SELECT * FROM TB WHERE DJOG...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 82,067
Captured SQL accounts for 57.6% of Total Parse Calls

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
3,466	3,466	4.22	8v0s8g8hbd8tz	SELECT NVL(KULCSSZAM, 'XX'), S...
3,270	9,705	3.98	7sa4v2c8a5jtv	SELECT NAPLO_SEQ.NEXTVAL FROM ...
3,089	3,094	3.76	dnq8hyrpwb01p	SELECT USER, TO_CHAR(SYSDATE, ...
2,658	3,286	3.24	gf3475wtsu9j0	SELECT JOGTIPKOD, KEZD, VEGE ...
2,303	2,303	2.81	grwydz59pu6mc	select text from view$ where r...
2,269	2,269	2.76	9m22qp63dh8tp	ALTER SESSION SET REMOTE_DEPEN...
2,266	2,266	2.76	7cff8vv7fat8n	SELECT M.MUNKAREND FROM MUNK...
2,244	2,244	2.73	5mcq2uj822xy3	ALTER SESSION SET NLS_DATE_FOR...
1,474	3,988	1.80	f4xf8228tsuzv	INSERT INTO NAPLO(AZON, SZMAZ...
1,425	1,425	1.74	0h6b2sajwb74n	select privilege#, level from ...
1,173	1,173	1.43	47r1y8yn34jmj	select default$ from col$ wher...
1,115	1,115	1.36	bf7vh5bcn4211	SELECT substr(RV_LOW_VALUE, 1,...
1,096	1,096	1.34	2yf5uv17yv94k	SELECT substr(RV_LOW_VALUE, 1,...
1,059	1,059	1.29	942848zttvrxk	SELECT UGYI_KOD FROM HELYETT...
1,014	1,014	1.24	ftj9uawt4wwzb	select condition from cdef$ wh...
856	428	1.04	8r1w3j35mbq7k	SELECT RV_MEANING, RV_LOW_VAL...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

01wdkj7jhwf8a SELECT * FROM MNAPAT WHERE MUNKANAP = :1

0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

14msddhc9d4rm SELECT * FROM TKODOK WHERE JOGCIM = :b1 AND ROWNUM < 2

1rtq4uuu1hnzt SELECT VRG.RESZ_NEV, VRG.RESZ_ELONEV, VRG.RESZ_SZULDATUM, VRG.RESZ_ADOSZAM, VRG.RESZ_TAJSZAM, VRG.RESZ_UTLEVEL, VRG.DJOG_FOGSOR, VRG.VBERK_SZEE_UGYI_KOD, VRG.VBERK_BERG_TORZSSZAM, VRG.RESZ_SZMAZONIH, VRG.DJOG_BERK_BERKIFAZON, VRG.DJOG_FOGAZONIH, VRG.VBERK_SZEE_AZONOSITO, VRG.djog_megszunes FROM V_RESZDJOG VRG WHERE ( ( VRG.RESZ_SZMAZONIH IN (select resz_szmazonih from eloado where eloado=/*:global.eloado*/:1) or (vrg.vberk_szee_ugyi_kod in (select ugyi_kod from helyettes where ugyi_kod_hel yettes=:2))) or :3='1' ) and ( UPPER(VRG.RESZ_NEV) LIKE :4 and (VRG.RESZ_NEV LIKE :5 or VRG.RESZ_NEV LIKE :6 or VRG.RESZ_NEV LIKE :7 or VRG.RESZ_NEV LIKE :8)) order by RESZ_NEV, DJOG_FOGAZONIH-9

28ykwc28c0vay SELECT VRG.RESZ_NEV, VRG.RESZ_ELONEV, VRG.RESZ_SZULDATUM, VRG.RESZ_ADOSZAM, VRG.RESZ_TAJSZAM, VRG.RESZ_UTLEVEL, VRG.DJOG_FOGSOR, VRG.VBERK_SZEE_UGYI_KOD, VRG.VBERK_BERG_TORZSSZAM, VRG.RESZ_SZMAZONIH, VRG.DJOG_BERK_BERKIFAZON, VRG.DJOG_FOGAZONIH, VRG.VBERK_SZEE_AZONOSITO, VRG.djog_megszunes FROM V_RESZDJOG VRG WHERE ( ( VRG.RESZ_SZMAZONIH IN (select resz_szmazonih from eloado where eloado=/*:global.eloado*/:1) or (vrg.vberk_szee_ugyi_kod in (select ugyi_kod from helyettes where ugyi_kod_hel yettes=:2))) or :3='1' ) and (VRG.RESZ_SZULDATUM=:4) order by RESZ_NEV, DJOG_FOGAZONIH-9

2vuqztfak9qvz UPDATE ATLAGOK SET OSZTO08=NVL(OSZTO08, 0) + :b1 , FT13OSZ08=NVL(FT13OSZ08, 0) + :b2 WHERE DJOG_FOGAZONIH = :b3 AND EVSZAM = :b4

2yf5uv17yv94k SELECT substr(RV_LOW_VALUE, 1, 1) RV_LOW_VALUE , substr(RV_MEANING, 1, 5) RV_MEANING FROM CG_REF_CODES WHERE RV_DOMAIN = '01' ORDER BY RV_LOW_VALUE

3v9v8ujzm4whb SELECT * FROM TBTETEL WHERE TAVO_TAVAZONIH = :b1 AND STATUSZ = '0' ORDER BY TAVKEZD, TAVVEGE, TJOGCIM

441129zwf3wvr UPDATE EVESTENY SET NNAP08=NVL(NNAP08, 0) - :b1 WHERE DJOG_FOGAZONIH = :b2 AND EVSZAM = :b3

47r1y8yn34jmj select default$ from col$ where rowid=:1

4b26spmmjd279 SELECT KF.ALLASJEL, KT.KIADASNEM, KT.FOGJELLEG FROM KIADTORT KT, KIADFOG KF WHERE KT.DJOG_FOGAZONIH = :b1 AND KT.KEZD <= NVL(:b2, :b3) AND NVL(KT.VEGE, TO_DATE('39991231', 'yyyymmdd')) >= NVL(:b2, :b3) AND KF.KIADASNEM = KT.KIADASNEM AND KF.FOGJELLEG = KT.FOGJELLEG AND KF.DATUMTOL <= GREATEST(KT.KEZD, TO_DATE('20010101', 'yyyymmdd')) AND KF.DATUMIG >= GREATEST(KT.KEZD, TO_DATE('20010101', 'yyyymmdd'))

4czuhzpsqzjwr INSERT INTO NAPLO(AZON, SZMAZONIH, FOGAZONIH, PROGRAM, VERZIO, ELOADO, AKTELOADO, TABLA, AKCIO, ROGZITES, SZIDOSZAK, KIDOSZAK, GEPNEV, USERNEV, ADAT) VALUES(:B1 , NAPLOZ.ELKODOL(TO_CHAR(:B13 ), :B1 ), NAPLOZ.ELKODOL(TO_CHAR(:B12 ), :B1 ), NAPLOZ.ELKODOL(:B11 , :B1 ), NAPLOZ.ELKODOL(:B10 , :B1 ), NAPLOZ.ELKODOL(:B9 , :B1 ), NAPLOZ.ELKODOL(:B8 , :B1 ), NAPLOZ.ELKODOL('EVESTENY', :B1 ), NAPLOZ.ELKODOL(:B7 , :B1 ), NAPLOZ.ELKODOL(TO_CHAR(SYSDATE, 'yyyy.mm.dd./hh24:mi:ss'), :B1 ), NAPLOZ.ELKODOL(:B6 , :B1 ), NAPLOZ.ELKODOL(:B5 , :B1 ), NAPLOZ.ELKODOL(:B4 , :B1 ), NAPLOZ.ELKODOL(:B3 , :B1 ), NAPLOZ.ELKODOL(:B2 , :B1 ))

4ftasyybktj9j SELECT TAVKEZD FROM TKODOK TK, TBTETEL TBT, TAVOL T WHERE TK.FOLY2JEL NOT IN ( '2', '6' ) AND TK.JELZO = '3' AND TK.TIPUS = :b1 AND TK.JOGCIM = TBT.TJOGCIM AND TBT.TJOGCIM != '15010' AND TBT.TAVVEGE = :b2 - 1 AND TBT.STATUSZ = '0' AND TBT.TAVO_TAVAZONIH = T.TAVAZONIH AND T.SZTORNO = 'N' AND T.DJOG_FOGAZONIH = :b3

4tuv9t25jutcm INSERT INTO TAVOL TAVO(KOD, KEZD, KEZDODO, GYOGYULT, VEGE, JOGOSULT, JVEGE, TAVORA, TPLEJAR, TBELLATAS, TERITMENY, TAVOLDIJ, TPKIEG, SZTORNO, MELLEKLET, MUSZAKREND, GENERALT, UEVHO, RESZ_SZMAZONIH, TAVAZONIH, DJOG_FOGAZONIH, EJUT_SORSZAM, ALAP, OSZTO, NRALAP, NROSZTO, MODMAX) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27)

4ubf0xz92w3kt SELECT * FROM MNAPAT WHERE PIHENONAP = :1

5a6zvw6bgk28y INSERT INTO TTERIT ( TTERAZON, TAVO_TAVAZONIH, SORSZAM, TJOGCIM, IDEGEN, VISSZAVET, TAVKEZD, TAVVEGE, MUNKANAP, NAPTARINAP, JOGCIM, ALAPJA, TERITMENY, STATUSZ, UEVHO, BERKIFAZON, ROGZITES ) VALUES ( :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17 )

5fx1bgfqq95pg SELECT VRG.RESZ_NEV, VRG.RESZ_ELONEV, VRG.RESZ_SZULDATUM, VRG.RESZ_ADOSZAM, VRG.RESZ_TAJSZAM, VRG.RESZ_UTLEVEL, VRG.DJOG_FOGSOR, VRG.VBERK_SZEE_UGYI_KOD, VRG.VBERK_BERG_TORZSSZAM, VRG.RESZ_SZMAZONIH, VRG.DJOG_BERK_BERKIFAZON, VRG.DJOG_FOGAZONIH, VRG.VBERK_SZEE_AZONOSITO, VRG.djog_megszunes FROM V_RESZDJOG VRG WHERE ( ( VRG.RESZ_SZMAZONIH IN (select resz_szmazonih from eloado where eloado=/*:global.eloado*/:1) or (vrg.vberk_szee_ugyi_kod in (select ugyi_kod from helyettes where ugyi_kod_helyettes =:2))) or :3='1' ) order by RESZ_NEV, DJOG_FOGAZONIH-9

5mcq2uj822xy3 ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY/MM/DD HH24:MI:SS'

60bt08y455bs8 UPDATE TAVOL TAVO SET TAVO.KOD=:1, TAVO.KEZD=:2, TAVO.KEZDODO=:3, TAVO.GYOGYULT=:4, TAVO.VEGE=:5, TAVO.JOGOSULT=:6, TAVO.JVEGE=:7, TAVO.TAVORA=:8, TAVO.TPLEJAR=:9, TAVO.TBELLATAS=:10, TAVO.TERITMENY=:11, TAVO.TAVOLDIJ=:12, TAVO.TPKIEG=:13, TAVO.SZTORNO=:14, TAVO.MELLEKLET=:15, TAVO.MUSZAKREND=:16, TAVO.GENERALT=:17, TAVO.UEVHO=:18, TAVO.RESZ_SZMAZONIH=:19, TAVO.TAVAZONIH=:20, TAVO.DJOG_FOGAZONIH=:21, TAVO.EJUT_SORSZAM=:22, TAVO.ALAP=:23, TAVO.OSZTO=:24, TAVO.NRALAP=:25, TAVO.NROSZTO=:26, TAVO.MO DMAX=:27 WHERE ROWID=:28

62bc3djway77z UPDATE TAVOL SET TBELLATAS=TBELLATAS + :b1 , TAVOLDIJ=TAVOLDIJ + :b2 , TPKIEG=TPKIEG + :b3 , TERITMENY=TERITMENY + :b4 WHERE TAVAZONIH = :b5

6jkcmz3n85trq SELECT MAX(TAVVEGE) FROM TTERIT WHERE TAVO_TAVAZONIH = :b1 AND STATUSZ = '0'

7cff8vv7fat8n SELECT M.MUNKAREND FROM MUNKAUGYEK M WHERE FOGAZONIH = :b1

7jnz6jg4nn3tq UPDATE TB SET TIBSZ=NVL(TIBSZ, 0) + :b1 WHERE DJOG_FOGAZONIH = :b2 AND EVSZAM = :b3

7sa4v2c8a5jtv SELECT NAPLO_SEQ.NEXTVAL FROM SYS.DUAL

8r1w3j35mbq7k SELECT RV_MEANING, RV_LOW_VALUE FROM CG_REF_CODES WHERE RV_DOMAIN = '74' ORDER BY 1

8v0s8g8hbd8tz SELECT NVL(KULCSSZAM, 'XX'), SUBSTR(NVL(KULCSSZAM, 'XX'), 1, 1), SUBSTR(NVL(KULCSSZAM, 'XX'), 1, 2) FROM SOROLFEJ S0 WHERE S0.DJOG_FOGAZONIH = :b1 AND S0.FJELZO = '00' AND S0.SORSZAM = (SELECT MAX(SORSZAM) FROM SOROLFEJ S1 WHERE S1.DJOG_FOGAZONIH = :b1 AND S1.KEZD <= :b3 )

942848zttvrxk SELECT UGYI_KOD FROM HELYETTES WHERE UGYI_KOD_HELYETTES = :b1 AND UGYI_KOD = :b2

9m22qp63dh8tp ALTER SESSION SET REMOTE_DEPENDENCIES_MODE=SIGNATURE

9mfw46w0bzx09 INSERT INTO NAPLO(AZON, SZMAZONIH, FOGAZONIH, PROGRAM, VERZIO, ELOADO, AKTELOADO, TABLA, AKCIO, ROGZITES, SZIDOSZAK, KIDOSZAK, GEPNEV, USERNEV, ADAT) VALUES(:B1 , NAPLOZ.ELKODOL(TO_CHAR(:B13 ), :B1 ), NAPLOZ.ELKODOL(TO_CHAR(:B12 ), :B1 ), NAPLOZ.ELKODOL(:B11 , :B1 ), NAPLOZ.ELKODOL(:B10 , :B1 ), NAPLOZ.ELKODOL(:B9 , :B1 ), NAPLOZ.ELKODOL(:B8 , :B1 ), NAPLOZ.ELKODOL('TTERIT', :B1 ), NAPLOZ.ELKODOL(:B7 , :B1 ), NAPLOZ.ELKODOL(TO_CHAR(SYSDATE, 'yyyy.mm.dd./hh24:mi:ss'), :B1 ) , NAPLOZ.ELKODOL(:B6 , :B1 ), NAPLOZ.ELKODOL(:B5 , :B1 ), NAPLOZ.ELKODOL(:B4 , :B1 ), NAPLOZ.ELKODOL(:B3 , :B1 ), NAPLOZ.ELKODOL(:B2 , :B1 ))

aq0cxnrqcrwym SELECT * FROM MUNKAREND WHERE KEZD <= :1 AND VEGE >= :1 AND DJOG_FOGAZONIH = :1 ORDER BY KEZD

axm5005kdufpd select ROLE GRPNAME , FLAG GRPFLG from FRM50_ENABLED_ROLES order by ROLE desc

bf7vh5bcn4211 SELECT substr(RV_LOW_VALUE, 1, 1) RV_LOW_VALUE , substr(RV_MEANING, 1, 57) RV_MEANING FROM CG_REF_CODES WHERE RV_DOMAIN = '102' ORDER BY RV_LOW_VALUE

c8gd0a0gx2szj SELECT SUM(NVL(A.TERITMENY, 0)), SUM(NVL(A.MUNKANAP, 0)) FROM TAVOL B, TTERIT A WHERE DJOG_FOGAZONIH = :b1 AND TAVO_TAVAZONIH = TAVAZONIH AND A.TJOGCIM = :b2 AND A.TAVKEZD >= :b3 AND A.TAVVEGE <= :b4 AND A.ALAPJA = :b5 AND A.STATUSZ = '0'

cg2k37y9rbrpq INSERT INTO TBTETEL ( TBTETAZON, TAVO_TAVAZONIH, SORSZAM, TJOGCIM, VISSZAVET, TAVKEZD, TAVVEGE, MUNKANAP, NAPTARINAP, FOLY1, FOLY2, SZAZALEK, EGYNAPI, TBELLATAS, GYOGYULT, STATUSZ, UEVHO, KEZDOJELZO, KOD, DJOG_FOGAZONIH, RESZ_SZMAZONIH_RESZ, RESZ_SZMAZONIH_JOGOS, BSZJOGNAP, ROGZITES ) VALUES ( :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24 )

cw2y0qwa9sfgp SELECT VRG.RESZ_NEV, VRG.RESZ_ELONEV, VRG.RESZ_SZULDATUM, VRG.RESZ_ADOSZAM, VRG.RESZ_TAJSZAM, VRG.RESZ_UTLEVEL, VRG.DJOG_FOGSOR, VRG.VBERK_SZEE_UGYI_KOD, VRG.VBERK_BERG_TORZSSZAM, VRG.RESZ_SZMAZONIH, VRG.DJOG_BERK_BERKIFAZON, VRG.DJOG_FOGAZONIH, VRG.VBERK_SZEE_AZONOSITO, VRG.djog_megszunes FROM V_RESZDJOG VRG WHERE ( ( VRG.RESZ_SZMAZONIH IN (select resz_szmazonih from eloado where eloado=/*:global.eloado*/:1) or (vrg.vberk_szee_ugyi_kod in (select ugyi_kod from helyettes where ugyi_kod_hel yettes=:2))) or :3='1' ) order by RESZ_NEV, DJOG_FOGAZONIH-9

d67xbu2yw4jcf SELECT A.KEZD, A.VEGE, NVL(A.EERTEKE, 0) EERTEK, B.BBETALAP BETALAP, B.BTERIT TERITM, B.BTAVALAP TAVALAP FROM BEREK A, BERJOGC B WHERE DJOG_FOGAZONIH = :b1 AND KEZD <= :b2 AND VEGE >= :b3 AND A.JOGCIM = B.JOGCIM AND DATUMTOL <= :b3 AND DATUMIG >= :b3 AND ((B.BBETALAP = 'I' AND B.BTERIT = 'N' ) OR B.BTAVALAP = 'I' )ORDER BY FJELZO, A.JOGCIM, IDEGEN, KEZD, VEGE

dnq8hyrpwb01p SELECT USER, TO_CHAR(SYSDATE, 'yyyy.mm.dd') FROM DUAL

f4xf8228tsuzv INSERT INTO NAPLO(AZON, SZMAZONIH, FOGAZONIH, PROGRAM, VERZIO, ELOADO, AKTELOADO, TABLA, AKCIO, ROGZITES, SZIDOSZAK, KIDOSZAK, GEPNEV, USERNEV, ADAT) VALUES(:B1 , NAPLOZ.ELKODOL(TO_CHAR(:B13 ), :B1 ), NAPLOZ.ELKODOL(TO_CHAR(:B12 ), :B1 ), NAPLOZ.ELKODOL(:B11 , :B1 ), NAPLOZ.ELKODOL(:B10 , :B1 ), NAPLOZ.ELKODOL(:B9 , :B1 ), NAPLOZ.ELKODOL(:B8 , :B1 ), NAPLOZ.ELKODOL('TAVOL', :B1 ), NAPLOZ.ELKODOL(:B7 , :B1 ), NAPLOZ.ELKODOL(TO_CHAR(SYSDATE, 'yyyy.mm.dd./hh24:mi:ss'), :B1 ), NAPLOZ.ELKODOL(:B6 , :B1 ), NAPLOZ.ELKODOL(:B5 , :B1 ), NAPLOZ.ELKODOL(:B4 , :B1 ), NAPLOZ.ELKODOL(:B3 , :B1 ), NAPLOZ.ELKODOL(:B2 , :B1 ))

f59xssgpjr9jp SELECT * FROM TB WHERE DJOG_FOGAZONIH = :b1 AND EVSZAM = :b2 AND ROWNUM < 2

f5d5rmc57ttcj SELECT VRG.RESZ_NEV, VRG.RESZ_ELONEV, VRG.RESZ_SZULDATUM, VRG.RESZ_ADOSZAM, VRG.RESZ_TAJSZAM, VRG.RESZ_UTLEVEL, VRG.DJOG_FOGSOR, VRG.VBERK_SZEE_UGYI_KOD, VRG.VBERK_BERG_TORZSSZAM, VRG.RESZ_SZMAZONIH, VRG.DJOG_BERK_BERKIFAZON, VRG.DJOG_FOGAZONIH, VRG.VBERK_SZEE_AZONOSITO, VRG.djog_megszunes FROM V_RESZDJOG VRG WHERE ( ( VRG.RESZ_SZMAZONIH IN (select resz_szmazonih from eloado where eloado=/*:global.eloado*/:1) or (vrg.vberk_szee_ugyi_kod in (select ugyi_kod from helyettes where ugyi_kod_hel yettes=:2))) or :3='1' ) and ( UPPER(VRG.RESZ_NEV) LIKE :4 and (VRG.RESZ_NEV LIKE :5 or VRG.RESZ_NEV LIKE :6)) order by RESZ_NEV, DJOG_FOGAZONIH-9

fhpcj88szp7r9 UPDATE TAVOL SET ROGZITES=:b1 WHERE TAVAZONIH = :b2

ftj9uawt4wwzb select condition from cdef$ where rowid=:1

gf3475wtsu9j0 SELECT JOGTIPKOD, KEZD, VEGE FROM JOGTORT WHERE DJOG_FOGAZONIH = :b1 AND KEZD <= :b2 AND (VEGE IS NULL OR VEGE >= :b2 )

grwydz59pu6mc select text from view$ where rowid=:1

SQL Id	SQL Text
01wdkj7jhwf8a	SELECT * FROM MNAPAT WHERE MUNKANAP = :1
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
14msddhc9d4rm	SELECT * FROM TKODOK WHERE JOGCIM = :b1 AND ROWNUM < 2
1rtq4uuu1hnzt	SELECT VRG.RESZ_NEV, VRG.RESZ_ELONEV, VRG.RESZ_SZULDATUM, VRG.RESZ_ADOSZAM, VRG.RESZ_TAJSZAM, VRG.RESZ_UTLEVEL, VRG.DJOG_FOGSOR, VRG.VBERK_SZEE_UGYI_KOD, VRG.VBERK_BERG_TORZSSZAM, VRG.RESZ_SZMAZONIH, VRG.DJOG_BERK_BERKIFAZON, VRG.DJOG_FOGAZONIH, VRG.VBERK_SZEE_AZONOSITO, VRG.djog_megszunes FROM V_RESZDJOG VRG WHERE ( ( VRG.RESZ_SZMAZONIH IN (select resz_szmazonih from eloado where eloado=/:global.eloado/:1) or (vrg.vberk_szee_ugyi_kod in (select ugyi_kod from helyettes where ugyi_kod_hel yettes=:2))) or :3='1' ) and ( UPPER(VRG.RESZ_NEV) LIKE :4 and (VRG.RESZ_NEV LIKE :5 or VRG.RESZ_NEV LIKE :6 or VRG.RESZ_NEV LIKE :7 or VRG.RESZ_NEV LIKE :8)) order by RESZ_NEV, DJOG_FOGAZONIH-9
28ykwc28c0vay	SELECT VRG.RESZ_NEV, VRG.RESZ_ELONEV, VRG.RESZ_SZULDATUM, VRG.RESZ_ADOSZAM, VRG.RESZ_TAJSZAM, VRG.RESZ_UTLEVEL, VRG.DJOG_FOGSOR, VRG.VBERK_SZEE_UGYI_KOD, VRG.VBERK_BERG_TORZSSZAM, VRG.RESZ_SZMAZONIH, VRG.DJOG_BERK_BERKIFAZON, VRG.DJOG_FOGAZONIH, VRG.VBERK_SZEE_AZONOSITO, VRG.djog_megszunes FROM V_RESZDJOG VRG WHERE ( ( VRG.RESZ_SZMAZONIH IN (select resz_szmazonih from eloado where eloado=/:global.eloado/:1) or (vrg.vberk_szee_ugyi_kod in (select ugyi_kod from helyettes where ugyi_kod_hel yettes=:2))) or :3='1' ) and (VRG.RESZ_SZULDATUM=:4) order by RESZ_NEV, DJOG_FOGAZONIH-9
2vuqztfak9qvz	UPDATE ATLAGOK SET OSZTO08=NVL(OSZTO08, 0) + :b1 , FT13OSZ08=NVL(FT13OSZ08, 0) + :b2 WHERE DJOG_FOGAZONIH = :b3 AND EVSZAM = :b4
2yf5uv17yv94k	SELECT substr(RV_LOW_VALUE, 1, 1) RV_LOW_VALUE , substr(RV_MEANING, 1, 5) RV_MEANING FROM CG_REF_CODES WHERE RV_DOMAIN = '01' ORDER BY RV_LOW_VALUE
3v9v8ujzm4whb	SELECT * FROM TBTETEL WHERE TAVO_TAVAZONIH = :b1 AND STATUSZ = '0' ORDER BY TAVKEZD, TAVVEGE, TJOGCIM
441129zwf3wvr	UPDATE EVESTENY SET NNAP08=NVL(NNAP08, 0) - :b1 WHERE DJOG_FOGAZONIH = :b2 AND EVSZAM = :b3
47r1y8yn34jmj	select default$ from col$ where rowid=:1
4b26spmmjd279	SELECT KF.ALLASJEL, KT.KIADASNEM, KT.FOGJELLEG FROM KIADTORT KT, KIADFOG KF WHERE KT.DJOG_FOGAZONIH = :b1 AND KT.KEZD <= NVL(:b2, :b3) AND NVL(KT.VEGE, TO_DATE('39991231', 'yyyymmdd')) >= NVL(:b2, :b3) AND KF.KIADASNEM = KT.KIADASNEM AND KF.FOGJELLEG = KT.FOGJELLEG AND KF.DATUMTOL <= GREATEST(KT.KEZD, TO_DATE('20010101', 'yyyymmdd')) AND KF.DATUMIG >= GREATEST(KT.KEZD, TO_DATE('20010101', 'yyyymmdd'))
4czuhzpsqzjwr	INSERT INTO NAPLO(AZON, SZMAZONIH, FOGAZONIH, PROGRAM, VERZIO, ELOADO, AKTELOADO, TABLA, AKCIO, ROGZITES, SZIDOSZAK, KIDOSZAK, GEPNEV, USERNEV, ADAT) VALUES(:B1 , NAPLOZ.ELKODOL(TO_CHAR(:B13 ), :B1 ), NAPLOZ.ELKODOL(TO_CHAR(:B12 ), :B1 ), NAPLOZ.ELKODOL(:B11 , :B1 ), NAPLOZ.ELKODOL(:B10 , :B1 ), NAPLOZ.ELKODOL(:B9 , :B1 ), NAPLOZ.ELKODOL(:B8 , :B1 ), NAPLOZ.ELKODOL('EVESTENY', :B1 ), NAPLOZ.ELKODOL(:B7 , :B1 ), NAPLOZ.ELKODOL(TO_CHAR(SYSDATE, 'yyyy.mm.dd./hh24:mi:ss'), :B1 ), NAPLOZ.ELKODOL(:B6 , :B1 ), NAPLOZ.ELKODOL(:B5 , :B1 ), NAPLOZ.ELKODOL(:B4 , :B1 ), NAPLOZ.ELKODOL(:B3 , :B1 ), NAPLOZ.ELKODOL(:B2 , :B1 ))
4ftasyybktj9j	SELECT TAVKEZD FROM TKODOK TK, TBTETEL TBT, TAVOL T WHERE TK.FOLY2JEL NOT IN ( '2', '6' ) AND TK.JELZO = '3' AND TK.TIPUS = :b1 AND TK.JOGCIM = TBT.TJOGCIM AND TBT.TJOGCIM != '15010' AND TBT.TAVVEGE = :b2 - 1 AND TBT.STATUSZ = '0' AND TBT.TAVO_TAVAZONIH = T.TAVAZONIH AND T.SZTORNO = 'N' AND T.DJOG_FOGAZONIH = :b3
4tuv9t25jutcm	INSERT INTO TAVOL TAVO(KOD, KEZD, KEZDODO, GYOGYULT, VEGE, JOGOSULT, JVEGE, TAVORA, TPLEJAR, TBELLATAS, TERITMENY, TAVOLDIJ, TPKIEG, SZTORNO, MELLEKLET, MUSZAKREND, GENERALT, UEVHO, RESZ_SZMAZONIH, TAVAZONIH, DJOG_FOGAZONIH, EJUT_SORSZAM, ALAP, OSZTO, NRALAP, NROSZTO, MODMAX) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27)
4ubf0xz92w3kt	SELECT * FROM MNAPAT WHERE PIHENONAP = :1
5a6zvw6bgk28y	INSERT INTO TTERIT ( TTERAZON, TAVO_TAVAZONIH, SORSZAM, TJOGCIM, IDEGEN, VISSZAVET, TAVKEZD, TAVVEGE, MUNKANAP, NAPTARINAP, JOGCIM, ALAPJA, TERITMENY, STATUSZ, UEVHO, BERKIFAZON, ROGZITES ) VALUES ( :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17 )
5fx1bgfqq95pg	SELECT VRG.RESZ_NEV, VRG.RESZ_ELONEV, VRG.RESZ_SZULDATUM, VRG.RESZ_ADOSZAM, VRG.RESZ_TAJSZAM, VRG.RESZ_UTLEVEL, VRG.DJOG_FOGSOR, VRG.VBERK_SZEE_UGYI_KOD, VRG.VBERK_BERG_TORZSSZAM, VRG.RESZ_SZMAZONIH, VRG.DJOG_BERK_BERKIFAZON, VRG.DJOG_FOGAZONIH, VRG.VBERK_SZEE_AZONOSITO, VRG.djog_megszunes FROM V_RESZDJOG VRG WHERE ( ( VRG.RESZ_SZMAZONIH IN (select resz_szmazonih from eloado where eloado=/:global.eloado/:1) or (vrg.vberk_szee_ugyi_kod in (select ugyi_kod from helyettes where ugyi_kod_helyettes =:2))) or :3='1' ) order by RESZ_NEV, DJOG_FOGAZONIH-9
5mcq2uj822xy3	ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY/MM/DD HH24:MI:SS'
60bt08y455bs8	UPDATE TAVOL TAVO SET TAVO.KOD=:1, TAVO.KEZD=:2, TAVO.KEZDODO=:3, TAVO.GYOGYULT=:4, TAVO.VEGE=:5, TAVO.JOGOSULT=:6, TAVO.JVEGE=:7, TAVO.TAVORA=:8, TAVO.TPLEJAR=:9, TAVO.TBELLATAS=:10, TAVO.TERITMENY=:11, TAVO.TAVOLDIJ=:12, TAVO.TPKIEG=:13, TAVO.SZTORNO=:14, TAVO.MELLEKLET=:15, TAVO.MUSZAKREND=:16, TAVO.GENERALT=:17, TAVO.UEVHO=:18, TAVO.RESZ_SZMAZONIH=:19, TAVO.TAVAZONIH=:20, TAVO.DJOG_FOGAZONIH=:21, TAVO.EJUT_SORSZAM=:22, TAVO.ALAP=:23, TAVO.OSZTO=:24, TAVO.NRALAP=:25, TAVO.NROSZTO=:26, TAVO.MO DMAX=:27 WHERE ROWID=:28
62bc3djway77z	UPDATE TAVOL SET TBELLATAS=TBELLATAS + :b1 , TAVOLDIJ=TAVOLDIJ + :b2 , TPKIEG=TPKIEG + :b3 , TERITMENY=TERITMENY + :b4 WHERE TAVAZONIH = :b5
6jkcmz3n85trq	SELECT MAX(TAVVEGE) FROM TTERIT WHERE TAVO_TAVAZONIH = :b1 AND STATUSZ = '0'
7cff8vv7fat8n	SELECT M.MUNKAREND FROM MUNKAUGYEK M WHERE FOGAZONIH = :b1
7jnz6jg4nn3tq	UPDATE TB SET TIBSZ=NVL(TIBSZ, 0) + :b1 WHERE DJOG_FOGAZONIH = :b2 AND EVSZAM = :b3
7sa4v2c8a5jtv	SELECT NAPLO_SEQ.NEXTVAL FROM SYS.DUAL
8r1w3j35mbq7k	SELECT RV_MEANING, RV_LOW_VALUE FROM CG_REF_CODES WHERE RV_DOMAIN = '74' ORDER BY 1
8v0s8g8hbd8tz	SELECT NVL(KULCSSZAM, 'XX'), SUBSTR(NVL(KULCSSZAM, 'XX'), 1, 1), SUBSTR(NVL(KULCSSZAM, 'XX'), 1, 2) FROM SOROLFEJ S0 WHERE S0.DJOG_FOGAZONIH = :b1 AND S0.FJELZO = '00' AND S0.SORSZAM = (SELECT MAX(SORSZAM) FROM SOROLFEJ S1 WHERE S1.DJOG_FOGAZONIH = :b1 AND S1.KEZD <= :b3 )
942848zttvrxk	SELECT UGYI_KOD FROM HELYETTES WHERE UGYI_KOD_HELYETTES = :b1 AND UGYI_KOD = :b2
9m22qp63dh8tp	ALTER SESSION SET REMOTE_DEPENDENCIES_MODE=SIGNATURE
9mfw46w0bzx09	INSERT INTO NAPLO(AZON, SZMAZONIH, FOGAZONIH, PROGRAM, VERZIO, ELOADO, AKTELOADO, TABLA, AKCIO, ROGZITES, SZIDOSZAK, KIDOSZAK, GEPNEV, USERNEV, ADAT) VALUES(:B1 , NAPLOZ.ELKODOL(TO_CHAR(:B13 ), :B1 ), NAPLOZ.ELKODOL(TO_CHAR(:B12 ), :B1 ), NAPLOZ.ELKODOL(:B11 , :B1 ), NAPLOZ.ELKODOL(:B10 , :B1 ), NAPLOZ.ELKODOL(:B9 , :B1 ), NAPLOZ.ELKODOL(:B8 , :B1 ), NAPLOZ.ELKODOL('TTERIT', :B1 ), NAPLOZ.ELKODOL(:B7 , :B1 ), NAPLOZ.ELKODOL(TO_CHAR(SYSDATE, 'yyyy.mm.dd./hh24:mi:ss'), :B1 ) , NAPLOZ.ELKODOL(:B6 , :B1 ), NAPLOZ.ELKODOL(:B5 , :B1 ), NAPLOZ.ELKODOL(:B4 , :B1 ), NAPLOZ.ELKODOL(:B3 , :B1 ), NAPLOZ.ELKODOL(:B2 , :B1 ))
aq0cxnrqcrwym	SELECT * FROM MUNKAREND WHERE KEZD <= :1 AND VEGE >= :1 AND DJOG_FOGAZONIH = :1 ORDER BY KEZD
axm5005kdufpd	select ROLE GRPNAME , FLAG GRPFLG from FRM50_ENABLED_ROLES order by ROLE desc
bf7vh5bcn4211	SELECT substr(RV_LOW_VALUE, 1, 1) RV_LOW_VALUE , substr(RV_MEANING, 1, 57) RV_MEANING FROM CG_REF_CODES WHERE RV_DOMAIN = '102' ORDER BY RV_LOW_VALUE
c8gd0a0gx2szj	SELECT SUM(NVL(A.TERITMENY, 0)), SUM(NVL(A.MUNKANAP, 0)) FROM TAVOL B, TTERIT A WHERE DJOG_FOGAZONIH = :b1 AND TAVO_TAVAZONIH = TAVAZONIH AND A.TJOGCIM = :b2 AND A.TAVKEZD >= :b3 AND A.TAVVEGE <= :b4 AND A.ALAPJA = :b5 AND A.STATUSZ = '0'
cg2k37y9rbrpq	INSERT INTO TBTETEL ( TBTETAZON, TAVO_TAVAZONIH, SORSZAM, TJOGCIM, VISSZAVET, TAVKEZD, TAVVEGE, MUNKANAP, NAPTARINAP, FOLY1, FOLY2, SZAZALEK, EGYNAPI, TBELLATAS, GYOGYULT, STATUSZ, UEVHO, KEZDOJELZO, KOD, DJOG_FOGAZONIH, RESZ_SZMAZONIH_RESZ, RESZ_SZMAZONIH_JOGOS, BSZJOGNAP, ROGZITES ) VALUES ( :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24 )
cw2y0qwa9sfgp	SELECT VRG.RESZ_NEV, VRG.RESZ_ELONEV, VRG.RESZ_SZULDATUM, VRG.RESZ_ADOSZAM, VRG.RESZ_TAJSZAM, VRG.RESZ_UTLEVEL, VRG.DJOG_FOGSOR, VRG.VBERK_SZEE_UGYI_KOD, VRG.VBERK_BERG_TORZSSZAM, VRG.RESZ_SZMAZONIH, VRG.DJOG_BERK_BERKIFAZON, VRG.DJOG_FOGAZONIH, VRG.VBERK_SZEE_AZONOSITO, VRG.djog_megszunes FROM V_RESZDJOG VRG WHERE ( ( VRG.RESZ_SZMAZONIH IN (select resz_szmazonih from eloado where eloado=/:global.eloado/:1) or (vrg.vberk_szee_ugyi_kod in (select ugyi_kod from helyettes where ugyi_kod_hel yettes=:2))) or :3='1' ) order by RESZ_NEV, DJOG_FOGAZONIH-9
d67xbu2yw4jcf	SELECT A.KEZD, A.VEGE, NVL(A.EERTEKE, 0) EERTEK, B.BBETALAP BETALAP, B.BTERIT TERITM, B.BTAVALAP TAVALAP FROM BEREK A, BERJOGC B WHERE DJOG_FOGAZONIH = :b1 AND KEZD <= :b2 AND VEGE >= :b3 AND A.JOGCIM = B.JOGCIM AND DATUMTOL <= :b3 AND DATUMIG >= :b3 AND ((B.BBETALAP = 'I' AND B.BTERIT = 'N' ) OR B.BTAVALAP = 'I' )ORDER BY FJELZO, A.JOGCIM, IDEGEN, KEZD, VEGE
dnq8hyrpwb01p	SELECT USER, TO_CHAR(SYSDATE, 'yyyy.mm.dd') FROM DUAL
f4xf8228tsuzv	INSERT INTO NAPLO(AZON, SZMAZONIH, FOGAZONIH, PROGRAM, VERZIO, ELOADO, AKTELOADO, TABLA, AKCIO, ROGZITES, SZIDOSZAK, KIDOSZAK, GEPNEV, USERNEV, ADAT) VALUES(:B1 , NAPLOZ.ELKODOL(TO_CHAR(:B13 ), :B1 ), NAPLOZ.ELKODOL(TO_CHAR(:B12 ), :B1 ), NAPLOZ.ELKODOL(:B11 , :B1 ), NAPLOZ.ELKODOL(:B10 , :B1 ), NAPLOZ.ELKODOL(:B9 , :B1 ), NAPLOZ.ELKODOL(:B8 , :B1 ), NAPLOZ.ELKODOL('TAVOL', :B1 ), NAPLOZ.ELKODOL(:B7 , :B1 ), NAPLOZ.ELKODOL(TO_CHAR(SYSDATE, 'yyyy.mm.dd./hh24:mi:ss'), :B1 ), NAPLOZ.ELKODOL(:B6 , :B1 ), NAPLOZ.ELKODOL(:B5 , :B1 ), NAPLOZ.ELKODOL(:B4 , :B1 ), NAPLOZ.ELKODOL(:B3 , :B1 ), NAPLOZ.ELKODOL(:B2 , :B1 ))
f59xssgpjr9jp	SELECT * FROM TB WHERE DJOG_FOGAZONIH = :b1 AND EVSZAM = :b2 AND ROWNUM < 2
f5d5rmc57ttcj	SELECT VRG.RESZ_NEV, VRG.RESZ_ELONEV, VRG.RESZ_SZULDATUM, VRG.RESZ_ADOSZAM, VRG.RESZ_TAJSZAM, VRG.RESZ_UTLEVEL, VRG.DJOG_FOGSOR, VRG.VBERK_SZEE_UGYI_KOD, VRG.VBERK_BERG_TORZSSZAM, VRG.RESZ_SZMAZONIH, VRG.DJOG_BERK_BERKIFAZON, VRG.DJOG_FOGAZONIH, VRG.VBERK_SZEE_AZONOSITO, VRG.djog_megszunes FROM V_RESZDJOG VRG WHERE ( ( VRG.RESZ_SZMAZONIH IN (select resz_szmazonih from eloado where eloado=/:global.eloado/:1) or (vrg.vberk_szee_ugyi_kod in (select ugyi_kod from helyettes where ugyi_kod_hel yettes=:2))) or :3='1' ) and ( UPPER(VRG.RESZ_NEV) LIKE :4 and (VRG.RESZ_NEV LIKE :5 or VRG.RESZ_NEV LIKE :6)) order by RESZ_NEV, DJOG_FOGAZONIH-9
fhpcj88szp7r9	UPDATE TAVOL SET ROGZITES=:b1 WHERE TAVAZONIH = :b2
ftj9uawt4wwzb	select condition from cdef$ where rowid=:1
gf3475wtsu9j0	SELECT JOGTIPKOD, KEZD, VEGE FROM JOGTORT WHERE DJOG_FOGAZONIH = :b1 AND KEZD <= :b2 AND (VEGE IS NULL OR VEGE >= :b2 )
grwydz59pu6mc	select text from view$ where rowid=: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	513,508	290.22	349.33
CPU used when call started	513,300	290.10	349.18
CR blocks created	31,397	17.74	21.36
Cached Commit SCN referenced	2,248,348	1,270.68	1,529.49
Commit SCN cached	4,378	2.47	2.98
DB time	36,858,517	20,831.07	25,073.82
DBWR checkpoint buffers written	15,587	8.81	10.60
DBWR transaction table writes	725	0.41	0.49
DBWR undo block writes	2,088	1.18	1.42
IMU CR rollbacks	32,013	18.09	21.78
IMU Flushes	1,245	0.70	0.85
IMU Redo allocation size	1,497,948	846.58	1,019.01
IMU commits	225	0.13	0.15
IMU contention	169	0.10	0.11
IMU ktichg flush	5	0.00	0.00
IMU pool not allocated	390	0.22	0.27
IMU undo allocation size	2,138,000	1,208.32	1,454.42
IMU- failed to get a private strand	390	0.22	0.27
SQL*Net roundtrips to/from client	894,343	505.45	608.40
active txn count during cleanout	900,958	509.19	612.90
application wait time	4,786	2.70	3.26
background timeouts	5,603	3.17	3.81
branch node splits	15	0.01	0.01
buffer is not pinned count	68,374,211	38,642.58	46,513.07
buffer is pinned count	86,236,106	48,737.46	58,664.02
bytes received via SQL*Net from client	54,974,176	31,069.37	37,397.40
bytes sent via SQL*Net to client	14,783,749,186	8,355,228.23	10,056,972.24
calls to get snapshot scn: kcmgss	1,093,577	618.05	743.93
calls to kcmgas	35,269	19.93	23.99
calls to kcmgcs	4,015	2.27	2.73
change write time	363	0.21	0.25
cleanout - number of ktugct calls	63,875	36.10	43.45
cleanouts and rollbacks - consistent read gets	27,507	15.55	18.71
cleanouts only - consistent read gets	4,435	2.51	3.02
cluster key scan block gets	31,502	17.80	21.43
cluster key scans	17,062	9.64	11.61
commit cleanout failures: block lost	39	0.02	0.03
commit cleanout failures: callback failure	22	0.01	0.01
commit cleanout failures: cannot pin	48	0.03	0.03
commit cleanouts	24,562	13.88	16.71
commit cleanouts successfully completed	24,453	13.82	16.63
commit txn count during cleanout	9,716	5.49	6.61
concurrency wait time	16,055,468	9,073.96	10,922.09
consistent changes	1,223,350	691.39	832.21
consistent gets	144,253,562	81,526.78	98,131.67
consistent gets - examination	101,071,483	57,121.86	68,756.11
consistent gets from cache	144,253,576	81,526.79	98,131.68
cursor authentications	545	0.31	0.37
data blocks consistent reads - undo records applied	1,222,886	691.13	831.90
db block changes	157,831	89.20	107.37
db block gets	175,810	99.36	119.60
db block gets direct	584	0.33	0.40
db block gets from cache	175,226	99.03	119.20
deferred (CURRENT) block cleanout applications	10,902	6.16	7.42
enqueue conversions	1,761	1.00	1.20
enqueue releases	35,780	20.22	24.34
enqueue requests	36,817	20.81	25.05
enqueue timeouts	6	0.00	0.00
enqueue waits	835	0.47	0.57
exchange deadlocks	15	0.01	0.01
execute count	496,165	280.41	337.53
free buffer inspected	18,117	10.24	12.32
free buffer requested	890,683	503.38	605.91
heap block compress	1,593	0.90	1.08
hot buffers moved to head of LRU	15,095	8.53	10.27
immediate (CR) block cleanout applications	31,942	18.05	21.73
immediate (CURRENT) block cleanout applications	970	0.55	0.66
index fast full scans (full)	1,297	0.73	0.88
index fetch by key	51,103,115	28,881.59	34,764.02
index scans kdiixs1	3,992,697	2,256.52	2,716.12
leaf node 90-10 splits	187	0.11	0.13
leaf node splits	293	0.17	0.20
logons cumulative	484	0.27	0.33
messages received	15,594	8.81	10.61
messages sent	15,594	8.81	10.61
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	38,561,902	21,793.76	26,232.59
opened cursors cumulative	76,164	43.05	51.81
parse count (failures)	1,018	0.58	0.69
parse count (hard)	2,009	1.14	1.37
parse count (total)	82,067	46.38	55.83
parse time cpu	5,299	2.99	3.60
parse time elapsed	4,274,426	2,415.75	2,907.77
physical read IO requests	189,938	107.35	129.21
physical reads	824,079	465.74	560.60
physical reads cache	824,079	465.74	560.60
physical reads cache prefetch	634,384	358.53	431.55
physical reads direct	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	578,131	326.74	393.29
physical write IO requests	11,852	6.70	8.06
physical writes	17,060	9.64	11.61
physical writes direct	584	0.33	0.40
physical writes from cache	16,476	9.31	11.21
physical writes non checkpoint	12,787	7.23	8.70
pinned buffers inspected	1	0.00	0.00
prefetch clients - default	56	0.03	0.04
prefetch warmup blocks aged out before use	3,256	1.84	2.21
process last non-idle time	1,776	1.00	1.21
recursive calls	1,062,579	600.53	722.84
recursive cpu usage	196,859	111.26	133.92
redo blocks written	70,713	39.96	48.10
redo entries	108,721	61.45	73.96
redo ordering marks	1,517	0.86	1.03
redo size	34,316,212	19,394.25	23,344.36
redo synch time	100	0.06	0.07
redo synch writes	1,305	0.74	0.89
redo wastage	650,392	367.58	442.44
redo write time	155	0.09	0.11
redo writes	1,993	1.13	1.36
rollback changes - undo records applied	1,182	0.67	0.80
rollbacks only - consistent read gets	4,428	2.50	3.01
rows fetched via callback	16,936,506	9,571.89	11,521.43
session connect time	31	0.02	0.02
session cursor cache hits	18,706	10.57	12.73
session logical reads	144,428,977	81,625.92	98,251.00
session pga memory	342,081,184	193,331.63	232,708.29
session pga memory max	353,511,328	199,791.53	240,483.90
session uga memory	###############	63,654,468.53	76,619,238.27
session uga memory max	1,204,548,872	680,766.47	819,421.00
shared hash latch upgrades - no wait	4,013,538	2,268.30	2,730.30
shared hash latch upgrades - wait	564	0.32	0.38
sorts (memory)	39,845	22.52	27.11
sorts (rows)	6,414,767	3,625.39	4,363.79
switch current to new buffer	201	0.11	0.14
table fetch by rowid	47,314,180	26,740.22	32,186.52
table fetch continued row	116	0.07	0.08
table scan blocks gotten	5,310,013	3,001.02	3,612.25
table scan rows gotten	123,054,719	69,545.98	83,710.69
table scans (short tables)	119,267	67.41	81.13
transaction rollbacks	128	0.07	0.09
undo change vector size	9,515,000	5,377.53	6,472.79
user I/O wait time	230,835	130.46	157.03
user calls	445,789	251.94	303.26
user commits	1,160	0.66	0.79
user rollbacks	310	0.18	0.21
workarea executions - optimal	25,078	14.17	17.06
write clones created in foreground	1	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)
Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Begin Value	End Value
session cursor cache count	730	8,790
opened cursors current	2,523	36,767
workarea memory allocated	0	3,363
logons current	82	384

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
KIR_DATA	148,467	84	11.34	3.74	7,017	4	1,216	19.83
KIR_INDX	30,272	17	15.75	5.68	2,433	1	1,352	23.98
KIR_DATA2	5,751	3	12.84	15.62	4	0	168	24.82
UNDOTBS	750	0	12.19	1.00	1,571	1	29	1.38
SYSTEM	2,077	1	8.36	1.41	77	0	1	0.00
SYSAUX	981	1	8.50	2.15	678	0	12	43.33
KIR_TEMP	3	0	26.67	1.00	0	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)
KIR_DATA	/data/oracle/DB1/kir_data_01.dbf	16,402	9	11.52	3.92	1,351	1	105	12.86
KIR_DATA	/data/oracle/DB1/kir_data_02.dbf	18,897	11	11.26	3.73	1,254	1	162	18.40
KIR_DATA	/data/oracle/DB1/kir_data_03.dbf	16,350	9	11.20	3.75	677	0	174	20.75
KIR_DATA	/data/oracle/DB1/kir_data_04.dbf	16,134	9	11.41	3.80	636	0	132	19.39
KIR_DATA	/data/oracle/DB1/kir_data_05.dbf	15,664	9	11.66	3.70	581	0	99	15.45
KIR_DATA	/data/oracle/DB1/kir_data_06.dbf	16,243	9	11.34	3.71	593	0	135	25.78
KIR_DATA	/data/oracle/DB1/kir_data_07.dbf	16,724	9	11.29	3.72	718	0	168	23.45
KIR_DATA	/data/oracle/DB1/kir_data_08.dbf	16,415	9	11.29	3.68	611	0	142	19.51
KIR_DATA	/data/oracle/DB1/kir_data_09.dbf	15,638	9	11.14	3.63	596	0	99	19.09
KIR_DATA2	/data/oracle/DB1/kir_data10.dbf	5,751	3	12.84	15.62	4	0	168	24.82
KIR_INDX	/data/oracle/DB1/kir_indx_01.dbf	1,667	1	14.00	5.37	115	0	148	5.95
KIR_INDX	/data/oracle/DB1/kir_indx_02.dbf	1,800	1	15.13	5.26	96	0	165	86.06
KIR_INDX	/data/oracle/DB1/kir_indx_03.dbf	2,966	2	13.82	4.88	227	0	182	13.46
KIR_INDX	/data/oracle/DB1/kir_indx_04.dbf	7,272	4	17.15	6.36	681	0	163	11.66
KIR_INDX	/data/oracle/DB1/kir_indx_05.dbf	1,160	1	8.68	3.24	4	0	42	2.62
KIR_INDX	/data/oracle/DB1/kir_indx_06.dbf	9,132	5	16.27	5.80	800	0	363	23.72
KIR_INDX	/data/oracle/DB1/kir_indx_07.dbf	6,275	4	16.23	5.76	510	0	289	14.78
KIR_TEMP	/data/oracle/DB1/kir_temp_01.dbf	1	0	30.00	1.00	0	0	0
KIR_TEMP	/data/oracle/DB1/kir_temp_02.dbf	1	0	40.00	1.00	0	0	0
KIR_TEMP	/data/oracle/DB1/kir_temp_03.dbf	1	0	10.00	1.00	0	0	0
SYSAUX	/data/oracle/DB1/sysaux01.dbf	981	1	8.50	2.15	678	0	12	43.33
SYSTEM	/data/oracle/DB1/system01.dbf	2,077	1	8.36	1.41	77	0	1	0.00
UNDOTBS	/data/oracle/DB1/undotbs01.dbf	548	0	11.50	1.00	1,111	1	16	1.88
UNDOTBS	/data/oracle/DB1/undotbs02.dbf	202	0	14.06	1.00	460	0	13	0.77

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	705,740	99	143,768,483	823,791	16,448	0	0	2,778

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
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	24	254	652	9,624	921,600	9,624
E	0	26	4,256	18,661	70,949	921,600	70,949

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 Estimate (M)	Size Factr	Buffers for Estimate	Est Physical Read Factor	Estimated Physical Reads
D	560	0.10	69,580	11.72	10,039,088
D	1,120	0.20	139,160	3.50	2,999,848
D	1,680	0.30	208,740	1.27	1,088,874
D	2,240	0.39	278,320	1.03	882,581
D	2,800	0.49	347,900	1.01	864,334
D	3,360	0.59	417,480	1.01	861,406
D	3,920	0.69	487,060	1.00	859,462
D	4,480	0.79	556,640	1.00	856,885
D	5,040	0.89	626,220	1.00	856,534
D	5,600	0.99	695,800	1.00	856,534
D	5,680	1.00	705,740	1.00	856,534
D	6,160	1.08	765,380	1.00	856,534
D	6,720	1.18	834,960	1.00	856,534
D	7,280	1.28	904,540	1.00	856,534
D	7,840	1.38	974,120	1.00	856,534
D	8,400	1.48	1,043,700	1.00	856,534
D	8,960	1.58	1,113,280	1.00	856,534
D	9,520	1.68	1,182,860	1.00	856,534
D	10,080	1.77	1,252,440	1.00	856,534
D	10,640	1.87	1,322,020	1.00	856,534
D	11,200	1.97	1,391,600	1.00	856,534

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	542	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,798	158.79	0.00	0.00	0.00	0.00	102,400
E	2,048	1,644	610.29	6.02	0.99	100.00	0.00	102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	24,704	24,704
64K	128K	11	11
128K	256K	105	105
256K	512K	50	50
512K	1024K	53	53
1M	2M	80	80
2M	4M	39	39
4M	8M	31	31
8M	16M	2	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd PGA Cache Hit %
256	0.13	574.20	100.00
512	0.25	574.20	100.00
1,024	0.50	574.20	100.00
1,536	0.75	574.20	100.00
2,048	1.00	574.20	100.00
2,458	1.20	574.20	100.00
2,867	1.40	574.20	100.00
3,277	1.60	574.20	100.00
3,686	1.80	574.20	100.00
4,096	2.00	574.20	100.00
6,144	3.00	574.20	100.00
8,192	4.00	574.20	100.00
12,288	6.00	574.20	100.00
16,384	8.00	574.20	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
496	0.39	44	4,123	12,314	1.00	35,123	1.00	377,769
624	0.49	44	4,123	12,314	1.00	35,123	1.00	377,769
752	0.59	44	4,123	12,314	1.00	35,123	1.00	377,769
880	0.70	44	4,123	12,314	1.00	35,123	1.00	377,769
1,008	0.80	44	4,123	12,314	1.00	35,123	1.00	377,769
1,136	0.90	44	4,123	12,314	1.00	35,123	1.00	377,769
1,264	1.00	44	4,123	12,314	1.00	35,123	1.00	377,769
1,392	1.10	44	4,123	12,314	1.00	35,123	1.00	377,769
1,520	1.20	44	4,123	12,314	1.00	35,123	1.00	377,769
1,648	1.30	44	4,123	12,314	1.00	35,123	1.00	377,769
1,776	1.41	44	4,123	12,314	1.00	35,123	1.00	377,769
1,904	1.51	44	4,123	12,314	1.00	35,123	1.00	377,769
2,032	1.61	44	4,123	12,314	1.00	35,123	1.00	377,769
2,160	1.71	44	4,123	12,314	1.00	35,123	1.00	377,769
2,288	1.81	44	4,123	12,314	1.00	35,123	1.00	377,769
2,416	1.91	44	4,123	12,314	1.00	35,123	1.00	377,769
2,544	2.01	44	4,123	12,314	1.00	35,123	1.00	377,769

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	2,728	61	22
1st level bmb	14	0	3
segment header	4	0	8
undo block	20	0	1
undo header	9	0	2
2nd level bmb	3	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue stats gathered prior to 10i should not be compared with 10i 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	3,117	3,100	588	5,667	9,636.97
US-Undo Segment	3,848	3,848	135	59	439.88
SQ-Sequence Cache	98	98	37	53	1,431.32
HW-Segment High Water Mark	1,225	1,225	1	2	1,624.00
JD-Job Queue Date	337	337	1	1	1,256.00
TX-Transaction (row lock contention)	1	1	1	1	1,120.00
TX-Transaction (index contention)	70	70	70	1	8.89
PR-Process Startup	382	382	1	0	365.00
FB-Format Block	114	114	1	0	1.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Undo Blocks	Num Trans	Max Qry Len (s)	Max Tx Concurcy	Snap TooOld	OutOf Space	uS/uR/uU/ eS/eR/eU
1	1,092	1,796	957	184	0	0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

ordered by Time desc

End Time	Undo Blocks	Num Trans	Max Qry Len (s)	Max Tx Concy	uS/uR/uU/ eS/eR/eU
20-Feb 08:54	433	624	957	184	0/0/0/0/0/0
20-Feb 08:44	488	826	451	169	0/0/0/0/0/0
20-Feb 08:34	171	346	0	55	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
Consistent RBA	1,990	0.00		0	0
FOB s.o list latch	6,554	0.14	0.00	0	0
In memory undo latch	550,651	0.04	0.01	0	1,927	0.00
JS queue state obj latch	9,330	0.00		0	0
JS slv state obj latch	18	0.00		0	0
KMG MMAN ready and startup request latch	398	0.00		0	0
KMG resize request state object freelist	140	0.00		0	0
KTF sga enqueue	4	0.00		0	487	0.00
KWQMN job cache list latch	58	0.00		0	0
MQL Tracking Latch	0			0	36	0.00
Memory Management Latch	11,136	0.02	0.50	0	2,502	0.04
PL/SQL warning settings	1,298	0.00		0	0
SQL memory manager latch	1	0.00		0	592	0.00
SQL memory manager workarea list latch	40,441	0.00	1.00	0	0
SWRF Alerted Metric Element list	19,673	0.00		0	0
active checkpoint queue latch	12,806	0.16	0.00	0	0
active service list	2,958	0.00		0	0
address list	394	0.00		0	0
archive control	7	0.00		0	0
begin backup scn array	24	0.00		0	0
buffer pool	1,959	0.00		0	0
cache buffer handles	15,763	0.00		0	0
cache buffers chains	191,287,617	0.72	0.01	80	1,983,605	0.02
cache buffers lru chain	610,507	0.25	0.01	0	1,008,016	0.30
channel handle pool latch	779	0.00		0	0
channel operations parent latch	6,292,230	0.00		0	0
checkpoint queue latch	139,540	0.00	0.00	0	159,515	0.01
child cursor hash table	24,706	0.83	0.17	34	0
client/application info	240	0.00		0	0
commit callback allocation	27	0.00		0	0
compile environment latch	5,730	0.00		0	0
cursor bind value capture	375	0.00		0	582	0.00
dml lock allocation	16,436	0.18	0.00	0	0
dummy allocation	665	0.00		0	0
enqueue hash chains	76,814	1.21	0.23	37	3,391	0.00
enqueues	57,953	0.28	0.00	0	0
event group latch	436	0.00		0	0
file cache latch	244	0.00		0	0
global KZLD latch for mem in SGA	450	0.00		0	0
hash table column usage latch	300	0.00		0	192,494	0.00
hash table modification latch	26	0.00		0	0
job workq parent latch	0			0	54	0.00
job_queue_processes parameter latch	53	0.00		0	0
kmcptab latch	626	0.80	0.00	0	0
kmcpvec latch	0			0	584	7.19
ksuosstats global area	121	0.00		0	0
ktm global data	18	0.00		0	0
lgwr LWN SCN	1,990	0.00		0	0
library cache	2,149,675	23.63	0.95	107,307	0
library cache load lock	2,156	0.00		0	72	0.00
library cache lock	283,863	0.44	0.02	0	0
library cache lock allocation	21,751	0.92	0.96	17	0
library cache pin	1,778,438	0.93	0.04	1	7,103	0.01
library cache pin allocation	22,579	0.61	0.96	10	0
list of block allocation	1,184	0.00		0	0
loader state object freelist	8	0.00		0	0
message pool operations parent latch	16	0.00		0	0
messages	45,273	0.17	0.00	0	0
mostly latch-free SCN	2,011	0.50	0.00	0	0
multiblock read objects	127,372	0.26	0.11	1	0
ncodef allocation latch	30	0.00		0	0
object queue header heap	1,343	0.00		0	868	0.00
object queue header operation	2,052,677	0.00	0.00	0	0
object stats modification	105	0.00		0	0
parallel query alloc buffer	240	0.00		0	0
parameter list	18	0.00		0	0
parameter table allocation management	665	0.15	1.00	0	0
post/wait queue	1,891	0.05	0.00	0	902	0.00
process allocation	739	0.00		0	436	0.00
process group creation	739	0.00		0	0
qmn state object latch	13	0.00		0	0
qmn task queue latch	19	0.00		0	0
redo allocation	9,573	0.08	0.00	0	108,222	0.43
redo copy	0			0	108,368	0.55
redo writing	18,668	0.01	0.00	0	0
row cache objects	1,910,843	2.18	0.11	319	407	0.00
sequence cache	48,045	0.14	0.01	0	0
session allocation	53,549	0.32	0.85	11	0
session idle bit	894,643	0.01	0.22	0	0
session switching	30	0.00		0	0
session timer	638	0.00		0	0
shared pool	3,667,198	50.51	0.87	186,061	0
simulator hash latch	27,863,938	0.00	0.00	0	0
simulator lru latch	15,943	0.32	0.10	0	270,198	2.13
slave class	8	0.00		0	0
slave class create	33	3.03	1.00	0	0
sort extent pool	83	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	112	0.00		0	0
temporary table state object allocation	1	0.00		0	0
threshold alerts latch	84	0.00		0	0
trace latch	199	0.00		0	0
transaction allocation	1,253	0.00		0	0
transaction branch allocation	30	0.00		0	0
undo global data	3,062,079	0.05	0.01	0	161	0.00
user lock	3,370	9.38	1.06	51	0
virtual circuit buffers	4,010,374	0.06	0.04	0	0
virtual circuit queues	1,781,985	0.05	0.01	0	0
virtual circuits	887,914	0.50	0.05	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets	Sleep1	Sleep2	Sleep3
shared pool	3,667,198	1,852,308	1,615,940	283,656	1,523,968	42,547	2,137
cache buffers chains	191,287,617	1,381,933	13,173	1,373,482	3,777	4,624	50
library cache	2,149,675	507,861	484,079	34,651	463,085	9,563	562
row cache objects	1,910,843	41,680	4,442	37,254	4,410	16	0
library cache pin	1,778,438	16,598	653	15,945	653	0	0
virtual circuits	887,914	4,472	231	4,241	231	0	0
virtual circuit buffers	4,010,374	2,371	84	2,287	84	0	0
cache buffers lru chain	610,507	1,501	9	1,492	9	0	0
undo global data	3,062,079	1,395	10	1,385	10	0	0
library cache lock	283,863	1,256	26	1,230	26	0	0
enqueue hash chains	76,814	928	212	716	212	0	0
simulator hash latch	27,863,938	918	4	914	4	0	0
virtual circuit queues	1,781,985	828	9	819	9	0	0
multiblock read objects	127,372	332	38	294	38	0	0
user lock	3,370	316	336	4	288	24	0
In memory undo latch	550,651	225	2	223	2	0	0
child cursor hash table	24,706	206	34	178	22	6	0
library cache lock allocation	21,751	201	192	9	192	0	0
session allocation	53,549	172	147	25	147	0	0
library cache pin allocation	22,579	138	133	5	133	0	0
session idle bit	894,643	85	19	75	1	9	0
sequence cache	48,045	67	1	66	1	0	0
simulator lru latch	15,943	51	5	46	5	0	0
Memory Management Latch	11,136	2	1	1	1	0	0
SQL memory manager workarea list latch	40,441	2	2	0	2	0	0
slave class create	33	1	1	0	1	0	0
parameter table allocation management	665	1	1	0	1	0	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	1	0
In memory undo latch	kturbk	1	2
Memory Management Latch	kmgsdrv3	1	0
SQL memory manager workarea list latch	qesmmIRegisterWorkArea	2	0
cache buffers chains	kcbgtcr: kslbegin excl	9,950	8,150
cache buffers chains	kcbrls: kslbegin	2,300	4,233
cache buffers chains	kcbgtcr: fast path	459	251
cache buffers chains	kcbchg: kslbegin: bufs not pinned	276	345
cache buffers chains	kcbgtcr: kslbegin shared	77	66
cache buffers chains	kcbzgb: scan from tail. nowait	33	0
cache buffers chains	kcbzib: multi-block read: nowait	14	0
cache buffers chains	kcbget: pin buffer	14	12
cache buffers chains	kcbchg: kslbegin: call CR func	11	78
cache buffers chains	kcbzhngcbk1: get hash chain latch no wait	4	0
cache buffers chains	kcbzwb	3	1
cache buffers lru chain	kcbzib	4	0
cache buffers lru chain	kcbzgws	4	0
cache buffers lru chain	kcbzgpwb: KSLBEGIN use prewarm buffers	1	7
child cursor hash table	kksfbc: broken child	18	14
child cursor hash table	kkslod: mark kksb state	12	16
child cursor hash table	kksheqd: delete enqueue	1	0
child cursor hash table	kkslod: set parent info.	1	0
child cursor hash table	opiaba: bitset.	1	1
child cursor hash table	kkssbt: mark kksb state	1	0
cost function	kzulgt: find user res	216	192
cost function	kzulrl	121	145
enqueue hash chains	ksqcmi: get hash chain latch after wait	199	192
enqueue hash chains	ksqgtl3	7	14
enqueue hash chains	ksqrcl	4	6
enqueue hash chains	ksucallcbksafely: ksqhngcbk1	2	0
library cache	kglupc: child	160,033	176,924
library cache	kglpnc: child	132,495	119,781
library cache	kglpndl: child: before processing	64,942	51,313
library cache	kglpnp: child	32,233	40,739
library cache	kglpndl: child: after processing	20,234	45
library cache	kglobpn: child:	18,374	27,083
library cache	kglpin: child: heap processing	9,193	6,917
library cache	kglhdgn: child:	9,105	25,888
library cache	kgldti: 2child	7,543	3,649
library cache	kglpin	7,014	4,894
library cache	kgldte: child 0	3,624	4,238
library cache	kglhdgc: child:	2,976	6,667
library cache	kglget: set reserved lock	2,302	3,407
library cache	kglrtl	638	236
library cache	kgldtld: 2child	436	379
library cache	kglobld	226	395
library cache	kglini: child	135	106
library cache	kglic	88	54
library cache	kglprg: child	77	1
library cache	kglpim	75	81
library cache	kglati	18	66
library cache	kglpur: child	10	148
library cache	kglhfr: child	7	1
library cache	kglnti	2	5
library cache	kglget: unpin heap 0	1	0
library cache lock	kgllkdl: child: no lock handle	12,280	11,076
library cache lock	kgllkal: child: multiinstance	16	9
library cache lock	kgllkdl: child: cleanup	10	17
library cache lock allocation	kgllkget	189	173
library cache lock allocation	kgllkrel	3	19
library cache pin	kglupc	195	255
library cache pin	kglpndl	156	91
library cache pin	kglpnc: child	114	62
library cache pin	kglpnal: child: check granted	79	172
library cache pin	kglpnal: child: alloc space	77	44
library cache pin	kglpnp: child	20	27
library cache pin	ksucallcbksafely: kqlphng	9	0
library cache pin	kglpnck	3	2
library cache pin allocation	kglpnget	132	114
library cache pin allocation	kglpnrel	1	19
multiblock read objects	kcbzib: normal mbr free	19	32
multiblock read objects	kcbzib: mbr get	19	6
parameter table allocation management	ksp_param_table_alloc	1	1
row cache objects	kqreqd: reget	3,984	2
row cache objects	kqrpre: find obj	378	4,353
row cache objects	kqreqd	42	60
row cache objects	kqrso	35	1
row cache objects	kqrpre: init complete	3	24
sequence cache	kdnssd	1	0
session allocation	ksuprc	67	23
session allocation	ksucrp	30	8
session allocation	ksuxds: not user session	18	40
session allocation	ksucri	16	48
session allocation	ksuxds: KSUSFCLC not set	6	3
session allocation	ksursi	4	17
session allocation	ksudlc	3	10
session allocation	kspallmod	2	0
session allocation	ksuxds: KSUSFCLC set	1	0
session idle bit	ksupuc: clear busy	15	17
session idle bit	ksupuc: set busy	4	2
shared pool	kghalo	986,312	995,891
shared pool	kghfre	525,836	536,199
shared pool	kghupr1	98,014	79,749
shared pool	kghalp	5,461	3,885
shared pool	kghfen: not perm alloc class	388	177
shared pool	kghfru	66	186
shared pool	kgh: add new extent	60	72
shared pool	kghfree_extents: scan	10	11
simulator hash latch	kcbsacc: lookup dba	4	4
simulator lru latch	kcbs_simulate: simulate set	2	4
simulator lru latch	kcbs_free_granule_sim_buffers	2	0
simulator lru latch	kcbs_shrink_pool	1	1
slave class create	ksvcreate	1	0
undo global data	kturimugur: child	5	1
undo global data	ktucof: at start	2	0
undo global data	ktudba: KSLBEGIN	2	8
undo global data	ktusmofu: KSLBEGIN	1	0
virtual circuit queues	kmcfsq	6	5
virtual circuit queues	kmcadq	3	4
virtual circuits	kmcmbuf: move ckt	169	192
virtual circuits	kmcgms	62	39
virtual circuits	kmcgms: if called with non-zero ckt	41	0
virtual circuits	kmcgms: if shared server	35	82
virtual circuits	kmcmbf	5	0
virtual circuits	kmcfms	2	1
virtual circuits	kmcgms: if not shared server	1	1

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 Buffer Busy Waits
Segments by Row Lock Waits
Segments by ITL Waits

Segments by Logical Reads

% Total shows % of logical reads for each top segment compared with total logical reads for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
ILLETMENY	KIR_DATA	ELOA_PK	INDEX	40,067,024	28.47
ILLETMENY	KIR_INDX	RESZ_PK	INDEX	26,930,992	19.13
ILLETMENY	KIR_DATA	MUNKAUGYEK	TABLE	16,565,920	11.77
ILLETMENY	KIR_INDX	FOKO_PK	INDEX	14,038,480	9.97
ILLETMENY	KIR_INDX	DJOG_1_BERK_FK_I	INDEX	5,496,240	3.91

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
ILLETMENY	KIR_DATA	TAVOL		TABLE	89,183	11.23
ILLETMENY	KIR_DATA	MUNKAUGYEK		TABLE	76,199	9.60
ILLETMENY	KIR_DATA	TTERIT		TABLE	68,914	8.68
ILLETMENY	KIR_INDX	TTER_UK		INDEX	60,292	7.59
ILLETMENY	KIR_DATA	BEREK	P4	TABLE PARTITION	58,975	7.43

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	%Total
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	93	24.73
ILLETMENY	KIR_INDX	PROBA_01		INDEX	74	19.68
ILLETMENY	KIR_INDX	TTER_TAVO_FK_I		INDEX	63	16.76
ILLETMENY	KIR_DATA	BERE_PK		INDEX	48	12.77
ILLETMENY	KIR_INDX	TTER_UK		INDEX	38	10.11

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	%Total
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	22	30.99
ILLETMENY	KIR_DATA	BERE_PK		INDEX	15	21.13
ILLETMENY	KIR_INDX	TTER_TAVO_FK_I		INDEX	12	16.90
ILLETMENY	KIR_INDX	TTER_UK		INDEX	9	12.68
ILLETMENY	KIR_INDX	PROBA_01		INDEX	6	8.45

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

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	43	0.00	2	1
dc_global_oids	2,069	0.48	0	43
dc_histogram_data	974	4.31	0	810
dc_histogram_defs	9,308	7.54	0	4,101
dc_object_ids	58,071	0.28	0	871
dc_objects	16,363	3.50	0	1,692
dc_profiles	451	0.00	0	1
dc_rollback_segments	41,962	0.00	240	361
dc_segments	51,770	0.51	33	1,258
dc_sequences	61	8.20	61	14
dc_tablespaces	25,990	0.00	0	7
dc_usernames	3,130	10.51	0	402
dc_users	428,154	0.10	0	546
outstanding_alerts	34	29.41	4	19

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	4,544	0.40	77,807	0.03	0
CLUSTER	4	0.00	5	0.00	0
INDEX	1,056	0.00	1,104	0.00	0
SQL AREA	51,432	2.23	612,147	0.40	1,456
TABLE/PROCEDURE	18,278	1.20	223,475	0.16	0
TRIGGER	4,983	6.86	14,591	2.34	0

SGA Statistics

SGA Memory Summary
SGA breakdown difference

SGA Memory Summary

SGA regions	Size in Bytes
Database Buffers	5,955,911,680
Fixed Size	1,312,768
Redo Buffers	10,485,760
Variable Size	2,622,224,384

Back to SGA Statistics
Back to Top

SGA breakdown difference

Pool	Name	Begin value	End value	% Diff
java	free memory	16,777,216	16,777,216	0.00
large	PX msg pool	1,076,072	1,076,072	0.00
large	free memory	14,725,040	243,246,576	1,551.92
large	session heap	84,862,184	1,030,745,768	1,114.61
shared	ASH buffers	16,777,216	16,777,216	0.00
shared	Checkpoint queue	410,624	410,624	0.00
shared	DML lock	2,040,456	2,040,456	0.00
shared	FileOpenBlock	2,884,928	2,884,928	0.00
shared	KGLS heap	4,264,616	5,623,368	31.86
shared	KQR L PO	1,868,872	2,624,776	40.45
shared	KQR L SO	115,712	120,832	4.42
shared	KQR M PO	2,547,368	3,388,128	33.01
shared	KQR M SO	335,400	354,344	5.65
shared	KQR S SO	7,704	35,832	365.11
shared	KSPD key heap	4,240	4,240	0.00
shared	KSXR pending messages que	853,952	853,952	0.00
shared	KTI-UNDO	17,042,608	17,042,608	0.00
shared	PL/SQL DIANA	2,177,120	2,529,384	16.18
shared	PL/SQL MPCODE	3,754,208	5,272,936	40.45
shared	PLS non-lib hp	16,632	16,632	0.00
shared	PX subheap	706,616	706,616	0.00
shared	SGA struct - SWRF Metrics	1,449,280	1,449,280	0.00
shared	Temporary Tables State Ob	517,080	517,080	0.00
shared	VIRTUAL CIRCUITS	4,656,960	4,656,960	0.00
shared	alert threshol	4,664	4,664	0.00
shared	db_block_hash_buckets	2,490,368	2,490,368	0.00
shared	enqueue	4,310,048	4,310,048	0.00
shared	enqueue resources	1,369,912	1,369,912	0.00
shared	event statistics per sess	57,294,720	57,294,720	0.00
shared	fixed allocation callback	1,136	1,136	0.00
shared	free memory	1,016,291,904	902,845,984	-11.16
shared	joxs heap	4,240	4,240	0.00
shared	library cache	18,105,032	58,071,184	220.75
shared	miscellaneous	84,400,816	141,195,392	67.29
shared	parameters	55,328	61,984	12.03
shared	partitioning d	350,520	350,520	0.00
shared	pl/sql source	2,240	4,016	79.29
shared	private strands	31,967,232	31,967,232	0.00
shared	procs: ksunfy	1,768,000	1,768,000	0.00
shared	repository	86,112	141,808	64.68
shared	row cache	7,414,544	7,414,544	0.00
shared	sessions	10,972,088	10,972,088	0.00
shared	sql area	18,200,952	31,453,912	72.81
shared	table definiti	15,168	22,688	49.58
shared	temporary tabl	4,240	5,048	19.06
shared	transaction	5,271,288	5,271,288	0.00
shared	trigger defini	116,432	288,264	147.58
shared	trigger inform	14,920	98,912	562.95
shared	trigger source	8,800	65,184	640.73
shared	type object de	342,424	616,736	80.11
	buffer_cache	7,130,316,800	5,955,911,680	-16.47
	fixed_sga	1,312,768	1,312,768	0.00
	log_buffer	10,485,760	10,485,760	0.00

Back to SGA 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)
__db_cache_size	7130316800	5955911680
__large_pool_size	100663296	1275068416
audit_file_dest	/opt/oracle/admin/DB1/audit
background_dump_dest	/opt/oracle/admin/DB1/bdump
compatible	10.1.0.4.0
control_file_record_keep_time	100
control_files	/data/oracle/DB1/control01.ctl, /
core_dump_dest	/opt/oracle/admin/DB1/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	64
db_name	DB1
db_writer_processes	2
dispatchers	(protocol=tcp)(dispatchers=100)(c
event	10235 trace name context forever,
instance_name	DB1
job_queue_processes	5
local_listener	(address=(protocol=tcp)(host=s21a
log_archive_dest_1	location=/data/oracle/arch/DB1
log_archive_format	log_%t_%r_%S.arc
log_archive_max_processes	1
log_buffer	10485760
max_dispatchers	400
max_shared_servers	800
nls_language	hungarian
nls_territory	hungary
open_cursors	10000
pga_aggregate_target	2147483648
processes	2000
remote_login_passwordfile	EXCLUSIVE
service_names	DB1
session_cached_cursors	1000
sga_target	8589934592
shared_servers	100
sort_area_retained_size	524288
sort_area_size	1048576
statistics_level	TYPICAL
undo_management	AUTO
undo_retention	1800
undo_tablespace	UNDOTBS
user_dump_dest	/opt/oracle/admin/DB1/udump

End of Report

Buffer Cache:	5,680M	Std Block Size:	8K
Shared Pool Size:	1,264M	Log Buffer:	10,240K

% Blocks changed per Read:	0.11	Recursive Call %:	70.45
Rollback per transaction %:	21.09	Rows per Sort:	160.99

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.43	In-memory Sort %:	100.00
Library Hit %:	99.66	Soft Parse %:	97.55
Execute to Parse %:	83.46	Latch Hit %:	98.47
Parse CPU to Parse Elapsd %:	0.12	% Non-Parse CPU:	98.99