| SQL Id | SQL Text |
|---|
| 0ajsjb0vamjuu | delete from ana_focusdoc_current where indexId=54 and serverId = 1 and tag = 1 and type=0 |
| 15kfxb4xub64f | insert into ana_PoliticsFocus (politicsFocusId, radarWebSiteId, title, keywords, relateNum, note, orderIndex, updateDate, indexChanged, numChanged, isNew, topicUrl) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12) |
| 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)) |
| 1dp158t1m3n5h | select * from ana_PageRankModule a where pageranksiteid=5 and RankContentClass ='ÌåÓýÐÂÎÅÈÕÈȵãÅÅÐÐ' and RankTaxsisClass ='µã»÷ÅÅÐÐ' and RankTimeClass is null |
| 1puu790473yxt | insert into sens_tempsens_asset ( sensitiveId, assetId ) values ( :1, :2 ) |
| 2060x3btpy71q | select * from ana_PageRankModule a where rankContentClass = '¶¯ÂþÓÎÏ·' and pageRankSiteId=7 and radarwebsiteid=3 |
| 2jdbk4m75hjpk | update app_SendPortal_info set name=:1, assetId=:2, url=:3, urlMd5=:4, title=:5, endDate=:6, createDate=:7, orderId=:8, topId=:9, deleteFlag=:10, organId=:11, source=:12, channel=:13, visitCount=:14, rebackCount=:15, keywords=:16, description=:17, zzSRC=:18, isMainTopic=:19, sameAssetCount=:20, taskId=:21 where sendPortalInfoId=:22 |
| 2zkbzbd3rmz53 | select * from ana_PageRankModule a where rankContentClass = 'ʱÉÐÇé¸Ð' and pageRankSiteId=7 and radarwebsiteid=3 |
| 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 |
| 3nf77vvhjwfbp | select assetid from app_assetmain where tweetid = :c1 and radarwebsiteid = :c2 |
| 3z9q3nc8tg4f8 | SELECT Seq_No FROM sys_SerialNo WHERE ID=:1 FOR UPDATE OF Seq_No |
| 4fcnjams7zmhw | select * from app_MainSplit where minValue<=:1 and maxValue>=:2 |
| 4p25wjr52db0d | select * from ana_PageRankModule a where pageranksiteid=5 and RankContentClass ='¹ú¼ÊÐÂÎÅÈÕÈȵãÅÅÐÐ' and RankTaxsisClass ='¸úÌûÅÅÐÐ' and RankTimeClass is null |
| 4pvnqn9pmfugv | select count(*) from sys_resource t where t.parentresourceid=:1 and t.isnavbar=1 |
| 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) |
| 4y0h76mca689b | select * from ana_PageRankModule a where pageranksiteid=5 and RankContentClass ='¹ú¼ÊÐÂÎÅÈÕÈȵãÅÅÐÐ' and RankTaxsisClass ='µã»÷ÅÅÐÐ' and RankTimeClass is null |
| 4yh9c1jm2dsvp | update app_AssetMain set retweetsCount=:1, commentsCount=:2 where assetId=:3 |
| 558hnx6sdycvt | insert into sys_log (logId, userId, createDate, description, userIP, isSuccess, describe) values (:1, :2, :3, :4, :5, :6, :7) |
| 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 |
| 5kfd3ujwt5ark | select * from ana_PageRankModule a where rankContentClass = '²Æ¾×ÊѶ' and pageRankSiteId=7 and radarwebsiteid=3 |
| 64qbdn68dzj1u | insert into ana_PageRank (pageRankId, pageRankModuleId, title, location, urlhash, visitcount, rebackCount, pubDate, source, orderIndex, updatedate) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11) |
| 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 |
| 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; |
| 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 |
| 71b9k85319v1y | insert into ana_focus_day ( dayId, serverId, IndexID, tag, folderId, Title, KeyWords, keywordWeight, FirstTime, lastTime, Total, LinkID, score, weight, numOfToday, webType, webCharacter, description, summary, sameTopicId, relatedTopicId, type, imgurl ) values( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23 ) |
| 7bpyh56n2b8jr | insert into app_SendPortal_info ( sendPortalInfoId, name, assetId, endDate, orderId, topId, deleteFlag, organId, taskId, source, radarWebSiteId, tweetId, userCode, createDate, tweetText, urlhash, location, publishFrom, picsCount, thumbnailPicUrl, originalPicUrl, retweetsCount, commentsCount, tweetType, retweetId, creator, verified, isAppraise ) 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 ) |
| 7d92gmwphtza8 | SELECT OWNER, JOB_NAME, COMMENTS FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME LIKE 'EM_IDX_STAT_JOB%' AND UPPER(OWNER) = 'DBSNMP' |
| 7dzkbafwxcdyb | insert into sens_sensitive_asset ( taskId, sensitiveId, assetId ) values ( :1, :2, :3 ) |
| 7n3hj4gf2dr06 | insert into ana_focusdoc_current ( serverId, indexId, TopicID, tag, folderId, assetId, sim, integratedWeight, type ) values( :1, :2, :3, :4, :5, :6, :7, :8, :9 ) |
| 84upmxkmhm85x | update app_assetMain set RebackCount=:c1, VisitCount= :c2 where assetid = :c3 |
| 88yuskybjb9ur | SELECT count(*) FROM v$open_cursor WHERE sid = :1 |
| 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 |
| 8vyjutx6hg3wh | update /*+ rule */ undo$ set name=:2, file#=:3, block#=:4, status$=:5, user#=:6, undosqn=:7, xactsqn=:8, scnbas=:9, scnwrp=:10, inst#=:11, ts#=:12, spare1=:13 where us#=:1 |
| 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 ) |
| 9m82p8p2d7z84 |
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 f.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 i.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 |
| a3jwty1m7xb9h | insert into ana_PoliticsFocus (politicsFocusId, politicsFocusSiteId, title, location, urlHash, visitCount, rebackCount, orderIndex, updateDate) values (:1, :2, :3, :4, :5, :6, :7, :8, :9) |
| 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 |
| af8amppk95q57 |
Insert into app_assetMain (AssetID, AssetInFolders, TITLE, DESCRIPTION, CREATOR, KEYWORDS, CREATEDATE, SOURCE, CHANNEL, LOCATION, DATASIZE, RECORDCREATIONDATE, LASTMODIFYDATE, VISITCOUNT, REBACKCOUNT, ISMAINTOPIC, WWWTYPE, WWWCHARACTER, URLHASH, REFURLHASH, PROVINCEID, USETYPE, WEIGHT, ORDERINDEX, RADARWEBSITEID, RADARCHANNELID, ZZSRC, DISTRICT, DATASOURCE, DEPTGROUPID, WEBGROUPID, ISIMAGE, ISGARBAGE, ISAPPRAISE, APPRAISEVALUE, ASSETINRULES, ASSETINORGANS) Values(:c1, :c2, :c3, :c4, :c5, :c6, TO_DATE(:c7, 'YYYY-MM-DD HH24:MI:SS'), :c8, :c9, :c10, TO_NUMBER(:c11), TO_DATE(:c12, 'YYYY-MM-DD HH24:MI:SS'), TO_DATE(:c13, 'YYYY-MM-DD HH24:MI:SS'), TO_NUMBER(:c14), TO_NUMBER(:c15), TO_NUMBER(:c16), TO_NUMBER(:c17), TO_NUMBER(:c18), TO_NUMBER(:c19), TO_NUMBER(:c20), TO_NUMBER(:c21), TO_NUMBER(:c22), TO_NUMBER(:c23), TO_NUMBER(:c24), TO_NUMBER(:c25), TO_NUMBER(:c26), :c27, :c28, TO_NUMBER(:c29), :c30, :c31, TO_NUMBER(:c32),
TO_NUMBER(:c33), TO_NUMBER(:c34), TO_NUMBER(:c35), :c36, :c37) |
| ajvzhw4a6tmjt | update sens_sensitive set totalType=:1 where sensitiveId=:2 |
| amzu1hjp5c1b8 | select * from ana_PageRankModule a where rankContentClass = 'Ìå̳·çÔÆ' and pageRankSiteId=7 and radarwebsiteid=3 |
| aqrj29fh24qkf | select * from ana_PageRankModule a where pageranksiteid=5 and RankContentClass ='¹úÄÚÐÂÎÅÈÕÈȵãÅÅÐÐ' and RankTaxsisClass ='µã»÷ÅÅÐÐ' and RankTimeClass is null |
| b2u9kspucpqwy | SELECT COUNT(*) FROM SYS.DBA_PROPAGATION WHERE ERROR_MESSAGE IS NOT NULL |
| b5d00ykp43h72 | select * from ana_PageRankModule a where rankContentClass = '½ñÈÕÈȵã' and pageRankSiteId=7 and radarwebsiteid=3 |
| b9nd31kztfyu4 | delete from app_AssetUpdateQueue_Temp a where updateAssetId = :1 and tweetType = :2 |
| bdtjsw2cpbnvd | insert into app_SendPortal_info (sendPortalInfoId, name, title, assetId, url, urlMd5, endDate, createDate, orderId, topId, deleteFlag, organId, source, channel, visitCount, rebackCount, keywords, description, zzSRC, isMainTopic, sameAssetCount, taskId) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22) |
| bfmxxsyz0v76c | select * from ana_PageRankModule a where rankContentClass = 'Éú»îȤ̸' and pageRankSiteId=7 and radarwebsiteid=3 |
| bkcqb6f33kn4u |
Insert into app_assetMain (AssetID, AssetInFolders, SECONDPROVINCEID, PROVINCEID, RADARWEBSITEID, TWEETID, USERCODE, SOURCE, CREATEDATE, TWEETTEXT, KEYWORDS, PUBLISHFROM, PICSCOUNT, THUMBNAILPICURL, ORIGINALPICURL, RETWEETSCOUNT, COMMENTSCOUNT, TWEETTYPE, RETWEETID, CREATOR, RECORDCREATIONDATE, LASTMODIFYDATE, DATASIZE, USETYPE, ISGARBAGE, ISAPPRAISE, APPRAISEVALUE, ORDERINDEX, ASSETINRULES, ASSETINORGANS, VERIFIED, LOCATION, URLHASH, SEX) Values(:c1, :c2, TO_NUMBER(:c3), TO_NUMBER(:c4), TO_NUMBER(:c5), TO_NUMBER(:c6), :c7, :c8, TO_DATE(:c9, 'YYYY-MM-DD HH24:MI:SS'), :c10, :c11, :c12, TO_NUMBER(:c13), :c14, :c15, TO_NUMBER(:c16), TO_NUMBER(:c17), TO_NUMBER(:c18), TO_NUMBER(:c19), :c20, TO_DATE(:c21, 'YYYY-MM-DD HH24:MI:SS'), TO_DATE(:c22, 'YYYY-MM-DD HH24:MI:SS'), TO_NUMBER(:c23), TO_NUMBER(:c24), TO_NUMBER(:c25), TO_NUMBER(:c26), TO_NUMBER(:c27), TO_NUMBER(:c28), :c29, :c30, TO_NUMBER(:c31), :c32, TO_NUMBER(:c33), TO
_NUMBER(:c34)) |
| bnhd0gpwcjqdv | select * from ana_PageRankModule a where pageranksiteid=5 and RankContentClass ='²Æ¾ÐÂÎÅÈÕÈȵãÅÅÐÐ' and RankTaxsisClass ='¸úÌûÅÅÐÐ' and RankTimeClass is null |
| c6631q9ukfhb1 | begin emd_mntr.get_target_settings(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18); end; |
| cb6qvc2v2961s | select * from ana_PageRankModule a where pageranksiteid=5 and RankContentClass ='Éç»áÐÂÎÅÈÕÈȵãÅÅÐÐ' and RankTaxsisClass ='¸úÌûÅÅÐÐ' and RankTimeClass is null |
| chuhf8t1ftx89 |
SELECT MET.METRIC_NAME, MET.METRIC_LABEL, MET.METRIC_LABEL_NLSID, MET.METRIC_COLUMN, MET.COLUMN_LABEL, MET.COLUMN_LABEL_NLSID, MET.METRIC_TYPE, MET.NUM_KEYS, MET.KEY_COLUMN, MET.IS_REPOSITORY, MET.IS_TRANSPOSED, MET.HAS_PUSH, MET.HAS_PULL, MET.REMOTE, MET.NON_THRESHOLDED_ALERTS, MET.KEYONLY_THRESHOLDS, P.POLICY_GUID, P.POLICY_NAME, NVL(MSG.MESSAGE, NVL(EMSG.MESSAGE, P.POLICY_NAME)) AS POLICY_NAME_DISPLAY, P.METRIC_GUID, P.POLICY_TYPE, P.POLICY_LABEL_NLSID, NVL(MSGDESC.MESSAGE, NVL(EMSGDESC.MESSAGE, P.DESCRIPTION)) AS DESCRIPTION, P.VIOLATION_LEVEL, P.CONDITION_TYPE, P.CONDITION, P.CONDITION_OPERATOR, P.MESSAGE, P.MESSAGE_NLSID, P.CLEAR_MESSAGE, P.CLEAR_MESSAGE_NLSID, P.DETAILED_URL_LINK, P.OWNER, PC.CATEGORY_NAME AS CATEGORY, NVL(MSGCAT.MESSAGE, NVL(EMSGCAT.MESSAGE, PC.CATEGORY_NAME)) AS CATEGORY_DISPLAY, PA.COLL_NAME, PA.IS_ENABLED, PA.ADD_OR_DELETE, PAC.KEY_VALUE, PAC.KEY_OPERATOR, PAC.EVAL_ORDER, PAC.IS_EXCEPTION, PAC.IS_PUSH, PAC.HAS
_ACTIVE_BASELINE, PAC.PREVENT_OVERRIDE, PAC.CRIT_ACTION_JOB_ID, PAC.WARN_ACTION_JOB_ID, PAC.INFO_ACTION_JOB_ID, TRIM(PAC.FIXIT_JOB) AS FIXIT_JOB, PAC.SIMULTANEOUS_ACTIONS, PAC.IMPORTANCE, PAC.NUM_OCCURRENCES, PACP.PARAM_NAME, NVL(MSGPARAM.MESSAGE, NVL(EMSGPARAM.MESSAGE, PP.PARAM_NAME)) AS PARAM_NAME_DISPLAY, PP.PARAM_TYPE, PACP.CRIT_THRESHOLD, PACP.WARN_THRESHOLD, PACP.INFO_THRESHOLD, DPACP.CRIT_THRESHOLD AS DEFAULT_CRIT_THRESHOLD, DPACP.WARN_THRESHOLD AS DEFAULT_WARN_THRESHOLD, DPACP.INFO_THRESHOLD AS DEFAULT_INFO_THRESHOLD, COMPKEYS.KEY_PART1_VALUE, COMPKEYS.KEY_PART2_VALUE, COMPKEYS.KEY_PART3_VALUE, COMPKEYS.KEY_PART4_VALUE, COMPKEYS.KEY_PART5_VALUE, AM.AGENT_SIDE_METRIC_GUID, AM.AGENT_SIDE_METRIC_NAME, AM.AGENT_SIDE_METRIC_LABEL, AM.AGENT_SIDE_METRIC_LABEL_NLSID FROM MGMT_METRICS MET, MGMT_POLICIES P, MGMT_CATEGORY_MAP PCM, MGMT_CATEGORIES PC, MGMT_POLICY_ASSOC PA, MGMT_POLICY_ASSOC_CFG PAC, MGMT_POLICY_ASSOC_CFG_PARAMS PACP, MGMT_POLICY_PARAMETERS
PP, (SELECT MESSAGE, MESSAGE_ID FROM MGMT_MESSAGES WHERE SUBSYSTEM = 'POLICY' AND LANGUAGE_CODE = :B11 AND COUNTRY_CODE = :B10 ) MSG, (SELECT MESSAGE, MESSAGE_ID FROM MGMT_MESSAGES WHERE SUBSYSTEM = 'POLICY' AND LANGUAGE_CODE = 'en' AND COUNTRY_CODE = ' ') EMSG, (SELECT MESSAGE, MESSAGE_ID FROM MGMT_MESSAGES WHERE SUBSYSTEM = 'POLICY' AND LANGUAGE_CODE = :B11 AND COUNTRY_CODE = :B10 ) MSGDESC, (SELECT MESSAGE, MESSAGE_ID FROM MGMT_MESSAGES WHERE SUBSYSTEM = 'POLICY' AND LANGUAGE_CODE = 'en' AND COUNTRY_CODE = ' ') EMSGDESC, (SELECT MESSAGE, MESSAGE_ID FROM MGMT_MESSAGES WHERE SUBSYSTEM = 'CATEGORY' AND LANGUAGE_CODE = :B11 AND COUNTRY_CODE = :B10 ) MSGCAT, (SELECT MESSAGE, MESSAGE_ID FROM MGMT_MESSAGES WHERE SUBSYSTEM = 'CATEGORY' AND LANGUAGE_CODE = 'en' AND COUNTRY_CODE = ' ') EMSGCAT, (SELECT MESSAGE, MESSAGE_ID FROM MGMT_MESSAGES WHERE SUBSYSTEM = 'POLICY' AND LANGUAGE_CODE = :B11 AND COUNTRY_CODE = :B10 ) MSGPARAM, (SELECT MESSAGE, MESSAGE_ID FROM MGMT_MESSAGES WH
ERE SUBSYSTEM = 'POLICY' AND LANGUAGE_CODE = 'en' AND COUNTRY_CODE = ' ') EMSGPARAM, MGMT_POLICY_ASSOC_CFG_PARAMS DPACP, MGMT_METRICS_COMPOSITE_KEYS COMPKEYS, (SELECT P.POLICY_GUID, M.METRIC_GUID AS AGENT_SIDE_METRIC_GUID, M.METRIC_NAME AS AGENT_SIDE_METRIC_NAME, M.METRIC_LABEL AS AGENT_SIDE_METRIC_LABEL, M.METRIC_LABEL_NLSID AS AGENT_SIDE_METRIC_LABEL_NLSID FROM MGMT_POLICIES P, MGMT_SNAPSHOT_METRIC_MAP S, MGMT_METRICS M, MGMT_COLLECTION_METRIC_TASKS CMT WHERE P.TARGET_TYPE = :B8 AND P.POLICY_TYPE = :B9 AND S.SNAPSHOT_TARGET_TYPE = :B8 AND S.METRIC_GUID = P.METRIC_GUID AND M.TARGET_TYPE = :B8 AND M.TYPE_META_VER = :B7 AND (M.CATEGORY_PROP_1 = :B6 OR M.CATEGORY_PROP_1 = ' ') AND (M.CATEGORY_PROP_2 = :B5 OR M.CATEGORY_PROP_2 = ' ') AND (M.CATEGORY_PROP_3 = :B4 OR M.CATEGORY_PROP_3 = ' ') AND (M.CATEGORY_PROP_4 = :B3 OR M.CATEGORY_PROP_4 = ' ') AND (M.CATEGORY_PROP_5 = :B2 OR M.CATEGORY_PROP_5 = ' ') AND CMT.TARGET_GUID = :B1 AND CMT.COLL_NAME = S.SNAPSHOT_NAME AND CMT.METRIC_GU
ID = M.METRIC_GUID) AM WHERE MET.TARGET_TYPE = :B8 AND MET.TYPE_META_VER = :B7 AND (MET.CATEGORY_PROP_1 = :B6 OR MET.CATEGORY_PROP_1 = ' ') AND (MET.CATEGORY_PROP_2 = :B5 OR MET.CATEGORY_PROP_2 = ' ') AND (MET.CATEGORY_PROP_3 = :B4 OR MET.CATEGORY_PROP_3 = ' ') AND (MET.CATEGORY_PROP_4 = :B3 OR MET.CATEGORY_PROP_4 = ' ') AND (MET.CATEGORY_PROP_5 = :B2 OR MET.CATEGORY_PROP_5 = ' ') AND P.METRIC_GUID = MET.METRIC_GUID AND P.POLICY_TYPE = :B9 AND P.TARGET_TYPE = :B8 AND P.POLICY_GUID = PCM.OBJECT_GUID (+) AND :B14 = PCM.CLASS_NAME (+) AND PCM.CATEGORY_NAME = PC.CATEGORY_NAME (+) AND PA.OBJECT_GUID = :B1 AND PA.POLICY_GUID = P.POLICY_GUID AND PA.OBJECT_TYPE = :B13 AND PA.OBJECT_GUID = PAC.OBJECT_GUID AND PAC.POLICY_GUID = PA.POLICY_GUID AND PAC.COLL_NAME = PA.COLL_NAME AND PAC.OBJECT_GUID = PACP.OBJECT_GUID (+) AND PAC.POLICY_GUID = PACP.POLICY_GUID (+) AND PAC.COLL_NAME = PACP.COLL_NAME (+) AND PAC.KEY_VALUE = PACP.KEY_VALUE (+) AND PAC.KEY_OPERATOR = PACP.KEY_OPERATOR (+) AND PACP.POLICY
_GUID = PP.POLICY_GUID (+) AND PACP.PARAM_NAME = PP.PARAM_NAME (+) AND :B12 = DPACP.OBJECT_GUID (+) AND PACP.POLICY_GUID = DPACP.POLICY_GUID (+) AND PACP.COLL_NAME = DPACP.COLL_NAME (+) AND PACP.KEY_VALUE = DPACP.KEY_VALUE (+) AND PACP.KEY_OPERATOR = DPACP.KEY_OPERATOR (+) AND PACP.PARAM_NAME = DPACP.PARAM_NAME (+) AND PAC.KEY_VALUE = COMPKEYS.COMPOSITE_KEY (+) AND PAC.OBJECT_GUID = COMPKEYS.TARGET_GUID(+) AND P.POLICY_GUID = AM.POLICY_GUID (+) AND MSG.MESSAGE_ID(+) = P.POLICY_LABEL_NLSID AND EMSG.MESSAGE_ID(+) = P.POLICY_LABEL_NLSID AND MSGDESC.MESSAGE_ID(+) = P.DESCRIPTION_NLSID AND EMSGDESC.MESSAGE_ID(+) = P.DESCRIPTION_NLSID AND MSGCAT.MESSAGE_ID(+) = PC.CATEGORY_NAME_NLSID AND EMSGCAT.MESSAGE_ID(+) = PC.CATEGORY_NAME_NLSID AND MSGPARAM.MESSAGE_ID(+) = PP.PARAM_NAME_NLSID AND EMSGPARAM.MESSAGE_ID(+) = PP.PARAM_NAME_NLSID UNION SELECT MET.METRIC_NAME, MET.METRIC_LABEL, MET.METRIC_LABEL_NLSID, MET.METRIC_COLUMN, MET.COLUMN_LABEL, MET.COLUMN_LABEL_NLSID, MET.METRIC_TYPE, MET.NU
M_KEYS, MET.KEY_COLUMN, MET.IS_REPOSITORY, MET.IS_TRANSPOSED, MET.HAS_PUSH, MET.HAS_PULL, MET.REMOTE, MET.NON_THRESHOLDED_ALERTS, MET.KEYONLY_THRESHOLDS, MET.METRIC_GUID AS POLICY_GUID, MET.METRIC_COLUMN AS POLICY_NAME, NULL AS POLICY_NAME_DISPLAY, TABLEMET.METRIC_GUID, :B17 AS POLICY_TYPE, NULL AS POLICY_LABEL_NLSID, NULL AS DESCRIPTION, NULL AS VIOLATION_LEVEL, :B16 AS CONDITION_TYPE, MET.METRIC_COLUMN AS CONDITION, PAC.CONDITION_OPERATOR, PAC.MESSAGE, PAC.MESSAGE_NLSID, PAC.CLEAR_MESSAGE, PAC.CLEAR_MESSAGE_NLSID, NULL AS DETAILED_URL_LINK, NULL AS OWNER, NULL AS CATEGORY, NULL AS CATEGORY_DISPLAY, PA.COLL_NAME, PA.IS_ENABLED, PA.ADD_OR_DELETE, PAC.KEY_VALUE, PAC.KEY_OPERATOR, PAC.EVAL_ORDER, PAC.IS_EXCEPTION, PAC.IS_PUSH, PAC.HAS_ACTIVE_BASELINE, PAC.PREVENT_OVERRIDE, PAC.CRIT_ACTION_JOB_ID, PAC.WARN_ACTION_JOB_ID, PAC.INFO_ACTION_JOB_ID, TRIM(PAC.FIXIT_JOB) AS FIXIT_JOB, PAC.SIMULTANEOUS_ACTIONS, PAC.IMPORTANCE, PAC.NUM_OCCURRENCES, PACP
.PARAM_NAME, NULL AS PARAM_NAME_DISPLAY, NULL AS PARAM_TYPE, PACP.CRIT_THRESHOLD, PACP.WARN_THRESHOLD, PACP.INFO_THRESHOLD, NULL AS DEFAULT_CRIT_THRESHOLD, NULL AS DEFAULT_WARN_THRESHOLD, NULL AS DEFAULT_INFO_THRESHOLD, COMPKEYS.KEY_PART1_VALUE, COMPKEYS.KEY_PART2_VALUE, COMPKEYS.KEY_PART3_VALUE, COMPKEYS.KEY_PART4_VALUE, COMPKEYS.KEY_PART5_VALUE, NULL AS AGENT_SIDE_METRIC_GUID, NULL AS AGENT_SIDE_METRIC_NAME, NULL AS AGENT_SIDE_METRIC_LABEL, NULL AS AGENT_SIDE_METRIC_LABEL_NLSID FROM MGMT_METRICS MET, (SELECT METRIC_NAME, METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B8 AND USAGE_TYPE = :B15 AND TYPE_META_VER = :B7 AND (CATEGORY_PROP_1 = :B6 OR CATEGORY_PROP_1 = ' ') AND (CATEGORY_PROP_2 = :B5 OR CATEGORY_PROP_2 = ' ') AND (CATEGORY_PROP_3 = :B4 OR CATEGORY_PROP_3 = ' ') AND (CATEGORY_PROP_4 = :B3 OR CATEGORY_PROP_4 = ' ') AND (CATEGORY_PROP_5 = :B2 OR CATEGORY_PROP_5 = ' ') AND METRIC_COLUMN = ' ') TABLEMET, MGMT_POLICY_ASSOC PA, MGMT_POLICY_ASSOC_CFG PAC,
MGMT_POLICY_ASSOC_CFG_PARAMS PACP, (SELECT COMPOSITE_KEY, KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE FROM MGMT_METRICS_COMPOSITE_KEYS WHERE TARGET_GUID = :B1 ) COMPKEYS WHERE MET.TARGET_TYPE = :B8 AND MET.USAGE_TYPE = :B15 AND MET.TYPE_META_VER = :B7 AND (MET.CATEGORY_PROP_1 = :B6 OR MET.CATEGORY_PROP_1 = ' ') AND (MET.CATEGORY_PROP_2 = :B5 OR MET.CATEGORY_PROP_2 = ' ') AND (MET.CATEGORY_PROP_3 = :B4 OR MET.CATEGORY_PROP_3 = ' ') AND (MET.CATEGORY_PROP_4 = :B3 OR MET.CATEGORY_PROP_4 = ' ') AND (MET.CATEGORY_PROP_5 = :B2 OR MET.CATEGORY_PROP_5 = ' ') AND MET.METRIC_NAME = TABLEMET.METRIC_NAME AND PA.OBJECT_GUID = :B1 AND PA.OBJECT_GUID = PAC.OBJECT_GUID AND PA.POLICY_GUID = MET.METRIC_GUID AND PA.OBJECT_TYPE = :B13 AND PAC.POLICY_GUID = PA.POLICY_GUID AND PAC.COLL_NAME = PA.COLL_NAME AND PAC.OBJECT_GUID = PACP.OBJECT_GUID AND PAC.POLICY_GUID = PACP.POLICY_GUID AND PAC.COLL_NAME = PACP.COLL_NAME AND PAC.KEY_VALUE = PACP.KEY_VALUE AND PAC.KEY
_OPERATOR = PACP.KEY_OPERATOR AND PAC.KEY_VALUE = COMPKEYS.COMPOSITE_KEY (+) ORDER BY POLICY_TYPE, POLICY_GUID, EVAL_ORDER, KEY_VALUE |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| cr4vjagmymqgm | select * from ana_PageRankModule a where rankContentClass = 'ÈÈÃŻ' and pageRankSiteId=7 and radarwebsiteid=3 |
| cyvm5a3hqfh6c | update sens_sensitive set provinceId=:1, radarWebSiteId=:2, assetId=:3, secondProvinceId=:4, tweetId=:5, tweetBigId=:6, userCode=:7, source=:8, createDate=:9, tweetText=:10, location=:11, urlhash=:12, keywords=:13, publishFrom=:14, thumbnailPicUrl=:15, originalPicUrl=:16, retweetsCount=:17, commentsCount=:18, retweetId=:19, creator=:20, useType=:21, verified=:22, isAppraise=:23, tweetType=:24, sameAssetCount=:25, recordCreationDate=:26 where sensitiveId=:27 |
| d15cdr0zt3vtp | SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') AS curr_timestamp, COUNT(username) AS failed_count FROM sys.dba_audit_session WHERE returncode != 0 AND TO_CHAR(timestamp, 'YYYY-MM-DD HH24:MI:SS') >= TO_CHAR(current_timestamp - TO_DSINTERVAL('0 0:30:00'), 'YYYY-MM-DD HH24:MI:SS') |
| d99ryh86tzuxy | select * from ana_PageRankModule a where rankContentClass = '¸øÁ¦ÍƼö' and pageRankSiteId=7 and radarwebsiteid=3 |
| ddn6tazv76ndd | select * from app_AssetUpdateQueue_Temp a where updateAssetId = :1 and tweetType = :2 |
| dfwtcs5xmwt41 | insert into app_AssetUpdateQueue_Temp ( updateAssetId, tweetId, tweetType, radarWebSiteId, createDate ) values ( :1, :2, :3, :4, sysdate ) |
| 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 |
| fxwvrzcddjxws | select * from ana_PageRankModule a where rankContentClass = 'ʱÊÂÐÂÎÅ' and pageRankSiteId=7 and radarwebsiteid=3 |
| g8vfu28snnt3r | select /*+ first_rows */ * from app_AssetMain a where a.tweetId = :1 and a.radarWebSiteId=:2 |
| gaxcmpr56x2u3 | select table_a.*, rownum from (select * from app_AssetUpdateQueue_Temp a where a.radarWebSiteId=:1 and a.tweetType=:2 order by CreateDate ASC) table_a where rownum<=100 |
| gc187n90hbvnz | select * from ana_PageRankModule a where rankContentClass = 'ÎÄ»¯½ÌÓý' and pageRankSiteId=7 and radarwebsiteid=3 |
| 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) |
| Statistic | Total | per Second | per Trans |
|---|
| Batched IO (bound) vector count | 16 | 0.00 | 0.00 |
| Batched IO (full) vector count | 0 | 0.00 | 0.00 |
| Batched IO (space) vector count | 0 | 0.00 | 0.00 |
| Batched IO block miss count | 299 | 0.04 | 0.00 |
| Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
| Batched IO double miss count | 1 | 0.00 | 0.00 |
| Batched IO same unit count | 156 | 0.02 | 0.00 |
| Batched IO single block count | 2 | 0.00 | 0.00 |
| Batched IO slow jump count | 0 | 0.00 | 0.00 |
| Batched IO vector block count | 142 | 0.02 | 0.00 |
| Batched IO vector read count | 16 | 0.00 | 0.00 |
| Block Cleanout Optim referenced | 158,624 | 21.99 | 0.12 |
| CCursor + sql area evicted | 8,593 | 1.19 | 0.01 |
| CPU used by this session | 257,484 | 35.69 | 0.19 |
| CPU used when call started | 254,561 | 35.28 | 0.19 |
| CR blocks created | 131,584 | 18.24 | 0.10 |
| Cached Commit SCN referenced | 8,682 | 1.20 | 0.01 |
| Commit SCN cached | 65,429 | 9.07 | 0.05 |
| DBWR checkpoint buffers written | 999,285 | 138.50 | 0.74 |
| DBWR checkpoints | 36 | 0.00 | 0.00 |
| DBWR object drop buffers written | 0 | 0.00 | 0.00 |
| DBWR revisited being-written buffer | 2,357 | 0.33 | 0.00 |
| DBWR tablespace checkpoint buffers written | 803 | 0.11 | 0.00 |
| DBWR thread checkpoint buffers written | 998,482 | 138.39 | 0.74 |
| DBWR transaction table writes | 187 | 0.03 | 0.00 |
| DBWR undo block writes | 356,259 | 49.38 | 0.26 |
| HSC Heap Segment Block Changes | 5,087,487 | 705.12 | 3.78 |
| Heap Segment Array Inserts | 2,758 | 0.38 | 0.00 |
| Heap Segment Array Updates | 16,524 | 2.29 | 0.01 |
| IMU CR rollbacks | 52,626 | 7.29 | 0.04 |
| IMU Flushes | 467,673 | 64.82 | 0.35 |
| IMU Redo allocation size | 617,705,676 | 85,613.34 | 459.02 |
| IMU commits | 835,102 | 115.74 | 0.62 |
| IMU contention | 435,876 | 60.41 | 0.32 |
| IMU ktichg flush | 0 | 0.00 | 0.00 |
| IMU pool not allocated | 85,853 | 11.90 | 0.06 |
| IMU recursive-transaction flush | 51 | 0.01 | 0.00 |
| IMU undo allocation size | 1,813,488,488 | 251,347.56 | 1,347.60 |
| IMU- failed to get a private strand | 85,853 | 11.90 | 0.06 |
| LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
| Misses for writing mapping | 0 | 0.00 | 0.00 |
| Number of read IOs issued | 7,437 | 1.03 | 0.01 |
| Requests to/from client | 7,782,356 | 1,078.63 | 5.78 |
| RowCR - row contention | 764 | 0.11 | 0.00 |
| RowCR attempts | 10,511 | 1.46 | 0.01 |
| RowCR hits | 9,098 | 1.26 | 0.01 |
| SMON posted for dropping temp segment | 0 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 159 | 0.02 | 0.00 |
| SQL*Net roundtrips to/from client | 7,782,409 | 1,078.63 | 5.78 |
| TBS Extension: bytes extended | 10,485,760 | 1,453.32 | 7.79 |
| TBS Extension: files extended | 1 | 0.00 | 0.00 |
| TBS Extension: tasks created | 1 | 0.00 | 0.00 |
| TBS Extension: tasks executed | 1 | 0.00 | 0.00 |
| active txn count during cleanout | 922,714 | 127.89 | 0.69 |
| auto extends on undo tablespace | 0 | 0.00 | 0.00 |
| background checkpoints completed | 29 | 0.00 | 0.00 |
| background checkpoints started | 32 | 0.00 | 0.00 |
| background timeouts | 37,459 | 5.19 | 0.03 |
| branch node splits | 184 | 0.03 | 0.00 |
| buffer is not pinned count | 12,725,230 | 1,763.70 | 9.46 |
| buffer is pinned count | 84,790,028 | 11,751.81 | 63.01 |
| bytes received via SQL*Net from client | 2,495,374,645 | 345,856.25 | 1,854.31 |
| bytes sent via SQL*Net to client | 1,908,962,868 | 264,580.21 | 1,418.55 |
| calls to get snapshot scn: kcmgss | 8,013,338 | 1,110.64 | 5.95 |
| calls to kcmgas | 1,600,489 | 221.83 | 1.19 |
| calls to kcmgcs | 5,504,779 | 762.96 | 4.09 |
| cell physical IO interconnect bytes | 25,048,115,712 | 3,471,642.00 | 18,613.27 |
| change write time | 12,120 | 1.68 | 0.01 |
| cleanout - number of ktugct calls | 970,454 | 134.50 | 0.72 |
| cleanouts and rollbacks - consistent read gets | 52,394 | 7.26 | 0.04 |
| cleanouts only - consistent read gets | 27,232 | 3.77 | 0.02 |
| cluster key scan block gets | 17,951 | 2.49 | 0.01 |
| cluster key scans | 16,934 | 2.35 | 0.01 |
| commit batch performed | 0 | 0.00 | 0.00 |
| commit batch requested | 0 | 0.00 | 0.00 |
| commit batch/immediate performed | 860 | 0.12 | 0.00 |
| commit batch/immediate requested | 860 | 0.12 | 0.00 |
| commit cleanout failures: block lost | 0 | 0.00 | 0.00 |
| commit cleanout failures: buffer being written | 160 | 0.02 | 0.00 |
| commit cleanout failures: callback failure | 5,096 | 0.71 | 0.00 |
| commit cleanout failures: cannot pin | 48,922 | 6.78 | 0.04 |
| commit cleanouts | 5,764,025 | 798.89 | 4.28 |
| commit cleanouts successfully completed | 5,709,847 | 791.38 | 4.24 |
| commit immediate performed | 860 | 0.12 | 0.00 |
| commit immediate requested | 860 | 0.12 | 0.00 |
| commit txn count during cleanout | 549,298 | 76.13 | 0.41 |
| consistent changes | 277,388 | 38.45 | 0.21 |
| consistent gets | 172,155,696 | 23,860.59 | 127.93 |
| consistent gets - examination | 13,447,522 | 1,863.81 | 9.99 |
| consistent gets direct | 841,004 | 116.56 | 0.62 |
| consistent gets from cache | 171,314,691 | 23,744.03 | 127.30 |
| consistent gets from cache (fastpath) | 134,140,937 | 18,591.79 | 99.68 |
| cursor authentications | 45,265 | 6.27 | 0.03 |
| data blocks consistent reads - undo records applied | 186,051 | 25.79 | 0.14 |
| db block gets | 53,744,453 | 7,448.92 | 39.94 |
| db block gets direct | 1,766 | 0.24 | 0.00 |
| db block gets from cache | 53,742,682 | 7,448.68 | 39.94 |
| db block gets from cache (fastpath) | 12,325,193 | 1,708.26 | 9.16 |
| deferred (CURRENT) block cleanout applications | 1,705,813 | 236.42 | 1.27 |
| dirty buffers inspected | 830 | 0.12 | 0.00 |
| enqueue conversions | 10,170 | 1.41 | 0.01 |
| enqueue releases | 5,392,058 | 747.33 | 4.01 |
| enqueue requests | 5,392,108 | 747.34 | 4.01 |
| enqueue timeouts | 7 | 0.00 | 0.00 |
| enqueue waits | 1,138,579 | 157.81 | 0.85 |
| exchange deadlocks | 92 | 0.01 | 0.00 |
| failed probes on index block reclamation | 38 | 0.01 | 0.00 |
| file io service time | 0 | 0.00 | 0.00 |
| free buffer inspected | 333,986 | 46.29 | 0.25 |
| free buffer requested | 764,369 | 105.94 | 0.57 |
| heap block compress | 60,265 | 8.35 | 0.04 |
| hot buffers moved to head of LRU | 301,325 | 41.76 | 0.22 |
| immediate (CR) block cleanout applications | 79,626 | 11.04 | 0.06 |
| immediate (CURRENT) block cleanout applications | 285,433 | 39.56 | 0.21 |
| index crx upgrade (positioned) | 12,012 | 1.66 | 0.01 |
| index crx upgrade (prefetch) | 5 | 0.00 | 0.00 |
| index fast full scans (full) | 2,784 | 0.39 | 0.00 |
| index fetch by key | 1,859,292 | 257.70 | 1.38 |
| index scans kdiixs1 | 3,700,585 | 512.90 | 2.75 |
| leaf node 90-10 splits | 4,382 | 0.61 | 0.00 |
| leaf node splits | 47,180 | 6.54 | 0.04 |
| lob reads | 246 | 0.03 | 0.00 |
| lob writes | 405 | 0.06 | 0.00 |
| lob writes unaligned | 359 | 0.05 | 0.00 |
| logical read bytes from cache | 1,843,669,049,344 | 255,530,554.53 | 1,370,031.39 |
| max cf enq hold time | 210 | 0.03 | 0.00 |
| messages received | 2,094,268 | 290.26 | 1.56 |
| messages sent | 2,094,271 | 290.26 | 1.56 |
| min active SCN optimization applied on CR | 125,186 | 17.35 | 0.09 |
| no buffer to keep pinned count | 0 | 0.00 | 0.00 |
| no work - consistent read gets | 153,451,260 | 21,268.18 | 114.03 |
| non-idle wait count | 16,900,627 | 2,342.41 | 12.56 |
| parse count (describe) | 6 | 0.00 | 0.00 |
| parse count (failures) | 135 | 0.02 | 0.00 |
| parse count (hard) | 102,693 | 14.23 | 0.08 |
| parse time cpu | 20,663 | 2.86 | 0.02 |
| physical read IO requests | 87,085 | 12.07 | 0.06 |
| physical read bytes | 7,545,069,568 | 1,045,738.56 | 5,606.74 |
| physical read total IO requests | 147,835 | 20.49 | 0.11 |
| physical read total bytes | 8,533,179,392 | 1,182,689.52 | 6,341.01 |
| physical read total multi block requests | 6,576 | 0.91 | 0.00 |
| physical reads cache | 80,025 | 11.09 | 0.06 |
| physical reads cache prefetch | 647 | 0.09 | 0.00 |
| physical reads direct | 841,004 | 116.56 | 0.62 |
| physical reads direct (lob) | 959 | 0.13 | 0.00 |
| physical reads direct temporary tablespace | 755 | 0.10 | 0.00 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 462,283 | 64.07 | 0.34 |
| physical write bytes | 8,691,023,872 | 1,204,566.60 | 6,458.30 |
| physical write total IO requests | 876,818 | 121.53 | 0.65 |
| physical write total bytes | 16,514,936,320 | 2,288,952.48 | 12,272.26 |
| physical write total multi block requests | 39,775 | 5.51 | 0.03 |
| physical writes direct | 1,766 | 0.24 | 0.00 |
| physical writes direct (lob) | 1,420 | 0.20 | 0.00 |
| physical writes direct temporary tablespace | 711 | 0.10 | 0.00 |
| physical writes from cache | 1,059,150 | 146.80 | 0.79 |
| physical writes non checkpoint | 469,783 | 65.11 | 0.35 |
| pinned buffers inspected | 13 | 0.00 | 0.00 |
| pinned cursors current | 11 | 0.00 | 0.00 |
| prefetch clients - default | 0 | 0.00 | 0.00 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 0 | 0.00 | 0.00 |
| process last non-idle time | 7,342 | 1.02 | 0.01 |
| recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
| recursive calls | 4,081,194 | 565.65 | 3.03 |
| recursive cpu usage | 21,675 | 3.00 | 0.02 |
| redo blocks checksummed by FG (exclusive) | 4,621,019 | 640.47 | 3.43 |
| redo blocks written | 15,201,587 | 2,106.92 | 11.30 |
| redo buffer allocation retries | 365 | 0.05 | 0.00 |
| redo entries | 17,411,715 | 2,413.25 | 12.94 |
| redo log space requests | 65,098 | 9.02 | 0.05 |
| redo ordering marks | 20,383 | 2.83 | 0.02 |
| redo size for direct writes | 37,728 | 5.23 | 0.03 |
| redo subscn max counts | 63,461 | 8.80 | 0.05 |
| redo synch long waits | 3 | 0.00 | 0.00 |
| redo synch time | 6,520,315 | 903.71 | 4.85 |
| redo synch time (usec) | 65,202,126,953 | 9,036,944.92 | 48,451.73 |
| redo synch time overhead (usec) | 192,683,672 | 26,705.75 | 143.18 |
| redo synch time overhead count (<128 msec) | 3 | 0.00 | 0.00 |
| redo synch time overhead count (<2 msec) | 1,388,131 | 192.39 | 1.03 |
| redo synch time overhead count (<32 msec) | 6 | 0.00 | 0.00 |
| redo synch time overhead count (<8 msec) | 17 | 0.00 | 0.00 |
| redo synch time overhead count (>=128 msec) | 0 | 0.00 | 0.00 |
| redo synch writes | 1,388,170 | 192.40 | 1.03 |
| redo wastage | 109,958,868 | 15,240.18 | 81.71 |
| redo write info find | 1,388,168 | 192.40 | 1.03 |
| redo write info find fail | 11 | 0.00 | 0.00 |
| redo write time | 497,164 | 68.91 | 0.37 |
| redo writes | 238,492 | 33.05 | 0.18 |
| remote Oradebug requests | 3 | 0.00 | 0.00 |
| rollback changes - undo records applied | 4,126 | 0.57 | 0.00 |
| rollbacks only - consistent read gets | 75,497 | 10.46 | 0.06 |
| root node splits | 0 | 0.00 | 0.00 |
| rows fetched via callback | 427,444 | 59.24 | 0.32 |
| session connect time | 0 | 0.00 | 0.00 |
| shared hash latch upgrades - no wait | 892,722 | 123.73 | 0.66 |
| shared hash latch upgrades - wait | 9,238 | 1.28 | 0.01 |
| sorts (memory) | 1,994,497 | 276.44 | 1.48 |
| sorts (rows) | 92,115,445 | 12,767.10 | 68.45 |
| sql area evicted | 97,554 | 13.52 | 0.07 |
| sql area purged | 129 | 0.02 | 0.00 |
| summed dirty queue length | 1,118 | 0.15 | 0.00 |
| switch current to new buffer | 98,907 | 13.71 | 0.07 |
| table fetch by rowid | 44,944,357 | 6,229.24 | 33.40 |
| table fetch continued row | 468,175 | 64.89 | 0.35 |
| table scan blocks gotten | 143,192,723 | 19,846.36 | 106.41 |
| table scan rows gotten | 17,235,113,949 | 2,388,768.32 | 12,807.42 |
| table scans (direct read) | 4 | 0.00 | 0.00 |
| table scans (long tables) | 4 | 0.00 | 0.00 |
| table scans (short tables) | 1,513,030 | 209.70 | 1.12 |
| total cf enq hold time | 34,920 | 4.84 | 0.03 |
| total number of cf enq holders | 7,393 | 1.02 | 0.01 |
| total number of times SMON posted | 188 | 0.03 | 0.00 |
| transaction rollbacks | 851 | 0.12 | 0.00 |
| transaction tables consistent read rollbacks | 46 | 0.01 | 0.00 |
| transaction tables consistent reads - undo records applied | 57,274 | 7.94 | 0.04 |
| undo change vector size | 2,595,836,844 | 359,780.20 | 1,928.97 |
| user logons cumulative | 16,259 | 2.25 | 0.01 |
| user logouts cumulative | 16,233 | 2.25 | 0.01 |
| write clones created in background | 5 | 0.00 | 0.00 |
| write clones created in foreground | 15,000 | 2.08 | 0.01 |