WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

ORA11G 4172642243 ora11g 1 28-Aug-12 03:08 11.1.0.7.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ORA11G	4172642243	ora11g	1	28-Aug-12 03:08	11.1.0.7.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

sdu1 Linux x86 64-bit 4 4 1 15.60

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
sdu1	Linux x86 64-bit	4	4	1	15.60

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 9055 11-Mar-13 22:00:20 73 6.9

End Snap: 9056 11-Mar-13 23:00:22 70 6.4

Elapsed: 60.03 (mins)

DB Time: 11.28 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	9055	11-Mar-13 22:00:20	73	6.9
End Snap:	9056	11-Mar-13 23:00:22	70	6.4
Elapsed:		60.03 (mins)
DB Time:		11.28 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 2,112M 2,112M Std Block Size: 8K

Shared Pool Size: 2,064M 2,064M Log Buffer: 10,444K

	Begin	End
Buffer Cache:	2,112M	2,112M	Std Block Size:	8K
Shared Pool Size:	2,064M	2,064M	Log Buffer:	10,444K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 0.2 1.5 0.00 0.00

DB CPU(s): 0.1 0.6 0.00 0.00

Redo size: 10,660.9 82,227.4

Logical reads: 1,409.2 10,869.5

Block changes: 273.7 2,111.3

Physical reads: 5.0 38.3

Physical writes: 1.6 12.5

User calls: 143.3 1,105.0

Parses: 45.6 351.6

Hard parses: 17.8 136.9

W/A MB processed: 151,546.1 1,168,879.6

Logons: 0.8 6.1

Executes: 97.6 752.4

Rollbacks: 0.0 0.0

Transactions: 0.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.2	1.5	0.00	0.00
DB CPU(s):	0.1	0.6	0.00	0.00
Redo size:	10,660.9	82,227.4
Logical reads:	1,409.2	10,869.5
Block changes:	273.7	2,111.3
Physical reads:	5.0	38.3
Physical writes:	1.6	12.5
User calls:	143.3	1,105.0
Parses:	45.6	351.6
Hard parses:	17.8	136.9
W/A MB processed:	151,546.1	1,168,879.6
Logons:	0.8	6.1
Executes:	97.6	752.4
Rollbacks:	0.0	0.0
Transactions:	0.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 73.80 Soft Parse %: 61.07

Execute to Parse %: 53.27 Latch Hit %: 99.78

Parse CPU to Parse Elapsd %: 0.00 % Non-Parse CPU: 82.50

Shared Pool Statistics

Begin End

Memory Usage %: 83.44 86.61

% SQL with executions>1: 78.33 74.77

% Memory for SQL w/exec>1: 78.98 75.69

	Begin	End
Memory Usage %:	83.44	86.61
% SQL with executions>1:	78.33	74.77
% Memory for SQL w/exec>1:	78.98	75.69

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		278		41.04
row cache lock	87	130	1489	19.13	Concurrency
db file sequential read	17,213	59	3	8.76	User I/O
library cache lock	2	21	10297	3.04	Concurrency
control file sequential read	29,980	7	0	0.98	System I/O

Host CPU (CPUs: 4 Cores: 4 Sockets: 1)

Load Average Begin Load Average End %User %System %WIO %Idle

2.05 1.50 5.8 8.6 1.9 85.5

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
2.05	1.50	5.8	8.6	1.9	85.5

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)

2.0 13.8 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
2.0	13.8	0.0

Begin End

Host Mem (MB): 15,974.4 15,974.4

SGA use (MB): 5,200.0 5,200.0

PGA use (MB): 331.6 257.5

% Host Mem used for SGA+PGA: 34.63 34.63

	Begin	End
Host Mem (MB):	15,974.4	15,974.4
SGA use (MB):	5,200.0	5,200.0
PGA use (MB):	331.6	257.5
% Host Mem used for SGA+PGA:	34.63	34.63

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): 677.1s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	411.17	60.73
parse time elapsed	290.10	42.85
DB CPU	277.87	41.04
hard parse elapsed time	264.07	39.00
PL/SQL execution elapsed time	173.22	25.58
failed parse elapsed time	80.57	11.90
connection management call elapsed time	17.17	2.54
hard parse (sharing criteria) elapsed time	12.38	1.83
PL/SQL compilation elapsed time	0.57	0.08
repeated bind elapsed time	0.17	0.03
Java execution elapsed time	0.07	0.01
hard parse (bind mismatch) elapsed time	0.03	0.00
sequence load elapsed time	0.01	0.00
DB time	677.08
background elapsed time	25.04
background cpu time	8.51

Back to Wait Events Statistics
Back to Top

Operating System Statistics

*TIME statistic values are diffed. All others display actual values. End Value is displayed if different
ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic	Value	End Value
BUSY_TIME	207,902
IDLE_TIME	1,226,879
IOWAIT_TIME	26,970
NICE_TIME	9
SYS_TIME	123,359
USER_TIME	82,884
LOAD	2	2
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	16,750,383,104
NUM_CPUS	4
NUM_CPU_CORES	4
NUM_CPU_SOCKETS	1
GLOBAL_RECEIVE_SIZE_MAX	8,388,608
GLOBAL_SEND_SIZE_MAX	8,388,608
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	174,760
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	131,072
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
11-Mar 22:00:20	2.05
11-Mar 23:00:22	1.50	14.49	5.78	8.60	1.88	85.51

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 74.3% of Total DB time 677.08 (s)
Total FG Wait Time: 225.14 (s) DB CPU time: 277.87 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			278		41.04
Concurrency	2,970	42	157	53	23.12
User I/O	17,366	0	61	3	8.94
System I/O	29,980	0	7	0	0.98
Network	370,349	0	1	0	0.13
Commit	601	0	0	1	0.06
Other	106	46	0	1	0.01
Scheduler	48	0	0	1	0.01
Application	0		0		0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

