WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

PROD15 3466472990 PROD15 1 10.2.0.3.0 NO clue

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
PROD15	3466472990	PROD15	1	10.2.0.3.0	NO	clue

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 2349 28-Oct-08 12:00:57 146 6.3

End Snap: 2350 28-Oct-08 13:01:00 145 6.0

Elapsed: 60.06 (mins)

DB Time: 91.48 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	2349	28-Oct-08 12:00:57	146	6.3
End Snap:	2350	28-Oct-08 13:01:00	145	6.0
Elapsed:		60.06 (mins)
DB Time:		91.48 (mins)

Report Summary

Cache Sizes

Begin End

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

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

	Begin	End
Buffer Cache:	2,304M	2,304M	Std Block Size:	8K
Shared Pool Size:	560M	560M	Log Buffer:	14,356K

Load Profile

Per Second Per Transaction

Redo size: 948,397.88 1,761,544.94

Logical reads: 6,562.64 12,189.37

Block changes: 740.05 1,374.57

Physical reads: 735.51 1,366.14

Physical writes: 464.54 862.84

User calls: 101.98 189.42

Parses: 22.08 41.01

Hard parses: 2.68 4.98

Sorts: 14.01 26.02

Logons: 0.32 0.59

Executes: 82.31 152.89

Transactions: 0.54

	Per Second	Per Transaction
Redo size:	948,397.88	1,761,544.94
Logical reads:	6,562.64	12,189.37
Block changes:	740.05	1,374.57
Physical reads:	735.51	1,366.14
Physical writes:	464.54	862.84
User calls:	101.98	189.42
Parses:	22.08	41.01
Hard parses:	2.68	4.98
Sorts:	14.01	26.02
Logons:	0.32	0.59
Executes:	82.31	152.89
Transactions:	0.54

% Blocks changed per Read: 11.28 Recursive Call %: 83.27

Rollback per transaction %: 8.92 Rows per Sort: 457.00

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 99.98

Buffer Hit %: 92.10 In-memory Sort %: 99.99

Library Hit %: 91.39 Soft Parse %: 87.87

Execute to Parse %: 73.18 Latch Hit %: 99.97

Parse CPU to Parse Elapsd %: 65.36 % Non-Parse CPU: 98.10

Shared Pool Statistics

Begin End

Memory Usage %: 30.16 30.20

% SQL with executions>1: 80.28 80.20

% Memory for SQL w/exec>1: 80.11 78.47

	Begin	End
Memory Usage %:	30.16	30.20
% SQL with executions>1:	80.28	80.20
% Memory for SQL w/exec>1:	80.11	78.47

Top 5 Timed Events

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

CPU time 3,641 66.3

db file sequential read 489,550 587 1 10.7 User I/O

db file scattered read 12,142 565 47 10.3 User I/O

direct path read temp 34,932 470 13 8.6 User I/O

log file parallel write 6,253 235 38 4.3 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		3,641		66.3
db file sequential read	489,550	587	1	10.7	User I/O
db file scattered read	12,142	565	47	10.3	User I/O
direct path read temp	34,932	470	13	8.6	User I/O
log file parallel write	6,253	235	38	4.3	System I/O

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
init.ora Parameters

Time Model Statistics

Total time in database user-calls (DB Time): 5488.7s
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	5,385.61	98.12
DB CPU	3,641.47	66.34
parse time elapsed	139.84	2.55
hard parse elapsed time	132.46	2.41
PL/SQL execution elapsed time	12.18	0.22
PL/SQL compilation elapsed time	9.35	0.17
connection management call elapsed time	9.21	0.17
hard parse (sharing criteria) elapsed time	5.65	0.10
sequence load elapsed time	1.19	0.02
failed parse elapsed time	0.76	0.01
repeated bind elapsed time	0.46	0.01
hard parse (bind mismatch) elapsed time	0.31	0.01
DB time	5,488.72
background elapsed time	534.09
background cpu time	84.49

Back to Wait Events Statistics
Back to Top

Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
User I/O	573,122	0.00	1,809	3	295.42
System I/O	25,042	0.00	421	17	12.91
Configuration	550	0.00	61	111	0.28
Commit	1,938	0.00	38	20	1.00
Concurrency	349	10.89	9	26	0.18
Network	364,344	0.00	7	0	187.81
Other	1,393	6.60	2	1	0.72
Application	344	0.00	0	1	0.18

