| SQL Id | SQL Text |
|---|
| 04p9rnacfgfsn | INSERT INTO sys.wri$_adv_objects (task_id, id, type, attr1, attr2, attr3, attr4, attr5)VALUES(:1, :2, :3, :4, :5, :6, ' ', :7) RETURNING rowid into :8 |
| 05xcf43d9psvm | SELECT NVL(SUM(FAILURES), 0) FROM SYS.DBA_QUEUE_SCHEDULES |
| 0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 0v3dvmc22qnam | insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time) |
| 10xj8nynmpqtq | ** SQL Text Not Available ** |
| 14566d856s6hs | ** SQL Text Not Available ** |
| 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)) |
| 19v5guvsgcd1v | SELECT C.TARGET_GUID, C.METRIC_GUID, C.STORE_METRIC, C.SCHEDULE, C.COLL_NAME, M.METRIC_NAME, M.EVAL_FUNC FROM MGMT_METRIC_COLLECTIONS_REP R, MGMT_METRIC_COLLECTIONS C, MGMT_METRICS M WHERE C.SUSPENDED = 0 AND C.IS_REPOSITORY = 1 AND (C.LAST_COLLECTED_TIMESTAMP IS NULL OR C.LAST_COLLECTED_TIMESTAMP + C.SCHEDULE / 1440 < SYSDATE) AND C.METRIC_GUID = M.METRIC_GUID AND R.TARGET_GUID = C.TARGET_GUID AND R.METRIC_GUID = C.METRIC_GUID AND R.COLL_NAME = C.COLL_NAME |
| 1ghaps5tp4wbn | BEGIN
SYS.KUPW$WORKER.MAIN('SYS_EXPORT_TABLE_01', 'SMMDB');
END;
|
| 1yyh2fdqqguz8 | INSERT INTO sys.wri$_adv_findings (id, task_id, type, parent, obj_id, impact_msg_id, impact_val, msg_id, more_info_id) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9) |
| 298ppdduqr7wm | SELECT status FROM sys.wri$_adv_tasks WHERE id = :1 |
| 2bq8dq4hnkgz5 | SELECT COUNT(*) FROM USER_BALACE WHERE BAK_CMMC = TRIM(:B4 ) AND ORG_ID = TRIM(:B3 ) AND TRANS_CMMC_ID = TRIM(:B2 ) AND F_ID = TRIM(:B1 ) AND ROWNUM < 2 |
| 350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
| 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 |
| 3m8smr0v7v1m6 | INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13) |
| 3pp09z2xhs5m3 | SELECT NVL(SUM(TOTAL_ATV), 0) FROM USER_BALACE WHERE F_ID = TRIM(:B1 ) AND LENGTH(ORG_ID) = 3 |
| 43c5ykm1mcp2a | begin dbms_application_info.set_module(:1, :2); dbms_application_info.set_client_info(:3); dbms_session.set_identifier(:4); end; |
| 46j11dddakvw8 | /* OracleOEM */
DECLARE
is_ols_enabled NUMBER :=0;
TYPE data_cursor_type IS REF CURSOR;
data_cursor data_cursor_type;
sqlQuery varchar2(200);
BEGIN
SELECT COUNT(*) INTO is_ols_enabled FROM
DBA_USERS WHERE UPPER(USERNAME)='LBACSYS';
IF is_ols_enabled > 0 THEN
sqlQuery:= 'SELECT SCHEMA_NAME, TABLE_NAME, POLICY_NAME, TABLE_OPTIONS' ||
' FROM LBACSYS.DBA_SA_TABLE_POLICIES';
ELSE
sqlQuery:= 'select * from dual where 0=1';--to return an empty cursor
END IF;
OPEN data_cursor FOR sqlQuery;
:1 := data_cursor;
END;
|
| 4vam3carp3uu7 | begin PKG_VIEW.proc_VIEW(o_nRet=>:o_nRet, pErrMsg=>:pErrMsg); end; |
| 54c6mtzfsv8kw | SELECT T.ROWID, T.* FROM T_OP T WHERE T.DEALFLAG = '0' AND T.DETAILFLAG = '1' AND ROWNUM < 10001 |
| 5a1j61u6hy9dy | select module, count(*) from v$active_session_history where sample_time > sysdate - 1/24 and service_hash = :1 group by module order by count(*) desc |
| 5d087cpg8fxj0 | SELECT COUNT(*) FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND BITAND(A.PROPERTY, :B2 ) = :B2 AND A.OWNER# = :B1 |
| 5k2b3qsy3b30r | /* OracleOEM */
WITH blocked_resources AS
(select
id1
, id2
, SUM(ctime) as blocked_secs
, MAX(request) as max_request
, COUNT(1) as blocked_count
from
v$lock
where
request > 0
group by
id1, id2
)
, blockers AS
(select
L.*
, BR.blocked_secs
, BR.blocked_count
from
v$lock L
, blocked_resources BR
where
BR.id1 = L.id1
and BR.id2 = L.id2
and L.lmode > 0
and L.block <> 0
)
select
B.id1||'_'||B.id2||'_'||S.sid||'_'||S.serial# as id
, 'SID, SERIAL:'||S.sid||', '||S.serial#||', LOCK_TYPE:'||B.type||', PROGRAM:'||S.program||', MODULE:'||S.module||', ACTION:'||S.action||', MACHINE:'||S.machine||', OSUSER:'||S.osuser||', USERNAME:'||S.username
as info
, B.blocked_secs
, B.blocked_count
from
v$session S
, blockers B
where
B.sid = S.sid
|
| 5rygsj4dbw6jt | insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7) |
| 64jvrsys6ybn5 | select l.*, o.owner object_owner, o.object_Name
from sys.all_objects o, v$lock l
where l.sid = :sid and l.type = 'TM' and o.object_id = l.id1
|
| 66gs90fyynks7 | insert into wrh$_instance_recovery (snap_id, dbid, instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_VIEWpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt) select :snap_id, :dbid, :instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_VIEWpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt from v$instance_recovery |
| 6b9fj2m1vrk58 | BEGIN
SYS.KUPM$MCP.MAIN('SYS_EXPORT_TABLE_01', 'SMMDB', 'KUPC$C_1_20120405132651', 'KUPC$S_1_20120405132651', 0);
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 |
| 6rkzuugrbf5pp | UPDATE USER_BALACE SET CMMC_MARKET = TRIM(:B17 ), DIST_TYPE = TRIM(:B16 ), TOTAL_ATV = :B15 , FROZ_ATV = :B14 , AVAI_ATV = :B13 , BRANCH_CODE = TRIM(:B12 ), SHARE_CLASS = TRIM(:B11 ), REG_DATE = TRIM(:B10 ), UPDATE_DATE = TRIM(:B9 ), UN_DIST_INCOME = :B8 , UN_DIST_INCOME_FALG=TRIM(:B7 ), CMMC_STATUS = TRIM(:B6 ), GUA_MNT = :B5 WHERE BAK_CMMC = TRIM(:B4 ) AND ORG_ID = TRIM(:B3 ) AND TRANS_CMMC_ID = TRIM(:B2 ) AND F_ID = TRIM(:B1 ) |
| 71y370j6428cb | insert into wrh$_thread (snap_id, dbid, instance_number, thread#, thread_instance_number, status, open_time, current_group#, sequence#) select :snap_id, :dbid, :instance_number, t.thread#, i.instance_number, t.status, t.open_time, t.current_group#, t.sequence# from v$thread t, v$instance i where i.thread#(+) = t.thread# |
| 74aatbc9854g4 | select MAX(sample_time) end_time, case when (TRIM(module) is null) then 'Unnamed' else module end, count(*)/15, trunc(sample_id/15) from v$active_session_history where sample_time > sysdate - 1/24 and service_hash = :1 group by trunc(sample_id/15), module order by end_time, module |
| 76yj9jrkj39cu | ** SQL Text Not Available ** |
| 79uvsz1g1c168 | insert into wrh$_buffer_pool_statistics (snap_id, dbid, instance_number, id, name, block_size, set_msize, cnum_repl, cnum_write, cnum_set, buf_got, sum_write, sum_scan, free_buffer_wait, write_complete_wait, buffer_busy_wait, free_buffer_inspected, dirty_buffers_inspected, db_block_change, db_block_gets, consistent_gets, physical_reads, physical_writes) select :snap_id, :dbid, :instance_number, id, name, block_size, set_msize, cnum_repl, cnum_write, cnum_set, buf_got, sum_write, sum_scan, free_buffer_wait, write_complete_wait, buffer_busy_wait, free_buffer_inspected, dirty_buffers_inspected, db_block_change, db_block_gets, consistent_gets, physical_reads, physical_writes from v$buffer_pool_statistics |
| 7fuc1t4ju3pz0 | ** SQL Text Not Available ** |
| 7h66bd08futqb |
insert into wrh$_sess_time_stats (snap_id, dbid, instance_number, session_type, min_logon_time, sum_cpu_time, sum_sys_io_wait, sum_user_io_wait) select :snap_id, :dbid, :instance_number, type, min(logon_time) min_logon_time, sum(cpu_time) cpu_time, sum(sys_io_wait) sys_io_wait, sum(user_io_wait) user_io_wait from (select sid, serial#, max(type) type, max(logon_time) logon_time, max(cpu_time) cpu_time, sum(case when kslcsclsname = 'System I/O' then kslcstim else 0 end) as sys_io_wait, sum(case when kslcsclsname ='User I/O' then kslcstim else 0 end) as user_io_wait from (select /*+ ordered */ allsids.sid sid, allsids.serial# serial#, max(type) type, max(logon_time) logon_time, sum(kewsval) cpu_time from (select type, allsids.sid, sess.ksuseser as serial#, sess.ksuseltm as logon_time from (select /*+ ordered index(p) */ s.indx as sid, decode(l.role, 'reader', 'Logminer Reader', 'preparer', 'Logminer Preparer', 'builder', 'Logminer Builder') as type from x$logmnr_process l, x$ksupr p, x$ksuse s where l.role in ('reader', 'preparer', 'builder') and l.pid = p.indx and bitand(p.ksspaflg, 1)!=0 and p.ksuprpid = s.ksusepid union all select sid
_knst as sid, decode(type_knst, 8, 'STREAMS Capture', 7, 'STREAMS Apply Reader', 2, 'STREAMS Apply Server', 1, 'STREAMS Apply Coordinator') as type from x$knstcap where type_knst in (8, 7, 2, 1) union all select indx as sid, (case when ksusepnm like '%(q00%)' then 'QMON Slaves' else 'QMON Coordinator' end) as type from x$ksuse where ksusepnm like '%(q00%)' or ksusepnm like '%(QMNC)' union all select kwqpssid as sid, 'Propagation Sender' as type from x$kwqps union all select kwqpdsid as sid, 'Propagation Receiver' as type from x$kwqpd) allsids, x$ksuse sess where bitand(sess.ksspaflg, 1) != 0 and bitand(sess.ksuseflg, 1) != 0 and allsids.sid = sess.indx) allsids, x$kewssesv sesv, x$kewssmap map where allsids.sid = sesv.ksusenum and sesv.kewsnum = map.soffst and map.aggid = 1 and (map.stype = 2 or map.stype = 3) and map.sname in ('DB CPU', 'background cpu time') group by sid, serial#) allaggr, x$kslcs allio where allaggr.sid = allio.kslcssid(+) and allio.kslcsclsname in ('System I/O', 'User I/O') group by allaggr.sid, allaggr.serial#) group by type
|
| 7jnfb51012hsc | UPDATE T_MUNT_OP SET DEALFLAG = '1' WHERE TACNTID = :B3 AND BRANCHCODE = TRIM(:B2 ) AND BAKCODE = TRIM(:B1 ) AND DETAILFLAG = '9' |
| 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 |
| 81ky0n97v4zsg | /* OracleOEM */ select s.sid, s.serial# from v$session s where s.sid = (select sid from v$mystat where rownum=1) |
| 8cuu0uynbrhbn | select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job |
| 8rfhqfbwpss1h | select text from view$ where obj#=:1 |
| 8ws9khwntd0bs | INSERT INTO T_MUNT_OP ( CNTSTATUS, AVAILABLEVOL, BRANCHCODE, DEFDIVIDENDMETHOD, DETAILFLAG, DISTRIBUTORCODE, BAKCODE, GUARANTEEDMNT, SHARECLASS, SHAREREGISTERDATE, SOURCETYPE, TACNTID, TASERIALNO, TOTALFROZENVOL, TOTALVOLOFDISTRIBUTORINTA, TRANSACTIONCNTID, TRANSACTIONCFMDATE, UNDISTRIBUTEMONETARYINCOME, UNDISTRIBUTEMONETARYINCOMEFLAG, DEALFLAG ) SELECT CNTSTATUS, AVAILABLEVOL, BRANCHCODE, DEFDIVIDENDMETHOD, DETAILFLAG, DISTRIBUTORCODE, BAKCODE, GUARANTEEDMNT, SHARECLASS, SHAREREGISTERDATE, SOURCETYPE, TACNTID, TASERIALNO, TOTALFROZENVOL, TOTALVOLOFDISTRIBUTORINTA, TRANSACTIONCNTID, TRANSACTIONCFMDATE, UNDISTRIBUTEMONETARYINCOME, UNDISTRIBUTEMONETARYINCOMEFLAG, '0' FROM T_MNT_IMP |
| 92n4nyngnwvnt | /* OracleOEM */
SELECT SUM(broken), SUM(failed)
FROM (SELECT DECODE(broken, 'N', 0, 1) broken,
DECODE(NVL(failures, 0), 0, 0, 1) failed
FROM dba_jobs
)
|
| 945qvukrux1fb | INSERT INTO T_MUNT_OP ( CNTSTATUS, AVAILABLEVOL, BRANCHCODE, DEFDIVIDENDMETHOD, DETAILFLAG, DISTRIBUTORCODE, BAKCODE, GUARANTEEDMNT, SHARECLASS, SHAREREGISTERDATE, SOURCETYPE, TACNTID, TASERIALNO, TOTALFROZENVOL, TOTALVOLOFDISTRIBUTORINTA, TRANSACTIONCNTID, TRANSACTIONCFMDATE, UNDISTRIBUTEMONETARYINCOME, UNDISTRIBUTEMONETARYINCOMEFLAG, DEALFLAG ) SELECT '0', MXZFES, MXXWDM, '1', '9', '', MXZQDM, 0, (SELECT CHARGE_TYPE FROM BAK_INFO WHERE F_ID = MXZQDM), TO_CHAR(MXFSRQ, 'yyyymmdd'), '', MXGDDM, '', 0, MXZFES, '', TO_CHAR(MXFSRQ, 'yyyymmdd'), 0, '0', '0' FROM DBF_GLRMX |
| 96g93hntrzjtr | select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 |
| 9qgtwh66xg6nz | update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3 |
| a0mv7svv8zvcq | ** SQL Text Not Available ** |
| 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||'%'
|
| ajs2yg50jh2y4 | UPDATE T_MUNT_OP SET DEALFLAG = '1' WHERE ROWID = :B1 |
| akh9zqqkx3wj7 | select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1 |
| aq4js2gkfjru8 | update tsq$ set blocks=:3, maxblocks=:4, grantor#=:5, priv1=:6, priv2=:7, priv3=:8 where ts#=:1 and user#=:2 |
| aq8yqxyyb40nn | update sys.job$ set this_date=:1 where job=:2 |
| b058ymxj1rvkg | SELECT sql_id, sql_text from v$sql WHERE sql_id in (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10) |
| b2gnxm5z6r51n | lock table sys.col_usage$ in exclusive mode nowait |
| b2u9kspucpqwy | SELECT COUNT(*) FROM SYS.DBA_PROPAGATION WHERE ERROR_MESSAGE IS NOT NULL |
| b4scaqd3rcdt1 | UPDATE USER_BALACE SET TOTAL_ATV = 0, FROZ_ATV = 0, AVAI_ATV = 0, UN_DIST_INCOME = 0, GUA_MNT = 0, UPDATE_DATE = :B1 WHERE (CMMC_MARKET = '98' OR F_ID IN (SELECT F_ID FROM BAK_INFO WHERE SUBSTR(CUSTOMIZE_INFO, 7, 1)='1')) AND TOTAL_ATV > 0 |
| bca0rf89ka08k | INSERT INTO T_MNT_IMP (AVAILABLEVOL, TOTALVOLOFDISTRIBUTORINTA, DEFDIVIDENDMETHOD, TRANSACTIONCFMDATE, TOTALFROZENVOL, BAKCODE, BRANCHCODE, TRANSACTIONCNTID, DISTRIBUTORCODE, TACNTID, TASERIALNO, SHARECLASS, DETAILFLAG, CNTSTATUS, SHAREREGISTERDATE, UNDISTRIBUTEMONETARYINCOME, GUARANTEEDMNT, UNDISTRIBUTEMONETARYINCOMEFLAG, SOURCETYPE) VALUES (TO_NUMBER(:"AVAILABLEVOL")/100, TO_NUMBER(:"TOTALVOLOFDISTRIBUTORINTA")/100, :DEFDIVIDENDMETHOD, :TRANSACTIONCFMDATE, TO_NUMBER(:"TOTALFROZENVOL")/100, :BAKCODE, :BRANCHCODE, :TRANSACTIONCNTID, :DISTRIBUTORCODE, TRIM(:"TACNTID"), :TASERIALNO, :SHARECLASS, :DETAILFLAG, :CNTSTATUS, :SHAREREGISTERDATE, TO_NUMBER(:"UNDISTRIBUTEMONETARYINCOME")/100, TO_NUMBER(:"GUARANTEEDMNT")/100, :UNDISTRIBUTEMONETARYINCOMEFLAG, :SOURCETYPE) |
| bggamr1xt3w3j | SELECT event#, sql_id, sql_plan_hash_value, sql_opcode, session_id, session_serial#, module, action, client_id, DECODE(wait_time, 0, 'W', 'C'), 1, time_waited, service_hash, user_id, program, sample_time, p1, p2, p3, current_file#, current_obj#, current_block#, qc_session_id, qc_instance_id, plsql_object_id, plsql_subprogram_id FROM v$active_session_history WHERE sample_time > :1 AND sample_time <= :2 |
| bqfx5q2jas08u | SELECT TASK_LIST.TASK_ID FROM (SELECT /*+ NO_MERGE(T) ORDERED */ T.TASK_ID FROM (SELECT * FROM DBA_ADVISOR_TASKS ORDER BY TASK_ID DESC) T, DBA_ADVISOR_PARAMETERS_PROJ P1, DBA_ADVISOR_PARAMETERS_PROJ P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STATUS = 'COMPLETED' AND T.EXECUTION_START >= (SYSDATE - 1) AND T.HOW_CREATED = 'AUTO' AND T.TASK_ID = P1.TASK_ID AND P1.PARAMETER_NAME = 'INSTANCE' AND P1.PARAMETER_VALUE = SYS_CONTEXT('USERENV', 'INSTANCE') AND T.TASK_ID = P2.TASK_ID AND P2.PARAMETER_NAME = 'DB_ID' AND P2.PARAMETER_VALUE = TO_CHAR(:B1 ) ORDER BY T.TASK_ID DESC) TASK_LIST WHERE ROWNUM = 1 |
| bsa0wjtftg3uw | select file# from file$ where ts#=:1 |
| bunssq950snhf | insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice |
| bx9azjv8rb7bu | SELECT COUNT(*) FROM DBA_USERS WHERE UPPER(USERNAME)='LBACSYS' |
| c085cbnq38u5v | UPDATE T_VIEWMNT_RESULT SET SUC_NUM = SUC_NUM + 1, UPD_NUM = UPD_NUM + 1 WHERE F_ID = TRIM(:B1 ) |
| cgd5z4rq28y6k | SELECT COUNT(*) FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND A.OWNER# = :B2 AND BITAND(A.PROPERTY, :B1 ) = :B1 |
| cgdftfmb26abc | SELECT NVL(SUM(TOTAL_ATV), 0) FROM USER_BALACE A WHERE A.F_ID = :B1 |
| cxjqbfn0d3yqq | SELECT COUNT(*) FROM SYS.DBA_PROPAGATION |
| czj7c4r6q1vr2 |
/* OracleOEM */
select capture_name streams_name, 'capture' streams_type , (available_message_create_time-capture_message_create_time)*86400 latency,
nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture
union all
select dba_propagation.propagation_name streams_name, 'propagation' streams_type, null streams_latency , total_msgs total_messages from gv$propagation_sender, dba_propagation
where source_queue_owner=queue_schema and source_queue_name=queue_name and dblink='"'||destination_queue_owner ||'"' ||'.'||'"' ||destination_queue_name||'"@'||destination_dblink
union all
SELECT apc.apply_name as STREAMS_NAME,
'apply' as STREAMS_TYPE,
CASE WHEN aps.state != 'IDLE' THEN
nvl((aps.apply_time - aps.create_time)*86400, -1)
WHEN apc.state != 'IDLE' THEN
nvl((apc.apply_time - apc.create_time)*86400, -1)
WHEN apr.state != 'IDLE' THEN
nvl((apr.apply_time - apr.create_time)*86400, -1)
ELSE 0
END as STREAMS_LATENCY,
nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES
FROM ( SELECT apply_name,
state,
apply_time,
applied_message_create_time as create_time,
total_messages_applied
FROM ( SELECT apply_name,
state,
apply_time,
applied_message_create_time,
MAX(applied_message_create_time)
OVER (PARTITION BY apply_name)
as max_create_time,
SUM(total_messages_applied)
OVER (PARTITION BY apply_name)
as total_messages_applied
FROM gv$streams_apply_server )
WHERE MAX_CREATE_TIME||'X' =
APPLIED_MESSAGE_CREATE_TIME||'X' ) aps,
( SELECT apply_name,
state,
lwm_time as apply_time,
lwm_message_create_time as create_time
FROM gv$streams_apply_coordinator ) apc,
( SELECT apply_name,
state,
dequeue_time as apply_time,
dequeued_message_create_time as create_time
FROM gv$streams_apply_reader ) apr
WHERE apc.apply_name = apr.apply_name AND
apr.apply_name = aps.apply_name |
| d021z3j124m80 | ** SQL Text Not Available ** |
| d4752nqqywx7a | select oidtext, oidtextlength from typed_view$ where obj# = :1 |
| d92h3rjp0y217 | begin privat_hcdma.auto_execute( :db_id, :inst_id, :end_snap ); end; |
| fqmpmkfr6pqyk | select s.synonym_name object_name, o.object_type
from sys.all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', user)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
|
| 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 |
| g3cbp79cbyprg | SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.IMPACT*100/:B5 IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B4 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') END_TIME FROM DBA_ADVISOR_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 WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND :B2 != 'BASIC' ORDER BY F.FINDING_ID |
| gdn3ysuyssf82 | SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1 |
| gqkp94mxp0s87 | update user$ set name=:2, password=:3, datats#=:4, tempts#=:5, type#=:6, defrole=:7, resource$=:8, ptime=DECODE(to_char(:9, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :9), exptime=DECODE(to_char(:10, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :10), ltime=DECODE(to_char(:11, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :11), astatus=:12, lcount=:13, defschclass=:14, spare1=:15 where user#=:1 |
| grwydz59pu6mc | select text from view$ where rowid=:1 |
| Statistic | Total | per Second | per Trans |
|---|
| CPU used by this session | 13,312 | 3.02 | 2.72 |
| CPU used when call started | 12,527 | 2.84 | 2.56 |
| CR blocks created | 4,094 | 0.93 | 0.84 |
| Cached Commit SCN referenced | 280,810 | 63.72 | 57.41 |
| Commit SCN cached | 3 | 0.00 | 0.00 |
| DB time | 1,674,120 | 379.86 | 342.29 |
| DBWR VIEWpoint buffers written | 45,876 | 10.41 | 9.38 |
| DBWR VIEWpoints | 21 | 0.00 | 0.00 |
| DBWR object drop buffers written | 58 | 0.01 | 0.01 |
| DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
| DBWR tablespace VIEWpoint buffers written | 35 | 0.01 | 0.01 |
| DBWR thread VIEWpoint buffers written | 2 | 0.00 | 0.00 |
| DBWR transaction table writes | 57 | 0.01 | 0.01 |
| DBWR undo block writes | 24,522 | 5.56 | 5.01 |
| IMU CR rollbacks | 4 | 0.00 | 0.00 |
| IMU Flushes | 5,371 | 1.22 | 1.10 |
| IMU Redo allocation size | 39,142,480 | 8,881.58 | 8,002.96 |
| IMU commits | 411 | 0.09 | 0.08 |
| IMU contention | 2 | 0.00 | 0.00 |
| IMU ktichg flush | 19 | 0.00 | 0.00 |
| IMU pool not allocated | 0 | 0.00 | 0.00 |
| IMU recursive-transaction flush | 0 | 0.00 | 0.00 |
| IMU undo allocation size | 8,536,408 | 1,936.94 | 1,745.33 |
| IMU- failed to get a private strand | 0 | 0.00 | 0.00 |
| PX local messages recv'd | 0 | 0.00 | 0.00 |
| PX local messages sent | 0 | 0.00 | 0.00 |
| RowCR - row contention | 12 | 0.00 | 0.00 |
| RowCR attempts | 6,370 | 1.45 | 1.30 |
| RowCR hits | 6,391 | 1.45 | 1.31 |
| SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 13,875 | 3.15 | 2.84 |
| active txn count during cleanout | 14,515 | 3.29 | 2.97 |
| application wait time | 8 | 0.00 | 0.00 |
| background VIEWpoints completed | 1 | 0.00 | 0.00 |
| background VIEWpoints started | 1 | 0.00 | 0.00 |
| background timeouts | 14,010 | 3.18 | 2.86 |
| branch node splits | 8 | 0.00 | 0.00 |
| buffer is not pinned count | 662,063 | 150.22 | 135.36 |
| buffer is pinned count | 9,996,172 | 2,268.17 | 2,043.79 |
| bytes received via SQL*Net from client | 46,277,017 | 10,500.44 | 9,461.67 |
| bytes sent via SQL*Net to client | 2,371,990 | 538.21 | 484.97 |
| calls to get snapshot scn: kcmgss | 1,325,707 | 300.81 | 271.05 |
| calls to kcmgas | 42,901 | 9.73 | 8.77 |
| calls to kcmgcs | 7,363 | 1.67 | 1.51 |
| change write time | 419,608 | 95.21 | 85.79 |
| cleanout - number of ktugct calls | 17,060 | 3.87 | 3.49 |
| cleanouts and rollbacks - consistent read gets | 395 | 0.09 | 0.08 |
| cleanouts only - consistent read gets | 2,524 | 0.57 | 0.52 |
| cluster key scan block gets | 11,695 | 2.65 | 2.39 |
| cluster key scans | 4,184 | 0.95 | 0.86 |
| commit batch performed | 0 | 0.00 | 0.00 |
| commit batch requested | 0 | 0.00 | 0.00 |
| commit batch/immediate performed | 0 | 0.00 | 0.00 |
| commit batch/immediate requested | 0 | 0.00 | 0.00 |
| commit cleanout failures: block lost | 1 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 102 | 0.02 | 0.02 |
| commit cleanout failures: cannot pin | 0 | 0.00 | 0.00 |
| commit cleanouts | 41,228 | 9.35 | 8.43 |
| commit cleanouts successfully completed | 41,125 | 9.33 | 8.41 |
| commit immediate performed | 0 | 0.00 | 0.00 |
| commit immediate requested | 0 | 0.00 | 0.00 |
| commit txn count during cleanout | 5,117 | 1.16 | 1.05 |
| concurrency wait time | 910,935 | 206.69 | 186.25 |
| consistent changes | 103,236 | 23.42 | 21.11 |
| consistent gets | 3,880,564 | 880.52 | 793.41 |
| consistent gets - examination | 2,447,938 | 555.45 | 500.50 |
| consistent gets direct | 54,500 | 12.37 | 11.14 |
| consistent gets from cache | 3,826,064 | 868.15 | 782.27 |
| cursor authentications | 266 | 0.06 | 0.05 |
| data blocks consistent reads - undo records applied | 93,778 | 21.28 | 19.17 |
| db block changes | 2,404,823 | 545.66 | 491.68 |
| db block gets | 1,396,798 | 316.94 | 285.59 |
| db block gets direct | 175 | 0.04 | 0.04 |
| db block gets from cache | 1,396,623 | 316.90 | 285.55 |
| deferred (CURRENT) block cleanout applications | 19,992 | 4.54 | 4.09 |
| dirty buffers inspected | 0 | 0.00 | 0.00 |
| enqueue conversions | 609 | 0.14 | 0.12 |
| enqueue releases | 43,165 | 9.79 | 8.83 |
| enqueue requests | 43,168 | 9.79 | 8.83 |
| enqueue timeouts | 3 | 0.00 | 0.00 |
| enqueue waits | 24 | 0.01 | 0.00 |
| execute count | 1,282,907 | 291.10 | 262.30 |
| failed probes on index block reclamation | 0 | 0.00 | 0.00 |
| free buffer inspected | 43,696 | 9.91 | 8.93 |
| free buffer requested | 45,818 | 10.40 | 9.37 |
| heap block compress | 26,070 | 5.92 | 5.33 |
| hot buffers moved to head of LRU | 13,194 | 2.99 | 2.70 |
| immediate (CR) block cleanout applications | 2,919 | 0.66 | 0.60 |
| immediate (CURRENT) block cleanout applications | 8,559 | 1.94 | 1.75 |
| index crx upgrade (found) | 0 | 0.00 | 0.00 |
| index crx upgrade (positioned) | 1,781 | 0.40 | 0.36 |
| index fast full scans (full) | 16 | 0.00 | 0.00 |
| index fetch by key | 979,425 | 222.24 | 200.25 |
| index scans kdiixs1 | 75,356 | 17.10 | 15.41 |
| java call heap collected bytes | 0 | 0.00 | 0.00 |
| java call heap collected count | 0 | 0.00 | 0.00 |
| java call heap gc count | 0 | 0.00 | 0.00 |
| java call heap object count | 0 | 0.00 | 0.00 |
| java call heap object count max | 0 | 0.00 | 0.00 |
| java call heap total size | 0 | 0.00 | 0.00 |
| java call heap total size max | 0 | 0.00 | 0.00 |
| java call heap used size | 0 | 0.00 | 0.00 |
| java call heap used size max | 0 | 0.00 | 0.00 |
| leaf node 90-10 splits | 160 | 0.04 | 0.03 |
| leaf node splits | 2,575 | 0.58 | 0.53 |
| lob reads | 4,384 | 0.99 | 0.90 |
| lob writes | 4,276 | 0.97 | 0.87 |
| lob writes unaligned | 4,276 | 0.97 | 0.87 |
| logons cumulative | 181 | 0.04 | 0.04 |
| messages received | 9,279 | 2.11 | 1.90 |
| messages sent | 9,279 | 2.11 | 1.90 |
| no buffer to keep pinned count | 3 | 0.00 | 0.00 |
| no work - consistent read gets | 1,389,320 | 315.24 | 284.06 |
| opened cursors cumulative | 9,892 | 2.24 | 2.02 |
| parse count (failures) | 6 | 0.00 | 0.00 |
| parse count (hard) | 619 | 0.14 | 0.13 |
| parse count (total) | 9,984 | 2.27 | 2.04 |
| parse time cpu | 241 | 0.05 | 0.05 |
| parse time elapsed | 249 | 0.06 | 0.05 |
| physical read IO requests | 3,974 | 0.90 | 0.81 |
| physical read bytes | 437,510,144 | 99,272.76 | 89,452.08 |
| physical read total IO requests | 9,067 | 2.06 | 1.85 |
| physical read total bytes | 1,023,168,512 | 232,160.93 | 209,194.13 |
| physical read total multi block requests | 3,986 | 0.90 | 0.81 |
| physical reads | 53,407 | 12.12 | 10.92 |
| physical reads cache | 306 | 0.07 | 0.06 |
| physical reads cache prefetch | 33 | 0.01 | 0.01 |
| physical reads direct | 53,101 | 12.05 | 10.86 |
| physical reads direct (lob) | 273 | 0.06 | 0.06 |
| physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 22,239 | 5.05 | 4.55 |
| physical write bytes | 377,896,960 | 85,746.30 | 77,263.74 |
| physical write total IO requests | 41,140 | 9.33 | 8.41 |
| physical write total bytes | 2,371,228,672 | 538,041.05 | 484,814.69 |
| physical write total multi block requests | 15,936 | 3.62 | 3.26 |
| physical writes | 46,130 | 10.47 | 9.43 |
| physical writes direct | 191 | 0.04 | 0.04 |
| physical writes direct (lob) | 135 | 0.03 | 0.03 |
| physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical writes from cache | 45,939 | 10.42 | 9.39 |
| physical writes non VIEWpoint | 35,029 | 7.95 | 7.16 |
| pinned buffers inspected | 8 | 0.00 | 0.00 |
| pinned cursors current | 3 | 0.00 | 0.00 |
| prefetch clients - default | 0 | 0.00 | 0.00 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetch warmup blocks flushed out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 0 | 0.00 | 0.00 |
| process last non-idle time | 11,156 | 2.53 | 2.28 |
| recovery blocks read | 0 | 0.00 | 0.00 |
| recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
| recursive calls | 1,367,233 | 310.23 | 279.54 |
| recursive cpu usage | 9,490 | 2.15 | 1.94 |
| redo blocks read for recovery | 0 | 0.00 | 0.00 |
| redo blocks written | 994,339 | 225.62 | 203.30 |
| redo buffer allocation retries | 7,291 | 1.65 | 1.49 |
| redo entries | 1,213,667 | 275.39 | 248.14 |
| redo log space requests | 3 | 0.00 | 0.00 |
| redo log space wait time | 3 | 0.00 | 0.00 |
| redo ordering marks | 25,230 | 5.72 | 5.16 |
| redo size | 836,794,556 | 189,871.95 | 171,088.64 |
| redo subscn max counts | 34,888 | 7.92 | 7.13 |
| redo synch time | 540 | 0.12 | 0.11 |
| redo synch writes | 4,439 | 1.01 | 0.91 |
| redo wastage | 1,200,204 | 272.33 | 245.39 |
| redo write time | 192,909 | 43.77 | 39.44 |
| redo writer latching time | 0 | 0.00 | 0.00 |
| redo writes | 5,585 | 1.27 | 1.14 |
| rollback changes - undo records applied | 16 | 0.00 | 0.00 |
| rollbacks only - consistent read gets | 3,547 | 0.80 | 0.73 |
| root node splits | 1 | 0.00 | 0.00 |
| rows fetched via callback | 17,805 | 4.04 | 3.64 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 5,049 | 1.15 | 1.03 |
| session logical reads | 5,277,362 | 1,197.45 | 1,078.99 |
| shared hash latch upgrades - no wait | 8,987 | 2.04 | 1.84 |
| shared hash latch upgrades - wait | 0 | 0.00 | 0.00 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 4,927 | 1.12 | 1.01 |
| sorts (rows) | 224,158 | 50.86 | 45.83 |
| sql area evicted | 113 | 0.03 | 0.02 |
| sql area purged | 14 | 0.00 | 0.00 |
| summed dirty queue length | 0 | 0.00 | 0.00 |
| switch current to new buffer | 5,400 | 1.23 | 1.10 |
| table fetch by rowid | 4,445,158 | 1,008.62 | 908.84 |
| table fetch continued row | 156 | 0.04 | 0.03 |
| table scan blocks gotten | 681,383 | 154.61 | 139.31 |
| table scan rows gotten | 48,206,005 | 10,938.13 | 9,856.06 |
| table scans (direct read) | 14 | 0.00 | 0.00 |
| table scans (long tables) | 14 | 0.00 | 0.00 |
| table scans (rowid ranges) | 14 | 0.00 | 0.00 |
| table scans (short tables) | 3,086 | 0.70 | 0.63 |
| total number of times SMON posted | 0 | 0.00 | 0.00 |
| transaction rollbacks | 0 | 0.00 | 0.00 |
| transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
| undo change vector size | 175,520,228 | 39,826.23 | 35,886.37 |
| user I/O wait time | 820 | 0.19 | 0.17 |
| user calls | 15,302 | 3.47 | 3.13 |
| user commits | 4,862 | 1.10 | 0.99 |
| user rollbacks | 29 | 0.01 | 0.01 |
| workarea executions - onepass | 0 | 0.00 | 0.00 |
| workarea executions - optimal | 3,137 | 0.71 | 0.64 |
| write clones created in background | 0 | 0.00 | 0.00 |
| write clones created in foreground | 14 | 0.00 | 0.00 |