Exemplo de um AWR (Automatic Workload Repository)

WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
BPODWH	640444401	BPODWH	1	10.2.0.3.0	NO	esu0028

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	11653	19-Ago-09 00:00:32	44	6.5
End Snap:	11668	19-Ago-09 15:00:55	41	8.5
Elapsed:		900.39 (mins)
DB Time:		876.36 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	1,760M	1,760M	Std Block Size:	8K
Shared Pool Size:	192M	192M	Log Buffer:	14,356K

Load Profile

	Per Second	Per Transaction
Redo size:	105,477.98	717,484.91
Logical reads:	653.72	4,446.76
Block changes:	505.74	3,440.16
Physical reads:	6.50	44.22
Physical writes:	13.01	88.47
User calls:	50.41	342.88
Parses:	6.26	42.60
Hard parses:	0.19	1.28
Sorts:	1.75	11.90
Logons:	0.03	0.22
Executes:	21.72	147.75
Transactions:	0.15

% Blocks changed per Read:	77.36	Recursive Call %:	62.96
Rollback per transaction %:	2.05	Rows per Sort:	53.68

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.22	In-memory Sort %:	100.00
Library Hit %:	97.27	Soft Parse %:	97.01
Execute to Parse %:	71.17	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	52.12	% Non-Parse CPU:	99.23

Shared Pool Statistics

	Begin	End
Memory Usage %:	56.13	55.02
% SQL with executions>1:	78.56	76.51
% Memory for SQL w/exec>1:	80.98	76.67

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
Backup: sbtbackup	17	3,367	198,054	6.4	Administrative
Backup: sbtwrite2	64,223	2,517	39	4.8	Administrative
RMAN backup & recovery I/O	70,488	2,376	34	4.5	System I/O
CPU time		2,352		4.5
control file sequential read	298,605	616	2	1.2	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

Back to Top

Wait Events Statistics

• Time Model Statistics
• Wait Class
• Wait Events
• Background Wait Events
• Operating System Statistics
• Service Statistics
• Service Wait Class Stats

Back to Top

Time Model Statistics

• Total time in database user-calls (DB Time): 52581,6s
• 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	52,530.76	99.90
DB CPU	2,352.13	4.47
RMAN cpu time (backup/restore)	75.73	0.14
parse time elapsed	62.34	0.12
hard parse elapsed time	52.53	0.10
PL/SQL execution elapsed time	37.16	0.07
PL/SQL compilation elapsed time	8.18	0.02
inbound PL/SQL rpc elapsed time	1.87	0.00
hard parse (sharing criteria) elapsed time	1.22	0.00
connection management call elapsed time	1.12	0.00
failed parse elapsed time	0.62	0.00
hard parse (bind mismatch) elapsed time	0.26	0.00
repeated bind elapsed time	0.22	0.00
sequence load elapsed time	0.19	0.00
DB time	52,581.61
background elapsed time	9,769.80
background cpu time	268.44

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
Administrative	64,361	0.00	6,183	96	8.10
System I/O	507,338	0.00	3,904	8	63.88
User I/O	133,794	0.00	623	5	16.85
Application	174,084	0.00	263	2	21.92
Network	14,287,318	0.00	190	0	1,798.96
Configuration	413	29.30	142	344	0.05
Other	2,795,216	99.30	67	0	351.95
Commit	4,207	0.19	34	8	0.53
Concurrency	367	0.00	12	33	0.05

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
Backup: sbtbackup	17	0.00	3,367	198054	0.00
Backup: sbtwrite2	64,223	0.00	2,517	39	8.09
RMAN backup & recovery I/O	70,488	0.00	2,376	34	8.88
control file sequential read	298,605	0.00	616	2	37.60
db file sequential read	119,216	0.00	521	4	15.01
log file sequential read	58,081	0.00	480	8	7.31
Backup: sbtclose2	17	0.00	283	16672	0.00
SQL*Net break/reset to client	173,657	0.00	257	1	21.87
log file parallel write	27,946	0.00	163	6	3.52
control file parallel write	23,477	0.00	118	5	2.96
db file parallel write	21,370	0.00	117	5	2.69
SQL*Net more data to client	10,934,528	0.00	117	0	1,376.80
log file switch (checkpoint incomplete)	197	35.03	80	408	0.02
SQL*Net more data from client	664,500	0.00	71	0	83.67
direct path read	5,326	0.00	62	12	0.67
log file switch completion	207	25.12	59	285	0.03
ARCH wait on c/f tx acquire 2	42	100.00	41	977	0.01
db file scattered read	5,468	0.00	37	7	0.69
log file sync	4,207	0.19	34	8	0.53
Log archive I/O	6,945	0.00	32	5	0.87
PX Deq Credit: send blkd	16,341	0.00	21	1	2.06
os thread startup	359	0.00	12	34	0.05
Backup: sbtinfo2	17	0.00	10	577	0.00
switch logfile command	39	0.00	6	164	0.00
enq: RO - fast object reuse	427	0.00	6	14	0.05
PX qref latch	2,777,085	99.94	3	0	349.67
log buffer space	7	0.00	3	367	0.00
SQL*Net message to client	2,688,290	0.00	2	0	338.49
Data file init write	194	0.00	1	5	0.02
direct path write	3,058	0.00	1	0	0.39
enq: CF - contention	139	0.00	1	5	0.02
control file single write	72	0.00	1	7	0.01
latch free	21	0.00	0	21	0.00
local write wait	288	0.00	0	1	0.04
LGWR wait for redo copy	1,377	0.22	0	0	0.17
log file single write	354	0.00	0	0	0.04
PX Deq: Signal ACK	5	40.00	0	22	0.00
Backup: sbtinit	12	0.00	0	5	0.00
enq: TC - contention	3	0.00	0	19	0.00
reliable message	147	0.00	0	0	0.02
latch: object queue header operation	7	0.00	0	1	0.00
db file single write	20	0.00	0	0	0.00
buffer busy waits	1	0.00	0	4	0.00
latch: shared pool	2	0.00	0	2	0.00
PX Deq: Table Q qref	3	0.00	0	1	0.00
direct path read temp	112	0.00	0	0	0.01
rdbms ipc reply	16	0.00	0	0	0.00
latch: row cache objects	1	0.00	0	2	0.00
latch: session allocation	9	0.00	0	0	0.00
latch: redo allocation	16	0.00	0	0	0.00
latch: checkpoint queue latch	1	0.00	0	1	0.00
latch: cache buffers lru chain	3	0.00	0	0	0.00
direct path write temp	112	0.00	0	0	0.01
Backup: sbtcommand	12	0.00	0	0	0.00
Backup: sbtend	12	0.00	0	0	0.00
latch: redo writing	2	0.00	0	0	0.00
enq: PS - contention	1	0.00	0	0	0.00
latch: library cache	3	0.00	0	0	0.00
Backup: sbtinit2	12	0.00	0	0	0.00
latch: cache buffers chains	1	0.00	0	0	0.00
SQL*Net message from client	2,688,293	0.00	207,409	77	338.49
jobq slave wait	18,923	95.84	54,968	2905	2.38
Streams AQ: waiting for messages in the queue	10,799	100.00	52,703	4880	1.36
Streams AQ: qmn slave idle wait	1,927	0.00	52,614	27303	0.24
Streams AQ: qmn coordinator idle wait	3,888	50.41	52,614	13532	0.49
virtual circuit status	1,800	100.00	52,527	29181	0.23
Streams AQ: waiting for time management or cleanup tasks	12	100.00	41,975	3497904	0.00
PX Idle Wait	4,830	99.36	9,377	1941	0.61
PX Deq: Table Q Normal	69,945	0.08	3,050	44	8.81
PX Deq: Execution Msg	1,842	81.60	2,982	1619	0.23
PX Deq: Execute Reply	145	2.07	13	91	0.02
PX Deq Credit: need buffer	2,451	0.00	3	1	0.31
PX Deq: Msg Fragment	155	0.00	1	4	0.02
PX Deq: Table Q Sample	8	0.00	0	53	0.00
PX Deq: Parse Reply	16	0.00	0	4	0.00
PX Deq: Join ACK	19	0.00	0	0	0.00
class slave wait	13	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	27,946	0.00	163	6	3.52
control file sequential read	39,956	0.00	154	4	5.03
control file parallel write	22,286	0.00	117	5	2.81
db file parallel write	21,370	0.00	117	5	2.69
log file sequential read	6,154	0.00	89	15	0.77
Log archive I/O	6,678	0.00	31	5	0.84
os thread startup	327	0.00	11	35	0.04
db file sequential read	160	0.00	1	7	0.02
direct path write	3,021	0.00	1	0	0.38
events in waitclass Other	1,493	0.20	1	1	0.19
direct path read	3,021	0.00	1	0	0.38
log file single write	324	0.00	0	0	0.04
latch: redo writing	2	0.00	0	0	0.00
latch: cache buffers chains	1	0.00	0	0	0.00
rdbms ipc message	199,257	87.24	566,033	2841	25.09
pmon timer	18,406	99.22	52,733	2865	2.32
Streams AQ: qmn slave idle wait	1,927	0.00	52,614	27303	0.24
Streams AQ: qmn coordinator idle wait	3,888	50.41	52,614	13532	0.49
smon timer	518	33.78	50,676	97829	0.07
Streams AQ: waiting for time management or cleanup tasks	12	100.00	41,975	3497904	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	158,415
AVG_IDLE_TIME	5,248,359
AVG_IOWAIT_TIME	88,636
AVG_SYS_TIME	55,772
AVG_USER_TIME	101,328
BUSY_TIME	639,012
IDLE_TIME	20,998,720
IOWAIT_TIME	359,832
SYS_TIME	228,403
USER_TIME	410,609
LOAD	0
OS_CPU_WAIT_TIME	5,730,600
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	8,589,934,592
NUM_CPU_CORES	2
NUM_CPUS	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
BPODWH	52,397.40	2,271.50	345,981	33,793,746
SYS$USERS	183.30	80.00	1,334	916,120
BPODWHXDB	0.00	0.00	0	0
SYS$BACKGROUND	0.00	0.00	3,882	602,623

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	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
BPODWH	125039	59831	38	77	33	630	14251649	18997
SYS$USERS	1534	1473	1	0	64328	617710	34726	12
SYS$BACKGROUND	7220	1006	328	1140	0	0	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