Back to Wait Events Statistics
Back to Top

Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file sequential read	489,550	0.00	587	1	252.35
db file scattered read	12,142	0.00	565	47	6.26
direct path read temp	34,932	0.00	470	13	18.01
log file parallel write	6,253	0.00	235	38	3.22
db file parallel write	4,029	0.00	176	44	2.08
direct path write temp	30,705	0.00	160	5	15.83
log buffer space	416	0.00	46	111	0.21
log file sync	1,938	0.00	38	20	1.00
db file parallel read	1,822	0.00	23	13	0.94
log file switch completion	133	0.00	14	108	0.07
control file parallel write	1,878	0.00	8	4	0.97
os thread startup	62	0.00	6	92	0.03
SQL*Net more data to client	94,595	0.00	5	0	48.76
buffer busy waits	86	0.00	3	34	0.04
direct path read	2,081	0.00	2	1	1.07
log file single write	156	0.00	1	8	0.08
SGA: allocation forcing component growth	96	94.79	1	10	0.05
TCP Socket (KGAS)	371	0.00	1	2	0.19
control file sequential read	12,390	0.00	1	0	6.39
direct path write	1,090	0.00	1	1	0.56
SQL*Net message to client	239,143	0.00	1	0	123.27
control file single write	180	0.00	1	3	0.09
rdbms ipc reply	225	0.00	0	2	0.12
cursor: pin S wait on X	39	97.44	0	10	0.02
read by other session	772	0.00	0	0	0.40
SQL*Net more data from client	63	0.00	0	5	0.03
SQL*Net break/reset to client	314	0.00	0	1	0.16
latch: shared pool	99	0.00	0	2	0.05
enq: RO - fast object reuse	30	0.00	0	5	0.02
latch free	16	0.00	0	9	0.01
log file switch (private strand flush incomplete)	1	0.00	0	132	0.00
enq: DX - contention	12	0.00	0	9	0.01
local write wait	28	0.00	0	3	0.01
LGWR wait for redo copy	940	0.00	0	0	0.48
log file sequential read	156	0.00	0	0	0.08
SQL*Net message to dblink	30,142	0.00	0	0	15.54
latch: cache buffers lru chain	47	0.00	0	1	0.02
enq: CU - contention	1	0.00	0	30	0.00
latch: cache buffers chains	36	0.00	0	1	0.02
latch: enqueue hash chains	4	0.00	0	6	0.00
cursor: pin X	1	100.00	0	10	0.00
library cache load lock	1	0.00	0	10	0.00
reliable message	26	0.00	0	0	0.01
latch: library cache	24	0.00	0	0	0.01
latch: object queue header operation	16	0.00	0	0	0.01
latch: redo allocation	1	0.00	0	4	0.00
SQL*Net more data from dblink	30	0.00	0	0	0.02
row cache lock	2	0.00	0	0	0.00
latch: session allocation	7	0.00	0	0	0.00
latch: undo global data	1	0.00	0	0	0.00
SQL*Net message from client	239,143	0.00	187,334	783	123.27
wait for unread message on broadcast channel	3,601	99.97	3,516	976	1.86
Streams AQ: qmn slave idle wait	242	0.00	3,515	14524	0.12
Streams AQ: qmn coordinator idle wait	377	35.54	3,515	9323	0.19
Streams AQ: waiting for messages in the queue	721	99.86	3,514	4873	0.37
Streams AQ: waiting for time management or cleanup tasks	8	50.00	2,636	329543	0.00
jobq slave wait	604	99.67	1,768	2927	0.31
SQL*Net message from dblink	30,142	0.00	31	1	15.54
single-task message	4	0.00	0	64	0.00
class slave wait	2	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	6,252	0.00	235	38	3.22
db file parallel write	4,029	0.00	176	44	2.08
control file parallel write	1,878	0.00	8	4	0.97
os thread startup	62	0.00	6	92	0.03
direct path read	2,081	0.00	2	1	1.07
log file single write	156	0.00	1	8	0.08
direct path write	1,052	0.00	1	1	0.54
control file single write	180	0.00	1	3	0.09
events in waitclass Other	1,010	0.00	0	0	0.52
control file sequential read	1,108	0.00	0	0	0.57
log file sequential read	156	0.00	0	0	0.08
latch: shared pool	7	0.00	0	8	0.00
latch: cache buffers chains	3	0.00	0	2	0.00
buffer busy waits	2	0.00	0	2	0.00
log buffer space	4	0.00	0	1	0.00
latch: library cache	1	0.00	0	0	0.00
rdbms ipc message	18,376	61.71	29,687	1616	9.47
Streams AQ: qmn slave idle wait	242	0.00	3,515	14524	0.12
Streams AQ: qmn coordinator idle wait	377	35.54	3,515	9323	0.19
pmon timer	1,431	100.00	3,514	2455	0.74
smon timer	56	1.79	3,453	61663	0.03
Streams AQ: waiting for time management or cleanup tasks	8	50.00	2,636	329543	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	116,897
AVG_IDLE_TIME	242,244
AVG_IOWAIT_TIME	53,542
AVG_SYS_TIME	20,811
AVG_USER_TIME	95,754
BUSY_TIME	469,494
IDLE_TIME	970,850
IOWAIT_TIME	215,489
SYS_TIME	84,604
USER_TIME	384,890
LOAD	0
OS_CPU_WAIT_TIME	537,600
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	10,737,418,240
NUM_CPUS	4
NUM_CPU_CORES	4

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	3,836.70	2,608.40	2,181,864	6,786,914
PROD15	1,660.00	1,038.50	468,384	16,768,646
SYS$BACKGROUND	0.00	0.00	3,134	72,431

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	106930	123285	90	10	13488	7
PROD15	461984	56500	174	328	348110	696
SYS$BACKGROUND	4247	1142	84	576	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
3,513	2,372	0		64.01	b1pr27t2fa2br	SQL*Plus	BEGIN CARGACASS_EIS.CALL_CASSE...
1,124	669	0		20.48	3tdzvvca1wghu	SQL*Plus	/* MV_REFRESH (INS) */INSERT /...
71	71	124	0.57	1.30	6zr5x4yxb1vdc	Lab128	--lab128 select latch#, gets,...
61	40	19	3.20	1.11	33bpz9dh1w5jk	Lab128	--lab128 select /+rule/ own...
32	28	669	0.05	0.59	cg3r8bbafckw7	Lab128	--lab128 select sid, inst_id,...
31	28	600	0.05	0.57	79zz4sq60ytgt	Lab128	--lab128 select address sqlad...
30	29	90,163	0.00	0.54	at2dqppt1wss5	oracle@bdweb2 (TNS V1-V3)	SELECT "A3"."DIF_HORARIA"/2 FR...
29	29	3,310	0.01	0.53	g8c2vk3m3mxgv	Lab128	--lab128 select s.sid, s.owne...
28	25	480	0.06	0.51	257rmrxgvaj4z	Realtime Connection	select begin_time, wait_class...
26	23	600	0.04	0.48	bbrr9n6xy7pxs	Lab128	--lab128 select sid, serial#,...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
2,372	3,513	0		64.01	b1pr27t2fa2br	SQL*Plus	BEGIN CARGACASS_EIS.CALL_CASSE...
669	1,124	0		20.48	3tdzvvca1wghu	SQL*Plus	/* MV_REFRESH (INS) */INSERT /...
71	71	124	0.57	1.30	6zr5x4yxb1vdc	Lab128	--lab128 select latch#, gets,...
40	61	19	2.11	1.11	33bpz9dh1w5jk	Lab128	--lab128 select /+rule/ own...
29	30	90,163	0.00	0.54	at2dqppt1wss5	oracle@bdweb2 (TNS V1-V3)	SELECT "A3"."DIF_HORARIA"/2 FR...
29	29	3,310	0.01	0.53	g8c2vk3m3mxgv	Lab128	--lab128 select s.sid, s.owne...
28	31	600	0.05	0.57	79zz4sq60ytgt	Lab128	--lab128 select address sqlad...
28	32	669	0.04	0.59	cg3r8bbafckw7	Lab128	--lab128 select sid, inst_id,...
25	28	480	0.05	0.51	257rmrxgvaj4z	Realtime Connection	select begin_time, wait_class...
23	26	600	0.04	0.48	bbrr9n6xy7pxs	Lab128	--lab128 select sid, serial#,...

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: 23,647,386
Captured SQL account for 18.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
4,220,483	0		17.85	2372.17	3513.50	b1pr27t2fa2br	SQL*Plus	BEGIN CARGACASS_EIS.CALL_CASSE...
2,179,611	19	114,716.37	9.22	40.00	60.89	33bpz9dh1w5jk	Lab128	--lab128 select /+rule/ own...
1,083,898	90,163	12.02	4.58	29.19	29.55	at2dqppt1wss5	oracle@bdweb2 (TNS V1-V3)	SELECT "A3"."DIF_HORARIA"/2 FR...
526,309	33,494	15.71	2.23	8.23	8.43	7fc345r61jg46	oracle@bdweb2 (TNS V1-V3)	SELECT CEIL("A1"."DIF_HORARIA"...
409,208	0		1.73	668.74	1124.08	3tdzvvca1wghu	SQL*Plus	/* MV_REFRESH (INS) */INSERT /...
169,680	10	16,968.00	0.72	8.12	8.14	ga6tqb86r8n65	c_retornos_nuevo.exe@clue (TNS V1-V3)	select sum(DECODE(m.tipo_carga...
61,764	20	3,088.20	0.26	3.42	3.62	4k6w45yc36f4b	Lab128	--lab128 select file_id, tabl...
59,632	1	59,632.00	0.25	4.91	25.69	7a6hpf0q9axjx	ocuvuelos.exe	select distinct a.n_awb, a.or...
39,383	449	87.71	0.17	3.06	4.33	085pnk9fbdqpa	Lab128	--lab128 select b.segment_nam...
20,423	9	2,269.22	0.09	2.07	5.37	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 2,650,307
Captured SQL account for 2.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
2,147,215	0		81.02	2372.17	3513.50	b1pr27t2fa2br	SQL*Plus	BEGIN CARGACASS_EIS.CALL_CASSE...
497,471	0		18.77	668.74	1124.08	3tdzvvca1wghu	SQL*Plus	/* MV_REFRESH (INS) */INSERT /...
47,338	19	2,491.47	1.79	40.00	60.89	33bpz9dh1w5jk	Lab128	--lab128 select /+rule/ own...
3,838	3	1,279.33	0.14	0.49	3.97	9b9z4bu0db1ax	JDBC Thin Client	SELECT tipo FROM ovtipos_uld ...
2,803	1	2,803.00	0.11	4.91	25.69	7a6hpf0q9axjx	ocuvuelos.exe	select distinct a.n_awb, a.or...
724	9	80.44	0.03	2.07	5.37	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
78	2,039	0.04	0.00	0.96	1.41	db78fxqxwxt7r		select /+ rule / bucket, en...
31	106	0.29	0.00	0.08	0.27	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
25	1,511	0.02	0.00	0.66	0.90	cqgv56fmuj63x		select owner#, name, namespace...
22	1,511	0.01	0.00	0.36	0.57	8swypbbr0m372		select order#, columns, types ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 296,603
Captured SQL account for 55.6% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
90,163	90,163	1.00	0.00	0.00	at2dqppt1wss5	oracle@bdweb2 (TNS V1-V3)	SELECT "A3"."DIF_HORARIA"/2 FR...
33,494	27,617	0.82	0.00	0.00	7fc345r61jg46	oracle@bdweb2 (TNS V1-V3)	SELECT CEIL("A1"."DIF_HORARIA"...
3,457	2,013	0.58	0.00	0.00	96g93hntrzjtr		select /+ rule / bucket_cnt,...
3,310	11,356	3.43	0.01	0.01	g8c2vk3m3mxgv	Lab128	--lab128 select s.sid, s.owne...
2,896	2,896	1.00	0.00	0.00	2ym6hhaq30r73		select type#, blocks, extents,...
2,142	2,142	1.00	0.00	0.00	1v717nvrhgbn9		SELECT USER FROM SYS.DUAL
2,039	32,670	16.02	0.00	0.00	db78fxqxwxt7r		select /+ rule / bucket, en...
1,511	5,003	3.31	0.00	0.00	8swypbbr0m372		select order#, columns, types ...
1,511	5,591	3.70	0.00	0.00	cqgv56fmuj63x		select owner#, name, namespace...
1,161	1,502	1.29	0.00	0.00	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 79,561
Captured SQL account for 22.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
2,896	2,896	3.64	2ym6hhaq30r73	select type#, blocks, extents,...
1,511	1,511	1.90	8swypbbr0m372	select order#, columns, types ...
1,511	1,511	1.90	cqgv56fmuj63x	select owner#, name, namespace...
1,066	2,142	1.34	1v717nvrhgbn9	SELECT USER FROM SYS.DUAL
1,066	1,066	1.34	5b6vy6zk2g7cb	DECLARE sqlstr VARCHAR2(200) ...
1,066	1,066	1.34	fpadd6mkfh5xb	DECLARE sqlstr VARCHAR2(200) ...
1,008	1,008	1.27	bsa0wjtftg3uw	select file# from file$ where ...
852	852	1.07	459f3z9u4fb3u	select value$ from props$ wher...
548	548	0.69	0h6b2sajwb74n	select privilege#, level from ...
548	548	0.69	ga9j9xk5cy9s0	select /*+ index(idl_sb4$ i_id...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Text
22	321	2q93zsrvbdw48	select grantee#, privilege#, n...
22	215	a73wbv1yu8x5c	select con#, type#, condlength...
21	1,161	53saa2zkr6wc3	select intcol#, nvl(pos#, 0), ...
21	321	6aq34nj2zb2n7	select col#, grantee#, privi...
21	293	7ng34ruy5awxq	select i.obj#, i.ts#, i.file#,...
21	342	f8pavn1bvsj7t	select con#, obj#, rcon#, enab...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

085pnk9fbdqpa --lab128 select b.segment_name seg_name, a.extends, a.writes, a.gets, a.waits, a.rssize, a.xacts, a.shrinks, a.wraps, a.hwmsize, a.status v_status, b.segment_id usn, b.tablespace_name ts_name, b.status, a.inst_id from gv$rollstat a, dba_rollback_segs b where a.usn(+)=b.segment_id

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

1v717nvrhgbn9 SELECT USER FROM SYS.DUAL

257rmrxgvaj4z select begin_time, wait_class#, (time_waited)/(intsize_csec/100) from v$waitclassmetric union all select begin_time, -1, value from v$sysmetric where metric_name = 'CPU Usage Per Sec' and group_id = 2 order by begin_time, wait_class#

2q93zsrvbdw48 select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#

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

33bpz9dh1w5jk --lab128 select /*+rule*/ owner, segment_name||decode(partition_name, null, null, ' ('||partition_name||')') name, segment_type, tablespace_name, extent_id, file_id, block_id, blocks, bytes/1048576 bytes from dba_extents

39m4sx9k63ba2 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#

3tdzvvca1wghu /* MV_REFRESH (INS) */INSERT /*+ BYPASS_RECURSIVE_CHECK APPEND SKIP_UNQ_UNUSABLE_IDX */ INTO "CASS"."MV_AGNTPAISFEMI"("AGNTPAIS_JE_ID", "DISTORIG", "PAIS_ID", "YEAR_EMI", "MES_EMI", "RANGO_ID", "COMP_ID", "SUM(FT11.PESO_TASADO)", "SUM(FT11.PESO_BRUTO)", "SUM(FT11.NUM_AWBS)", "SUM(FT11.VENT_NET_EURO)", "SUM(FT11.VENT_NET_MLIQUI)") SELECT "LT1"."AGNTPAIS_JE_ID", "LT5"."DIST_ID", "LT3"."PAIS_ID", "LT4"."YEAR_EMI", "FT11"."MES_EMI", "FT11"."RANGO_ID", "FT11"."COMP_ID", SUM("FT11"."PESO_TASADO"), SUM("FT11"."PESO_BRUTO"), SUM("FT11"."NUM_AWBS"), SUM("FT11"."VENT_NET_EURO"), SUM("FT11"."VENT_NET_MLIQUI") FROM "CASS"."CASS_DATOS_01" "FT11", "CASS"."CASS_AGEN" "LT1", "CASS"."CASS_DESTINO" "LT3", "CASS"."CASS_ORIGEN" "LT5", "CASS"."CASS_FECHA_EMISION" "LT4" WHERE "LT1"."AGNT_ID"="FT11"."AGNT_ID" AND "LT5"."ARPT_ORIG_ID"="FT11"."ARPT_ORIG_ID" AND "LT3"."ARPT_DEST_ID"="FT11"."ARPT_DEST_ID" AND "LT4"."MES_DATE_EMI"="FT11"."MES_EMI" GROUP BY "LT1"."AGNTPAIS_JE_ID", "LT5"."DIST_ID", "LT3"."PAIS_ID", "FT11"."MES_EMI", "LT4"."YEAR_EMI", "FT11"."RANGO_ID", "FT11"."COMP_ID"

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

4k6w45yc36f4b --lab128 select file_id, tablespace_name ts_name, sum(bytes) bytes from dba_free_space group by file_id, tablespace_name

53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1

5b6vy6zk2g7cb DECLARE sqlstr VARCHAR2(200) := 'alter session set "_optimizer_cost_based_transformation"=''off'''; BEGIN IF (USER = 'OCUVUE') THEN execute immediate sqlstr; END IF; END logon_ocuvue;

6aq34nj2zb2n7 select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

6zr5x4yxb1vdc --lab128 select latch#, gets, misses, sleeps, immediate_gets, immediate_misses, waits_holding_latch, spin_gets from v$latch where gets+immediate_gets>0

79zz4sq60ytgt --lab128 select address sqladdr, hash_value, sql_text, inst_id, sql_id from gv$open_cursor where saddr=:1 and sid=:2 and inst_id=:3

7a6hpf0q9axjx select distinct a.n_awb, a.org_awb, a.dest_awb, decode(awb_ind_sis, 'E', 'E', decode(fwb_correcto, 'E', 'E', ' ')) eawb, a.peso_merc, a.paq_merc, a.naturaleza, decode(agtawb.agt_nombre, null, agtfwb.agt_nombre, agtawb.agt_nombre) agt_nombre, a.id_cao, a.merc_especial_1, a.merc_especial_2, id_psh, vuelo, sufijo, fecha_gmt, origen, destino, matricula, peso, retorno, volumen, uld from bleach a, (select va.n_awb, va.id_psh, va.vuelo, va.sufijo, va.fecha_gmt, va.origen, v.destino, v.matricula, va.peso, va.retorno, va.volumen, va.uld from ovvueawb va, ovvuelos v where v.fecha_gmt >= to_date('01/08/2008', 'dd/mm/yyyy') and v.fecha_gmt <= to_date('31/08/2008', 'dd/mm/yyyy') and va.n_awb >= '07500000000' and va.n_awb <= '07599999999' and v.vuelo like 'IB3%' and va.vuelo = v.vuelo and va.fecha_gmt = v.fecha_gmt and va.origen = v.origen and va.sufijo = v.sufijo and va.retorno = 'N' and v.activo = 'S' union all select va.n_awb, va.id_psh, va.vuelo, va.sufijo, va.fecha_gmt, va.origen, v.destino, v.matricula, va.peso, va.retorno, va.volumen, va.uld from ovvueciaawb va, ovvueloscias v where v.fecha_gmt >= to_date('01/08/2008', 'dd/mm/yyyy') and v.fecha_gmt <= to_date('31/08/2008', 'dd/mm/yyyy') and va.n_awb >= '07500000000' and va.n_awb <= '07599999999' and v.vuelo like 'IB3%' and va.vuelo = v.vuelo and va.fecha_gmt = v.fecha_gmt and va.origen = v.origen and va.sufijo = v.sufijo and va.retorno = 'N' and v.activo = 'S') va, ovciudadesview ciudadesorigen, ovsumoview sumoorigen, ovciudadesview ciudadesdestino, ovsumoview sumodestino, vcdgen.vcdawb@ocuvue_vcd , vcdgen.vcdgen_fwb@ocuvue_vcd , vcdgen.vcdgen_agt@ocuvue_vcd agtawb, vcdgen.vcdgen_agt@ocuvue_vcd agtfwb where a.n_awb = va.n_awb and ciudadesorigen.ciu_cod_ciu_iata (+) = a.org_awb and ciudadesorigen.ciu_cod_pais = sumoorigen.pai_cod_pais (+) and ciudadesdestino.ciu_cod_ciu_iata (+) = a.dest_awb and ciudadesdestino.ciu_cod_pais = sumodestino.pai_cod_pais (+) and substr(a.n_awb, 1, 3) = awb_cod_cia (+) and substr(a.n_awb, 4) = awb_num_awb (+) and awb_cod_agt = agtawb.agt_cod_agt (+) and awb_cod_pais = agtawb.agt_cod_pais (+) and substr(a.n_awb, 1, 3) = fwb_cod_cia (+) and substr(a.n_awb, 4) = fwb_num_fwb (+) and fwb_cod_agt = agtfwb.agt_cod_agt (+) and fwb_cod_pais = agtfwb.agt_cod_pais (+) and ((substr(sumoorigen.pai_tide, 1, 1) = '2')) and ((substr(sumodestino.pai_tide, 1, 2) = '31') or (substr(sumodestino.pai_tide, 1, 1) = '4') or (substr(sumodestino.pai_tide, 1, 2) = '41') or (substr(sumodestino.pai_tide, 1, 1) = '5') or (substr(sumodestino.pai_tide, 1, 2) = '51') or (substr(sumodestino.pai_tide, 1, 1) = '6') or (substr(sumodestino.pai_tide, 1, 2) = '61'))

7fc345r61jg46 SELECT CEIL("A1"."DIF_HORARIA"/2) FROM "CIBER"."CB_ARPT" "A5", "CIBER"."CB_CIUDAD" "A4", "CIBER"."CB_DISTRITO" "A3", "CIBER"."CB_PAIS" "A2", "CIBER"."CB_HUSOS_HORARIOS" "A1" WHERE "A4"."HUSO_HORARIO"="A1"."HUSO_HORARIO" AND "A5"."ARP_CIU_ID"="A4"."CIU_ID" AND "A4"."CIU_DISTRITO_ID"="A3"."DIS_ID" AND "A3"."DIS_PAIS_ID"="A2"."PAI_ID" AND "A5"."ARP_ID"=:B2 AND "A1"."FECHA_DESDE"<=TRUNC(:B1) AND "A1"."FECHA_HASTA">=TRUNC(:B1) ORDER BY "A2"."PAI_DSC", "A4"."CIU_DSC"

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#

8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1

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

9b9z4bu0db1ax SELECT tipo FROM ovtipos_uld WHERE propiedad = 'S' ORDER BY tipo

a73wbv1yu8x5c select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1

at2dqppt1wss5 SELECT "A3"."DIF_HORARIA"/2 FROM "CIBER"."CB_CIUDAD" "A4", "CIBER"."CB_HUSOS_HORARIOS" "A3", "CIBER"."CB_DISTRITO" "A2", "CIBER"."CB_PAIS" "A1" WHERE "A4"."HUSO_HORARIO"="A3"."HUSO_HORARIO" AND "A4"."CIU_DISTRITO_ID"="A2"."DIS_ID" AND "A1"."PAI_ID"="A2"."DIS_PAIS_ID" AND "A4"."CIU_ID"='MAD' AND TRUNC("A3"."FECHA_DESDE")<=TRUNC(SYSDATE@!) AND TRUNC("A3"."FECHA_HASTA")>=TRUNC(SYSDATE@!)

b1pr27t2fa2br BEGIN CARGACASS_EIS.CALL_CASSEIS; END; �

bbrr9n6xy7pxs --lab128 select sid, serial#, inst_id, status from gv$px_process where sid is not null

bsa0wjtftg3uw select file# from file$ where ts#=:1

cg3r8bbafckw7 --lab128 select sid, inst_id, decode(type, 'TM', id1, null) obj_id, type, id1, id2, lmode, lmode "Lock Held", request, request "Lock Request", ctime, kaddr from gv$lock

cqgv56fmuj63x select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

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

f8pavn1bvsj7t select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1

fpadd6mkfh5xb DECLARE sqlstr VARCHAR2(200) := 'alter session set "_optimizer_cost_based_transformation"=''off'''; BEGIN IF (USER = 'CIBERBO') THEN execute immediate sqlstr; END IF; END logon_ciberbo;

g8c2vk3m3mxgv --lab128 select s.sid, s.ownerid, s.user#, s.sql_id, b.plan_hash_value hash_value , s.sql_child_number, s.seq#, s.event#, s.serial#, userenv('INSTANCE') inst_id , s.row_wait_obj#, s.row_wait_file#, s.row_wait_block#, s.row_wait_row# , s.service_name, p1, p2, p3, s.wait_time, s.seconds_in_wait , decode(s.state, 'WAITING', 0, 1) state , s.blocking_session, 1 blocking_instance , s.plsql_entry_object_id, s.plsql_entry_subprogram_id , s.plsql_object_id, s.plsql_subprogram_id , s.osuser, s.machine, s.terminal, s.program from v$session s, v$sql b where s.sql_id=b.sql_id(+) and s.sql_child_number=b.child_number(+) and sid!=:1 and decode(s.ownerid, 2147483644, 0, 1)!=:2 and nvl(s.module, '-')!=:3 and ((s.status='ACTIVE' and s.username is not null) or (userenv('INSTANCE')-1)*1048576+s.sid in (:4, :5, :6, :7, :8, :9, :10, :11))

ga6tqb86r8n65 select sum(DECODE(m.tipo_carga, 'C', m.peso, 0)) , sum(DECODE(m.tipo_carga, 'M', m.peso, 0)) , sum(DECODE(t.pallet, 'S', DECODE(m.tipo_carga, 'C', 1, 0), 0)) , sum(DECODE(t.pallet, 'S', DECODE(m.tipo_carga, 'M', 1, 0), 0)) , sum(DECODE(t.pallet, 'N', DECODE(m.tipo_carga, 'C', 1, 0), 0)) , sum(DECODE(t.pallet, 'N', DECODE(m.tipo_carga, 'M', 1, 0), 0)) into :b0, :b1, :b2, :b3, :b4, :b5 from ovcmer m , ovtipos_uld t where ((((m.tipo_uld=t.tipo(+) and m.vuelo=:b6) and m.sufijo=:b7) and m.fecha_gmt=to_date(:b8, 'dd/mm/yyyy')) and m.origen=:b9)

ga9j9xk5cy9s0 select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#

SQL Id	SQL Text
085pnk9fbdqpa	--lab128 select b.segment_name seg_name, a.extends, a.writes, a.gets, a.waits, a.rssize, a.xacts, a.shrinks, a.wraps, a.hwmsize, a.status v_status, b.segment_id usn, b.tablespace_name ts_name, b.status, a.inst_id from gv$rollstat a, dba_rollback_segs b where a.usn(+)=b.segment_id
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
1v717nvrhgbn9	SELECT USER FROM SYS.DUAL
257rmrxgvaj4z	select begin_time, wait_class#, (time_waited)/(intsize_csec/100) from v$waitclassmetric union all select begin_time, -1, value from v$sysmetric where metric_name = 'CPU Usage Per Sec' and group_id = 2 order by begin_time, wait_class#
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
33bpz9dh1w5jk	--lab128 select /+rule/ owner, segment_name\|\|decode(partition_name, null, null, ' ('\|\|partition_name\|\|')') name, segment_type, tablespace_name, extent_id, file_id, block_id, blocks, bytes/1048576 bytes from dba_extents
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3tdzvvca1wghu	/* MV_REFRESH (INS) /INSERT /+ BYPASS_RECURSIVE_CHECK APPEND SKIP_UNQ_UNUSABLE_IDX */ INTO "CASS"."MV_AGNTPAISFEMI"("AGNTPAIS_JE_ID", "DISTORIG", "PAIS_ID", "YEAR_EMI", "MES_EMI", "RANGO_ID", "COMP_ID", "SUM(FT11.PESO_TASADO)", "SUM(FT11.PESO_BRUTO)", "SUM(FT11.NUM_AWBS)", "SUM(FT11.VENT_NET_EURO)", "SUM(FT11.VENT_NET_MLIQUI)") SELECT "LT1"."AGNTPAIS_JE_ID", "LT5"."DIST_ID", "LT3"."PAIS_ID", "LT4"."YEAR_EMI", "FT11"."MES_EMI", "FT11"."RANGO_ID", "FT11"."COMP_ID", SUM("FT11"."PESO_TASADO"), SUM("FT11"."PESO_BRUTO"), SUM("FT11"."NUM_AWBS"), SUM("FT11"."VENT_NET_EURO"), SUM("FT11"."VENT_NET_MLIQUI") FROM "CASS"."CASS_DATOS_01" "FT11", "CASS"."CASS_AGEN" "LT1", "CASS"."CASS_DESTINO" "LT3", "CASS"."CASS_ORIGEN" "LT5", "CASS"."CASS_FECHA_EMISION" "LT4" WHERE "LT1"."AGNT_ID"="FT11"."AGNT_ID" AND "LT5"."ARPT_ORIG_ID"="FT11"."ARPT_ORIG_ID" AND "LT3"."ARPT_DEST_ID"="FT11"."ARPT_DEST_ID" AND "LT4"."MES_DATE_EMI"="FT11"."MES_EMI" GROUP BY "LT1"."AGNTPAIS_JE_ID", "LT5"."DIST_ID", "LT3"."PAIS_ID", "FT11"."MES_EMI", "LT4"."YEAR_EMI", "FT11"."RANGO_ID", "FT11"."COMP_ID"
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4k6w45yc36f4b	--lab128 select file_id, tablespace_name ts_name, sum(bytes) bytes from dba_free_space group by file_id, tablespace_name
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5b6vy6zk2g7cb	DECLARE sqlstr VARCHAR2(200) := 'alter session set "_optimizer_cost_based_transformation"=''off'''; BEGIN IF (USER = 'OCUVUE') THEN execute immediate sqlstr; END IF; END logon_ocuvue;
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6zr5x4yxb1vdc	--lab128 select latch#, gets, misses, sleeps, immediate_gets, immediate_misses, waits_holding_latch, spin_gets from v$latch where gets+immediate_gets>0
79zz4sq60ytgt	--lab128 select address sqladdr, hash_value, sql_text, inst_id, sql_id from gv$open_cursor where saddr=:1 and sid=:2 and inst_id=:3
7a6hpf0q9axjx	select distinct a.n_awb, a.org_awb, a.dest_awb, decode(awb_ind_sis, 'E', 'E', decode(fwb_correcto, 'E', 'E', ' ')) eawb, a.peso_merc, a.paq_merc, a.naturaleza, decode(agtawb.agt_nombre, null, agtfwb.agt_nombre, agtawb.agt_nombre) agt_nombre, a.id_cao, a.merc_especial_1, a.merc_especial_2, id_psh, vuelo, sufijo, fecha_gmt, origen, destino, matricula, peso, retorno, volumen, uld from bleach a, (select va.n_awb, va.id_psh, va.vuelo, va.sufijo, va.fecha_gmt, va.origen, v.destino, v.matricula, va.peso, va.retorno, va.volumen, va.uld from ovvueawb va, ovvuelos v where v.fecha_gmt >= to_date('01/08/2008', 'dd/mm/yyyy') and v.fecha_gmt <= to_date('31/08/2008', 'dd/mm/yyyy') and va.n_awb >= '07500000000' and va.n_awb <= '07599999999' and v.vuelo like 'IB3%' and va.vuelo = v.vuelo and va.fecha_gmt = v.fecha_gmt and va.origen = v.origen and va.sufijo = v.sufijo and va.retorno = 'N' and v.activo = 'S' union all select va.n_awb, va.id_psh, va.vuelo, va.sufijo, va.fecha_gmt, va.origen, v.destino, v.matricula, va.peso, va.retorno, va.volumen, va.uld from ovvueciaawb va, ovvueloscias v where v.fecha_gmt >= to_date('01/08/2008', 'dd/mm/yyyy') and v.fecha_gmt <= to_date('31/08/2008', 'dd/mm/yyyy') and va.n_awb >= '07500000000' and va.n_awb <= '07599999999' and v.vuelo like 'IB3%' and va.vuelo = v.vuelo and va.fecha_gmt = v.fecha_gmt and va.origen = v.origen and va.sufijo = v.sufijo and va.retorno = 'N' and v.activo = 'S') va, ovciudadesview ciudadesorigen, ovsumoview sumoorigen, ovciudadesview ciudadesdestino, ovsumoview sumodestino, vcdgen.vcdawb@ocuvue_vcd , vcdgen.vcdgen_fwb@ocuvue_vcd , vcdgen.vcdgen_agt@ocuvue_vcd agtawb, vcdgen.vcdgen_agt@ocuvue_vcd agtfwb where a.n_awb = va.n_awb and ciudadesorigen.ciu_cod_ciu_iata (+) = a.org_awb and ciudadesorigen.ciu_cod_pais = sumoorigen.pai_cod_pais (+) and ciudadesdestino.ciu_cod_ciu_iata (+) = a.dest_awb and ciudadesdestino.ciu_cod_pais = sumodestino.pai_cod_pais (+) and substr(a.n_awb, 1, 3) = awb_cod_cia (+) and substr(a.n_awb, 4) = awb_num_awb (+) and awb_cod_agt = agtawb.agt_cod_agt (+) and awb_cod_pais = agtawb.agt_cod_pais (+) and substr(a.n_awb, 1, 3) = fwb_cod_cia (+) and substr(a.n_awb, 4) = fwb_num_fwb (+) and fwb_cod_agt = agtfwb.agt_cod_agt (+) and fwb_cod_pais = agtfwb.agt_cod_pais (+) and ((substr(sumoorigen.pai_tide, 1, 1) = '2')) and ((substr(sumodestino.pai_tide, 1, 2) = '31') or (substr(sumodestino.pai_tide, 1, 1) = '4') or (substr(sumodestino.pai_tide, 1, 2) = '41') or (substr(sumodestino.pai_tide, 1, 1) = '5') or (substr(sumodestino.pai_tide, 1, 2) = '51') or (substr(sumodestino.pai_tide, 1, 1) = '6') or (substr(sumodestino.pai_tide, 1, 2) = '61'))
7fc345r61jg46	SELECT CEIL("A1"."DIF_HORARIA"/2) FROM "CIBER"."CB_ARPT" "A5", "CIBER"."CB_CIUDAD" "A4", "CIBER"."CB_DISTRITO" "A3", "CIBER"."CB_PAIS" "A2", "CIBER"."CB_HUSOS_HORARIOS" "A1" WHERE "A4"."HUSO_HORARIO"="A1"."HUSO_HORARIO" AND "A5"."ARP_CIU_ID"="A4"."CIU_ID" AND "A4"."CIU_DISTRITO_ID"="A3"."DIS_ID" AND "A3"."DIS_PAIS_ID"="A2"."PAI_ID" AND "A5"."ARP_ID"=:B2 AND "A1"."FECHA_DESDE"<=TRUNC(:B1) AND "A1"."FECHA_HASTA">=TRUNC(:B1) ORDER BY "A2"."PAI_DSC", "A4"."CIU_DSC"
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#
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
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
9b9z4bu0db1ax	SELECT tipo FROM ovtipos_uld WHERE propiedad = 'S' ORDER BY tipo
a73wbv1yu8x5c	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1
at2dqppt1wss5	SELECT "A3"."DIF_HORARIA"/2 FROM "CIBER"."CB_CIUDAD" "A4", "CIBER"."CB_HUSOS_HORARIOS" "A3", "CIBER"."CB_DISTRITO" "A2", "CIBER"."CB_PAIS" "A1" WHERE "A4"."HUSO_HORARIO"="A3"."HUSO_HORARIO" AND "A4"."CIU_DISTRITO_ID"="A2"."DIS_ID" AND "A1"."PAI_ID"="A2"."DIS_PAIS_ID" AND "A4"."CIU_ID"='MAD' AND TRUNC("A3"."FECHA_DESDE")<=TRUNC(SYSDATE@!) AND TRUNC("A3"."FECHA_HASTA")>=TRUNC(SYSDATE@!)
b1pr27t2fa2br	BEGIN CARGACASS_EIS.CALL_CASSEIS; END; �
bbrr9n6xy7pxs	--lab128 select sid, serial#, inst_id, status from gv$px_process where sid is not null
bsa0wjtftg3uw	select file# from file$ where ts#=:1
cg3r8bbafckw7	--lab128 select sid, inst_id, decode(type, 'TM', id1, null) obj_id, type, id1, id2, lmode, lmode "Lock Held", request, request "Lock Request", ctime, kaddr from gv$lock
cqgv56fmuj63x	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
f8pavn1bvsj7t	select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1
fpadd6mkfh5xb	DECLARE sqlstr VARCHAR2(200) := 'alter session set "_optimizer_cost_based_transformation"=''off'''; BEGIN IF (USER = 'CIBERBO') THEN execute immediate sqlstr; END IF; END logon_ciberbo;
g8c2vk3m3mxgv	--lab128 select s.sid, s.ownerid, s.user#, s.sql_id, b.plan_hash_value hash_value , s.sql_child_number, s.seq#, s.event#, s.serial#, userenv('INSTANCE') inst_id , s.row_wait_obj#, s.row_wait_file#, s.row_wait_block#, s.row_wait_row# , s.service_name, p1, p2, p3, s.wait_time, s.seconds_in_wait , decode(s.state, 'WAITING', 0, 1) state , s.blocking_session, 1 blocking_instance , s.plsql_entry_object_id, s.plsql_entry_subprogram_id , s.plsql_object_id, s.plsql_subprogram_id , s.osuser, s.machine, s.terminal, s.program from v$session s, v$sql b where s.sql_id=b.sql_id(+) and s.sql_child_number=b.child_number(+) and sid!=:1 and decode(s.ownerid, 2147483644, 0, 1)!=:2 and nvl(s.module, '-')!=:3 and ((s.status='ACTIVE' and s.username is not null) or (userenv('INSTANCE')-1)*1048576+s.sid in (:4, :5, :6, :7, :8, :9, :10, :11))
ga6tqb86r8n65	select sum(DECODE(m.tipo_carga, 'C', m.peso, 0)) , sum(DECODE(m.tipo_carga, 'M', m.peso, 0)) , sum(DECODE(t.pallet, 'S', DECODE(m.tipo_carga, 'C', 1, 0), 0)) , sum(DECODE(t.pallet, 'S', DECODE(m.tipo_carga, 'M', 1, 0), 0)) , sum(DECODE(t.pallet, 'N', DECODE(m.tipo_carga, 'C', 1, 0), 0)) , sum(DECODE(t.pallet, 'N', DECODE(m.tipo_carga, 'M', 1, 0), 0)) into :b0, :b1, :b2, :b3, :b4, :b5 from ovcmer m , ovtipos_uld t where ((((m.tipo_uld=t.tipo(+) and m.vuelo=:b6) and m.sufijo=:b7) and m.fecha_gmt=to_date(:b8, 'dd/mm/yyyy')) and m.origen=:b9)
ga9j9xk5cy9s0	select /+ index(idl_sb4$ i_idl_sb41) +/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	357,737	99.28	184.40
CPU used when call started	112,678	31.27	58.08
CR blocks created	6,874	1.91	3.54
Cached Commit SCN referenced	69,374	19.25	35.76
Commit SCN cached	3	0.00	0.00
DB time	1,106,470	307.07	570.35
DBWR checkpoint buffers written	425,421	118.06	219.29
DBWR checkpoints	67	0.02	0.03
DBWR object drop buffers written	43	0.01	0.02
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR revisited being-written buffer	347	0.10	0.18
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	421,358	116.94	217.19
DBWR transaction table writes	681	0.19	0.35
DBWR undo block writes	313,146	86.90	161.42
DFO trees parallelized	0	0.00	0.00
DML statements parallelized	0	0.00	0.00
IMU CR rollbacks	291	0.08	0.15
IMU Flushes	1,145	0.32	0.59
IMU Redo allocation size	2,568,508	712.81	1,323.97
IMU commits	993	0.28	0.51
IMU contention	27	0.01	0.01
IMU ktichg flush	13	0.00	0.01
IMU pool not allocated	13	0.00	0.01
IMU recursive-transaction flush	3	0.00	0.00
IMU undo allocation size	7,080,480	1,964.98	3,649.73
IMU- failed to get a private strand	13	0.00	0.01
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations downgraded 25 to 50 pct	0	0.00	0.00
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	2	0.00	0.00
SQL*Net roundtrips to/from client	236,397	65.61	121.85
SQL*Net roundtrips to/from dblink	30,142	8.37	15.54
active txn count during cleanout	104,778	29.08	54.01
application wait time	31	0.01	0.02
background checkpoints completed	39	0.01	0.02
background checkpoints started	39	0.01	0.02
background timeouts	11,483	3.19	5.92
branch node splits	367	0.10	0.19
buffer is not pinned count	11,482,543	3,186.64	5,918.84
buffer is pinned count	14,959,172	4,151.48	7,710.91
bytes received via SQL*Net from client	37,461,322	10,396.29	19,309.96
bytes received via SQL*Net from dblink	3,454,372	958.66	1,780.60
bytes sent via SQL*Net to client	257,520,969	71,467.36	132,742.77
bytes sent via SQL*Net to dblink	3,242,779	899.94	1,671.54
calls to get snapshot scn: kcmgss	504,210	139.93	259.90
calls to kcmgas	602,490	167.20	310.56
calls to kcmgcs	668	0.19	0.34
change write time	9,434	2.62	4.86
cleanout - number of ktugct calls	104,828	29.09	54.04
cleanouts and rollbacks - consistent read gets	1	0.00	0.00
cleanouts only - consistent read gets	16	0.00	0.01
cluster key scan block gets	3,369,890	935.21	1,737.06
cluster key scans	2,072,595	575.19	1,068.35
commit batch performed	12	0.00	0.01
commit batch requested	12	0.00	0.01
commit batch/immediate performed	125	0.03	0.06
commit batch/immediate requested	125	0.03	0.06
commit cleanout failures: block lost	6,359	1.76	3.28
commit cleanout failures: buffer being written	65	0.02	0.03
commit cleanout failures: callback failure	13	0.00	0.01
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	256,077	71.07	132.00
commit cleanouts successfully completed	249,640	69.28	128.68
commit immediate performed	113	0.03	0.06
commit immediate requested	113	0.03	0.06
commit txn count during cleanout	104,485	29.00	53.86
concurrency wait time	913	0.25	0.47
consistent changes	31,178	8.65	16.07
consistent gets	20,946,148	5,812.99	10,796.98
consistent gets - examination	5,176,020	1,436.45	2,668.05
consistent gets direct	0	0.00	0.00
consistent gets from cache	20,946,148	5,812.99	10,796.98
current blocks converted for CR	0	0.00	0.00
cursor authentications	3,235	0.90	1.67
data blocks consistent reads - undo records applied	4,443	1.23	2.29
db block changes	2,666,664	740.05	1,374.57
db block gets	2,701,236	749.65	1,392.39
db block gets direct	245,466	68.12	126.53
db block gets from cache	2,455,770	681.53	1,265.86
deferred (CURRENT) block cleanout applications	13,548	3.76	6.98
dirty buffers inspected	28,363	7.87	14.62
enqueue conversions	202,281	56.14	104.27
enqueue releases	488,849	135.67	251.98
enqueue requests	488,852	135.67	251.99
enqueue timeouts	0	0.00	0.00
enqueue waits	41	0.01	0.02
execute count	296,603	82.31	152.89
failed probes on index block reclamation	2	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	2,163,770	600.49	1,115.35
free buffer requested	2,300,493	638.43	1,185.82
global undo segment hints helped	16	0.00	0.01
global undo segment hints were stale	0	0.00	0.00
heap block compress	159	0.04	0.08
hot buffers moved to head of LRU	164,852	45.75	84.98
immediate (CR) block cleanout applications	17	0.00	0.01
immediate (CURRENT) block cleanout applications	209,201	58.06	107.84
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	18,382	5.10	9.48
index fast full scans (direct read)	0	0.00	0.00
index fast full scans (full)	400	0.11	0.21
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	4,516,901	1,253.53	2,328.30
index scans kdiixs1	370,954	102.95	191.21
leaf node 90-10 splits	103,966	28.85	53.59
leaf node splits	103,990	28.86	53.60
lob reads	3,937	1.09	2.03
lob writes	5,779	1.60	2.98
lob writes unaligned	5,779	1.60	2.98
logons cumulative	1,137	0.32	0.59
messages received	12,483	3.46	6.43
messages sent	12,483	3.46	6.43
no buffer to keep pinned count	20	0.01	0.01
no work - consistent read gets	15,358,757	4,262.37	7,916.89
opened cursors cumulative	124,180	34.46	64.01
parse count (failures)	4	0.00	0.00
parse count (hard)	9,654	2.68	4.98
parse count (total)	79,561	22.08	41.01
parse time cpu	6,937	1.93	3.58
parse time elapsed	10,613	2.95	5.47
physical read IO requests	571,448	158.59	294.56
physical read bytes	21,711,314,944	6,025,335.67	11,191,399.46
physical read total IO requests	584,360	162.17	301.22
physical read total bytes	21,815,891,968	6,054,357.94	11,245,305.14
physical read total multi block requests	61,505	17.07	31.70
physical reads	2,650,307	735.51	1,366.14
physical reads cache	1,869,233	518.75	963.52
physical reads cache prefetch	1,366,312	379.18	704.28
physical reads direct	781,074	216.76	402.62
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	778,993	216.19	401.54
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	374,397	103.90	192.99
physical write bytes	13,712,605,184	3,805,529.48	7,068,353.19
physical write total IO requests	108,061	29.99	55.70
physical write total bytes	20,806,364,160	5,774,193.24	10,724,929.98
physical write total multi block requests	80,593	22.37	41.54
physical writes	1,673,902	464.54	862.84
physical writes direct	1,208,300	335.33	622.84
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	961,898	266.95	495.82
physical writes from cache	465,602	129.21	240.00
physical writes non checkpoint	1,627,322	451.62	838.83
pinned buffers inspected	1	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
process last non-idle time	3,656	1.01	1.88
queries parallelized	0	0.00	0.00
recursive calls	1,828,794	507.53	942.68
recursive cpu usage	188,713	52.37	97.27
redo blocks written	6,882,349	1,909.99	3,547.60
redo buffer allocation retries	716	0.20	0.37
redo entries	1,336,010	370.77	688.66
redo log space requests	240	0.07	0.12
redo log space wait time	1,484	0.41	0.76
redo ordering marks	331,495	92.00	170.87
redo size	3,417,397,188	948,397.88	1,761,544.94
redo subscn max counts	419,396	116.39	216.18
redo synch time	3,875	1.08	2.00
redo synch writes	6,399	1.78	3.30
redo wastage	1,587,760	440.64	818.43
redo write time	24,576	6.82	12.67
redo writer latching time	6	0.00	0.00
redo writes	6,249	1.73	3.22
rollback changes - undo records applied	419	0.12	0.22
rollbacks only - consistent read gets	4,192	1.16	2.16
rows fetched via callback	2,486,815	690.14	1,281.86
session connect time	0	0.00	0.00
session cursor cache hits	92,831	25.76	47.85
session logical reads	23,647,386	6,562.64	12,189.37
session pga memory	96,768,328	26,855.20	49,880.58
session pga memory max	182,030,664	50,517.25	93,830.24
session uga memory	###############	71,508,832.45	132,819,805.05
session uga memory max	673,038,560	186,782.02	346,927.09
shared hash latch upgrades - no wait	32,998	9.16	17.01
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	4	0.00	0.00
sorts (memory)	50,481	14.01	26.02
sorts (rows)	23,071,437	6,402.80	11,892.49
sql area evicted	4,167	1.16	2.15
sql area purged	12	0.00	0.01
summed dirty queue length	63,863	17.72	32.92
switch current to new buffer	173	0.05	0.09
table fetch by rowid	8,862,467	2,459.52	4,568.28
table fetch continued row	231,879	64.35	119.53
table scan blocks gotten	8,731,111	2,423.06	4,500.57
table scan rows gotten	914,606,409	253,822.06	471,446.60
table scans (cache partitions)	0	0.00	0.00
table scans (direct read)	0	0.00	0.00
table scans (long tables)	39	0.01	0.02
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	24,600	6.83	12.68
total number of times SMON posted	55	0.02	0.03
transaction rollbacks	125	0.03	0.06
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	1,555,832,656	431,775.51	801,975.60
user I/O wait time	180,697	50.15	93.14
user calls	367,478	101.98	189.42
user commits	1,767	0.49	0.91
user rollbacks	173	0.05	0.09
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	22	0.01	0.01
workarea executions - optimal	33,347	9.25	17.19
write clones created in background	91	0.03	0.05
write clones created in foreground	1,528	0.42	0.79

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	2,635,365	2,648,014
opened cursors current	913	863
workarea memory allocated	58,884	48,553
logons current	146	145

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)	39	38.96

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
TS_UNDO	158	0	20.19	1.00	223,836	62	86	35.12
TS_BP_ALTA	156,365	43	1.30	1.00	46	0	0	0.00
TS_OCUVUE	111,701	31	1.83	1.00	1,273	0	772	0.48
TEMP	59,686	17	15.65	13.04	45,904	13	0	0.00
SYSAUX	94,623	26	0.71	1.00	1,295	0	0	0.00
TS_XCASS	3,182	1	2.66	1.02	89,180	25	0	0.00
TS_XREV	48,615	13	0.86	1.00	16	0	0	0.00
TS_CASS	25,934	7	22.64	53.54	9,061	3	0	0.00
TS_RAM	23,185	6	0.71	1.00	17	0	0	0.00
TS_XRAM	10,222	3	0.77	1.00	16	0	0	0.00
TS_REV	9,046	3	2.92	1.00	16	0	0	0.00
TS_XCB_ALTA	4,644	1	7.44	1.00	95	0	0	0.00
TS_XBP_ALTA	1,744	0	4.81	1.00	2,195	1	0	0.00
TS_CMT	3,631	1	0.71	1.00	16	0	0	0.00
PERFSTAT	3,444	1	1.15	1.00	30	0	0	0.00
TS_XOCUVUE	2,245	1	15.48	1.00	402	0	0	0.00
TS_CB_ALTA	2,577	1	4.67	1.00	62	0	0	0.00
TS_ALMA	2,443	1	0.75	1.00	16	0	0	0.00
SYSTEM	1,387	0	9.79	1.00	631	0	0	0.00
TS_XCB_MEDIA	1,378	0	1.87	1.00	31	0	0	0.00
TS_PATROL	1,302	0	1.15	1.00	15	0	0	0.00
TS_XCB_BAJA	1,036	0	1.31	1.00	16	0	0	0.00
TS_CB_MEDIA	916	0	1.75	1.00	16	0	0	0.00
TS_MTCQ	571	0	1.31	1.00	16	0	0	0.00
TS_XMTCQ	451	0	1.35	1.00	16	0	0	0.00
TS_XBP_MEDIA	377	0	2.15	1.00	16	0	0	0.00
TS_RAMCASS	271	0	1.88	1.00	16	0	0	0.00
TS_DEFECTO	196	0	2.24	1.00	16	0	0	0.00
TS_XBP_BAJA	196	0	3.11	1.00	16	0	0	0.00
TS_CB_BAJA	136	0	2.87	1.00	16	0	0	0.00
TS_TABLA	136	0	3.24	1.00	16	0	0	0.00
TS_BP_BAJA	124	0	3.31	1.00	16	0	0	0.00
TS_BP_MEDIA	103	0	6.60	1.00	16	0	0	0.00
TS_XCMT	31	0	9.35	1.00	16	0	0	0.00
TS_XRAMCASS	31	0	10.32	1.00	16	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
PERFSTAT	/ciberd/user/bpns/perfstat.dbf	3,402	1	1.09	1.00	15	0	0	0.00
PERFSTAT	/ciberd/user/bpns/perfstat1.dbf	42	0	6.19	1.00	15	0	0	0.00
SYSAUX	/ciberc/admin/system/sysaux01.dbf	94,623	26	0.71	1.00	1,295	0	0	0.00
SYSTEM	/ciberc/admin/system/system.dbf	1,387	0	9.79	1.00	631	0	0	0.00
TEMP	/cibert/admin/system/temp.dbf	29,000	8	16.67	17.98	27,914	8	0
TEMP	/cibert/admin/system/temp1.dbf	30,677	9	14.69	8.37	17,981	5	0
TEMP	/cibert/admin/system/temp3.dbf	9	0	0.00	15.00	9	0	0
TS_ALMA	/ciberd/user/comun/ts_alma.dbf	2,443	1	0.75	1.00	16	0	0	0.00
TS_BP_ALTA	/ciberb/user/bpns/bp_alta.dbf	128,510	36	1.22	1.00	16	0	0	0.00
TS_BP_ALTA	/ciberb/user/bpns/bp_alta2.dbf	27,813	8	1.64	1.00	15	0	0	0.00
TS_BP_ALTA	/ciberd/user/bpns/xbp_alta03.dbf	42	0	6.43	1.00	15	0	0	0.00
TS_BP_BAJA	/ciberb/user/bpns/bp_baja.dbf	124	0	3.31	1.00	16	0	0	0.00
TS_BP_MEDIA	/ciberd/user/bpns/bp_media.dbf	103	0	6.60	1.00	16	0	0	0.00
TS_CASS	/ciberd/user/cass/ts_cass1.dbf	7,118	2	25.45	55.17	2,174	1	0	0.00
TS_CASS	/ciberd/user/cass/ts_cass2.dbf	6,985	2	24.32	59.51	2,210	1	0	0.00
TS_CASS	/ciberd/user/cass/ts_cass3.dbf	7,093	2	21.62	56.76	2,465	1	0	0.00
TS_CASS	/ciberd/user/cass/ts_cass4.dbf	4,738	1	17.45	37.47	2,212	1	0	0.00
TS_CB_ALTA	/cibera/user/ciber/cb_alta.dbf	616	0	2.29	1.00	16	0	0	0.00
TS_CB_ALTA	/cibera/user/ciber/cb_alta2.dbf	414	0	5.02	1.00	16	0	0	0.00
TS_CB_ALTA	/cibera/user/ciber/cb_alta3.dbf	962	0	4.79	1.00	15	0	0	0.00
TS_CB_ALTA	/cibera/user/ciber/cb_alta4.dbf	585	0	6.74	1.00	15	0	0	0.00
TS_CB_BAJA	/ciberc/user/ciber/cb_baja.dbf	136	0	2.87	1.00	16	0	0	0.00
TS_CB_MEDIA	/ciberb/user/ciber/cb_media.dbf	916	0	1.75	1.00	16	0	0	0.00
TS_CMT	/cibere/user/cmt/ts_cmt.dbf	3,631	1	0.71	1.00	16	0	0	0.00
TS_DEFECTO	/ciberd/user/comun/defecto.dbf	196	0	2.24	1.00	16	0	0	0.00
TS_MTCQ	/ciberd/user/mtcq/mtcq.dbf	571	0	1.31	1.00	16	0	0	0.00
TS_OCUVUE	/ciberb/user/ocuvue/ocuvue.dbf	48,815	14	1.80	1.00	36	0	772	0.48
TS_OCUVUE	/ciberb/user/ocuvue/ocuvue2.dbf	23,686	7	1.84	1.00	260	0	0	0.00
TS_OCUVUE	/ciberb/user/ocuvue/ocuvue3.dbf	23,189	6	1.20	1.00	86	0	0	0.00
TS_OCUVUE	/ciberb/user/ocuvue/ocuvue4.dbf	11,799	3	1.96	1.00	651	0	0	0.00
TS_OCUVUE	/ciberb/user/ocuvue/ocuvue5.dbf	3,017	1	3.82	1.00	134	0	0	0.00
TS_OCUVUE	/ciberb/user/ocuvue/ocuvue6.dbf	1,195	0	9.06	1.00	106	0	0	0.00
TS_PATROL	/ciberc/user/patrol/ts_patrol.dbf	1,302	0	1.15	1.00	15	0	0	0.00
TS_RAM	/ciberb/user/ramadm/ram.dbf	23,185	6	0.71	1.00	17	0	0	0.00
TS_RAMCASS	/ciberd/user/ramadmcass/ts_ramcass1.dbf	271	0	1.88	1.00	16	0	0	0.00
TS_REV	/cibere/user/rev/ts_rev.dbf	9,046	3	2.92	1.00	16	0	0	0.00
TS_TABLA	/ciberc/user/ciber/ts_tabla.dbf	136	0	3.24	1.00	16	0	0	0.00
TS_UNDO	/ciberr/admin/system/ts_undo.dbf	46	0	25.65	1.00	44,932	12	16	45.00
TS_UNDO	/ciberr/admin/system/ts_undo01.dbf	17	0	20.59	1.00	45,563	13	70	32.86
TS_UNDO	/ciberr/admin/system/ts_undo02.dbf	31	0	10.65	1.00	36,854	10	0	0.00
TS_UNDO	/ciberr/admin/system/ts_undo03.dbf	32	0	28.13	1.00	46,234	13	0	0.00
TS_UNDO	/ciberr/admin/system/ts_undo04.dbf	32	0	13.44	1.00	50,253	14	0	0.00
TS_XBP_ALTA	/ciberd/user/bpns/xbp_alta.dbf	297	0	5.79	1.00	179	0	0	0.00
TS_XBP_ALTA	/ciberd/user/bpns/xbp_alta02.dbf	264	0	9.36	1.00	609	0	0	0.00
TS_XBP_ALTA	/ciberd/user/bpns/xbp_alta04.dbf	939	0	2.13	1.00	720	0	0	0.00
TS_XBP_ALTA	/ciberd/user/bpns/xbp_alta05.dbf	171	0	7.78	1.00	312	0	0	0.00
TS_XBP_ALTA	/ciberd/user/bpns/xbp_alta06.dbf	73	0	11.78	1.00	375	0	0	0.00
TS_XBP_BAJA	/cibera/user/bpns/xbp_baja.dbf	196	0	3.11	1.00	16	0	0	0.00
TS_XBP_MEDIA	/ciberb/user/bpns/xbp_media.dbf	377	0	2.15	1.00	16	0	0	0.00
TS_XCASS	/ciberc/user/cass/ts_xcass1.dbf	956	0	1.63	1.03	17,632	5	0	0.00
TS_XCASS	/ciberc/user/cass/ts_xcass2.dbf	1,654	0	1.28	1.03	18,705	5	0	0.00
TS_XCASS	/ciberc/user/cass/ts_xcass3.dbf	412	0	4.17	1.00	17,267	5	0	0.00
TS_XCASS	/ciberc/user/cass/ts_xcass4.dbf	99	0	17.47	1.00	17,329	5	0	0.00
TS_XCASS	/ciberc/user/cass/ts_xcass5.dbf	61	0	22.13	1.00	18,247	5	0	0.00
TS_XCB_ALTA	/ciberc/user/ciber/xcb_alta01.dbf	616	0	1.79	1.00	16	0	0	0.00
TS_XCB_ALTA	/ciberc/user/ciber/xcb_alta02.dbf	727	0	8.18	1.00	16	0	0	0.00
TS_XCB_ALTA	/ciberc/user/ciber/xcb_alta03.dbf	394	0	12.26	1.00	16	0	0	0.00
TS_XCB_ALTA	/ciberc/user/ciber/xcb_alta04	1,253	0	8.63	1.00	16	0	0	0.00
TS_XCB_ALTA	/ciberc/user/ciber/xcb_alta06.dbf	321	0	9.50	1.00	16	0	0	0.00
TS_XCB_ALTA	/ciberc/user/ciber/xcb_alta5.dbf	1,333	0	6.60	1.00	15	0	0	0.00
TS_XCB_BAJA	/ciberb/user/ciber/xcb_baja.dbf	1,036	0	1.31	1.00	16	0	0	0.00
TS_XCB_MEDIA	/ciberd/user/ciber/xcb_media.dbf	1,336	0	1.72	1.00	16	0	0	0.00
TS_XCB_MEDIA	/ciberd/user/ciber/xcb_media2.dbf	42	0	6.43	1.00	15	0	0	0.00
TS_XCMT	/ciberf/user/cmt/TS_XCMT1.dbf	31	0	9.35	1.00	16	0	0	0.00
TS_XMTCQ	/ciberc/user/mtcq/xmtcq.dbf	451	0	1.35	1.00	16	0	0	0.00
TS_XOCUVUE	/ciberc/user/ocuvue/xocuvue.dbf	1,475	0	15.15	1.00	211	0	0	0.00
TS_XOCUVUE	/ciberc/user/ocuvue/xocuvue2.dbf	770	0	16.13	1.00	191	0	0	0.00
TS_XRAM	/ciberc/user/ramadm/xram.dbf	10,222	3	0.77	1.00	16	0	0	0.00
TS_XRAMCASS	/ciberc/user/ramadmcass/ts_xramcass1.dbf	31	0	10.32	1.00	16	0	0	0.00
TS_XREV	/ciberf/user/rev/ts_xrev.dbf	48,615	13	0.86	1.00	16	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	283,264	92	23,399,641	1,870,689	465,602	0	0	858

Advisory Statistics

Instance Recovery Stats
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	17	907	4607	10000	530820		10000
E	0	17	975	3742	10000	530820		10000

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	224	0.10	27,706	2.76	289,188,961
D	448	0.19	55,412	2.24	234,373,759
D	672	0.29	83,118	1.87	196,075,335
D	896	0.39	110,824	1.60	168,001,457
D	1,120	0.49	138,530	1.41	147,620,489
D	1,344	0.58	166,236	1.27	132,897,681
D	1,568	0.68	193,942	1.17	122,232,847
D	1,792	0.78	221,648	1.09	114,608,368
D	2,016	0.88	249,354	1.04	109,201,077
D	2,240	0.97	277,060	1.01	105,447,705
D	2,304	1.00	284,976	1.00	104,708,864
D	2,464	1.07	304,766	0.98	102,861,736
D	2,688	1.17	332,472	0.97	101,519,282
D	2,912	1.26	360,178	0.96	100,499,560
D	3,136	1.36	387,884	0.95	99,603,647
D	3,360	1.46	415,590	0.94	98,787,329
D	3,584	1.56	443,296	0.94	98,001,060
D	3,808	1.65	471,002	0.93	97,221,898
D	4,032	1.75	498,708	0.92	96,424,936
D	4,256	1.85	526,414	0.91	95,616,197
D	4,480	1.94	554,120	0.90	94,669,742

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
60.55	11,724	7,638

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	300	115	360.33	57.50	15.96	100.00	0.00	61,440
E	300	117	345.37	47.42	13.73	91.36	8.64	61,440

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs
2K	4K	29,289	29,289	0
64K	128K	17	17	0
128K	256K	2	2	0
256K	512K	120	120	0
512K	1024K	3,086	3,086	0
1M	2M	818	818	0
2M	4M	14	8	6
4M	8M	4	4	0
32M	64M	4	4	0
64M	128M	8	0	8
128M	256M	4	0	4
512M	1024M	2	0	2
2G	4G	2	0	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
38	0.13	493,576.16	723,349.19	41.00	14,758
75	0.25	493,576.16	719,290.28	41.00	14,225
150	0.50	493,576.16	390,381.88	56.00	617
225	0.75	493,576.16	181,236.11	73.00	6
300	1.00	493,576.16	128,154.50	79.00	0
360	1.20	493,576.16	92,363.07	84.00	0
420	1.40	493,576.16	90,135.61	85.00	0
480	1.60	493,576.16	89,471.37	85.00	0
540	1.80	493,576.16	88,157.44	85.00	0
600	2.00	493,576.16	85,110.70	85.00	0
900	3.00	493,576.16	81,363.54	86.00	0
1,200	4.00	493,576.16	81,363.54	86.00	0
1,800	6.00	493,576.16	81,363.54	86.00	0
2,400	8.00	493,576.16	81,363.54	86.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
176	0.31	79	5,759	8,890,016	0.96	384,514	44.06	109,654,234
240	0.43	139	9,749	8,959,828	0.97	314,702	36.06	109,683,832
304	0.54	199	13,367	9,037,180	0.98	237,350	27.19	109,710,152
368	0.66	261	16,967	9,102,737	0.98	171,793	19.68	109,733,463
432	0.77	324	21,369	9,162,721	0.99	111,809	12.81	109,754,693
496	0.89	387	25,825	9,216,972	0.99	57,558	6.59	109,774,195
560	1.00	450	30,191	9,265,802	1.00	8,728	1.00	109,792,000
624	1.11	513	35,466	9,309,181	1.00	1	0.00	109,808,038
688	1.23	576	41,437	9,347,591	1.01	1	0.00	109,822,557
752	1.34	639	46,002	9,381,832	1.01	1	0.00	109,835,867
816	1.46	687	49,445	9,412,512	1.02	1	0.00	109,848,217
880	1.57	750	52,355	9,440,080	1.02	1	0.00	109,859,798
944	1.69	813	57,509	9,465,185	1.02	1	0.00	109,870,772
1,008	1.80	876	61,682	9,488,833	1.02	1	0.00	109,881,281
1,072	1.91	939	66,176	9,511,600	1.03	1	0.00	109,891,511
1,136	2.03	1,002	70,825	9,533,145	1.03	1	0.00	109,901,619

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
752	0.25	871,089	289,179,257
1,504	0.50	597,351	168,002,070
2,256	0.75	524,664	122,234,725
3,008	1.00	500,252	104,706,806
3,760	1.25	493,148	99,597,114
4,512	1.50	489,797	97,220,269
5,264	1.75	486,302	94,665,423
6,016	2.00	486,303	94,665,423

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	0.33	0	0	0	0
32	0.67	0	0	0	0
48	1.00	0	0	0	0
64	1.33	0	0	0	0
80	1.67	0	0	0	0
96	2.00	0	0	0	0
112	2.33	0	0	0	0
128	2.67	0	0	0	0
144	3.00	0	0	0	0
160	3.33	0	0	0	0
176	3.67	0	0	0	0
192	4.00	0	0	0	0
208	4.33	0	0	0	0
224	4.67	0	0	0	0
240	5.00	0	0	0	0
256	5.33	0	0	0	0
272	5.67	0	0	0	0
288	6.00	0	0	0	0
304	6.33	0	0	0	0
320	6.67	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
undo header	86	3	35
data block	772	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data
ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Waits	Av Wt Time(ms)
RO-Multiple Object Reuse (fast object reuse)	252	252	28	5.89
DX-Distributed Transaction	481,697	481,697	12	10.75
CU-Cursor	12,189	12,189	1	31.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
41	434.81	153,006	1,377	12	97.7/719.6	0/0	0/0/0/67/354048/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
28-Oct 13:05	180	1,016	1,377	12	117	0/0	0/0/0/0/0/0
28-Oct 12:55	104	1,273	778	10	107	0/0	0/0/0/0/0/0
28-Oct 12:45	238,242	80,740	311	11	98	0/0	0/0/0/38/231936/0
28-Oct 12:35	69	915	921	10	408	0/0	0/0/0/0/0/0
28-Oct 12:25	16,655	6,442	320	10	398	0/0	0/0/0/5/13440/0
28-Oct 12:15	57,584	20,952	378	10	400	0/0	0/0/0/2/12288/0
28-Oct 12:05	121,979	41,668	306	10	720	0/0	0/0/0/22/96384/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Parent Latch Statistics
Child Latch Statistics

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,733	0.00		0
AWR Alerted Metric Element list	22,437	0.00		0
Consistent RBA	6,291	0.00		0
FOB s.o list latch	5,626	0.00		0
In memory undo latch	19,433	0.00		3,374	0.03
JS broadcast kill buf latch	8	0.00		0
JS queue state obj latch	21,556	0.00		0
JS slv state obj latch	180	0.00		0
KMG MMAN ready and startup request latch	1,215	0.00		0
KMG resize request state object freelist	12	0.00		0
KTF sga latch	98	0.00		992	0.00
KWQMN job cache list latch	19	0.00		0
KWQP Prop Status	2	0.00		0
MQL Tracking Latch	0			72	0.00
Memory Management Latch	86	0.00		1,210	0.00
OS process	3,618	0.00		0
OS process allocation	3,611	0.00		0
OS process: request allocation	2,163	0.00		0
PL/SQL warning settings	4,041	0.00		0
SGA IO buffer pool latch	18,652	0.00		19,256	0.00
SQL memory manager latch	4	0.00		1,197	0.00
SQL memory manager workarea list latch	99,660	0.00		0
Shared B-Tree	138	0.00		0
Undo Hint Latch	0			39	0.00
active checkpoint queue latch	7,320	0.00		0
active service list	11,314	0.00		1,431	0.00
archive control	26	0.00		0
begin backup scn array	8,833	0.00		0
buffer pool	216	0.00		0
cache buffer handles	12,156	0.00		0
cache buffers chains	50,712,704	0.01	0.01	3,819,688	0.01
cache buffers lru chain	960,111	0.74	0.01	4,289,915	0.19
cache table scan latch	0			12,135	0.00
channel handle pool latch	2,233	0.00		0
channel operations parent latch	26,472	0.00		0
checkpoint queue latch	557,689	0.05	0.00	454,382	0.09
client/application info	7,262	0.00		0
commit callback allocation	46	0.00		0
compile environment latch	17,070	0.00		0
constraint object allocation	8	0.00		0
dictionary lookup	38	0.00		0
dml lock allocation	38,246	0.00		0
dummy allocation	2,283	0.00		0
enqueue hash chains	1,180,070	0.02	0.02	5,522	0.00
enqueues	732,726	0.05	0.01	0
event group latch	1,081	0.00		0
file cache latch	4,077	0.00		0
global KZLD latch for mem in SGA	1,018	0.00		0
global tx hash mapping	293,070	0.00		0
hash table column usage latch	1,458	0.00		550,735	0.00
hash table modification latch	103	0.00		0
job workq parent latch	0			120	0.00
job_queue_processes parameter latch	120	0.00		0
kks stats	45,471	0.00		0
ksuosstats global area	1,442	0.14	1.00	0
ktm global data	60	0.00		0
kwqbsn:qsga	137	0.00		0
lgwr LWN SCN	6,519	0.02	0.00	0
library cache	800,513	0.05	0.06	39,899	0.06
library cache load lock	26,526	0.00		3	0.00
library cache lock	388,770	0.01	0.00	53	0.00
library cache lock allocation	9,708	0.00		0
library cache pin	191,193	0.00	0.00	1	0.00
library cache pin allocation	3,438	0.00		0
list of block allocation	6,855	0.00		0
loader state object freelist	848	0.00		0
logminer context allocation	1	0.00		0
longop free list parent	41	0.00		40	0.00
message pool operations parent latch	204	0.00		0
messages	57,502	0.02	0.00	0
mostly latch-free SCN	6,544	0.03	0.00	0
multiblock read objects	107,900	0.00	0.00	0
ncodef allocation latch	68	0.00		0
object queue header heap	23,428	0.00		10,852	0.00
object queue header operation	5,990,478	0.10	0.00	5,727	0.00
object stats modification	95	0.00		0
parallel query alloc buffer	476	0.00		0
parameter list	3,150	0.00		0
parameter table allocation management	2,865	0.00		0
post/wait queue	5,910	0.00		2,572	0.00
process allocation	2,163	0.05	0.00	1,080	0.09
process group creation	2,163	0.00		0
qmn task queue latch	887	0.23	0.50	0
redo allocation	34,013	0.21	0.01	1,336,112	0.01
redo copy	0			1,336,172	0.07
redo writing	29,384	0.02	0.00	0
resmgr group change latch	1,608	0.00		0
resmgr:actses active list	2,890	0.00		0
resmgr:actses change group	1,099	0.00		0
resmgr:free threads list	2,279	0.00		0
resmgr:schema config	601	0.00		0
resumable state object	2	0.00		0
row cache objects	3,114,858	0.02	0.00	19,250	0.02
rules engine aggregate statistics	1	0.00		0
rules engine rule set statistics	102	0.00		0
sequence cache	4,154	0.00		0
session allocation	1,603,700	0.15	0.00	0
session idle bit	750,968	0.00	0.00	0
session state list latch	2,053	0.00		0
session switching	68	0.00		0
session timer	1,429	0.00		0
shared pool	786,987	0.21	0.06	0
shared pool sim alloc	21	0.00		0
shared pool simulator	705,953	0.00		0
simulator hash latch	3,283,962	0.00	0.00	0
simulator lru latch	1,668,605	0.12	0.00	1,351,385	0.00
slave class	2	0.00		0
slave class create	8	12.50	1.00	0
sort extent pool	9,893	0.01	0.00	0
state object free list	2	0.00		0
statistics aggregation	112	0.00		0
temp lob duration state obj allocation	3	0.00		0
temporary table state object allocation	4	0.00		0
threshold alerts latch	883	0.00		0
transaction allocation	5,151,488	0.00	0.00	0
transaction branch allocation	286,835	0.00	0.00	0
undo global data	524,071	0.00	0.14	0
user lock	4,280	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers lru chain	960,111	7,078	47	7,032
object queue header operation	5,990,478	6,002	16	5,986
cache buffers chains	50,712,704	3,692	36	3,656
session allocation	1,603,700	2,463	6	2,457
simulator lru latch	1,668,605	2,060	10	2,050
shared pool	786,987	1,632	98	1,535
enqueues	732,726	396	2	394
library cache	800,513	395	23	376
enqueue hash chains	1,180,070	186	4	182
redo allocation	34,013	71	1	70
undo global data	524,071	7	1	6
ksuosstats global area	1,442	2	2	0
qmn task queue latch	887	2	1	1
slave class create	8	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 buffers chains	kcbbxsv	30	3
cache buffers chains	kcbgtcr: kslbegin excl	15	12
cache buffers chains	kcbgcur: kslbegin	3	2
cache buffers chains	kcbgtcr: fast path	2	1
cache buffers chains	kcbget: exchange rls	1	0
cache buffers chains	kcbzhngcbk1: get hash chain latch no wait	1	0
cache buffers chains	kcbzwb	1	0
cache buffers lru chain	kcbzgws	42	3
cache buffers lru chain	kcbbxsv: move to being written	2	33
cache buffers lru chain	kcbzgb: posted for free bufs	2	0
cache buffers lru chain	kcbzar: KSLNBEGIN	1	0
enqueue hash chains	ksqcnl	2	0
enqueue hash chains	ksqgtl3	1	1
enqueue hash chains	ksqrcl	1	3
enqueues	ksqgel: create enqueue	2	2
event range base latch	No latch	1	1
ksuosstats global area	ksugetosstat	2	2
library cache	kglic	13	0
library cache	kglScanDependency	9	0
object queue header operation	kcbo_switch_mq_bg	14	12
object queue header operation	kcbw_unlink_q	7	9
object queue header operation	kcbo_switch_cq	6	9
object queue header operation	kcbw_link_q	5	1
object queue header operation	kcbo_switch_q_bg	3	3
redo allocation	kcrfw_redo_gen: redo allocation 1	1	0
session allocation	ksuxds: KSUSFCLC not set	6	0
shared pool	kghalo	78	48
shared pool	kghupr1	5	24
shared pool	kghfrunp: alloc: session dur	4	0
shared pool	kghfrunp: alloc: wait	4	0
shared pool	kghalp	3	8
shared pool	kgh: quiesce extents	1	0
shared pool	kghasp	1	4
shared pool	kghfen: not perm alloc class	1	0
shared pool	kghfre	1	10
shared pool	kghfrunp: clatch: nowait	1	0
simulator lru latch	kcbs_simulate: simulate set	5	8
simulator lru latch	kcbs_simbufseq	4	2
simulator lru latch	kcbs_lookup_setid	1	0
slave class create	ksvcreate	1	0
undo global data	ktubnd:child	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 23,647,386
Captured Segments account for 86.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
OCUVUE	TS_OCUVUE	OVCMER	TABLE	6,156,352	26.03
SYS	SYSTEM	SEG$	TABLE	1,725,840	7.30
SYS	SYSTEM	FILE$	TABLE	1,352,688	5.72
CASS	TS_XCASS	I_SNAP$_MV_AGNTPAISDEST	INDEX	1,182,496	5.00
OCUVUE	TS_OCUVUE	OVVUELOS	TABLE	1,064,768	4.50

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 2,650,307
Captured Segments account for 59.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
CASS	TS_CASS	CASS_DATOS_01	P2007	TABLE PARTITION	266,701	10.06
CASS	TS_CASS	CASS_DATOS_01	P2006	TABLE PARTITION	252,166	9.51
CASS	TS_CASS	CASS_DATOS_01	P2005	TABLE PARTITION	246,342	9.29
CASS	TS_CASS	CASS_DATOS_01	P2004	TABLE PARTITION	227,846	8.60
CASS	TS_CASS	CASS_DATOS_01	P2008	TABLE PARTITION	223,641	8.44

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
OCUVUE	TS_XOCUVUE	PK_OVVUELOS	INDEX	46	31.51
OCUVUE	TS_OCUVUE	FK_CCAHFWBS	INDEX	45	30.82
OCUVUE	TS_OCUVUE	PK_CCAHAWB	INDEX	37	25.34
OCUVUE	TS_OCUVUE	PK_CCAHVUE	INDEX	16	10.96
SYSMAN	SYSAUX	MGMT_METRICS_1HOUR_PK	INDEX	1	0.68

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	65	0.00	2	1
dc_database_links	40,133	0.07	0	5
dc_files	3,311	17.79	0	58
dc_free_extents	39	100.00	0	0
dc_global_oids	5,530	2.77	0	15
dc_histogram_data	146,914	8.40	0	1,597
dc_histogram_defs	134,031	12.54	0	1,328
dc_object_grants	2,112	30.54	0	81
dc_object_ids	298,889	1.09	4	425
dc_objects	31,250	14.87	61	348
dc_profiles	1,077	0.00	0	1
dc_rollback_segments	1,473	0.00	0	24
dc_segments	30,625	12.26	2,987	388
dc_sequences	401	3.74	401	1
dc_table_scns	469	4.69	0	1
dc_tablespace_quotas	2,944	0.34	2,944	1
dc_tablespaces	89,057	0.11	0	35
dc_usernames	7,750	0.54	0	6
dc_users	328,636	0.04	0	64
kqlsubheap_object	2,127	3.53	0	6
outstanding_alerts	405	96.05	1	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	839	2.62	8,808	1.85	140	0
CLUSTER	1,020	1.18	2,290	1.31	18	0
INDEX	120	44.17	376	26.86	44	0
PIPE	12	33.33	12	33.33	0	0
SQL AREA	13,332	48.62	401,417	7.52	5,870	2,778
TABLE/PROCEDURE	16,625	8.60	86,013	14.69	5,977	0
TRIGGER	62	9.68	2,649	2.15	51	0

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

B: Begin snap E: End snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	232.42		1.59	5.91	69	72	146	146
	SQL	82.23	77.68	0.59	6.27	74	79	140	139
	Freeable	40.88	0.00	0.55	0.41	2		74	74
	PL/SQL	4.50	3.40	0.03	0.02	0	6	146	146
E	Other	275.08		1.90	6.98	69	72	145	145
	Freeable	44.13	0.00	0.59	0.41	2		75	75
	SQL	21.71	17.00	0.16	1.14	13	88	139	138
	PL/SQL	4.53	3.37	0.03	0.02	0	6	145	145

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	2,415,919,104
Fixed Size	2,076,176
Redo Buffers	14,700,544
Variable Size	721,420,784

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	64.00	64.00	0.00
large	free memory	15.94	15.94	0.00
shared	Cursor Stats	15.11	15.11	0.00
shared	KGH: NO ACCESS	227.09	258.86	13.99
shared	db_block_hash_buckets	22.50	22.50	0.00
shared	free memory	391.09	390.87	-0.06
shared	kglsim object batch	16.67	16.71	0.27
shared	ktcmvcb	577.54	577.58	0.01
streams	free memory	47.91	47.91	0.00
	buffer_cache	2,304.00	2,304.00	0.00
	fixed_sga	1.98	1.98	0.00
	log_buffer	14.02	14.02	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

Streams processes ordered by CPU usage
CPU and I/O Time in micro seconds

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Slaves	633,266	41,087	0
QMON Coordinator	62,255	0	0

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

Rule Sets ordered by Evaluations

Ruleset Name	Evals	Fast Evals	SQL Execs	CPU Time	Elapsed Time
SYS.ALERT_QUE_R	1	0	0	18	38

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
background_dump_dest	/apli/app/oracle/admin/PROD15/bdump
compatible	10.0.0
control_files	/ciberb/admin/system/control01.ctl, /ciberd/admin/system/control02.ctl, /cibera/admin/system/control03.ctl
core_dump_dest	/apli/app/oracle/admin/PROD15/cdump
db_block_size	8192
db_cache_size	2097152000
db_file_multiblock_read_count	1
db_files	300
db_name	PROD15
dml_locks	748
event	10258 trace name context forever, level 4, 1115 trace name errorstack level 12
global_names	FALSE
instance_name	PROD15
java_pool_size	67108864
job_queue_processes	2
large_pool_size	16777216
log_buffer	14254080
log_checkpoint_interval	10000
log_checkpoint_timeout	0
max_dump_file_size	10240
open_cursors	1500
os_authent_prefix
parallel_max_servers	8
parallel_min_servers	0
pga_aggregate_target	314572800
processes	300
query_rewrite_enabled	TRUE
query_rewrite_integrity	trusted
remote_login_passwordfile	NONE
service_names	PROD15
session_max_open_files	20
sga_max_size	3154116608
sga_target	3154116608
shared_pool_size	318767104
streams_pool_size	50331648
timed_statistics	TRUE
undo_management	AUTO
undo_retention	3600
undo_tablespace	TS_UNDO
user_dump_dest	/apli/app/oracle/admin/PROD15/udump
utl_file_dir	/trabajo/samedaycargo/ciber/log, /trabajo/samedaycargo/bpns/log

End of Report

% Blocks changed per Read:	11.28	Recursive Call %:	83.27
Rollback per transaction %:	8.92	Rows per Sort:	457.00

Buffer Nowait %:	100.00	Redo NoWait %:	99.98
Buffer Hit %:	92.10	In-memory Sort %:	99.99
Library Hit %:	91.39	Soft Parse %:	87.87
Execute to Parse %:	73.18	Latch Hit %:	99.97
Parse CPU to Parse Elapsd %:	65.36	% Non-Parse CPU:	98.10