s - second, ms - millisecond - 1000th of a second
Only events with Total Wait Time (s) >= .001 are shown
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
row cache lock	87	1	130	1489	0.19	19.13
db file sequential read	17,213	0	59	3	36.86	8.76
library cache lock	2	0	21	10297	0.00	3.04
control file sequential read	29,980	0	7	0	64.20	0.98
library cache: mutex X	1,235	100	5	4	2.64	0.67
latch: shared pool	1,593	0	1	1	3.41	0.19
db file scattered read	136	0	1	8	0.29	0.16
SQL*Net message to client	370,349	0	1	0	793.04	0.13
log file sync	601	0	0	1	1.29	0.06
latch: row cache objects	32	0	0	11	0.07	0.05
resmgr:internal state change	3	67	0	68	0.01	0.03
direct path write	1	0	0	103	0.00	0.02
cursor: pin S	49	100	0	1	0.10	0.01
resmgr:cpu quantum	48	0	0	1	0.10	0.01
direct path write temp	16	0	0	2	0.03	0.00
latch: session allocation	38	0	0	0	0.08	0.00
latch free	17	0	0	0	0.04	0.00
latch: cache buffers chains	14	0	0	0	0.03	0.00
SQL*Net message from client	370,329	0	37,417	101	793.00
jobq slave wait	752	99	2,238	2976	1.61
auto-sqltune: wait graph update	2	100	10	5000	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)
Only events with Total Wait Time (s) >= .001 are shown
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
library cache lock	1	0	4	4312	0.00	17.22
os thread startup	84	0	4	42	0.18	13.98
log file parallel write	3,067	0	2	1	6.57	6.35
control file sequential read	4,545	0	1	0	9.73	4.76
control file parallel write	1,317	0	1	1	2.82	4.01
db file parallel write	2,187	0	1	0	4.68	2.21
SQL*Net break/reset to client	3,372	0	0	0	7.22	1.17
latch: shared pool	20	0	0	11	0.04	0.86
db file sequential read	12	0	0	6	0.03	0.29
SQL*Net message to client	9,268	0	0	0	19.85	0.09
latch free	1	0	0	13	0.00	0.05
library cache: mutex X	13,563	100	0	0	29.04	0.05
LGWR wait for redo copy	46	0	0	0	0.10	0.01
log file sync	1	0	0	2	0.00	0.01
direct path write	5	0	0	0	0.01	0.01
rdbms ipc message	17,047	82	53,818	3157	36.50
DIAG idle wait	7,164	100	7,165	1000	15.34
fbar timer	12	100	3,600	300008	0.03
Space Manager: slave idle wait	720	99	3,586	4981	1.54
Streams AQ: qmn coordinator idle wait	256	50	3,585	14002	0.55
Streams AQ: qmn slave idle wait	130	0	3,585	27574	0.28
pmon timer	1,253	95	3,582	2859	2.68
shared server idle wait	119	100	3,570	30003	0.25
dispatcher timer	59	100	3,540	60005	0.13
smon timer	11	100	3,300	300007	0.02
JOX Jit Process Sleep	12	92	89	7418	0.03
SQL*Net message from client	9,268	0	6	1	19.85
class slave wait	9	0	0	0	0.02

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
% of Waits: value of .0 indicates value was <.05%. Value of null is truly 0
% of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
Ordered by Event (idle events last)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
LGWR wait for redo copy	46	100.0
SQL*Net break/reset to client	3372	99.3	.5	.2		.1
SQL*Net message to client	379K	100.0	.0	.0
control file parallel write	1318	91.1	3.7	4.5	.7
control file sequential read	34K	98.8	.6	.6	.1	.0
cursor: mutex X	4	100.0
cursor: pin S	49	71.4	2.0	18.4	8.2
db file parallel write	2187	94.4	4.9	.6				.0
db file scattered read	136	3.7	6.6		45.6	44.1
db file sequential read	17K	62.2	.3	.3	16.9	19.8	.3	.1
direct path write	6	83.3						16.7
direct path write temp	16	31.3	18.8	50.0
latch free	18	88.9	5.6			5.6
latch: cache buffer handles	1	100.0
latch: cache buffers chains	14	92.9	7.1
latch: enqueue hash chains	1	100.0
latch: row cache objects	32	40.6	18.8	6.3			34.4
latch: session allocation	38	100.0
latch: shared pool	1612	91.5	2.5	2.4	.6	1.2	1.5	.2
library cache lock	4								100.0
library cache: mutex X	14K	98.7	.2	.5	.2	.1	.1	.2
log file parallel write	3067	89.9	4.5	4.8	.8	.0		.0
log file sync	602	81.4	11.1	6.1	.8	.5
os thread startup	84				1.2		84.5	14.3
resmgr:cpu quantum	48	60.4	27.1	12.5
resmgr:internal state change	3	33.3						66.7
row cache lock	87	39.1	31.0	3.4	1.1				25.3
DIAG idle wait	7163							100.0
JOX Jit Process Sleep	12	8.3							91.7
SQL*Net message from client	379K	22.5	1.7	14.3	16.5	19.9	12.0	12.3	.7
Space Manager: slave idle wait	720	.3							99.7
Streams AQ: qmn coordinator idle wait	256	48.4	.4	1.2					50.0
Streams AQ: qmn slave idle wait	130	1.5							98.5
auto-sqltune: wait graph update	2								100.0
class slave wait	9	88.9	11.1
dispatcher timer	59								100.0
fbar timer	12								100.0
jobq slave wait	752							.9	99.1
pmon timer	1253	4.7							95.3
rdbms ipc message	17K	3.3	.3	.3	.4	.9	1.0	30.0	63.7
shared server idle wait	119								100.0
smon timer	11								100.0

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
SYS$USERS	358	119	16	3,432
ora11g	322	159	2	1,606
SYS$BACKGROUND	0	0	0	38
ora11gXDB	0	0	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 seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	15788	60	105	21	9213	0
ora11g	1578	1	2862	136	361130	1
SYS$BACKGROUND	17	0	13661	8	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
Total DB Time (s): 677
Captured SQL account for 31.8% of Total
Total DB Time (s): 677
Captured PL/SQL account for 1.1% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
46	1	13	3.56	6.83	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...
9	4	63,709	0.00	1.29	du3npcpzq82sp	SDU@sdu1 (TNS V1-V3)	select sSubscriberID, sSubscri...
8	2	1,687	0.00	1.18	59d21tvx4xn3q		update user$ set name=:2, pass...
8	8	12	0.65	1.15	59p216atzcyfh	amosperf@sdu1 (TNS V1-V3)	select sql_text from (select s...
8	8	12	0.63	1.11	3uhm3u5jynbak	amosperf@sdu1 (TNS V1-V3)	select sql_text from (select s...
8	7	12	0.63	1.11	byzbk6f5n4upz	amosperf@sdu1 (TNS V1-V3)	select sql_text from (select s...
7	2	1	6.53	0.96	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
6	0	3	2.04	0.90	bph1a3spdtg6g	SDU@sdu1 (TNS V1-V3)	select SUBSCRIBERID, RESOURCEN...
6	0	5	1.22	0.90	8wyymnrxrudgd	SDU@sdu1 (TNS V1-V3)	select SUBSCRIBERID, RESOURCEN...
6	0	2	3.05	0.90	2y7qjmt522cxk	SDU@sdu1 (TNS V1-V3)	select SUBSCRIBERID, RESOURCEN...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total is the CPU Time divided into the Total CPU Time times 100
Total CPU Time (s): 278
Captured SQL account for 19.7% of Total
Total CPU Time (s): 278
Captured PL/SQL account for 1.0% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
8	8	12	0.65	2.80	1.15	59p216atzcyfh	amosperf@sdu1 (TNS V1-V3)	select sql_text from (select s...
8	8	12	0.63	2.71	1.11	3uhm3u5jynbak	amosperf@sdu1 (TNS V1-V3)	select sql_text from (select s...
7	8	12	0.62	2.69	1.11	byzbk6f5n4upz	amosperf@sdu1 (TNS V1-V3)	select sql_text from (select s...
5	5	106	0.04	1.71	0.71	c0j6cx9kzjf7g	DBMS_SCHEDULER	SELECT EXTRACTVALUE(VALUE(T), ...
4	9	63,709	0.00	1.53	1.29	du3npcpzq82sp	SDU@sdu1 (TNS V1-V3)	select sSubscriberID, sSubscri...
3	3	3,272	0.00	1.01	0.43	43ruajmwv9fus		insert into histgrm$(obj#, int...
3	3	12	0.22	0.96	0.40	d98d5kh4u6ufx	amosperf@sdu1 (TNS V1-V3)	select o.sid, o.user_name, o...
2	3	1,347	0.00	0.89	0.38	4y1y43113gv8f		delete from histgrm$ where obj...
2	3	63,713	0.00	0.74	0.50	12kbqx41uwvdn	SDU@sdu1 (TNS V1-V3)	select sSubscriberID, sSubscri...
2	7	1	1.94	0.70	0.96	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...

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: 5,076,042
Captured SQL account for 33.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
828,650	63,709	13.01	16.32	4.25	8.72	du3npcpzq82sp	SDU@sdu1 (TNS V1-V3)	select sSubscriberID, sSubscri...
254,860	63,713	4.00	5.02	2.04	3.36	12kbqx41uwvdn	SDU@sdu1 (TNS V1-V3)	select sSubscriberID, sSubscri...
136,664	3,272	41.77	2.69	2.80	2.89	43ruajmwv9fus		insert into histgrm$(obj#, int...
121,930	1,586	76.88	2.40	0.41	0.46	cvhk2j2gymzhd	DBMS_SCHEDULER	SELECT SU.NAME, SO.NAME, A.S...
90,852	1,347	67.45	1.79	2.48	2.57	4y1y43113gv8f		delete from histgrm$ where obj...
67,651	22,326	3.03	1.33	0.96	1.23	7br6xgmpmhukc	SDU@sdu1 (TNS V1-V3)	Select sScreenNumber, sScreenT...
34,529	13	2,656.08	0.68	0.93	46.22	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...
16,807	1,573	10.68	0.33	0.11	0.38	d0xmnp08rhfbg		insert into sys.wri$_optstat_h...
14,480	402	36.02	0.29	0.33	0.80	63kf3an2j0pkc		insert into sys.wri$_optstat_h...
13,237	4,656	2.84	0.26	0.14	0.16	96g93hntrzjtr		select /+ rule / bucket_cnt,...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 17,891
Captured SQL account for 87.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
14,006	13	1,077.38	78.29	0.93	46.22	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...
732	12	61.00	4.09	0.28	0.37	0u3a2gth3r9vw	amosperf@sdu1 (TNS V1-V3)	select sum(bytes)/1024 from DB...
732	12	61.00	4.09	0.28	0.41	47fh8q7arykp9	amosperf@sdu1 (TNS V1-V3)	select tablespace_name , sum(...
48	402	0.12	0.27	0.33	0.80	63kf3an2j0pkc		insert into sys.wri$_optstat_h...
13	1,573	0.01	0.07	0.11	0.38	d0xmnp08rhfbg		insert into sys.wri$_optstat_h...
12	12	1.00	0.07	0.02	0.61	8xgd2r1h0kr34	DBMS_SCHEDULER	insert into wri$_adv_sqlt_plan...
8	2	4.00	0.04	0.00	0.06	dckagq5arxva5	SDU@sdu1 (TNS V1-V3)	delete from t_bme...
6	2	3.00	0.03	0.01	0.05	6s2jxg0nq736d	SDU@sdu1 (TNS V1-V3)	delete from F2...
5	11	0.45	0.03	0.01	0.08	6kqztxmbnwzht	SDU@sdu1 (TNS V1-V3)	update F1 ...
4	2	2.00	0.02	0.01	0.03	5ungsgg5wj7cd	TOTO@TOTO1 (TNS V1-V3)	delete from R...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 351,360
Captured SQL account for 54.0% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
63,713	63,717	1.00	12kbqx41uwvdn	TOTO@TOTO1 (TNS V1-V3)	select sSubscriberID, sSubscri...
63,709	63,718	1.00	du3npcpzq82sp	TOTO@TOTO1 (TNS V1-V3)	select sSubscriberID, sSubscri...
22,326	590	0.03	7br6xgmpmhukc	TOTO@TOTO1 (TNS V1-V3)	Select sScreenNumber, sScreenT...
4,656	3,759	0.81	96g93hntrzjtr		select /+ rule / bucket_cnt,...
3,566	3,566	1.00	a5ks9fhw2v9s1	TOTO@TOTO1 (TNS V1-V3)	select * from dual
3,272	22,239	6.80	43ruajmwv9fus		insert into histgrm$(obj#, int...
3,211	51,028	15.89	db78fxqxwxt7r		select /+ rule / bucket, en...
1,957	1,957	1.00	9tgj4g8y4rwy8		select type#, blocks, extents,...
1,687	0	0.00	3972rvxu3knn3	TOTO@TOTO1 (TNS V1-V3)	delete from sdo_geor_ddl__tabl...
1,687	1,687	1.00	59d21tvx4xn3q		update user$ set name=:2, pass...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 164,188
Captured SQL account for 12.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
3,566	3,566	2.17	a5ks9fhw2v9s1	TOTO@TOTO1 (TNS V1-V3)	select * from dual
1,957	1,957	1.19	9tgj4g8y4rwy8		select type#, blocks, extents,...
1,687	1,687	1.03	3972rvxu3knn3	TOTO@TOTO1 (TNS V1-V3)	delete from sdo_geor_ddl__tabl...
1,687	1,687	1.03	59d21tvx4xn3q		update user$ set name=:2, pass...
1,687	1,687	1.03	a6u3yjca29nqc	TOTO@TOTO1 (TNS V1-V3)	declare m_stmt varchar2(512...
1,056	1,056	0.64	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
1,056	1,056	0.64	459f3z9u4fb3u		select value$ from props$ wher...
895	895	0.55	520mkxqpf15q8	TOTO@TOTO1 (TNS V1-V3)	select 1 from dual
716	716	0.44	0khbp2znt4394	sqlplus@TOTO1 (TNS V1-V3)	select tablespace_name, statu...
716	716	0.44	6v3dub2363sa5	sqlplus@TOTO1 (TNS V1-V3)	select name, open_mode from v...

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
15,365,330	2	0.71	803u6vwz0ah1p		select OBJOID, CLSOID, RUNT...
3,289,400	10	0.15	bn4b3vjw2mj3u		SELECT OBJOID, CLSOID, DE...
2,274,577	11	0.11	6kqztxmbnwzht	TOTO@TOTO1 (TNS V1-V3)	update F1 ...
2,127,429	12	0.10	g278wv0zzpn5j		select unique objn from ((sele...
2,127,364	12	0.10	99xa2xfxq7xmc	amosperf@TOTO1 (TNS V1-V3)	select * from (select event, ...
2,099,700	5	0.10	7bdgxpmaqxx89	TOTO@TOTO1 (TNS V1-V3)	update F1 ...

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 Text
2,164	0	0v3dvmc22qnam	insert into sys.col_usage$ (ob...
302	10	1gfaj4z5hn1kf	delete from dependency$ where ...
29	769	7ng34ruy5awxq	select i.obj#, i.ts#, i.file#,...
29	769	7ng34ruy5awxq	select i.obj#, i.ts#, i.file#,...
24	733	1gu8t96d0bdmu	select t.ts#, t.file#, t.block...
22	1,957	9tgj4g8y4rwy8	select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0khbp2znt4394 select tablespace_name, status from dba_tablespaces

0u3a2gth3r9vw select sum(bytes)/1024 from DBA_FREE_SPACE

0v3dvmc22qnam insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)

0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

12kbqx41uwvdn select sSubscriberID, sSubscriberNumber, sMainType, sUserType, sUserSort , sUserState, sServiceActiveFlag, sActiveRoute, sActiveType, nSingleMain , sBarringFlag, sFeeType, sChargeAccount, sSameCallFlag from F1 WHERE sSubscriberID=:sSubscriberID

1gfaj4z5hn1kf delete from dependency$ where d_obj#=:1

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

2y7qjmt522cxk select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618960645348'

3972rvxu3knn3 delete from sdo_geor_ddl__table$$

3uhm3u5jynbak select sql_text from (select sql_text from v$sqlarea where disk_reads > 5000 * executions order by executions desc) where rownum<6

43ruajmwv9fus insert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue)values(:1, :2, :3, :4, :5, :6, :7)

459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'

47fh8q7arykp9 select tablespace_name , sum(bytes)/1024 bytes from dba_free_space group by tablespace_name

4y1y43113gv8f delete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3

520mkxqpf15q8 select 1 from dual

59d21tvx4xn3q update user$ set name=:2, password=:3, datats#=:4, tempts#=:5, type#=:6, defrole=:7, resource$=:8, ptime=DECODE(to_char(:9, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :9), exptime=DECODE(to_char(:10, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :10), ltime=DECODE(to_char(:11, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :11), astatus=:12, lcount=:13, defschclass=:14, spare1=:15, spare4=:16 where user#=:1

59p216atzcyfh select sql_text from (select sql_text from v$sqlarea order by loads desc) where rownum<6

5ungsgg5wj7cd delete from R_BIND_ASSOCIATEDNUM where SSUBSCRIBERID = :0

63kf3an2j0pkc insert into sys.wri$_optstat_histgrm_history (obj#, intcol#, savtime, bucket, endpoint, epvalue, colname) select hg.obj#, hg.intcol#, :3, hg.bucket, hg.endpoint, hg.epvalue, :4 from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2

6ajkhukk78nsr begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;

6kqztxmbnwzht update F1 set sSubscriberNumber = :0 where sSubscriberNumber = :1

6s2jxg0nq736d delete from F2la where 1=1 and subscriberID = :0

6v3dub2363sa5 select name, open_mode from v$database

7bdgxpmaqxx89 update F1 set sSubscriberid = :0 , sUserState = :1 , sActiveType = :2 , nSingleMain = :3 , sActiveRoute = :4 , SCHARGEACCOUNT = :5 where sSubscriberNumber = :6

7br6xgmpmhukc Select sScreenNumber, sScreenType, sScreenFlow from R_BWList_SubscriberBWList where nServiceID =:nServiceID and sSubscriberNumber=:sSubscriberNumber and sSubscriberNumType=:sSubscriberNumType and sScreenNumber=:sScreenNumber and sScreenNumberType=:sScreenNumberType and sScreenType=:sScreenType and (sScreenFlow=:sScreenFlow or sScreenFlow=0) and sSPID=:sSPID and sMatchType=0 and rownum =1

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#

803u6vwz0ah1p select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID

8szmwam7fysa3 insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))

8wyymnrxrudgd select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615375915431'

8xgd2r1h0kr34 insert into wri$_adv_sqlt_plans (statement_id, timestamp, operation, options, object_node, object_owner, object_name, object_instance, object_type, search_columns, id, parent_id, position, other, optimizer, cost, cardinality, bytes, other_tag, partition_start, partition_stop, partition_id, distribution, cpu_cost, io_cost, temp_space, access_predicates, filter_predicates, projection, time, qblock_name, object_alias, plan_id, depth, remarks, other_xml) 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, :28, :29, :30, :31, :32, :33, :34, :35, :36)

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

99xa2xfxq7xmc select * from (select event, count(*) from v$session_wait group by event order by count(*) desc) where rownum < 6

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

a5ks9fhw2v9s1 select * from dual

a6u3yjca29nqc declare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;

bn4b3vjw2mj3u SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1

bph1a3spdtg6g select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618965065765'

byzbk6f5n4upz select sql_text from (select sql_text from v$sqlarea where buffer_gets > 5000 * executions order by executions desc) where rownum<6

c0j6cx9kzjf7g SELECT EXTRACTVALUE(VALUE(T), '/select_list_item/pos') + 1 POS, EXTRACTVALUE(VALUE(T), '/select_list_item/value') RES, EXTRACTVALUE(VALUE(T), '/select_list_item/nonnulls') NONNULLS, EXTRACTVALUE(VALUE(T), '/select_list_item/ndv') NDV, EXTRACTVALUE(VALUE(T), '/select_list_item/split') SPLIT, EXTRACTVALUE(VALUE(T), '/select_list_item/rsize') RSIZE, EXTRACTVALUE(VALUE(T), '/select_list_item/rowcnt') ROWCNT, EXTRACT(VALUE(T), '/select_list_item/hash_val').GETCLOBVAL() HASHVAL FROM TABLE(XMLSEQUENCE(EXTRACT(:B1 , '/process_result/select_list_item'))) T

cvhk2j2gymzhd SELECT SU.NAME, SO.NAME, A.STATSTYPE#, C.INTCOL# FROM ASSOCIATION$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU, COLTYPE$ CT, OBJ$ TY WHERE O.OWNER#=U.USER# AND A.OBJ#=TY.OBJ# AND O.OBJ#=C.OBJ# AND C.INTCOL#=CT.INTCOL# AND O.OBJ#=CT.OBJ# AND CT.TOID=TY.OID$ AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.TYPE#=2 AND O.NAME=:B3 AND U.NAME=:B2 AND C.NAME=:B1

d0xmnp08rhfbg insert into sys.wri$_optstat_histhead_history (obj#, intcol#, savtime, flags, null_cnt, minimum, maximum, distcnt, density, lowval, hival, avgcln, sample_distcnt, sample_size, timestamp#, colname) select h.obj#, h.intcol#, :3, bitand(h.spare2, 7) + 8 + decode(h.cache_cnt, 0, 0, 64), h.null_cnt, h.minimum, h.maximum, h.distcnt, h.density, h.lowval, h.hival, h.avgcln, h.spare1, h.sample_size, h.timestamp#, :4 from sys.hist_head$ h where h.obj# = :1 and h.intcol# = :2

d98d5kh4u6ufx select o.sid, o.user_name, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where o.sid=s.sid group by o.sid, o.user_name, osuser, machine order by o.user_name desc

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

dckagq5arxva5 delete from t_bme_subscriber where resourceNumber = :0

du3npcpzq82sp select sSubscriberID, sSubscriberNumber, sAssociatedNum1, sAssociatedNum2, sAssociatedNum3, sAssociatedNum4, sAssociatedNum5, sAssociatedNum6, sAssociatedNum7, sAssociatedNum8, sAssociatedNum9, sAssociatedNum10, sAssociatedNumTypeList, sActiveFlagList from R_Bind_AssociatedNum WHERE sAssociatedNum1 =:sAssociatedNum1 OR sAssociatedNum2 =:sAssociatedNum2 OR sAssociatedNum3 =:sAssociatedNum3 OR sAssociatedNum4 =:sAssociatedNum4 OR sAssociatedNum5 =:sAssociatedNum5 OR sAssociatedNum6 =:sAssociatedNum6 OR sAssociatedNum7 =:sAssociatedNum7 OR sAssociatedNum8 =:sAssociatedNum8 OR sAssociatedNum9 =:sAssociatedNum9 OR sAssociatedNum10 =:sAssociatedNum10

g278wv0zzpn5j select unique objn from ((select objn from SYS_MFBA_STAGE_RID) union all (select d.objn "OBJN" from SYS_FBA_DL d, SYS_MFBA_TRACKED_TXN t where (d.usn=t.usn) and (d.slot = t.slot)))

SQL Id	SQL Text
0khbp2znt4394	select tablespace_name, status from dba_tablespaces
0u3a2gth3r9vw	select sum(bytes)/1024 from DBA_FREE_SPACE
0v3dvmc22qnam	insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
12kbqx41uwvdn	select sSubscriberID, sSubscriberNumber, sMainType, sUserType, sUserSort , sUserState, sServiceActiveFlag, sActiveRoute, sActiveType, nSingleMain , sBarringFlag, sFeeType, sChargeAccount, sSameCallFlag from F1 WHERE sSubscriberID=:sSubscriberID
1gfaj4z5hn1kf	delete from dependency$ where d_obj#=:1
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
2y7qjmt522cxk	select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618960645348'
3972rvxu3knn3	delete from sdo_geor_ddl__table$$
3uhm3u5jynbak	select sql_text from (select sql_text from v$sqlarea where disk_reads > 5000 * executions order by executions desc) where rownum<6
43ruajmwv9fus	insert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue)values(:1, :2, :3, :4, :5, :6, :7)
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
47fh8q7arykp9	select tablespace_name , sum(bytes)/1024 bytes from dba_free_space group by tablespace_name
4y1y43113gv8f	delete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3
520mkxqpf15q8	select 1 from dual
59d21tvx4xn3q	update user$ set name=:2, password=:3, datats#=:4, tempts#=:5, type#=:6, defrole=:7, resource$=:8, ptime=DECODE(to_char(:9, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :9), exptime=DECODE(to_char(:10, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :10), ltime=DECODE(to_char(:11, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :11), astatus=:12, lcount=:13, defschclass=:14, spare1=:15, spare4=:16 where user#=:1
59p216atzcyfh	select sql_text from (select sql_text from v$sqlarea order by loads desc) where rownum<6
5ungsgg5wj7cd	delete from R_BIND_ASSOCIATEDNUM where SSUBSCRIBERID = :0
63kf3an2j0pkc	insert into sys.wri$_optstat_histgrm_history (obj#, intcol#, savtime, bucket, endpoint, epvalue, colname) select hg.obj#, hg.intcol#, :3, hg.bucket, hg.endpoint, hg.epvalue, :4 from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6kqztxmbnwzht	update F1 set sSubscriberNumber = :0 where sSubscriberNumber = :1
6s2jxg0nq736d	delete from F2la where 1=1 and subscriberID = :0
6v3dub2363sa5	select name, open_mode from v$database
7bdgxpmaqxx89	update F1 set sSubscriberid = :0 , sUserState = :1 , sActiveType = :2 , nSingleMain = :3 , sActiveRoute = :4 , SCHARGEACCOUNT = :5 where sSubscriberNumber = :6
7br6xgmpmhukc	Select sScreenNumber, sScreenType, sScreenFlow from R_BWList_SubscriberBWList where nServiceID =:nServiceID and sSubscriberNumber=:sSubscriberNumber and sSubscriberNumType=:sSubscriberNumType and sScreenNumber=:sScreenNumber and sScreenNumberType=:sScreenNumberType and sScreenType=:sScreenType and (sScreenFlow=:sScreenFlow or sScreenFlow=0) and sSPID=:sSPID and sMatchType=0 and rownum =1
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#
803u6vwz0ah1p	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
8szmwam7fysa3	insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
8wyymnrxrudgd	select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615375915431'
8xgd2r1h0kr34	insert into wri$_adv_sqlt_plans (statement_id, timestamp, operation, options, object_node, object_owner, object_name, object_instance, object_type, search_columns, id, parent_id, position, other, optimizer, cost, cardinality, bytes, other_tag, partition_start, partition_stop, partition_id, distribution, cpu_cost, io_cost, temp_space, access_predicates, filter_predicates, projection, time, qblock_name, object_alias, plan_id, depth, remarks, other_xml) 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, :28, :29, :30, :31, :32, :33, :34, :35, :36)
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
99xa2xfxq7xmc	select * from (select event, count() from v$session_wait group by event order by count() desc) where rownum < 6
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
a5ks9fhw2v9s1	select * from dual
a6u3yjca29nqc	declare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;
bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
bph1a3spdtg6g	select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618965065765'
byzbk6f5n4upz	select sql_text from (select sql_text from v$sqlarea where buffer_gets > 5000 * executions order by executions desc) where rownum<6
c0j6cx9kzjf7g	SELECT EXTRACTVALUE(VALUE(T), '/select_list_item/pos') + 1 POS, EXTRACTVALUE(VALUE(T), '/select_list_item/value') RES, EXTRACTVALUE(VALUE(T), '/select_list_item/nonnulls') NONNULLS, EXTRACTVALUE(VALUE(T), '/select_list_item/ndv') NDV, EXTRACTVALUE(VALUE(T), '/select_list_item/split') SPLIT, EXTRACTVALUE(VALUE(T), '/select_list_item/rsize') RSIZE, EXTRACTVALUE(VALUE(T), '/select_list_item/rowcnt') ROWCNT, EXTRACT(VALUE(T), '/select_list_item/hash_val').GETCLOBVAL() HASHVAL FROM TABLE(XMLSEQUENCE(EXTRACT(:B1 , '/process_result/select_list_item'))) T
cvhk2j2gymzhd	SELECT SU.NAME, SO.NAME, A.STATSTYPE#, C.INTCOL# FROM ASSOCIATION$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU, COLTYPE$ CT, OBJ$ TY WHERE O.OWNER#=U.USER# AND A.OBJ#=TY.OBJ# AND O.OBJ#=C.OBJ# AND C.INTCOL#=CT.INTCOL# AND O.OBJ#=CT.OBJ# AND CT.TOID=TY.OID$ AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.TYPE#=2 AND O.NAME=:B3 AND U.NAME=:B2 AND C.NAME=:B1
d0xmnp08rhfbg	insert into sys.wri$_optstat_histhead_history (obj#, intcol#, savtime, flags, null_cnt, minimum, maximum, distcnt, density, lowval, hival, avgcln, sample_distcnt, sample_size, timestamp#, colname) select h.obj#, h.intcol#, :3, bitand(h.spare2, 7) + 8 + decode(h.cache_cnt, 0, 0, 64), h.null_cnt, h.minimum, h.maximum, h.distcnt, h.density, h.lowval, h.hival, h.avgcln, h.spare1, h.sample_size, h.timestamp#, :4 from sys.hist_head$ h where h.obj# = :1 and h.intcol# = :2
d98d5kh4u6ufx	select o.sid, o.user_name, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where o.sid=s.sid group by o.sid, o.user_name, osuser, machine order by o.user_name desc
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dckagq5arxva5	delete from t_bme_subscriber where resourceNumber = :0
du3npcpzq82sp	select sSubscriberID, sSubscriberNumber, sAssociatedNum1, sAssociatedNum2, sAssociatedNum3, sAssociatedNum4, sAssociatedNum5, sAssociatedNum6, sAssociatedNum7, sAssociatedNum8, sAssociatedNum9, sAssociatedNum10, sAssociatedNumTypeList, sActiveFlagList from R_Bind_AssociatedNum WHERE sAssociatedNum1 =:sAssociatedNum1 OR sAssociatedNum2 =:sAssociatedNum2 OR sAssociatedNum3 =:sAssociatedNum3 OR sAssociatedNum4 =:sAssociatedNum4 OR sAssociatedNum5 =:sAssociatedNum5 OR sAssociatedNum6 =:sAssociatedNum6 OR sAssociatedNum7 =:sAssociatedNum7 OR sAssociatedNum8 =:sAssociatedNum8 OR sAssociatedNum9 =:sAssociatedNum9 OR sAssociatedNum10 =:sAssociatedNum10
g278wv0zzpn5j	select unique objn from ((select objn from SYS_MFBA_STAGE_RID) union all (select d.objn "OBJN" from SYS_FBA_DL d, SYS_MFBA_TRACKED_TXN t where (d.usn=t.usn) and (d.slot = t.slot)))

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
Batched IO (bound) vector count	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	64	0.02	0.14
CCursor + sql area evicted	1,535	0.43	3.29
CPU used by this session	15,202	4.22	32.55
CPU used when call started	11,228	3.12	24.04
CR blocks created	22	0.01	0.05
Cached Commit SCN referenced	1,528	0.42	3.27
Commit SCN cached	11	0.00	0.02
DB time	278,229	77.24	595.78
DBWR checkpoint buffers written	5,514	1.53	11.81
DBWR checkpoints	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	114	0.03	0.24
DBWR undo block writes	2,234	0.62	4.78
Effective IO time	0	0.00	0.00
HSC Heap Segment Block Changes	52,971	14.71	113.43
Heap Segment Array Inserts	640	0.18	1.37
Heap Segment Array Updates	5	0.00	0.01
IMU CR rollbacks	9	0.00	0.02
IMU Flushes	71	0.02	0.15
IMU Redo allocation size	164,856	45.77	353.01
IMU commits	363	0.10	0.78
IMU contention	7	0.00	0.01
IMU ktichg flush	7	0.00	0.01
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	1,098,360	304.93	2,351.95
IMU- failed to get a private strand	0	0.00	0.00
LOB table id lookup cache misses	4	0.00	0.01
Misses for writing mapping	0	0.00	0.00
Number of read IOs issued	0	0.00	0.00
RowCR - row contention	0	0.00	0.00
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	370,354	102.82	793.05
active txn count during cleanout	549	0.15	1.18
application wait time	0	0.00	0.00
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	13,951	3.87	29.87
branch node splits	0	0.00	0.00
buffer is not pinned count	1,538,201	427.04	3,293.79
buffer is pinned count	301,379	83.67	645.35
bytes received via SQL*Net from client	90,824,231	25,215.06	194,484.43
bytes sent via SQL*Net to client	244,248,108	67,809.33	523,015.22
calls to get snapshot scn: kcmgss	1,369,687	380.26	2,932.95
calls to kcmgas	25,746	7.15	55.13
calls to kcmgcs	36,862	10.23	78.93
cell physical IO interconnect bytes	930,956,800	258,456.67	1,993,483.51
change write time	518	0.14	1.11
cleanout - number of ktugct calls	609	0.17	1.30
cleanouts and rollbacks - consistent read gets	13	0.00	0.03
cleanouts only - consistent read gets	80	0.02	0.17
cluster key scan block gets	108,246	30.05	231.79
cluster key scans	98,870	27.45	211.71
commit batch/immediate performed	13	0.00	0.03
commit batch/immediate requested	13	0.00	0.03
commit cleanout failures: block lost	61	0.02	0.13
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	100	0.03	0.21
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	9,640	2.68	20.64
commit cleanouts successfully completed	9,479	2.63	20.30
commit immediate performed	13	0.00	0.03
commit immediate requested	13	0.00	0.03
commit txn count during cleanout	587	0.16	1.26
concurrency wait time	16,453	4.57	35.23
consistent changes	754,257	209.40	1,615.11
consistent gets	2,693,625	747.82	5,767.93
consistent gets - examination	1,087,174	301.83	2,328.00
consistent gets direct	6	0.00	0.01
consistent gets from cache	2,693,619	747.82	5,767.92
consistent gets from cache (fastpath)	966,827	268.42	2,070.29
current blocks converted for CR	0	0.00	0.00
cursor authentications	18,309	5.08	39.21
data blocks consistent reads - undo records applied	30	0.01	0.06
db block changes	985,971	273.73	2,111.29
db block gets	2,382,417	661.42	5,101.54
db block gets direct	342	0.09	0.73
db block gets from cache	2,382,075	661.32	5,100.80
db block gets from cache (fastpath)	59,845	16.61	128.15
deferred (CURRENT) block cleanout applications	4,822	1.34	10.33
dirty buffers inspected	2	0.00	0.00
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	727	0.20	1.56
enqueue deadlocks	0	0.00	0.00
enqueue releases	113,569	31.53	243.19
enqueue requests	113,533	31.52	243.11
enqueue timeouts	0	0.00	0.00
enqueue waits	0	0.00	0.00
exchange deadlocks	0	0.00	0.00
execute count	351,360	97.55	752.38
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	21,431	5.95	45.89
free buffer requested	185,718	51.56	397.68
global undo segment hints helped	0	0.00	0.00
heap block compress	370	0.10	0.79
hot buffers moved to head of LRU	36,956	10.26	79.13
immediate (CR) block cleanout applications	93	0.03	0.20
immediate (CURRENT) block cleanout applications	3,630	1.01	7.77
index crx upgrade (positioned)	13	0.00	0.03
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	718	0.20	1.54
index fetch by key	422,019	117.16	903.68
index scans kdiixs1	743,359	206.37	1,591.78
java call heap collected bytes	0	0.00	0.00
java call heap collected count	0	0.00	0.00
java call heap gc count	0	0.00	0.00
java call heap live object count	0	0.00	0.00
java call heap live object count max	0	0.00	0.00
java call heap live size	0	0.00	0.00
java call heap live size max	0	0.00	0.00
java call heap object count	0	0.00	0.00
java call heap object count max	0	0.00	0.00
java call heap total size	0	0.00	0.00
java call heap total size max	0	0.00	0.00
java call heap used size	0	0.00	0.00
java call heap used size max	0	0.00	0.00
leaf node 90-10 splits	80	0.02	0.17
leaf node splits	280	0.08	0.60
lob reads	110,583	30.70	236.79
lob writes	251,872	69.93	539.34
lob writes unaligned	251,868	69.92	539.33
local undo segment hints helped	0	0.00	0.00
logons cumulative	2,840	0.79	6.08
messages received	5,347	1.48	11.45
messages sent	5,347	1.48	11.45
min active SCN optimization applied to CR	23	0.01	0.05
no work - consistent read gets	548,066	152.16	1,173.59
opened cursors cumulative	191,216	53.09	409.46
parse count (describe)	26	0.01	0.06
parse count (failures)	102	0.03	0.22
parse count (hard)	63,919	17.75	136.87
parse count (total)	164,188	45.58	351.58
parse time cpu	4,864	1.35	10.42
parse time elapsed	22,708	6.30	48.63
physical IO disk bytes	930,956,800	258,456.67	1,993,483.51
physical read IO requests	17,355	4.82	37.16
physical read bytes	146,563,072	40,689.54	313,839.55
physical read total IO requests	51,886	14.40	111.10
physical read total bytes	712,269,824	197,743.75	1,525,203.05
physical read total multi block requests	12	0.00	0.03
physical reads	17,891	4.97	38.31
physical reads cache	17,885	4.97	38.30
physical reads cache prefetch	536	0.15	1.15
physical reads direct	6	0.00	0.01
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	2,327	0.65	4.98
physical write bytes	47,988,736	13,322.86	102,759.61
physical write total IO requests	13,315	3.70	28.51
physical write total bytes	218,686,976	60,712.92	468,280.46
physical write total multi block requests	225	0.06	0.48
physical writes	5,858	1.63	12.54
physical writes direct	342	0.09	0.73
physical writes direct (lob)	8	0.00	0.02
physical writes direct temporary tablespace	330	0.09	0.71
physical writes from cache	5,516	1.53	11.81
physical writes non checkpoint	2,636	0.73	5.64
pinned buffers inspected	12	0.00	0.03
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	1,340	0.37	2.87
recursive calls	919,332	255.23	1,968.59
recursive cpu usage	9,552	2.65	20.45
redo blocks checksummed by FG (exclusive)	16,755	4.65	35.88
redo blocks written	80,531	22.36	172.44
redo buffer allocation retries	0	0.00	0.00
redo entries	118,118	32.79	252.93
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	2,073	0.58	4.44
redo size	38,400,212	10,660.85	82,227.43
redo size for direct writes	98,736	27.41	211.43
redo subscn max counts	3,387	0.94	7.25
redo synch time	48	0.01	0.10
redo synch writes	1,810	0.50	3.88
redo wastage	1,145,000	317.88	2,451.82
redo write time	203	0.06	0.43
redo writer latching time	1	0.00	0.00
redo writes	3,067	0.85	6.57
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	9	0.00	0.02
rows fetched via callback	124,618	34.60	266.85
session connect time	0	0.00	0.00
session cursor cache hits	99,847	27.72	213.81
session logical reads	5,076,042	1,409.24	10,869.47
shared hash latch upgrades - no wait	578,200	160.52	1,238.12
shared hash latch upgrades - wait	350	0.10	0.75
sorts (memory)	13,427	3.73	28.75
sorts (rows)	4,758,542	1,321.09	10,189.60
space was found by tune down	0	0.00	0.00
sql area evicted	60,393	16.77	129.32
sql area purged	139	0.04	0.30
steps of tune down ret. in space pressure	0	0.00	0.00
summed dirty queue length	2	0.00	0.00
switch current to new buffer	3,388	0.94	7.25
table fetch by rowid	333,887	92.70	714.96
table fetch continued row	746	0.21	1.60
table scan blocks gotten	63,269	17.57	135.48
table scan rows gotten	3,194,543	886.88	6,840.56
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (short tables)	12,343	3.43	26.43
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	13	0.00	0.03
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
tune down retentions in space pressure	0	0.00	0.00
undo change vector size	14,457,824	4,013.85	30,958.94
user I/O wait time	6,062	1.68	12.98
user calls	516,023	143.26	1,104.97
user commits	459	0.13	0.98
user rollbacks	8	0.00	0.02
workarea executions - optimal	9,332	2.59	19.98
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session uga memory	194,389,624,923,608	194,441,276,873,176
opened cursors current	505	448
logons current	73	70
session uga memory max	4,185,263,809,984	4,186,165,263,440
session pga memory	101,195,064,272	101,185,427,904
session pga memory max	130,523,079,632	130,552,830,400
session cursor cache count	41,596,456	41,605,301

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)	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
TOTO_USER_DAT	7,727	2	4.02	1.00	202
TOTO_USER_IDX	6,379	2	2.35	1.00	67
SYSAUX	3,216	1	4.51	1.07	1,144
SYSTEM	18	0	8.89	1.00	538
UNDOTBS1	0	0	0.00	0.00	357
TEMP	15	0	2.00	22.00	19

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 Buf Wt(ms)
TOTO_USER_DAT	/dev/vx/rdsk/vgphydb/lvdata	7,727	2	4.02	1.00	202	0.00
TOTO_USER_IDX	/dev/vx/rdsk/vgphydb/lvindex	6,379	2	2.35	1.00	67	0.00
SYSAUX	/dev/vx/rdsk/vgora/lvsysaux	3,216	1	4.51	1.07	1,144	0.00
SYSTEM	/dev/vx/rdsk/vgora/lvsystem	18	0	8.89	1.00	538	0.00
TEMP	/dev/vx/rdsk/vgora/lvtemp	15	0	2.00	22.00	19
UNDOTBS1	/dev/vx/rdsk/vgora/lvundo	0	0			357	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	260,172	100	5,075,381	17,885	5,516	0	0	0

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	11	483	3469	6235	9216000	6235
E	0	10	271	1437	2860	9216000	2860

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	208	0.10	25,623	194.65	3,247,497,161
D	416	0.20	51,246	117.14	1,954,333,378
D	624	0.30	76,869	65.40	1,091,022,150
D	832	0.39	102,492	31.32	522,596,897
D	1,040	0.49	128,115	12.96	216,142,454
D	1,248	0.59	153,738	6.05	101,009,914
D	1,456	0.69	179,361	3.28	54,761,828
D	1,664	0.79	204,984	1.94	32,309,928
D	1,872	0.89	230,607	1.27	21,265,160
D	2,080	0.98	256,230	1.02	16,992,582
D	2,112	1.00	260,172	1.00	16,683,391
D	2,288	1.08	281,853	0.90	15,011,374
D	2,496	1.18	307,476	0.83	13,814,475
D	2,704	1.28	333,099	0.78	12,995,029
D	2,912	1.38	358,722	0.74	12,299,166
D	3,120	1.48	384,345	0.70	11,725,175
D	3,328	1.58	409,968	0.67	11,216,026
D	3,536	1.67	435,591	0.65	10,762,633
D	3,744	1.77	461,214	0.62	10,386,321
D	3,952	1.87	486,837	0.60	10,034,047
D	4,160	1.97	512,460	0.58	9,722,979

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	519	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

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	8,765	8,765
64K	128K	74	74
128K	256K	40	40
256K	512K	44	44
512K	1024K	199	199
1M	2M	195	195
2M	4M	2	2
4M	8M	10	10
16M	32M	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 %	Estd Time
350	0.13	1,231,167.91	100.00	184,877,226
700	0.25	1,231,167.91	100.00	184,877,226
1,400	0.50	1,231,167.91	100.00	184,877,226
2,100	0.75	1,231,167.91	100.00	184,877,226
2,800	1.00	1,231,167.91	100.00	184,877,226
3,360	1.20	1,231,167.91	100.00	184,877,226
3,920	1.40	1,231,167.91	100.00	184,877,226
4,480	1.60	1,231,167.91	100.00	184,877,226
5,040	1.80	1,231,167.91	100.00	184,877,226
5,600	2.00	1,231,167.91	100.00	184,877,226
8,400	3.00	1,231,167.91	100.00	184,877,226
11,200	4.00	1,231,167.91	100.00	184,877,226
16,800	6.00	1,231,167.91	100.00	184,877,226
22,400	8.00	1,231,167.91	100.00	184,877,226

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
400	0.19	209	37,784	16,935,572	0.98	1,251,743	1.34	292,672
608	0.29	417	47,741	17,050,266	0.99	1,137,049	1.22	304,725
816	0.40	625	59,921	17,106,351	0.99	1,080,964	1.16	310,662
1,024	0.50	833	72,045	17,142,947	0.99	1,044,368	1.12	314,354
1,232	0.60	1,041	84,792	17,172,002	1.00	1,015,313	1.09	317,405
1,440	0.70	1,249	96,532	17,195,693	1.00	991,622	1.06	319,911
1,648	0.80	1,457	109,221	17,216,198	1.00	971,117	1.04	322,095
1,856	0.90	1,665	121,083	17,234,715	1.00	952,600	1.02	324,068
2,064	1.00	1,872	133,980	17,251,610	1.00	935,705	1.00	325,889
2,272	1.10	2,080	145,949	17,266,952	1.00	920,363	0.98	327,556
2,480	1.20	2,288	158,314	17,280,925	1.00	906,390	0.97	329,093
2,688	1.30	2,496	170,741	17,293,869	1.00	893,446	0.95	330,537
2,896	1.40	2,704	182,957	17,306,025	1.00	881,290	0.94	331,901
3,104	1.50	2,912	195,515	17,317,354	1.00	869,961	0.93	333,185
3,312	1.60	3,120	207,955	17,328,018	1.00	859,297	0.92	334,402
3,520	1.71	3,328	220,610	17,338,134	1.01	849,181	0.91	335,562
3,728	1.81	3,536	232,982	17,347,734	1.01	839,581	0.90	336,668
3,936	1.91	3,744	246,162	17,357,543	1.01	829,772	0.89	337,720
4,144	2.01	4,013	261,789	17,368,473	1.01	818,842	0.88	338,930

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,950	0.38	7,070,555	1,533,263,693
2,600	0.50	2,471,942	169,573,323
3,250	0.63	1,885,815	25,348,744
3,900	0.75	1,775,895	16,683,391
4,550	0.88	1,712,178	16,683,391
5,200	1.00	1,667,977	16,683,391
5,850	1.13	1,632,449	13,088,120
6,500	1.25	1,602,759	13,088,120
7,150	1.38	1,568,232	13,331,698
7,800	1.50	1,557,724	10,195,220
8,450	1.63	1,553,053	8,798,820
9,100	1.75	1,549,884	7,872,892
9,750	1.88	1,549,050	7,627,646
10,400	2.00	1,549,050	7,627,646

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	2	49	4,302	1.00	935,705	1.00	35,138
32	2.00	9	177	4,302	1.00	935,705	1.00	128,780

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

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
2	2.14	4,256	1,190	5	61111.9/63949.9	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
11-Mar 22:53	17	307	1,185	2	63,935	0/0	0/0/0/0/0/0
11-Mar 22:43	15	351	585	1	63,939	0/0	0/0/0/0/0/0
11-Mar 22:33	13	306	1,187	1	63,934	0/0	0/0/0/0/0/0
11-Mar 22:23	28	584	586	1	63,914	0/0	0/0/0/0/0/0
11-Mar 22:13	3	311	1,190	1	63,950	0/0	0/0/0/0/0/0
11-Mar 22:03	2,061	2,397	590	5	61,112	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
Mutex Sleep Summary
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,386	0.00		0	0
ASM map operation hash table	1	0.00		0	0
AWR Alerted Metric Element list	25,661	0.00		0	0
Change Notification Hash table latch	1,210	0.00		0	0
Consistent RBA	3,067	0.00		0	0
DML lock allocation	1,726,442	0.00	0.00	0	0
Event Group Locks	2,830	0.00		0	0
FAL request queue	96	0.00		0	0
FOB s.o list latch	14,721	0.00		0	0
File State Object Pool Parent Latch	1	0.00		0	0
IPC stats buffer allocation latch	13	0.00		0	0
In memory undo latch	7,773	0.00		0	2,894	0.00
JOX JIT latch	1	0.00		0	1	0.00
JOX SGA heap latch	895	0.00		0	0
JS Sh mem access	7	0.00		0	0
JS mem alloc latch	11	0.00		0	0
JS queue access latch	12	0.00		0	0
JS queue state obj latch	25,990	0.00		0	0
JS slv state obj latch	233	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KFR redo allocation latch	1	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	13	0.00		0	0
KJCT flow control latch	13	0.00		0	0
KMG MMAN ready and startup request latch	1,194	0.00		0	0
KTF sga latch	48	0.00		0	929	0.00
Locator state objects pool parent latch	1	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	13	0.00		0	1,194	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	1,381,462	0.02	0.00	0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	9,013	0.00		0	0
OS process allocation	7,191	0.00		0	0
OS process: request allocation	5,661	0.00		0	0
PL/SQL warning settings	4,747	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	4,087	0.00		0	0
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	121	0.00		0	1,193	0.00
SQL memory manager workarea list latch	82,800	0.00		0	0
Shared B-Tree	129	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	13	0.00		0	0
Token Manager	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	3,381	0.00		0	0
active service list	17,302	0.02	0.00	0	2,699,579	0.00
archive control	1,013	0.00		0	0
archive process latch	1,385	0.00		0	0
begin backup scn array	9	0.00		0	0
buffer pool	13	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	777,812	0.09	0.00	0	0
cache buffers chains	11,164,843	0.03	0.00	0	199,934	0.03
cache buffers lru chain	18,349	0.02	0.00	0	464,606	0.04
cache table scan latch	136	0.00		0	136	0.00
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	5,676	0.00		0	0
channel operations parent latch	27,823	0.00		0	0
checkpoint queue latch	70,335	0.00		0	5,228	0.00
client/application info	8,159	0.00		0	0
commit callback allocation	1	0.00		0	0
compile environment latch	2,841	0.00		0	0
corrupted undo seg lock	13	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	59	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	59	0.00		0	0
dictionary lookup	13	0.00		0	0
dml lock allocation	59	0.00		0	0
done queue latch	13	0.00		0	0
dummy allocation	5,686	0.00		0	0
enqueue hash chains	227,834	0.02	0.02	0	0
enqueues	203,567	0.07	0.00	0	0
fifth spare latch	13	0.00		0	0
file cache latch	170	0.00		0	0
flashback archiver latch	12	0.00		0	0
flashback copy	1	0.00		0	0
gc element	1	0.00		0	0
gcs commit scn state	13	0.00		0	0
gcs partitioned table hash	13	0.00		0	0
gcs pcm hashed value bucket hash	13	0.00		0	0
gcs resource freelist	13	0.00		0	0
gcs resource hash	13	0.00		0	0
gcs resource scan list	13	0.00		0	0
gcs shadows freelist	13	0.00		0	0
ges domain table	13	0.00		0	0
ges enqueue table freelist	13	0.00		0	0
ges group table	13	0.00		0	0
ges process hash list	13	0.00		0	0
ges process parent latch	13	0.00		0	0
ges resource hash list	13	0.00		0	0
ges resource scan list	13	0.00		0	0
ges resource table freelist	13	0.00		0	0
ges value block free list	13	0.00		0	0
global KZLD latch for mem in SGA	1,713	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule operation	13	0.00		0	0
hash table column usage latch	486	0.00		0	422,996	0.05
hash table modification latch	81	0.00		0	0
heartbeat check	13	0.00		0	0
internal temp table object number allocation latch	3	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	1	0.00		0	18	0.00
job_queue_processes free list latch	7	0.00		0	0
job_queue_processes parameter latch	857	0.00		0	0
k2q lock allocation	1	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kks stats	382,755	0.07	0.06	0	0
kokc descriptor allocation latch	30	0.00		0	0
ksfv messages	13	0.00		0	0
kss move lock	45	0.00		0	0
ksuosstats global area	242	0.00		0	0
ksv allocation latch	123	0.00		0	0
ksv class latch	77	0.00		0	0
ksv msg queue latch	13	0.00		0	0
ksz_so allocation latch	5,661	0.00		0	0
ktm global data	17	0.00		0	0
kwqbsn:qsga	128	0.00		0	0
lgwr LWN SCN	3,072	0.03	0.00	0	0
list of block allocation	3,590	0.00		0	0
loader state object freelist	56	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	13	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	1	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	140	0.00		0	126	0.00
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	13	0.00		0	0
messages	44,623	0.00	0.00	0	0
mostly latch-free SCN	3,078	0.13	0.00	0	0
msg queue latch	13	0.00		0	0
multiblock read objects	1,854	0.00		0	0
name-service namespace bucket	13	0.00		0	0
ncodef allocation latch	59	0.00		0	0
object queue header heap	198	0.00		0	158	0.00
object queue header operation	358,253	0.00	0.00	0	0
object stats modification	157	0.00		0	0
parallel query alloc buffer	461	0.00		0	0
parallel query stats	1	0.00		0	0
parameter list	7,287	0.00		0	0
parameter table management	5,687	0.00		0	0
peshm	1	0.00		0	0
pesom_free_list	575	0.00		0	0
pesom_hash_node	575	0.00		0	0
pesom_heap_alloc	6	0.00		0	0
post/wait queue	926	0.00		0	605	0.00
process allocation	5,745	0.02	1.00	0	2,829	0.00
process group creation	5,661	0.00		0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	523	0.00		0	0
query server freelists	1	0.00		0	0
queued dump request	11	0.00		0	0
recovery domain hash list	13	0.00		0	0
redo allocation	15,030	0.04	0.00	0	118,135	0.02
redo copy	13	0.00		0	118,140	0.05
redo writing	15,099	0.00		0	0
resmgr group change latch	2,143	0.00		0	0
resmgr:active threads	6,463	0.02	0.00	0	604	0.00
resmgr:actses change group	1,097	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	5,707	0.00		0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	2	0.00		0	0
resmgr:schema config	833	0.00		0	59	0.00
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	8,431,452	0.53	0.00	0	2,233	0.04
second spare latch	13	0.00		0	0
sequence cache	5,562	0.00		0	0
session allocation	603,097	0.20	0.03	0	0
session idle bit	1,326,505	0.01	0.01	0	0
session queue latch	13	0.00		0	0
session state list latch	2,299	0.00		0	0
session switching	72	0.00		0	0
session timer	1,253	0.00		0	0
shared pool	3,373,122	0.63	0.08	2	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	637,527	0.00	0.00	0	0
sim partition latch	13	0.00		0	0
simulator hash latch	219,272	0.00		0	0
simulator lru latch	13	0.00		0	218,999	0.03
sort extent pool	200	0.00		0	0
space background state object latch	8	0.00		0	0
space background task latch	2,652	0.00		0	2,388	0.00
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
tablespace key chain	13	0.00		0	0
temp lob duration state obj allocation	5	0.00		0	0
temporary table state object allocation	4	0.00		0	0
test excl. parent l0	13	0.00		0	0
test excl. parent2 l0	13	0.00		0	0
third spare latch	13	0.00		0	0
threshold alerts latch	166	0.00		0	0
transaction allocation	529,267	0.00	0.00	0	0
undo global data	14,286	0.00		0	0
user lock	6,877	0.00		0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
row cache objects	8,431,452	44,540	33	44,508
shared pool	3,373,122	21,110	1,664	19,510
cache buffers chains	11,164,843	3,249	15	3,235
session allocation	603,097	1,220	40	1,181
cache buffer handles	777,812	668	1	667
kks stats	382,755	257	16	242
session idle bit	1,326,505	167	2	165
enqueue hash chains	227,834	41	1	40
process allocation	5,745	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
cache buffer handles	kcbzfs	1	0
cache buffers chains	kcbgtcr_9	120	124
cache buffers chains	kcbgtcr: fast path	15	4
cache buffers chains	kcbzgb: scan from tail. nowait	4	0
cache buffers chains	kcbrls_2	3	10
cache buffers chains	kcbrls: fast release	1	0
enqueue hash chains	ksqrcl	1	0
kks stats	kksAllocChildStat	16	16
object queue header operation	kcbo_switch_cq	1	0
object queue header operation	kcbo_unlink_q	1	2
process allocation	ksucrp:1	1	0
row cache objects	kqreqd: reget	22	0
row cache objects	kqrget	7	7
row cache objects	kqrpre: find obj	4	25
session allocation	ksuxds: KSUSFCLC not set	18	0
session allocation	ksufap: active sessions	15	0
session allocation	ksuxds: not user session	4	3
session allocation	ksucri	3	36
session idle bit	ksupuc: clear busy	1	0
session idle bit	ksuxds	1	0
shared pool	kghalo	1,076	875
shared pool	kghalp	393	333
shared pool	kghupr1	163	393
shared pool	kgh_heap_sizes	12	32
shared pool	kghasp	10	16
shared pool	kghfre	9	15

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Library Cache	kglGetHandleReference 115	13,561	14
Library Cache	kglhdgn2 106	309	2,279
Library Cache	kglobpn1 71	305	251
Library Cache	kglhdgn1 62	187	521
Library Cache	kglpin1 4	123	47
Library Cache	kglpndl1 95	123	354
Library Cache	kgllkdl1 85	60	422
Library Cache	kglpnal1 90	54	46
Library Cache	kgldtin1 42	39	300
Library Cache	kglget2 2	31	337
Library Cache	kgllkc1 57	5	0
Cursor Stat	kkocsStoreBindAwareStats [KKSSTALOC8]	4	1
Library Cache	kglrfcl1 79	1	3

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 Direct Physical Reads
Segments by Physical Writes
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 5,076,042
Captured Segments account for 43.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TOTO	TOTO_USER_IDX	I_BME_PERSON_SUB_NUMBER	INDEX	396,112	7.80
TOTO	TOTO_USER_DAT	INDEX_BIND_NUMBER1	INDEX	195,792	3.86
TOTO	TOTO_USER_DAT	SYS_C0011178	INDEX	191,936	3.78
SYS	SYSTEM	I_H_OBJ#_COL#	INDEX	131,424	2.59
SYS	SYSTEM	USER$	TABLE	80,640	1.59

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 17,891
Captured Segments account for 17.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TOTO	TOTO_USER_DAT	INDEX_BIND_NUMBER1	INDEX	1,328	7.42
TOTO	TOTO_USER_IDX	I_BME_SUBSCRIBER_CREATETIME	INDEX	1,114	6.23
TOTO	TOTO_USER_DAT	SYS_C0011178	INDEX	220	1.23
TOTO	TOTO_USER_DAT	R_BIND_ASSOCIATEDNUM	TABLE	118	0.66
SYS	SYSAUX	WRI$_ADV_MESSAGE_GROUPS	TABLE	108	0.60

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 5,858
Captured Segments account for 33.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST	INDEX	604	10.31
SYS	SYSTEM	HISTGRM$	TABLE	594	10.14
SYS	SYSTEM	I_H_OBJ#_COL#	INDEX	188	3.21
SYS	SYSAUX	WRI$_OPTSTAT_HISTGRM_HISTORY	TABLE	118	2.01
SYS	SYSAUX	WRH$_SQLTEXT	TABLE	44	0.75

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 342
Captured Segments account for 3.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	SYS_LOB0000005575C00040$$		LOB	4	1.17
SYS	SYSAUX	SYS_LOB0000005981C00038$$		LOB	4	1.17
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	42243_9044	TABLE PARTITION	4	1.17

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 718
Captured Segments account for 2.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	I_OBJ2		INDEX	7	0.97
SYS	SYSAUX	WRH$_PGA_TARGET_ADVICE_PK		INDEX	3	0.42
SYS	SYSAUX	WRH$_WAITSTAT_PK	42243_9044	INDEX PARTITION	3	0.42
SYS	SYSAUX	WRH$_DB_CACHE_ADVICE_PK	42243_9044	INDEX PARTITION	2	0.28
SYS	SYSTEM	I_OBJ1		INDEX	1	0.14

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
SYS	SYSTEM	HISTGRM$	TABLE	44,928	44.88
SYS	SYSTEM	I_H_OBJ#_COL#	INDEX	44,736	44.69
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST	INDEX	3,904	3.90
SYS	SYSTEM	USER$	TABLE	1,776	1.77
SYS	SYSAUX	WRI$_OPTSTAT_HISTHEAD_HISTORY	TABLE	1,760	1.76

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	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
TOTO	TOTO_USER_IDX	I_BME_SUBSCRIBER_CREATETIME		INDEX	2	100.00

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

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	83	0.00	2	1
dc_constraints	117	34.19	117	1
dc_database_links	4,460	0.00	0	1
dc_files	222	0.00	0	6
dc_global_oids	81	7.41	0	27
dc_histogram_data	824,400	0.41	2,772	1,536
dc_histogram_defs	1,076,103	0.43	1,575	1,775
dc_object_grants	56	10.71	0	16
dc_objects	1,015,709	0.06	56	821
dc_profiles	1,755	0.00	0	2
dc_rollback_segments	824	0.00	0	22
dc_segments	255,260	0.09	4	591
dc_sequences	24	8.33	24	2
dc_table_scns	11	100.00	0	0
dc_tablespaces	14,111	0.00	0	8
dc_users	153,232	0.01	1,685	112
global database name	3,485	0.00	0	1
outstanding_alerts	48	12.50	0	7

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	144	15.97	312	8.01	0	0
CLUSTER	359	0.00	189	0.00	0	0
INDEX	1,758	7.05	1,455	16.63	21	0
JAVA DATA	2	0.00	0		0	0
SQL AREA	270,769	66.04	483,897	38.27	6,396	211
TABLE/PROCEDURE	1,135,862	0.04	225,982	0.69	542	0
TRIGGER	2,050	0.88	2,050	0.88	0	0

Memory Statistics

Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Memory Dynamic Components

Min/Max sizes since instance startup
Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
ordered by Component

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	2,112.00	2,112.00	2,112.00	2,576.00	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	2,800.00	2,800.00	2,800.00	3,280.00	SHR/DEF
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	5,200.00	5,200.00	4,720.00	5,200.00	GRO/DEF
Shared IO Pool	944.00	944.00	944.00	944.00	STA/
java pool	16.00	16.00	16.00	32.00	SHR/DEF
large pool	16.00	16.00	16.00	16.00	STA/
shared pool	2,064.00	2,064.00	1,104.00	2,064.00	GRO/DEF
streams pool	0.00	0.00	0.00	0.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

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	270.52		3.61	6.85	40	40	75	75
	Freeable	51.88	0.00	1.08	1.48	7		48	48
	SQL	6.32	2.10	0.11	0.30	2	11	58	45
	JAVA	2.36	2.36	1.18	1.67	2	4	2	2
	PL/SQL	0.53	0.30	0.01	0.02	0	0	73	73
E	Other	213.78		2.97	5.38	22	22	72	72
	Freeable	37.88	0.00	0.84	1.06	7		45	45
	SQL	3.41	0.11	0.06	0.08	0	9	55	42
	JAVA	2.36	2.36	1.18	1.67	2	4	2	2
	PL/SQL	0.22	0.09	0.00	0.00	0	0	70	70

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	2,214,592,512
Fixed Size	2,176,320
Redo Buffers	10,694,656
Variable Size	6,123,686,592

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	4.35	4.35	0.00
java	joxlod exec hp	11.19	11.19	0.00
java	joxs heap	0.46	0.46	0.00
large	PX msg pool	0.99	0.99	0.00
large	free memory	15.01	15.01	0.00
shared	CCursor	210.42	219.94	4.53
shared	Cursor Stats	26.97	26.97	0.00
shared	KGL handle	76.10	76.85	0.98
shared	PCursor	209.75	212.45	1.29
shared	db_block_hash_buckets	22.25	22.25	0.00
shared	free memory	341.79	276.36	-19.14
shared	kglsim object batch	36.28	36.28	0.00
shared	sql area	961.39	1,021.81	6.28
	buffer_cache	2,112.00	2,112.00	0.00
	fixed_sga	2.08	2.08	0.00
	log_buffer	10.20	10.20	0.00
	shared_io_pool	944.00	944.00	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

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

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Subscribers

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

if IP/Public/Source at End snap is different a '*' is displayed

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/app/admin/ora11g/adump
audit_trail	NONE
compatible	11.1.0.0.0
control_files	/dev/vx/rdsk/vgora/lvctl1, /dev/vx/rdsk/vgora/lvctl2, /dev/vx/rdsk/vgora/lvctl3
db_block_size	8192
db_domain
db_name	ora11g
db_recovery_file_dest
db_recovery_file_dest_size	2147483648
diagnostic_dest	/oracle/app
dispatchers	(PROTOCOL=TCP) (SERVICE=ora11gXDB)
local_listener
log_archive_dest_1	location=/home/oracle/archive
memory_target	8388608000
open_cursors	300
processes	150
remote_listener
remote_login_passwordfile	EXCLUSIVE
sec_case_sensitive_logon	FALSE
spfile	/dev/vx/rdsk/vgora/lvspfile
undo_tablespace	UNDOTBS1

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.65	In-memory Sort %:	100.00
Library Hit %:	73.80	Soft Parse %:	61.07
Execute to Parse %:	53.27	Latch Hit %:	99.78
Parse CPU to Parse Elapsd %:	0.00	% Non-Parse CPU:	82.50