WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
XFF	3393548168	xff	1	22-4月 -11 21:04	11.2.0.1.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
XIFENFEI-PC	Microsoft Windows IA (32-bit)	2	2	1	2.99

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	120	22-4月 -11 21:40:20	32	1.3
End Snap:	125	22-4月 -11 23:30:34	34	1.8
Elapsed:		110.23 (mins)
DB Time:		15.00 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	76M	76M	Std Block Size:	8K
Shared Pool Size:	132M	132M	Log Buffer:	6,032K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.1	0.6	0.01	0.34
DB CPU(s):	0.1	0.2	0.00	0.12
Redo size:	10,963.4	47,516.9
Logical reads:	459.0	1,989.3
Block changes:	106.3	460.7
Physical reads:	7.3	31.6
Physical writes:	2.3	9.8
User calls:	0.4	1.7
Parses:	7.8	33.8
Hard parses:	0.9	4.1
W/A MB processed:	-0.0	-0.0
Logons:	0.1	0.3
Executes:	24.6	106.4
Rollbacks:	0.0	0.0
Transactions:	0.2

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	99.35
Buffer Hit %:	98.46	In-memory Sort %:	100.00
Library Hit %:	91.58	Soft Parse %:	87.93
Execute to Parse %:	68.26	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	56.59	% Non-Parse CPU:	94.02

Shared Pool Statistics

	Begin	End
Memory Usage %:	90.88	84.78
% SQL with executions>1:	80.45	78.91
% Memory for SQL w/exec>1:	66.27	79.91

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
		9.5	7.1		83.4

Instance CPU

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

Memory Statistics

	Begin	End
Host Mem (MB):	3,063.4	3,063.4
SGA use (MB):	232.0	232.0
PGA use (MB):	90.4	113.0
% Host Mem used for SGA+PGA:	10.52	11.26

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
• Shared Server Statistics
• init.ora Parameters

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Wait Event Histogram Detail (64 msec to 2 sec)
• Wait Event Histogram Detail (4 sec to 2 min)
• Wait Event Histogram Detail (4 min to 1 hr)
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 900.2s
• 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

