WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
UCS	2887772758	ucs1	1	29-Feb-12 01:02	11.1.0.6.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
orca.domain	Linux 64-bit for AMD	8	8	2	31.43

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	11015	10-Mar-12 00:30:23	135	2.0
End Snap:	11093	13-Mar-12 06:30:17	119	2.3
Elapsed:		4,679.90 (mins)
DB Time:		7,477.70 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	11,520M	11,520M	Std Block Size:	8K
Shared Pool Size:	2,816M	2,816M	Log Buffer:	167,584K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.6	0.1	0.00	0.00
DB CPU(s):	0.2	0.0	0.00	0.00
Redo size:	22,620.0	1,530.0
Logical reads:	6,944.0	469.7
Block changes:	129.3	8.7
Physical reads:	1,933.9	130.8
Physical writes:	24.8	1.7
User calls:	424.0	28.7
Parses:	429.8	29.1
Hard parses:	0.0	0.0
W/A MB processed:	109,230.5	7,388.2
Logons:	0.0	0.0
Executes:	655.6	44.3
Rollbacks:	0.1	0.0
Transactions:	14.8

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.86	Redo NoWait %:	99.82
Buffer Hit %:	72.43	In-memory Sort %:	100.00
Library Hit %:	100.07	Soft Parse %:	100.00
Execute to Parse %:	34.44	Latch Hit %:	99.89
Parse CPU to Parse Elapsd %:	0.01	% Non-Parse CPU:	97.24

Shared Pool Statistics

	Begin	End
Memory Usage %:	34.42	35.19
% SQL with executions>1:	95.67	96.51
% Memory for SQL w/exec>1:	93.50	93.09

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1.12	0.38	2.6	1.0	8.6	95.6

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
3.4	76.2	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	32,183.8	32,183.8
SGA use (MB):	15,360.0	15,360.0
PGA use (MB):	661.7	726.5
% Host Mem used for SGA+PGA:	49.78	49.78

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	383.17	25.92
Global Cache blocks served:	22.55	1.53
GCS/GES messages received:	93.15	6.30
GCS/GES messages sent:	468.42	31.68
DBWR Fusion writes:	0.25	0.02
Estd Interconnect traffic (KB)	3,355.48

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %:	66.89
Buffer access - remote cache %:	5.54
Buffer access - disk %:	27.57

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	0.6
Avg global cache current block receive time (ms):	1.1
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	0.1
Avg global cache cr block flush time (ms):	2.2
Avg global cache current block pin time (ms):	0.1
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.7
Avg global cache current block flush time (ms):	1.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	1.3
Avg message sent queue time on ksxp (ms):	6.5
Avg message received queue time (ms):	0.1
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	37.60
% of indirect sent messages:	39.74
% of flow controlled messages:	22.66

Cluster Interconnect

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

More RAC Statistics

• RAC Report Summary
• Global Enqueue Statistics
• Global CR Served Stats
• Global CURRENT Served Stats
• Global Cache Transfer Stats
• Interconnect Stats

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
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

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

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 99.0% of Total DB time 448,661.71 (s)
• Total FG Wait Time: 375,530.03 (s) DB CPU time: 68,630.86 (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

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
• SQL ordered by Cluster Wait Time
• 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): 448,662
• Captured SQL account for 159.2% 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): 68,631
• Captured SQL account for 113.0% 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: 1,949,819,620
• Captured SQL account for 98.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 543,022,265
• Captured SQL account for 99.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 184,080,499
• Captured SQL account for 99.8% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 120,678,731
• Captured SQL account for 99.8% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

