WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
CDW	75754686	cdw	1	10.2.0.5.0	NO	CDWDBSCBG

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	733	22-Dec-12 05:00:10	44	2.7
End Snap:	734	22-Dec-12 06:00:23	51	3.3
Elapsed:		60.22 (mins)
DB Time:		2.02 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	69,840M	69,840M	Std Block Size:	8K
Shared Pool Size:	1,936M	1,936M	Log Buffer:	30,600K

Load Profile

	Per Second	Per Transaction
Redo size:	5,581.17	42,722.13
Logical reads:	242.86	1,858.98
Block changes:	35.00	267.88
Physical reads:	3.44	26.35
Physical writes:	0.22	1.70
User calls:	2.83	21.64
Parses:	2.39	18.27
Hard parses:	0.11	0.83
Sorts:	2.54	19.44
Logons:	0.02	0.14
Executes:	7.61	58.27
Transactions:	0.13

% Blocks changed per Read:	14.41	Recursive Call %:	95.43
Rollback per transaction %:	0.00	Rows per Sort:	750.60

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	98.58	In-memory Sort %:	100.00
Library Hit %:	96.95	Soft Parse %:	95.43
Execute to Parse %:	68.64	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	93.68	% Non-Parse CPU:	93.49

Shared Pool Statistics

	Begin	End
Memory Usage %:	86.10	86.02
% SQL with executions>1:	97.98	90.41
% Memory for SQL w/exec>1:	98.22	94.94

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
control file sequential read	165,342	65	0	53.3	System I/O
CPU time		39		32.0
db file sequential read	9,948	17	2	13.9	User I/O
control file parallel write	1,189	17	14	13.7	System I/O
db file parallel write	367	4	10	2.9	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

Wait Events Statistics

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

Time Model Statistics

