WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

PRECISED 3261210183 precisedb 1 10.2.0.5.0 NO PRECISE1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
PRECISED	3261210183	precisedb	1	10.2.0.5.0	NO	PRECISE1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 14216 22-Jul-13 07:01:00 47 3.5

End Snap: 14218 22-Jul-13 09:00:43 47 2.5

Elapsed: 119.71 (mins)

DB Time: 123.40 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	14216	22-Jul-13 07:01:00	47	3.5
End Snap:	14218	22-Jul-13 09:00:43	47	2.5
Elapsed:		119.71 (mins)
DB Time:		123.40 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 1,264M 1,264M Std Block Size: 8K

Shared Pool Size: 3,824M 3,824M Log Buffer: 14,328K

	Begin	End
Buffer Cache:	1,264M	1,264M	Std Block Size:	8K
Shared Pool Size:	3,824M	3,824M	Log Buffer:	14,328K

Load Profile

Per Second Per Transaction

Redo size: 34,154.42 15,033.64

Logical reads: 442,847.33 194,926.72

Block changes: 240.64 105.92

Physical reads: 8.10 3.57

Physical writes: 8.74 3.85

User calls: 20.94 9.22

Parses: 15.87 6.99

Hard parses: 0.51 0.22

Sorts: 3.90 1.72

Logons: 0.01 0.00

Executes: 27.26 12.00

Transactions: 2.27

	Per Second	Per Transaction
Redo size:	34,154.42	15,033.64
Logical reads:	442,847.33	194,926.72
Block changes:	240.64	105.92
Physical reads:	8.10	3.57
Physical writes:	8.74	3.85
User calls:	20.94	9.22
Parses:	15.87	6.99
Hard parses:	0.51	0.22
Sorts:	3.90	1.72
Logons:	0.01	0.00
Executes:	27.26	12.00
Transactions:	2.27

% Blocks changed per Read: 0.05 Recursive Call %: 84.85

Rollback per transaction %: 22.32 Rows per Sort: 324.90

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 96.03 Soft Parse %: 96.80

Execute to Parse %: 41.76 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 82.29 % Non-Parse CPU: 99.56

Shared Pool Statistics

Begin End

Memory Usage %: 21.61 42.46

% SQL with executions>1: 94.28 93.88

% Memory for SQL w/exec>1: 85.45 86.23

	Begin	End
Memory Usage %:	21.61	42.46
% SQL with executions>1:	94.28	93.88
% Memory for SQL w/exec>1:	85.45	86.23

Top 5 Timed Events

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

CPU time 7,319 98.9

io done 45,275 216 5 2.9 System I/O

db file parallel write 26,988 156 6 2.1 System I/O

log file sync 12,684 89 7 1.2 Commit