Operating System Statistics

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

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

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

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

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 User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• 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 - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 28.2% of Total DB Time (s): 900
• Captured PL/SQL account for 25.9% of Total DB Time (s): 900

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 - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 31.1% of Total CPU Time (s): 308
• Captured PL/SQL account for 26.3% of Total CPU Time (s): 308

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 37.8% of Total User I/O Wait Time (s): 300
• Captured PL/SQL account for 40.2% of Total User I/O Wait Time (s): 300

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 as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 3,035,598
• Captured SQL account for 60.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 48,151
• Captured SQL account for 31.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 31,748
• Captured SQL account for 47.3% of Total
• Total UnOptimized Read Requests: 31,748
• Captured SQL account for 47.3% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 162,424
• Captured SQL account for 66.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 51,548
• Captured SQL account for 57.2% 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
0v3dvmc22qnam	insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
1cq3qr774cu45	insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
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
39m4sx9k63ba2	select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3nkd3g3ju5ph1	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
424h0nf7bhqzd	SELECT sqlset_row(sql_id, force_matching_signature, sql_text, object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, priority, command_type, first_load_time, stat_period, active_stat_period, other, plan_hash_value, sql_plan, bind_list) FROM ( SELECT /*+ first_rows(1) */ sql_id, force_matching_signature, sql_text, cast(NULL as SQL_OBJECTS) object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, NULL priority, command_type, NULL first_load_time, null stat_period, null active_stat_period, xmlelement( "other_attrs", xmlelement("parsing_user_id", parsing_user_id)).getClobVal() other, plan_hash_value, cast(NULL as SQL_PLAN_TABLE_TYPE) sql_plan, cast (NULL as SQL_BINDS) bind_list FROM ((SELECT t1.sql_id, t1.force_matching_signature, sql_text, module, action, selap as ELAPSED_TIME, scpu as CPU_TIME, sbgets as BUFFER_GETS, swrites as DIRECT_WRITES, sdreads as DISK_READS, srow as ROWS_PROCESSED , sfetches as fetches, sexec as EXECUTIONS, seofc as end_of_fetch_count, optimizer_cost, optimizer_env, command_type, parsing_schema_name, parsing_user_id, T1.snap_id, T1.plan_hash_value, T1.dbid, loaded_versions, bind_data FROM (SELECT sql_id, force_matching_signature, action, module, snap_id, dbid, loaded_versions, instance_number, sql_text, command_type, optimizer_env, bind_data, parsing_schema_name, parsing_user_id, plan_hash_value, optimizer_cost FROM (SELECT s.snap_id, s.dbid, s.instance_number, s.sql_id, s.force_matching_signature, sql_text, t.command_type, module, action, fetches_delta as FETCHES, executions_delta as EXECUTIONS, end_of_fetch_count_delta as END_OF_FETCH_COUNT, disk_reads_delta AS DISK_READS, direct_writes_delta DIRECT_WRITES, buffer_gets_delta as BUFFER_GETS, optimizer_env, rows_processed_delta as ROWS_PROCESSED, cpu_time_delta as CPU_TIME, elapsed_time_delta as ELAPSED_TIME, optimizer_cost, s.parsing_schema_name, s.parsing_user_id, plan_hash_value, loaded_versions, bind_data FROM DBA_HIST_SQLSTAT s, DBA_HIST_SQLTEXT t, DBA_HIST_OPTIMIZER_ENV e, V$DATABASE d WHERE s.sql_id = t.sql _id and s.dbid = t.dbid and s.dbid = e.dbid(+) and s.optimizer_env_hash_value = e.optimizer_env_hash_value(+) and s.dbid = d.dbid and /* only capture sqls with the full set of execution stats */ bitand(nvl(s.flag, 0), 1) = 0)) T1, (SELECT sql_id, plan_hash_value, sum(CPU_TIME) AS scpu, sum(BUFFER_GETS) AS sbgets, sum(DISK_READS) AS sdreads, sum(DIRECT_WRITES) AS swrites, sum(ROWS_PROCESSED) AS srow, sum(FETCHES) AS sfetches, sum(EXECUTIONS) AS sexec, sum(END_OF_FETCH_COUNT) AS seofc, sum(ELAPSED_TIME) AS selap, MAX(SNAP_ID) KEEP (DENSE_RANK LAST ORDER BY ELAPSED_TIME) AS snap_id, MAX(INSTANCE_NUMBER) KEEP (DENSE_RANK LAST ORDER BY ELAPSED_TIME) AS instance_number FROM (SELECT s.snap_id, s.dbid, s.instance_number, s.sql_id, s.force_matching_signature, sql_text, t.command_type, module, action, fetches_delta as FETCHES, executions_delta as EXECUTIONS, end_of_fetch_count_delta as END_OF_FETCH_COUNT, disk_reads_delta AS DISK_READS, direct_writes_delta DIRECT_WRITES, buffer_gets_delta as BUFFER_GETS, optimizer_env, rows_processed_delta as ROWS_PROCESSED, cpu_time_delta as CPU_TIME, elapsed_time_delta as ELAPSED_TIME, optimizer_cost, s.parsing_schema_name, s.parsing_user_id, plan_hash_value, loaded_versions, bind_data FROM DBA_HIST_SQLSTAT s, DBA_HIST_SQLTEXT t, DBA_HIST_OPTIMIZER_ENV e, V$DATABASE d WHERE s.sql_id = t.sql_id and s.dbid = t.dbid and s.dbid = e.dbid(+) and s.optimizer_env_hash_value = e.optimizer_env_hash_value(+) and s.dbid = d.dbid and /* only capture sqls with the full set of execution stats */ bitand(nvl(s.flag, 0), 1) = 0) WHERE snap_id >= :begin_snap and snap_id <= :end_snap AND command_type in (1, 2, 3, 6, 7, 189) AND sql_id = :sqlid AND plan_hash_value = :phv GROUP BY sql_id, plan_hash_value) T2 WHERE T1.sql_id = T2.sql_id AND T1.plan_hash_value = T2.plan_hash_value AND T1.snap_id = T2.snap_id AND T1.instance_number = T2.instance_number)) S )
43ruajmwv9fus	insert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue)values(:1, :2, :3, :4, :5, :6, :7)
4s1ztxvbck5hu	/* SQL Analyze(1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("OBJ#")), to_char(substrb(dump(min("OBJ#"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OBJ#"), 16, 0, 32), 1, 120)), to_char(count("COL#")), to_char(substrb(dump(min("COL#"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("COL#"), 16, 0, 32), 1, 120)), to_char(count("ROW#")), to_char(substrb(dump(min("ROW#"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ROW#"), 16, 0, 32), 1, 120)), to_char(count("BUCKET")), to_char(substrb(dump(min("BUCKET"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("BUCKET"), 16, 0, 32), 1, 120)), to_char(count("ENDPOINT")), to_char(substrb(dump(min("ENDPOINT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ENDPOINT"), 16, 0, 32), 1, 120)), to_char(count("INTCOL#")), to_char(substrb(dump(min("INTCOL#"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INTCOL#"), 16, 0, 32), 1, 120)), to_char(count("EPVALUE")), to_char(substrb(dump(min("EPVALUE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EPVALUE"), 16, 0, 32), 1, 120)), to_char(count("SPARE1")), to_char(substrb(dump(min("SPARE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump (max("SPARE1"), 16, 0, 32), 1, 120)), to_char(count("SPARE2")), to_char(substrb(dump(min("SPARE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SPARE2"), 16, 0, 32), 1, 120)) from "SYS"."HISTGRM$" t /* NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/
4y1y43113gv8f	delete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
572fbaj0fdw2b	select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
62yyzw3309d6a	SELECT VALUE FROM V$SESSION_FIX_CONTROL WHERE BUGNO = :B1 AND SESSION_ID = USERENV('SID')
63kf3an2j0pkc	insert into sys.wri$_optstat_histgrm_history (obj#, intcol#, savtime, bucket, endpoint, epvalue, colname) select hg.obj#, hg.intcol#, :3, hg.bucket, hg.endpoint, hg.epvalue, :4 from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
73umqpb6k256a	begin dbms_workload_repository.create_snapshot(); end;
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#
7sx5p1ug5ag12	SELECT SPARE4 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1
7wgks43wrjtrz	SELECT U.SPACE_USED, U.SPACE_ALLOCATED FROM TABLE(DBMS_SPACE.OBJECT_SPACE_USAGE_TBF( :B1 , :B2 , :B3 , 0, :B4 , 'TRUE', :B5 )) U
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
96g93hntrzjtr	select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9gkq7rruycsjp	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, mod(spare3, 256) interval_dty, rowid, defmaxsize from partobj$ where obj# = :1
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
asvzxj61dc5vs	select timestamp, flags from fixed_obj$ where obj#=:1
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
b6usrg82hwsa3	call dbms_stats.gather_database_stats_job_proc ( )
bq8rvyw6vvqyw	/* SQL Analyze(25, 1) */ select object_name synonym_name, object_name, owner object_owner, status, object_type from sys.all_objects o where o.owner = :object_owner and o.object_type in ('TABLE', 'VIEW', 'MATERIALIZED VIEW', 'SEQUENCE', 'FUNCTION', 'PROCEDURE', 'PACKAGE', 'TYPE') and o.object_name not like 'BIN$%' order by o.object_type, o.object_name
bzvd38cwpf0vd	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; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; BEGIN BEGIN quest_ppcm_collector.take_snapshot('PM'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
c0j6cx9kzjf7g	SELECT EXTRACTVALUE(VALUE(T), '/select_list_item/pos') + 1 POS, EXTRACTVALUE(VALUE(T), '/select_list_item/value') RES, EXTRACTVALUE(VALUE(T), '/select_list_item/nonnulls') NONNULLS, EXTRACTVALUE(VALUE(T), '/select_list_item/ndv') NDV, EXTRACTVALUE(VALUE(T), '/select_list_item/split') SPLIT, EXTRACTVALUE(VALUE(T), '/select_list_item/rsize') RSIZE, EXTRACTVALUE(VALUE(T), '/select_list_item/rowcnt') ROWCNT, EXTRACT(VALUE(T), '/select_list_item/hash_val').GETCLOBVAL() HASHVAL FROM TABLE(XMLSEQUENCE(EXTRACT(:B1 , '/process_result/select_list_item'))) T
c3amcasx93pvb	INSERT INTO STATS$FILESTATXS ( SNAP_ID , DBID , INSTANCE_NUMBER , TSNAME , FILENAME , PHYRDS , PHYWRTS , SINGLEBLKRDS , READTIM , WRITETIM , SINGLEBLKRDTIM , PHYBLKRD , PHYBLKWRT , WAIT_COUNT , TIME , FILE# ) SELECT :B3 , :B2 , :B1 , TSNAME , FILENAME , PHYRDS , PHYWRTS , SINGLEBLKRDS , READTIM , WRITETIM , SINGLEBLKRDTIM , PHYBLKRD , PHYBLKWRT , WAIT_COUNT , TIME , FILE# FROM STATS$V$FILESTATXS
c6awqs517jpj0	select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cn39cg7kr98v6	SELECT P.VALCHAR FROM SYS.OPTSTAT_USER_PREFS$ P WHERE P.OBJ#=:B2 AND P.PNAME=:B1
cpj1b53snratw	SELECT PIO.IOSTAT_ID, SUM (IOF.SMALL_READ_MEGABYTES) SMALL_READ_MEGABYTES, SUM (IOF.SMALL_WRITE_MEGABYTES) SMALL_WRITE_MEGABYTES, SUM (IOF.LARGE_READ_MEGABYTES) LARGE_READ_MEGABYTES, SUM (IOF.LARGE_WRITE_MEGABYTES) LARGE_WRITE_MEGABYTES, SUM (IOF.SMALL_READ_REQS) SMALL_READ_REQS, SUM (IOF.SMALL_WRITE_REQS) SMALL_WRITE_REQS, SUM (IOF.SMALL_SYNC_READ_REQS) SMALL_SYNC_READ_REQS, SUM (IOF.LARGE_READ_REQS) LARGE_READ_REQS, SUM (IOF.LARGE_WRITE_REQS) LARGE_WRITE_REQS, SUM (IOF.SMALL_READ_SERVICETIME) SMALL_READ_SERVICETIME, SUM (IOF.SMALL_WRITE_SERVICETIME) SMALL_WRITE_SERVICETIME, SUM (IOF.SMALL_SYNC_READ_LATENCY) SMALL_SYNC_READ_LATENCY, SUM (IOF.LARGE_READ_SERVICETIME) LARGE_READ_SERVICETIME, SUM (IOF.LARGE_WRITE_SERVICETIME) LARGE_WRITE_SERVICETIME, SUM (IOF.RETRIES_ON_ERROR) RETRIES_ON_ERROR, SUM ( (IOF.SMALL_READ_MEGABYTES * 1024 * 1024) / T.BLOCK_SIZE ) SMALL_READ_BLOCKS, SUM ( (IOF.LARGE_READ_MEGABYTES * 1024 * 1024) / T.BLOCK_SIZE ) LARGE_READ_BLOCKS, SUM ( (IOF.SMALL_WRITE_MEGABYTES * 1024 * 1024) / T.BLOCK_SIZE ) SMALL_WRITE_BLOCKS, SUM ( (IOF.LARGE_WRITE_MEGABYTES * 1024 * 1024) / T.BLOCK_SIZE ) LARGE_WRITE_BLOCKS FROM V$IOSTAT_FILE IOF, QUEST_PPCM_IOSTAT PIO, DBA_DATA_FILES DF, DBA_TABLESPACES T WHERE PIO.IOSTAT_SOURCE = 'V$IOSTAT_FILE' AND PIO.IOSTAT_NAME = IOF.FILETYPE_NAME AND PIO.IOSTAT_NAME = 'Data File' AND DF.FILE_ID = IOF.FILE_NO AND T.TABLESPACE_NAME = DF.TABLESPACE_NAME GROUP BY PIO.IOSTAT_ID UNION ALL SELECT PIO.IOSTAT_ID, SUM (IOF.SMA LL_READ_MEGABYTES) SMALL_READ_MEGABYTES, SUM (IOF.SMALL_WRITE_MEGABYTES) SMALL_WRITE_MEGABYTES, SUM (IOF.LARGE_READ_MEGABYTES) LARGE_READ_MEGABYTES, SUM (IOF.LARGE_WRITE_MEGABYTES) LARGE_WRITE_MEGABYTES, SUM (IOF.SMALL_READ_REQS) SMALL_READ_REQS, SUM (IOF.SMALL_WRITE_REQS) SMALL_WRITE_REQS, SUM (IOF.SMALL_SYNC_READ_REQS) SMALL_SYNC_READ_REQS, SUM (IOF.LARGE_READ_REQS) LARGE_READ_REQS, SUM (IOF.LARGE_WRITE_REQS) LARGE_WRITE_REQS, SUM (IOF.SMALL_READ_SERVICETIME) SMALL_READ_SERVICETIME, SUM (IOF.SMALL_WRITE_SERVICETIME) SMALL_WRITE_SERVICETIME, SUM (IOF.SMALL_SYNC_READ_LATENCY) SMALL_SYNC_READ_LATENCY, SUM (IOF.LARGE_READ_SERVICETIME) LARGE_READ_SERVICETIME, SUM (IOF.LARGE_WRITE_SERVICETIME) LARGE_WRITE_SERVICETIME, SUM (IOF.RETRIES_ON_ERROR) RETRIES_ON_ERROR, SUM ( (IOF.SMALL_READ_MEGABYTES * 1024 * 1024) / T.BLOCK_SIZE ) SMALL_READ_BLOCKS, SUM ( (IOF.LARGE_READ_MEGABYTES * 1024 * 1024) / T.BLOCK_SIZE ) LARGE_READ_BLOCKS, SUM ( (IOF.SMALL_WRITE_MEGABYTES * 1024 * 1024) / T.BLOCK_SIZE ) SMALL_WRITE_BLOCKS, SUM ( (IOF.LARGE_WRITE_MEGABYTES * 1024 * 1024) / T.BLOCK_SIZE ) LARGE_WRITE_BLOCKS FROM V$IOSTAT_FILE IOF, QUEST_PPCM_IOSTAT PIO, DBA_TEMP_FILES TF, DBA_TABLESPACES T WHERE PIO.IOSTAT_SOURCE = 'V$IOSTAT_FILE' AND PIO.IOSTAT_NAME = IOF.FILETYPE_NAME AND PIO.IOSTAT_NAME = 'Temp File' AND TF.FILE_ID = IOF.FILE_NO AND T.TABLESPACE_NAME = TF.TABLESPACE_NAME GROUP BY PIO.IOSTAT_ID
cs1um7tna4mvu	/* SQL Analyze(1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("OBJ#")), to_char(substrb(dump(min("OBJ#"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OBJ#"), 16, 0, 32), 1, 120)), to_char(count("DATAOBJ#")), to_char(substrb(dump(min("DATAOBJ#"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DATAOBJ#"), 16, 0, 32), 1, 120)), to_char(count("TS#")), to_char(substrb(dump(min("TS#"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TS#"), 16, 0, 32), 1, 120)), to_char(count("FILE#")), to_char(substrb(dump(min("FILE#"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FILE#"), 16, 0, 32), 1, 120)), to_char(count("BLOCK#")), to_char(substrb(dump(min("BLOCK#"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("BLOCK#"), 16, 0, 32), 1, 120)), to_char(count("COLS")), to_char(substrb(dump(min("COLS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("COLS"), 16, 0, 32), 1, 120)), to_char(count("PCTFREE$")), to_char(substrb(dump(min("PCTFREE$"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PCTFREE$"), 16, 0, 32), 1, 120)), to_char(count("PCTUSED$")), to_char(substrb(dump(min("PCTUSED$"), 16, 0, 32), 1, 120)), to_char(substrb(dump(m ax("PCTUSED$"), 16, 0, 32), 1, 120)), to_char(count("INITRANS")), to_char(substrb(dump(min("INITRANS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INITRANS"), 16, 0, 32), 1, 120)), to_char(count("MAXTRANS")), to_char(substrb(dump(min("MAXTRANS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MAXTRANS"), 16, 0, 32), 1, 120)), to_char(count("SIZE$")), to_char(substrb(dump(min("SIZE$"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SIZE$"), 16, 0, 32), 1, 120)), to_char(count("HASHFUNC")), to_char(substrb(dump(min("HASHFUNC"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("HASHFUNC"), 16, 0, 32), 1, 120)), to_char(count("HASHKEYS")), to_char(substrb(dump(min("HASHKEYS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("HASHKEYS"), 16, 0, 32), 1, 120)), to_char(count("FUNC")), to_char(substrb(dump(min("FUNC"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FUNC"), 16, 0, 32), 1, 120)), to_char(count("EXTIND")), to_char(substrb(dump(min("EXTIND"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTIND"), 16, 0, 32), 1, 120)), to_char(count("FLAGS")), to_char(substrb(dump(min("FLAGS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FLAGS"), 16, 0, 32), 1, 120)), to_char(count("DEGREE")), to_char(substrb(dump(min( "DEGREE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DEGREE"), 16, 0, 32), 1, 120)), to_char(count("INSTANCES")), to_char(substrb(dump(min("INSTANCES"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INSTANCES"), 16, 0, 32), 1, 120)), to_char(count("AVGCHN")), to_char(substrb(dump(min("AVGCHN"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("AVGCHN"), 16, 0, 32), 1, 120)), to_char(count("SPARE1")), to_char(substrb(dump(min("SPARE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SPARE1"), 16, 0, 32), 1, 120)), to_char(count("SPARE2")), to_char(substrb(dump(min("SPARE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SPARE2"), 16, 0, 32), 1, 120)), to_char(count("SPARE3")), to_char(substrb(dump(min("SPARE3"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SPARE3"), 16, 0, 32), 1, 120)), to_char(count("SPARE4")), to_char(substrb(dump(min("SPARE4"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SPARE4"), 16, 0, 32), 1, 120)), to_char(count("SPARE5")), to_char(substrb(dump(min("SPARE5"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SPARE5"), 16, 0, 32), 1, 120)), to_char(count("SPARE6")), to_char(substrb(dump(min("SPARE6"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SPARE6"), 16, 0, 32), 1, 120)), to_c har(count("SPARE7")), to_char(substrb(dump(min("SPARE7"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SPARE7"), 16, 0, 32), 1, 120)) from "SYS"."CLU$" t /* NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/
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
cvn54b7yz0s8u	select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d0xmnp08rhfbg	insert into sys.wri$_optstat_histhead_history (obj#, intcol#, savtime, flags, null_cnt, minimum, maximum, distcnt, density, lowval, hival, avgcln, sample_distcnt, sample_size, timestamp#, colname) select h.obj#, h.intcol#, :3, bitand(h.spare2, 7) + 8 + decode(h.cache_cnt, 0, 0, 64), h.null_cnt, h.minimum, h.maximum, h.distcnt, h.density, h.lowval, h.hival, h.avgcln, h.spare1, h.sample_size, h.timestamp#, :4 from sys.hist_head$ h where h.obj# = :1 and h.intcol# = :2
db78fxqxwxt7r	select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
djs2w2f17nw2z	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN statspack.snap; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
g1xapjmt4vm5c	SELECT SU.NAME, SO.NAME, A.STATSTYPE#, A.INTCOL# FROM ASSOCIATION$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU WHERE O.OWNER#=U.USER# AND A.OBJ#=O.OBJ# AND O.OBJ#=C.OBJ# AND C.INTCOL#=A.INTCOL# AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.TYPE#=2 AND U.NAME=:B3 AND O.NAME=:B2 AND C.NAME=:B1
g5m0bnvyy37b1	select sql_id, plan_hash_value, bucket_id, begin_snap, end_snap from (select dbid, sql_id, bucket_id, plan_hash_value, begin_snap, end_snap, cpu_plus_io from (select dbid, sql_id, bucket_id, plan_hash_value, begin_snap, end_snap, cpu_plus_io, row_number() over (partition by bucket_id order by cpu_plus_io desc) as within_bucket_rnk from (select dbid, sql_id, bucket_id, max(plan_hash_value) keep (dense_rank last order by cpu_plus_io) plan_hash_value, max(begin_snap) keep (dense_rank last order by cpu_plus_io) begin_snap, max(end_snap) keep (dense_rank last order by cpu_plus_io) end_snap, max(cpu_plus_io) cpu_plus_io from (select dbid, sql_id, plan_hash_value, begin_snap, end_snap, bucket_id, cpu_time + buffer_gets * 10000 as cpu_plus_io from (select dbid, begin_snap, end_snap, sql_id, plan_hash_value, case when bucket_id = 0 then cpu_time / executions else cpu_time end as cpu_time, case when bucket_id = 0 then buffer_gets / executions else buffer_gets end as buffer_gets, bucket_id from (select dbid, min(snap_id) begin_snap, max(snap_id) end_snap, sql_id, plan_hash_value, sum(cpu_time) cpu_time, sum(buffer_gets) buffer_gets, decode(sum(executions), 0, 1, sum(executions)) executions, decode(grouping_id(snap_id, hour_id, day_id), 3, 0, 5, 1, 6, 2, 3) bucket_id from (select f.dbid, f.snap_id, sql_id, plan_hash_value, to_number(to_char(begin_interval_time + 0, 'DDD')) day_id, (to_number(to_char(begin_interval_time + 0, 'DDD')) - 1)*24 + to_number(to_char(begin_interval_time + 0, 'HH24')) hour_id, cpu_time, buffer_gets, executions from (select v1.* from ( select snap_id, dbid, min_inst_num, sql_id, plan_hash_value, cpu_time, buffer_gets, executions from (select snap_id, dbid, min_inst_num, sql_id, plan_hash_value, cpu_time, buffer_gets, executions, row_number() over(partition by dbid, snap_id order by(cpu_time + buffer_gets * 10000) desc) as within_snap_rnk from (select /*+ cardinality(d 1) */ sq.dbid, sq.snap_id, min(sq.instance_number) min_inst_num, sq.sql_id, plan_hash_value, sum(cpu_time_delta) cpu_time, sum(buffer_gets_delta) buffer_gets, sum(executions_delta) executions from dba_hist_sqlstat sq, v$database d, dba_hist_sqltext st where sq.dbid = d.dbid and st.dbid = sq.dbid and st.sql_id = sq.sql_id and sq.snap_id between :bid and :eid and st.command_type in (2, 3, 6, 7, 189) and bitand(nvl(sq.flag, 0), 1) = 0 group by sq.dbid, sq.snap_id, sq.sql_id, plan_hash_value)) where within_snap_rnk <= 150 ) v1, (select sq.sql_id from dba_hist_sqlstat sq, v$database d where sq.dbid = d.dbid and sq.snap_id between :bid and :eid group by sq.dbid, sq.sql_id having sum(nvl(executions_delta, 0)) >= 2) v2 where v1.sql_id = v2.sql_id) f, dba_hist_snapshot s where f.snap_id = s.snap_id and f.dbid = s.dbid and s.instance_number = f.min_inst_num) group by grouping sets ((dbid, sql_id, plan_hash_value, snap_id), (dbid, sql_id, plan_hash_value, day_id), (dbid, sql_id, plan_hash_value, hour_id), (dbid, sql_id, plan_hash_value))))) group by dbid, sql_id, bucket_id) where cpu_plus_io >= decode(bucket_id, 0, (10 * 100 0000), 1, (60 * 1000000), 2, (240 * 1000000), (480 * 1000000)))where within_bucket_rnk <= 150) order by bucket_id asc, cpu_plus_io desc
ga9j9xk5cy9s0	select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
grwydz59pu6mc	select text from view$ where rowid=: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

• Ordered by statistic name

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

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times, in milliseconds
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Ordered by (Data Read + Write) desc for each function

Back to IO Stats
Back to Top

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

• Buffer Pool Statistics
• Checkpoint Activity

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 Buffer Pool Statistics
Back to Top

Checkpoint Activity

• Total Physical Writes: 14,997

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

• Instance Recovery Stats
• MTTR Advisory
• 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

MTTR Advisory

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Buffer Wait Statistics

• ordered by wait time desc, waits desc

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
• Mutex Sleep Summary
• Parent Latch Statistics
• Child Latch Statistics

Latch Activity

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