WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
LNSMP	220271819	LNSMP	1	06-7月 -14 06:07	11.2.0.3.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
SMPDB	Linux x86 64-bit	24	12	2	62.91

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	10737	21-8月 -14 09:00:00	218	2.1
End Snap:	10739	21-8月 -14 11:00:10	218	2.1
Elapsed:		120.18 (mins)
DB Time:		33.47 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	18,944M	18,944M	Std Block Size:	8K
Shared Pool Size:	5,760M	5,760M	Log Buffer:	25,884K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.3	0.0	0.00	0.00
DB CPU(s):	0.1	0.0	0.00	0.00
Redo size:	809,770.9	39,492.6
Logical reads:	17,697.9	863.1
Block changes:	3,382.6	165.0
Physical reads:	2.0	0.1
Physical writes:	80.8	3.9
User calls:	325.9	15.9
Parses:	3.7	0.2
Hard parses:	0.4	0.0
W/A MB processed:	0.8	0.0
Logons:	0.3	0.0
Executes:	133.2	6.5
Rollbacks:	0.0	0.0
Transactions:	20.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	99.30	Soft Parse %:	89.75
Execute to Parse %:	97.24	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	121.67	% Non-Parse CPU:	97.49

Shared Pool Statistics

	Begin	End
Memory Usage %:	76.73	76.73
% SQL with executions>1:	98.46	98.65
% Memory for SQL w/exec>1:	92.77	94.24

Top 5 Timed Foreground Events

Host CPU (CPUs: 24 Cores: 12 Sockets: 2)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.31	0.60	0.6	0.2	0.9	99.3

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.5	72.5	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	64,417.7	64,417.7
SGA use (MB):	25,984.0	25,984.0
PGA use (MB):	450.2	448.4
% Host Mem used for SGA+PGA:	41.04	41.03

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): 2008.5s
• 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 102.8% of Total DB time 2,008.47 (s)
• Total FG Wait Time: 1,376.95 (s) DB CPU time: 687.06 (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)