Back to Top

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
50,962	1,693	0		96.92	51rrwh8qpp81f	dtllst@esu5550 (TNS V1-V3)	SELECT SCN, TO_CHAR(SCN) AS S...
373	17	1	372.54	0.71	5r2w0zcdpc5zp	Disco10, V00EENERY	SELECT o113128.EPP_CAM_ANO_IN...
176	147	86,866	0.00	0.34	dfgmnt6v0rjms	pmdtm@esu5550 (TNS V1-V3)	INSERT INTO EST_CAN_PU_09(PUN_...
102	11	1	101.75	0.19	bs28ccwphg7y5	Disco10, V00GMGAMA	SELECT ( CASE WHEN o113133.DR...
28	26	15	1.90	0.05	bunssq950snhf		insert into wrh$_sga_target_ad...
26	10	900	0.03	0.05	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
25	2	7	3.54	0.05	3uyjvvs6wru8r	rman@esu0028 (TNS V1-V3)	SELECT RECID , STAMP , THREA...
18	6	885	0.02	0.04	1396drrvjbcnk	pmdtm@esu5550 (TNS V1-V3)	INSERT INTO EST_ASA_DET_CAL_PA...
18	17	10,800	0.00	0.03	096rr4hppg636	OWB Runtime Service - Infrastructure	BEGIN wb_rt_service_control.wa...
11	11	294,099	0.00	0.02	avbybxzfurku2	pmdtm@esu5550 (TNS V1-V3)	SELECT MED_DESCRICAO FROM EST_...

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
1,693	50,962	0		96.92	51rrwh8qpp81f	dtllst@esu5550 (TNS V1-V3)	SELECT SCN, TO_CHAR(SCN) AS S...
147	176	86,866	0.00	0.34	dfgmnt6v0rjms	pmdtm@esu5550 (TNS V1-V3)	INSERT INTO EST_CAN_PU_09(PUN_...
26	28	15	1.74	0.05	bunssq950snhf		insert into wrh$_sga_target_ad...
17	18	10,800	0.00	0.03	096rr4hppg636	OWB Runtime Service - Infrastructure	BEGIN wb_rt_service_control.wa...
17	373	1	16.68	0.71	5r2w0zcdpc5zp	Disco10, V00EENERY	SELECT o113128.EPP_CAM_ANO_IN...
11	11	294,099	0.00	0.02	avbybxzfurku2	pmdtm@esu5550 (TNS V1-V3)	SELECT MED_DESCRICAO FROM EST_...
11	102	1	10.81	0.19	bs28ccwphg7y5	Disco10, V00GMGAMA	SELECT ( CASE WHEN o113133.DR...
10	26	900	0.01	0.05	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
7	7	86,869	0.00	0.01	dwwbq1j9kw64f		select o.name, c.name from co...
6	18	885	0.01	0.04	1396drrvjbcnk	pmdtm@esu5550 (TNS V1-V3)	INSERT INTO EST_ASA_DET_CAL_PA...

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: 35,316,147
• Captured SQL account for 16.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
2,398,774	86,866	27.61	6.79	147.05	176.17	dfgmnt6v0rjms	pmdtm@esu5550 (TNS V1-V3)	INSERT INTO EST_CAN_PU_09(PUN_...
893,774	1	893,774.00	2.53	16.68	372.54	5r2w0zcdpc5zp	Disco10, V00EENERY	SELECT o113128.EPP_CAM_ANO_IN...
588,349	294,099	2.00	1.67	11.23	11.39	avbybxzfurku2	pmdtm@esu5550 (TNS V1-V3)	SELECT MED_DESCRICAO FROM EST_...
434,345	86,869	5.00	1.23	6.62	6.62	dwwbq1j9kw64f		select o.name, c.name from co...
173,508	900	192.79	0.49	10.00	25.61	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
89,881	32,849	2.74	0.25	1.07	1.17	96g93hntrzjtr		select /*+ rule */ bucket_cnt,...
89,012	1	89,012.00	0.25	10.81	101.75	bs28ccwphg7y5	Disco10, V00GMGAMA	SELECT ( CASE WHEN o113133.DR...
83,832	50	1,676.64	0.24	4.14	5.05	6fndj356xhw6n	w3wp.exe	select DFD_COD_DIA, DAC_COD_A...
80,051	2	40,025.50	0.23	4.11	6.40	b0abrwr3dab44	dtllst@esu5550 (TNS V1-V3)	BEGIN SYS.DBMS_LOGMNR_D.BUILD(...
71,403	885	80.68	0.20	5.65	18.46	1396drrvjbcnk	pmdtm@esu5550 (TNS V1-V3)	INSERT INTO EST_ASA_DET_CAL_PA...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 351,206
• Captured SQL account for 46.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
78,544	1	78,544.00	22.36	10.81	101.75	bs28ccwphg7y5	Disco10, V00GMGAMA	SELECT ( CASE WHEN o113133.DR...
71,654	1	71,654.00	20.40	16.68	372.54	5r2w0zcdpc5zp	Disco10, V00EENERY	SELECT o113128.EPP_CAM_ANO_IN...
4,926	1	4,926.00	1.40	0.12	0.45	23pjhhw9v7u6d	TOAD 9.0.1.8	SELECT ROWID, EJV_NUM_VER...
2,613	885	2.95	0.74	5.65	18.46	1396drrvjbcnk	pmdtm@esu5550 (TNS V1-V3)	INSERT INTO EST_ASA_DET_CAL_PA...
1,797	1	1,797.00	0.51	0.16	0.65	df68xh2rzv24n	TOAD 9.0.1.8	select count(*) from ( SELECT ...
1,710	2	855.00	0.49	0.63	1.31	8t3j6myj5prdh	TOAD 9.0.1.8	select count(*) from ( SELECT ...
466	900	0.52	0.13	10.00	25.61	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
317	1,577	0.20	0.09	0.68	3.12	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
167	1,577	0.11	0.05	0.26	2.64	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
131	690	0.19	0.04	3.39	7.08	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 1,173,429
• Captured SQL account for 60.3% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
294,099	294,099	1.00	0.00	0.00	avbybxzfurku2	pmdtm@esu5550 (TNS V1-V3)	SELECT MED_DESCRICAO FROM EST_...
86,869	86,869	1.00	0.00	0.00	dwwbq1j9kw64f		select o.name, c.name from co...
86,866	0	0.00	0.00	0.00	dfgmnt6v0rjms	pmdtm@esu5550 (TNS V1-V3)	INSERT INTO EST_CAN_PU_09(PUN_...
32,849	22,481	0.68	0.00	0.00	96g93hntrzjtr		select /*+ rule */ bucket_cnt,...
32,400	0	0.00	0.00	0.00	9tbyrcrvgp196	OWB Runtime Service - Infrastructure	select /*+ FIRST_ROWS(1) */ ...
18,036	301,141	16.70	0.00	0.00	db78fxqxwxt7r		select /*+ rule */ bucket, en...
15,273	18,652	1.22	0.00	0.00	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
10,800	10,800	1.00	0.00	0.00	096rr4hppg636	OWB Runtime Service - Infrastructure	BEGIN wb_rt_service_control.wa...
10,800	1,050	0.10	0.00	0.00	6ssrk2dqj7jbx		select job, nvl2(last_date, ...
9,456	9,454	1.00	0.00	0.00	2ym6hhaq30r73		select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 338,342
• Captured SQL account for 78.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
86,869	86,869	25.67	dwwbq1j9kw64f		select o.name, c.name from co...
86,867	86,866	25.67	dfgmnt6v0rjms	pmdtm@esu5550 (TNS V1-V3)	INSERT INTO EST_CAN_PU_09(PUN_...
10,800	10,800	3.19	096rr4hppg636	OWB Runtime Service - Infrastructure	BEGIN wb_rt_service_control.wa...
9,456	9,456	2.79	2ym6hhaq30r73		select type#, blocks, extents,...
6,603	6,603	1.95	0h6b2sajwb74n		select privilege#, level from ...
3,409	8,100	1.01	3c1kubcdjnppq		update sys.col_usage$ set eq...
2,868	2,868	0.85	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
2,574	2,574	0.76	bhx2pzbtqvygj	dtllst@esu5550 (TNS V1-V3)	BEGIN :aucTrueEolSCN := dbms_...
2,492	96	0.74	53btfq0dt9bs9		insert into sys.col_usage$ val...
2,428	2,428	0.72	g00cj285jmgsw		update sys.mon_mods$ set inser...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
096rr4hppg636	BEGIN wb_rt_service_control.wait( :1 , :2 , :3 ) ; END;
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
1396drrvjbcnk	INSERT INTO EST_ASA_DET_CAL_PAR_08(TCA_NUM_SEQ, CAM_ANO_INI_CAM, PRO_NUM_ORD, PRO_VERSAO, UPR_CODIGO, MED_CODIGO, UPR_NUM_SEQ, DUP_NUM_SUB_PAR, ARV_PRO_NUM_ORD, GGE_CODIGO, ARV_ARE_COM_DEC_AGR, ARV_ARE_SEM_DEC_AGR, ARV_ARE_COM_CAL_ARE, ARV_ARE_SEM_CAL_ARE, ARV_ARE_COM_ELE, ARV_ARE_SEM_ELE, ARV_ARE_COM_CAD, ARV_ARE_SEM_CAD, NCA_NUM_SEQ, ARV_ARE_COM_DET_ELE_ADM, ARV_ARE_SEM_DET_ELE_ADM, ARV_ARE_COM_RCO, ARV_ARE_SEM_RCO, ARV_ARE_COM_DET_ELE_CAM, ARV_ARE_SEM_DET_ELE_CAM, ARV_ARE_COM_DET, ARV_ARE_SEM_DET, ARV_ARE_COM_SAN, ARV_ARE_SEM_SAN, ARV_ARE_COM_APU, ARV_ARE_SEM_APU, GCU_COD_SAN_COM, GCU_COD_SAN_SEM, GCU_COD_SAN_MAJ, GCU_COD_SAN_COM_RCO, GCU_COD_SAN_SEM_RCO, GCU_COD_SAN_MAJ_RCO, CIN_CODIGO_PAG, GCU_CODIGO_PAG, PPA_SEQ, PCC_SEQ, PSG_SEQ, MED_DESCRICAO, GGE_DESCRICAO, GCU_DES_SAN_COM, GCU_DES_SAN_SEM, GCU_DES_SAN_MAJ, GCU_DES_SAN_COM_RCO, GCU_DES_SAN_SEM_RCO, GCU_DES_SAN_MAJ_RCO, CIN_DESCRICAO, GCU_DESCRICAO_PAG, TER_NINGA) 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, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53)
23pjhhw9v7u6d	SELECT ROWID, EJV_NUM_VER, CAM_ANO_INI_CAM, PRO_NUM_ORD, PRO_VERSAO, UPR_CODIGO, MED_CODIGO, UPR_NUM_SEQ, DUP_NUM_SUB_PAR, ARV_PRO_NUM_ORD, TER_NINGA, ARV_AJU_CODIGO, GGE_CODIGO, ARV_ARE_COM_DEC_AGR, ARV_ARE_SEM_DEC_AGR, ARV_ARE_COM_CAL_ARE, ARV_ARE_SEM_CAL_ARE, ARV_ARE_COM_ELE, ARV_ARE_SEM_ELE, ARV_ARE_COM_CAD, ARV_ARE_SEM_CAD, NCA_NUM_SEQ, ARV_ARE_COM_DET_ELE_ADM, ARV_ARE_SEM_DET_ELE_ADM, ARV_ARE_COM_RCO, ARV_ARE_SEM_RCO, ARV_ARE_COM_DET_ELE_CAM, ARV_ARE_SEM_DET_ELE_CAM, ARV_ARE_COM_DET, ARV_ARE_SEM_DET, ARV_ARE_COM_SAN, ARV_ARE_SEM_SAN, ARV_ARE_COM_APU, ARV_ARE_SEM_APU, GCU_COD_SAN_COM, GCU_COD_SAN_SEM, GCU_COD_SAN_MAJ, GCU_COD_SAN_COM_RCO, GCU_COD_SAN_SEM_RCO, GCU_COD_SAN_MAJ_RCO, CIN_CODIGO_PAG, GCU_CODIGO_PAG, PPA_SEQ, PCC_SEQ, PSG_SEQ, ARV_ARE_COM_ADI_DEC_AGR, ARV_ARE_COM_ADI_CAL_ARE, ARV_ARE_COM_ADI_ELE, ARV_ARE_COM_ADI_CAD, ARV_ARE_COM_ADI_DET_ELE_ADM, ARV_ARE_COM_ADI_RCO, ARV_ARE_COM_ADI_DET_ELE_CAM, ARV_ARE_COM_ADI_DET, ARV_ARE_COM_ADI_SAN, ARV_ARE_COM_ADI_APU, PPA_SEQ_HIE, PCC_SEQ_HIE, DAT_CRI FROM EST.EST_ASA_PARCELAS_08 Tbl Where CAM_ANO_INI_CAM = 2008 AND EJV_NUM_VER = 0
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
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#
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3uyjvvs6wru8r	SELECT RECID , STAMP , THREAD# , SEQUENCE# , FIRST_CHANGE# LOW_SCN , FIRST_TIME LOW_TIME , NEXT_CHANGE# NEXT_SCN , RESETLOGS_CHANGE# , RESETLOGS_TIME FROM V$LOG_HISTORY WHERE RECID BETWEEN :1 AND :1 AND RESETLOGS_TIME IS NOT NULL AND STAMP >= :1 ORDER BY RECID
51rrwh8qpp81f	SELECT SCN, TO_CHAR(SCN) AS SCN_CHAR, SCN AS SCN_FLOAT, NVL(:aucEolSCN - SCN, :aucEolSCN) AS SCN_EOF_DIFF, TO_CHAR(TIMESTAMP) AS TIMESTAMP, TO_CHAR(XIDUSN || '.' || XIDSLT || '.' || XIDSQN) AS TRANID, SEG_OWNER, SEG_NAME, USERNAME, ROLLBACK, OPERATION_CODE, SQL_REDO, SQL_UNDO, CSF, STATUS FROM V$LOGMNR_CONTENTS
53btfq0dt9bs9	insert into sys.col_usage$ 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)
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5r2w0zcdpc5zp	SELECT o113128.EPP_CAM_ANO_INI_CAM as E143448, ( CASE WHEN o113103.DRA_CODIGO BETWEEN '11000' AND '18000' THEN SUBSTR(o113103.DRA_DES_DRA, 30, 30) WHEN o113103.DRA_CODIGO IN ('180000', '190000') THEN SUBSTR(o113103.DRA_DES_DRA, -7) ELSE o113103.DRA_DES_DRA END ) as E143455, o113128.CON_CODIGO as E143459, CASE WHEN o113128.DUP_SEQ_REG = 'R' THEN 'Regadio' WHEN o113128.DUP_SEQ_REG = 'S' THEN 'Sequeiro' ELSE '-' END as E143469, o113128.TCU_DESCRICAO as E143481, ( CASE WHEN o113128.TCU_DESCRICAO LIKE '%OLIVAL%' THEN 'OLIVAL' WHEN o113128.TCU_DESCRICAO LIKE '%SILAGEM%' THEN 'SUPERFÍCIES FORRAGEIRAS' WHEN o113128.GCU_CODIGO IN ('G01', 'G05', 'G10', 'G14', 'G22', 'G30') THEN o113128.GCU_DESCRICAO ELSE 'Outras Superfícies Elegíveis' END ) as E145670, as133302_143455_OLD as as133302_143455_OLD, SUM(o113128.DUP_ARE_RPU) as E143468_SUM, NVL(COUNT(DISTINCT CASE WHEN o113128.DUP_ARE_RPU > 0 THEN o113133.TER_NINGA END), 0) as E143470 FROM EST.EST_HOR_FREGUESIA_07 o113103, EST.EST_PUN_DET_UTI_PAR_07 o113128, EST.EST_PUN_PED_UNI_07 o113133, ( SELECT o133290.DRA_ABRV AS as133302_143455_OLD_2, MAX(o133290.DRA_CODIGO) AS as133302_143455_OLD FROM ( /* Formatted on 2009/05/28 16:10 (Formatter Plus v4.8.8) */ SELECT DISTINCT h.dra_codigo , h.dra_des_dra , (CASE WHEN dra_codigo BETWEEN '11000' AND '18000' THEN SUBSTR (h.dra_des_dra , 30 , 30) WHEN dra_codigo IN ('180000', '190000') THEN SUBSTR (h.dra_des_dra , -7) ELSE h.dra_des_dra END) dra_abrv , (CASE WHEN dra_codigo BETWEEN '11000' AND '18000' THEN 'DRAP ' || SUBSTR (h.dra_des_dra , 30 , 30) WHEN dra_codigo IN ('180000', '190000') THEN 'DRAP ' || SUBSTR (h.dra_des_dra , -7) ELSE h.dra_des_dra END) dra_drap FROM est_hor_freguesia_07 h UNION SELECT DISTINCT h.dra_codigo , h.dra_des_dra , h.dra_des_dra dra_abrv , 'DRA ' || h.dra_des_dra dra_drap FROM est_e x_dra_07 h ORDER BY dra_codigo ) o133290 GROUP BY o133290.DRA_ABRV) WHERE ( (o113103.DIS_CODIGO = o113128.DIS_CODIGO AND o113103.CON_CODIGO = o113128.CON_CODIGO AND o113103.FRE_CODIGO = o113128.FRE_CODIGO AND o113103.EJV_NUM_VER = o113128.EJV_NUM_VER) and (o113128.EPP_PRO_NUM_ORD = o113133.PRO_NUM_ORD AND o113128.EPP_CAM_ANO_INI_CAM = o113133.CAM_ANO_INI_CAM AND o113128.EJV_NUM_VER = o113133.EJV_NUM_VER) and (( CASE WHEN o113103.DRA_CODIGO BETWEEN '11000' AND '18000' THEN SUBSTR(o113103.DRA_DES_DRA, 30, 30) WHEN o113103.DRA_CODIGO IN ('180000', '190000') THEN SUBSTR(o113103.DRA_DES_DRA, -7) ELSE o113103.DRA_DES_DRA END ) = as133302_143455_OLD_2(+))) AND (( CASE WHEN o113103.DRA_CODIGO BETWEEN '11000' AND '18000' THEN SUBSTR(o113103.DRA_DES_DRA, 30, 30) WHEN o113103.DRA_CODIGO IN ('180000', '190000') THEN SUBSTR(o113103.DRA_DES_DRA, -7) ELSE o113103.DRA_DES_DRA END ) IN ('ENTRE DOURO E MINHO', 'TRAS-OS-MONTES', 'BEIRA LITORAL', 'BEIRA INTERIOR', 'RIBATEJO E OESTE', 'NORTE', 'CENTRO', 'LISBOA E VALE DO TEJO', 'ALENTEJO', 'ALGARVE')) AND (CASE WHEN o113128.DUP_SEQ_REG = 'R' THEN 'Regadio' WHEN o113128.DUP_SEQ_REG = 'S' THEN 'Sequeiro' ELSE '-' END IN ('Regadio', 'Sequeiro')) AND (o113128.EPP_CAM_ANO_INI_CAM IN (2009)) GROUP BY as133302_143455_OLD, o113128.EPP_CAM_ANO_INI_CAM, ( CASE WHEN o113103.DRA_CODIGO BETWEEN '11000' AND '18000' THEN SUBSTR(o113103.DRA_DES_DRA, 30, 30) WHEN o113103.DRA_CODIGO IN ('180000', '190000') THEN SUBSTR(o113103.DRA _DES_DRA, -7) ELSE o113103.DRA_DES_DRA END ), o113128.CON_CODIGO, CASE WHEN o113128.DUP_SEQ_REG = 'R' THEN 'Regadio' WHEN o113128.DUP_SEQ_REG = 'S' THEN 'Sequeiro' ELSE '-' END, o113128.TCU_DESCRICAO, ( CASE WHEN o113128.TCU_DESCRICAO LIKE '%OLIVAL%' THEN 'OLIVAL' WHEN o113128.TCU_DESCRICAO LIKE '%SILAGEM%' THEN 'SUPERFÍCIES FORRAGEIRAS' WHEN o113128.GCU_CODIGO IN ('G01', 'G05', 'G10', 'G14', 'G22', 'G30') THEN o113128.GCU_DESCRICAO ELSE 'Outras Superfícies Elegíveis' END )
6fndj356xhw6n	select DFD_COD_DIA, DAC_COD_ACTIVIDADE, DPO_COD_PRODUTO, nvl(dfd_qtd_horas, 0) as dfd_qtd_horas from (SELECT 0 as cnt, rownum, DFD_COD_DIA, DAC_COD_ACTIVIDADE, DPO_COD_PRODUTO, DFD_QTD_HORAS as dfd_qtd_horas FROM SCG_FHR_DWF_FHR_DIA WHERE (DRH_COD_RHU = :DRH_COD_RHU) AND (SUBSTR(DFD_COD_DIA, 1, 6) = :COD_ANO_MES) union SELECT 1 as cnt, rownum, DFD_COD_DIA, DAC_COD_ACTIVIDADE, DPO_COD_PRODUTO, DFD_QTD_HORAS_EXT as dfd_qtd_horas FROM SCG_FHR_DWF_FHR_DIA WHERE (DRH_COD_RHU = :DRH_COD_RHU) AND (SUBSTR(DFD_COD_DIA, 1, 6) = :COD_ANO_MES)) ORDER BY DAC_COD_ACTIVIDADE ASC, DPO_COD_PRODUTO ASC, DFD_COD_DIA ASC, rownum, cnt
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;
6ssrk2dqj7jbx	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
8t3j6myj5prdh	select count(*) from ( SELECT ROWID, EJV_NUM_VER, CAM_ANO_INI_CAM, PRO_NUM_ORD, PRO_VERSAO, UPR_CODIGO, MED_CODIGO, UPR_NUM_SEQ, DUP_NUM_SUB_PAR, ARV_PRO_NUM_ORD, TER_NINGA, ARV_AJU_CODIGO, GGE_CODIGO, ARV_ARE_COM_DEC_AGR, ARV_ARE_SEM_DEC_AGR, ARV_ARE_COM_CAL_ARE, ARV_ARE_SEM_CAL_ARE, ARV_ARE_COM_ELE, ARV_ARE_SEM_ELE, ARV_ARE_COM_CAD, ARV_ARE_SEM_CAD, NCA_NUM_SEQ, ARV_ARE_COM_DET_ELE_ADM, ARV_ARE_SEM_DET_ELE_ADM, ARV_ARE_COM_RCO, ARV_ARE_SEM_RCO, ARV_ARE_COM_DET_ELE_CAM, ARV_ARE_SEM_DET_ELE_CAM, ARV_ARE_COM_DET, ARV_ARE_SEM_DET, ARV_ARE_COM_SAN, ARV_ARE_SEM_SAN, ARV_ARE_COM_APU, ARV_ARE_SEM_APU, GCU_COD_SAN_COM, GCU_COD_SAN_SEM, GCU_COD_SAN_MAJ, GCU_COD_SAN_COM_RCO, GCU_COD_SAN_SEM_RCO, GCU_COD_SAN_MAJ_RCO, CIN_CODIGO_PAG, GCU_CODIGO_PAG, PPA_SEQ, PCC_SEQ, PSG_SEQ, ARV_ARE_COM_ADI_DEC_AGR, ARV_ARE_COM_ADI_CAL_ARE, ARV_ARE_COM_ADI_ELE, ARV_ARE_COM_ADI_CAD, ARV_ARE_COM_ADI_DET_ELE_ADM, ARV_ARE_COM_ADI_RCO, ARV_ARE_COM_ADI_DET_ELE_CAM, ARV_ARE_COM_ADI_DET, ARV_ARE_COM_ADI_SAN, ARV_ARE_COM_ADI_APU, PPA_SEQ_HIE, PCC_SEQ_HIE, DAT_CRI FROM EST.EST_ASA_PARCELAS_08 Tbl where CAM_ANO_INI_CAM = 2008 AND EJV_NUM_VER = 0)
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
9tbyrcrvgp196	select /*+ FIRST_ROWS(1) */ tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration, tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "OWBREP"."WB_RT_SERVICE_QUEUE_TAB" tab where q_name = :1 and (state = :2 ) order by q_name, state, enq_time, step_no, chain_no, local_order_no for update skip locked
abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
avbybxzfurku2	SELECT MED_DESCRICAO FROM EST_AGR_MEDIDA_07 WHERE CAM_ANO_INI_CAM = :1 AND MED_CODIGO = :2 AND EJV_NUM_VER = :3 ORDER BY MED_DESCRICAO
b0abrwr3dab44	BEGIN SYS.DBMS_LOGMNR_D.BUILD(OPTIONS => SYS.DBMS_LOGMNR_D.STORE_IN_REDO_LOGS); END;
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
bhx2pzbtqvygj	BEGIN :aucTrueEolSCN := dbms_flashback.get_system_change_number; END;
bs28ccwphg7y5	SELECT ( CASE WHEN o113133.DRA_CODIGO BETWEEN '11000' AND '18000' THEN SUBSTR(o113133.DRA_DES_DRA, 30, 30) WHEN o113133.DRA_CODIGO IN ('180000', '190000') THEN SUBSTR(o113133.DRA_DES_DRA, -7) ELSE o113133.DRA_DES_DRA END ) as E138552, o113116.EPP_CAM_ANO_INI_CAM as E138608, as133302_138552_OLD as as133302_138552_OLD, SUM(( CASE WHEN o113116.EPP_CAM_ANO_INI_CAM = '2008' THEN o113116.AAM_TOT_PRO_INT WHEN o113116.EPP_CAM_ANO_INI_CAM = '2009' THEN o113116.AAM_ANI_PRO_INT END )*o113097.ECE_CAB_NOR) as E138581_SUM, SUM(( CASE WHEN o113116.EPP_CAM_ANO_INI_CAM = '2008' THEN o113116.AAM_TOT_PRO_BIO WHEN o113116.EPP_CAM_ANO_INI_CAM = '2009' THEN o113116.AAM_ANI_PRO_BIO END )*o113097.ECE_CAB_NOR) as E138576_SUM, SUM(o113116.AAM_TOT_RA*o113097.ECE_CAB_NOR) as E138586_SUM, COUNT(DISTINCT o113133.TER_NINGA) as C_1, COUNT(DISTINCT CASE WHEN CASE WHEN o113116.EPP_CAM_ANO_INI_CAM = '2008' THEN o113116.AAM_TOT_PRO_INT WHEN o113116.EPP_CAM_ANO_INI_CAM = '2009' THEN o113116.AAM_ANI_PRO_INT END > 0 THEN o113133.TER_NINGA END) as E138761, COUNT(DISTINCT CASE WHEN o113116.AAM_TOT_RA > 0 THEN o113133.TER_NINGA END) as E138764, COUNT(DISTINCT CASE WHEN CASE WHEN o113116.EPP_CAM_ANO_INI_CAM = '2008' THEN o113116.AAM_TOT_PRO_BIO WHEN o113116.EPP_CAM_ANO_INI_CAM = '2009' THEN o113116.AAM_ANI_PRO_BIO END > 0 THEN o113133.TER_NINGA END) as E138767, GROUPING_ID(( CASE WHEN o113133.DRA_CODIGO BETWEEN '11000' AND '18000' THEN SUBSTR(o113133.DRA_DES_DRA, 30, 30) WHEN o113133.DRA_CODIGO IN ('180000', '190000') THEN SUBSTR(o113133.DRA_DES_DRA, -7) ELSE o113133.DRA_DES_DRA END ), o113116.EPP_CAM_ANO_INI_CAM) as GID FROM EST.EST_ANI_ESP_CLA_ETA_08 o113097, EST.EST_PUN_AGR_ANI_AGR_08 o113116, EST.EST_PUN_PED_UNI_07 o113133, ( SELECT o133290.DRA_ABRV AS as133302_138552_OLD_2, MAX(o133290.DRA_CODIGO) AS as133302_138552_OLD FROM ( /* Formatted on 2009/05/28 16:10 (Formatter Plus v4.8.8) */ SELECT DISTINCT h.dra_codigo , h.dra_des_dra , (CASE WHEN dra_codigo BETWEEN '11000' AND '18000' THEN SUBSTR (h.dra_des_dra , 30 , 30) WHEN dra_codigo IN ('180000', '190000') THEN SUBSTR (h.dra_des_dra , -7) ELSE h.dra_des_dra END) dra_abrv , (CASE WHEN dra_codigo BETWEEN '11000' AND '18000' THEN 'DRAP ' || SUBSTR (h.dra_des_dra , 30 , 30) WHEN dra_codigo IN ('180000', '190000') THEN 'DRAP ' || SUBSTR (h.dra_des_dra , -7) ELSE h.dra_des_dra END) dra_drap FROM est_hor_freguesia_07 h UNION SELECT DISTINCT h.dra_codigo , h.dra_des_dra , h.dra_des_dra dra_abrv , 'DRA ' || h.dra_des_dra dra_drap FROM est_ex_dra_07 h ORDER BY dra_codigo ) o133290 GROUP BY o133290.DRA_ABRV) WHERE ( (o113133.EJV_NUM_VER = o113116.EJV_NUM_VER AND o113133.CAM_ANO_INI_CAM = o113116.EPP_CAM_ANO_INI_CAM AND o113133.PRO_NUM_ORD = o113116.EPP_PRO_NUM_ORD) and (o113116.ECE_CODIGO = o113097.ECE_CODIGO AND o113116.EJV_NUM_VER = o113097.EJV_NUM_VER) and (( CASE WHEN o113133.DRA_CODIGO BETWEEN '11000' AND '18000' THEN SUBSTR(o113133.DRA_DES_DRA, 30, 30) WHEN o113133.DRA_CODIGO IN ('180000', '190000') THEN SUBSTR(o113133.DRA_DES_DRA, -7) ELSE o113133.DRA_DES_DRA END ) = as133302_138552_OLD_2(+))) AND ( ( CASE WHEN o113116.EPP_CAM_ANO_INI_CAM = '2008' THEN o113116.AAM_TOT_PRO_BIO WHEN o113116.EPP_CAM_ANO_INI_CAM = '2009' THEN o113116.AAM_ANI_PRO_BIO END IS NOT NULL OR CASE WHEN o113116.EPP_CAM_ANO_INI_CAM = '2008' THE N o113116.AAM_TOT_PRO_INT WHEN o113116.EPP_CAM_ANO_INI_CAM = '2009' THEN o113116.AAM_ANI_PRO_INT END IS NOT NULL OR o113116.AAM_TOT_RA IS NOT NULL ) ) GROUP BY GROUPING SETS(( ( CASE WHEN o113133.DRA_CODIGO BETWEEN '11000' AND '18000' THEN SUBSTR(o113133.DRA_DES_DRA, 30, 30) WHEN o113133.DRA_CODIGO IN ('180000', '190000') THEN SUBSTR(o113133.DRA_DES_DRA, -7) ELSE o113133.DRA_DES_DRA END ), as133302_138552_OLD, o113116.EPP_CAM_ANO_INI_CAM ), ( o113116.EPP_CAM_ANO_INI_CAM )) HAVING (GROUP_ID()=0) ORDER BY GID DESC
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
cvn54b7yz0s8u	select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
db78fxqxwxt7r	select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
df68xh2rzv24n	select count(*) from ( SELECT ROWID, TCA_NUM_SEQ, CAM_ANO_INI_CAM, PRO_NUM_ORD, PRO_VERSAO, AAA_NUM_SEQ, UPR_CODIGO, EJV_NUM_VER, ANI_PRO_NUM_ORD, ANI_REP_AUT_ELE, ANI_FEM_AUT_1_ELE, ANI_PRO_BIO_ELE, ANI_OUT_BIO_ELE, ANI_PRO_INT_ELE, ANI_OUT_INT_ELE, ANI_REP_AUT_DET, ANI_FEM_AUT_1_DET, ANI_PRO_BIO_DET, ANI_OUT_BIO_DET, ANI_PRO_INT_DET, ANI_OUT_INT_DET, ANI_REP_AUT_DET_ELE, ANI_FEM_AUT_1_DET_ELE, ANI_PRO_BIO_DET_ELE, ANI_OUT_BIO_DET_ELE, ANI_PRO_INT_DET_ELE, ANI_OUT_INT_DET_ELE, ANI_REP_AUT_SAN, ANI_FEM_AUT_1_SAN, ANI_PRO_BIO_SAN, ANI_OUT_BIO_SAN, ANI_PRO_INT_SAN, ANI_OUT_INT_SAN, ANI_REP_AUT_APU, ANI_FEM_AUT_1_APU, ANI_PRO_BIO_APU, ANI_OUT_BIO_APU, ANI_PRO_INT_APU, ANI_OUT_INT_APU, PPA_SEQ_AUT, PPA_SEQ_BIO, PPA_SEQ_INT, ANI_PRO_BIO_APU_CN, ANI_OUT_BIO_APU_CN, ANI_PRO_INT_APU_CN, ANI_OUT_INT_APU_CN, EAN_CODIGO, ECE_CODIGO, DAT_CRI, EAN_DESCRICAO, ECE_ESP_CLA_DES, TER_NINGA FROM EST.EST_ASA_DET_CAL_ANI_08 Tbl where CAM_ANO_INI_CAM = 2008 AND EJV_NUM_VER = 0)
dfgmnt6v0rjms	INSERT INTO EST_CAN_PU_09(PUN_NUM_DOC, PUN_VER_DOC, TDO_COD_TIP_DOC, PUN_TIP_CAN, TDO_COD_TIP_DOC_BEN, BEN_NUM_DOC, BEN_VER_DOC, EDO_COD_EST_DOC, REG_CODIGO, PUN_DAT_VAL, PUN_DAT_CAN, PUN_DAT_SUB, PUN_PER_COD, PUN_AJU_RPU, PUN_PAG_ESP_TRI_DUR, PUN_PRE_PRO, PUN_PAG_ESP_ARR, PUN_AJU_CUL_ENE, PUN_PAG_FRU_CAS_RIJ, PUN_AJU_TBC, PUN_PAG_ESP_ALG, PUN_AJU_SEM_CER, PUN_AJU_TOM, PUN_FOR_SEC, PUN_AJU_BAN, PUN_POS_MED_1, PUN_POS_VIN, PUN_PRE_VAC_ALE, PUN_PRE_NAC_SUP, PUN_PRE_OVI_CAP, PUN_PRE_COM, PUN_PRE_ABA, PUN_COM_BOV, PUN_COM_OVI_CAP, PUN_RAC_AUT_BOV, PUN_RAC_AUT_OVI_CAP, PUN_ARV_ART_69, PUN_ARR_ART_69, PUN_AZT_AZE_ART_69, PUN_AZT_MES_ART_69, PUN_CON_ANI_OUT, PUN_CON_LAM, PUN_CON_VIN, PUN_ICS, PUN_EFE_PEC_ICS, PUN_AGR_COM_ANT, PUN_AGR_COM_NOV, PUN_EFE_PEC_AGR_AMB, PUN_AGR_PAS, PUN_FLO_MAN, PUN_FLO_PER_REN, PUN_APO_REG_QUA, PUN_ANE_INF_COM, PUN_ANE_UNI_PRO, PUN_ANE_EFE_PEC, PUN_ANE_DET_UTI_PAR, PUN_ANE_AJU_ANI, PUN_ANE_DET_AGR_SIL_AMB, PUN_ANE_PAG_COM_AZE_AZM, PUN_ANE_AJU_DIR, PUN_ANE_TRA_DIR, PUN_ANE_DOC_OBR, PUN_CN_PRO_ZON_DES, PUN_COD_ENT_SAN, PUN_QTD_SEM_TRI_DUR, PUN_SNIRB_CON, PUN_SNIRB_NAO_CON, PUN_TLM_CON, PUN_EMAIL, PUN_DAT_ACT_SUP, PUN_DAT_ACT_ANI, PUN_AUT_ACO_AGR, PUN_COD_ENT_ACO_AGR, PUN_DAT_ABA, PUN_DAT_OVI_CAP, PUN_DAT_CAN_MAN, DAT_CRI, UTI_CODIGO_CRI, UTI_CODIGO_SUB, UTI_CODIGO, COD_UTI_ALT, DAT_ALT, PUN_PRE_ABA_SUI) 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, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83)
dwwbq1j9kw64f	select o.name, c.name from con$ c, user$ o where c.con# = :1 and owner# = user#
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Back to Top

Instance Activity Stats

Statistic	Total	per Second	per Trans
active txn count during cleanout	108,422	2.01	13.65
application wait time	26,303	0.49	3.31
background checkpoints completed	160	0.00	0.02
background checkpoints started	162	0.00	0.02
background timeouts	173,902	3.22	21.90
branch node splits	2	0.00	0.00
buffer is not pinned count	3,018,699	55.88	380.09
buffer is pinned count	10,431,313	193.09	1,313.44
bytes received via SQL*Net from client	1,879,186,647	34,784.76	236,613.78
bytes sent via SQL*Net to client	23,242,224,890	430,226.18	2,926,495.20
Cached Commit SCN referenced	1,436	0.03	0.18
calls to get snapshot scn: kcmgss	1,250,750	23.15	157.49
calls to kcmgas	433,023	8.02	54.52
calls to kcmgcs	185,630	3.44	23.37
change write time	10,210	0.19	1.29
cleanout - number of ktugct calls	176,145	3.26	22.18
cleanouts and rollbacks - consistent read gets	1	0.00	0.00
cleanouts only - consistent read gets	57,965	1.07	7.30
cluster key scan block gets	260,243	4.82	32.77
cluster key scans	151,169	2.80	19.03
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	21	0.00	0.00
commit batch/immediate requested	21	0.00	0.00
commit cleanout failures: block lost	5,753	0.11	0.72
commit cleanout failures: buffer being written	155	0.00	0.02
commit cleanout failures: callback failure	58	0.00	0.01
commit cleanout failures: cannot pin	1	0.00	0.00
commit cleanouts	233,491	4.32	29.40
commit cleanouts successfully completed	227,524	4.21	28.65
commit immediate performed	21	0.00	0.00
commit immediate requested	21	0.00	0.00
Commit SCN cached	15	0.00	0.00
commit txn count during cleanout	68,526	1.27	8.63
concurrency wait time	1,219	0.02	0.15
consistent changes	2,693	0.05	0.34
consistent gets	5,663,872	104.84	713.15
consistent gets - examination	2,235,869	41.39	281.52
consistent gets direct	70,224	1.30	8.84
consistent gets from cache	5,593,648	103.54	704.31
CPU used by this session	147,719	2.73	18.60
CPU used when call started	144,133	2.67	18.15
CR blocks created	2,582	0.05	0.33
cursor authentications	3,318	0.06	0.42
data blocks consistent reads - undo records applied	2,678	0.05	0.34
db block changes	27,321,770	505.74	3,440.16
db block gets	29,652,275	548.88	3,733.60
db block gets direct	187	0.00	0.02
db block gets from cache	29,652,088	548.88	3,733.58
DB time	17,034,644	315.32	2,144.88
DBWR checkpoint buffers written	648,421	12.00	81.64
DBWR checkpoints	451	0.01	0.06
DBWR object drop buffers written	23,436	0.43	2.95
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR revisited being-written buffer	20	0.00	0.00
DBWR tablespace checkpoint buffers written	251	0.00	0.03
DBWR thread checkpoint buffers written	562,427	10.41	70.82
DBWR transaction table writes	2,139	0.04	0.27
DBWR undo block writes	318,977	5.90	40.16
deferred (CURRENT) block cleanout applications	183,907	3.40	23.16
DFO trees parallelized	2	0.00	0.00
dirty buffers inspected	16,849	0.31	2.12
DML statements parallelized	0	0.00	0.00
enqueue conversions	78,548	1.45	9.89
enqueue releases	671,001	12.42	84.49
enqueue requests	671,265	12.43	84.52
enqueue timeouts	265	0.00	0.03
enqueue waits	428	0.01	0.05
execute count	1,173,429	21.72	147.75
failed probes on index block reclamation	239	0.00	0.03
frame signature mismatch	0	0.00	0.00
free buffer inspected	644,058	11.92	81.10
free buffer requested	703,685	13.03	88.60
heap block compress	141,560	2.62	17.82
hot buffers moved to head of LRU	148,766	2.75	18.73
immediate (CR) block cleanout applications	57,966	1.07	7.30
immediate (CURRENT) block cleanout applications	57,388	1.06	7.23
index crx upgrade (found)	2	0.00	0.00
index crx upgrade (positioned)	69,233	1.28	8.72
index fast full scans (full)	2,064	0.04	0.26
index fetch by key	1,080,340	20.00	136.03
index scans kdiixs1	305,237	5.65	38.43
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 splits	891	0.02	0.11
leaf node 90-10 splits	145	0.00	0.02
lob reads	6,087	0.11	0.77
lob writes	198	0.00	0.02
lob writes unaligned	198	0.00	0.02
logons cumulative	1,743	0.03	0.22
messages received	46,422	0.86	5.85
messages sent	46,422	0.86	5.85
no buffer to keep pinned count	1	0.00	0.00
no work - consistent read gets	2,894,164	53.57	364.41
opened cursors cumulative	343,927	6.37	43.30
Parallel operations downgraded 25 to 50 pct	0	0.00	0.00
Parallel operations not downgraded	2	0.00	0.00
parse count (failures)	205	0.00	0.03
parse count (hard)	10,128	0.19	1.28
parse count (total)	338,342	6.26	42.60
parse time cpu	1,811	0.03	0.23
parse time elapsed	3,475	0.06	0.44
physical read bytes	2,877,079,552	53,256.30	362,261.34
physical read IO requests	129,749	2.40	16.34
physical read total bytes	###############	2,860,389.87	19,457,014.78
physical read total IO requests	673,657	12.47	84.82
physical read total multi block requests	239,707	4.44	30.18
physical reads	351,206	6.50	44.22
physical reads cache	274,489	5.08	34.56
physical reads cache prefetch	150,183	2.78	18.91
physical reads direct	76,717	1.42	9.66
physical reads direct (lob)	4	0.00	0.00
physical reads direct temporary tablespace	3,472	0.06	0.44
physical reads prefetch warmup	0	0.00	0.00
physical write bytes	5,755,994,112	106,546.57	724,753.73
physical write IO requests	382,514	7.08	48.16
physical write total bytes	18,867,766,272	349,252.58	2,375,694.57
physical write total IO requests	380,840	7.05	47.95
physical write total multi block requests	61,937	1.15	7.80
physical writes	702,636	13.01	88.47
physical writes direct	6,680	0.12	0.84
physical writes direct (lob)	9	0.00	0.00
physical writes direct temporary tablespace	3,472	0.06	0.44
physical writes from cache	695,956	12.88	87.63
physical writes non checkpoint	470,819	8.72	59.28
pinned buffers inspected	2,298	0.04	0.29
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	77,398	1.43	9.75
process last non-idle time	54,185	1.00	6.82
PX local messages recv'd	89,806	1.66	11.31
PX local messages sent	89,806	1.66	11.31
queries parallelized	2	0.00	0.00
recursive calls	4,628,780	85.68	582.82
recursive cpu usage	14,844	0.27	1.87
redo blocks written	11,511,054	213.08	1,449.39
redo buffer allocation retries	398	0.01	0.05
redo entries	13,528,664	250.42	1,703.43
redo log space requests	524	0.01	0.07
redo log space wait time	14,276	0.26	1.80
redo ordering marks	323,483	5.99	40.73
redo size	5,698,265,172	105,477.98	717,484.91
redo subscn max counts	448,470	8.30	56.47
redo synch time	3,528	0.07	0.44
redo synch writes	29,411	0.54	3.70
redo wastage	8,192,736	151.65	1,031.57
redo write time	16,884	0.31	2.13
redo writer latching time	16	0.00	0.00
redo writes	27,947	0.52	3.52
rollback changes - undo records applied	253,069	4.68	31.86
rollbacks only - consistent read gets	2,581	0.05	0.32
rows fetched via callback	727,303	13.46	91.58
session connect time	0	0.00	0.00
session cursor cache hits	356,165	6.59	44.85
session logical reads	35,316,147	653.72	4,446.76
session pga memory	1,664,505,528	30,810.90	209,582.67
session pga memory max	2,295,748,280	42,495.55	289,064.25
session uga memory	###############	86,022,258.53	585,142,736.40
session uga memory max	1,912,363,824	35,398.89	240,791.21
shared hash latch upgrades - no wait	94,117	1.74	11.85
shared hash latch upgrades - wait	2	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	94,509	1.75	11.90
sorts (rows)	5,073,096	93.91	638.77
sql area evicted	3,474	0.06	0.44
sql area purged	650	0.01	0.08
SQL*Net roundtrips to/from client	2,687,429	49.75	338.38
summed dirty queue length	36,497	0.68	4.60
switch current to new buffer	84,168	1.56	10.60
table fetch by rowid	2,377,830	44.01	299.40
table fetch continued row	12,206	0.23	1.54
table scan blocks gotten	1,287,936	23.84	162.17
table scan rows gotten	90,700,831	1,678.92	11,420.40
table scans (direct read)	104	0.00	0.01
table scans (long tables)	119	0.00	0.01
table scans (rowid ranges)	104	0.00	0.01
table scans (short tables)	50,628	0.94	6.37
total number of times SMON posted	343	0.01	0.04
transaction rollbacks	21	0.00	0.00
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	2,502,722,564	46,326.75	315,124.98
user calls	2,723,158	50.41	342.88
user commits	7,779	0.14	0.98
user I/O wait time	62,328	1.15	7.85
user rollbacks	163	0.00	0.02
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	51,765	0.96	6.52
write clones created in background	303	0.01	0.04
write clones created in foreground	579	0.01	0.07

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	234,069	258,897
opened cursors current	284	350
logons current	44	41

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)	162	10.80

Back to Instance Activity Statistics
Back to Top

IO Stats

• Tablespace IO Stats
• File IO Stats

Back to Top

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)
ESTTBLL	98,504	2	122.52	3.15	139,920	3	0	0.00
UNDOTBS1	174	0	25673.91	1.00	176,072	3	1	10.00
ESTIDXL	25,726	0	413.06	1.24	39,882	1	0	0.00
SYSTEM	1,878	0	465.23	1.00	18,669	0	0	0.00
SYSAUX	974	0	643.13	1.09	5,021	0	0	0.00
DIVTBLS	294	0	1129.49	1.00	691	0	0	0.00
SCGTBLS	384	0	1626.38	1.10	557	0	0	0.00
USERS	259	0	1415.25	1.00	159	0	0	0.00
OWBTBLS	162	0	2294.75	1.00	159	0	0	0.00
DIVIDXS	159	0	2057.42	1.00	159	0	0	0.00
DWHIDXS	159	0	4404.28	1.00	159	0	0	0.00
DWHTBLS	159	0	3893.65	1.00	159	0	0	0.00
ESTIMTV	159	0	10140.31	1.00	159	0	0	0.00
ESTMTV	159	0	15406.79	1.00	159	0	0	0.00
LOGMNRTS	159	0	2353.46	1.00	159	0	0	0.00
OWBIDXS	159	0	2076.86	1.00	159	0	0	0.00
SCGIDXS	159	0	4407.86	1.00	159	0	0	0.00
TEMP	112	0	25.54	31.00	112	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)
DIVIDXS	/dev/rBPODWHdividxS01	159	0	2057.42	1.00	159	0	0	0.00
DIVTBLS	/dev/rBPODWHdivtblS01	294	0	1129.49	1.00	691	0	0	0.00
DWHIDXS	/dev/rBPODWHdwhidxS01	159	0	4404.28	1.00	159	0	0	0.00
DWHTBLS	/dev/rBPODWHdwhtblS01	159	0	3893.65	1.00	159	0	0	0.00
ESTIDXL	/dev/rBPODWHestidxL01	13,690	0	452.92	1.00	174	0	0	0.00
ESTIDXL	/dev/rBPODWHestidxL02	12,036	0	367.74	1.51	39,708	1	0	0.00
ESTIMTV	/dev/rBPODWHestimtV01	159	0	10140.31	1.00	159	0	0	0.00
ESTMTV	/dev/rBPODWHestmtV01	159	0	15406.79	1.00	159	0	0	0.00
ESTTBLL	/dev/rBPODWHesttblL01	73,875	1	111.95	2.14	24,133	0	0	0.00
ESTTBLL	/dev/rBPODWHesttblL02	24,629	0	154.24	6.17	115,787	2	0	0.00
LOGMNRTS	/dev/rBPODWHlgmtblS01	159	0	2353.46	1.00	159	0	0	0.00
OWBIDXS	/dev/rBPODWHowbidxS01	159	0	2076.86	1.00	159	0	0	0.00
OWBTBLS	/dev/rBPODWHowbtblS01	162	0	2294.75	1.00	159	0	0	0.00
SCGIDXS	/dev/rBPODWHscgidxS01	159	0	4407.86	1.00	159	0	0	0.00
SCGTBLS	/dev/rBPODWHscgtblS01	384	0	1626.38	1.10	557	0	0	0.00
SYSAUX	/dev/rBPODWHobjsaux01	974	0	643.13	1.09	5,021	0	0	0.00
SYSTEM	/dev/rBPODWHobjsyst01	1,878	0	465.23	1.00	18,669	0	0	0.00
TEMP	/dev/rBPODWHobjtemp01	112	0	25.54	31.00	112	0	0
UNDOTBS1	/dev/rBPODWHobjundo01	174	0	25673.91	1.00	176,072	3	1	10.00
USERS	/dev/rBPODWHobjuser01	259	0	1415.25	1.00	159	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	215,809	99	35,244,299	274,487	695,956	0	0	1

Back to Top

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

Back to Top

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	13	197	789	2593	183330	2593
E	0	20	1195	183870	183330	183330	500325

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	176	0.10	21,769	1.69	42,154,161
D	352	0.20	43,538	1.52	37,956,707
D	528	0.30	65,307	1.41	35,190,657
D	704	0.40	87,076	1.34	33,301,367
D	880	0.50	108,845	1.23	30,722,161
D	1,056	0.59	130,614	1.13	28,082,244
D	1,232	0.69	152,383	1.07	26,573,769
D	1,408	0.79	174,152	1.03	25,620,803
D	1,584	0.89	195,921	1.01	25,176,497
D	1,760	0.99	217,690	1.00	24,917,778
D	1,776	1.00	219,669	1.00	24,902,895
D	1,936	1.09	239,459	0.99	24,743,196
D	2,112	1.19	261,228	0.98	24,497,776
D	2,288	1.29	282,997	0.97	24,204,722
D	2,464	1.39	304,766	0.97	24,061,131
D	2,640	1.49	326,535	0.96	23,973,353
D	2,816	1.59	348,304	0.96	23,861,805
D	2,992	1.68	370,073	0.95	23,682,309
D	3,168	1.78	391,842	0.93	23,139,470
D	3,344	1.88	413,611	0.91	22,780,697
D	3,520	1.98	435,380	0.89	22,238,329

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	2,152	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	399	257	219.35	0.00	0.00	0.00	0.00	81,715
E	399	253	237.17	0.00	0.00	0.00	0.00	81,715

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	M-Pass Execs
2K	4K	49,363	49,363	0	0
64K	128K	81	81	0	0
128K	256K	102	102	0	0
256K	512K	22	22	0	0
512K	1024K	1,478	1,478	0	0
1M	2M	707	707	0	0
2M	4M	4	4	0	0
8M	16M	7	7	0	0

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
50	0.13	110,401.67	244,563.63	31.00	834
100	0.25	110,401.67	238,657.61	32.00	740
200	0.50	110,401.67	130,137.16	46.00	6
299	0.75	110,401.67	79,667.95	58.00	0
399	1.00	110,401.67	42,128.69	72.00	0
479	1.20	110,401.67	27,554.75	80.00	0
559	1.40	110,401.67	20,226.04	85.00	0
638	1.60	110,401.67	18,943.45	85.00	0
718	1.80	110,401.67	14,744.73	88.00	0
798	2.00	110,401.67	12,549.27	90.00	0
1,197	3.00	110,401.67	7,360.05	94.00	0
1,596	4.00	110,401.67	6,816.11	94.00	0
2,394	6.00	110,401.67	6,816.11	94.00	0
3,192	8.00	110,401.67	6,816.11	94.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
96	0.50	35	2,717	881,667	0.80	225,946	166.87	6,067,468
128	0.67	65	4,517	1,006,053	0.91	101,560	75.01	6,098,297
160	0.83	96	5,885	1,070,865	0.97	36,748	27.14	6,115,329
192	1.00	127	7,333	1,106,259	1.00	1,354	1.00	6,127,133
224	1.17	158	9,096	1,136,891	1.03	1	0.00	6,135,505
256	1.33	189	11,056	1,157,390	1.05	1	0.00	6,142,170
288	1.50	220	12,571	1,169,332	1.06	1	0.00	6,147,881
320	1.67	251	13,816	1,176,933	1.06	1	0.00	6,152,911
352	1.83	282	14,995	1,182,842	1.07	1	0.00	6,155,401
384	2.00	313	16,841	1,187,416	1.07	1	0.00	6,157,721

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
500	0.25	931,857	42,153,090
1,000	0.50	893,537	33,302,609
1,500	0.75	864,475	26,573,854
2,000	1.00	857,274	24,902,871
2,500	1.25	854,275	24,205,591
3,000	1.50	852,817	23,861,931
3,500	1.75	848,102	22,781,146
4,000	2.00	845,788	22,238,264

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	11	202	11	1.00	1,354	1.00	200
32	2.00	11	202	11	1.00	1,354	1.00	200

Back to Advisory Statistics
Back to Top

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Back to Top

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
undo header	1	0	10

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	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
RO-Multiple Object Reuse (fast object reuse)	2,583	2,583	0	287	6	20.86
CF-Controlfile Transaction	85,377	85,320	57	138	1	5.46
TC-Tablespace Checkpoint	6	6	0	2	0	29.50
PS-PX Process Reservation	176	159	16	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Back to Top

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	312.06	19,233	99,838	4	789,566666666666666666666666666666666667/1678,95	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
19-Ago 14:53	5,664	121	99,838	2	1,679	0/0	0/0/0/0/0/0
19-Ago 14:43	3	107	99,236	1	1,669	0/0	0/0/0/0/0/0
19-Ago 14:33	3	160	98,636	1	1,659	0/0	0/0/0/0/0/0
19-Ago 14:23	2	64	98,036	1	1,649	0/0	0/0/0/0/0/0
19-Ago 14:13	127	537	97,436	4	1,639	0/0	0/0/0/0/0/0
19-Ago 14:03	75	175	96,836	3	1,629	0/0	0/0/0/0/0/0
19-Ago 13:53	11	70	96,236	3	1,619	0/0	0/0/0/0/0/0
19-Ago 13:43	5	110	95,636	1	1,609	0/0	0/0/0/0/0/0
19-Ago 13:33	2	63	95,036	1	1,599	0/0	0/0/0/0/0/0
19-Ago 13:23	9	337	94,435	1	1,589	0/0	0/0/0/0/0/0
19-Ago 13:13	119	342	93,832	3	1,579	0/0	0/0/0/0/0/0
19-Ago 13:03	66	193	93,232	3	1,569	0/0	0/0/0/0/0/0
19-Ago 12:53	5	112	92,632	1	1,559	0/0	0/0/0/0/0/0
19-Ago 12:43	33	394	92,032	3	1,549	0/0	0/0/0/0/0/0
19-Ago 12:33	6	97	91,432	1	1,539	0/0	0/0/0/0/0/0
19-Ago 12:23	9,538	1,750	90,832	3	1,529	0/0	0/0/0/0/0/0
19-Ago 12:13	1,090	548	90,231	4	1,519	0/0	0/0/0/0/0/0
19-Ago 12:03	1,037	148	89,633	4	1,509	0/0	0/0/0/0/0/0
19-Ago 11:53	1,277	175	89,033	2	1,499	0/0	0/0/0/0/0/0
19-Ago 11:43	1,583	236	88,432	3	1,489	0/0	0/0/0/0/0/0
19-Ago 11:33	130,255	265	87,832	2	1,479	0/0	0/0/0/0/0/0
19-Ago 11:23	158,487	92	87,230	2	1,469	0/0	0/0/0/0/0/0
19-Ago 11:13	166	602	86,630	3	1,459	0/0	0/0/0/0/0/0
19-Ago 11:03	108	156	86,030	3	1,449	0/0	0/0/0/0/0/0
19-Ago 10:53	52	247	85,430	1	1,439	0/0	0/0/0/0/0/0
19-Ago 10:43	5	88	84,830	1	1,429	0/0	0/0/0/0/0/0
19-Ago 10:33	18	269	84,230	2	1,419	0/0	0/0/0/0/0/0
19-Ago 10:23	2	75	83,630	1	1,409	0/0	0/0/0/0/0/0
19-Ago 10:13	127	527	83,030	4	1,399	0/0	0/0/0/0/0/0
19-Ago 10:03	77	186	82,429	3	1,389	0/0	0/0/0/0/0/0
19-Ago 09:53	10	239	81,829	1	1,379	0/0	0/0/0/0/0/0
19-Ago 09:43	4	104	81,229	1	1,369	0/0	0/0/0/0/0/0
19-Ago 09:33	6	62	80,629	1	1,359	0/0	0/0/0/0/0/0
19-Ago 09:23	3	161	80,029	1	1,349	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Back to Top

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
active checkpoint queue latch	45,929	0.00		0	0
active service list	116,147	0.02	0.00	0	18,336	0.00
archive control	1,962	0.00		0	0
archive process latch	19,357	0.00		0	0
ASM db client latch	36,684	0.00		0	0
AWR Alerted Metric Element list	217,352	0.00		0	0
begin backup scn array	63	0.00		0	0
cache buffer handles	8,459	0.00		0	0
cache buffers chains	128,215,053	0.00	0.01	0	926,468	0.00
cache buffers lru chain	1,564,353	0.12	0.00	0	855,177	0.03
cache table scan latch	0			0	5,468	0.00
channel handle pool latch	2,023	0.20	0.00	0	0
channel operations parent latch	262,968	0.00	0.00	0	0
checkpoint queue latch	1,723,802	0.01	0.01	0	694,322	0.02
client/application info	31,509	0.00		0	0
commit callback allocation	4	0.00		0	0
compile environment latch	645,871	0.00		0	0
Consistent RBA	28,116	0.03	0.00	0	0
device information	38	0.00		0	0
dictionary lookup	348	0.00		0	0
dml lock allocation	234,233	0.00	0.00	0	0
dummy allocation	3,553	0.23	0.00	0	0
enqueue hash chains	1,422,142	0.00	0.00	0	964	0.00
enqueues	1,712,717	0.00	0.05	0	0
error message lists	34	5.88	0.00	0	0
event group latch	661	0.00		0	0
FAL request queue	1,403	0.00		0	0
FAL subheap alocation	1,403	0.00		0	0
FIB s.o chain latch	54,192	0.00		0	0
file cache latch	4,713	0.00		0	0
FOB s.o list latch	55,846	0.00	0.00	0	0
global KZLD latch for mem in SGA	265	0.00		0	0
hash table column usage latch	6,848	0.00		0	483,531	0.00
hash table modification latch	1,405	0.00		0	0
In memory undo latch	36	0.00		0	0
internal temp table object number allocation latc	4,687	0.00		0	0
job workq parent latch	0			0	2,164	0.00
job_queue_processes parameter latch	1,946	0.00		0	0
JS mem alloc latch	147	0.00		0	0
JS queue access latch	147	0.00		0	0
JS queue state obj latch	390,544	0.00		0	0
JS slv state obj latch	2,070	0.00		0	0
kks stats	53,878	0.00		0	0
kmcptab latch	4	0.00		0	0
kmcpvec latch	0			0	4	0.00
KMG MMAN ready and startup request latch	18,004	0.00		0	0
krbmrosl	1,121	0.00		0	0
ksuosstats global area	3,632	0.00		0	0
KTF sga latch	2,424	0.00		0	16,565	0.00
ktm global data	518	0.00		0	0
kwqbsn:qsga	1,927	0.00		0	0
KWQMN job cache list latch	13	0.00		0	0
lgwr LWN SCN	35,058	0.14	0.00	0	0
library cache	2,806,508	0.00	0.03	0	46,575	0.01
library cache load lock	43,036	0.00	0.00	0	0
library cache lock	968,898	0.00	0.00	0	0
library cache lock allocation	30,003	0.00		0	0
library cache pin	925,547	0.00	0.00	0	0
library cache pin allocation	8,847	0.00		0	0
list of block allocation	23,651	0.00		0	0
loader state object freelist	2,198	0.09	0.00	0	0
longop free list parent	20,581	0.00		0	55	0.00
Memory Management Latch	0			0	18,004	0.00
message pool operations parent latch	1,559	0.00		0	0
messages	470,474	0.00	0.00	0	0
mostly latch-free SCN	35,336	0.82	0.00	0	0
MQL Tracking Latch	0			0	1,080	0.00
multiblock read objects	14,548	0.00		0	0
ncodef allocation latch	1,001	0.00		0	0
object queue header heap	88,976	0.00		0	1,631	0.00
object queue header operation	3,606,680	0.04	0.00	0	0
object stats modification	604	0.00		0	0
OS process	4,146	0.00		0	0
OS process allocation	20,765	0.01	0.00	0	0
OS process: request allocation	1,325	0.30	0.00	0	0
parallel query alloc buffer	8,084	0.02	0.00	0	0
parallel query stats	37	5.41	0.00	0	0
parameter list	1,214	0.00		0	0
parameter table allocation management	2,355	0.25	0.00	0	0
PL/SQL warning settings	25,455	0.00		0	0
post/wait queue	11,842	0.00		0	4,663	0.00
process allocation	1,327	0.08	0.00	0	660	0.15
process group creation	1,325	0.23	0.00	0	0
process queue	688	0.00		0	0
process queue reference	3,422,232	0.00	0.00	0	109,189	2551.80
qmn task queue latch	7,708	0.00		0	0
query server freelists	582	0.69	0.00	0	0
query server process	32	0.00		0	32	0.00
redo allocation	113,250	0.33	0.04	0	13,528,298	0.00
redo copy	0			0	13,528,436	0.01
redo writing	167,400	0.00	0.29	0	0
resmgr group change latch	7,153	0.00		0	0
resmgr:actses active list	3,520	0.06	0.00	0	0
resmgr:actses change group	1,447	0.00		0	0
resmgr:free threads list	3,489	0.29	0.00	0	0
resmgr:schema config	15	0.00		0	0
row cache objects	4,212,916	0.01	0.00	0	32,401	0.00
sequence cache	2,554	0.08	0.00	0	0
session allocation	5,062,381	0.01	0.01	0	0
session idle bit	6,103,661	0.00	0.21	0	0
session state list latch	4,570	0.20	0.00	0	0
session switching	1,001	0.00		0	0
session timer	18,336	0.00		0	0
SGA IO buffer pool latch	13,614	0.01	0.00	0	20,442	0.00
Shared B-Tree	1,927	0.00		0	0
shared pool	1,437,089	0.02	0.01	0	0
shared pool sim alloc	11	0.00		0	0
shared pool simulator	1,035,529	0.00		0	0
simulator hash latch	2,598,560	0.00	0.00	0	0
simulator lru latch	2,485,573	0.05	0.00	0	45,245	0.00
slave class	32	0.00		0	0
slave class create	128	11.72	1.00	0	0
sort extent pool	1,829	0.00		0	0
SQL memory manager latch	15	0.00		0	17,954	0.00
SQL memory manager workarea list latch	1,231,909	0.00		0	0
state object free list	30	0.00		0	0
statistics aggregation	1,680	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	4,457	0.00		0	0
transaction allocation	37,959	0.00		0	0
transaction branch allocation	1,001	0.00		0	0
undo global data	259,666	0.01	0.00	0	0
user lock	3,362	0.06	0.00	0	0
X$KSFQP	124	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	Sleep1	Sleep2	Sleep3
cache buffers lru chain	1,564,353	1,900	3	1,897	0	0	0
object queue header operation	3,606,680	1,426	7	1,419	0	0	0
simulator lru latch	2,485,573	1,201	2	1,199	0	0	0
session allocation	5,062,381	608	9	599	0	0	0
redo allocation	113,250	376	16	360	0	0	0
row cache objects	4,212,916	295	1	294	0	0	0
shared pool	1,437,089	227	2	225	0	0	0
cache buffers chains	128,215,053	188	1	187	0	0	0
checkpoint queue latch	1,723,802	168	1	167	0	0	0
library cache	2,806,508	115	3	112	0	0	0
enqueues	1,712,717	21	1	20	0	0	0
slave class create	128	15	15	0	0	0	0
session idle bit	6,103,661	14	3	11	0	0	0
redo writing	167,400	7	2	5	0	0	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	NoWait Misses	Sleeps	Waiter Sleeps
cache buffers chains	kcbchg: kslbegin: bufs not pinned	0	1	0
cache buffers lru chain	kcbzgws	0	2	0
cache buffers lru chain	kcbbxsv: move to being written	0	1	0
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	0	1	0
enqueues	ksqgel: create enqueue	0	1	0
library cache	kglobpn: child:	0	1	0
library cache	kglpndl: child: after processing	0	1	0
library cache	kglpnp: child	0	1	0
object queue header operation	kcbo_switch_mq_bg	0	6	0
object queue header operation	kcbo_switch_q_bg	0	4	1
object queue header operation	kcbo_switch_cq	0	1	4
redo allocation	kcrfw_redo_gen: redo allocation 1	0	16	0
redo writing	kcrfwcr	0	2	2
row cache objects	kqreqd: reget	0	1	0
session allocation	ksuprc	0	6	0
session allocation	ksudlc	0	2	0
session allocation	ksuxds: KSUSFCLC not set	0	1	1
session idle bit	ksupuc: set busy	0	3	0
shared pool	kghalo	0	2	1
simulator lru latch	kcbs_simbufseq	0	1	1
simulator lru latch	kcbs_simulate: simulate set	0	1	1
slave class create	ksvcreate	0	15	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

Back to Top

Segments by Logical Reads

• Total Logical Reads: 35,316,147
• Captured Segments account for 90.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
EST	ESTTBLL	EST_ASA_DET_CAL_ESC_08		TABLE	3,426,416	9.70
EST	ESTTBLL	EST_PGR_GGE_FK_I		INDEX	2,600,240	7.36
EST	ESTIDXL	EST_PAR_GGE_FK_I		INDEX	2,598,048	7.36
EST	ESTTBLL	EST_PGR_PPA_FK_I		INDEX	2,501,664	7.08
EST	ESTTBLL	EST_PGR_GCU_03_PAG_FK_I		INDEX	2,470,976	7.00

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 351,206
• Captured Segments account for 96.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
EST	ESTTBLL	EST_ASA_DET_CAL_ESC_08		TABLE	107,933	30.73
EST	ESTTBLL	EST_PUN_PED_UNI_07		TABLE	70,161	19.98
EST	ESTTBLL	EST_PUN_DET_UTI_PAR_07		TABLE	57,974	16.51
EST	ESTTBLL	EST_ASA_PARCELAS_08		TABLE	24,856	7.08
EST	ESTIDXL	EPD_GCU_I		INDEX	13,667	3.89

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
EST	ESTIDXL	PRO_PK_08		INDEX	156	93.41
SCG	SCGTBLS	SCG_DWF_BOLITEN_PK		INDEX	6	3.59
SYS	SYSAUX	WRH$_SYSTEM_EVENT_PK	4401_11631	INDEX PARTITION	2	1.20
SYS	SYSAUX	WRH$_WAITSTAT_PK	4401_11631	INDEX PARTITION	2	1.20
DISCOV	SCGTBLS	EUL5_EXP_PK		INDEX	1	0.60

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 (<>
• "Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Scan Reqs	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	959	0.00	0		30	1
dc_constraints	24	54.17	0		24	0
dc_files	95	100.00	0		0	0
dc_global_oids	93,617	0.36	0		1	16
dc_histogram_data	143,366	13.65	0		0	1,259
dc_histogram_defs	107,740	34.51	0		0	1,085
dc_object_grants	4,350	35.22	0		0	71
dc_object_ids	348,175	1.96	0		3	470
dc_objects	41,743	14.78	0		408	424
dc_profiles	1,377	0.07	0		0	1
dc_rollback_segments	10,342	0.00	0		0	21
dc_segments	40,604	25.26	0		2,210	422
dc_sequences	431	12.53	0		431	1
dc_tablespace_quotas	16	25.00	0		0	0
dc_tablespaces	348,488	0.02	0		0	18
dc_usernames	7,125	1.81	0		0	20
dc_users	336,961	0.14	0		0	101
outstanding_alerts	1,710	6.20	0		0	18

Back to Top

Library Cache Activity

• "Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	10,785	0.64	65,922	0.43	214	0
CLUSTER	845	1.89	1,529	2.94	29	0
INDEX	438	44.29	896	33.59	107	0
SQL AREA	13,625	57.51	1,404,231	2.05	5,021	1,395
TABLE/PROCEDURE	31,754	13.09	346,473	5.86	7,595	0
TRIGGER	721	6.10	2,786	2.73	32	0

Back to Top

Memory Statistics

• Process Memory Summary
• SGA Memory Summary
• SGA breakdown difference

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	190.85		4.15	10.50	52	65	46	46
	Freeable	25.31	0.00	0.97	0.53	2		26	26
	SQL	2.22	1.04	0.06	0.04	0	80	36	31
	PL/SQL	1.00	0.68	0.02	0.02	0	0	44	44
E	Other	211.26		4.91	13.38	74	93	43	43
	Freeable	22.94	0.00	1.00	0.55	2		23	23
	SQL	2.14	1.01	0.06	0.04	0	7	33	29
	PL/SQL	0.85	0.58	0.02	0.02	0	0	41	41

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,845,493,760
Fixed Size	2,074,152
Redo Buffers	14,700,544
Variable Size	234,883,544

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.86	4.86	0.00
java	joxlod exec hp	10.69	10.69	0.00
java	joxs heap	0.45	0.45	0.00
large	free memory	14.97	14.97	0.00
large	PX msg pool	1.03	1.03	0.00
shared	ASH buffers	8.00	8.00	0.00
shared	CCursor	3.44	3.07	-10.79
shared	db_block_hash_buckets	11.25	11.25	0.00
shared	free memory	84.23	86.36	2.53
shared	Heap0: KGL		2.82
shared	KCB Table Scan Buffer	4.00	4.00	0.00
shared	KGH: NO ACCESS	63.80	65.38	2.49
shared	KGLS heap	2.80		-100.00
shared	kglsim hash table bkts	4.00	4.00	0.00
shared	KSFD SGA I/O b	4.00	4.00	0.00
shared	library cache	8.35	7.86	-5.83
shared	row cache	7.16	7.16	0.00
shared	sql area	8.47	9.30	9.75
shared	XDB Schema Cac	8.99	9.02	0.29
	buffer_cache	1,760.00	1,760.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

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Back to Top

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u01/apps/oradba/admin/BPODWH/adump
background_dump_dest	/u01/apps/oradba/admin/BPODWH/bdump
compatible	10.2.0.3.0
control_files	/dev/rBPODWHobjctl01, /dev/rBPODWHobjctl02, /dev/rBPODWHobjctl03
core_dump_dest	/u01/apps/oradba/admin/BPODWH/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	32
db_name	BPODWH
dispatchers	(PROTOCOL=TCP) (SERVICE=BPODWHXDB)
filesystemio_options	SETALL
job_queue_processes	10
lock_sga	TRUE
log_archive_dest_1	LOCATION=/u02/oradbf/BPODWH/arch mandatory reopen=300
log_archive_format	BPODWH_%t_%s_%r.arch
nls_language	PORTUGUESE
nls_territory	PORTUGAL
open_cursors	300
O7_DICTIONARY_ACCESSIBILITY	TRUE
pga_aggregate_target	418381824
processes	150
remote_login_passwordfile	EXCLUSIVE
sga_max_size	2097152000
sga_target	2097152000
star_transformation_enabled	TRUE
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/u01/apps/oradba/admin/BPODWH/udump

Back to Top

End of Report