• Total time in database user-calls (DB Time): 121.1s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

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

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

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

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

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

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): 121
• Captured SQL account for 92.4% of Total

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): 39
• Captured SQL account for 79.5% of Total

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: 877,440
• Captured SQL account for 80.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 12,436
• Captured SQL account for 191.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 27,504
• Captured SQL account for 46.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 8,625
• Captured SQL account for 45.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

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
04xtrk7uyhknh	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 is null
07n8v9h1dngzt	select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count(distinct "SNAP_ID"), sum(sys_op_opnsize("SNAP_ID")), count(distinct "DBID"), sum(sys_op_opnsize("DBID")), count(distinct "INSTANCE_NUMBER"), sum(sys_op_opnsize("INSTANCE_NUMBER")), count("TS#"), count(distinct "TS#"), sum(sys_op_opnsize("TS#")), count(distinct "OBJ#"), sum(sys_op_opnsize("OBJ#")), count(distinct "DATAOBJ#"), sum(sys_op_opnsize("DATAOBJ#")), count("LOGICAL_READS_TOTAL"), count(distinct "LOGICAL_READS_TOTAL"), sum(sys_op_opnsize("LOGICAL_READS_TOTAL")), substrb(dump(min("LOGICAL_READS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("LOGICAL_READS_TOTAL"), 16, 0, 32), 1, 120), count("LOGICAL_READS_DELTA"), count(distinct "LOGICAL_READS_DELTA"), sum(sys_op_opnsize("LOGICAL_READS_DELTA")), substrb(dump(min("LOGICAL_READS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("LOGICAL_READS_DELTA"), 16, 0, 32), 1, 120), count("BUFFER_BUSY_WAITS_TOTAL"), count(distinct "BUFFER_BUSY_WAITS_TOTAL"), sum(sys_op_opnsize("BUFFER_BUSY_WAITS_TOTAL")), substrb(dump(min("BUFFER_BUSY_WAITS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("BUFFER_BUSY_WAITS_TOTAL"), 16, 0, 32), 1, 120), count("BUFFER_BUSY_WAITS_DELTA"), count(distinct "BUFFER_BUSY_WAITS_DELTA"), sum(sys_op_opnsize("BUFFER_BUSY_WAITS_DELTA")), substrb(dump(min("BUFFER_BUSY_WAITS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("BUFFER_BUSY_WAITS_DELTA"), 16, 0, 32), 1, 120), count("DB_BLOCK_CHANGES_TOTAL"), count(distinct "DB_BLOCK_CHANGES_TOTAL"), sum(sys_op_opnsize("DB_BLOCK_CHANGES_TOTAL")), substrb(dump(min("DB_BLOCK_CHANGES_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("DB_BLOCK_CHANGES_TOTAL"), 16, 0, 32), 1, 120), count("DB_BLOCK_CHANGES_DELTA"), count(distinct "DB_BLOCK_CHANGES_DELTA"), sum(sys_op_opnsize("DB_BLOCK_CHANGES_DELTA")), substrb(dump(min("DB_BLOCK_CHANGES_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("DB_BLOCK_CHANGES_DELTA"), 16, 0, 32), 1, 120), count("PHYSICAL_READS_TOTAL"), count(distinct "PHYSICAL_READS_TOTAL"), sum(sys_op_opnsize("PHYSICAL_READS_TOTAL")), substrb(dump(min("PHYSICAL_READS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("PHYSICAL_READS_TOTAL"), 16, 0, 32), 1, 120), count("PHYSICAL_READS_DELTA"), count(distinct "PHYSICAL_READS_DELTA"), sum(sys_op_opnsize("PHYSICAL_READS_DELTA")), substrb(dump(min("PHYSICAL_READS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("PHYSICAL_READS_DELTA"), 16, 0, 32), 1, 120), count("PHYSICAL_WRITES_TOTAL"), count(distinct "PHYSICAL_WRITES_TOTAL"), sum(sys_op_opnsize("PHYSICAL_WRITES_TOTAL")), substrb(dump(min("PHYSICAL_WRITES_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("PHYSICAL_WRITES_TOTAL"), 16, 0, 32), 1, 120), count("PHYSICAL_WRITES_DELTA"), count(distinct "PHYSICAL_WRITES_DELTA"), sum(sys_op_opnsize("PHYSICAL_WRITES_DELTA")), substrb(dump(min("PHYSICAL_WRITES_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("PHYSICAL_WRITES_DELTA"), 16, 0, 32), 1, 120), count("PHYSICAL_READS_DIRECT_TOTAL"), count(distinct "PHYSICAL_READS_DIRECT_TOTAL"), sum(sys_op_opnsize("PHYSICAL_READS_DIRECT_TOTAL")), substrb(dump(min("PHYSICAL_READS_DIRECT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("PHYSICAL_READS_DIRECT_TOTAL"), 16, 0, 32), 1, 120), count("PHYSICAL_READS_DIRECT_DELTA"), count(distinct "PHYSICAL_READS_DIRECT_DELTA"), sum(sys_op_opnsize("PHYSICAL_READS_DIRECT_DELTA")), substrb(dump(min("PHYSICAL_READS_DIRECT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("PHYSICAL_READS_DIRECT_DELTA"), 16, 0, 32), 1, 120), count("PHYSICAL_WRITES_DIRECT_TOTAL"), count(distinct "PHYSICAL_WRITES_DIRECT_TOTAL"), sum(sys_op_opnsize("PHYSICAL_WRITES_DIRECT_TOTAL")), substrb(dump(min("PHYSICAL_WRITES_DIRECT_TOTAL"), 16, 0 , 32), 1, 120), substrb(dump(max("PHYSICAL_WRITES_DIRECT_TOTAL"), 16, 0, 32), 1, 120), count("PHYSICAL_WRITES_DIRECT_DELTA"), count(distinct "PHYSICAL_WRITES_DIRECT_DELTA"), sum(sys_op_opnsize("PHYSICAL_WRITES_DIRECT_DELTA")), substrb(dump(min("PHYSICAL_WRITES_DIRECT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("PHYSICAL_WRITES_DIRECT_DELTA"), 16, 0, 32), 1, 120), count("ITL_WAITS_TOTAL"), count(distinct "ITL_WAITS_TOTAL"), sum(sys_op_opnsize("ITL_WAITS_TOTAL")), substrb(dump(min("ITL_WAITS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("ITL_WAITS_TOTAL"), 16, 0, 32), 1, 120), count("ITL_WAITS_DELTA"), count(distinct "ITL_WAITS_DELTA"), sum(sys_op_opnsize("ITL_WAITS_DELTA")), substrb(dump(min("ITL_WAITS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("ITL_WAITS_DELTA"), 16, 0, 32), 1, 120), count("ROW_LOCK_WAITS_TOTAL"), count(distinct "ROW_LOCK_WAITS_TOTAL"), sum(sys_op_opnsize("ROW_LOCK_WAITS_TOTAL")), substrb(dump(min("ROW_LOCK_WAITS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("ROW_LOCK_WAITS_TOTAL"), 16, 0, 32), 1, 120), count("ROW_LOCK_WAITS_DELTA"), count(distinct "ROW_LOCK_WAITS_DELTA"), sum(sys_op_opnsize("ROW_LOCK_WAITS_DELTA")), substrb(dump(min("ROW_LOCK_WAITS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("ROW _LOCK_WAITS_DELTA"), 16, 0, 32), 1, 120), count("GC_BUFFER_BUSY_TOTAL"), count(distinct "GC_BUFFER_BUSY_TOTAL"), sum(sys_op_opnsize("GC_BUFFER_BUSY_TOTAL")), substrb(dump(min("GC_BUFFER_BUSY_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("GC_BUFFER_BUSY_TOTAL"), 16, 0, 32), 1, 120), count("GC_BUFFER_BUSY_DELTA"), count(distinct "GC_BUFFER_BUSY_DELTA"), sum(sys_op_opnsize("GC_BUFFER_BUSY_DELTA")), substrb(dump(min("GC_BUFFER_BUSY_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("GC_BUFFER_BUSY_DELTA"), 16, 0, 32), 1, 120), count("GC_CR_BLOCKS_RECEIVED_TOTAL"), count(distinct "GC_CR_BLOCKS_RECEIVED_TOTAL"), sum(sys_op_opnsize("GC_CR_BLOCKS_RECEIVED_TOTAL")), substrb(dump(min("GC_CR_BLOCKS_RECEIVED_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("GC_CR_BLOCKS_RECEIVED_TOTAL"), 16, 0, 32), 1, 120), count("GC_CR_BLOCKS_RECEIVED_DELTA"), count(distinct "GC_CR_BLOCKS_RECEIVED_DELTA"), sum(sys_op_opnsize("GC_CR_BLOCKS_RECEIVED_DELTA")), substrb(dump(min("GC_CR_BLOCKS_RECEIVED_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("GC_CR_BLOCKS_RECEIVED_DELTA"), 16, 0, 32), 1, 120), count("GC_CU_BLOCKS_RECEIVED_TOTAL"), count(distinct "GC_CU_BLOCKS_RECEIVED_TOTAL"), sum(sys_op_opnsize("GC_CU_BLOCKS_RECEIVED_TOTAL")), substrb(dump(min("GC_CU_BLOCKS_RECEIVED_TOT AL"), 16, 0, 32), 1, 120), substrb(dump(max("GC_CU_BLOCKS_RECEIVED_TOTAL"), 16, 0, 32), 1, 120), count("GC_CU_BLOCKS_RECEIVED_DELTA"), count(distinct "GC_CU_BLOCKS_RECEIVED_DELTA"), sum(sys_op_opnsize("GC_CU_BLOCKS_RECEIVED_DELTA")), substrb(dump(min("GC_CU_BLOCKS_RECEIVED_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("GC_CU_BLOCKS_RECEIVED_DELTA"), 16, 0, 32), 1, 120), count("SPACE_USED_TOTAL"), count(distinct "SPACE_USED_TOTAL"), sum(sys_op_opnsize("SPACE_USED_TOTAL")), substrb(dump(min("SPACE_USED_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("SPACE_USED_TOTAL"), 16, 0, 32), 1, 120), count("SPACE_USED_DELTA"), count(distinct "SPACE_USED_DELTA"), sum(sys_op_opnsize("SPACE_USED_DELTA")), count("SPACE_ALLOCATED_TOTAL"), count(distinct "SPACE_ALLOCATED_TOTAL"), sum(sys_op_opnsize("SPACE_ALLOCATED_TOTAL")), substrb(dump(min("SPACE_ALLOCATED_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("SPACE_ALLOCATED_TOTAL"), 16, 0, 32), 1, 120), count("SPACE_ALLOCATED_DELTA"), count(distinct "SPACE_ALLOCATED_DELTA"), sum(sys_op_opnsize("SPACE_ALLOCATED_DELTA")), count("TABLE_SCANS_TOTAL"), count(distinct "TABLE_SCANS_TOTAL"), sum(sys_op_opnsize("TABLE_SCANS_TOTAL")), substrb(dump(min("TABLE_SCANS_TOTAL"), 16, 0, 32), 1, 120), su bstrb(dump(max("TABLE_SCANS_TOTAL"), 16, 0, 32), 1, 120), count("TABLE_SCANS_DELTA"), count(distinct "TABLE_SCANS_DELTA"), sum(sys_op_opnsize("TABLE_SCANS_DELTA")), count("CHAIN_ROW_EXCESS_TOTAL"), count(distinct "CHAIN_ROW_EXCESS_TOTAL"), sum(sys_op_opnsize("CHAIN_ROW_EXCESS_TOTAL")), substrb(dump(min("CHAIN_ROW_EXCESS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("CHAIN_ROW_EXCESS_TOTAL"), 16, 0, 32), 1, 120), count("CHAIN_ROW_EXCESS_DELTA"), count(distinct "CHAIN_ROW_EXCESS_DELTA"), sum(sys_op_opnsize("CHAIN_ROW_EXCESS_DELTA")) from "SYS"."WRH$_SEG_STAT" t
08pj61ghtuug2	select proxyserve0_.c_id as c1_36_, proxyserve0_.c_proxyport as c2_36_, proxyserve0_.c_alias as c3_36_, proxyserve0_.c_proxyip as c4_36_, proxyserve0_.c_concurrentjob as c5_36_, proxyserve0_.c_logsavetime as c6_36_, proxyserve0_.c_recordsavetime as c7_36_, proxyserve0_.c_cpuUsage as c8_36_, proxyserve0_.c_physicalRamUsge as c9_36_, proxyserve0_.c_proxyname as c10_36_, proxyserve0_.c_proxymemo as c11_36_, proxyserve0_.c_password as c12_36_, proxyserve0_.c_username as c13_36_ from ts_proxyserver proxyserve0_
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0ybwd63u2any5	insert into sys.wri$_optstat_histgrm_history (obj#, intcol#, savtime, bucket, endpoint, epvalue) select hg.obj#, hg.intcol#, :3, hg.bucket, hg.endpoint, hg.epvalue from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2
119066tqzx40m	select df.BYTES, f.PHYRDS, f.PHYWRTS, f.PHYBLKRD, f.PHYBLKWRT, f.READTIM, f.WRITETIM, f.MAXIORTM, f.MAXIOWTM from v$filestat f, dba_data_files df where f.file# = df.file_id AND df.tablespace_name = 'CDWAUDIT' AND df.file_name = 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\CDWAUDIT.DBF'
1fp87jmavgnvs	insert into sys.wri$_optstat_ind_history(obj#, rowcnt, leafcnt, distkey, lblkkey, dblkkey, clufac, blevel, analyzetime, samplesize, guessq, cachedblk, cachehit, logicalread, savtime, flags) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16)
1hqswxr052pg8	select monitorinf0_.c_id as c1_44_0_, monitorinf0_.c_maxMemory as c2_44_0_, monitorinf0_.c_cpuUsage as c3_44_0_, monitorinf0_.c_ip as c4_44_0_, monitorinf0_.c_totalMemory as c5_44_0_, monitorinf0_.c_freeMemory as c6_44_0_, monitorinf0_.c_osName as c7_44_0_, monitorinf0_.c_totalMemorySize as c8_44_0_, monitorinf0_.c_freeMemorySize as c9_44_0_, monitorinf0_.c_usedMemory as c10_44_0_, monitorinf0_.c_totalThread as c11_44_0_, monitorinf0_.c_diskUsage as c12_44_0_, monitorinf0_.c_serverType as c13_44_0_, monitorinf0_.c_date as c14_44_0_ from tsc_monitor monitorinf0_ where monitorinf0_.c_id=:1
1vu1su5fxbhrd	SELECT ddf.file_name file_name, vdf.status status, ddf.tablespace_name tablespace_name, '', ddf.autoextensible autoextensible, ddf.increment_by increment_by, ddf.maxbytes max_file_size, vdf.create_bytes FROM sys.dba_data_files ddf, v$datafile vdf /*+ all_rows use_concat */ WHERE (ddf.file_name = vdf.name) UNION ALL SELECT dtf.file_name file_name, vtf.status status, dtf.tablespace_name tablespace_name, '', dtf.autoextensible autoextensible, dtf.increment_by increment_by, dtf.maxbytes max_file_size, vtf.create_bytes FROM sys.dba_temp_files dtf, v$tempfile vtf WHERE (dtf.file_id = vtf.file#)
1y1n1kfamjg4x	select df.BYTES, f.PHYRDS, f.PHYWRTS, f.PHYBLKRD, f.PHYBLKWRT, f.READTIM, f.WRITETIM, f.MAXIORTM, f.MAXIOWTM from v$filestat f, dba_data_files df where f.file# = df.file_id AND df.tablespace_name = 'CDWANALYSE' AND df.file_name = 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\CDWANALYSE.DBF'
27xdav1rg5g14	select u.name, o.name, o.namespace, o.type#, decode(bitand(i.property, 1024), 0, 0, 1) from ind$ i, obj$ o, user$ u where i.obj#=:1 and o.obj#=i.bo# and o.owner#=u.user#
2fdkggt13qcdd	select sum(PHYRDS), sum(PHYWRTS), sum(PHYBLKRD), sum(PHYBLKWRT), max(READTIM), max(WRITETIM), max(MAXIORTM), max(MAXIOWTM) from v$filestat, dba_data_files df where file# = file_id AND df.tablespace_name = 'SYSAUX' AND df.status = 'AVAILABLE'
330q95smuwnv9	update hist_head$ set bucket_cnt=:3, row_cnt=:4, cache_cnt=:5, null_cnt=:6, timestamp#=:7, sample_size=:8, minimum=:9, maximum=:10, distcnt=:11, lowval=:12, hival=:13, density=:14, spare1=:15, spare2=:16, avgcln=:17, col#=:18 where obj#=:1 and intcol#=:2
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
3axxxnjp5jjwj	delete from ind_stats$ where obj#=:1
3kywng531fcxu	delete from tab_stats$ where obj#=:1
46xws8s7n4ytj	select df.BYTES, f.PHYRDS, f.PHYWRTS, f.PHYBLKRD, f.PHYBLKWRT, f.READTIM, f.WRITETIM, f.MAXIORTM, f.MAXIOWTM from v$filestat f, dba_data_files df where f.file# = df.file_id AND df.tablespace_name = 'USERS' AND df.file_name = 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\USERS01.DBF'
4xmsck0n8xqg5	select sum(PHYRDS), sum(PHYWRTS), sum(PHYBLKRD), sum(PHYBLKWRT), max(READTIM), max(WRITETIM), max(MAXIORTM), max(MAXIOWTM) from v$filestat, dba_data_files df where file# = file_id AND df.tablespace_name = 'USERS' AND df.status = 'AVAILABLE'
4y1y43113gv8f	delete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3
53hbjy45s92v0	select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("ZOPEXERCISECONVENTION"), count(distinct "ZOPEXERCISECONVENTION"), substrb(dump(min("ZOPEXERCISECONVENTION"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPEXERCISECONVENTION"), 16, 0, 32), 1, 120), count("ZOPEXERCISEDATE"), count(distinct "ZOPEXERCISEDATE"), substrb(dump(min("ZOPEXERCISEDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPEXERCISEDATE"), 16, 0, 32), 1, 120), count("ZOPEXERCISEPRICE"), count(distinct "ZOPEXERCISEPRICE"), sum(sys_op_opnsize("ZOPEXERCISEPRICE")), substrb(dump(min("ZOPEXERCISEPRICE"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPEXERCISEPRICE"), 16, 0, 32), 1, 120), count("ZOPFACEVALUE"), count(distinct "ZOPFACEVALUE"), sum(sys_op_opnsize("ZOPFACEVALUE")), substrb(dump(min("ZOPFACEVALUE"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPFACEVALUE"), 16, 0, 32), 1, 120), count("ZOPFIRSTFINERATE"), count(distinct "ZOPFIRSTFINERATE"), sum(sys_op_opnsize("ZOPFIRSTFINERATE")), substrb(dump(min("ZOPFIRSTFINERATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPFIRSTFINERATE"), 16, 0, 32), 1, 120), count("ZOPFIRSTOPTIONDATE"), count(distinct "ZOPFIRSTOPTIONDATE"), substrb(dump(m in("ZOPFIRSTOPTIONDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPFIRSTOPTIONDATE"), 16, 0, 32), 1, 120), count("ZOPMARGIN"), count(distinct "ZOPMARGIN"), substrb(dump(min("ZOPMARGIN"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPMARGIN"), 16, 0, 32), 1, 120), count("ZOPMARGINTREATMENT"), count(distinct "ZOPMARGINTREATMENT"), substrb(dump(min("ZOPMARGINTREATMENT"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPMARGINTREATMENT"), 16, 0, 32), 1, 120), count("ZOPPREMIUMPAYABLE"), count(distinct "ZOPPREMIUMPAYABLE"), substrb(dump(min("ZOPPREMIUMPAYABLE"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPPREMIUMPAYABLE"), 16, 0, 32), 1, 120), count("ZOPPRICINGMODEL"), count(distinct "ZOPPRICINGMODEL"), sum(sys_op_opnsize("ZOPPRICINGMODEL")), substrb(dump(min("ZOPPRICINGMODEL"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPPRICINGMODEL"), 16, 0, 32), 1, 120), count("ZOPQUOTEMETHOD"), count(distinct "ZOPQUOTEMETHOD"), substrb(dump(min("ZOPQUOTEMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPQUOTEMETHOD"), 16, 0, 32), 1, 120), count("ZOPRECEIVABLECCY"), count(distinct "ZOPRECEIVABLECCY"), substrb(dump(min("ZOPRECEIVABLECCY"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPRECEIVABLECCY"), 16, 0, 32), 1, 120), count("ZOPSECONDFIN ERATE"), count(distinct "ZOPSECONDFINERATE"), sum(sys_op_opnsize("ZOPSECONDFINERATE")), substrb(dump(min("ZOPSECONDFINERATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPSECONDFINERATE"), 16, 0, 32), 1, 120), count("ZOPSECONDOPTIONDATE"), count(distinct "ZOPSECONDOPTIONDATE"), substrb(dump(min("ZOPSECONDOPTIONDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPSECONDOPTIONDATE"), 16, 0, 32), 1, 120), count("ZOPSETTLEMENTDATE"), count(distinct "ZOPSETTLEMENTDATE"), substrb(dump(min("ZOPSETTLEMENTDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPSETTLEMENTDATE"), 16, 0, 32), 1, 120), count("ZOPTARGETSECURITY"), count(distinct "ZOPTARGETSECURITY"), substrb(dump(min("ZOPTARGETSECURITY"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPTARGETSECURITY"), 16, 0, 32), 1, 120), count("ZOPTHIRDFINERATE"), count(distinct "ZOPTHIRDFINERATE"), sum(sys_op_opnsize("ZOPTHIRDFINERATE")), substrb(dump(min("ZOPTHIRDFINERATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPTHIRDFINERATE"), 16, 0, 32), 1, 120), count("ZOPTHIRDOPTIONDATE"), count(distinct "ZOPTHIRDOPTIONDATE"), substrb(dump(min("ZOPTHIRDOPTIONDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPTHIRDOPTIONDATE"), 16, 0, 32), 1, 120), count("ZOPTIMESTEPS"), count(distinct "ZOPTIMEST EPS"), sum(sys_op_opnsize("ZOPTIMESTEPS")), substrb(dump(min("ZOPTIMESTEPS"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPTIMESTEPS"), 16, 0, 32), 1, 120), count("ZOPYIELDPRICE"), count(distinct "ZOPYIELDPRICE"), substrb(dump(min("ZOPYIELDPRICE"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPYIELDPRICE"), 16, 0, 32), 1, 120), count("ZPRAVERAGELIFE"), count(distinct "ZPRAVERAGELIFE"), sum(sys_op_opnsize("ZPRAVERAGELIFE")), substrb(dump(min("ZPRAVERAGELIFE"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRAVERAGELIFE"), 16, 0, 32), 1, 120), count("ZPRDATE"), count(distinct "ZPRDATE"), substrb(dump(min("ZPRDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRDATE"), 16, 0, 32), 1, 120), count("ZPRDELTA"), count(distinct "ZPRDELTA"), sum(sys_op_opnsize("ZPRDELTA")), substrb(dump(min("ZPRDELTA"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRDELTA"), 16, 0, 32), 1, 120), count("ZPRFADJUSTYIELD"), count(distinct "ZPRFADJUSTYIELD"), substrb(dump(min("ZPRFADJUSTYIELD"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRFADJUSTYIELD"), 16, 0, 32), 1, 120), count("ZPRFFRNVALUATION"), count(distinct "ZPRFFRNVALUATION"), substrb(dump(min("ZPRFFRNVALUATION"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRFFRNVALUATION"), 16, 0, 32), 1, 120), count("ZPRFINDEXVALUATION"), count(distinct "ZPRFINDEXVALUATION"), substrb(dump(min("ZPRFINDEXVALUATION"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRFINDEXVALUATION"), 16, 0, 32), 1, 120), count("ZPRFLIFEMETHOD"), count(distinct "ZPRFLIFEMETHOD"), substrb(dump(min("ZPRFLIFEMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRFLIFEMETHOD"), 16, 0, 32), 1, 120), count("ZPRFVALUATIONMETHOD"), count(distinct "ZPRFVALUATIONMETHOD"), substrb(dump(min("ZPRFVALUATIONMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRFVALUATIONMETHOD"), 16, 0, 32), 1, 120), count("ZPRFYIELDFACTOR"), count(distinct "ZPRFYIELDFACTOR"), sum(sys_op_opnsize("ZPRFYIELDFACTOR")), substrb(dump(min("ZPRFYIELDFACTOR"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRFYIELDFACTOR"), 16, 0, 32), 1, 120), count("ZPRINTERESTMARGIN"), count(distinct "ZPRINTERESTMARGIN"), sum(sys_op_opnsize("ZPRINTERESTMARGIN")), substrb(dump(min("ZPRINTERESTMARGIN"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRINTERESTMARGIN"), 16, 0, 32), 1, 120), count("ZPRMARKETMARGIN"), count(distinct "ZPRMARKETMARGIN"), sum(sys_op_opnsize("ZPRMARKETMARGIN")), substrb(dump(min("ZPRMARKETMARGIN"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRMARKETMARGIN"), 16, 0, 32), 1, 120), count("ZPRMETHOD"), count(distinct "ZPRMETHOD"), substrb(dump(min("ZPRMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRMETHOD"), 16, 0, 32), 1, 120), count("ZPRPARTPERIODDISCRATE"), count(distinct "ZPRPARTPERIODDISCRATE"), sum(sys_op_opnsize("ZPRPARTPERIODDISCRATE")), substrb(dump(min("ZPRPARTPERIODDISCRATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRPARTPERIODDISCRATE"), 16, 0, 32), 1, 120), count("ZPRPRICE"), count(distinct "ZPRPRICE"), sum(sys_op_opnsize("ZPRPRICE")), substrb(dump(min("ZPRPRICE"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRPRICE"), 16, 0, 32), 1, 120), count("ZPRPRICECONDITIONDIVIDEND"), count(distinct "ZPRPRICECONDITIONDIVIDEND"), substrb(dump(min("ZPRPRICECONDITIONDIVIDEND"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRPRICECONDITIONDIVIDEND"), 16, 0, 32), 1, 120), count("ZPRPRICECONDITIONRIGHTS"), count(distinct "ZPRPRICECONDITIONRIGHTS"), substrb(dump(min("ZPRPRICECONDITIONRIGHTS"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRPRICECONDITIONRIGHTS"), 16, 0, 32), 1, 120), count("ZPRPRICECONDITIONSHARESPLIT"), count(distinct "ZPRPRICECONDITIONSHARESPLIT"), substrb(dump(min("ZPRPRICECONDITIONSHARESPLIT"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRPRICECONDITIONSHARESPLIT"), 16, 0, 32), 1, 120), count( "ZPRPRICINGFACTOR"), count(distinct "ZPRPRICINGFACTOR"), sum(sys_op_opnsize("ZPRPRICINGFACTOR")), substrb(dump(min("ZPRPRICINGFACTOR"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRPRICINGFACTOR"), 16, 0, 32), 1, 120), count("ZPRROUNDINGMETHOD"), count(distinct "ZPRROUNDINGMETHOD"), substrb(dump(min("ZPRROUNDINGMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRROUNDINGMETHOD"), 16, 0, 32), 1, 120), count("ZPRROUNDTO"), count(distinct "ZPRROUNDTO"), sum(sys_op_opnsize("ZPRROUNDTO")), substrb(dump(min("ZPRROUNDTO"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRROUNDTO"), 16, 0, 32), 1, 120), count("ZPRSBLOOMBERGSOURCETYPE"), count(distinct "ZPRSBLOOMBERGSOURCETYPE"), substrb(dump(min("ZPRSBLOOMBERGSOURCETYPE"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRSBLOOMBERGSOURCETYPE"), 16, 0, 32), 1, 120), count("ZPRSBLOOMBERGYELLOWKEY"), count(distinct "ZPRSBLOOMBERGYELLOWKEY"), substrb(dump(min("ZPRSBLOOMBERGYELLOWKEY"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRSBLOOMBERGYELLOWKEY"), 16, 0, 32), 1, 120), count("ZPRSECONDPRICE"), count(distinct "ZPRSECONDPRICE"), sum(sys_op_opnsize("ZPRSECONDPRICE")), substrb(dump(min("ZPRSECONDPRICE"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRSECONDPRICE"), 16, 0, 32), 1, 120), count(" ;ZPRSECONDYIELD"), count(distinct "ZPRSECONDYIELD"), sum(sys_op_opnsize("ZPRSECONDYIELD")), substrb(dump(min("ZPRSECONDYIELD"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRSECONDYIELD"), 16, 0, 32), 1, 120), count("ZPRSEXTERNALSOURCE"), count(distinct "ZPRSEXTERNALSOURCE"), substrb(dump(min("ZPRSEXTERNALSOURCE"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRSEXTERNALSOURCE"), 16, 0, 32), 1, 120), count("ZPRSPRICINGSOURCE1"), count(distinct "ZPRSPRICINGSOURCE1"), substrb(dump(min("ZPRSPRICINGSOURCE1"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRSPRICINGSOURCE1"), 16, 0, 32), 1, 120), count("ZPRSPRICINGSOURCE2"), count(distinct "ZPRSPRICINGSOURCE2"), substrb(dump(min("ZPRSPRICINGSOURCE2"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRSPRICINGSOURCE2"), 16, 0, 32), 1, 120), count("ZPRSWAPRATEEFFDATE"), count(distinct "ZPRSWAPRATEEFFDATE"), substrb(dump(min("ZPRSWAPRATEEFFDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRSWAPRATEEFFDATE"), 16, 0, 32), 1, 120), count("ZPRSWAPRATEMAT"), count(distinct "ZPRSWAPRATEMAT"), sum(sys_op_opnsize("ZPRSWAPRATEMAT")), substrb(dump(min("ZPRSWAPRATEMAT"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRSWAPRATEMAT"), 16, 0, 32), 1, 120), count("ZPRTHIRDPRICE"), count(distinct "ZPRTHIRDPRICE&qu ot;), sum(sys_op_opnsize("ZPRTHIRDPRICE")), substrb(dump(min("ZPRTHIRDPRICE"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRTHIRDPRICE"), 16, 0, 32), 1, 120), count("ZPRTHIRDYIELD"), count(distinct "ZPRTHIRDYIELD"), sum(sys_op_opnsize("ZPRTHIRDYIELD")), substrb(dump(min("ZPRTHIRDYIELD"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRTHIRDYIELD"), 16, 0, 32), 1, 120), count("ZPRTIME"), count(distinct "ZPRTIME"), sum(sys_op_opnsize("ZPRTIME")), substrb(dump(min("ZPRTIME"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRTIME"), 16, 0, 32), 1, 120), count("ZPRVOLATILITY"), count(distinct "ZPRVOLATILITY"), sum(sys_op_opnsize("ZPRVOLATILITY")), substrb(dump(min("ZPRVOLATILITY"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRVOLATILITY"), 16, 0, 32), 1, 120), count("ZPRYIELD"), count(distinct "ZPRYIELD"), sum(sys_op_opnsize("ZPRYIELD")), substrb(dump(min("ZPRYIELD"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRYIELD"), 16, 0, 32), 1, 120), count("ZPRYIELDCURVE"), count(distinct "ZPRYIELDCURVE"), substrb(dump(min("ZPRYIELDCURVE"), 16, 0, 32), 1, 120), substrb(dump(max("ZPRYIELDCURVE"), 16, 0, 32), 1, 120), count("ZPRYIELDTYPE"), count(distinct "ZPRYIELDTYPE"), substrb(dump(min("ZPRYIELDTYPE"), 16, 0, 32), 1 , 120), substrb(dump(max("ZPRYIELDTYPE"), 16, 0, 32), 1, 120), count("ZRIDUEDATE"), count(distinct "ZRIDUEDATE"), substrb(dump(min("ZRIDUEDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZRIDUEDATE"), 16, 0, 32), 1, 120), count("ZSCPLOCATION"), count(distinct "ZSCPLOCATION"), substrb(dump(min("ZSCPLOCATION"), 16, 0, 32), 1, 120), substrb(dump(max("ZSCPLOCATION"), 16, 0, 32), 1, 120), count("ZSCPSCRIP"), count(distinct "ZSCPSCRIP"), substrb(dump(min("ZSCPSCRIP"), 16, 0, 32), 1, 120), substrb(dump(max("ZSCPSCRIP"), 16, 0, 32), 1, 120), count("ZSSDEFERINTSETTLE"), count(distinct "ZSSDEFERINTSETTLE"), sum(sys_op_opnsize("ZSSDEFERINTSETTLE")), substrb(dump(min("ZSSDEFERINTSETTLE"), 16, 0, 32), 1, 120), substrb(dump(max("ZSSDEFERINTSETTLE"), 16, 0, 32), 1, 120), count("ZSSPAYMENTDELAY"), count(distinct "ZSSPAYMENTDELAY"), sum(sys_op_opnsize("ZSSPAYMENTDELAY")), substrb(dump(min("ZSSPAYMENTDELAY"), 16, 0, 32), 1, 120), substrb(dump(max("ZSSPAYMENTDELAY"), 16, 0, 32), 1, 120), count("ZSSSETTLEMENTAGENCY"), count(distinct "ZSSSETTLEMENTAGENCY"), substrb(dump(min("ZSSSETTLEMENTAGENCY"), 16, 0, 32), 1, 120), substrb(dump(max("ZSSSETTLEMENTAGENCY"), 16, 0, 32), 1, 120), count("ZSSSETTLEMENTMODE"), count(distinct &q uot;ZSSSETTLEMENTMODE"), substrb(dump(min("ZSSSETTLEMENTMODE"), 16, 0, 32), 1, 120), substrb(dump(max("ZSSSETTLEMENTMODE"), 16, 0, 32), 1, 120), count("ZSSSETTLEMENTSYSTEM"), count(distinct "ZSSSETTLEMENTSYSTEM"), substrb(dump(min("ZSSSETTLEMENTSYSTEM"), 16, 0, 32), 1, 120), substrb(dump(max("ZSSSETTLEMENTSYSTEM"), 16, 0, 32), 1, 120), count("ZSSSETTLEMENTTYPE"), count(distinct "ZSSSETTLEMENTTYPE"), substrb(dump(min("ZSSSETTLEMENTTYPE"), 16, 0, 32), 1, 120), substrb(dump(max("ZSSSETTLEMENTTYPE"), 16, 0, 32), 1, 120), count("ZBMREDEMPTIONFREQUENCY"), count(distinct "ZBMREDEMPTIONFREQUENCY"), substrb(dump(min("ZBMREDEMPTIONFREQUENCY"), 16, 0, 32), 1, 120), substrb(dump(max("ZBMREDEMPTIONFREQUENCY"), 16, 0, 32), 1, 120), count("ZBMREPOMATURITYPERIOD"), count(distinct "ZBMREPOMATURITYPERIOD"), sum(sys_op_opnsize("ZBMREPOMATURITYPERIOD")), substrb(dump(min("ZBMREPOMATURITYPERIOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZBMREPOMATURITYPERIOD"), 16, 0, 32), 1, 120), count("ZBODUEDATE"), count(distinct "ZBODUEDATE"), substrb(dump(min("ZBODUEDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZBODUEDATE"), 16, 0, 32), 1, 120), count("ZCFCASHFLOWMETHOD"), count(distinct "ZCFCASHFLOWMETHOD"), substrb(dump(min("ZCFCASHFLOWMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZCFCASHFLOWMETHOD"), 16, 0, 32), 1, 120), count("ZCFCONDPREPAYRATE"), count(distinct "ZCFCONDPREPAYRATE"), sum(sys_op_opnsize("ZCFCONDPREPAYRATE")), substrb(dump(min("ZCFCONDPREPAYRATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZCFCONDPREPAYRATE"), 16, 0, 32), 1, 120), count("ZCFFIRSTCASHFLOWMETHOD"), count(distinct "ZCFFIRSTCASHFLOWMETHOD"), sum(sys_op_opnsize("ZCFFIRSTCASHFLOWMETHOD")), substrb(dump(min("ZCFFIRSTCASHFLOWMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZCFFIRSTCASHFLOWMETHOD"), 16, 0, 32), 1, 120), count("ZCFFIRSTPAYMENTDATE"), count(distinct "ZCFFIRSTPAYMENTDATE"), substrb(dump(min("ZCFFIRSTPAYMENTDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZCFFIRSTPAYMENTDATE"), 16, 0, 32), 1, 120), count("ZCFLASTPAYMENTDATE"), count(distinct "ZCFLASTPAYMENTDATE"), substrb(dump(min("ZCFLASTPAYMENTDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZCFLASTPAYMENTDATE"), 16, 0, 32), 1, 120), count("ZCFNOOFCASHFLOWS"), count(distinct "ZCFNOOFCASHFLOWS"), sum(sys_op_opnsize("ZCFNOOFCASHFLOWS")), substrb(dump(min("ZCFNOOFCASHFLOWS"), 16, 0, 32), 1, 120), substrb(dump(max("ZCFNOOFCASHFLOWS"), 16, 0, 32), 1, 120), count("ZCFPREPAYRATE"), count(distinct "ZCFPREPAYRATE"), sum(sys_op_opnsize ("ZCFPREPAYRATE")), substrb(dump(min("ZCFPREPAYRATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZCFPREPAYRATE"), 16, 0, 32), 1, 120), count("ZCFPROJECTIONMETHOD"), count(distinct "ZCFPROJECTIONMETHOD"), substrb(dump(min("ZCFPROJECTIONMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZCFPROJECTIONMETHOD"), 16, 0, 32), 1, 120), count("ZCFROUNDING"), count(distinct "ZCFROUNDING"), substrb(dump(min("ZCFROUNDING"), 16, 0, 32), 1, 120), substrb(dump(max("ZCFROUNDING"), 16, 0, 32), 1, 120), count("ZCFWEIGHTEDAVGCOUP"), count(distinct "ZCFWEIGHTEDAVGCOUP"), sum(sys_op_opnsize("ZCFWEIGHTEDAVGCOUP")), substrb(dump(min("ZCFWEIGHTEDAVGCOUP"), 16, 0, 32), 1, 120), substrb(dump(max("ZCFWEIGHTEDAVGCOUP"), 16, 0, 32), 1, 120), count("ZCFWEIGHTEDAVGMAT"), count(distinct "ZCFWEIGHTEDAVGMAT"), sum(sys_op_opnsize("ZCFWEIGHTEDAVGMAT")), substrb(dump(min("ZCFWEIGHTEDAVGMAT"), 16, 0, 32), 1, 120), substrb(dump(max("ZCFWEIGHTEDAVGMAT"), 16, 0, 32), 1, 120), count("ZCONVNEXTCONVDATE"), count(distinct "ZCONVNEXTCONVDATE"), substrb(dump(min("ZCONVNEXTCONVDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZCONVNEXTCONVDATE"), 16, 0, 32), 1, 120), count("ZCONVPRICE"), count(distinct "ZCONVPRICE"), sum(sys_op_opnsize("ZCONVPRICE")), subs trb(dump(min("ZCONVPRICE"), 16, 0, 32), 1, 120), substrb(dump(max("ZCONVPRICE"), 16, 0, 32), 1, 120), count("ZCONVRATIO"), count(distinct "ZCONVRATIO"), sum(sys_op_opnsize("ZCONVRATIO")), substrb(dump(min("ZCONVRATIO"), 16, 0, 32), 1, 120), substrb(dump(max("ZCONVRATIO"), 16, 0, 32), 1, 120), count("ZCONVRATIODENOMINATOR"), count(distinct "ZCONVRATIODENOMINATOR"), sum(sys_op_opnsize("ZCONVRATIODENOMINATOR")), substrb(dump(min("ZCONVRATIODENOMINATOR"), 16, 0, 32), 1, 120), substrb(dump(max("ZCONVRATIODENOMINATOR"), 16, 0, 32), 1, 120), count("ZDIVACCUMDIV"), count(distinct "ZDIVACCUMDIV"), substrb(dump(min("ZDIVACCUMDIV"), 16, 0, 32), 1, 120), substrb(dump(max("ZDIVACCUMDIV"), 16, 0, 32), 1, 120), count("ZDIVANNUALDIVIDEND"), count(distinct "ZDIVANNUALDIVIDEND"), sum(sys_op_opnsize("ZDIVANNUALDIVIDEND")), substrb(dump(min("ZDIVANNUALDIVIDEND"), 16, 0, 32), 1, 120), substrb(dump(max("ZDIVANNUALDIVIDEND"), 16, 0, 32), 1, 120), count("ZDIVCURRENCYCODE"), count(distinct "ZDIVCURRENCYCODE"), substrb(dump(min("ZDIVCURRENCYCODE"), 16, 0, 32), 1, 120), substrb(dump(max("ZDIVCURRENCYCODE"), 16, 0, 32), 1, 120), count("ZDIVENQANNUALDIVRATE"), count(distinct "ZDIVENQANNUALDIVRATE"), sum(sys_op_opnsize("ZDIVENQANNUALDI VRATE")), substrb(dump(min("ZDIVENQANNUALDIVRATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZDIVENQANNUALDIVRATE"), 16, 0, 32), 1, 120), count("ZDIVNEXTDATE"), count(distinct "ZDIVNEXTDATE"), substrb(dump(min("ZDIVNEXTDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZDIVNEXTDATE"), 16, 0, 32), 1, 120), count("ZFLRPCOUPONRATEMETHOD"), count(distinct "ZFLRPCOUPONRATEMETHOD"), substrb(dump(min("ZFLRPCOUPONRATEMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPCOUPONRATEMETHOD"), 16, 0, 32), 1, 120), count("ZFLRPDEFAULTINTMARGIN"), count(distinct "ZFLRPDEFAULTINTMARGIN"), sum(sys_op_opnsize("ZFLRPDEFAULTINTMARGIN")), substrb(dump(min("ZFLRPDEFAULTINTMARGIN"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPDEFAULTINTMARGIN"), 16, 0, 32), 1, 120), count("ZFLRPEXTERNALINDEX"), count(distinct "ZFLRPEXTERNALINDEX"), substrb(dump(min("ZFLRPEXTERNALINDEX"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPEXTERNALINDEX"), 16, 0, 32), 1, 120), count("ZFLRPINDEXCODE"), count(distinct "ZFLRPINDEXCODE"), substrb(dump(min("ZFLRPINDEXCODE"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPINDEXCODE"), 16, 0, 32), 1, 120), count("ZFLRPINTCHANGEDATE"), count(distinct "ZFLRPINTCHANGEDATE"), substrb(dump(min("ZFLRPINTCHANGEDATE"), 16, 0, 32), 1, 12 0), substrb(dump(max("ZFLRPINTCHANGEDATE"), 16, 0, 32), 1, 120), count("ZFLRPINTCHANGEFREQ"), count(distinct "ZFLRPINTCHANGEFREQ"), substrb(dump(min("ZFLRPINTCHANGEFREQ"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPINTCHANGEFREQ"), 16, 0, 32), 1, 120), count("ZFLRPINTTABLECODE"), count(distinct "ZFLRPINTTABLECODE"), count("ZFLRPLOOKBACKDAYS"), count(distinct "ZFLRPLOOKBACKDAYS"), sum(sys_op_opnsize("ZFLRPLOOKBACKDAYS")), substrb(dump(min("ZFLRPLOOKBACKDAYS"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPLOOKBACKDAYS"), 16, 0, 32), 1, 120), count("ZFLRPMAXIMUMRATE"), count(distinct "ZFLRPMAXIMUMRATE"), sum(sys_op_opnsize("ZFLRPMAXIMUMRATE")), substrb(dump(min("ZFLRPMAXIMUMRATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPMAXIMUMRATE"), 16, 0, 32), 1, 120), count("ZFLRPMINIMUMRATE"), count(distinct "ZFLRPMINIMUMRATE"), sum(sys_op_opnsize("ZFLRPMINIMUMRATE")), substrb(dump(min("ZFLRPMINIMUMRATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPMINIMUMRATE"), 16, 0, 32), 1, 120), count("ZFLRPRESETFREQ"), count(distinct "ZFLRPRESETFREQ"), sum(sys_op_opnsize("ZFLRPRESETFREQ")), substrb(dump(min("ZFLRPRESETFREQ"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPRESETFREQ"), 16, 0, 32), 1, 120), count("ZFLRPRESETSCHEDU LE"), count(distinct "ZFLRPRESETSCHEDULE"), sum(sys_op_opnsize("ZFLRPRESETSCHEDULE")), substrb(dump(min("ZFLRPRESETSCHEDULE"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPRESETSCHEDULE"), 16, 0, 32), 1, 120), count("ZFLRPREVFLOATRATE"), count(distinct "ZFLRPREVFLOATRATE"), sum(sys_op_opnsize("ZFLRPREVFLOATRATE")), substrb(dump(min("ZFLRPREVFLOATRATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPREVFLOATRATE"), 16, 0, 32), 1, 120), count("ZFLRPSWAPCALCMETHOD"), count(distinct "ZFLRPSWAPCALCMETHOD"), substrb(dump(min("ZFLRPSWAPCALCMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPSWAPCALCMETHOD"), 16, 0, 32), 1, 120), count("ZFLRPSWAPFLOATINGFREQ"), count(distinct "ZFLRPSWAPFLOATINGFREQ"), sum(sys_op_opnsize("ZFLRPSWAPFLOATINGFREQ")), substrb(dump(min("ZFLRPSWAPFLOATINGFREQ"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPSWAPFLOATINGFREQ"), 16, 0, 32), 1, 120), count("ZFLRPSWAPFLOATINGNEXTDATE"), count(distinct "ZFLRPSWAPFLOATINGNEXTDATE"), substrb(dump(min("ZFLRPSWAPFLOATINGNEXTDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZFLRPSWAPFLOATINGNEXTDATE"), 16, 0, 32), 1, 120), count("ZFRPINTCHANGEMONTHS"), count(distinct "ZFRPINTCHANGEMONTHS"), sum(sys_op_opnsize("ZFRPINTCHANGEMONTHS")), substrb(dump(min("ZFRPINTCHANGEMON THS"), 16, 0, 32), 1, 120), substrb(dump(max("ZFRPINTCHANGEMONTHS"), 16, 0, 32), 1, 120), count("ZFRPPRINCIPALDEFINITION"), count(distinct "ZFRPPRINCIPALDEFINITION"), substrb(dump(min("ZFRPPRINCIPALDEFINITION"), 16, 0, 32), 1, 120), substrb(dump(max("ZFRPPRINCIPALDEFINITION"), 16, 0, 32), 1, 120), count("ZFRPREPAYSTRUCTURE"), count(distinct "ZFRPREPAYSTRUCTURE"), substrb(dump(min("ZFRPREPAYSTRUCTURE"), 16, 0, 32), 1, 120), substrb(dump(max("ZFRPREPAYSTRUCTURE"), 16, 0, 32), 1, 120), count("ZFRPROUNDPRINCIPAL"), count(distinct "ZFRPROUNDPRINCIPAL"), substrb(dump(min("ZFRPROUNDPRINCIPAL"), 16, 0, 32), 1, 120), substrb(dump(max("ZFRPROUNDPRINCIPAL"), 16, 0, 32), 1, 120), count("ZFRPSCHEDULE"), count(distinct "ZFRPSCHEDULE"), substrb(dump(min("ZFRPSCHEDULE"), 16, 0, 32), 1, 120), substrb(dump(max("ZFRPSCHEDULE"), 16, 0, 32), 1, 120), count("ZFUACCRUEDINTEREST"), count(distinct "ZFUACCRUEDINTEREST"), sum(sys_op_opnsize("ZFUACCRUEDINTEREST")), substrb(dump(min("ZFUACCRUEDINTEREST"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUACCRUEDINTEREST"), 16, 0, 32), 1, 120), count("ZFUBONDDURATION"), count(distinct "ZFUBONDDURATION"), sum(sys_op_opnsize("ZFUBONDDURATION")), substrb(dump(min("ZFUBONDDURATION"), 16, 0, 32), 1, 120), su bstrb(dump(max("ZFUBONDDURATION"), 16, 0, 32), 1, 120), count("ZFUBONDSECTOR"), count(distinct "ZFUBONDSECTOR"), substrb(dump(min("ZFUBONDSECTOR"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUBONDSECTOR"), 16, 0, 32), 1, 120), count("ZFUCOUPON"), count(distinct "ZFUCOUPON"), sum(sys_op_opnsize("ZFUCOUPON")), substrb(dump(min("ZFUCOUPON"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUCOUPON"), 16, 0, 32), 1, 120), count("ZFUDEPOSIT"), count(distinct "ZFUDEPOSIT"), sum(sys_op_opnsize("ZFUDEPOSIT")), substrb(dump(min("ZFUDEPOSIT"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUDEPOSIT"), 16, 0, 32), 1, 120), count("ZFUFACTOR"), count(distinct "ZFUFACTOR"), sum(sys_op_opnsize("ZFUFACTOR")), substrb(dump(min("ZFUFACTOR"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUFACTOR"), 16, 0, 32), 1, 120), count("ZFUFREQUENCY"), count(distinct "ZFUFREQUENCY"), sum(sys_op_opnsize("ZFUFREQUENCY")), substrb(dump(min("ZFUFREQUENCY"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUFREQUENCY"), 16, 0, 32), 1, 120), count("ZFUINDEX"), count(distinct "ZFUINDEX"), substrb(dump(min("ZFUINDEX"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUINDEX"), 16, 0, 32), 1, 120), count("ZFUMARGINACCOUNT"), count(distinct "ZFUMARGINA CCOUNT"), substrb(dump(min("ZFUMARGINACCOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUMARGINACCOUNT"), 16, 0, 32), 1, 120), count("ZFUMARGINCALL"), count(distinct "ZFUMARGINCALL"), sum(sys_op_opnsize("ZFUMARGINCALL")), substrb(dump(min("ZFUMARGINCALL"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUMARGINCALL"), 16, 0, 32), 1, 120), count("ZFUMATURITYDATE"), count(distinct "ZFUMATURITYDATE"), substrb(dump(min("ZFUMATURITYDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUMATURITYDATE"), 16, 0, 32), 1, 120), count("ZFUMULTIPLE"), count(distinct "ZFUMULTIPLE"), sum(sys_op_opnsize("ZFUMULTIPLE")), substrb(dump(min("ZFUMULTIPLE"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUMULTIPLE"), 16, 0, 32), 1, 120), count("ZFUTBADELMONTH"), count(distinct "ZFUTBADELMONTH"), sum(sys_op_opnsize("ZFUTBADELMONTH")), substrb(dump(min("ZFUTBADELMONTH"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUTBADELMONTH"), 16, 0, 32), 1, 120), count("ZFUTBADELYEAR"), count(distinct "ZFUTBADELYEAR"), sum(sys_op_opnsize("ZFUTBADELYEAR")), substrb(dump(min("ZFUTBADELYEAR"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUTBADELYEAR"), 16, 0, 32), 1, 120), count("ZFUTBAMANUALPAIROFF"), count(distinct "ZFUTBAMANUALPAIROFF"), sum(sys_op_opnsize ("ZFUTBAMANUALPAIROFF")), substrb(dump(min("ZFUTBAMANUALPAIROFF"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUTBAMANUALPAIROFF"), 16, 0, 32), 1, 120), count("ZFUTBAPRODCODE"), count(distinct "ZFUTBAPRODCODE"), substrb(dump(min("ZFUTBAPRODCODE"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUTBAPRODCODE"), 16, 0, 32), 1, 120), count("ZFUTBAPRODYEAR"), count(distinct "ZFUTBAPRODYEAR"), sum(sys_op_opnsize("ZFUTBAPRODYEAR")), substrb(dump(min("ZFUTBAPRODYEAR"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUTBAPRODYEAR"), 16, 0, 32), 1, 120), count("ZFUTBASEASONING"), count(distinct "ZFUTBASEASONING"), sum(sys_op_opnsize("ZFUTBASEASONING")), substrb(dump(min("ZFUTBASEASONING"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUTBASEASONING"), 16, 0, 32), 1, 120), count("ZFUTERM"), count(distinct "ZFUTERM"), sum(sys_op_opnsize("ZFUTERM")), substrb(dump(min("ZFUTERM"), 16, 0, 32), 1, 120), substrb(dump(max("ZFUTERM"), 16, 0, 32), 1, 120), count("ZIDACCEPTOR"), count(distinct "ZIDACCEPTOR"), substrb(dump(min("ZIDACCEPTOR"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDACCEPTOR"), 16, 0, 32), 1, 120), count("ZIDASSOCHOLDING"), count(distinct "ZIDASSOCHOLDING"), substrb(dump(min("ZIDASSOCHOLDING"), 16, 0, 32), 1, 120), s ubstrb(dump(max("ZIDASSOCHOLDING"), 16, 0, 32), 1, 120), count("ZIDCONVERSIONPERIOD"), count(distinct "ZIDCONVERSIONPERIOD"), substrb(dump(min("ZIDCONVERSIONPERIOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDCONVERSIONPERIOD"), 16, 0, 32), 1, 120), count(distinct "ZIDCOUNTERPARTY"), substrb(dump(min("ZIDCOUNTERPARTY"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDCOUNTERPARTY"), 16, 0, 32), 1, 120), count("ZIDDEBTOR"), count(distinct "ZIDDEBTOR"), substrb(dump(min("ZIDDEBTOR"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDDEBTOR"), 16, 0, 32), 1, 120), count("ZIDDEBTORRISK"), count(distinct "ZIDDEBTORRISK"), substrb(dump(min("ZIDDEBTORRISK"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDDEBTORRISK"), 16, 0, 32), 1, 120), count("ZIDDRAWER"), count(distinct "ZIDDRAWER"), substrb(dump(min("ZIDDRAWER"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDDRAWER"), 16, 0, 32), 1, 120), count("ZIDENDORSER"), count(distinct "ZIDENDORSER"), substrb(dump(min("ZIDENDORSER"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDENDORSER"), 16, 0, 32), 1, 120), count("ZIDFRATERM"), count(distinct "ZIDFRATERM"), sum(sys_op_opnsize("ZIDFRATERM")), substrb(dump(min("ZIDFRATERM"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDFRATERM"), 16 , 0, 32), 1, 120), count("ZIDISSUEPRICE"), count(distinct "ZIDISSUEPRICE"), sum(sys_op_opnsize("ZIDISSUEPRICE")), substrb(dump(min("ZIDISSUEPRICE"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDISSUEPRICE"), 16, 0, 32), 1, 120), count(distinct "ZIDISSUER"), substrb(dump(min("ZIDISSUER"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDISSUER"), 16, 0, 32), 1, 120), count("ZIDISSUESIZE"), count(distinct "ZIDISSUESIZE"), sum(sys_op_opnsize("ZIDISSUESIZE")), substrb(dump(min("ZIDISSUESIZE"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDISSUESIZE"), 16, 0, 32), 1, 120), count("ZIDLISTINGBOARD"), count(distinct "ZIDLISTINGBOARD"), substrb(dump(min("ZIDLISTINGBOARD"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDLISTINGBOARD"), 16, 0, 32), 1, 120), count("ZIDLOTSIZE"), count(distinct "ZIDLOTSIZE"), sum(sys_op_opnsize("ZIDLOTSIZE")), substrb(dump(min("ZIDLOTSIZE"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDLOTSIZE"), 16, 0, 32), 1, 120), count("ZIDNEWISSUE"), count(distinct "ZIDNEWISSUE"), sum(sys_op_opnsize("ZIDNEWISSUE")), substrb(dump(min("ZIDNEWISSUE"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDNEWISSUE"), 16, 0, 32), 1, 120), count("ZIDNEWISSUESIZE"), count(distinct "ZIDNEWISSUESIZE"), sum(sys_op_opnsize(&qu ot;ZIDNEWISSUESIZE")), substrb(dump(min("ZIDNEWISSUESIZE"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDNEWISSUESIZE"), 16, 0, 32), 1, 120), count("ZIDOPTIONTRADED"), count(distinct "ZIDOPTIONTRADED"), sum(sys_op_opnsize("ZIDOPTIONTRADED")), substrb(dump(min("ZIDOPTIONTRADED"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDOPTIONTRADED"), 16, 0, 32), 1, 120), count("ZIDPAIDUPVALUE"), count(distinct "ZIDPAIDUPVALUE"), sum(sys_op_opnsize("ZIDPAIDUPVALUE")), substrb(dump(min("ZIDPAIDUPVALUE"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDPAIDUPVALUE"), 16, 0, 32), 1, 120), count("ZIDPARVALUE"), count(distinct "ZIDPARVALUE"), sum(sys_op_opnsize("ZIDPARVALUE")), substrb(dump(min("ZIDPARVALUE"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDPARVALUE"), 16, 0, 32), 1, 120), count("ZIDPOOLTERM"), count(distinct "ZIDPOOLTERM"), sum(sys_op_opnsize("ZIDPOOLTERM")), substrb(dump(min("ZIDPOOLTERM"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDPOOLTERM"), 16, 0, 32), 1, 120), count("ZIDPRODUCTCODE"), count(distinct "ZIDPRODUCTCODE"), substrb(dump(min("ZIDPRODUCTCODE"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDPRODUCTCODE"), 16, 0, 32), 1, 120), count("ZIDPRODUCTYEAR"), count(distinct "ZIDPRODUCTYEAR"), sum(sys_op_opnsize(&q uot;ZIDPRODUCTYEAR")), substrb(dump(min("ZIDPRODUCTYEAR"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDPRODUCTYEAR"), 16, 0, 32), 1, 120), count("ZIDQUOTECURRENCYCODE"), count(distinct "ZIDQUOTECURRENCYCODE"), substrb(dump(min("ZIDQUOTECURRENCYCODE"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDQUOTECURRENCYCODE"), 16, 0, 32), 1, 120), count("ZIDSEASONING"), count(distinct "ZIDSEASONING"), sum(sys_op_opnsize("ZIDSEASONING")), substrb(dump(min("ZIDSEASONING"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDSEASONING"), 16, 0, 32), 1, 120), count("ZIDSHARESISSUED"), count(distinct "ZIDSHARESISSUED"), sum(sys_op_opnsize("ZIDSHARESISSUED")), substrb(dump(min("ZIDSHARESISSUED"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDSHARESISSUED"), 16, 0, 32), 1, 120), count("ZIDTAXISSUEDATE"), count(distinct "ZIDTAXISSUEDATE"), substrb(dump(min("ZIDTAXISSUEDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDTAXISSUEDATE"), 16, 0, 32), 1, 120), count("ZIDTERMTOLISTING"), count(distinct "ZIDTERMTOLISTING"), sum(sys_op_opnsize("ZIDTERMTOLISTING")), substrb(dump(min("ZIDTERMTOLISTING"), 16, 0, 32), 1, 120), substrb(dump(max("ZIDTERMTOLISTING"), 16, 0, 32), 1, 120), count("ZIFCFIRSTCOUPONDATE"), count(distinct "ZIFCFIRSTCOUPONDATE"), subs trb(dump(min("ZIFCFIRSTCOUPONDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZIFCFIRSTCOUPONDATE"), 16, 0, 32), 1, 120), count("ZILCLASTFULLCOUPON"), count(distinct "ZILCLASTFULLCOUPON"), substrb(dump(min("ZILCLASTFULLCOUPON"), 16, 0, 32), 1, 120), substrb(dump(max("ZILCLASTFULLCOUPON"), 16, 0, 32), 1, 120), count("ZILCTHAIIRRPERIODMETHOD"), count(distinct "ZILCTHAIIRRPERIODMETHOD"), sum(sys_op_opnsize("ZILCTHAIIRRPERIODMETHOD")), substrb(dump(min("ZILCTHAIIRRPERIODMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZILCTHAIIRRPERIODMETHOD"), 16, 0, 32), 1, 120), count("ZIRPBASEINDEX"), count(distinct "ZIRPBASEINDEX"), sum(sys_op_opnsize("ZIRPBASEINDEX")), substrb(dump(min("ZIRPBASEINDEX"), 16, 0, 32), 1, 120), substrb(dump(max("ZIRPBASEINDEX"), 16, 0, 32), 1, 120), count("ZIRPCURRENTINDEX"), count(distinct "ZIRPCURRENTINDEX"), sum(sys_op_opnsize("ZIRPCURRENTINDEX")), substrb(dump(min("ZIRPCURRENTINDEX"), 16, 0, 32), 1, 120), substrb(dump(max("ZIRPCURRENTINDEX"), 16, 0, 32), 1, 120), count("ZIRPCURRENTINDEXDATE"), count(distinct "ZIRPCURRENTINDEXDATE"), substrb(dump(min("ZIRPCURRENTINDEXDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZIRPCURRENTINDEXDATE"), 16, 0, 32), 1, 120), count("ZIRPHIGHESTINDEX"), count(distinct " ZIRPHIGHESTINDEX"), sum(sys_op_opnsize("ZIRPHIGHESTINDEX")), substrb(dump(min("ZIRPHIGHESTINDEX"), 16, 0, 32), 1, 120), substrb(dump(max("ZIRPHIGHESTINDEX"), 16, 0, 32), 1, 120), count("ZIRPLAGTIME"), count(distinct "ZIRPLAGTIME"), sum(sys_op_opnsize("ZIRPLAGTIME")), substrb(dump(min("ZIRPLAGTIME"), 16, 0, 32), 1, 120), substrb(dump(max("ZIRPLAGTIME"), 16, 0, 32), 1, 120), count("ZIRPPREVIOUSINDEX"), count(distinct "ZIRPPREVIOUSINDEX"), sum(sys_op_opnsize("ZIRPPREVIOUSINDEX")), substrb(dump(min("ZIRPPREVIOUSINDEX"), 16, 0, 32), 1, 120), substrb(dump(max("ZIRPPREVIOUSINDEX"), 16, 0, 32), 1, 120), count("ZIRPROUNDADJCOUPON"), count(distinct "ZIRPROUNDADJCOUPON"), sum(sys_op_opnsize("ZIRPROUNDADJCOUPON")), substrb(dump(min("ZIRPROUNDADJCOUPON"), 16, 0, 32), 1, 120), substrb(dump(max("ZIRPROUNDADJCOUPON"), 16, 0, 32), 1, 120), count("ZIRPROUNDINDEX"), count(distinct "ZIRPROUNDINDEX"), substrb(dump(min("ZIRPROUNDINDEX"), 16, 0, 32), 1, 120), substrb(dump(max("ZIRPROUNDINDEX"), 16, 0, 32), 1, 120), count("ZIRPROUNDINDEXTO"), count(distinct "ZIRPROUNDINDEXTO"), sum(sys_op_opnsize("ZIRPROUNDINDEXTO")), substrb(dump(min("ZIRPROUNDINDEXTO"), 16, 0, 32), 1, 120), substrb(dump(max("ZIRPROUNDINDEXTO"), 16, 0, 32), 1, 1 20), count("ZIRPRPICONVFACTOR"), count(distinct "ZIRPRPICONVFACTOR"), sum(sys_op_opnsize("ZIRPRPICONVFACTOR")), substrb(dump(min("ZIRPRPICONVFACTOR"), 16, 0, 32), 1, 120), substrb(dump(max("ZIRPRPICONVFACTOR"), 16, 0, 32), 1, 120), count("ZIRPSECONDINDEX"), count(distinct "ZIRPSECONDINDEX"), sum(sys_op_opnsize("ZIRPSECONDINDEX")), substrb(dump(min("ZIRPSECONDINDEX"), 16, 0, 32), 1, 120), substrb(dump(max("ZIRPSECONDINDEX"), 16, 0, 32), 1, 120), count("ZLCVLASTCOUPMETHOD"), count(distinct "ZLCVLASTCOUPMETHOD"), substrb(dump(min("ZLCVLASTCOUPMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZLCVLASTCOUPMETHOD"), 16, 0, 32), 1, 120), count("ZLCVROUNDLAST"), count(distinct "ZLCVROUNDLAST"), sum(sys_op_opnsize("ZLCVROUNDLAST")), substrb(dump(min("ZLCVROUNDLAST"), 16, 0, 32), 1, 120), substrb(dump(max("ZLCVROUNDLAST"), 16, 0, 32), 1, 120), count("ZOPCALLPUT"), count(distinct "ZOPCALLPUT"), substrb(dump(min("ZOPCALLPUT"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPCALLPUT"), 16, 0, 32), 1, 120), count("ZOPCONVERSIONNUMERATOR"), count(distinct "ZOPCONVERSIONNUMERATOR"), sum(sys_op_opnsize("ZOPCONVERSIONNUMERATOR")), substrb(dump(min("ZOPCONVERSIONNUMERATOR"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPCONVERSIONNUMER ATOR"), 16, 0, 32), 1, 120), count("ZOPDELIVERABLECCY"), count(distinct "ZOPDELIVERABLECCY"), substrb(dump(min("ZOPDELIVERABLECCY"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPDELIVERABLECCY"), 16, 0, 32), 1, 120), count("ZOPDENOMINATOR"), count(distinct "ZOPDENOMINATOR"), sum(sys_op_opnsize("ZOPDENOMINATOR")), substrb(dump(min("ZOPDENOMINATOR"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPDENOMINATOR"), 16, 0, 32), 1, 120), count("ZOPETOOTC"), count(distinct "ZOPETOOTC"), substrb(dump(min("ZOPETOOTC"), 16, 0, 32), 1, 120), substrb(dump(max("ZOPETOOTC"), 16, 0, 32), 1, 120), count("FRANKCREDPERCENT"), count(distinct "FRANKCREDPERCENT"), sum(sys_op_opnsize("FRANKCREDPERCENT")), substrb(dump(min("FRANKCREDPERCENT"), 16, 0, 32), 1, 120), substrb(dump(max("FRANKCREDPERCENT"), 16, 0, 32), 1, 120), count("FRANKCREDPORTFOLIOCODE"), count(distinct "FRANKCREDPORTFOLIOCODE"), substrb(dump(min("FRANKCREDPORTFOLIOCODE"), 16, 0, 32), 1, 120), substrb(dump(max("FRANKCREDPORTFOLIOCODE"), 16, 0, 32), 1, 120), count("FREQUENCY"), count(distinct "FREQUENCY"), sum(sys_op_opnsize("FREQUENCY")), substrb(dump(min("FREQUENCY"), 16, 0, 32), 1, 120), substrb(dump(max("FREQUENCY"), 16, 0, 32), 1, 120), count("FULLNAME"), cou nt(distinct "FULLNAME"), substrb(dump(min(substrb("FULLNAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("FULLNAME", 1, 32)), 16, 0, 32), 1, 120), count("GLGROUP"), count(distinct "GLGROUP"), count("IMMSWAPFLAG"), count(distinct "IMMSWAPFLAG"), sum(sys_op_opnsize("IMMSWAPFLAG")), substrb(dump(min("IMMSWAPFLAG"), 16, 0, 32), 1, 120), substrb(dump(max("IMMSWAPFLAG"), 16, 0, 32), 1, 120), count("IMMSWAPFLOATINGFLAG"), count(distinct "IMMSWAPFLOATINGFLAG"), substrb(dump(min("IMMSWAPFLOATINGFLAG"), 16, 0, 32), 1, 120), substrb(dump(max("IMMSWAPFLOATINGFLAG"), 16, 0, 32), 1, 120), count("INCLUDEFRANKCREDS"), count(distinct "INCLUDEFRANKCREDS"), sum(sys_op_opnsize("INCLUDEFRANKCREDS")), substrb(dump(min("INCLUDEFRANKCREDS"), 16, 0, 32), 1, 120), substrb(dump(max("INCLUDEFRANKCREDS"), 16, 0, 32), 1, 120), count("INDEXED"), count(distinct "INDEXED"), sum(sys_op_opnsize("INDEXED")), substrb(dump(min("INDEXED"), 16, 0, 32), 1, 120), substrb(dump(max("INDEXED"), 16, 0, 32), 1, 120), count("INDUSTRYCLASS"), count(distinct "INDUSTRYCLASS"), substrb(dump(min("INDUSTRYCLASS"), 16, 0, 32), 1, 120), substrb(dump(max("INDUSTRYCLASS"), 16, 0, 32), 1, 120) from "CDWBASE"."T07_HIP_SECURITY" t
5pcvvwsh4cqdy	select a.value + b.value logical_reads, c.value phys_reads, 100 * ((a.value+b.value)-c.value), a.value+b.value from v$sysstat a, v$sysstat b, v$sysstat c where a.statistic# = 38 and b.statistic# = 39 and c.statistic# = 40
5v1dx7u9qrnhs	select sum(PHYRDS), sum(PHYWRTS), sum(PHYBLKRD), sum(PHYBLKWRT), max(READTIM), max(WRITETIM), max(MAXIORTM), max(MAXIOWTM) from v$filestat, dba_data_files df where file# = file_id AND df.tablespace_name = 'SYSTEM' AND df.status = 'AVAILABLE'
6mcpb06rctk0x	call dbms_space.auto_space_advisor_job_proc ( )
777sbg0j3pnxy	select sum(PHYRDS), sum(PHYWRTS), sum(PHYBLKRD), sum(PHYBLKWRT), max(READTIM), max(WRITETIM), max(MAXIORTM), max(MAXIOWTM) from v$filestat, dba_data_files df where file# = file_id AND df.tablespace_name = 'CDWBASE' AND df.status = 'AVAILABLE'
78697ky4qp7d0	select df.BYTES, f.PHYRDS, f.PHYWRTS, f.PHYBLKRD, f.PHYBLKWRT, f.READTIM, f.WRITETIM, f.MAXIORTM, f.MAXIOWTM from v$filestat f, dba_data_files df where f.file# = df.file_id AND df.tablespace_name = 'UNDOTBS1' AND df.file_name = 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\UNDOTBS01.DBF'
7hq9v8w273ufm	select df.BYTES, f.PHYRDS, f.PHYWRTS, f.PHYBLKRD, f.PHYBLKWRT, f.READTIM, f.WRITETIM, f.MAXIORTM, f.MAXIOWTM from v$filestat f, dba_data_files df where f.file# = df.file_id AND df.tablespace_name = 'SYSTEM' AND df.file_name = 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\SYSTEM01.DBF'
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
83hvvbwhbza8p	select sum(PHYRDS), sum(PHYWRTS), sum(PHYBLKRD), sum(PHYBLKWRT), max(READTIM), max(WRITETIM), max(MAXIORTM), max(MAXIOWTM) from v$filestat, dba_data_files df where file# = file_id AND df.tablespace_name = 'CDWAUDIT' AND df.status = 'AVAILABLE'
84qubbrsr0kfn	insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
85y5h00qub4uu	select df.BYTES, f.PHYRDS, f.PHYWRTS, f.PHYBLKRD, f.PHYBLKWRT, f.READTIM, f.WRITETIM, f.MAXIORTM, f.MAXIOWTM from v$filestat f, dba_data_files df where f.file# = df.file_id AND df.tablespace_name = 'CDWBASE' AND df.file_name = 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\CDWBASE.DBF'
8a1pvy4cy8hgv	insert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue) values(:1, :2, :3, :4, :5, :6, :7)
8bmx9xzmx4uqk	SELECT OWNER, SEGMENT_NAME, PARTITION_NAME, SEGMENT_TYPE, TABLESPACE_NAME, TABLESPACE_ID FROM SYS_DBA_SEGS WHERE SEGMENT_OBJD = :B1 AND SEGMENT_TYPE <> 'ROLLBACK' AND SEGMENT_TYPE <> 'TYPE2 UNDO' AND SEGMENT_TYPE <> 'DEFERRED ROLLBACK' AND SEGMENT_TYPE <> 'TEMPORARY' AND SEGMENT_TYPE <> 'CACHE' AND SEGMENT_TYPE <> 'SPACE HEADER' AND SEGMENT_TYPE <> 'UNDEFINED'
8gwdpj59m45xy	select sum(PHYRDS), sum(PHYWRTS), sum(PHYBLKRD), sum(PHYBLKWRT), max(READTIM), max(WRITETIM), max(MAXIORTM), max(MAXIOWTM) from v$filestat, dba_data_files df where file# = file_id AND df.tablespace_name = 'CDWANALYSE' AND df.status = 'AVAILABLE'
8hd36umbhpgsz	select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags from partobj$ where obj# = :1
8szmwam7fysa3	insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
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
97atfwpaz1c1n	select df.BYTES, f.PHYRDS, f.PHYWRTS, f.PHYBLKRD, f.PHYBLKWRT, f.READTIM, f.WRITETIM, f.MAXIORTM, f.MAXIOWTM from v$filestat f, dba_data_files df where f.file# = df.file_id AND df.tablespace_name = 'SYSAUX' AND df.file_name = 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\SYSAUX01.DBF'
b5cr4hhndmbuf	update tab$ set ts#=:2, file#=:3, block#=:4, bobj#=decode(:5, 0, null, :5), tab#=decode(:6, 0, null, :6), intcols=:7, kernelcols=:8, clucols=decode(:9, 0, null, :9), audit$=:10, flags=:11, pctfree$=:12, pctused$=:13, initrans=:14, maxtrans=:15, rowcnt=:16, blkcnt=:17, empcnt=:18, avgspc=:19, chncnt=:20, avgrln=:21, analyzetime=:22, samplesize=:23, cols=:24, property=:25, degree=decode(:26, 1, null, :26), instances=decode(:27, 1, null, :27), dataobj#=:28, avgspc_flb=:29, flbcnt=:30, trigflag=:31, spare1=:32, spare2=decode(:33, 0, null, :33), spare4=:34, spare6=:35 where obj#=:1
b61ssw3akk8wh	select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("IRREGLONGMETHOD"), count(distinct "IRREGLONGMETHOD"), substrb(dump(min("IRREGLONGMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("IRREGLONGMETHOD"), 16, 0, 32), 1, 120), count("ISSUEDATE"), count(distinct "ISSUEDATE"), substrb(dump(min("ISSUEDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ISSUEDATE"), 16, 0, 32), 1, 120), count("LASTUPDATEDACTION"), count(distinct "LASTUPDATEDACTION"), substrb(dump(min("LASTUPDATEDACTION"), 16, 0, 32), 1, 120), substrb(dump(max("LASTUPDATEDACTION"), 16, 0, 32), 1, 120), count("LASTUPDATEDDETAILSUSER"), count(distinct "LASTUPDATEDDETAILSUSER"), sum(sys_op_opnsize("LASTUPDATEDDETAILSUSER")), substrb(dump(min("LASTUPDATEDDETAILSUSER"), 16, 0, 32), 1, 120), substrb(dump(max("LASTUPDATEDDETAILSUSER"), 16, 0, 32), 1, 120), count("LASTUPDATEDTIMESTAMP"), count(distinct "LASTUPDATEDTIMESTAMP"), substrb(dump(min("LASTUPDATEDTIMESTAMP"), 16, 0, 32), 1, 120), substrb(dump(max("LASTUPDATEDTIMESTAMP"), 16, 0, 32), 1, 120), count("LINKEDSECURITY"), count(distinct "LINKEDSECURITY"), substrb(dump(min("LINKEDSECURITY"), 16, 0, 32), 1, 120), substrb(dump(max("LINKEDSECURI TY"), 16, 0, 32), 1, 120), count("LOANTYPE"), count(distinct "LOANTYPE"), substrb(dump(min("LOANTYPE"), 16, 0, 32), 1, 120), substrb(dump(max("LOANTYPE"), 16, 0, 32), 1, 120), count("MATURITYDATE"), count(distinct "MATURITYDATE"), substrb(dump(min("MATURITYDATE"), 16, 0, 32), 1, 120), substrb(dump(max("MATURITYDATE"), 16, 0, 32), 1, 120), count("MORTGAGETYPE"), count(distinct "MORTGAGETYPE"), substrb(dump(min("MORTGAGETYPE"), 16, 0, 32), 1, 120), substrb(dump(max("MORTGAGETYPE"), 16, 0, 32), 1, 120), count("NAICCLASS1MUTBOND"), count(distinct "NAICCLASS1MUTBOND"), sum(sys_op_opnsize("NAICCLASS1MUTBOND")), substrb(dump(min("NAICCLASS1MUTBOND"), 16, 0, 32), 1, 120), substrb(dump(max("NAICCLASS1MUTBOND"), 16, 0, 32), 1, 120), count("NAICINDEFAULT"), count(distinct "NAICINDEFAULT"), sum(sys_op_opnsize("NAICINDEFAULT")), substrb(dump(min("NAICINDEFAULT"), 16, 0, 32), 1, 120), substrb(dump(max("NAICINDEFAULT"), 16, 0, 32), 1, 120), count("NAICPREFERRED"), count(distinct "NAICPREFERRED"), sum(sys_op_opnsize("NAICPREFERRED")), substrb(dump(min("NAICPREFERRED"), 16, 0, 32), 1, 120), substrb(dump(max("NAICPREFERRED"), 16, 0, 32), 1, 120), count("NAICPRINCIPAL"), count(distinct "NAICPRINCIPAL"), s ubstrb(dump(min("NAICPRINCIPAL"), 16, 0, 32), 1, 120), substrb(dump(max("NAICPRINCIPAL"), 16, 0, 32), 1, 120), count("NAICPRIVATEPLACEMENT"), count(distinct "NAICPRIVATEPLACEMENT"), sum(sys_op_opnsize("NAICPRIVATEPLACEMENT")), substrb(dump(min("NAICPRIVATEPLACEMENT"), 16, 0, 32), 1, 120), substrb(dump(max("NAICPRIVATEPLACEMENT"), 16, 0, 32), 1, 120), count("NAICRESTRICTIONCLASS"), count(distinct "NAICRESTRICTIONCLASS"), substrb(dump(min("NAICRESTRICTIONCLASS"), 16, 0, 32), 1, 120), substrb(dump(max("NAICRESTRICTIONCLASS"), 16, 0, 32), 1, 120), count("NAICSCHEDULEDCLASS"), count(distinct "NAICSCHEDULEDCLASS"), substrb(dump(min("NAICSCHEDULEDCLASS"), 16, 0, 32), 1, 120), substrb(dump(max("NAICSCHEDULEDCLASS"), 16, 0, 32), 1, 120), count("NAICSCHEDULEDCLASSDESC"), count(distinct "NAICSCHEDULEDCLASSDESC"), substrb(dump(min("NAICSCHEDULEDCLASSDESC"), 16, 0, 32), 1, 120), substrb(dump(max("NAICSCHEDULEDCLASSDESC"), 16, 0, 32), 1, 120), count("NAICSTATETERRITORY"), count(distinct "NAICSTATETERRITORY"), substrb(dump(min("NAICSTATETERRITORY"), 16, 0, 32), 1, 120), substrb(dump(max("NAICSTATETERRITORY"), 16, 0, 32), 1, 120), count(distinct "NAME"), substrb(dump(min("NAME"), 16, 0, 32), 1, 120), substrb(dump(max("NAME"), 16, 0, 32) , 1, 120), count("NETTANGIBLEASSETS"), count(distinct "NETTANGIBLEASSETS"), sum(sys_op_opnsize("NETTANGIBLEASSETS")), substrb(dump(min("NETTANGIBLEASSETS"), 16, 0, 32), 1, 120), substrb(dump(max("NETTANGIBLEASSETS"), 16, 0, 32), 1, 120), count("NEXTCAPEVENTDATE"), count(distinct "NEXTCAPEVENTDATE"), substrb(dump(min("NEXTCAPEVENTDATE"), 16, 0, 32), 1, 120), substrb(dump(max("NEXTCAPEVENTDATE"), 16, 0, 32), 1, 120), count("NEXTDATE"), count(distinct "NEXTDATE"), substrb(dump(min("NEXTDATE"), 16, 0, 32), 1, 120), substrb(dump(max("NEXTDATE"), 16, 0, 32), 1, 120), count("NZPIEALLOCATEDINCOMEMETHOD"), count(distinct "NZPIEALLOCATEDINCOMEMETHOD"), sum(sys_op_opnsize("NZPIEALLOCATEDINCOMEMETHOD")), substrb(dump(min("NZPIEALLOCATEDINCOMEMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("NZPIEALLOCATEDINCOMEMETHOD"), 16, 0, 32), 1, 120), count("NZPIEATTIBUTIONFREQUENCY"), count(distinct "NZPIEATTIBUTIONFREQUENCY"), sum(sys_op_opnsize("NZPIEATTIBUTIONFREQUENCY")), substrb(dump(min("NZPIEATTIBUTIONFREQUENCY"), 16, 0, 32), 1, 120), substrb(dump(max("NZPIEATTIBUTIONFREQUENCY"), 16, 0, 32), 1, 120), count("NZPIEDEEMEDDIVIDENDFLAG"), count(distinct "NZPIEDEEMEDDIVIDENDFLAG"), sum(sys_op_opnsize("NZPIEDEEMEDDIVIDENDFLAG")), substrb(dump( min("NZPIEDEEMEDDIVIDENDFLAG"), 16, 0, 32), 1, 120), substrb(dump(max("NZPIEDEEMEDDIVIDENDFLAG"), 16, 0, 32), 1, 120), count("NZPIEFLAG"), count(distinct "NZPIEFLAG"), sum(sys_op_opnsize("NZPIEFLAG")), substrb(dump(min("NZPIEFLAG"), 16, 0, 32), 1, 120), substrb(dump(max("NZPIEFLAG"), 16, 0, 32), 1, 120), count("NZPIELISTEDFLAG"), count(distinct "NZPIELISTEDFLAG"), sum(sys_op_opnsize("NZPIELISTEDFLAG")), substrb(dump(min("NZPIELISTEDFLAG"), 16, 0, 32), 1, 120), substrb(dump(max("NZPIELISTEDFLAG"), 16, 0, 32), 1, 120), count("ORIGAVGCOUPON"), count(distinct "ORIGAVGCOUPON"), sum(sys_op_opnsize("ORIGAVGCOUPON")), substrb(dump(min("ORIGAVGCOUPON"), 16, 0, 32), 1, 120), substrb(dump(max("ORIGAVGCOUPON"), 16, 0, 32), 1, 120), count("ORIGAVGMAT"), count(distinct "ORIGAVGMAT"), sum(sys_op_opnsize("ORIGAVGMAT")), substrb(dump(min("ORIGAVGMAT"), 16, 0, 32), 1, 120), substrb(dump(max("ORIGAVGMAT"), 16, 0, 32), 1, 120), count("ORIGINALISSUEDISCOUNT"), count(distinct "ORIGINALISSUEDISCOUNT"), sum(sys_op_opnsize("ORIGINALISSUEDISCOUNT")), substrb(dump(min("ORIGINALISSUEDISCOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("ORIGINALISSUEDISCOUNT"), 16, 0, 32), 1, 120), count("PAYABLESECURITYCODE"), count(distinct " PAYABLESECURITYCODE"), substrb(dump(min("PAYABLESECURITYCODE"), 16, 0, 32), 1, 120), substrb(dump(max("PAYABLESECURITYCODE"), 16, 0, 32), 1, 120), count("PAYERRECEIVER"), count(distinct "PAYERRECEIVER"), count("PREPAIDTAX"), count(distinct "PREPAIDTAX"), sum(sys_op_opnsize("PREPAIDTAX")), substrb(dump(min("PREPAIDTAX"), 16, 0, 32), 1, 120), substrb(dump(max("PREPAIDTAX"), 16, 0, 32), 1, 120), count("PRIMEFAMILYSECTOR"), count(distinct "PRIMEFAMILYSECTOR"), substrb(dump(min("PRIMEFAMILYSECTOR"), 16, 0, 32), 1, 120), substrb(dump(max("PRIMEFAMILYSECTOR"), 16, 0, 32), 1, 120), count("RATETYPE"), count(distinct "RATETYPE"), substrb(dump(min("RATETYPE"), 16, 0, 32), 1, 120), substrb(dump(max("RATETYPE"), 16, 0, 32), 1, 120), count("RECEIVABLESECURITYCODE"), count(distinct "RECEIVABLESECURITYCODE"), substrb(dump(min("RECEIVABLESECURITYCODE"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIVABLESECURITYCODE"), 16, 0, 32), 1, 120), count("REPOROUNDING"), count(distinct "REPOROUNDING"), substrb(dump(min("REPOROUNDING"), 16, 0, 32), 1, 120), substrb(dump(max("REPOROUNDING"), 16, 0, 32), 1, 120), count("REPORTGROUP"), count(distinct "REPORTGROUP"), sum(sys_op_opnsize("REPORTGROUP")), count("REPOTYPE" ), count(distinct "REPOTYPE"), substrb(dump(min("REPOTYPE"), 16, 0, 32), 1, 120), substrb(dump(max("REPOTYPE"), 16, 0, 32), 1, 120), count("SADISCTAX"), count(distinct "SADISCTAX"), sum(sys_op_opnsize("SADISCTAX")), substrb(dump(min("SADISCTAX"), 16, 0, 32), 1, 120), substrb(dump(max("SADISCTAX"), 16, 0, 32), 1, 120), count("SAEXERSEC9B"), count(distinct "SAEXERSEC9B"), sum(sys_op_opnsize("SAEXERSEC9B")), substrb(dump(min("SAEXERSEC9B"), 16, 0, 32), 1, 120), substrb(dump(max("SAEXERSEC9B"), 16, 0, 32), 1, 120), count("SAFINSERVLEVY"), count(distinct "SAFINSERVLEVY"), sum(sys_op_opnsize("SAFINSERVLEVY")), substrb(dump(min("SAFINSERVLEVY"), 16, 0, 32), 1, 120), substrb(dump(max("SAFINSERVLEVY"), 16, 0, 32), 1, 120), count("SAINCCACCTAX"), count(distinct "SAINCCACCTAX"), sum(sys_op_opnsize("SAINCCACCTAX")), substrb(dump(min("SAINCCACCTAX"), 16, 0, 32), 1, 120), substrb(dump(max("SAINCCACCTAX"), 16, 0, 32), 1, 120), count("SAINCOMETAX"), count(distinct "SAINCOMETAX"), sum(sys_op_opnsize("SAINCOMETAX")), substrb(dump(min("SAINCOMETAX"), 16, 0, 32), 1, 120), substrb(dump(max("SAINCOMETAX"), 16, 0, 32), 1, 120), count("SARETFUNDTAX"), count(distinct "SARETFUNDTAX"), sum(sys_op_opnsize(&qu ot;SARETFUNDTAX")), substrb(dump(min("SARETFUNDTAX"), 16, 0, 32), 1, 120), substrb(dump(max("SARETFUNDTAX"), 16, 0, 32), 1, 120), count("SARSCLEVY"), count(distinct "SARSCLEVY"), sum(sys_op_opnsize("SARSCLEVY")), substrb(dump(min("SARSCLEVY"), 16, 0, 32), 1, 120), substrb(dump(max("SARSCLEVY"), 16, 0, 32), 1, 120), count("SARSCREGIONCODE"), count(distinct "SARSCREGIONCODE"), substrb(dump(min("SARSCREGIONCODE"), 16, 0, 32), 1, 120), substrb(dump(max("SARSCREGIONCODE"), 16, 0, 32), 1, 120), count("SCREENINGFLAG1"), count(distinct "SCREENINGFLAG1"), sum(sys_op_opnsize("SCREENINGFLAG1")), substrb(dump(min("SCREENINGFLAG1"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG1"), 16, 0, 32), 1, 120), count("SCREENINGFLAG10"), count(distinct "SCREENINGFLAG10"), sum(sys_op_opnsize("SCREENINGFLAG10")), substrb(dump(min("SCREENINGFLAG10"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG10"), 16, 0, 32), 1, 120), count("SCREENINGFLAG11"), count(distinct "SCREENINGFLAG11"), sum(sys_op_opnsize("SCREENINGFLAG11")), substrb(dump(min("SCREENINGFLAG11"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG11"), 16, 0, 32), 1, 120), count("SCREENINGFLAG12"), count(distinct "SCREENINGFLAG12"), sum(sys_op_opn size("SCREENINGFLAG12")), substrb(dump(min("SCREENINGFLAG12"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG12"), 16, 0, 32), 1, 120), count("SCREENINGFLAG13"), count(distinct "SCREENINGFLAG13"), sum(sys_op_opnsize("SCREENINGFLAG13")), substrb(dump(min("SCREENINGFLAG13"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG13"), 16, 0, 32), 1, 120), count("SCREENINGFLAG14"), count(distinct "SCREENINGFLAG14"), sum(sys_op_opnsize("SCREENINGFLAG14")), substrb(dump(min("SCREENINGFLAG14"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG14"), 16, 0, 32), 1, 120), count("SCREENINGFLAG15"), count(distinct "SCREENINGFLAG15"), sum(sys_op_opnsize("SCREENINGFLAG15")), substrb(dump(min("SCREENINGFLAG15"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG15"), 16, 0, 32), 1, 120), count("SCREENINGFLAG16"), count(distinct "SCREENINGFLAG16"), sum(sys_op_opnsize("SCREENINGFLAG16")), substrb(dump(min("SCREENINGFLAG16"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG16"), 16, 0, 32), 1, 120), count("SCREENINGFLAG17"), count(distinct "SCREENINGFLAG17"), sum(sys_op_opnsize("SCREENINGFLAG17")), substrb(dump(min("SCREENINGFLAG17"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG17"), 16, 0, 32), 1, 120), count("SCREENINGFLAG18"), count(distinct "SCREENINGFLAG18"), sum(sys_op_opnsize("SCREENINGFLAG18")), substrb(dump(min("SCREENINGFLAG18"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG18"), 16, 0, 32), 1, 120), count("SCREENINGFLAG19"), count(distinct "SCREENINGFLAG19"), sum(sys_op_opnsize("SCREENINGFLAG19")), substrb(dump(min("SCREENINGFLAG19"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG19"), 16, 0, 32), 1, 120), count("SCREENINGFLAG2"), count(distinct "SCREENINGFLAG2"), sum(sys_op_opnsize("SCREENINGFLAG2")), substrb(dump(min("SCREENINGFLAG2"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG2"), 16, 0, 32), 1, 120), count("SCREENINGFLAG20"), count(distinct "SCREENINGFLAG20"), sum(sys_op_opnsize("SCREENINGFLAG20")), substrb(dump(min("SCREENINGFLAG20"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG20"), 16, 0, 32), 1, 120), count("SCREENINGFLAG21"), count(distinct "SCREENINGFLAG21"), sum(sys_op_opnsize("SCREENINGFLAG21")), substrb(dump(min("SCREENINGFLAG21"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG21"), 16, 0, 32), 1, 120), count("SCREENINGFLAG22"), count(distinct "SCREENINGFLAG22"), sum(sys_op_opnsize("SCREENINGFLAG22")), substrb(dump(min("SCREENING FLAG22"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG22"), 16, 0, 32), 1, 120), count("SCREENINGFLAG23"), count(distinct "SCREENINGFLAG23"), sum(sys_op_opnsize("SCREENINGFLAG23")), substrb(dump(min("SCREENINGFLAG23"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG23"), 16, 0, 32), 1, 120), count("SCREENINGFLAG24"), count(distinct "SCREENINGFLAG24"), sum(sys_op_opnsize("SCREENINGFLAG24")), substrb(dump(min("SCREENINGFLAG24"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG24"), 16, 0, 32), 1, 120), count("SCREENINGFLAG3"), count(distinct "SCREENINGFLAG3"), sum(sys_op_opnsize("SCREENINGFLAG3")), substrb(dump(min("SCREENINGFLAG3"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG3"), 16, 0, 32), 1, 120), count("SCREENINGFLAG4"), count(distinct "SCREENINGFLAG4"), sum(sys_op_opnsize("SCREENINGFLAG4")), substrb(dump(min("SCREENINGFLAG4"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG4"), 16, 0, 32), 1, 120), count("SCREENINGFLAG5"), count(distinct "SCREENINGFLAG5"), sum(sys_op_opnsize("SCREENINGFLAG5")), substrb(dump(min("SCREENINGFLAG5"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG5"), 16, 0, 32), 1, 120), count("SCREENINGFLAG6"), count(distinct "SCREENINGFLAG6" ), sum(sys_op_opnsize("SCREENINGFLAG6")), substrb(dump(min("SCREENINGFLAG6"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG6"), 16, 0, 32), 1, 120), count("SCREENINGFLAG7"), count(distinct "SCREENINGFLAG7"), sum(sys_op_opnsize("SCREENINGFLAG7")), substrb(dump(min("SCREENINGFLAG7"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG7"), 16, 0, 32), 1, 120), count("SCREENINGFLAG8"), count(distinct "SCREENINGFLAG8"), sum(sys_op_opnsize("SCREENINGFLAG8")), substrb(dump(min("SCREENINGFLAG8"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG8"), 16, 0, 32), 1, 120), count("SCREENINGFLAG9"), count(distinct "SCREENINGFLAG9"), sum(sys_op_opnsize("SCREENINGFLAG9")), substrb(dump(min("SCREENINGFLAG9"), 16, 0, 32), 1, 120), substrb(dump(max("SCREENINGFLAG9"), 16, 0, 32), 1, 120), count("SINKINGFUND"), count(distinct "SINKINGFUND"), sum(sys_op_opnsize("SINKINGFUND")), substrb(dump(min("SINKINGFUND"), 16, 0, 32), 1, 120), substrb(dump(max("SINKINGFUND"), 16, 0, 32), 1, 120), count("SINKINGFUNDSCHEDULE"), count(distinct "SINKINGFUNDSCHEDULE"), substrb(dump(min("SINKINGFUNDSCHEDULE"), 16, 0, 32), 1, 120), substrb(dump(max("SINKINGFUNDSCHEDULE"), 16, 0, 32), 1, 120), count("SPECIFICDATE"), count(distinct "SPECIFICDATE"), substrb(dump(min("SPECIFICDATE"), 16, 0, 32), 1, 120), substrb(dump(max("SPECIFICDATE"), 16, 0, 32), 1, 120), count("SPECIFICDATEPRICE"), count(distinct "SPECIFICDATEPRICE"), sum(sys_op_opnsize("SPECIFICDATEPRICE")), substrb(dump(min("SPECIFICDATEPRICE"), 16, 0, 32), 1, 120), substrb(dump(max("SPECIFICDATEPRICE"), 16, 0, 32), 1, 120), count(distinct "SUBTYPE"), sum(sys_op_opnsize("SUBTYPE")), count("TAXCURRENCYCODE"), count(distinct "TAXCURRENCYCODE"), substrb(dump(min("TAXCURRENCYCODE"), 16, 0, 32), 1, 120), substrb(dump(max("TAXCURRENCYCODE"), 16, 0, 32), 1, 120), count("TRADEMETHOD"), count(distinct "TRADEMETHOD"), substrb(dump(min("TRADEMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("TRADEMETHOD"), 16, 0, 32), 1, 120), count("TRADEREDUCED"), count(distinct "TRADEREDUCED"), sum(sys_op_opnsize("TRADEREDUCED")), substrb(dump(min("TRADEREDUCED"), 16, 0, 32), 1, 120), substrb(dump(max("TRADEREDUCED"), 16, 0, 32), 1, 120), count("TRANCHEDATE"), count(distinct "TRANCHEDATE"), substrb(dump(min("TRANCHEDATE"), 16, 0, 32), 1, 120), substrb(dump(max("TRANCHEDATE"), 16, 0, 32), 1, 120), count("TRANCHETYPE"), count(distinct "TRANCHETYPE"), substrb(dump(min("TRANCHETYPE"), 16, 0, 32), 1, 120), substrb(dump(max("TRANCHETYPE"), 16, 0, 32), 1, 120), count("UKCGTLIABLE"), count(distinct "UKCGTLIABLE"), substrb(dump(min("UKCGTLIABLE"), 16, 0, 32), 1, 120), substrb(dump(max("UKCGTLIABLE"), 16, 0, 32), 1, 120), count("UNITTRUSTPORTFOLIOCODE"), count(distinct "UNITTRUSTPORTFOLIOCODE"), substrb(dump(min("UNITTRUSTPORTFOLIOCODE"), 16, 0, 32), 1, 120), substrb(dump(max("UNITTRUSTPORTFOLIOCODE"), 16, 0, 32), 1, 120), count("USTAXEXEMPT"), count(distinct "USTAXEXEMPT"), substrb(dump(min("USTAXEXEMPT"), 16, 0, 32), 1, 120), substrb(dump(max("USTAXEXEMPT"), 16, 0, 32), 1, 120), count("YIELDTOOPTION"), count(distinct "YIELDTOOPTION"), sum(sys_op_opnsize("YIELDTOOPTION")), substrb(dump(min("YIELDTOOPTION"), 16, 0, 32), 1, 120), substrb(dump(max("YIELDTOOPTION"), 16, 0, 32), 1, 120), count("ZACAMORTCOLLAR"), count(distinct "ZACAMORTCOLLAR"), substrb(dump(min("ZACAMORTCOLLAR"), 16, 0, 32), 1, 120), substrb(dump(max("ZACAMORTCOLLAR"), 16, 0, 32), 1, 120), count("ZACAMORTMETHOD"), count(distinct "ZACAMORTMETHOD"), substrb(dump(min("ZACAMORTMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZACAMORTMETHOD"), 16, 0, 32), 1, 120), count("ZACCOSTREDMETHOD"), count(distinct "ZACCOSTREDMETHOD"), su bstrb(dump(min("ZACCOSTREDMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZACCOSTREDMETHOD"), 16, 0, 32), 1, 120), count("ZACINDEXVALMETHOD"), count(distinct "ZACINDEXVALMETHOD"), substrb(dump(min("ZACINDEXVALMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZACINDEXVALMETHOD"), 16, 0, 32), 1, 120), count("ZACSPECIFICDATEAMORT"), count(distinct "ZACSPECIFICDATEAMORT"), sum(sys_op_opnsize("ZACSPECIFICDATEAMORT")), substrb(dump(min("ZACSPECIFICDATEAMORT"), 16, 0, 32), 1, 120), substrb(dump(max("ZACSPECIFICDATEAMORT"), 16, 0, 32), 1, 120), count("ZAIACCRATEMETHOD"), count(distinct "ZAIACCRATEMETHOD"), substrb(dump(min("ZAIACCRATEMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZAIACCRATEMETHOD"), 16, 0, 32), 1, 120), count("ZAIACCRUEDCALC"), count(distinct "ZAIACCRUEDCALC"), substrb(dump(min("ZAIACCRUEDCALC"), 16, 0, 32), 1, 120), substrb(dump(max("ZAIACCRUEDCALC"), 16, 0, 32), 1, 120), count("ZAIACCRUEDINTCALCSOURCE"), count(distinct "ZAIACCRUEDINTCALCSOURCE"), substrb(dump(min("ZAIACCRUEDINTCALCSOURCE"), 16, 0, 32), 1, 120), substrb(dump(max("ZAIACCRUEDINTCALCSOURCE"), 16, 0, 32), 1, 120), count("ZAIACCRUEFROMDATE"), count(distinct "ZAIACCRUEFROMDATE"), substrb(dump(min("ZAIACCRUEFROMDATE"), 16, 0, 32), 1, 120), substrb(d ump(max("ZAIACCRUEFROMDATE"), 16, 0, 32), 1, 120), count("ZAIFIXEDDAYSINMONTH"), count(distinct "ZAIFIXEDDAYSINMONTH"), sum(sys_op_opnsize("ZAIFIXEDDAYSINMONTH")), substrb(dump(min("ZAIFIXEDDAYSINMONTH"), 16, 0, 32), 1, 120), substrb(dump(max("ZAIFIXEDDAYSINMONTH"), 16, 0, 32), 1, 120), count("ZAIFIXEDDAYSINYEAR"), count(distinct "ZAIFIXEDDAYSINYEAR"), sum(sys_op_opnsize("ZAIFIXEDDAYSINYEAR")), substrb(dump(min("ZAIFIXEDDAYSINYEAR"), 16, 0, 32), 1, 120), substrb(dump(max("ZAIFIXEDDAYSINYEAR"), 16, 0, 32), 1, 120), count("ZAIPARINEX"), count(distinct "ZAIPARINEX"), substrb(dump(min("ZAIPARINEX"), 16, 0, 32), 1, 120), substrb(dump(max("ZAIPARINEX"), 16, 0, 32), 1, 120), count("ZAIREPOACCRUAL"), count(distinct "ZAIREPOACCRUAL"), substrb(dump(min("ZAIREPOACCRUAL"), 16, 0, 32), 1, 120), substrb(dump(max("ZAIREPOACCRUAL"), 16, 0, 32), 1, 120), count("ZAIROUNDACCRUED"), count(distinct "ZAIROUNDACCRUED"), sum(sys_op_opnsize("ZAIROUNDACCRUED")), substrb(dump(min("ZAIROUNDACCRUED"), 16, 0, 32), 1, 120), substrb(dump(max("ZAIROUNDACCRUED"), 16, 0, 32), 1, 120), count("ZAIVARBONDMETHOD"), count(distinct "ZAIVARBONDMETHOD"), substrb(dump(min("ZAIVARBONDMETHOD"), 16, 0, 32), 1, 120), substrb(dump(max("ZAIVARBONDMETHOD&q uot;), 16, 0, 32), 1, 120), count("ZBMFIRSTREDEMPTIONDATE"), count(distinct "ZBMFIRSTREDEMPTIONDATE"), substrb(dump(min("ZBMFIRSTREDEMPTIONDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZBMFIRSTREDEMPTIONDATE"), 16, 0, 32), 1, 120), count("ZBMNOTICEDAYS"), count(distinct "ZBMNOTICEDAYS"), sum(sys_op_opnsize("ZBMNOTICEDAYS")), substrb(dump(min("ZBMNOTICEDAYS"), 16, 0, 32), 1, 120), substrb(dump(max("ZBMNOTICEDAYS"), 16, 0, 32), 1, 120), count("ZBMPREREFUND"), count(distinct "ZBMPREREFUND"), sum(sys_op_opnsize("ZBMPREREFUND")), substrb(dump(min("ZBMPREREFUND"), 16, 0, 32), 1, 120), substrb(dump(max("ZBMPREREFUND"), 16, 0, 32), 1, 120), count("ZBMPREREFUNDINGPRICE"), count(distinct "ZBMPREREFUNDINGPRICE"), sum(sys_op_opnsize("ZBMPREREFUNDINGPRICE")), substrb(dump(min("ZBMPREREFUNDINGPRICE"), 16, 0, 32), 1, 120), substrb(dump(max("ZBMPREREFUNDINGPRICE"), 16, 0, 32), 1, 120), count("ZBMREALMATURITYDATE"), count(distinct "ZBMREALMATURITYDATE"), substrb(dump(min("ZBMREALMATURITYDATE"), 16, 0, 32), 1, 120), substrb(dump(max("ZBMREALMATURITYDATE"), 16, 0, 32), 1, 120), count("ZBMREDEEMABLE"), count(distinct "ZBMREDEEMABLE"), sum(sys_op_opnsize("ZBMREDEEMABLE")), substrb(dump(min("ZBMREDEEMABLE"), 16, 0, 32), 1, 120), su bstrb(dump(max("ZBMREDEEMABLE"), 16, 0, 32), 1, 120), count("ABSPAYMENTTYPE"), count(distinct "ABSPAYMENTTYPE"), substrb(dump(min("ABSPAYMENTTYPE"), 16, 0, 32), 1, 120), substrb(dump(max("ABSPAYMENTTYPE"), 16, 0, 32), 1, 120), count("ABSTYPE"), count(distinct "ABSTYPE"), substrb(dump(min("ABSTYPE"), 16, 0, 32), 1, 120), substrb(dump(max("ABSTYPE"), 16, 0, 32), 1, 120), count("ACTIVESECURITY"), count(distinct "ACTIVESECURITY"), sum(sys_op_opnsize("ACTIVESECURITY")), substrb(dump(min("ACTIVESECURITY"), 16, 0, 32), 1, 120), substrb(dump(max("ACTIVESECURITY"), 16, 0, 32), 1, 120), count("ADJUSTHOLIDAYS"), count(distinct "ADJUSTHOLIDAYS"), substrb(dump(min("ADJUSTHOLIDAYS"), 16, 0, 32), 1, 120), substrb(dump(max("ADJUSTHOLIDAYS"), 16, 0, 32), 1, 120), count("ADJUSTINTEREST"), count(distinct "ADJUSTINTEREST"), sum(sys_op_opnsize("ADJUSTINTEREST")), substrb(dump(min("ADJUSTINTEREST"), 16, 0, 32), 1, 120), substrb(dump(max("ADJUSTINTEREST"), 16, 0, 32), 1, 120), count("ADVANCEARREARS"), count(distinct "ADVANCEARREARS"), sum(sys_op_opnsize("ADVANCEARREARS")), substrb(dump(min("ADVANCEARREARS"), 16, 0, 32), 1, 120), substrb(dump(max("ADVANCEARREARS"), 16, 0, 32), 1, 120), count("BANKBILL"), count(dist inct "BANKBILL"), sum(sys_op_opnsize("BANKBILL")), substrb(dump(min("BANKBILL"), 16, 0, 32), 1, 120), substrb(dump(max("BANKBILL"), 16, 0, 32), 1, 120), count("CASHFLOWIMPORT"), count(distinct "CASHFLOWIMPORT"), sum(sys_op_opnsize("CASHFLOWIMPORT")), substrb(dump(min("CASHFLOWIMPORT"), 16, 0, 32), 1, 120), substrb(dump(max("CASHFLOWIMPORT"), 16, 0, 32), 1, 120), count(distinct "CATEGORY"), substrb(dump(min("CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("CATEGORY"), 16, 0, 32), 1, 120), count("CHECKCALENDAR"), count(distinct "CHECKCALENDAR"), sum(sys_op_opnsize("CHECKCALENDAR")), substrb(dump(min("CHECKCALENDAR"), 16, 0, 32), 1, 120), substrb(dump(max("CHECKCALENDAR"), 16, 0, 32), 1, 120), count("CNTYPE"), count(distinct "CNTYPE"), substrb(dump(min("CNTYPE"), 16, 0, 32), 1, 120), substrb(dump(max("CNTYPE"), 16, 0, 32), 1, 120), count(distinct "CODE"), count("COLLATERALTYPE"), count(distinct "COLLATERALTYPE"), substrb(dump(min("COLLATERALTYPE"), 16, 0, 32), 1, 120), substrb(dump(max("COLLATERALTYPE"), 16, 0, 32), 1, 120), count("COMMENTS"), count(distinct "COMMENTS"), substrb(dump(min("COMMENTS"), 16, 0, 32), 1, 120), substrb(dump(max("COMMENTS"), 16, 0, 32), 1, 120), count(" ;COMPLIANCEDECLARATION"), count(distinct "COMPLIANCEDECLARATION"), substrb(dump(min("COMPLIANCEDECLARATION"), 16, 0, 32), 1, 120), substrb(dump(max("COMPLIANCEDECLARATION"), 16, 0, 32), 1, 120), count("COUNTRY"), count(distinct "COUNTRY"), substrb(dump(min("COUNTRY"), 16, 0, 32), 1, 120), substrb(dump(max("COUNTRY"), 16, 0, 32), 1, 120), count("COUPONCALC"), count(distinct "COUPONCALC"), substrb(dump(min("COUPONCALC"), 16, 0, 32), 1, 120), substrb(dump(max("COUPONCALC"), 16, 0, 32), 1, 120), count("COUPONDATEVALUATION"), count(distinct "COUPONDATEVALUATION"), substrb(dump(min("COUPONDATEVALUATION"), 16, 0, 32), 1, 120), substrb(dump(max("COUPONDATEVALUATION"), 16, 0, 32), 1, 120), count("COUPONRATE"), count(distinct "COUPONRATE"), sum(sys_op_opnsize("COUPONRATE")), substrb(dump(min("COUPONRATE"), 16, 0, 32), 1, 120), substrb(dump(max("COUPONRATE"), 16, 0, 32), 1, 120), count("COUPONTYPE"), count(distinct "COUPONTYPE"), substrb(dump(min("COUPONTYPE"), 16, 0, 32), 1, 120), substrb(dump(max("COUPONTYPE"), 16, 0, 32), 1, 120), count("CREATIONDATE"), count(distinct "CREATIONDATE"), substrb(dump(min("CREATIONDATE"), 16, 0, 32), 1, 120), substrb(dump(max("CREATIONDATE"), 16, 0, 32), 1, 120), count(" ;CREATIONUSER"), count(distinct "CREATIONUSER"), sum(sys_op_opnsize("CREATIONUSER")), substrb(dump(min("CREATIONUSER"), 16, 0, 32), 1, 120), substrb(dump(max("CREATIONUSER"), 16, 0, 32), 1, 120), count("CREDITRATING"), count(distinct "CREDITRATING"), substrb(dump(min("CREDITRATING"), 16, 0, 32), 1, 120), substrb(dump(max("CREDITRATING"), 16, 0, 32), 1, 120), count("CURRENCYCODE"), count(distinct "CURRENCYCODE"), substrb(dump(min("CURRENCYCODE"), 16, 0, 32), 1, 120), substrb(dump(max("CURRENCYCODE"), 16, 0, 32), 1, 120), count(distinct "CUSIPCODE"), substrb(dump(min("CUSIPCODE"), 16, 0, 32), 1, 120), substrb(dump(max("CUSIPCODE"), 16, 0, 32), 1, 120), count("DAYSINMONTH"), count(distinct "DAYSINMONTH"), sum(sys_op_opnsize("DAYSINMONTH")), substrb(dump(min("DAYSINMONTH"), 16, 0, 32), 1, 120), substrb(dump(max("DAYSINMONTH"), 16, 0, 32), 1, 120), count("DAYSINYEAR"), count(distinct "DAYSINYEAR"), sum(sys_op_opnsize("DAYSINYEAR")), substrb(dump(min("DAYSINYEAR"), 16, 0, 32), 1, 120), substrb(dump(max("DAYSINYEAR"), 16, 0, 32), 1, 120), count("DIRECTDEPOSIT"), count(distinct "DIRECTDEPOSIT"), sum(sys_op_opnsize("DIRECTDEPOSIT")), substrb(dump(min("DIRECTDEPOSIT"), 16, 0, 32), 1, 120), substr b(dump(max("DIRECTDEPOSIT"), 16, 0, 32), 1, 120), count("DUTCHLOANTYPE"), count(distinct "DUTCHLOANTYPE"), sum(sys_op_opnsize("DUTCHLOANTYPE")), substrb(dump(min("DUTCHLOANTYPE"), 16, 0, 32), 1, 120), substrb(dump(max("DUTCHLOANTYPE"), 16, 0, 32), 1, 120), count("EARNINGSPERSHARE"), count(distinct "EARNINGSPERSHARE"), sum(sys_op_opnsize("EARNINGSPERSHARE")), substrb(dump(min("EARNINGSPERSHARE"), 16, 0, 32), 1, 120), substrb(dump(max("EARNINGSPERSHARE"), 16, 0, 32), 1, 120), count("EMBEDDEDOPTIONS"), count(distinct "EMBEDDEDOPTIONS"), sum(sys_op_opnsize("EMBEDDEDOPTIONS")), substrb(dump(min("EMBEDDEDOPTIONS"), 16, 0, 32), 1, 120), substrb(dump(max("EMBEDDEDOPTIONS"), 16, 0, 32), 1, 120), count("EUROCONVERTED"), count(distinct "EUROCONVERTED"), sum(sys_op_opnsize("EUROCONVERTED")), substrb(dump(min("EUROCONVERTED"), 16, 0, 32), 1, 120), substrb(dump(max("EUROCONVERTED"), 16, 0, 32), 1, 120), count("EXCHANGE"), count(distinct "EXCHANGE"), substrb(dump(min("EXCHANGE"), 16, 0, 32), 1, 120), substrb(dump(max("EXCHANGE"), 16, 0, 32), 1, 120), count("EXDATE"), count(distinct "EXDATE"), substrb(dump(min("EXDATE"), 16, 0, 32), 1, 120), substrb(dump(max("EXDATE"), 16, 0, 32), 1, 120), count("EXDAY S"), count(distinct "EXDAYS"), sum(sys_op_opnsize("EXDAYS")), substrb(dump(min("EXDAYS"), 16, 0, 32), 1, 120), substrb(dump(max("EXDAYS"), 16, 0, 32), 1, 120), count("EXTERNALADMINISTRATORCODE"), count(distinct "EXTERNALADMINISTRATORCODE"), substrb(dump(min("EXTERNALADMINISTRATORCODE"), 16, 0, 32), 1, 120), substrb(dump(max("EXTERNALADMINISTRATORCODE"), 16, 0, 32), 1, 120), count(distinct "EXTERNALCODE1"), count(distinct "EXTERNALCODE2"), substrb(dump(min("EXTERNALCODE2"), 16, 0, 32), 1, 120), substrb(dump(max("EXTERNALCODE2"), 16, 0, 32), 1, 120), count("FINEPERIOD"), count(distinct "FINEPERIOD"), sum(sys_op_opnsize("FINEPERIOD")), substrb(dump(min("FINEPERIOD"), 16, 0, 32), 1, 120), substrb(dump(max("FINEPERIOD"), 16, 0, 32), 1, 120), count("FINERATE"), count(distinct "FINERATE"), sum(sys_op_opnsize("FINERATE")), substrb(dump(min("FINERATE"), 16, 0, 32), 1, 120), substrb(dump(max("FINERATE"), 16, 0, 32), 1, 120), count("FIXEDFLOATING"), count(distinct "FIXEDFLOATING"), sum(sys_op_opnsize("FIXEDFLOATING")), substrb(dump(min("FIXEDFLOATING"), 16, 0, 32), 1, 120), substrb(dump(max("FIXEDFLOATING"), 16, 0, 32), 1, 120) from "CDWBASE"."T07_HIP_SECURITY" t
b6usrg82hwsa3	call dbms_stats.gather_database_stats_job_proc ( )
bd13sdj0ty0q4	SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJECT_TYPE = 'TABLE'
bgv9jgzru7uvm	SELECT SID, DECODE(BLOCK, 0, 'NO', 'YES' ) BLOCKER, DECODE(REQUEST, 0, 'NO', 'YES' ) WAITER FROM V$LOCK WHERE REQUEST > 0 OR BLOCK > 0 ORDER BY block DESC
bsa0wjtftg3uw	select file# from file$ where ts#=:1
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
c2fra60nkantf	select df.BYTES, f.PHYRDS, f.PHYWRTS, f.PHYBLKRD, f.PHYBLKWRT, f.READTIM, f.WRITETIM, f.MAXIORTM, f.MAXIOWTM from v$filestat f, dba_data_files df where f.file# = df.file_id AND df.tablespace_name = 'JIANKONG' AND df.file_name = 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\JIANKONG01.DBF'
c9vs68pbjptu1	update ind$ set ts#=:2, file#=:3, block#=:4, intcols=:5, type#=:6, flags=:7, property=:8, pctfree$=:9, initrans=:10, maxtrans=:11, blevel=:12, leafcnt=:13, distkey=:14, lblkkey=:15, dblkkey=:16, clufac=:17, cols=:18, analyzetime=:19, samplesize=:20, dataobj#=:21, degree=decode(:22, 1, null, :22), instances=decode(:23, 1, null, :23), rowcnt=:24, pctthres$=:31*256+:25, indmethod#=:26, trunccnt=:27, spare1=:28, spare4=:29, spare2=:30, spare6=:32where obj#=:1
cbdfcfcp1pgtp	select intcol#, col# , type#, spare1, segcol#, charsetform from partcol$ where obj# = :1 order by pos#
cqjwytk1ghamg	select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("ROWS_PROCESSED_DELTA"), count(distinct "ROWS_PROCESSED_DELTA"), sum(sys_op_opnsize("ROWS_PROCESSED_DELTA")), substrb(dump(min("ROWS_PROCESSED_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("ROWS_PROCESSED_DELTA"), 16, 0, 32), 1, 120), count("CPU_TIME_TOTAL"), count(distinct "CPU_TIME_TOTAL"), sum(sys_op_opnsize("CPU_TIME_TOTAL")), substrb(dump(min("CPU_TIME_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("CPU_TIME_TOTAL"), 16, 0, 32), 1, 120), count("CPU_TIME_DELTA"), count(distinct "CPU_TIME_DELTA"), sum(sys_op_opnsize("CPU_TIME_DELTA")), substrb(dump(min("CPU_TIME_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("CPU_TIME_DELTA"), 16, 0, 32), 1, 120), count("ELAPSED_TIME_TOTAL"), count(distinct "ELAPSED_TIME_TOTAL"), sum(sys_op_opnsize("ELAPSED_TIME_TOTAL")), substrb(dump(min("ELAPSED_TIME_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("ELAPSED_TIME_TOTAL"), 16, 0, 32), 1, 120), count("ELAPSED_TIME_DELTA"), count(distinct "ELAPSED_TIME_DELTA"), sum(sys_op_opnsize("ELAPSED_TIME_DELTA")), substrb(dump(min("ELAPSED_TIME_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("ELAPSED_TIME_DELTA" ;), 16, 0, 32), 1, 120), count("IOWAIT_TOTAL"), count(distinct "IOWAIT_TOTAL"), sum(sys_op_opnsize("IOWAIT_TOTAL")), substrb(dump(min("IOWAIT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("IOWAIT_TOTAL"), 16, 0, 32), 1, 120), count("IOWAIT_DELTA"), count(distinct "IOWAIT_DELTA"), sum(sys_op_opnsize("IOWAIT_DELTA")), substrb(dump(min("IOWAIT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("IOWAIT_DELTA"), 16, 0, 32), 1, 120), count("CLWAIT_TOTAL"), count(distinct "CLWAIT_TOTAL"), sum(sys_op_opnsize("CLWAIT_TOTAL")), substrb(dump(min("CLWAIT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("CLWAIT_TOTAL"), 16, 0, 32), 1, 120), count("CLWAIT_DELTA"), count(distinct "CLWAIT_DELTA"), sum(sys_op_opnsize("CLWAIT_DELTA")), substrb(dump(min("CLWAIT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("CLWAIT_DELTA"), 16, 0, 32), 1, 120), count("APWAIT_TOTAL"), count(distinct "APWAIT_TOTAL"), sum(sys_op_opnsize("APWAIT_TOTAL")), substrb(dump(min("APWAIT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("APWAIT_TOTAL"), 16, 0, 32), 1, 120), count("APWAIT_DELTA"), count(distinct "APWAIT_DELTA"), sum(sys_op_opnsize("APWAIT_DELTA")), substrb(dump(min("APWAIT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("APWAI T_DELTA"), 16, 0, 32), 1, 120), count("CCWAIT_TOTAL"), count(distinct "CCWAIT_TOTAL"), sum(sys_op_opnsize("CCWAIT_TOTAL")), substrb(dump(min("CCWAIT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("CCWAIT_TOTAL"), 16, 0, 32), 1, 120), count("CCWAIT_DELTA"), count(distinct "CCWAIT_DELTA"), sum(sys_op_opnsize("CCWAIT_DELTA")), substrb(dump(min("CCWAIT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("CCWAIT_DELTA"), 16, 0, 32), 1, 120), count("DIRECT_WRITES_TOTAL"), count(distinct "DIRECT_WRITES_TOTAL"), sum(sys_op_opnsize("DIRECT_WRITES_TOTAL")), substrb(dump(min("DIRECT_WRITES_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("DIRECT_WRITES_TOTAL"), 16, 0, 32), 1, 120), count("DIRECT_WRITES_DELTA"), count(distinct "DIRECT_WRITES_DELTA"), sum(sys_op_opnsize("DIRECT_WRITES_DELTA")), substrb(dump(min("DIRECT_WRITES_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("DIRECT_WRITES_DELTA"), 16, 0, 32), 1, 120), count("PLSEXEC_TIME_TOTAL"), count(distinct "PLSEXEC_TIME_TOTAL"), sum(sys_op_opnsize("PLSEXEC_TIME_TOTAL")), substrb(dump(min("PLSEXEC_TIME_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("PLSEXEC_TIME_TOTAL"), 16, 0, 32), 1, 120), count("PLSEXEC_TIME_DELTA"), count(distinct "PLSEXEC_TIME_DELTA"), sum(sys_op_opnsi ze("PLSEXEC_TIME_DELTA")), substrb(dump(min("PLSEXEC_TIME_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("PLSEXEC_TIME_DELTA"), 16, 0, 32), 1, 120), count("JAVEXEC_TIME_TOTAL"), count(distinct "JAVEXEC_TIME_TOTAL"), sum(sys_op_opnsize("JAVEXEC_TIME_TOTAL")), substrb(dump(min("JAVEXEC_TIME_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("JAVEXEC_TIME_TOTAL"), 16, 0, 32), 1, 120), count("JAVEXEC_TIME_DELTA"), count(distinct "JAVEXEC_TIME_DELTA"), sum(sys_op_opnsize("JAVEXEC_TIME_DELTA")), substrb(dump(min("JAVEXEC_TIME_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("JAVEXEC_TIME_DELTA"), 16, 0, 32), 1, 120), count("BIND_DATA"), count(distinct "BIND_DATA"), sum(sys_op_opnsize("BIND_DATA")), substrb(dump(min(substrb("BIND_DATA", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("BIND_DATA", 1, 32)), 16, 0, 32), 1, 120), count("FLAG"), count(distinct "FLAG"), sum(sys_op_opnsize("FLAG")), substrb(dump(min("FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("FLAG"), 16, 0, 32), 1, 120), count(distinct "SNAP_ID"), sum(sys_op_opnsize("SNAP_ID")), count(distinct "DBID"), sum(sys_op_opnsize("DBID")), count(distinct "INSTANCE_NUMBER"), sum(sys_op_opnsize("INSTANCE_NUMBER")), count(distinct "SQL_ID&q uot;), sum(sys_op_opnsize("SQL_ID")), count(distinct "PLAN_HASH_VALUE"), sum(sys_op_opnsize("PLAN_HASH_VALUE")), substrb(dump(min("PLAN_HASH_VALUE"), 16, 0, 32), 1, 120), substrb(dump(max("PLAN_HASH_VALUE"), 16, 0, 32), 1, 120), count("OPTIMIZER_COST"), count(distinct "OPTIMIZER_COST"), sum(sys_op_opnsize("OPTIMIZER_COST")), substrb(dump(min("OPTIMIZER_COST"), 16, 0, 32), 1, 120), substrb(dump(max("OPTIMIZER_COST"), 16, 0, 32), 1, 120), count("OPTIMIZER_MODE"), count(distinct "OPTIMIZER_MODE"), sum(sys_op_opnsize("OPTIMIZER_MODE")), substrb(dump(min("OPTIMIZER_MODE"), 16, 0, 32), 1, 120), substrb(dump(max("OPTIMIZER_MODE"), 16, 0, 32), 1, 120), count("OPTIMIZER_ENV_HASH_VALUE"), count(distinct "OPTIMIZER_ENV_HASH_VALUE"), sum(sys_op_opnsize("OPTIMIZER_ENV_HASH_VALUE")), substrb(dump(min("OPTIMIZER_ENV_HASH_VALUE"), 16, 0, 32), 1, 120), substrb(dump(max("OPTIMIZER_ENV_HASH_VALUE"), 16, 0, 32), 1, 120), count("SHARABLE_MEM"), count(distinct "SHARABLE_MEM"), sum(sys_op_opnsize("SHARABLE_MEM")), substrb(dump(min("SHARABLE_MEM"), 16, 0, 32), 1, 120), substrb(dump(max("SHARABLE_MEM"), 16, 0, 32), 1, 120), count("LOADED_VERSIONS"), count(distinct "LOADED_VERSIONS"), sum(sys_op_opnsize("LOADED_VERSIONS")), su bstrb(dump(min("LOADED_VERSIONS"), 16, 0, 32), 1, 120), substrb(dump(max("LOADED_VERSIONS"), 16, 0, 32), 1, 120), count("VERSION_COUNT"), count(distinct "VERSION_COUNT"), sum(sys_op_opnsize("VERSION_COUNT")), substrb(dump(min("VERSION_COUNT"), 16, 0, 32), 1, 120), substrb(dump(max("VERSION_COUNT"), 16, 0, 32), 1, 120), count("MODULE"), count(distinct "MODULE"), sum(sys_op_opnsize("MODULE")), substrb(dump(min(substrb("MODULE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MODULE", 1, 32)), 16, 0, 32), 1, 120), count("ACTION"), count(distinct "ACTION"), sum(sys_op_opnsize("ACTION")), substrb(dump(min(substrb("ACTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ACTION", 1, 32)), 16, 0, 32), 1, 120), count("SQL_PROFILE"), count(distinct "SQL_PROFILE"), sum(sys_op_opnsize("SQL_PROFILE")), substrb(dump(min(substrb("SQL_PROFILE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SQL_PROFILE", 1, 32)), 16, 0, 32), 1, 120), count("FORCE_MATCHING_SIGNATURE"), count(distinct "FORCE_MATCHING_SIGNATURE"), sum(sys_op_opnsize("FORCE_MATCHING_SIGNATURE")), substrb(dump(min("FORCE_MATCHING_SIGNATURE"), 16, 0, 32), 1, 120), substrb(dump(max("FORCE_MATCHING_SIGNATURE"), 16, 0, 32), 1, 120), count(&quo t;PARSING_SCHEMA_ID"), count(distinct "PARSING_SCHEMA_ID"), sum(sys_op_opnsize("PARSING_SCHEMA_ID")), substrb(dump(min("PARSING_SCHEMA_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PARSING_SCHEMA_ID"), 16, 0, 32), 1, 120), count("PARSING_SCHEMA_NAME"), count(distinct "PARSING_SCHEMA_NAME"), sum(sys_op_opnsize("PARSING_SCHEMA_NAME")), substrb(dump(min("PARSING_SCHEMA_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("PARSING_SCHEMA_NAME"), 16, 0, 32), 1, 120), count("FETCHES_TOTAL"), count(distinct "FETCHES_TOTAL"), sum(sys_op_opnsize("FETCHES_TOTAL")), substrb(dump(min("FETCHES_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("FETCHES_TOTAL"), 16, 0, 32), 1, 120), count("FETCHES_DELTA"), count(distinct "FETCHES_DELTA"), sum(sys_op_opnsize("FETCHES_DELTA")), substrb(dump(min("FETCHES_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("FETCHES_DELTA"), 16, 0, 32), 1, 120), count("END_OF_FETCH_COUNT_TOTAL"), count(distinct "END_OF_FETCH_COUNT_TOTAL"), sum(sys_op_opnsize("END_OF_FETCH_COUNT_TOTAL")), substrb(dump(min("END_OF_FETCH_COUNT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("END_OF_FETCH_COUNT_TOTAL"), 16, 0, 32), 1, 120), count("END_OF_FETCH_COUNT_DELTA"), count(distinct "END_OF_FETCH_COUNT_DELTA"), sum(sys_op_opnsize(&q uot;END_OF_FETCH_COUNT_DELTA")), substrb(dump(min("END_OF_FETCH_COUNT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("END_OF_FETCH_COUNT_DELTA"), 16, 0, 32), 1, 120), count("SORTS_TOTAL"), count(distinct "SORTS_TOTAL"), sum(sys_op_opnsize("SORTS_TOTAL")), substrb(dump(min("SORTS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("SORTS_TOTAL"), 16, 0, 32), 1, 120), count("SORTS_DELTA"), count(distinct "SORTS_DELTA"), sum(sys_op_opnsize("SORTS_DELTA")), substrb(dump(min("SORTS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("SORTS_DELTA"), 16, 0, 32), 1, 120), count("EXECUTIONS_TOTAL"), count(distinct "EXECUTIONS_TOTAL"), sum(sys_op_opnsize("EXECUTIONS_TOTAL")), substrb(dump(min("EXECUTIONS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("EXECUTIONS_TOTAL"), 16, 0, 32), 1, 120), count("EXECUTIONS_DELTA"), count(distinct "EXECUTIONS_DELTA"), sum(sys_op_opnsize("EXECUTIONS_DELTA")), substrb(dump(min("EXECUTIONS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("EXECUTIONS_DELTA"), 16, 0, 32), 1, 120), count("PX_SERVERS_EXECS_TOTAL"), count(distinct "PX_SERVERS_EXECS_TOTAL"), sum(sys_op_opnsize("PX_SERVERS_EXECS_TOTAL")), substrb(dump(min("PX_SERVERS_EXECS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("PX_SERVERS_EXECS_TOT AL"), 16, 0, 32), 1, 120), count("PX_SERVERS_EXECS_DELTA"), count(distinct "PX_SERVERS_EXECS_DELTA"), sum(sys_op_opnsize("PX_SERVERS_EXECS_DELTA")), substrb(dump(min("PX_SERVERS_EXECS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("PX_SERVERS_EXECS_DELTA"), 16, 0, 32), 1, 120), count("LOADS_TOTAL"), count(distinct "LOADS_TOTAL"), sum(sys_op_opnsize("LOADS_TOTAL")), substrb(dump(min("LOADS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("LOADS_TOTAL"), 16, 0, 32), 1, 120), count("LOADS_DELTA"), count(distinct "LOADS_DELTA"), sum(sys_op_opnsize("LOADS_DELTA")), substrb(dump(min("LOADS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("LOADS_DELTA"), 16, 0, 32), 1, 120), count("INVALIDATIONS_TOTAL"), count(distinct "INVALIDATIONS_TOTAL"), sum(sys_op_opnsize("INVALIDATIONS_TOTAL")), substrb(dump(min("INVALIDATIONS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("INVALIDATIONS_TOTAL"), 16, 0, 32), 1, 120), count("INVALIDATIONS_DELTA"), count(distinct "INVALIDATIONS_DELTA"), sum(sys_op_opnsize("INVALIDATIONS_DELTA")), substrb(dump(min("INVALIDATIONS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("INVALIDATIONS_DELTA"), 16, 0, 32), 1, 120), count("PARSE_CALLS_TOTAL"), count(distinct "PARSE_CALLS_TOTAL"), sum(sys_op_op nsize("PARSE_CALLS_TOTAL")), substrb(dump(min("PARSE_CALLS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("PARSE_CALLS_TOTAL"), 16, 0, 32), 1, 120), count("PARSE_CALLS_DELTA"), count(distinct "PARSE_CALLS_DELTA"), sum(sys_op_opnsize("PARSE_CALLS_DELTA")), substrb(dump(min("PARSE_CALLS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("PARSE_CALLS_DELTA"), 16, 0, 32), 1, 120), count("DISK_READS_TOTAL"), count(distinct "DISK_READS_TOTAL"), sum(sys_op_opnsize("DISK_READS_TOTAL")), substrb(dump(min("DISK_READS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("DISK_READS_TOTAL"), 16, 0, 32), 1, 120), count("DISK_READS_DELTA"), count(distinct "DISK_READS_DELTA"), sum(sys_op_opnsize("DISK_READS_DELTA")), substrb(dump(min("DISK_READS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("DISK_READS_DELTA"), 16, 0, 32), 1, 120), count("BUFFER_GETS_TOTAL"), count(distinct "BUFFER_GETS_TOTAL"), sum(sys_op_opnsize("BUFFER_GETS_TOTAL")), substrb(dump(min("BUFFER_GETS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("BUFFER_GETS_TOTAL"), 16, 0, 32), 1, 120), count("BUFFER_GETS_DELTA"), count(distinct "BUFFER_GETS_DELTA"), sum(sys_op_opnsize("BUFFER_GETS_DELTA")), substrb(dump(min("BUFFER_GETS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max ("BUFFER_GETS_DELTA"), 16, 0, 32), 1, 120), count("ROWS_PROCESSED_TOTAL"), count(distinct "ROWS_PROCESSED_TOTAL"), sum(sys_op_opnsize("ROWS_PROCESSED_TOTAL")), substrb(dump(min("ROWS_PROCESSED_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("ROWS_PROCESSED_TOTAL"), 16, 0, 32), 1, 120) from "SYS"."WRH$_SQLSTAT" t
cvhk2j2gymzhd	SELECT SU.NAME, SO.NAME, A.STATSTYPE#, C.INTCOL# FROM ASSOCIATION$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU, COLTYPE$ CT, OBJ$ TY WHERE O.OWNER#=U.USER# AND A.OBJ#=TY.OBJ# AND O.OBJ#=C.OBJ# AND C.INTCOL#=CT.INTCOL# AND O.OBJ#=CT.OBJ# AND CT.TOID=TY.OID$ AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.TYPE#=2 AND O.NAME=:B3 AND U.NAME=:B2 AND C.NAME=:B1
cydgw456rs7z0	insert into sys.wri$_optstat_histhead_history(obj#, intcol#, savtime, flags, null_cnt, minimum, maximum, distcnt, density, lowval, hival, avgcln, sample_distcnt, sample_size, timestamp#) select h.obj#, h.intcol#, :3, bitand(h.spare2, 7) + 8 + decode(h.cache_cnt, 0, 0, 64), h.null_cnt, h.minimum, h.maximum, h.distcnt, h.density, h.lowval, h.hival, h.avgcln, h.spare1, h.sample_size, h.timestamp# from sys.hist_head$ h where h.obj# = :1 and h.intcol# = :2
d2nmbb77yzhm5	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; BEGIN BEGIN ORACLE_OCM.MGMT_DB_LL_METRICS.collect_config_metrics('ORACLE_OCM_CONFIG_DIR'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
d2vhun1bqg4dg	MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN STALENESS > .5 THEN 128 ELSE 0 END + AFLAGS AFLAGS, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN T.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, NULL, NULL) WHEN S.TYPE# = 5 THEN DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) ELSE NULL END * NVL(TS.BLOCKSIZE, :B4 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, NULL BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M WHERE :B1 IS NOT NULL AND O.TYPE# = 2 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE#(+) AND T.BLOCK# = S.BLOCK#(+) AND T.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.PROPERTY, 64+512) = 0 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(O .FLAGS, 128) != 128 AND BITAND(T.PROPERTY, 2147483648) = 0 AND (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608) AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME = 'SUMDELTA$') AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABPART$ T, SYS.TAB$ TAB, SYS. OBJ$ OT, SYS.MON_MODS_ALL$ M WHERE O.TYPE# = 19 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(TAB.PROPERTY, 512) != 512 AND BITAND(TAB.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 2) != 2)) UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, O.SUBNAME, NULL) * :B4 OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO# FROM SYS.OBJ$ O, SYS.USER$ U, SYS.TABCOMPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M WHERE O.TYPE# = 19 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AN D BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 2) != 2)) ) WHERE :B5 IS NOT NULL UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 64 ELSE 0 END + CASE WHEN ROW_NUMBER() OVER (PARTITION BY (SELECT TCP0.BO# FROM TABCOMPART$ TCP0 WHERE TCP0.OBJ#=ST0.BO#) ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, PART#, BO# FROM (SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.SUBPART# PART#, T.POBJ# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.PARTOBJ$ PO WHERE O.TYPE# = 3 4 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND TCP.OBJ# = T.POBJ# AND TCP.BO# = TAB.OBJ# AND PO.OBJ# = TAB.OBJ# AND ((:B7 IS NOT NULL AND BITAND(PO.SPARE2, 255) = 2) OR (:B6 IS NOT NULL AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND BITAND(TCP.FLAGS, 32) != 32 AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 2) != 2))) ST0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(I.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(CM.TRUNC, 1, GREATEST(CM.ROWCNT, CM.INSERTS), CM.TOT_MODS/(CM.ROWCNT + 0.01))))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, I.BO# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.IND$ I, (SELECT BOBJ#, SUM(BITAND(T.TRIGFLAG, 67108864)/67108864) LOCKED, SUM(BITAND(M.FLAGS, 1))/COUNT(M.FLAGS) TRUNC, SUM(M.INSERTS+M.DELETES) TOT_MODS, SUM(M.INSERTS) INSERTS, SUM(T .ROWCNT) ROWCNT FROM MON_MODS_ALL$ M, TAB$ T WHERE M.OBJ#(+) = T.OBJ# AND T.CLUCOLS IS NOT NULL GROUP BY BOBJ#) CM WHERE (:B8 IS NOT NULL) AND O.TYPE# = 1 AND S.TYPE# = 6 AND I.TYPE# = 3 AND I.OBJ# = O.OBJ# AND I.BO# = CM.BOBJ#(+) AND I.FILE# = S.FILE# AND I.BLOCK# = S.BLOCK# AND I.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(O.FLAGS, 128) != 128 AND (BITAND(I.FLAGS, 2) = 0 OR (BITAND(I.FLAGS, 2) != 0 AND (CM.TRUNC > 0 OR CM.TOT_MODS > .1 * CM.ROWCNT))) AND CM.LOCKED = 0 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN I.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_INDEX_BLOCK_COUNT(U.NAME, OI.NAME, NULL, NULL) WHEN S.TYPE# = 6 THEN DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), I.DATAOBJ#, S.BLOCKS) ELSE NULL END * NVL(TS.BLOCKSIZE, :B4 ) OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, NULL BO# FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OBJ$ OI WHERE :B1 IS NOT NULL AND I.TYPE# = 4 AND I.BO# = OT.OB J# AND BITAND(OT.FLAGS, 128) != 128 AND OT.OWNER# = U.USER# AND M.OBJ#(+) = OT.OBJ# AND I.FILE# = S.FILE#(+) AND I.BLOCK# = S.BLOCK#(+) AND I.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND T.OBJ# = OT.OBJ# AND I.OBJ# = OI.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT /*+ leading(i t) no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, PART#, BO# FROM (SELECT DECODE(BITAND(TP.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(TP.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(TP.ROWCNT, (TP.ROWCNT + M.INSERTS - M.DELETES)))) / (TP.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(IP.TS#, IP.FILE#, IP.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), IP.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, TP.PART# PART#, TP.BO# BO# FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.INDPART$ IP, SYS.TABPART$ TP, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T WHERE I.TYPE# = 4 AND S.TYPE# = 6 AND OT.OWNER# = U.USER# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND TP.OBJ# = OT.OBJ# AND I.BO# = TP.BO# AND BITAND(OT.FLAGS, 128) != 128 AND M.OBJ#(+) = OT.OBJ# AND IP.FILE# = S.FILE# AND IP.BLOCK# = S.BLOCK# AND IP.TS# = S.TS# AND TS.TS# = S.TS# AND I.BO# = T.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(TP.FLAGS, 32) != 32 AND ((BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * TP.ROWCNT)))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(TP.FLAGS, 2) != 2))) WHERE :B5 IS NOT NULL UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B4 OSIZE, I.OBJ# OBJ#, 1 TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, I.BO# BO# FROM SYS.IND$ I, SYS.TAB$ T, SYS.OBJ$ O, USER$ U WHERE (:B8 IS NOT NULL) AND :B1 IS NOT NULL AND BITAND(I.PROPERTY, 32) != 32 AND BITAND(I.PROPERTY, 64) != 64 AND BITAND(I.FLAGS, 2) != 2 AND I.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 16) = 16 AND I.OBJ# = O.OBJ# AND I.TYPE# != 4 AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND BITAND(O.FLAGS, 128) != 128 AND O.OWNER# = U.USER# AND NOT (U.NAME = 'SYS' AND O.NAME = 'I_SUMDELTA$') UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B4 OSIZE, I.OBJ# OBJ#, 20 TYPE#, 64 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, I.PART# PART#, I .BO# BO# FROM (SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) I, SYS.IND$ IND, SYS.TAB$ T, SYS.OBJ$ OI WHERE (:B8 IS NOT NULL) AND :B5 IS NOT NULL AND I.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B4 OSIZE, I.OBJ# OBJ#, 35 TYPE#, 0 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, I.SUBPART# PART#, I.POBJ# BO# FROM SYS.INDSUBPART$ I, SYS.INDCOMPART$ ICP, SYS.IND$ IND, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OI WHERE (:B8 IS NOT NULL) AND BITAND(I.FLAGS, 2) != 2 AND I.POBJ# = ICP.OBJ# AND ICP.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = PO.OBJ# AND ((:B7 IS NOT NULL AND BITAND(PO.SPARE2, 255) = 2) OR (:B6 IS NOT NULL AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 ) WHERE OSIZE IS NOT NULL ) NEW ON (ST.OBJ# = NEW.OBJ#) WHEN MATCHED THEN UPDATE SET ST.STALENESS = CASE WHEN BITAND(ST.FLAGS, 7) > 1 THEN GREATEST(NEW.STALENESS, -0.5) + ROUND(BITAND(ST.FLAGS, 7)*0.15, 1) ELSE NEW.STALENESS END, ST.OSIZE = NEW.OSIZE * DECODE(BITAND(ST.FLA GS, 7), 0, 1, 2), ST.FLAGS = ST.FLAGS - BITAND(ST.FLAGS, 32+64+128) + NEW.AFLAGS, ST.STATUS = 0, ST.TYPE# = NEW.TYPE#, ST.PART# = NEW.PART#, ST.BO# = NEW.BO#, ST.SID = NEW.SID, ST.SERIAL# = NEW.SERIAL# WHEN NOT MATCHED THEN INSERT (ST.STALENESS, ST.OSIZE, ST.OBJ#, ST.TYPE#, ST.FLAGS, ST.STATUS, ST.SID, ST.SERIAL#, ST.PART#, ST.BO#) VALUES (NEW.STALENESS, NEW.OSIZE, NEW.OBJ#, NEW.TYPE#, NEW.AFLAGS, NEW.STATUS, :B3 , :B2 , NEW.PART#, NEW.BO#)
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
db78fxqxwxt7r	select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
fq40szjfmn07f	select table_name from all_tables where ( TABLE_NAME=upper('MetaStage_Loc_Info') and OWNER=upper('CDWBASE')) or exists (select VIEW_NAME from all_views where VIEW_NAME=upper('MetaStage_Loc_Info') and OWNER=upper('CDWBASE'))
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
gfw9v7ckmbdb6	delete from ind_online$ where obj#= :1
gpdzjd2ncwa8h	select sum(PHYRDS), sum(PHYWRTS), sum(PHYBLKRD), sum(PHYBLKWRT), max(READTIM), max(WRITETIM), max(MAXIORTM), max(MAXIOWTM) from v$filestat, dba_data_files df where file# = file_id AND df.tablespace_name = 'UNDOTBS1' AND df.status = 'AVAILABLE'
gsfnqdfcvy33q	delete from superobj$ where subobj# = :1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

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

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

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

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

Instance Recovery Stats

• B: Begin snapshot, E: End snapshot

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

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

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

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.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

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

No data exists for this section of the report.

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

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

Back to Undo Statistics
Back to Top

Undo Segment Stats

• Most recent 35 Undostat rows, ordered by Time desc

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

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

• ordered by misses desc

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

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: 877,440
• Captured Segments account for 79.8% of Total

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 12,436
• Captured Segments account for 32.7% of Total

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

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

• "Pct Misses" should be very low (< 2% in most cases)
• "Final Usage" is the number of cache entries being used

Back to Top

Library Cache Activity

• "Pct Misses" should be very low

Back to Top

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

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

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.

Back to Top

init.ora Parameters

Back to Top

End of Report