• %Ela is Cluster Wait Time as percentage of SQL Elapsed Time
• %Total is Cluster Wait Time as percentage of Total Cluster Wait Time
• Only SQL with Cluster Wait Time > .005 seconds is reported
• Total Cluster Wait Time (s): 42,196,606,606
• Captured SQL accounts for 9.4% of Total Cluster Wait Time

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
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0rc20hyugnrxf	SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.fg_cnt, sd_xe_ash_nm.fg_wts_diff, sd_xe_ash_nm.fg_tmo_diff, sd_xe_ash_nm.fg_tim_wait_diff, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tot_tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt, nvl(ash.fg_cnt, 0) as fg_cnt FROM ( SELECT nvl(xe.k eh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.fg_wts_diff, 0) as fg_wts_diff, nvl(sd.fg_tmo_diff, 0) as fg_tmo_diff, nvl(sd.fg_tim_wait_diff, 0) as fg_tim_wait_diff, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tot_tim_wait_diff, 0) as tot_tim_wait_diff FROM ( SELECT endsn.event_id as event_id, sum(endsn.total_waits_fg - nvl(begsn.total_waits_fg, 0)) as fg_wts_diff, sum(endsn.total_timeouts_fg - nvl(begsn.total_timeouts_fg, 0)) as fg_tmo_diff, sum(endsn.time_waited_micro_fg - nvl(begsn.time_waited_micro_fg, 0)) as fg_tim_wait_diff, sum(endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, sum(endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, sum(endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tot_tim_wait_diff FROM ( SELECT * FROM WRH$_SYSTEM_EVENT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) endsn LEFT OUTER JOIN ( SELECT * FROM WRH$_SYSTEM_EVENT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) begsn ON (endsn.event_id = begsn.event_id AND endsn.instance_number = begsn.instance_number) GROUP BY endsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt, sum(decode(a.session_type, 1, 1, 0)) as fg_cnt FROM WRH$_ACTIVE_SESSION_HISTORY a WHERE a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.fg_tim_wait_diff DESC, sd_xe_ash_nm.event_id
13fnb572x6z9j	insert into wrh$_osstat (snap_id, dbid, instance_number, stat_id, value) select :snap_id, :dbid, :instance_number, osstat_id, value from v$osstat
1tkztbrcvfcdw	SELECT KTFBUESEGTSN, KTFBUESEGFNO, KTFBUESEGBNO, KTFBUEEXTNO, KTFBUEFNO, KTFBUEBNO, KTFBUEBLKS, KTFBUECTM, KTFBUESTT, KTFBUESTA FROM SYS.X$KTFBUE AS OF SCN :B1
1uym1vta995yb	insert into wrh$_rowcache_summary (snap_id, dbid, instance_number, parameter, total_usage, usage, gets, getmisses, scans, scanmisses, scancompletes, modifications, flushes, dlm_requests, dlm_conflicts, dlm_releases) select :snap_id, :dbid, :instance_number, parameter, sum("COUNT"), sum(usage), sum(gets), sum(getmisses), sum(scans), sum(scanmisses), sum(scancompletes), sum(modifications), sum(flushes), sum(dlm_requests), sum(dlm_conflicts), sum(dlm_releases) from v$rowcache group by parameter order by parameter
1y4u5x9nr6aqg	INSERT /*+ APPEND */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial# , current_obj#, current_file#, current_block#, current_row# , consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial# , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
1zdgvkq55zxt9	UPDATE TB_USER_BASICINFO NOLOGGING SET LAST_TIME = SYSDATE WHERE BASIC_ID = :B1
209fr01svbb5s	update sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(SYS_EXTRACT_UTC(systimestamp) as date), logoff$pread=:4, logoff$lread=:5, logoff$lwrite=:6, logoff$dead=:7, sessioncpu=:8 where sessionid=:1 and entryid=1 and action#=100
26tccf8hy1kc1	SELECT CARRIERID FROM TB_CARRIERID WHERE IMSI = SUBSTR(:B1 , 1, IMSI_LEN)
2cn0kc8u4b81w	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select l.obj#, l.clas s_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bi tand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys. scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
2gxbvynrd71dr	INSERT INTO sys.wri$_adv_rec_actions (task_id, rec_id, act_id) VALUES (:1, :2, :3)
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
36g2yq0mxjx2y	insert into wrh$_pgastat (snap_id, dbid, instance_number, name, value) select :snap_id, :dbid, :instance_number, name, value from v$pgastat where value > 0
3972rvxu3knn3	delete from sdo_geor_ddl__table$$
3m8smr0v7v1m6	INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
3sqgkcng6vx8r	INSERT INTO sys.wri$_adv_rationale (id, task_id, rec_id, obj_id, impact_msg_id, impact_val, msg_id, type, attr1, attr2, attr3, attr4, attr5, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, ' ', :13) RETURNING rowid INTO :14
4bvhj5ctc66fw	INSERT INTO sys.wri$_adv_objects (task_id, id, type, attr1, attr2, attr3, attr4, attr5, exec_name) VALUES(:1, :2, :3, :4, :5, :6, ' ', :7, :8) RETURNING rowid into :9
4dy1xm4nxc0gf	insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4tg8mr2bvy6gr	select smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time) smontabv where smontab.scn = smontabv.scnmax
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
586b2udq6dbng	insert into wrh$_sysstat (snap_id, dbid, instance_number, stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value from v$sysstat order by stat_id
5ax5xu96u2ztd	insert into WRH$_EVENT_HISTOGRAM (snap_id, dbid, instance_number, event_id, wait_time_milli, wait_count) select :snap_id, :dbid, :instance_number, d.ksledhash, s.kslsesmaxdur, s.kslsesval from x$kslseshist s, x$ksled d where s.kslsesenum = d.indx and s.kslsesval > 0 order by d.ksledhash, s.kslsesmaxdur
5h7w8ykwtb2xt	INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
65vuzhm491wk9	DECLARE reason_id dbms_server_alert.REASON_ID_T := NULL; resource_id NUMBER; db_name recent_resource_incarnations$.db_unique_name%TYPE := :db_unique_name; inst_name recent_resource_incarnations$.instance_name%TYPE := :instance_name; event_id NUMBER := :event_id; event_time TIMESTAMP WITH TIME ZONE := TO_TIMESTAMP_TZ(:event_time, 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM', 'NLS_CALENDAR=''Gregorian'''); BEGIN CASE :reason_name WHEN 'DATABASE_UP' THEN reason_id := dbms_server_alert.RSN_FAN_DATABASE_UP; WHEN 'DATABASE_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_DATABASE_DOWN; WHEN 'INSTANCE_UP' THEN reason_id := dbms_server_alert.RSN_FAN_INSTANCE_UP; WHEN 'INSTANCE_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_INSTANCE_DOWN; WHEN 'SERVICE_UP' THEN reason_id := dbms_server_alert.RSN_FAN_SERVICE_UP; WHEN 'SERVICE_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_SERVICE_DOWN; WHEN 'SERVICE_MEMBER_UP' THEN reason_id := dbms_server_alert.RSN_FAN_SERVICE_MEMBER_UP; WHEN 'SERVICE_MEMBER_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_SERVICE_MEMBER_DOWN; WHEN 'SVC_PRECONNECT_UP' THEN reason_id := dbms_server_alert.RSN_FAN_SVC_PRECONNECT_UP; WHEN 'SVC_PRECONNECT_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_SVC_PRECONNECT_DOWN; WHEN 'NODE_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_NODE_DOWN; WHEN 'ASM_INSTANCE_UP' THEN reason_id := dbms_server_alert.RSN_FAN_ASM_INSTANCE_UP; WHEN 'ASM_INSTANCE_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_ASM_INSTANCE_DOWN; END CASE; IF :use_resource_id = 'Y' THEN BEGIN SELECT resource_id INTO resource_id FROM recent_resource_incarnations$ WHERE resource_type = 'INSTANCE' AND db_unique_name = db_name AND db_domain=NVL(SYS_CONTEXT('USERENV', 'DB_DOMAIN'), '==N/A==') AND instance_name = inst_name AND startup_time = (SELECT MAX(startup_time) FROM recent_resource_incarnations$ WHERE resource_type = 'INSTANCE' AND db_unique_name = db_name AND db_domain = NVL(SYS_CONTEXT('USERENV', 'DB_DOMAIN'), '==N/A==') AND instance_name = inst_name AND from_tz(startup_time, '+00:00') < event_time); EXCEPTION WHEN NO_DATA_FOUND T HEN RETURN; WHEN OTHERS THEN RAISE; END; event_id := 2147483648 + BITAND(event_id * 128, 2147483648-1) + resource_id; END IF; dbms_ha_alerts_prvt.post_ha_alert( reason_id => reason_id, same_transaction => FALSE, clear_old_alert => FALSE, database_unique_name => db_name, instance_name => inst_name, service_name => :service_name, host_name => :host_name, incarnation => :incarnation, event_reason => :event_reason, event_time => event_time, cardinality => :cardinality, event_id => event_id, timeout_seconds => :alert_timeout_seconds, immediate_timeout => :immed_timeout = 'Y', duplicates_ok => TRUE); END;
68vzyxv6uf24s	SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_00"), NVL(SUM(C2), :"SYS_B_01") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("TB_MTN_FACTS") FULL("TB_MTN_FACTS") NO_PARALLEL_INDEX("TB_MTN_FACTS") */ :"SYS_B_02" AS C1, CASE WHEN "TB_MTN_FACTS"."GENTIME">=TO_DATE(:"SYS_B_03", :"SYS_B_04") AND "TB_MTN_FACTS"."GENTIME"<TO_DATE(:"SYS_B_05", :"SYS_B_06") THEN :"SYS_B_07" ELSE :"SYS_B_08" END AS C2 FROM "TB_MTN_FACTS" SAMPLE BLOCK (:"SYS_B_09" , :"SYS_B_10") SEED (:"SYS_B_11") "TB_MTN_FACTS") SAMPLESUB
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6tba2h5863gt0	call dbms_hm.create_offline_dictionary ( )
6w3rdsz64hdhk	select min(timeout) from sys.reg$
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC
71k5024zn7c9a	insert into wrh$_latch_misses_summary (snap_id, dbid, instance_number, parent_name, where_in_code, nwfail_count, sleep_count, wtr_slp_count) select :snap_id, :dbid, :instance_number, parent_name, "WHERE", sum(nwfail_count), sum(sleep_count), sum(wtr_slp_count) from v$latch_misses where sleep_count > 0 group by parent_name, "WHERE" order by parent_name, "WHERE"
7f41t5f5qc9wf	INSERT INTO TB_USER_BASICINFO (BASIC_ID, BASIC_IMEI, BASIC_IMSI, BASIC_MSISDN) VALUES (SQ_TB_USER_BASICINFO.NEXTVAL, :B3 , :B2 , :B1 )
7gs8x44r7mpnb	INSERT INTO sys.wri$_adv_actions (id, task_id, obj_id, command, msg_id, flags, attr1, attr2, attr3, attr4, attr5, attr6, num_attr1, num_attr2, num_attr3, num_attr4, num_attr5, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, ' ', ' ', :11, :12, :13, :14, :15, :16) RETURNING rowid INTO :17
7tb5svkb5g09p	SELECT a.plsql_entry_object_id, a.plsql_entry_subprogram_id, dba.object_name, dba.object_type, dba.owner, dba.procedure_name, to_number(dba.overload), a.cnt FROM dba_procedures dba, ( SELECT cnt , PLSQL_ENTRY_OBJECT_ID, PLSQL_ENTRY_SUBPROGRAM_ID FROM ( SELECT count(*) as cnt , a.PLSQL_ENTRY_OBJECT_ID, a.PLSQL_ENTRY_SUBPROGRAM_ID FROM WRH$_ACTIVE_SESSION_HISTORY a WHERE a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid AND a.session_type = 1 AND bitand(a.time_model, power(2, 11 )) !=0 AND a.PLSQL_ENTRY_OBJECT_ID > 0 AND a.PLSQL_ENTRY_SUBPROGRAM_ID > 0 GROUP BY PLSQL_ENTRY_OBJECT_ID, PLSQL_ENTRY_SUBPROGRAM_ID HAVING count(*) >= :rowcnt ORDER BY 1 DESC ) WHERE rownum <= :ret ) a WHERE a.plsql_entry_object_id = dba.object_id(+) AND a.plsql_entry_subprogram_id = dba.subprogram_id(+) ORDER BY a.cnt DESC, a.plsql_entry_object_id, a.plsql_entry_subprogram_id
806d0qb72zb93	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN sp_tripletstatisticjob; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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
8g9m3tfrxpu5x	insert into wrh$_dlm_misc (snap_id, dbid, instance_number, statistic#, name, value) select :snap_id, :dbid, :instance_number, statistic#, name, value from v$dlm_misc
8pt0h7aj41t5r	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN wksys.wk_job.invoke(2, 4); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
8z5h7ks4vc4c2	select table_objno, primary_instance, secondary_instance, owner_instance from sys.aq$_queue_table_affinities a where a.owner_instance <> :1 and dbms_aqadm_syscalls.get_owner_instance(a.primary_instance, a.secondary_instance, a.owner_instance) = :2 order by table_objno for update of a.owner_instance skip locked
90rn1zkrfm1qb	SELECT * FROM TB_MTN_FACTS WHERE GENTIME >= TO_DATE('201203121115', 'yyyymmddhh24mi') AND GENTIME < TO_DATE('201203121130', 'yyyymmddhh24mi') ORDER BY GENTIME DESC
91a61auw01qpf	BEGIN SP_QUERY_BASICINFO(:1, :2, :3, :4); END;
92jmvnxzup3gw	insert into wrh$_interconnect_pings (snap_id, dbid, instance_number, target_instance, cnt_500b, wait_500b, waitsq_500b, cnt_8k, wait_8k, waitsq_8k) select :snap_id, :dbid, :instance_number, inst, iter_500b, wait_500b, waitsq_500b, iter_8k, wait_8k, waitsq_8k from x$ksxpping
952s7qg704ung	SELECT /*+parallel(tb_user_basicinfo, 16)*/ COUNT(DISTINCT BASIC_MSISDN) FROM TB_USER_BASICINFO
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
9g99psfcvs9y7	SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_00"), NVL(SUM(C2), :"SYS_B_01") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("TB_USER_BASICINFO") FULL("TB_USER_BASICINFO") NO_PARALLEL_INDEX("TB_USER_BASICINFO") */ :"SYS_B_02" AS C1, CASE WHEN "TB_USER_BASICINFO"."GENTIME">=TO_DATE(:"SYS_B_03", :"SYS_B_04") AND "TB_USER_BASICINFO"."GENTIME"<TO_DATE(:"SYS_B_05", :"SYS_B_06") THEN :"SYS_B_07" ELSE :"SYS_B_08" END AS C2 FROM "TB_USER_BASICINFO" SAMPLE BLOCK (:"SYS_B_09" , :"SYS_B_10") SEED (:"SYS_B_11") "TB_USER_BASICINFO" WHERE "TB_USER_BASICINFO"."GENTIME">=TO_DATE(:"SYS_B_12", :"SYS_B_13") AND "TB_USER_BASICINFO"."GENTIME"<TO_DATE(:"SYS_B_14", :"SYS_B_15")) SAMPLESUB
9wkffwz97jgdf	INSERT INTO TB_MTN_FACTS(NINDEX, RECVMSC, SENDMSC, GRECVMSC, GSENDMSC, SENDOTA, ASRECVMSC, ASSENDOTA, QRECVMSC, QSENDOTA) VALUES(SQ_TB_MTN_FACTS.NEXTVAL, :1, :2, :3, :4, :5, :6, :7, :8, :9)
a6u3yjca29nqc	declare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;
acc988uzvjmmt	delete from WRH$_SYSMETRIC_HISTORY tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id))
ajymgnp1qnruw	select o.name, o.owner# from obj$ o, type$ t where o.oid$ = t.tvoid and bitand(t.properties, 8388608) = 8388608 and (sysdate-o.ctime) > 0.0007
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
b1wc53ddd6h3p	select audit$, options from procedure$ where obj#=:1
bg0c1aubgr95t	insert into wrh$_inst_cache_transfer (snap_id, dbid, instance_number, instance, class, cr_block, cr_busy, cr_congested, current_block, current_busy, current_congested , lost , cr_2hop , cr_3hop , current_2hop , current_3hop , cr_block_time , cr_busy_time , cr_congested_time , current_block_time , current_busy_time , current_congested_time , lost_time , cr_2hop_time , cr_3hop_time , current_2hop_time , current_3hop_time ) select :snap_id, :dbid, :instance_number, instance, class, sum(cr_block), sum(cr_busy), sum(cr_congested), sum(current_block), sum(current_busy), sum(current_congested) , sum(lost) , sum(cr_2hop) , sum(cr_3hop) , sum(current_2hop) , sum(current_3hop) , sum(cr_block_time) , sum(cr_busy_time) , sum(cr_congested_time) , sum(current_block_time) , sum(current_busy_time) , sum(current_congested_time) , sum(lost_time) , sum(cr_2hop_time) , sum(cr_3hop_time) , sum(current_2hop_time) , sum(current_3hop_time) from (select instance, case when class in ('data block', 'undo header', 'undo block') then class else 'Others' end as class, cr_block, cr_busy, cr_congested, current_block, current_busy, current_congested , lost , cr_2hop , cr_3hop , current_2hop , current_3hop , cr_block_time , cr_busy_time , cr_congested_time , current_block_time , current_busy_time , current_congested_time , lost_time , cr_2hop_time , cr_3hop_time , current_2hop_time , current_3hop_time fr om v$instance_cache_transfer where ((cr_block + cr_busy + cr_congested + current_block + current_busy + current_congested) > 0)) group by instance, class
bqnn4c3gjtmgu	insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select /*+ ordered use_nl(e) */ :snap_id, :dbid, :instance_number, e.event_id, sum(e.total_waits), sum(e.total_timeouts), sum(e.time_waited_micro) from v$session bgsids, v$session_event e where bgsids.type = 'BACKGROUND' and bgsids.sid = e.sid group by e.event_id
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
c2p32r5mzv8hb	BEGIN prvt_advisor.delete_expired_tasks; END;
cajzqhwtknznu	SELECT /*+ INDEX(TB_USER_BASICINFO INDEX_BASIC_MSISDN) */ BASIC_ID, BASIC_MSISDN, BASIC_IMEI FROM TB_USER_BASICINFO WHERE BASIC_MSISDN = :B1 ORDER BY LAST_TIME DESC
ccqyy2p6f9rqw	SELECT /*+parallel(tb_user_basicinfo, 16)*/ COUNT(DISTINCT BASIC_IMEI) FROM TB_USER_BASICINFO
cfz686a6qp0kg	select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#
cp3gpd7z878w8	insert into wrh$_sgastat (snap_id, dbid, instance_number, pool, name, bytes) select :snap_id, :dbid, :instance_number, pool, name, bytes from (select pool, name, bytes, 100*(bytes) / (sum(bytes) over (partition by pool)) part_pct from v$sgastat) where part_pct >= 1 or pool is null or name = 'free memory' order by name, pool
cvdpt4wa8qg9x	SELECT /*+parallel(tb_user_basicinfo, 16)*/ COUNT(1) FROM TB_USER_BASICINFO
dayq182sk41ks	insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice
ddwc2t7wr092f	select min(BARRIERSCN) from SYS_FBA_BARRIERSCN
dnwpm0gdccrph	insert into wrh$_process_memory_summary (snap_id, dbid, instance_number, category, num_processes, non_zero_allocs, used_total, allocated_total, allocated_stddev, allocated_max, max_allocated_max) select :snap_id, :dbid, :instance_number, category, COUNT(*) num_processes, SUM(DECODE(allocated, 0, 0, 1)) non_zero_allocs, SUM(used) used_total, SUM(allocated) allocated_total, STDDEV(allocated) allocated_stddev, MAX(allocated) allocated_max, MAX(max_allocated) max_allocated_max from v$process_memory group by category
f0s0bk5k713yb	insert into wrh$_parameter (snap_id, dbid, instance_number, parameter_hash, value, isdefault, ismodified) select :snap_id, :dbid, :instance_number, i.ksppihash hash, substr(sv.ksppstvl, 1, 512), sv.ksppstdf, decode(bitand(sv.ksppstvf, 7), 1, 'MODIFIED', 'FALSE') from x$ksppi i, x$ksppsv sv where i.indx = sv.indx and (((i.ksppinm not like '#_%' escape '#') or (sv.ksppstdf = 'FALSE') or (bitand(sv.ksppstvf, 5) > 0)) or (i.ksppinm like '#_#_%' escape '#')) order by hash
fnk7155mk2jq6	insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv order by groupid, metricid, begtime
fnz13xnvkybtj	INSERT INTO sys.wri$_adv_findings (id, task_id, type, parent, obj_id, impact_msg_id, impact_val, msg_id, more_info_id, name_msg_code, flags, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
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
g5vpd5g3y90qv	INSERT INTO sys.wri$_adv_recommendations (id, task_id, finding_id, rank, benefit_msg_id, benefit_val, type, flags, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9)
gn76db01pq8cs	SELECT * FROM TB_MTN_FACTS WHERE GENTIME >= TO_DATE('201203121400', 'yyyymmddhh24mi') AND GENTIME < TO_DATE('201203121415', 'yyyymmddhh24mi') ORDER BY GENTIME DESC
gndwc7fqyak6b	select basic_imei, basic_imsi from tb_user_basicinfo where basic_msisdn = :1 order by last_time desc
gwzbnhabktus4	begin dbms_logmnr_d.build(options => 268435456, dictionary_filename => 'offline_dictionary.ir', dictionary_location => '/home/oracle/app/diag/rdbms/ucs/ucs1/ir'); end;

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)