No data exists for this section of the report.

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 11.0% of Total DB Time (s): 2,008
• Captured PL/SQL account for 0.1% of Total DB Time (s): 2,008

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.9% of Total CPU Time (s): 687
• Captured PL/SQL account for 0.2% of Total CPU Time (s): 687

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 15.7% of Total User I/O Wait Time (s): 14
• Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 14

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: 127,611,137
• Captured SQL account for 62.7% 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: 14,480
• Captured SQL account for 46.4% 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: 10,430
• Captured SQL account for 55.4% of Total
• Total UnOptimized Read Requests: 10,430
• Captured SQL account for 55.4% 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: 960,503
• Captured SQL account for 81.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 26,488
• Captured SQL account for 44.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

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
07c4n5uh9nk0r	select tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration , tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "SYSMAN"."MGMT_TASK_QTABLE" tab where tab.msgid = :1 and tab.state != 2 for update skip locked
089dbukv1aanh	SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2	SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
08c857fxy1ddk	UPDATE TOPO_MAP TM1 SET STATUS=( SELECT NVL(MIN(TNI.INFO_LEVEL), 0) FROM TOPO_NODE TN INNER JOIN TOPO_NODE_INFO TNI ON TNI.TOPONODE=TN.PK_TOPONODE INNER JOIN TOPO_MAP_NODE TMN ON TMN.PK_TOPONODE=TN.PK_TOPONODE INNER JOIN TOPO_MAP TM ON TM.PK_TOPOMAP=TMN.PK_TOPOMAP WHERE TM.TOPOMAP_CODE LIKE :1 AND TNI.INFO_LEVEL>0) WHERE TM1.PK_TOPOMAP=:2
08vznc16ycuag	SELECT SYS_GUID() FROM SYS.DUAL
092ctkvgy9dxm	SELECT PARTITION_NAME FROM USER_SEGMENTS WHERE UPPER(SEGMENT_NAME) = UPPER(:B2 ) AND TO_NUMBER(SUBSTR(PARTITION_NAME, LENGTH(:B2 ) + 2, LENGTH(PARTITION_NAME))) < :B1
0aa6q5r7fdznt	UPDATE FM_DEVICEALERT SET OCCURCOUNT=:1, ALERTLEVELID=:2, SECA_ALERT_ID=:3 WHERE DEVICEALERTID=:4 AND CLRFLAG=0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
130dvvr5s8bgn	select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part#
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
19x1189chq3xd	SELECT LOCKID FROM DBMS_LOCK_ALLOCATED WHERE NAME = :B1 FOR UPDATE
1df9md86bx48y	DELETE FROM MGMT_CURRENT_VIOLATION WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND KEY_VALUE = :B1
1mkmz2c6nr80d	select column_name from dba_tab_columns where owner=:1 and table_name=:2
1sx59sd5vjt36	SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QZM_TRIGGERS WHERE TRIGGER_STATE = :1 AND NEXT_FIRE_TIME < :2 AND (NEXT_FIRE_TIME >= :3) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC
1wt5699n4pzt3	INSERT INTO FM_STDASSPRIMAL(STDEVENTID, PRIMALEVENTID, STARTTIME) VALUES(:1, :2, :3)
25fu98m3hw2ts	SELECT VALUE FROM MGMT_CURRENT_METRICS A, MGMT_METRICS B, MGMT_TARGETS C WHERE B.TARGET_TYPE = :B3 AND A.METRIC_GUID = B.METRIC_GUID AND B.METRIC_COLUMN = :B2 AND B.METRIC_NAME = :B1 AND C.TYPE_META_VER = B.TYPE_META_VER AND (B.CATEGORY_PROP_1 = C.CATEGORY_PROP_1 OR B.CATEGORY_PROP_1 = ' ') AND (B.CATEGORY_PROP_2 = C.CATEGORY_PROP_2 OR B.CATEGORY_PROP_2 = ' ') AND (B.CATEGORY_PROP_3 = C.CATEGORY_PROP_3 OR B.CATEGORY_PROP_3 = ' ') AND (B.CATEGORY_PROP_4 = C.CATEGORY_PROP_4 OR B.CATEGORY_PROP_4 = ' ') AND (B.CATEGORY_PROP_5 = C.CATEGORY_PROP_5 OR B.CATEGORY_PROP_5 = ' ')
2d93bytu1xg1d	INSERT INTO MGMT_JOB_HISTORY(JOB_ID, EXECUTION_ID, STEP_ID, SOURCE_STEP_ID, ORIGINAL_STEP_ID, RESTART_MODE, STEP_NAME, STEP_TYPE, COMMAND_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, PARENT_STEP_ID, STEP_STATUS, STEP_STATUS_CODE, NUM_CHILDREN, NUM_CHILDREN_COMPLETED, OUTPUT_ID, ERROR_ID, START_TIME, END_TIME, TIMEZONE_REGION, SEQUENCE_NUMBER, DISPATCHER_ID) VALUES (:B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , :B20 , :B21 , :B22 , :B23 )
2dq7zy63j43hj	SELECT FLOOR((STARTTIME + 8*1000*3600)/(1000*60*60*24)) AS TIMEID, SUM(OCCURCOUNT) AS EVTNUM FROM FM_STDEVENT WHERE INSERTTIME >= :1 AND INSERTTIME <= :2 AND STARTTIME > :3 GROUP BY FLOOR((STARTTIME + 8*1000*3600)/(1000*60*60*24))
2mysbczfp729x	SELECT /*+ INDEX(ping mgmt_emd_ping_idx_01) */ TGT.TARGET_GUID, TGT.EMD_URL, PING.STATUS FROM MGMT_EMD_PING PING, MGMT_EMD_PING_CHECK PINGC, MGMT_TARGETS TGT, MGMT_CURRENT_AVAILABILITY CAVAIL WHERE PING.TARGET_GUID = TGT.TARGET_GUID AND PING.TARGET_GUID = CAVAIL.TARGET_GUID AND PING.TARGET_GUID = PINGC.TARGET_GUID AND TGT.TARGET_TYPE = :B4 AND PING.MAX_INACTIVE_TIME > 0 AND CAVAIL.CURRENT_STATUS != :B3 AND PING.STATUS = :B2 AND PING.PING_JOB_NAME IS NULL AND ( (:B1 -PING.LAST_HEARTBEAT_UTC)*24*60*60 > PING.MAX_INACTIVE_TIME) AND ( (:B1 -PINGC.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2) ORDER BY TGT.EMD_URL
2q6wnw4agkt70	SELECT COUNT(TRIGGER_NAME) FROM QURTZ_TRIGGERS WHERE NEXT_FIRE_TIME < :1 AND ((TRIGGER_STATE = :2) OR (TRIGGER_STATE = :3))
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
34rks4d5suuxz	SELECT COUNT(FAILOVER_ID) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP < :B1 /(24*60*60)
39ax31acw29z6	WITH MET AS (SELECT DISTINCT METRIC_GUID METRIC_GUID FROM MGMT_METRICS WHERE KEYS_FROM_MULT_COLLS = 0 ), CM AS (SELECT TARGET_GUID, METRIC_GUID, MAX(COLLECTION_TIMESTAMP) MAX_TIME FROM MGMT_CURRENT_METRICS GROUP BY TARGET_GUID, METRIC_GUID HAVING MAX(COLLECTION_TIMESTAMP) != MIN(COLLECTION_TIMESTAMP)) SELECT CM.TARGET_GUID TARGET_GUID, CM.METRIC_GUID METRIC_GUID, CM. MAX_TIME MAX_TIME FROM MET, CM WHERE CM.METRIC_GUID = MET.METRIC_GUID
39c8q6w3s3r8y	UPDATE MGMT_EMD_PING_CHECK SET LAST_CHECKED_UTC = :B1 WHERE TARGET_GUID IN (SELECT PING.TARGET_GUID FROM MGMT_EMD_PING PING, MGMT_EMD_PING_CHECK PINGC WHERE PING.TARGET_GUID = PINGC.TARGET_GUID AND PING.MAX_INACTIVE_TIME > 0 AND ( (PING.STATUS = :B3 ) OR (PING.STATUS = :B2 ) ) AND (:B1 - PINGC.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2)
3b5w82jwcjyrw	SELECT COUNT(PARTITION_NAME) FROM USER_TAB_PARTITIONS WHERE UPPER(PARTITION_NAME) = UPPER(:B2 ) AND UPPER(TABLE_NAME) = UPPER(:B1 )
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
3sg3d5sxhpna8	INSERT INTO RE_STDEVT_FACT(EVTNUM, TIME_ID, KMID, EVT_TYPE_ID, PARENT_EVT_TYPE_ID, SENDHOST, TARGETHOSTIP, ALERTLEVELID, TARGETIP, HOST_ID, GROUP_UUID, GROUP_NAME) SELECT SUM(OCCURCOUNT) AS EVTNUM, :1 AS TIME_ID, EVT.STDEVENTKMID AS KMID, ET.EVENTTYPEID AS EVT_TYPE_ID, ET.PARENTID AS PARENT_EVT_TYPE_ID, EVT.SENDHOSTIP AS SENDHOST, EVT.F_1 AS TARGETHOSTIP, EVT.ALERTLEVELID, EVT.F_12 AS TARGETIP, EVT.HOSTID AS HOST_ID, EVT.GROUP_UUID, EVT.GROUP_NAME FROM FM_STDEVENT EVT LEFT OUTER JOIN FM_STDEVENTKM KM ON EVT.STDEVENTKMID = KM.STDEVENTKMID LEFT OUTER JOIN FM_EVENTTYPE ET ON KM.EVENTTYPEID = ET.EVENTTYPEID WHERE EVT.STARTTIME>=:2 AND EVT.STARTTIME<:3 GROUP BY EVT.STDEVENTKMID, ET.EVENTTYPEID, ET.PARENTID, EVT.SENDHOSTIP, EVT.F_1, EVT.ALERTLEVELID, EVT.F_12, EVT.HOSTID, EVT.GROUP_UUID, EVT.GROUP_NAME
3w4qs0tbpmxr6	select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1
415urv6x9mf8w	SELECT /*+ RULE */ STEP_ID FROM MGMT_JOB_EXECUTION E, MGMT_JOB J WHERE E.JOB_ID=J.JOB_ID AND STEP_STATUS IN (:B8 , :B7 , :B6 , :B5 , :B4 , :B3 ) AND STEP_TYPE=:B2 AND J.EXECUTION_TIMEOUT > 0 AND (:B1 -E.START_TIME) > (J.EXECUTION_TIMEOUT/24)
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
467tqzkjxgakm	select positions0_.USER_ID as USER1_0_1_, positions0_.POSITION_ID as POSITION2_1_, position1_.ID as ID0_0_, position1_2_.NAME as NAME0_0_, position1_2_.PINYIN as PINYIN0_0_, position1_1_.DEPT_NAME as DEPT2_3_0_, position1_1_.NOTE as NOTE3_0_, position1_1_.STATE as STATE3_0_, position1_1_.TYPE as TYPE3_0_, position1_1_.ORG_PHONE as ORG6_3_0_, position1_1_.ORG_FAX as ORG7_3_0_, position1_1_.ORG_ORDERBY as ORG8_3_0_, position1_1_.APP_NAME as APP9_3_0_, position1_1_.SYS_GROUP as SYS10_3_0_, position1_1_.ORG_STATUS as ORG11_3_0_, position1_1_.GROUP_DNID as GROUP12_3_0_, position1_1_.ORG_DNNAME as ORG13_3_0_, position1_1_.MEMEO as MEMEO3_0_, position1_1_.MEMONUM as MEMONUM3_0_, position1_1_.MEMEO1 as MEMEO16_3_0_, position1_1_.MEMEO2 as MEMEO17_3_0_, position1_1_.MEMEO3 as MEMEO18_3_0_, position1_1_.MEMEO4 as MEMEO19_3_0_, position1_1_.SUPER_ID as SUPER20_3_0_, position1_.CREATED as CREATED6_0_, position1_.CREATOR as CREATOR6_0_, position1_.UPDATED as UPDATED6_0_, position1_.NAME as NAME6_0_, position1_.DESCRIPTION as DESCRIPT6_6_0_, position1_.ORDER_NO as ORDER7_6_0_, position1_.VERSION as VERSION6_0_, position1_.POSLEVEL as POSLEVEL6_0_, position1_.PERSON_NUM as PERSON10_6_0_, position1_.DEPT_ID as DEPT11_6_0_ from SECURITY_POSITION_USER_REL positions0_, SECURITY_POSITION position1_, SECURITY_ORGANIZATION position1_1_, SECURITY_PARTY position1_2_ where positions0_.POSITION_ID=position1_.ID and position1_.ID=position1_1_.DEPT_ID(+) and position1_.ID=position1_2_.ID(+) and positions0_.USER_ID=:1
47a50dvdgnxc2	update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
4g46czps3t55u	SELECT sum(case when snap_id = :begin_snap_id then value else 0 end) as begin_sga, sum(case when snap_id = :end_snap_id then value else 0 end) as end_sga FROM WRH$_SGA sga WHERE sga.dbid = :dbid AND sga.instance_number = :inst_num AND (sga.snap_id = :begin_snap_id OR sga.snap_id = :end_snap_id )
4v42j05q0bpfg	SELECT AD.TIME_ID AS OCCURTIME, SUM(AD.EVTNUM) AS NUM, FE1.PARENTID, FE2.EVENTTYPENAME FROM RE_ALERT_FACT_DAY AD INNER JOIN FM_STDEVENTKM FS ON ( AD.KMID=FS.STDEVENTKMID ) INNER JOIN FM_EVENTTYPE FE1 ON FS.EVENTTYPEID=FE1.EVENTTYPEID INNER JOIN FM_EVENTTYPE FE2 ON FE1.PARENTID=FE2.EVENTTYPEID GROUP BY AD.TIME_ID , FE1.PARENTID, FE2.EVENTTYPENAME HAVING AD.TIME_ID >=:1 AND AD.TIME_ID <=:2
4zkjnnuxaq61k	SELECT COUNT(TRIGGER_NAME) FROM QZM_TRIGGERS WHERE NEXT_FIRE_TIME < :1 AND ((TRIGGER_STATE = :2) OR (TRIGGER_STATE = :3))
520mkxqpf15q8	select 1 from dual
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5fk0v8km2f811	select propagation_name, 'BUFFERED', num_msgs ready, 0 from gv$buffered_subscribers b, dba_propagation p, dba_queues q, dba_queue_tables t where b.subscriber_name = p.propagation_name and b.subscriber_address = p.destination_dblink and b.queue_schema = p.source_queue_owner and b.queue_name = p.source_queue_name and p.source_queue_name = q.name and p.source_queue_owner = q.owner and q.queue_table = t.queue_table and b.inst_id=t.owner_instance
5mpxv5shrfcth	SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QDATA_TRIGGERS WHERE TRIGGER_STATE = :1 AND NEXT_FIRE_TIME < :2 AND (NEXT_FIRE_TIME >= :3) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC
5rygsj4dbw6jt	insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7)
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5uw1u291s3m0k	SELECT case when cnt = 0 then 0 else (1000000 * total) / cnt end FROM ( SELECT SUM(m.num_interval) AS cnt, SUM(m.num_interval * m.average) AS total FROM WRH$_SYSMETRIC_SUMMARY m , WRH$_METRIC_NAME n WHERE m.dbid = :dbid and m.instance_number = :inst_num and m.snap_id > :begin_snap_id and m.snap_id <= :end_snap_id and m.metric_id = n.metric_id and n.dbid = :dbid and n.metric_name = 'Current OS Load' )
69k5bhm12sz98	SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE _INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst
6k5agh28pr3wp	select propagation_name streams_name, 'PROPAGATION' streams_type, '"'||destination_queue_owner||'"."'||destination_queue_name||'"@'||destination_dblink address, queue_table, owner, source_queue_name from dba_queues, dba_propagation where owner=SOURCE_QUEUE_OWNER and SOURCE_QUEUE_NAME=name
6p1kmw893j6sx	SELECT 1 FROM FM_DEVICEALERT WHERE DEVICEALERTID=:1
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_WINGR OUP_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 WH ERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
74fnxs1kfd150	DELETE FROM MGMT_BLACKOUT_WINDOWS WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B4 ) AND END_TIME IS NOT NULL AND END_TIME < (:B3 - (1/24)) AND STATUS IN (:B2 , :B1 )
772s25v1y0x8k	select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
79cud6dqkc1jv	select total.tablespace_name, round(((total.bytes-free.bytes)/total.bytes)*100, 2) as percent_used from (select tablespace_name, sum(bytes) bytes from dba_data_files group by tablespace_name) total, (select tablespace_name, sum(bytes) bytes from dba_free_space group by tablespace_name) free , dba_tablespaces tbs where tbs.tablespace_name not like '%CVT%' and tbs.tablespace_name not like '%WORK_USER%' --and tbs.allocation_type='UNIFORM' and tbs.CONTENTS='PERMANENT' and total.tablespace_name=free.tablespace_name and free.tablespace_name=tbs.tablespace_name(+) and round(((total.bytes-free.bytes)/total.bytes)*100, 2)>=95
7d92gmwphtza8	SELECT OWNER, JOB_NAME, COMMENTS FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME LIKE 'EM_IDX_STAT_JOB%' AND UPPER(OWNER) = 'DBSNMP'
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#
7s1dtk08d0y3n	INSERT INTO FM_DEVICEALERT (DEVICEALERTID, ALERTSTATUS, ALERTLEVELID, OCCURTIME, ACKOPRTER, ACKFLAG, ACKTIME, CLRFLAG, CLROPRTER, CLRTIME, CLRTIME_ID, OCCURCOUNT, ALERTCONTENT, NOTIFYFLAG, TRANSFLAG, SENDFLAG, STDEVENTKMID, EUID, ACKTIME_DISPLAY, CLRTIME_DISPLAY, SENDHOSTIP, WFSTATUS, WFNUMBER, HOSTID, IP, GROUP_UUID, SECA_ALERT_ID, GROUP_UUID2, TIMEID, FM_SP_TABLENAME, INSERTTIME) VALUES( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31)
7tc5u8t3mmzgf	select cachedblk, cachehit, logicalread from tab_stats$ where obj#=:1
7wc9w5svkm229	SELECT * FROM ORG_GROUP WHERE GROUP_UUID=:1
7wt7phk4xns75	select a.capture_name streams_process_name, a.status streams_process_status, 'CAPTURE' streams_process_type, COUNT(a.error_message) from dba_capture a group by a.capture_name, a.status union all select a.propagation_name streams_process_name, a.status streams_process_status, 'PROPAGATION' streams_process_type, COUNT(a.error_message) from dba_propagation a group by a.propagation_name, a.status union all select a.apply_name streams_process_name, a.status streams_process_status, 'APPLY' streams_process_type, COUNT(a.error_message) from dba_apply a group by a.apply_name, a.status
8ghdsjbgvgmaq	LOCK TABLE "FM_STDEVENT" IN ROW EXCLUSIVE MODE NOWAIT
8t43xdhf4d9x2	SELECT CONTEXT_TYPE_ID, CONTEXT_TYPE, TRACE_LEVEL, NULL, NULL FROM EMDW_TRACE_CONFIG WHERE CONTEXT_TYPE = UPPER(:B1 )
8vwv6hx92ymmm	UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
8w5dxxmd9z3kt	select sdo_geor_def.isDropColumn(:1) from dual
9dhn1b8d88dpf	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, v$instance i 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.nex t_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')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_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 , v$instance i 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 ((bitand(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.cla ss_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' 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 , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' 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, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' 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, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
9juw6s4yy5pzp	/* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, 'BROKEN', 1, 0) broken, DECODE(STATE, 'FAILED', 1, 0) failed FROM DBA_SCHEDULER_JOBS )
a5pyncg7v0bw3	/* OracleOEM */ SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED' AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%'
a8j39qb13tqkr	SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS FROM DBA_ADDM_FINDINGS F, (SELECT FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE) RECINFO, (SELECT COUNT(F_ALL.TASK_ID) FINDING_COUNT, F_CURR.FINDING_NAME FROM (SELECT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 ) F_CURR, (SELECT T.TASK_ID, I.LOCAL_TASK_ID, T.END_TIME, T.BEGIN_TIME FROM DBA_ADDM_TASKS T, DBA_ADDM_INSTANCES I WHERE T.END_TIME>SYSDATE -1 AND T.TASK_ID=I.TASK_ID AND I.INSTANCE_NUMBER=SYS_CONTEXT('USERENV', 'INSTANCE') AND T.REQUESTED_ANALYSIS='INSTANCE' ) TASKS, DBA_ADVISOR_F INDINGS F_ALL WHERE F_ALL.TASK_ID=TASKS.TASK_ID AND F_ALL.FINDING_NAME=F_CURR.FINDING_NAME AND F_ALL.TYPE<>'INFORMATION' AND F_ALL.TYPE<>'WARNING' AND F_ALL.PARENT=0 GROUP BY F_CURR.FINDING_NAME) HISTORY WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME ORDER BY F.FINDING_ID
acchfs311r2zt	select STDEVENTID, EUID, STDEVENTKMID, EVENTCONTENT, STARTTIME, ENDTIME, OCCURCOUNT, SENDHOSTIP, ALERTLEVELID, HOSTID, F_1, GROUP_UUID, GROUP_UUID2 FROM FM_STDEVENT where FM_STDEVENT.EUIDCODE like '1252-1253-%' AND STARTTIME>=1408583449748 AND STARTTIME<1408584349748 and F_16='10.65.3.19' order by STARTTIME
am40v6qgdqj2b	select bc.pk_checkitem from bms_checkitem bc where bc.pk_checkitem in ( select bcr.pk_checkitem from bms_checkitem_related bcr left join so_class_def scd on bcr.pk_so = scd.so_uuid left join so_obj so on scd.so_id = so.class_id where so.so_uuid = :1 ) and bc.property = 6
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
b41wak2bb7atw	SELECT sum(delta_cpu_time) as total_cpu, sum(case when session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' ) then delta_cpu_time else 0 end) as logmr_cpu, sum(case when session_type in ( 'STREAMS Capture' ) then delta_cpu_time else 0 end) as captr_cpu, sum(case when session_type in ( 'Propagation Sender' , 'Propagation Receiver' ) then delta_cpu_time else 0 end) as prpgt_cpu, sum(case when session_type in ( 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' ) then delta_cpu_time else 0 end) as apply_cpu, sum(case when session_type in ( 'QMON Slaves' , 'QMON Coordinator' ) then delta_cpu_time else 0 end) as qmon_cpu FROM ( SELECT b.session_type, (case when b.min_logon_time = e.min_logon_time then e.sum_cpu_time - b.sum_cpu_time else e.sum_cpu_time end) as delta_cpu_time FROM wrh$_sess_time_stats b, wrh$_sess_time_stats e WHERE b.dbid = :dbid AND b.instance_number = :inst_num AND b.snap_id = :begin_snap_id AND e.dbid = : dbid AND e.instance_number = :inst_num AND e.snap_id = :end_snap_id AND e.session_type = b.session_type AND e.session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' , 'STREAMS Capture' , 'Propagation Sender' , 'Propagation Receiver' , 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' , 'QMON Slaves' , 'QMON Coordinator' ) ) all_types
bfxs7m7a03brt	select sequence_name from all_sequences union select synonym_name from all_synonyms us, all_sequences asq where asq.sequence_name = us.table_name and asq.sequence_owner = us.table_owner
bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.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, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a .flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (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, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
bskzz1dgvftcd	SELECT MIN(INSERTTIME) AS STARTID, MAX(INSERTTIME) AS ENDID, MIN(STARTTIME) AS STARTT, MAX(STARTTIME) AS ENDT FROM FM_STDEVENT WHERE INSERTTIME >= :1 AND INSERTTIME <= :2 AND STARTTIME >= :3 AND STARTTIME < :4
c4rtfbah05hfd	SELECT NULL AS pktable_cat, p.owner as pktable_schem, p.table_name as pktable_name, pc.column_name as pkcolumn_name, NULL as fktable_cat, f.owner as fktable_schem, f.table_name as fktable_name, fc.column_name as fkcolumn_name, fc.position as key_seq, NULL as update_rule, decode (f.delete_rule, 'CASCADE', 0, 'SET NULL', 2, 1) as delete_rule, f.constraint_name as fk_name, p.constraint_name as pk_name, decode(f.deferrable, 'DEFERRABLE', 5 , 'NOT DEFERRABLE', 7 , 'DEFERRED', 6 ) deferrability FROM all_cons_columns pc, all_constraints p, all_cons_columns fc, all_constraints f WHERE 1 = 1 AND f.table_name = :2 AND f.owner = :4 AND f.constraint_type = 'R' AND p.owner = f.r_owner AND p.constraint_name = f.r_constraint_name AND p.constraint_type = 'P' AND pc.owner = p.owner AND pc.constraint_name = p.constraint_name AND pc.table_name = p.table_name AND fc.owner = f.owner AND fc.constraint_name = f.constraint_name AND fc.table_name = f.table_name AND fc.position = pc.posi tion ORDER BY pktable_schem, pktable_name, key_seq
cdfahyc6apxcc	UPDATE QURTZ_SIMPLE_TRIGGERS SET REPEAT_COUNT = :1, REPEAT_INTERVAL = :2, TIMES_TRIGGERED = :3 WHERE TRIGGER_NAME = :4 AND TRIGGER_GROUP = :5
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cumjq42201t37	select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
cxjqbfn0d3yqq	SELECT COUNT(*) FROM SYS.DBA_PROPAGATION
d7dyc8cbh7ts4	SELECT * FROM (SELECT ROW_.*, ROWNUM SYS_ROWNUM FROM (SELECT F_16, SUM(OCCURCOUNT) AS ALLOCCURCOUNT FROM FM_STDEVENT EVT LEFT OUTER JOIN FM_STDEVENTKM KM ON EVT.STDEVENTKMID = KM.STDEVENTKMID WHERE STARTTIME >= 1408550400000 AND STARTTIME < 1408636800000 AND KM.EVENTTYPECODE LIKE '1252-1253-%' AND EVT.ALERTLEVELID IN (1, 2) GROUP BY F_16 ORDER BY ALLOCCURCOUNT DESC) ROW_ WHERE ROWNUM <= 3) WHERE SYS_ROWNUM >= 1 AND ALLOCCURCOUNT >= 2000 AND F_16 <> '10.65.3.19'
db2bhgn24fzr4	SELECT /*+ RULE */ JOB_ID, EXECUTION_ID, STATUS, SUSPEND_TIMEOUT FROM MGMT_JOB_EXEC_SUMMARY WHERE STATUS IN (:B2 ) AND SUSPEND_TIMEOUT > 0 AND (:B1 -SUSPEND_TIME) > (SUSPEND_TIMEOUT/(24*60))
dj3rdn4gd92cz	SELECT PRE_TIME FROM SUMMARY_STATUS WHERE THREAD_NAME=:1
dzmwg21cjmn32	SELECT T2.TARGET_GUID FROM MGMT_TARGETS T1, MGMT_TARGETS T2 WHERE T1.TARGET_GUID=:B2 AND T1.EMD_URL=T2.EMD_URL AND T2.TARGET_TYPE=:B1
fcb5u7n0r523m	SELECT NVL(AVG((VALUE*1000.0)/DURATION), 0), NVL((((SUM(DURATION)/(60*1000))/60)*100), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG A, MGMT_PERFORMANCE_NAMES B WHERE :B1 = B.DISPLAY_NAME AND A.JOB_NAME = B.JOB_NAME AND A.TIME > (SYSDATE-(1/24)) AND A.IS_TOTAL='Y' AND A.DURATION > 0
fuu5g28kkxzwc	SELECT * FROM ( SELECT ROW_.*, ROWNUM SYS_ROWNUM FROM ( SELECT S.STDEVENTID, L.ALERTLVLNAME, T.EVENTTYPENAME, KM.STDEVENTKMID, KM.KMNAME, S.OCCURCOUNT, S.STARTTIME, S.F_1 AS IP, AST.AST_NAME FROM FM_STDEVENT S LEFT JOIN FM_ALERTLEVEL L ON S.ALERTLEVELID=L.ALERTLEVELID LEFT JOIN FM_STDEVENTKM KM ON S.STDEVENTKMID=KM.STDEVENTKMID LEFT JOIN FM_EVENTTYPE T ON KM.EVENTTYPEID=T.EVENTTYPEID LEFT JOIN AST_ASSET AST ON AST.AST_ID=S.HOSTID WHERE 1=1 AND S.STARTTIME>=:1 AND S.STARTTIME<:2 AND S.F_1435=1 ORDER BY S.STARTTIME DESC ) ROW_ WHERE ROWNUM<=:3 ) WHERE SYS_ROWNUM>=:4
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
g2hum95yqvzb3	SELECT SUM(OCCURCOUNT) AS EVTNUM, :1 AS TIME_ID, EVT.STDEVENTKMID AS KMID, ET.EVENTTYPEID AS EVT_TYPE_ID, ET.PARENTID AS PARENT_EVT_TYPE_ID, EVT.SENDHOSTIP AS SENDHOST, EVT.F_1 AS TARGETHOSTIP, EVT.ALERTLEVELID, EVT.F_12 AS TARGETIP, EVT.HOSTID AS HOST_ID, EVT.GROUP_UUID, EVT.GROUP_NAME FROM FM_STDEVENT EVT LEFT OUTER JOIN FM_STDEVENTKM KM ON EVT.STDEVENTKMID = KM.STDEVENTKMID LEFT OUTER JOIN FM_EVENTTYPE ET ON KM.EVENTTYPEID = ET.EVENTTYPEID WHERE EVT.STARTTIME>=:2 AND EVT.STARTTIME<:3 AND EVT.INSERTTIME >=:4 AND EVT.INSERTTIME<=:5 GROUP BY EVT.STDEVENTKMID, ET.EVENTTYPEID, ET.PARENTID, EVT.SENDHOSTIP, EVT.F_1, EVT.ALERTLEVELID, EVT.F_12, EVT.HOSTID, EVT.GROUP_UUID, EVT.GROUP_NAME
g6ury8u2fymrp	SELECT USER_NAME FROM SECURITY_ULTRA_USER WHERE ACCOUNT='root'
gcph0kd36arc6	SELECT /*+ ORDERED PUSH_SUBQ */ DISTINCT D.PROFILE_NAME, D.DEVICE_NAME, D.TYPE, D.STATUS, D.PROGRAM, CFG.OWNER, CFG.RULE_NAME, DECODE(D.TYPE, :B29 , D.PROFILE_NAME, :B28 , D.PROFILE_NAME, CFG.OWNER) CHECKUSER FROM (SELECT RULE_NAME, OWNER FROM MGMT_NOTIFY_RULE_CONFIGS C WHERE ((:B26 LIKE C.TARGET_TYPE ESCAPE :B21 AND :B25 LIKE C.TARGET_NAME ESCAPE :B21 ) OR (C.TARGET_GUID IS NOT NULL AND EXISTS (SELECT 1 FROM MGMT_FLAT_TARGET_ASSOC A, MGMT_TARGETS T WHERE A.SOURCE_TARGET_GUID = C.TARGET_GUID AND A.IS_MEMBERSHIP = 1 AND A.ASSOC_TARGET_GUID = T.TARGET_GUID AND T.TARGET_TYPE = C.TARGET_TYPE AND T.TARGET_NAME = :B25 ))) AND :B24 LIKE C.METRIC_NAME ESCAPE :B21 AND :B23 LIKE C.METRIC_COLUMN ESCAPE :B21 AND ((:B22 LIKE C.KEY_VALUE ESCAPE :B21 ) OR (C.KEY_VALUE <> ' ' AND EXISTS (SELECT 1 FROM MGMT_METRICS_COMPOSITE_KEYS K WHERE K.COMPOSITE_KEY = :B22 AND NVL(K.KEY_PART1_VALUE, ' ') LIKE C.KEY_PART_1 ESCAPE :B21 AND NVL(K.KEY_PART2_VALUE, ' ') LIKE C.KEY_PART_2 ESCAPE :B21 AND NVL(K.KEY_PART3_VALUE, ' ') LIKE C.KEY_PART_3 ESCAPE :B21 AND NVL(K.KEY_PART4_VALUE, ' ') LIKE C.KEY_PART_4 ESCAPE :B21 AND NVL(K.KEY_PART5_VALUE, ' ') LIKE C.KEY_PART_5 ESCAPE :B21 AND K.TARGET_GUID = :B27 ))) AND ((:B4 = -1 AND ( (:B2 = :B20 AND WANT_TARGET_UNREACHABLE_START = 1) OR (:B2 = :B19 AND WANT_TARGET_UNREACHABLE_END = 1) OR (:B2 = :B18 AND WANT_TARGET_BLACKOUT_START = 1) OR (:B2 = :B17 AND WANT_TARGET_BLACKOUT_END = 1) OR (:B2 = :B16 AND ((WANT_TARGET_METRIC_ERR_START = 1 AND :B12 = 1) OR (WANT_TARGET_METRIC_ERR_START = 2 AND :B12 = 0) OR (WANT_TARGET_METRIC_ERR_START = 3))) OR (:B2 = :B15 AND ((WANT_TARGET_METRIC_ERR_END = 1 AND :B12 = 1) OR (WANT_TARGET_METRIC_ERR_END = 2 AND :B12 = 0) OR (WANT_TARGET_METRIC_ERR_END = 3))) OR (:B2 = :B1 AND WANT_CLEARS = 1 AND :B14 <> 1) OR (:B2 = :B1 AND WANT_TARGET_UP = 1 AND :B14 = 1) OR (:B2 = :B6 AND WANT_WARNINGS = 1) OR (:B2 = :B5 AND WANT_CRITICAL_ALERTS = 1 AND :B14 <> 1) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 0) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 1 AND :B12 = 1 AND IGNORE_RCA = 1 AND :B11 NOT IN (:B10 , :B9 )) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 1 AND :B12 = 1 AND IGNORE_RCA = 0 AND :B11 IN (:B10 , :B9 )) OR ((:B2 = :B8 OR :B2 = :B6 OR :B2 = :B5 ) AND WANT_POLICY_VIOLATIONS = 1 ) OR (:B2 = :B1 AND WANT_POLICY_CLEARS = 1 ) ) ) OR (:B4 <> -1 AND ( (:B4 = :B7 AND :B2 = :B6 AND WANT_WARNING_JOB_SUCCEEDED = 1) OR (:B4 = :B7 AND :B2 = :B5 AND WANT_CRITICAL_JOB_SUCCEEDED = 1) OR (:B4 = :B7 AND :B2 <> :B1 AND WANT_POLICY_JOB_SUCCEEDED = 1) OR (:B4 = :B3 AND :B2 = :B6 AND WANT_WARNING_JOB_PROBLEMS = 1) OR (:B4 = :B3 AND :B2 = :B5 AND WANT_CRITICAL_JOB_PROBLEMS = 1) OR (:B4 = :B3 AND :B2 <> :B1 AND WANT_POLICY_JOB_PROBLEMS = 1) ) ) )) CFG, MGMT_NOTIFY_NOTIFYEES N, MGMT_NOTIFY_DEVICES D WHERE N.RULE_NAME = CFG.RULE_NAME AND N.OWNER = CFG.OWNER AND ((D.DEVICE_NAME = N.DEVICE_NAME AND D.PROFILE_NAME = N. PROFILE_NAME) OR (N.DEVICE_NAME = ' ' AND D.PROFILE_NAME = N.PROFILE_NAME AND D.TYPE IN (:B29 , :B28 ) ) ) ORDER BY CHECKUSER
gjm43un5cy843	SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)

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