log file parallel write 14,009 46 3 .6 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		7,319		98.9
io done	45,275	216	5	2.9	System I/O
db file parallel write	26,988	156	6	2.1	System I/O
log file sync	12,684	89	7	1.2	Commit
log file parallel write	14,009	46	3	.6	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): 7403.8s
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
DB CPU	7,319.41	98.86
sql execute elapsed time	7,111.43	96.05
parse time elapsed	43.67	0.59
hard parse elapsed time	38.61	0.52
PL/SQL execution elapsed time	10.80	0.15
PL/SQL compilation elapsed time	0.52	0.01
hard parse (sharing criteria) elapsed time	0.27	0.00
connection management call elapsed time	0.21	0.00
hard parse (bind mismatch) elapsed time	0.08	0.00
repeated bind elapsed time	0.05	0.00
DB time	7,403.82
background elapsed time	531.30
background cpu time	49.79

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
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%Total Call Time
CPU time			7,319		98.86
System I/O	115,197	0	450	4	6.07
Commit	12,684		89	7	1.20
Configuration	21	33	8	367	0.10
User I/O	29,529		6	0	0.08
Concurrency	1,604	1	3	2	0.04
Application	4,606		2	0	0.03
Other	602	4	1	1	0.01
Network	94,766		0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
io done	45,275	0	216	5	2.77
db file parallel write	26,988		156	6	1.65
log file sync	12,684		89	7	0.78
log file parallel write	14,009		46	3	0.86
control file parallel write	2,784		30	11	0.17
log buffer space	9	78	8	839	0.00
db file sequential read	25,986		3	0	1.59
library cache lock	163		2	13	0.01
SQL*Net break/reset to client	4,474		2	0	0.27
Log archive I/O	482		1	2	0.03
direct path sync	76		1	14	0.00
local write wait	128		1	8	0.01
db file scattered read	3,184		1	0	0.20
os thread startup	21		1	31	0.00
log file sequential read	485		1	1	0.03
rdbms ipc reply	50		0	10	0.00
enq: RO - fast object reuse	71		0	4	0.00
control file sequential read	25,172		0	0	1.54
log file switch completion	2		0	80	0.00
db file single write	11		0	14	0.00
SQL*Net more data from client	11,223		0	0	0.69
cursor: pin S wait on X	13	100	0	12	0.00
latch free	14		0	6	0.00
SQL*Net message to client	83,177		0	0	5.10
latch: library cache	117		0	1	0.01
buffer busy waits	401		0	0	0.02
latch: In memory undo latch	356		0	0	0.02
row cache lock	35		0	1	0.00
latch: cache buffers chains	341		0	0	0.02
latch: shared pool	113		0	0	0.01
LGWR wait for redo copy	438		0	0	0.03
reliable message	67		0	0	0.00
SQL*Net more data to client	366		0	0	0.02
enq: TX - index contention	17		0	0	0.00
enq: TX - row lock contention	61		0	0	0.00
log file single write	2		0	1	0.00
enq: TX - allocate ITL entry	10		0	0	0.00
direct path write	74		0	0	0.00
direct path read	62		0	0	0.00
buffer deadlock	28	96	0	0	0.00
latch: row cache objects	2		0	0	0.00
cursor: mutex X	24		0	0	0.00
kkdlgon	1		0	0	0.00
latch: object queue header operation	1		0	0	0.00
direct path write temp	8		0	0	0.00
latch: enqueue hash chains	1		0	0	0.00
latch: library cache pin	1		0	0	0.00
latch: session allocation	1		0	0	0.00
latch: redo allocation	1		0	0	0.00
SQL*Net message from client	83,193		120,171	1444	5.10
i/o slave wait	358,205	21	76,927	215	21.95
Streams AQ: qmn coordinator idle wait	528	52	7,014	13283	0.03
Streams AQ: qmn slave idle wait	255		7,014	27504	0.02
virtual circuit status	239	100	7,004	29306	0.01
Streams AQ: waiting for time management or cleanup tasks	2	100	5,323	2661560	0.00
jobq slave wait	80	100	234	2930	0.00
class slave wait	16		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)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
io done	45,274	0	216	5	2.77
db file parallel write	26,988		156	6	1.65
log file parallel write	14,009		46	3	0.86
control file parallel write	2,784		30	11	0.17
Log archive I/O	482		1	2	0.03
os thread startup	21		1	31	0.00
log file sequential read	485		1	1	0.03
db file single write	11		0	14	0.00
control file sequential read	6,394		0	0	0.39
events in waitclass Other	456		0	0	0.03
log file single write	2		0	1	0.00
latch: cache buffers chains	1		0	0	0.00
buffer busy waits	1		0	0	0.00
direct path write	1		-0	-0	0.00
i/o slave wait	358,205	21	76,927	215	21.95
rdbms ipc message	33,234	69	74,741	2249	2.04
pmon timer	2,404	100	7,014	2918	0.15
Streams AQ: qmn coordinator idle wait	528	52	7,014	13283	0.03
Streams AQ: qmn slave idle wait	255		7,014	27504	0.02
smon timer	26	81	6,662	256221	0.00
Streams AQ: waiting for time management or cleanup tasks	2	100	5,323	2661560	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	785,480
IDLE_TIME	10,736,824
IOWAIT_TIME	50,062
NICE_TIME	928
SYS_TIME	17,405
USER_TIME	766,291
LOAD	1
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	8,790,016
VM_OUT_BYTES	1,808,609,280
PHYSICAL_MEMORY_BYTES	67,555,950,592
NUM_CPUS	16
NUM_CPU_SOCKETS	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	7,404.30	7,319.50	21,214	3,178,957,787
SYS$BACKGROUND	0.00	0.00	36,991	1,857,576
precisedb	0.00	0.00	0	0
precisedbXDB	0.00	0.00	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

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
SYS$USERS	12213	3	1579	3	0	0	94640	0
SYS$BACKGROUND	17326	3	24	1	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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
6,236	6,378	9,293	0.67	84.23	cvhk2j2gymzhd	DBMS_SCHEDULER	SELECT SU.NAME, SO.NAME, A.STA...
407	416	18,592	0.02	5.50	djupx9h0ggd9t	Precise - pw.fp	SELECT /+ rule / OI.NAME FRO...
260	266	1,064	0.24	3.51	d89c1mh5pvbkz	DBMS_SCHEDULER	SELECT /+ rule / U.NAME, OT....
41	42	1	41.15	0.56	4rsq427kszp0g	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
40	41	1	40.20	0.54	8x5n0dyzwwp5q	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
40	40	1	39.60	0.53	dwfnyy9pnxwrn	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
39	40	1	39.17	0.53	du25gntfqdm1u	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
39	40	1	39.09	0.53	fyfy49x4t6aph	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
39	40	1	39.08	0.53	2xf9aphjb3jz6	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
39	40	1	38.78	0.52	2n9ydz0cvgzur	Precise - pw.fp	BEGIN dbms_stats.gather_table_...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
6,378	6,236	9,293	0.69	87.13	84.23	cvhk2j2gymzhd	DBMS_SCHEDULER	SELECT SU.NAME, SO.NAME, A.STA...
416	407	18,592	0.02	5.69	5.50	djupx9h0ggd9t	Precise - pw.fp	SELECT /+ rule / OI.NAME FRO...
266	260	1,064	0.25	3.63	3.51	d89c1mh5pvbkz	DBMS_SCHEDULER	SELECT /+ rule / U.NAME, OT....
42	41	1	41.87	0.57	0.56	4rsq427kszp0g	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
41	40	1	41.08	0.56	0.54	8x5n0dyzwwp5q	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
40	40	1	40.49	0.55	0.53	dwfnyy9pnxwrn	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
40	39	1	39.97	0.55	0.53	du25gntfqdm1u	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
40	39	1	39.94	0.55	0.53	fyfy49x4t6aph	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
40	39	1	39.87	0.54	0.53	2xf9aphjb3jz6	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
40	39	1	39.59	0.54	0.52	2n9ydz0cvgzur	Precise - pw.fp	BEGIN dbms_stats.gather_table_...

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: 3,180,814,283
Captured SQL account for 98.8% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
2,942,286,965	9,293	316,613.25	92.50	6377.57	6235.87	cvhk2j2gymzhd	DBMS_SCHEDULER	SELECT SU.NAME, SO.NAME, A.STA...
101,575,626	18,592	5,463.41	3.19	416.18	407.04	djupx9h0ggd9t	Precise - pw.fp	SELECT /+ rule / OI.NAME FRO...
97,213,471	1,064	91,366.04	3.06	265.83	260.01	d89c1mh5pvbkz	DBMS_SCHEDULER	SELECT /+ rule / U.NAME, OT....
16,934,012	1	16,934,012.00	0.53	40.49	39.60	dwfnyy9pnxwrn	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
16,926,118	1	16,926,118.00	0.53	39.94	39.09	fyfy49x4t6aph	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
16,919,790	1	16,919,790.00	0.53	39.00	38.10	1jk6pgwyzd9ag	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
16,919,677	1	16,919,677.00	0.53	39.01	38.14	8adbmwsnxtvu5	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
16,919,674	1	16,919,674.00	0.53	38.98	38.11	fh5pj4unjhjbb	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
16,919,665	1	16,919,665.00	0.53	39.01	38.13	8q32jht0j6m3z	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
16,919,560	1	16,919,560.00	0.53	39.19	38.36	af9ay6atjs58c	Precise - pw.fp	BEGIN dbms_stats.gather_table_...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 58,192
Captured SQL account for 0.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
5,673	1	5,673.00	9.75	41.08	40.20	8x5n0dyzwwp5q	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
3,436	1	3,436.00	5.90	40.49	39.60	dwfnyy9pnxwrn	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
146	63	2.32	0.25	0.02	0.44	g4nyrfxtg1pg1	Precise - db2.focal	INSERT INTO PW_UDSX_STATEMENT_...
112	1,064	0.11	0.19	265.83	260.01	d89c1mh5pvbkz	DBMS_SCHEDULER	SELECT /+ rule / U.NAME, OT....
107	1	107.00	0.18	39.94	39.09	fyfy49x4t6aph	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
98	321	0.31	0.17	0.04	0.25	d5gr0tpsjj13a	Precise - db2.focal	INSERT INTO PW_UDEO_EXPLAIN_O...
49	4,394	0.01	0.08	0.11	0.55	1y41akzwjytsq	Precise - db2.focal	INSERT INTO PS_PWSC_SUMMARY_CO...
16	1,457	0.01	0.03	0.24	0.17	6cr55dpp3n44a		select obj#, type#, ctime, mti...
15	1	15.00	0.03	39.14	38.29	9z4950jfutn4z	Precise - pw.fp	BEGIN dbms_stats.gather_table_...
12	1	12.00	0.02	39.23	38.38	09gbgjxukvwfc	Precise - pw.fp	BEGIN dbms_stats.gather_table_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 195,763
Captured SQL account for 54.4% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
18,592	1,306	0.07	0.02	0.02	djupx9h0ggd9t	Precise - pw.fp	SELECT /+ rule / OI.NAME FRO...
15,092	15,090	1.00	0.00	0.00	bunvx480ynf57	Precise - main	SELECT 1 FROM DUAL
9,293	0	0.00	0.69	0.67	cvhk2j2gymzhd	DBMS_SCHEDULER	SELECT SU.NAME, SO.NAME, A.STA...
6,289	6,288	1.00	0.00	0.00	1y95zktz71h35	Precise - pw.fp	SELECT PWTR_PWII_ID, PWTR_TABL...
6,286	6,284	1.00	0.00	0.00	2qqznx6a98xv7	Precise - pw.fp	SELECT 1 FROM PW_PWII_INSTANCE...
4,394	4,394	1.00	0.00	0.00	1y41akzwjytsq	Precise - db2.focal	INSERT INTO PS_PWSC_SUMMARY_CO...
3,930	3,930	1.00	0.00	0.00	1bfzmm2bbajqq	Precise - pw.fp	UPDATE PW_PWJH_JOB_HISTORY SET...
3,920	3,920	1.00	0.00	0.00	9ccf9ygspmv2v	Precise - pw.fp	INSERT INTO PW_PWJH_JOB_HISTOR...
2,699	0	0.00	0.00	0.00	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
2,699	1,678	0.62	0.00	0.00	g00cj285jmgsw		update sys.mon_mods$ set inser...
2,361	2,361	1.00	0.00	0.00	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
2,199	2,199	1.00	0.00	0.00	307fr7b35zfr9	Precise - db2.focal	UPDATE PS_PWTR_TABLE_RANGE SET...
2,199	2,200	1.00	0.00	0.00	f54d62ubt511v	Precise - db2.focal	declare error boolean; st_syn_...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 114,021
Captured SQL account for 67.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
15,092	15,092	13.24	bunvx480ynf57	Precise - main	SELECT 1 FROM DUAL
6,288	6,289	5.51	1y95zktz71h35	Precise - pw.fp	SELECT PWTR_PWII_ID, PWTR_TABL...
6,283	6,286	5.51	2qqznx6a98xv7	Precise - pw.fp	SELECT 1 FROM PW_PWII_INSTANCE...
4,394	4,394	3.85	1y41akzwjytsq	Precise - db2.focal	INSERT INTO PS_PWSC_SUMMARY_CO...
3,930	3,930	3.45	1bfzmm2bbajqq	Precise - pw.fp	UPDATE PW_PWJH_JOB_HISTORY SET...
3,920	3,920	3.44	9ccf9ygspmv2v	Precise - pw.fp	INSERT INTO PW_PWJH_JOB_HISTOR...
2,699	2,699	2.37	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
2,699	2,699	2.37	g00cj285jmgsw		update sys.mon_mods$ set inser...
2,227	2,361	1.95	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
2,199	2,199	1.93	307fr7b35zfr9	Precise - db2.focal	UPDATE PS_PWTR_TABLE_RANGE SET...
2,192	2,199	1.92	f54d62ubt511v	Precise - db2.focal	declare error boolean; st_syn_...
1,782	1,782	1.56	bsa0wjtftg3uw		select file# from file$ where ...
1,755	1,755	1.54	9babjv8yq8ru3	SQL*Plus	BEGIN DBMS_OUTPUT.GET_LINES(:L...
1,561	1,561	1.37	9qgtwh66xg6nz		update seg$ set type#=:4, bloc...
1,508	1,508	1.32	2ym6hhaq30r73		select type#, blocks, extents,...
1,300	1,300	1.14	aq4js2gkfjru8		update tsq$ set blocks=:3, max...
1,263	1,263	1.11	5fbmafvm27kfm		insert into obj$(owner#, name,...
1,238	1,238	1.09	64wq3fa5a77sm		insert into seg$ (file#, block...
1,208	1,208	1.06	3kywng531fcxu		delete from tab_stats$ where o...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
4,228,069	1	0.11	84pt912vu3pw9	Precise - pw.fp	create global temporary table ...
4,225,877	1	0.11	bz5p1ybmhvb6t	Precise - pw.fp	create global temporary table ...

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

09gbgjxukvwfc BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDAS_APPLICATION_STATS_T', partname=>'P21072013_22072013_S1772', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

1bfzmm2bbajqq UPDATE PW_PWJH_JOB_HISTORY SET PWJH_PWII_ID = :1 , PWJH_END_TIMESTAMP = :2 , PWJH_PROCESSED_OBJECT = :3 , PWJH_SUB_PROCESS = :4 , PWJH_DATA_START_TIMESTAMP = :5 , PWJH_DATA_END_TIMESTAMP = :6 , PWJH_STATUS = :7 , PWJH_ROWS_PROCESSED = :8 , PWJH_ERROR_MESSAGE = :9 , PWJH_FILE_NAME = :10 WHERE PWJH_ID = :11

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

1jk6pgwyzd9ag BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S1309', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

1y41akzwjytsq INSERT INTO PS_PWSC_SUMMARY_CONTROLLER (PWSC_PWII_INSTANCE_ID, PWSC_TABLE_NAME, PWSC_DATA_START_TIMESTAMP, PWSC_PROCESS_START_TIMESTAMP) VALUES(:1 , :2 , :3 , :4 )

1y95zktz71h35 SELECT PWTR_PWII_ID, PWTR_TABLE_NAME, PWTR_SUMMARY_LEVEL, PWTR_START_TIMESTAMP, PWTR_END_TIMESTAMP FROM PS_PWTR_TABLE_RANGE WHERE PWTR_PWII_ID = :1 AND PWTR_TABLE_NAME = :2

2n9ydz0cvgzur BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S2138', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

2qqznx6a98xv7 SELECT 1 FROM PW_PWII_INSTANCE_ID WHERE PWII_ID = :1

2xf9aphjb3jz6 BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDAS_APPLICATION_STATS_T', partname=>'P21072013_22072013_S1768', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

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

307fr7b35zfr9 UPDATE PS_PWTR_TABLE_RANGE SET PWTR_END_TIMESTAMP = :1 WHERE PWTR_PWII_ID = :2 AND PWTR_TABLE_NAME = :3 AND PWTR_SUMMARY_LEVEL = :4

350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait

3kywng531fcxu delete from tab_stats$ where obj#=:1

4rsq427kszp0g BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDAS_APPLICATION_STATS_T', partname=>'P21072013_22072013_S2011', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

5fbmafvm27kfm insert into obj$(owner#, name, namespace, obj#, type#, ctime, mtime, stime, status, remoteowner, linkname, subname, dataobj#, flags, oid$, spare1, spare2)values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)

64wq3fa5a77sm insert into seg$ (file#, block#, type#, ts#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, lists, groups, cachehint, bitmapranges, hwmincr, spare1, scanhint) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, 0, :16, DECODE(:17, 0, NULL, :17), :18)

6cr55dpp3n44a select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname = :4

84pt912vu3pw9 create global temporary table sys.ora_temp_1_ds_663925 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"UDTS_POOL_TMP_DT_LR_STATS_SUM", "UDTS_POOL_TMP_DT_PR_STATS_SUM", "UDTS_BP_TMP_IDX_LR_STATS_SUM", "UDTS_BP_TMP_IDX_PR_STATS_SUM", "UDTS_AUT_PREFETCHSIZE_ENBL_MAX", "UDTS_USING_AUTO_STORAGE_MAX", "UDTS_FILE_SYSTEM_CACHING_MAX", "UDTS_TOTAL_NUM_OF_PAGES_MAX", "UDTS_NUM_OF_USABLE_PAGES_MAX", "UDTS_NUM_OF_USED_PAGES_MAX", "UDTS_MIN_RECOVERY_TIME_MAX", "UDTS_NUM_OF_QUIESCERS_MAX", "UDTS_NUM_OF_CONTAINERS_MAX", "UDTS_BP_NO_VICT_BUFF_STATS_SUM", "UDTS_PWII_INSTANCE_ID", "UDTS_TIMESTAMP", "UDTS_PWHG_ID", "UDTS_CLUSTER_ID", "UDTS_MINUTES_COUNT_SUM", "UDTS_BUFFER_POOL_ID", "UDTS_BUFFER_POOL_CAT_ID_MAX", "UDTS_TABLE_SPACE_ID", "UDTS_EXTENTSIZE_MAX", "UDTS_PREFETCHSIZE_MAX", "UDTS_PAGESIZE_MAX", "UDTS_BP_DT_LOG_RD_STATS_SUM", "UDTS_BP_DT_PHYS_RD_STATS_SUM", "UDTS_BP_ASYNC_DT_RD_STATS_SUM", "UDTS_BP_DT_WR_STATS_SUM", "UDTS_BP_ASYNC_DT_WR_STATS_SUM", "UDTS_BP_IDX_LOG_RD_STATS_SUM", "UDTS_BP_IDX_PHYS_RD_STATS_SUM", "UDTS_BP_ASYNC_IDX_RD_STATS_ SUM", "UDTS_BP_IDX_WR_STATS_SUM", "UDTS_BP_ASYNC_IDX_WR_STATS_SUM", "UDTS_BP_RD_TIME_SUM", "UDTS_BP_WR_TIME_SUM", "UDTS_BP_ASYNC_RD_TIME_SUM", "UDTS_BP_ASYNC_WR_TIME_SUM", "UDTS_BP_ASY_DT_RD_RQ_STATS_SUM", "UDTS_BP_ASY_IX_RD_RQ_STATS_SUM", "UDTS_DIRECT_RD_STATS_SUM", "UDTS_DIRECT_WR_STATS_SUM", "UDTS_DIRECT_RD_REQS_STATS_SUM", "UDTS_DIRECT_WR_REQS_STATS_SUM", "UDTS_DIRECT_RD_TIME_SUM", "UDTS_DIRECT_WR_TIME_SUM", "UDTS_FILES_CLOSED_STATS_SUM", rowid SYS_DS_ALIAS_0 from "PRECISE_PMDB"."PW_UDTS_TABLESPACES_STATS_T" sample ( 16.4073313923) t where 1 = 2

8adbmwsnxtvu5 BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S1371', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

8q32jht0j6m3z BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S1374', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

8x5n0dyzwwp5q BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDAS_APPLICATION_STATS_T', partname=>'P21072013_22072013', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'PARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

9babjv8yq8ru3 BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;

9ccf9ygspmv2v INSERT INTO PW_PWJH_JOB_HISTORY (PWJH_ID, PWJH_PWJG_ID, PWJH_PWII_ID, PWJH_BEGIN_TIMESTAMP, PWJH_PROCESSED_OBJECT, PWJH_DATA_START_TIMESTAMP, PWJH_DATA_END_TIMESTAMP, PWJH_END_TIMESTAMP, PWJH_STATUS, PWJH_ROWS_PROCESSED, PWJH_SUB_PROCESS, PWJH_PWSE_ID) VALUES (:1 , :2 , :3 , :4 , :5 , NULL, NULL, NULL, :6 , 0, :7 , :8 )

9qgtwh66xg6nz update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3

9z4950jfutn4z BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDAS_APPLICATION_STATS_T', partname=>'P21072013_22072013_S1441', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

af9ay6atjs58c BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S1329', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

aq4js2gkfjru8 update tsq$ set blocks=:3, maxblocks=:4, grantor#=:5, priv1=:6, priv2=:7, priv3=:8 where ts#=:1 and user#=:2

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

bunvx480ynf57 SELECT 1 FROM DUAL

bz5p1ybmhvb6t create global temporary table sys.ora_temp_1_ds_663924 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"UDTS_POOL_TMP_DT_LR_STATS_SUM", "UDTS_POOL_TMP_DT_PR_STATS_SUM", "UDTS_BP_TMP_IDX_LR_STATS_SUM", "UDTS_BP_TMP_IDX_PR_STATS_SUM", "UDTS_AUT_PREFETCHSIZE_ENBL_MAX", "UDTS_USING_AUTO_STORAGE_MAX", "UDTS_FILE_SYSTEM_CACHING_MAX", "UDTS_TOTAL_NUM_OF_PAGES_MAX", "UDTS_NUM_OF_USABLE_PAGES_MAX", "UDTS_NUM_OF_USED_PAGES_MAX", "UDTS_MIN_RECOVERY_TIME_MAX", "UDTS_NUM_OF_QUIESCERS_MAX", "UDTS_NUM_OF_CONTAINERS_MAX", "UDTS_BP_NO_VICT_BUFF_STATS_SUM", "UDTS_PWII_INSTANCE_ID", "UDTS_TIMESTAMP", "UDTS_PWHG_ID", "UDTS_CLUSTER_ID", "UDTS_MINUTES_COUNT_SUM", "UDTS_BUFFER_POOL_ID", "UDTS_BUFFER_POOL_CAT_ID_MAX", "UDTS_TABLE_SPACE_ID", "UDTS_EXTENTSIZE_MAX", "UDTS_PREFETCHSIZE_MAX", "UDTS_PAGESIZE_MAX", "UDTS_BP_DT_LOG_RD_STATS_SUM", "UDTS_BP_DT_PHYS_RD_STATS_SUM", "UDTS_BP_ASYNC_DT_RD_STATS_SUM", "UDTS_BP_DT_WR_STATS_SUM", "UDTS_BP_ASYNC_DT_WR_STATS_SUM", "UDTS_BP_IDX_LOG_RD_STATS_SUM", "UDTS_BP_IDX_PHYS_RD_STATS_SUM", "UDTS_BP_ASYNC_IDX_RD_STATS_ SUM", "UDTS_BP_IDX_WR_STATS_SUM", "UDTS_BP_ASYNC_IDX_WR_STATS_SUM", "UDTS_BP_RD_TIME_SUM", "UDTS_BP_WR_TIME_SUM", "UDTS_BP_ASYNC_RD_TIME_SUM", "UDTS_BP_ASYNC_WR_TIME_SUM", "UDTS_BP_ASY_DT_RD_RQ_STATS_SUM", "UDTS_BP_ASY_IX_RD_RQ_STATS_SUM", "UDTS_DIRECT_RD_STATS_SUM", "UDTS_DIRECT_WR_STATS_SUM", "UDTS_DIRECT_RD_REQS_STATS_SUM", "UDTS_DIRECT_WR_REQS_STATS_SUM", "UDTS_DIRECT_RD_TIME_SUM", "UDTS_DIRECT_WR_TIME_SUM", "UDTS_FILES_CLOSED_STATS_SUM", rowid SYS_DS_ALIAS_0 from "PRECISE_PMDB"."PW_UDTS_TABLESPACES_STATS_T" sample ( 3.6246688371) t where 1 = 2

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

d5gr0tpsjj13a INSERT INTO PW_UDEO_EXPLAIN_OPER ( UDEO_CLUSTER_ID, UDEO_STATEMENT_HV, UDEO_EXPLAIN_TIME, UDEO_OPERATOR_ID, UDEO_OPERATOR_TYPE, UDEO_OPTIONS, UDEO_PRE_FETCH, UDEO_EXECUTION_ORDER, UDEO_TREE_LEVEL, UDEO_ARGUMENTS_LIST, UDEO_REMOTE_QUERY_HV, UDEO_OBJECT_SCHEMA_NAME, UDEO_OBJECT_NAME, UDEO_OBJECT_TYPE, UDEO_BASE_SCHEMA_NAME, UDEO_BASE_TABLE_NAME, UDEO_TOTAL_ESTIMATED_COST, UDEO_FIRST_ROW_COST, UDEO_ESTIMATED_IO_COST, UDEO_ESTIMATED_CPU_COST, UDEO_ESTIMATED_COMM_COST, UDEO_CONTRIBUTION_RATIO, UDEO_PARENT_OP_ID, UDEO_FILTER_FACTOR, UDEO_MAX_ROWS, UDEO_MAX_PAGES, UDEO_PART_NUM, UDEO_LAST_EXPLAIN_IND, UDEO_MAX_EXECUTION_ORDER, UDEO_HAS_CHILD, UDEO_SONS_LIST, UDEO_TOTAL_COST_PERCENT) 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 )

d89c1mh5pvbkz SELECT /*+ rule */ U.NAME, OT.NAME, NULL, NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.COL$ C, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE :B4 IS NULL AND U.NAME = :B3 AND OT.OWNER# = U.USER# AND OT.NAME = :B2 AND OT.TYPE# = 2 AND C.OBJ# = OT.OBJ# AND (:B1 IS NULL OR C.NAME = :B1 ) AND H.OBJ# = OT.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OT.NAME, OP.SUBNAME, NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.COL$ C, SYS.TABPART$ TP, SYS.OBJ$ OP, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OT.OWNER# = U.USER# AND OT.NAME = :B2 AND OT.TYPE# = 2 AND C.OBJ# = OT.OBJ# AND (:B1 IS NULL OR C.NAME = :B1 ) AND TP.BO# = OT.OBJ# AND TP.OBJ# = OP.OBJ# AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR OP.SUBNAME = :B4 ) AND H.OBJ# = OP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OP.NAME, OP.SUBNAME , NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.COL$ C, SYS.TABCOMPART$ TP, SYS.OBJ$ OP, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OP.OWNER# = U.USER# AND OP.NAME = :B2 AND OP.TYPE# = 19 AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR OP.SUBNAME = :B4 ) AND TP.OBJ# = OP.OBJ# AND C.OBJ# = TP.BO# AND (:B1 IS NULL OR C.NAME = :B1 ) AND H.OBJ# = OP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OP.NAME, OP.SUBNAME, OS.SUBNAME, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.COL$ C, SYS.TABCOMPART$ TP, SYS.OBJ$ OP, SYS.TABSUBPART$ TS, SYS.OBJ$ OS, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OP.OWNER# = U.USER# AND OP.NAME = :B2 AND OP.TYPE# = 19 AND TP.OBJ# = OP.OBJ# AND C.OBJ# = TP.BO# AND (:B1 IS NULL OR C.NAME = :B1 ) AND TS.POBJ# = TP.OBJ# AND TS.OBJ# = OS.OBJ# AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR (OP.SUBNAME = :B4 AND (:B5 IS NOT NULL OR OS.SUBNAME IS NULL)) OR OS.SUBNAME = :B4 ) AND H.OBJ# = OS.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# ORDER BY 1, 2, 3, 4, 5, 22

djupx9h0ggd9t SELECT /*+ rule */ OI.NAME FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.COL$ C, SYS.ICOL$ IC, SYS.OBJ$ OI WHERE U.NAME = :B3 AND OT.OWNER# = U.USER# AND OT.NAME = :B2 AND OT.TYPE# = 2 AND OT.OBJ# = C.OBJ# AND C.NAME = :B1 AND OT.OBJ# = IC.BO# AND IC.INTCOL# = C.INTCOL# AND IC.OBJ# = OI.OBJ#

du25gntfqdm1u BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDAS_APPLICATION_STATS_T', partname=>'P21072013_22072013_S2036', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

dwfnyy9pnxwrn BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'PARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

f54d62ubt511v declare error boolean; st_syn_detected EXCEPTION; PRAGMA EXCEPTION_INIT(st_syn_detected, -995); BEGIN if((sys.dbms_standard.dictionary_obj_type != 'SYNONYM')or(sys.dbms_standard.dictionary_obj_owner != 'PUBLIC')) then return; end if; error := CASE sys.dbms_standard.dictionary_obj_name WHEN 'ST_GEOMETRY' THEN TRUE WHEN 'ST_SURFACE' THEN TRUE WHEN 'ST_POLYGON' THEN TRUE WHEN 'ST_POINT' THEN TRUE WHEN 'ST_MULTISURFACE' THEN TRUE WHEN 'ST_MULTIPOINT' THEN TRUE WHEN 'ST_MULTILINESTRING' THEN TRUE WHEN 'ST_MULTICURVE' THEN TRUE WHEN 'ST_LINESTRING' THEN TRUE WHEN 'ST_GEOMCOLLECTION' THEN TRUE WHEN 'ST_CURVE' THEN TRUE WHEN 'ST_CURVEPOLYGON' THEN TRUE WHEN 'ST_COMPOUNDCURVE' THEN TRUE WHEN 'ST_CIRCULARSTRING' THEN TRUE WHEN 'ST_INTERSECTS' THEN TRUE WHEN 'ST_RELATE' THEN TRUE WHEN 'ST_TOUCH' THEN TRUE WHEN 'ST_CONTAINS' THEN TRUE WHEN 'ST_COVERS' THEN TRUE WHEN 'ST_COVEREDBY' THEN TRUE WHEN 'ST_INSIDE' THEN TRUE WHEN 'ST_OVERLAP' THEN TRUE WHEN 'ST_OVERLAPS' THEN TRUE WHEN 'ST_EQUAL' THEN TRUE WHEN 'ST_OVERLAPBDYDISJOINT' THEN TRUE WHEN 'ST_OVERLAPBDYINTERSECT' THEN TRUE WHEN 'ST_GEOMETRY_ARRAY' THEN TRUE WHEN 'ST_POINT_ARRAY' THEN TRUE WHEN 'ST_CURVE_ARRAY' THEN TRUE WHEN 'ST_SURFACE_A RRAY' THEN TRUE WHEN 'ST_LINESTRING_ARRAY' THEN TRUE WHEN 'ST_POLYGON_ARRAY' THEN TRUE ELSE FALSE END; if(error) then raise st_syn_detected; end if; END;

fh5pj4unjhjbb BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S1377', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

fyfy49x4t6aph BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S1107', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;

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

g4nyrfxtg1pg1 INSERT INTO PW_UDSX_STATEMENT_TEXT(UDSX_STATEMENT_HV, UDSX_CONSISTENT_HV, UDSX_STATEMENT_TEXT, UDSX_UNFORMATTED_TEXT) VALUES (:1 , :2 , :3 , :4 )

SQL Id	SQL Text
09gbgjxukvwfc	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDAS_APPLICATION_STATS_T', partname=>'P21072013_22072013_S1772', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
1bfzmm2bbajqq	UPDATE PW_PWJH_JOB_HISTORY SET PWJH_PWII_ID = :1 , PWJH_END_TIMESTAMP = :2 , PWJH_PROCESSED_OBJECT = :3 , PWJH_SUB_PROCESS = :4 , PWJH_DATA_START_TIMESTAMP = :5 , PWJH_DATA_END_TIMESTAMP = :6 , PWJH_STATUS = :7 , PWJH_ROWS_PROCESSED = :8 , PWJH_ERROR_MESSAGE = :9 , PWJH_FILE_NAME = :10 WHERE PWJH_ID = :11
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1jk6pgwyzd9ag	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S1309', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
1y41akzwjytsq	INSERT INTO PS_PWSC_SUMMARY_CONTROLLER (PWSC_PWII_INSTANCE_ID, PWSC_TABLE_NAME, PWSC_DATA_START_TIMESTAMP, PWSC_PROCESS_START_TIMESTAMP) VALUES(:1 , :2 , :3 , :4 )
1y95zktz71h35	SELECT PWTR_PWII_ID, PWTR_TABLE_NAME, PWTR_SUMMARY_LEVEL, PWTR_START_TIMESTAMP, PWTR_END_TIMESTAMP FROM PS_PWTR_TABLE_RANGE WHERE PWTR_PWII_ID = :1 AND PWTR_TABLE_NAME = :2
2n9ydz0cvgzur	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S2138', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
2qqznx6a98xv7	SELECT 1 FROM PW_PWII_INSTANCE_ID WHERE PWII_ID = :1
2xf9aphjb3jz6	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDAS_APPLICATION_STATS_T', partname=>'P21072013_22072013_S1768', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
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
307fr7b35zfr9	UPDATE PS_PWTR_TABLE_RANGE SET PWTR_END_TIMESTAMP = :1 WHERE PWTR_PWII_ID = :2 AND PWTR_TABLE_NAME = :3 AND PWTR_SUMMARY_LEVEL = :4
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
3kywng531fcxu	delete from tab_stats$ where obj#=:1
4rsq427kszp0g	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDAS_APPLICATION_STATS_T', partname=>'P21072013_22072013_S2011', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
5fbmafvm27kfm	insert into obj$(owner#, name, namespace, obj#, type#, ctime, mtime, stime, status, remoteowner, linkname, subname, dataobj#, flags, oid$, spare1, spare2)values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)
64wq3fa5a77sm	insert into seg$ (file#, block#, type#, ts#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, lists, groups, cachehint, bitmapranges, hwmincr, spare1, scanhint) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, 0, :16, DECODE(:17, 0, NULL, :17), :18)
6cr55dpp3n44a	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname = :4
84pt912vu3pw9	create global temporary table sys.ora_temp_1_ds_663925 on commit preserve rows cache noparallel as select /+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring /"UDTS_POOL_TMP_DT_LR_STATS_SUM", "UDTS_POOL_TMP_DT_PR_STATS_SUM", "UDTS_BP_TMP_IDX_LR_STATS_SUM", "UDTS_BP_TMP_IDX_PR_STATS_SUM", "UDTS_AUT_PREFETCHSIZE_ENBL_MAX", "UDTS_USING_AUTO_STORAGE_MAX", "UDTS_FILE_SYSTEM_CACHING_MAX", "UDTS_TOTAL_NUM_OF_PAGES_MAX", "UDTS_NUM_OF_USABLE_PAGES_MAX", "UDTS_NUM_OF_USED_PAGES_MAX", "UDTS_MIN_RECOVERY_TIME_MAX", "UDTS_NUM_OF_QUIESCERS_MAX", "UDTS_NUM_OF_CONTAINERS_MAX", "UDTS_BP_NO_VICT_BUFF_STATS_SUM", "UDTS_PWII_INSTANCE_ID", "UDTS_TIMESTAMP", "UDTS_PWHG_ID", "UDTS_CLUSTER_ID", "UDTS_MINUTES_COUNT_SUM", "UDTS_BUFFER_POOL_ID", "UDTS_BUFFER_POOL_CAT_ID_MAX", "UDTS_TABLE_SPACE_ID", "UDTS_EXTENTSIZE_MAX", "UDTS_PREFETCHSIZE_MAX", "UDTS_PAGESIZE_MAX", "UDTS_BP_DT_LOG_RD_STATS_SUM", "UDTS_BP_DT_PHYS_RD_STATS_SUM", "UDTS_BP_ASYNC_DT_RD_STATS_SUM", "UDTS_BP_DT_WR_STATS_SUM", "UDTS_BP_ASYNC_DT_WR_STATS_SUM", "UDTS_BP_IDX_LOG_RD_STATS_SUM", "UDTS_BP_IDX_PHYS_RD_STATS_SUM", "UDTS_BP_ASYNC_IDX_RD_STATS_ SUM", "UDTS_BP_IDX_WR_STATS_SUM", "UDTS_BP_ASYNC_IDX_WR_STATS_SUM", "UDTS_BP_RD_TIME_SUM", "UDTS_BP_WR_TIME_SUM", "UDTS_BP_ASYNC_RD_TIME_SUM", "UDTS_BP_ASYNC_WR_TIME_SUM", "UDTS_BP_ASY_DT_RD_RQ_STATS_SUM", "UDTS_BP_ASY_IX_RD_RQ_STATS_SUM", "UDTS_DIRECT_RD_STATS_SUM", "UDTS_DIRECT_WR_STATS_SUM", "UDTS_DIRECT_RD_REQS_STATS_SUM", "UDTS_DIRECT_WR_REQS_STATS_SUM", "UDTS_DIRECT_RD_TIME_SUM", "UDTS_DIRECT_WR_TIME_SUM", "UDTS_FILES_CLOSED_STATS_SUM", rowid SYS_DS_ALIAS_0 from "PRECISE_PMDB"."PW_UDTS_TABLESPACES_STATS_T" sample ( 16.4073313923) t where 1 = 2
8adbmwsnxtvu5	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S1371', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
8q32jht0j6m3z	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S1374', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
8x5n0dyzwwp5q	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDAS_APPLICATION_STATS_T', partname=>'P21072013_22072013', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'PARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
9babjv8yq8ru3	BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
9ccf9ygspmv2v	INSERT INTO PW_PWJH_JOB_HISTORY (PWJH_ID, PWJH_PWJG_ID, PWJH_PWII_ID, PWJH_BEGIN_TIMESTAMP, PWJH_PROCESSED_OBJECT, PWJH_DATA_START_TIMESTAMP, PWJH_DATA_END_TIMESTAMP, PWJH_END_TIMESTAMP, PWJH_STATUS, PWJH_ROWS_PROCESSED, PWJH_SUB_PROCESS, PWJH_PWSE_ID) VALUES (:1 , :2 , :3 , :4 , :5 , NULL, NULL, NULL, :6 , 0, :7 , :8 )
9qgtwh66xg6nz	update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
9z4950jfutn4z	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDAS_APPLICATION_STATS_T', partname=>'P21072013_22072013_S1441', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
af9ay6atjs58c	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S1329', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
aq4js2gkfjru8	update tsq$ set blocks=:3, maxblocks=:4, grantor#=:5, priv1=:6, priv2=:7, priv3=:8 where ts#=:1 and user#=:2
bsa0wjtftg3uw	select file# from file$ where ts#=:1
bunvx480ynf57	SELECT 1 FROM DUAL
bz5p1ybmhvb6t	create global temporary table sys.ora_temp_1_ds_663924 on commit preserve rows cache noparallel as select /+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring /"UDTS_POOL_TMP_DT_LR_STATS_SUM", "UDTS_POOL_TMP_DT_PR_STATS_SUM", "UDTS_BP_TMP_IDX_LR_STATS_SUM", "UDTS_BP_TMP_IDX_PR_STATS_SUM", "UDTS_AUT_PREFETCHSIZE_ENBL_MAX", "UDTS_USING_AUTO_STORAGE_MAX", "UDTS_FILE_SYSTEM_CACHING_MAX", "UDTS_TOTAL_NUM_OF_PAGES_MAX", "UDTS_NUM_OF_USABLE_PAGES_MAX", "UDTS_NUM_OF_USED_PAGES_MAX", "UDTS_MIN_RECOVERY_TIME_MAX", "UDTS_NUM_OF_QUIESCERS_MAX", "UDTS_NUM_OF_CONTAINERS_MAX", "UDTS_BP_NO_VICT_BUFF_STATS_SUM", "UDTS_PWII_INSTANCE_ID", "UDTS_TIMESTAMP", "UDTS_PWHG_ID", "UDTS_CLUSTER_ID", "UDTS_MINUTES_COUNT_SUM", "UDTS_BUFFER_POOL_ID", "UDTS_BUFFER_POOL_CAT_ID_MAX", "UDTS_TABLE_SPACE_ID", "UDTS_EXTENTSIZE_MAX", "UDTS_PREFETCHSIZE_MAX", "UDTS_PAGESIZE_MAX", "UDTS_BP_DT_LOG_RD_STATS_SUM", "UDTS_BP_DT_PHYS_RD_STATS_SUM", "UDTS_BP_ASYNC_DT_RD_STATS_SUM", "UDTS_BP_DT_WR_STATS_SUM", "UDTS_BP_ASYNC_DT_WR_STATS_SUM", "UDTS_BP_IDX_LOG_RD_STATS_SUM", "UDTS_BP_IDX_PHYS_RD_STATS_SUM", "UDTS_BP_ASYNC_IDX_RD_STATS_ SUM", "UDTS_BP_IDX_WR_STATS_SUM", "UDTS_BP_ASYNC_IDX_WR_STATS_SUM", "UDTS_BP_RD_TIME_SUM", "UDTS_BP_WR_TIME_SUM", "UDTS_BP_ASYNC_RD_TIME_SUM", "UDTS_BP_ASYNC_WR_TIME_SUM", "UDTS_BP_ASY_DT_RD_RQ_STATS_SUM", "UDTS_BP_ASY_IX_RD_RQ_STATS_SUM", "UDTS_DIRECT_RD_STATS_SUM", "UDTS_DIRECT_WR_STATS_SUM", "UDTS_DIRECT_RD_REQS_STATS_SUM", "UDTS_DIRECT_WR_REQS_STATS_SUM", "UDTS_DIRECT_RD_TIME_SUM", "UDTS_DIRECT_WR_TIME_SUM", "UDTS_FILES_CLOSED_STATS_SUM", rowid SYS_DS_ALIAS_0 from "PRECISE_PMDB"."PW_UDTS_TABLESPACES_STATS_T" sample ( 3.6246688371) t where 1 = 2
cvhk2j2gymzhd	SELECT SU.NAME, SO.NAME, A.STATSTYPE#, C.INTCOL# FROM ASSOCIATION$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU, COLTYPE$ CT, OBJ$ TY WHERE O.OWNER#=U.USER# AND A.OBJ#=TY.OBJ# AND O.OBJ#=C.OBJ# AND C.INTCOL#=CT.INTCOL# AND O.OBJ#=CT.OBJ# AND CT.TOID=TY.OID$ AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.TYPE#=2 AND O.NAME=:B3 AND U.NAME=:B2 AND C.NAME=:B1
d5gr0tpsjj13a	INSERT INTO PW_UDEO_EXPLAIN_OPER ( UDEO_CLUSTER_ID, UDEO_STATEMENT_HV, UDEO_EXPLAIN_TIME, UDEO_OPERATOR_ID, UDEO_OPERATOR_TYPE, UDEO_OPTIONS, UDEO_PRE_FETCH, UDEO_EXECUTION_ORDER, UDEO_TREE_LEVEL, UDEO_ARGUMENTS_LIST, UDEO_REMOTE_QUERY_HV, UDEO_OBJECT_SCHEMA_NAME, UDEO_OBJECT_NAME, UDEO_OBJECT_TYPE, UDEO_BASE_SCHEMA_NAME, UDEO_BASE_TABLE_NAME, UDEO_TOTAL_ESTIMATED_COST, UDEO_FIRST_ROW_COST, UDEO_ESTIMATED_IO_COST, UDEO_ESTIMATED_CPU_COST, UDEO_ESTIMATED_COMM_COST, UDEO_CONTRIBUTION_RATIO, UDEO_PARENT_OP_ID, UDEO_FILTER_FACTOR, UDEO_MAX_ROWS, UDEO_MAX_PAGES, UDEO_PART_NUM, UDEO_LAST_EXPLAIN_IND, UDEO_MAX_EXECUTION_ORDER, UDEO_HAS_CHILD, UDEO_SONS_LIST, UDEO_TOTAL_COST_PERCENT) 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 )
d89c1mh5pvbkz	SELECT /+ rule / U.NAME, OT.NAME, NULL, NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.COL$ C, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE :B4 IS NULL AND U.NAME = :B3 AND OT.OWNER# = U.USER# AND OT.NAME = :B2 AND OT.TYPE# = 2 AND C.OBJ# = OT.OBJ# AND (:B1 IS NULL OR C.NAME = :B1 ) AND H.OBJ# = OT.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OT.NAME, OP.SUBNAME, NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.COL$ C, SYS.TABPART$ TP, SYS.OBJ$ OP, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OT.OWNER# = U.USER# AND OT.NAME = :B2 AND OT.TYPE# = 2 AND C.OBJ# = OT.OBJ# AND (:B1 IS NULL OR C.NAME = :B1 ) AND TP.BO# = OT.OBJ# AND TP.OBJ# = OP.OBJ# AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR OP.SUBNAME = :B4 ) AND H.OBJ# = OP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OP.NAME, OP.SUBNAME , NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.COL$ C, SYS.TABCOMPART$ TP, SYS.OBJ$ OP, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OP.OWNER# = U.USER# AND OP.NAME = :B2 AND OP.TYPE# = 19 AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR OP.SUBNAME = :B4 ) AND TP.OBJ# = OP.OBJ# AND C.OBJ# = TP.BO# AND (:B1 IS NULL OR C.NAME = :B1 ) AND H.OBJ# = OP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OP.NAME, OP.SUBNAME, OS.SUBNAME, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.COL$ C, SYS.TABCOMPART$ TP, SYS.OBJ$ OP, SYS.TABSUBPART$ TS, SYS.OBJ$ OS, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OP.OWNER# = U.USER# AND OP.NAME = :B2 AND OP.TYPE# = 19 AND TP.OBJ# = OP.OBJ# AND C.OBJ# = TP.BO# AND (:B1 IS NULL OR C.NAME = :B1 ) AND TS.POBJ# = TP.OBJ# AND TS.OBJ# = OS.OBJ# AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR (OP.SUBNAME = :B4 AND (:B5 IS NOT NULL OR OS.SUBNAME IS NULL)) OR OS.SUBNAME = :B4 ) AND H.OBJ# = OS.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# ORDER BY 1, 2, 3, 4, 5, 22
djupx9h0ggd9t	SELECT /+ rule / OI.NAME FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.COL$ C, SYS.ICOL$ IC, SYS.OBJ$ OI WHERE U.NAME = :B3 AND OT.OWNER# = U.USER# AND OT.NAME = :B2 AND OT.TYPE# = 2 AND OT.OBJ# = C.OBJ# AND C.NAME = :B1 AND OT.OBJ# = IC.BO# AND IC.INTCOL# = C.INTCOL# AND IC.OBJ# = OI.OBJ#
du25gntfqdm1u	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDAS_APPLICATION_STATS_T', partname=>'P21072013_22072013_S2036', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
dwfnyy9pnxwrn	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'PARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
f54d62ubt511v	declare error boolean; st_syn_detected EXCEPTION; PRAGMA EXCEPTION_INIT(st_syn_detected, -995); BEGIN if((sys.dbms_standard.dictionary_obj_type != 'SYNONYM')or(sys.dbms_standard.dictionary_obj_owner != 'PUBLIC')) then return; end if; error := CASE sys.dbms_standard.dictionary_obj_name WHEN 'ST_GEOMETRY' THEN TRUE WHEN 'ST_SURFACE' THEN TRUE WHEN 'ST_POLYGON' THEN TRUE WHEN 'ST_POINT' THEN TRUE WHEN 'ST_MULTISURFACE' THEN TRUE WHEN 'ST_MULTIPOINT' THEN TRUE WHEN 'ST_MULTILINESTRING' THEN TRUE WHEN 'ST_MULTICURVE' THEN TRUE WHEN 'ST_LINESTRING' THEN TRUE WHEN 'ST_GEOMCOLLECTION' THEN TRUE WHEN 'ST_CURVE' THEN TRUE WHEN 'ST_CURVEPOLYGON' THEN TRUE WHEN 'ST_COMPOUNDCURVE' THEN TRUE WHEN 'ST_CIRCULARSTRING' THEN TRUE WHEN 'ST_INTERSECTS' THEN TRUE WHEN 'ST_RELATE' THEN TRUE WHEN 'ST_TOUCH' THEN TRUE WHEN 'ST_CONTAINS' THEN TRUE WHEN 'ST_COVERS' THEN TRUE WHEN 'ST_COVEREDBY' THEN TRUE WHEN 'ST_INSIDE' THEN TRUE WHEN 'ST_OVERLAP' THEN TRUE WHEN 'ST_OVERLAPS' THEN TRUE WHEN 'ST_EQUAL' THEN TRUE WHEN 'ST_OVERLAPBDYDISJOINT' THEN TRUE WHEN 'ST_OVERLAPBDYINTERSECT' THEN TRUE WHEN 'ST_GEOMETRY_ARRAY' THEN TRUE WHEN 'ST_POINT_ARRAY' THEN TRUE WHEN 'ST_CURVE_ARRAY' THEN TRUE WHEN 'ST_SURFACE_A RRAY' THEN TRUE WHEN 'ST_LINESTRING_ARRAY' THEN TRUE WHEN 'ST_POLYGON_ARRAY' THEN TRUE ELSE FALSE END; if(error) then raise st_syn_detected; end if; END;
fh5pj4unjhjbb	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S1377', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
fyfy49x4t6aph	BEGIN dbms_stats.gather_table_stats(ownname=>'PRECISE_PMDB', tabname=>'PW_UDTS_TABLESPACES_STATS_T', partname=>'P21072013_22072013_S1107', method_opt=>'FOR ALL INDEXED COLUMNS SIZE 1', granularity=>'SUBPARTITION', cascade=>TRUE, estimate_percent=>dbms_stats.auto_sample_size ); END;
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
g4nyrfxtg1pg1	INSERT INTO PW_UDSX_STATEMENT_TEXT(UDSX_STATEMENT_HV, UDSX_CONSISTENT_HV, UDSX_STATEMENT_TEXT, UDSX_UNFORMATTED_TEXT) VALUES (:1 , :2 , :3 , :4 )

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	731,765	101.88	44.84
CPU used when call started	730,352	101.68	44.76
CR blocks created	5,127	0.71	0.31
Cached Commit SCN referenced	1,058	0.15	0.06
Commit SCN cached	6	0.00	0.00
DB time	765,020	106.51	46.88
DBWR checkpoint buffers written	61,639	8.58	3.78
DBWR checkpoints	70	0.01	0.00
DBWR object drop buffers written	128	0.02	0.01
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	237	0.03	0.01
DBWR undo block writes	13,805	1.92	0.85
IMU CR rollbacks	407	0.06	0.02
IMU Flushes	2,972	0.41	0.18
IMU Redo allocation size	3,089,248	430.10	189.32
IMU commits	9,291	1.29	0.57
IMU contention	317	0.04	0.02
IMU ktichg flush	2,224	0.31	0.14
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	13	0.00	0.00
IMU undo allocation size	35,057,200	4,880.82	2,148.38
IMU- failed to get a private strand	0	0.00	0.00
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
RowCR - row contention	0	0.00	0.00
RowCR attempts	111	0.02	0.01
RowCR hits	109	0.02	0.01
SMON posted for undo segment shrink	5	0.00	0.00
SQL*Net roundtrips to/from client	82,974	11.55	5.08
active txn count during cleanout	5,209	0.73	0.32
application wait time	186	0.03	0.01
background checkpoints completed	1	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	23,118	3.22	1.42
branch node splits	0	0.00	0.00
buffer is not pinned count	3,092,322,016	430,527.04	189,503.74
buffer is pinned count	3,706,813,884	516,079.37	227,161.04
bytes received via SQL*Net from client	51,719,864	7,200.67	3,169.50
bytes sent via SQL*Net to client	15,088,232	2,100.65	924.64
calls to get snapshot scn: kcmgss	4,426,945	616.34	271.29
calls to kcmgas	51,413	7.16	3.15
calls to kcmgcs	5,706	0.79	0.35
change write time	1,465	0.20	0.09
cleanout - number of ktugct calls	7,502	1.04	0.46
cleanouts and rollbacks - consistent read gets	915	0.13	0.06
cleanouts only - consistent read gets	787	0.11	0.05
cluster key scan block gets	1,327,834	184.87	81.37
cluster key scans	554,682	77.23	33.99
commit batch/immediate performed	18	0.00	0.00
commit batch/immediate requested	18	0.00	0.00
commit cleanout failures: block lost	2,627	0.37	0.16
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	148	0.02	0.01
commit cleanout failures: cannot pin	505	0.07	0.03
commit cleanouts	95,871	13.35	5.88
commit cleanouts successfully completed	92,591	12.89	5.67
commit immediate performed	18	0.00	0.00
commit immediate requested	18	0.00	0.00
commit txn count during cleanout	6,036	0.84	0.37
concurrency wait time	316	0.04	0.02
consistent changes	27,267	3.80	1.67
consistent gets	3,178,851,983	442,574.13	194,806.47
consistent gets - examination	76,410,820	10,638.26	4,682.61
consistent gets direct	115	0.02	0.01
consistent gets from cache	3,178,851,864	442,574.11	194,806.46
current blocks converted for CR	0	0.00	0.00
cursor authentications	168	0.02	0.01
data blocks consistent reads - undo records applied	9,307	1.30	0.57
db block changes	1,728,457	240.64	105.92
db block gets	1,962,295	273.20	120.25
db block gets direct	531	0.07	0.03
db block gets from cache	1,961,764	273.13	120.22
deferred (CURRENT) block cleanout applications	44,071	6.14	2.70
dirty buffers inspected	239	0.03	0.01
enqueue conversions	1,797	0.25	0.11
enqueue deadlocks	0	0.00	0.00
enqueue releases	152,331	21.21	9.34
enqueue requests	152,326	21.21	9.33
enqueue timeouts	0	0.00	0.00
enqueue waits	157	0.02	0.01
exchange deadlocks	28	0.00	0.00
execute count	195,763	27.26	12.00
failed probes on index block reclamation	1	0.00	0.00
free buffer inspected	106,281	14.80	6.51
free buffer requested	91,988	12.81	5.64
heap block compress	812	0.11	0.05
hot buffers moved to head of LRU	69,024	9.61	4.23
immediate (CR) block cleanout applications	1,702	0.24	0.10
immediate (CURRENT) block cleanout applications	12,654	1.76	0.78
index crx upgrade (found)	5	0.00	0.00
index crx upgrade (positioned)	14,143	1.97	0.87
index fast full scans (full)	54	0.01	0.00
index fetch by key	25,340,677	3,528.04	1,552.93
index scans kdiixs1	547,361	76.21	33.54
leaf node 90-10 splits	220	0.03	0.01
leaf node splits	561	0.08	0.03
lob reads	1,410	0.20	0.09
lob writes	748	0.10	0.05
lob writes unaligned	672	0.09	0.04
logons cumulative	81	0.01	0.00
messages received	41,339	5.76	2.53
messages sent	41,338	5.76	2.53
no buffer to keep pinned count	25,373,529	3,532.62	1,554.94
no work - consistent read gets	3,098,187,467	431,343.65	189,863.19
opened cursors cumulative	118,346	16.48	7.25
parse count (failures)	3	0.00	0.00
parse count (hard)	3,650	0.51	0.22
parse count (total)	114,021	15.87	6.99
parse time cpu	3,247	0.45	0.20
parse time elapsed	3,946	0.55	0.24
physical read IO requests	29,197	4.06	1.79
physical read bytes	476,708,864	66,369.56	29,213.68
physical read total IO requests	54,887	7.64	3.36
physical read total bytes	1,393,132,032	193,958.13	85,373.94
physical read total multi block requests	3,667	0.51	0.22
physical reads	58,192	8.10	3.57
physical reads cache	58,093	8.09	3.56
physical reads cache prefetch	28,991	4.04	1.78
physical reads direct	99	0.01	0.01
physical reads direct (lob)	66	0.01	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	27,216	3.79	1.67
physical write bytes	514,506,752	71,631.95	31,530.01
physical write total IO requests	50,549	7.04	3.10
physical write total bytes	1,412,409,344	196,642.01	86,555.30
physical write total multi block requests	22,004	3.06	1.35
physical writes	62,806	8.74	3.85
physical writes direct	531	0.07	0.03
physical writes direct (lob)	88	0.01	0.01
physical writes direct temporary tablespace	420	0.06	0.03
physical writes from cache	62,275	8.67	3.82
physical writes non checkpoint	33,709	4.69	2.07
pinned buffers inspected	41	0.01	0.00
pinned cursors current	7	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	6,521	0.91	0.40
recursive calls	842,136	117.25	51.61
recursive cpu usage	720,676	100.34	44.16
redo blocks written	502,426	69.95	30.79
redo buffer allocation retries	11	0.00	0.00
redo entries	866,596	120.65	53.11
redo log space requests	2	0.00	0.00
redo log space wait time	17	0.00	0.00
redo ordering marks	18,320	2.55	1.12
redo size	245,319,000	34,154.42	15,033.64
redo subscn max counts	30,017	4.18	1.84
redo synch time	9,206	1.28	0.56
redo synch writes	12,875	1.79	0.79
redo wastage	3,703,404	515.60	226.95
redo write time	6,217	0.87	0.38
redo writer latching time	2	0.00	0.00
redo writes	13,997	1.95	0.86
rollback changes - undo records applied	51	0.01	0.00
rollbacks only - consistent read gets	3,163	0.44	0.19
root node splits	0	0.00	0.00
rows fetched via callback	13,500,198	1,879.56	827.32
session connect time	0	0.00	0.00
session cursor cache hits	85,277	11.87	5.23
session logical reads	3,180,814,283	442,847.33	194,926.72
shared hash latch upgrades - no wait	19,742	2.75	1.21
shared hash latch upgrades - wait	7	0.00	0.00
sorts (memory)	28,048	3.90	1.72
sorts (rows)	9,112,754	1,268.72	558.45
sql area evicted	1,057	0.15	0.06
sql area purged	2,289	0.32	0.14
summed dirty queue length	636	0.09	0.04
switch current to new buffer	2,216	0.31	0.14
table fetch by rowid	2,377,722,519	331,037.27	145,711.64
table fetch continued row	975,951	135.88	59.81
table scan blocks gotten	1,457,744	202.95	89.33
table scan rows gotten	86,684,271	12,068.58	5,312.19
table scans (cache partitions)	0	0.00	0.00
table scans (long tables)	521	0.07	0.03
table scans (short tables)	1,452,786	202.26	89.03
total number of times SMON posted	5	0.00	0.00
transaction rollbacks	18	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	103,108,704	14,355.26	6,318.71
user I/O wait time	613	0.09	0.04
user calls	150,396	20.94	9.22
user commits	12,676	1.76	0.78
user rollbacks	3,642	0.51	0.22
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	23,261	3.24	1.43
write clones created in background	128	0.02	0.01
write clones created in foreground	1	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session pga memory max	1,293,909,432	1,210,562,008
session cursor cache count	90,899	92,122
session uga memory	1.4E+12	1.4E+12
opened cursors current	164	118
workarea memory allocated	382	382
logons current	47	47
session uga memory max	25,619,879,096	25,826,572,976
session pga memory	443,235,096	443,708,216

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)	1	0.50

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)
SYSAUX	16,547	2	0.16	2.18	5,574	1	0	0.00
PRECISE_PMDB_IND_SMALL	3,808	1	0.14	1.00	12,929	2	169	0.12
PRECISE_PMDB_TAB_SMALL	3,616	1	0.06	2.80	5,416	1	21	0.00
SYSTEM	4,882	1	0.05	1.51	1,513	0	132	0.00
UNDOTBS1	0	0	0.00	0.00	1,457	0	79	0.00
PATROL_DATA	256	0	0.00	1.00	236	0	0	0.00
PRECISE_PMDB_TAB_LARGE	68	0	0.00	1.00	67	0	0	0.00
PRECISE_PMDB_TMP	28	0	0.36	15.00	16	0	0	0.00
PRECISE_PMDB_IND_MEDIUM	6	0	0.00	1.00	3	0	0	0.00
PRECISE_PMDB_IND_LARGE	3	0	0.00	1.00	3	0	0	0.00
PRECISE_PMDB_TAB_MEDIUM	0	0	0.00	0.00	2	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)
PATROL_DATA	/oradata/PRECISEDB/patrol_data.dbf	256	0	0.00	1.00	236	0	0	0.00
PRECISE_PMDB_IND_LARGE	/oradata/PRECISEDB/PRECISE_PMDB_IND_LARGE.dbf	3	0	0.00	1.00	3	0	0	0.00
PRECISE_PMDB_IND_MEDIUM	/oradata/PRECISEDB/PRECISE_PMDB_IND_MEDIUM.dbf	6	0	0.00	1.00	3	0	0	0.00
PRECISE_PMDB_IND_SMALL	/oradata/PRECISEDB/PRECISE_PMDB_IND_SMALL.dbf	3,808	1	0.14	1.00	12,929	2	169	0.12
PRECISE_PMDB_TAB_LARGE	/oradata/PRECISEDB/PRECISE_PMDB_TAB_LARGE.dbf	68	0	0.00	1.00	67	0	0	0.00
PRECISE_PMDB_TAB_MEDIUM	/oradata/PRECISEDB/PRECISE_PMDB_TAB_MEDIUM.dbf	0	0			2	0	0	0.00
PRECISE_PMDB_TAB_SMALL	/oradata/PRECISEDB/PRECISE_PMDB_TAB_SMALL.dbf	3,616	1	0.06	2.80	5,416	1	21	0.00
PRECISE_PMDB_TMP	/oradata/PRECISEDB/PRECISE_PMDB_TMP.dbf	28	0	0.36	15.00	16	0	0
SYSAUX	/oradata/PRECISEDB/o1_mf_sysaux_7fxm0zks_.dbf	16,547	2	0.16	2.18	5,574	1	0	0.00
SYSTEM	/oradata/PRECISEDB/o1_mf_system_7fxm0zko_.dbf	4,882	1	0.05	1.51	1,513	0	132	0.00
UNDOTBS1	/oradata/PRECISEDB/o1_mf_undotbs1_7fxm0zm7_.dbf	0	0			1,457	0	79	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	156,340	100	-5,409,139,017	58,091	62,275	0	0	401

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	9	784	3667	30813	3774870	30813
E	0	8	251	1102	36698	3774870	36698

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	112	0.09	13,853	1.35	24,944,271
D	224	0.18	27,706	1.14	21,010,501
D	336	0.27	41,559	1.07	19,659,868
D	448	0.35	55,412	1.06	19,438,744
D	560	0.44	69,265	1.05	19,304,633
D	672	0.53	83,118	1.04	19,204,908
D	784	0.62	96,971	1.04	19,119,852
D	896	0.71	110,824	1.03	19,047,402
D	1,008	0.80	124,677	1.03	18,959,930
D	1,120	0.89	138,530	1.02	18,829,994
D	1,232	0.97	152,383	1.01	18,525,387
D	1,264	1.00	156,341	1.00	18,419,206
D	1,344	1.06	166,236	0.98	18,016,897
D	1,456	1.15	180,089	0.94	17,357,018
D	1,568	1.24	193,942	0.90	16,581,860
D	1,680	1.33	207,795	0.85	15,673,935
D	1,792	1.42	221,648	0.80	14,727,204
D	1,904	1.51	235,501	0.75	13,778,932
D	2,016	1.59	249,354	0.70	12,830,124
D	2,128	1.68	263,207	0.64	11,878,649
D	2,240	1.77	277,060	0.59	10,853,577

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	1,626	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	512	411	92.84	0.37	0.40	100.00	0.00	102,400
E	512	413	89.83	0.37	0.42	100.00	0.00	102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	21,460	21,460
64K	128K	160	160
128K	256K	202	202
256K	512K	67	67
512K	1024K	1,215	1,215
1M	2M	105	105
2M	4M	4	4
8M	16M	26	26
16M	32M	8	8

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
64	0.13	159,991.57	46,994.43	77.00	1,168
128	0.25	159,991.57	22,291.39	88.00	0
256	0.50	159,991.57	5,920.85	96.00	0
384	0.75	159,991.57	5,861.90	96.00	0
512	1.00	159,991.57	5,762.94	97.00	0
614	1.20	159,991.57	5,291.10	97.00	0
717	1.40	159,991.57	5,291.10	97.00	0
819	1.60	159,991.57	5,291.10	97.00	0
922	1.80	159,991.57	5,291.10	97.00	0
1,024	2.00	159,991.57	5,291.10	97.00	0
1,536	3.00	159,991.57	5,291.10	97.00	0
2,048	4.00	159,991.57	5,291.10	97.00	0
3,072	6.00	159,991.57	5,291.10	97.00	0
4,096	8.00	159,991.57	5,291.10	97.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 (K)
1,520	0.40	431	35,544	107,420	1.00	1,420	1.07	10,443
1,904	0.50	792	56,480	107,478	1.00	1,362	1.03	10,450
2,288	0.60	1,181	68,608	107,503	1.00	1,337	1.01	10,453
2,672	0.70	1,574	70,133	107,511	1.00	1,329	1.00	10,454
3,056	0.80	1,961	71,431	107,513	1.00	1,327	1.00	10,454
3,440	0.90	2,340	73,200	107,514	1.00	1,326	1.00	10,454
3,824	1.00	2,740	74,392	107,515	1.00	1,325	1.00	10,455
4,208	1.10	3,108	75,612	107,516	1.00	1,324	1.00	10,455
4,592	1.20	3,388	76,228	107,517	1.00	1,323	1.00	10,455
4,976	1.30	3,632	78,660	107,517	1.00	1,323	1.00	10,456
5,360	1.40	3,666	78,992	107,517	1.00	1,323	1.00	10,456
5,744	1.50	3,666	78,992	107,517	1.00	1,323	1.00	10,456
6,128	1.60	3,666	78,992	107,517	1.00	1,323	1.00	10,456
6,512	1.70	3,666	78,992	107,517	1.00	1,323	1.00	10,456
6,896	1.80	3,666	78,992	107,517	1.00	1,323	1.00	10,456
7,280	1.90	3,666	78,992	107,517	1.00	1,323	1.00	10,456
7,664	2.00	3,666	78,992	107,517	1.00	1,323	1.00	10,456

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
2,568	0.50	309,772	29,398,860
3,852	0.75	306,827	16,829,608
5,136	1.00	306,735	18,419,184
6,420	1.25	306,735	16,829,608
7,704	1.50	306,735	16,829,608
8,988	1.75	306,735	16,829,608
10,272	2.00	306,735	16,829,608

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

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	317	0	0
undo block	44	0	0
undo header	35	0	0
file header block	5	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)	621	621	69	4.49
TX-Transaction (row lock contention)	61	61	61	0.16
TX-Transaction (allocate ITL entry)	11	11	10	1.00
TX-Transaction (index contention)	20	20	17	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	14.01	26,229	1,648	11	15.3/41.5	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
22-Jul 09:03	456	2,442	1,135	6	33	0/0	0/0/0/0/0/0
22-Jul 08:53	385	1,867	535	6	23	0/0	0/0/0/0/0/0
22-Jul 08:43	51	655	81	3	15	0/0	0/0/0/0/0/0
22-Jul 08:33	314	1,872	1,589	7	41	0/0	0/0/0/0/0/0
22-Jul 08:23	654	7,256	989	11	30	0/0	0/0/0/0/0/0
22-Jul 08:13	43	725	387	3	20	0/0	0/0/0/0/0/0
22-Jul 08:03	431	1,846	1,648	5	41	0/0	0/0/0/0/0/0
22-Jul 07:53	357	2,171	1,048	5	31	0/0	0/0/0/0/0/0
22-Jul 07:43	35	187	447	3	21	0/0	0/0/0/0/0/0
22-Jul 07:33	392	2,231	75	5	15	0/0	0/0/0/0/0/0
22-Jul 07:23	336	1,750	1,310	5	36	0/0	0/0/0/0/0/0
22-Jul 07:13	10,174	1,432	711	4	26	0/0	0/0/0/0/0/0
22-Jul 07:03	379	1,795	109	5	16	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
ASM db client latch	4,995	0.00		0
AWR Alerted Metric Element list	29,141	0.00		0
Consistent RBA	14,011	0.00		0
FAL request queue	146	0.00		0
FAL subheap alocation	146	0.00		0
FIB s.o chain latch	6	0.00		0
FOB s.o list latch	572	0.00		0
In memory undo latch	80,759	0.51	0.86	13,920	0.00
JS mem alloc latch	10	0.00		0
JS queue access latch	10	0.00		0
JS queue state obj latch	51,908	0.00		0
JS slv state obj latch	8	0.00		0
KMG MMAN ready and startup request latch	2,394	0.00		0
KTF sga latch	14	0.00		2,154	0.00
KWQMN job cache list latch	2	0.00		0
MQL Tracking Latch	0			143	0.00
Memory Management Latch	0			2,394	0.00
OS process	357	0.00		0
OS process allocation	2,632	0.00		0
OS process: request allocation	154	0.00		0
PL/SQL warning settings	4,749	0.00		0
SQL memory manager latch	2	0.00		2,384	0.00
SQL memory manager workarea list latch	176,336	0.00	0.00	0
Shared B-Tree	255	0.00		0
active checkpoint queue latch	30,238	0.00		0
active service list	14,929	0.00		4,086	0.00
alert log latch	2	0.00		0
archive control	266	0.00		0
archive process latch	2,678	0.00		0
begin backup scn array	86	0.00		0
cache buffer handles	3,916	0.00		0
cache buffers chains	6,289,551,884	0.00	0.01	150,710	0.03
cache buffers lru chain	150,733	0.00	0.00	1,132,645	0.06
cache table scan latch	0			3,184	0.00
channel handle pool latch	156	0.00		0
channel operations parent latch	35,115	0.00		0
checkpoint queue latch	1,097,617	0.00	0.00	61,601	0.01
client/application info	569	0.00		0
commit callback allocation	5,317	0.04	0.00	0
compile environment latch	81	0.00		0
dictionary lookup	1,646	0.00		0
direct msg latch	41,617	0.00		0
dml lock allocation	96,037	0.19	0.01	0
done queue latch	41,011	0.00		41,026	0.00
dummy allocation	162	0.00		0
enqueue hash chains	308,572	0.02	0.02	0
enqueues	187,241	0.08	0.01	0
event group latch	77	0.00		0
file cache latch	2,047	0.00		0
global KZLD latch for mem in SGA	56	0.00		0
hash table column usage latch	675	0.00		47,645	0.00
hash table modification latch	1,025	0.00		0
job workq parent latch	0			8	0.00
job_queue_processes parameter latch	124	0.00		0
kks stats	9,034	0.02	0.00	0
kmcptab latch	1	0.00		0
kmcpvec latch	0			1	0.00
kokc descriptor allocation latch	16	0.00		0
ksfv messages	82,628	0.00		0
ksuosstats global area	483	0.00		0
ktm global data	36	0.00		0
kwqbsn:qsga	255	0.00		0
lgwr LWN SCN	15,484	0.04	0.00	0
library cache	451,805	0.39	0.07	9,464	65.89
library cache load lock	5,506	0.00		0
library cache lock	738,943	0.04	0.00	39	0.00
library cache lock allocation	2,525	0.00		0
library cache pin	143,290	0.16	0.00	0
library cache pin allocation	780	0.00		0
list of block allocation	788	0.00		0
loader state object freelist	2,038	0.00		0
longop free list parent	1,295	0.00		401	0.00
message pool operations parent latch	207	0.00		0
messages	139,399	0.04	0.00	0
mostly latch-free SCN	15,638	0.68	0.00	0
msg queue latch	0			82,779	0.98
multiblock read objects	9,174	0.00		0
ncodef allocation latch	114	0.00		0
object queue header heap	252,700	0.00		13,325	0.01
object queue header operation	757,094	0.01	0.02	0
object stats modification	1,329	0.00		0
parallel query alloc buffer	956	0.00		0
parameter list	24	0.00		0
parameter table management	166	0.00		0
post/wait queue	16,960	0.01	0.00	12,680	0.06
process allocation	154	0.00		77	0.00
process group creation	154	0.00		0
qmn task queue latch	1,020	0.00		0
redo allocation	74,402	0.12	0.01	866,536	0.07
redo copy	0			866,744	0.05
redo writing	77,403	0.01	0.00	0
resmgr group change latch	104	0.00		0
resmgr:active threads	130	0.00		0
resmgr:actses change group	60	0.00		0
resmgr:free threads list	128	0.00		0
resmgr:resource group CPU method	60	0.00		0
resmgr:schema config	2	0.00		0
row cache objects	840,371	0.24	0.00	655	0.00
sequence cache	518	0.00		0
session allocation	56,964	0.41	0.00	0
session idle bit	326,770	0.02	0.03	0
session queue latch	41,617	0.00		0
session state list latch	135	0.00		0
session switching	499	0.00		0
session timer	2,404	0.00		0
shared pool	2,457,473	2.96	0.00	0
shared pool sim alloc	33	0.00		0
shared pool simulator	13,252	0.12	0.00	0
simulator hash latch	203,545,462	0.00	0.01	0
simulator lru latch	62,290	0.17	0.04	203,381,567	0.01
slave class	17	0.00		0
slave class create	68	4.41	1.00	0
sort extent pool	13,628	0.29	0.00	0
state object free list	4	0.00		0
statistics aggregation	1,120	0.00		0
temporary table state object allocation	13	0.00		0
threshold alerts latch	450	0.00		0
transaction allocation	697,122	0.00		0
transaction branch allocation	2,404	0.00		0
undo global data	118,246	0.02	0.00	0
user lock	232	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
shared pool	2,457,473	72,634	113	72,529
cache buffers chains	6,289,551,884	35,887	341	35,572
row cache objects	840,371	1,999	2	1,997
library cache	451,805	1,759	117	1,649
In memory undo latch	80,759	415	355	64
simulator hash latch	203,545,462	283	2	282
session allocation	56,964	234	1	233
library cache pin	143,290	229	1	228
dml lock allocation	96,037	185	1	184
enqueues	187,241	147	2	145
simulator lru latch	62,290	107	4	103
redo allocation	74,402	86	1	85
session idle bit	326,770	75	2	73
enqueue hash chains	308,572	66	1	65
object queue header operation	757,094	49	1	48
slave class create	68	3	3	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	235	147
In memory undo latch	kticmt: child	146	85
In memory undo latch	ktichg: child	3	145
cache buffers chains	kcbgtcr: kslbegin excl	2,536	2,617
cache buffers chains	kcbgtcr: fast path	186	8
cache buffers chains	kcbrls: kslbegin	136	399
cache buffers chains	kcbnew: new latch again	94	0
cache buffers chains	kcbzgb: scan from tail. nowait	53	0
cache buffers chains	kcbchg: kslbegin: bufs not pinned	49	52
cache buffers chains	kcbgcur: kslbegin	37	29
cache buffers chains	kcbget: pin buffer	33	5
cache buffers chains	kcbzib: multi-block read: nowait	26	0
cache buffers chains	kcbbic1	6	0
cache buffers chains	kcbnlc	3	10
cache buffers chains	kcbso1: set no access	3	2
cache buffers chains	kcbzwb	3	2
cache buffers chains	kcbo_ivd_process	2	0
cache buffers chains	kcb_pre_apply: kcbhq61	1	7
cache buffers chains	kcbbxsv	1	0
dml lock allocation	ktaidm	1	0
enqueue hash chains	ksqgtl3	1	1
enqueues	ksqgel: create enqueue	1	2
enqueues	ksqgtl2	1	0
library cache	kglpndl: child: after processing	98	1
library cache	kglpndl: child: before processing	9	10
library cache	kglhdiv: child	6	1
library cache	kglScanDependency	1	0
library cache	kgldte: child 0	1	21
library cache	kglobpn: child:	1	13
library cache lock	kgllkdl: child: no lock handle	1	5
library cache pin	kglpnal: child: alloc space	1	0
object queue header operation	kcbo_switch_cq	1	1
object queue header operation	kcbw_link_q	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	1	0
row cache objects	kqreqd: reget	1	0
session allocation	ksucri	1	1
session idle bit	ksupuc: set busy	2	0
shared pool	kghalo	89	83
shared pool	kghfrunp: alloc: cursor dur	9	0
shared pool	kghalp	6	4
shared pool	kghfre	5	12
shared pool	kghupr1	3	9
shared pool	kghasp	1	5
shared pool	kghfrunp: clatch: nowait	1	0
simulator hash latch	kcbsacc: lookup dba	2	2
simulator lru latch	kcbs_simulate: simulate set	4	0
slave class create	ksvcreate	3	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: 3,180,814,283
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	I_OBJ2	INDEX	2,070,363,888	65.09
SYS	SYSTEM	OBJ$	TABLE	1,011,886,384	31.81
SYS	SYSTEM	I_OBJ1	INDEX	38,786,288	1.22
SYS	SYSTEM	TABSUBPART$	TABLE	13,599,760	0.43
SYS	SYSTEM	I_TABSUBPART_POBJSUBPART$	INDEX	13,380,320	0.42

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 58,192
Captured Segments account for 73.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	WRI$_OPTSTAT_HISTGRM_HISTORY	TABLE	19,808	34.04
SYS	SYSAUX	I_WRI$_OPTSTAT_HH_ST	INDEX	6,519	11.20
SYS	SYSAUX	I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST	INDEX	3,074	5.28
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST	INDEX	1,975	3.39
SYS	SYSTEM	I_OBJ2	INDEX	1,794	3.08

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
PRECISE_PMDB	PRECISE_PMDB_IND_SMALL	IW_UDSX_01		INDEX	61	38.85
SYS	SYSTEM	I_FILE#_BLOCK#		INDEX	61	38.85
PRECISE_PMDB	PRECISE_PMDB_IND_SMALL	IW_PWJG_PK		INDEX	15	9.55
PRECISE_PMDB	PRECISE_PMDB_IND_SMALL	IW_PWJH_PWSE_ID	2_16_00_00	INDEX PARTITION	10	6.37
PRECISE_PMDB	PRECISE_PMDB_IND_SMALL	IW_PWJH_ID	2_16_00_00	INDEX PARTITION	5	3.18

Back to Segment Statistics
Back to Top

Segments by ITL Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
SYS	SYSTEM	SEG$		TABLE	10	90.91
SYS	SYSTEM	I_FILE#_BLOCK#		INDEX	1	9.09

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
PRECISE_PMDB	PRECISE_PMDB_IND_SMALL	IW_PWJH_PWJG_ID	2_16_00_00	INDEX PARTITION	86	27.13
PRECISE_PMDB	PRECISE_PMDB_IND_SMALL	IW_PWJH_PWSE_ID	2_16_00_00	INDEX PARTITION	67	21.14
SYS	SYSTEM	I_FILE#_BLOCK#		INDEX	60	18.93
SYS	SYSTEM	SEG$		TABLE	40	12.62
PRECISE_PMDB	PRECISE_PMDB_TAB_SMALL	PW_PWJH_JOB_HISTORY	2_16_00_00	TABLE PARTITION	16	5.05

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	175	0.00	6	1
dc_constraints	552	33.33	552	1
dc_database_links	116	0.00	0	1
dc_files	1,364	0.00	0	11
dc_global_oids	5,329	0.00	0	15
dc_histogram_data	5,358	5.10	243	6,495
dc_histogram_defs	78,660	2.61	943	8,144
dc_object_grants	2,016	0.00	0	19
dc_object_ids	29,833	5.28	1,320	4,220
dc_objects	17,917	11.54	1,640	8,149
dc_profiles	64	0.00	0	1
dc_rollback_segments	794	0.00	0	22
dc_segments	29,775	4.90	2,874	273,324
dc_sequences	7	0.00	7	4
dc_table_scns	4	100.00	0	0
dc_tablespace_quotas	1,393	0.00	1,393	3
dc_tablespaces	40,310	0.00	0	15
dc_usernames	5,220	0.02	0	38
dc_users	58,589	0.00	0	64
outstanding_alerts	156	0.00	0	13

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	479	0.21	6,036	0.05	1	0
CLUSTER	50	2.00	65	1.54	0	0
INDEX	1,698	1.65	5,621	0.62	7	0
SQL AREA	38,556	4.72	234,501	3.40	2,881	1,108
TABLE/PROCEDURE	4,589	0.72	39,935	9.46	2,917	0
TRIGGER	3,074	0.00	10,804	0.00	0	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	65.03		1.33	2.59	11	17	49	49
	Freeable	26.06	0.00	1.13	0.91	5		23	23
	SQL	1.24	0.17	0.04	0.10	1	114	28	22
	PL/SQL	0.53	0.38	0.01	0.02	0	0	47	47
E	Other	62.22		1.27	2.58	11	17	49	49
	Freeable	26.13	0.00	1.19	0.91	5		22	22
	SQL	1.02	0.05	0.04	0.10	1	114	28	18
	PL/SQL	0.48	0.36	0.01	0.02	0	0	47	47

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,325,400,064
Fixed Size	2,103,896
Redo Buffers	14,671,872
Variable Size	4,043,310,504

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	16.00	16.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	KQR M PO	138.94	139.65	0.51
shared	free memory	2,997.69	2,200.21	-26.60
shared	mvobj part des		814.26
shared	obj stat memo	74.17	74.56	0.52
shared	partitioning d	106.33	113.04	6.31
shared	sql area	136.31	127.74	-6.28
	buffer_cache	1,264.00	1,264.00	0.00
	fixed_sga	2.01	2.01	0.00
	log_buffer	13.99	13.99	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/product/admin/precisedb/adump
background_dump_dest	/oracle/product/admin/precisedb/bdump
backup_tape_io_slaves	TRUE
compatible	10.2.0.5.0
control_files	/oradata/PRECISEDB/control01.ctl, /oradata/PRECISEDB/control02.ctl, /oradata/PRECISEDB/control03.ctl
core_dump_dest	/oracle/product/admin/precisedb/cdump
db_block_size	8192
db_create_file_dest	/oradata
db_domain
db_file_multiblock_read_count	16
db_name	precised
db_recovery_file_dest	/oradata/recovery
db_recovery_file_dest_size	2147483648
db_unique_name	precisedb
dbwr_io_slaves	10
dispatchers	(PROTOCOL=TCP) (SERVICE=precisedbXDB)
job_queue_processes	10
log_archive_dest_1	LOCATION=/oradata/oraarch
open_cursors	2100
pga_aggregate_target	536870912
processes	2000
remote_login_passwordfile	EXCLUSIVE
sga_max_size	5385486336
sga_target	5385486336
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/product/admin/precisedb/udump

End of Report

% Blocks changed per Read:	0.05	Recursive Call %:	84.85
Rollback per transaction %:	22.32	Rows per Sort:	324.90

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	96.03	Soft Parse %:	96.80
Execute to Parse %:	41.76	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	82.29	% Non-Parse CPU:	99.56