| SQL Id | SQL Text |
|---|
| 06fgu71hdy0r2 | select /*+rule*/ text from sys.dba_source
where owner = :owner
and name = :name
and type = :type
order by line
|
| 0bcsy1bsy8uz3 | SELECT djd.job_id, djd.freq, djd.use_holiday, djd.holiday_type FROM d_job_define djd, metabase.safe_job_mail sjm WHERE sjm.job_code=djd.job_id AND (sjm.status IS NULL or sjm.status ='1' or sjm.status='3') AND (SUBSTR(djd.FREQ, 6, 1)='D' or djd.job_id in (select job_id from VW_NEED_CHECK_JOB)) AND JOB_ID NOT IN (SELECT JOB_ID FROM J_JOB_MAILED WHERE SUBSTR(JOB_TIME, 1, 10)=TO_CHAR(SYSDATE, 'YYYY-MM-DD')) |
| 0c489vn29w1df |
INSERT INTO DATACORE.T_BASE_MID_CHANGES (ACTIONTYPE, BRANCH_CODE, ACCOUNT, DEAL_DATE, CURRENCE_CODE, CREDIT, DEBT, BALANCE, DATASTATUS, BUSINESSID, IMPORTDATE) SELECT 'A', D.EXPLANATION, C.ACCOUNT_NO, TO_DATE(A.BATCHENTRYDATE, 'yyyy-mm-dd'), C.CURRENCYCODE, SUM(DECODE(A.CREDITDEBIT, 'C', A.TRANSACTIONAMOUNT, 0)), SUM(DECODE(A.CREDITDEBIT, 'D', A.TRANSACTIONAMOUNT, 0)), CASE WHEN C.CURRENCYCODE = 'JPY' THEN ROUND(C.CCYLEDGERBALANCE, 0) ELSE C.CCYLEDGERBALANCE END BALANCE, 1 DATASTATUS, C.ACCOUNT_NO || C.CURRENCYCODE || :B1 , TO_DATE(:B1 , 'yyyy-mm-dd') FROM DF_CUST C LEFT JOIN (SELECT DISTINCT ACCOUNTBRANCH, DESCRIPTION, MASTERNO, CURRENCYCODE, ACCOUNT_NUMBER, SEQNO, ACCT_CLASS_CODE, PRODUCTCODE, VALUEDT_YYYY, VALUEDT_MM, VALUEDT_DD, BATCHENTRYDATE, VALUEDT_YYYYMMDD, NARRATIONPOST, TRANSACTIONAMOUNT, CREDITDEBIT, ACCOUNTBRANCH1, SEGMENTCODE, REFERENCENUMBER, NARRATIONTRAN, BATCHNUMBER, GLDEPTID, ARMCODE, EXTREFNO, MAKERID, CHECKERID, CHANNELID, TRANSACTION_AMT_IN_USD, ACCSHORTNAME, ARMNAME, SEGNAME, TXNCODE, REVERSALFLAG, EBBSREFERENCE, TRANSTYPECODE, CUSTOMERRATE, ADVTREASURYFLAG, VA_FLAG FROM DF_ACMOV_TODAY WHERE CREDITDEBIT IN ('C', 'D')) A ON A.ACCOUNT_NUMBER = C.ACCOUNT_NO LEFT JOIN DA_MID_ACC_GL_DIC D ON D.SOURCE = A.ACCOUNTBRANCH WHERE EXISTS (SELECT 1 FROM ACC.T_BASE_ACCOUNT B WHERE B.ACCOUNT = C.ACCOUNT_NO AND B.CURRENCE_CODE = C.CURRENCYCODE) AND A.ACCOUNT_NUMBER IS NOT NULL AND C.ACCOUNT_NO LIKE '0%'
GROUP BY D.EXPLANATION, C.ACCOUNT_NO, A.BATCHENTRYDATE, C.CURRENCYCODE, C.CCYLEDGERBALANCE |
| 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) |
| 17tvnzq7zrb9x |
INSERT INTO DATACORE.T_BASE_MID_CHANGES (ACTIONTYPE, BRANCH_CODE, ACCOUNT, DEAL_DATE, CURRENCE_CODE, CREDIT, DEBT, BALANCE, INSTCODE, DATASTATUS, BUSINESSID, IMPORTDATE) SELECT 'A', B.BRANCH_CODE, B.ACCOUNT, TO_DATE(A.BATCHENTRYDATE, 'yyyy-mm-dd'), B.CURRENCE_CODE, SUM(DECODE(A.CREDITDEBIT, 'C', A.TRANSACTIONAMOUNT, 0)), SUM(DECODE(A.CREDITDEBIT, 'D', A.TRANSACTIONAMOUNT, 0)), 0 BALANCE, B.INSTCODE INSTCODE, 1 DATASTATUS, B.ACCOUNT || B.CURRENCE_CODE || :B1 , TO_DATE(:B1 , 'yyyy-mm-dd') FROM ACC.T_BASE_ACCOUNT B LEFT JOIN (SELECT DISTINCT ACCOUNTBRANCH, DESCRIPTION, MASTERNO, CURRENCYCODE, ACCOUNT_NUMBER, SEQNO, ACCT_CLASS_CODE, PRODUCTCODE, VALUEDT_YYYY, VALUEDT_MM, VALUEDT_DD, BATCHENTRYDATE, VALUEDT_YYYYMMDD, NARRATIONPOST, TRANSACTIONAMOUNT, CREDITDEBIT, ACCOUNTBRANCH1, SEGMENTCODE, REFERENCENUMBER, NARRATIONTRAN, BATCHNUMBER, GLDEPTID, ARMCODE, EXTREFNO, MAKERID, CHECKERID, CHANNELID, TRANSACTION_AMT_IN_USD, ACCSHORTNAME, ARMNAME, SEGNAME, TXNCODE, REVERSALFLAG, EBBSREFERENCE, TRANSTYPECODE, CUSTOMERRATE, ADVTREASURYFLAG, VA_FLAG FROM DF_ACMOV_TODAY) A ON A.ACCOUNT_NUMBER = B.ACCOUNT AND A.CREDITDEBIT IN ('C', 'D') AND A.ACCOUNT_NUMBER LIKE '0%' LEFT JOIN DA_MID_ACC_GL_DIC D ON D.SOURCE = A.ACCOUNTBRANCH WHERE B.ACCOUNTSTAT = '13' AND B.OPEN_DATE = TO_DATE(:B1 , 'yyyy-mm-dd') AND A.ACCOUNT_NUMBER IS NOT NULL GROUP BY B.BRANCH_CODE, B.CURRENCE_CODE, A.BATCHENTRYDATE, B.ACCOUNT, A.CURRENCYCODE, B.INS
TCODE, B.ACCOUNTSTAT |
| 1rz8hy15knvtt | select count(Creditdebit) from df_acmov_today
|
| 1xq5pqgjt9pj5 | select column_id, table_id, column_name, "order", position, data_type, dictionary_type_id, cons_rule, txt_id, txt_column_id, is_show, tag_type, can_modify, data_type_desc, cons_desc, log_column_id, can_input from t_rpt_column_info where is_enabled = '1' and table_id = :1 order by to_number(position) asc |
| 2sr515y2bhf7y | INSERT INTO DATACORE.T_BASE_MID_CHANGES (ACTIONTYPE, ACCOUNT, BRANCH_CODE, CURRENCE_CODE, DEAL_DATE, BALANCE, CREDIT, DEBT, INSTCODE, DATASTATUS, BUSINESSID, IMPORTDATE) SELECT 'A', T.DEALNO ACCOUNT_NO, D.EXPLANATION BRANCH_CODE, T.CURRENCYCODE CURRENCYCODE, GETDATE(:B2 ), 0 BALANCE, 0 CREDIT, T.CCYDEALAMT DEBIT, GETCOSTCLASS(T.ACCOUNT_BRANCH, '2') || :B3 INSTCODE, 1 DATA_STATUS, T.DEALNO || T.CURRENCYCODE || :B2 , TO_DATE(:B2 , 'yyyy-mm-dd') FROM DF2_DEALDEPOSITS T LEFT JOIN DA_MID_ACC_GL_DIC D ON D.SOURCE = T.ACCOUNT_BRANCH WHERE NOT EXISTS (SELECT 1 FROM DF2_DEALDEPOSITS T1 WHERE T1.DATA_DATE = :B2 AND T.DEALNO = T1.DEALNO) AND EXISTS ( SELECT 1 FROM ACC.T_BASE_ACCOUNT T9 WHERE T9.ACCOUNT = T.DEALNO ) AND T.CURRENCYCODE <> 'CNY' AND T.DATA_DATE = :B1 |
| 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 |
| 3nz260v5dwqnv | select value from v$sesstat where sid = :sid order by statistic#
|
| 3rc93kcxxfvgw | select distinct data_date from DF_ACMOV_TODAY t
|
| 3sygh5g68vhuz |
select 'A',
d.explanation, --金融机构标识码
c.account_no, --交易账号
to_date(a.batchentrydate, 'yyyy-mm-dd'), --发生日期
c.currencycode, --币种
--SUM(decode(A.Creditdebit, 'C', a.transactionamount, 0)), --当日贷方发生额
--SUM(decode(A.Creditdebit, 'D', a.transactionamount, 0)), --当日借方发生额
case
when C.Currencycode = 'JPY' Then
Round(c.Ccyledgerbalance, 0)
else
c.ccyledgerbalance
End Balance, --账户余额
--b.instcode instcode, --系统虚拟机构代号
1 datastatus, --前台对应的数据状态
c.account_no || c.currencycode || '2013-01-04',
to_date('2013-01-04', 'yyyy-mm-dd')
from df_cust C
left join df_acmov_today a on a.account_number =
c.account_no
Left Join Da_Mid_Acc_Gl_Dic D On D.Source = A.Accountbranch
Where exists (select 1
from acc.t_base_account b
where b.account = c.account_no
and b.currence_code = c.currencycode)
and a.account_number is not null
and c.account_no like '0%'
/* group by d.explanation, --金融机构标识码
c.account_no, --交易账号
a.batchentrydate, --发生日期
c.currencycode, --币种
C.Ccyledgerbalance --系统机构代号*/
|
| 42cfrr6x5t75c | SELECT MAX(DB_NAME), MAX(VERSION) FROM WRM$_DATABASE_INSTANCE WHERE DBID = :B1 AND STARTUP_TIME = (SELECT MAX(STARTUP_TIME) FROM WRM$_DATABASE_INSTANCE WHERE DBID = :B1 AND STARTUP_TIME <= :B2 ) |
| 42t7dv03xqmva | UPDATE DATACORE.T_BASE_MID_CHANGES T SET T.ACCOUNT = 'NRA'||T.ACCOUNT WHERE EXISTS (SELECT 1 FROM DA_MID_CUST_STATUS T1, DC_ACC_NRA_CODE T2 WHERE T.ACCOUNT = T1.ACCOUNT_NO AND T1.PRODUCTCODE = T2.EBBS_VALUE ) |
| 49s332uhbnsma | declare
vsn varchar2(20);
begin
vsn := dbms_rcvman.getPackageVersion;
:pkg_vsn:pkg_vsn_i := vsn;
if vsn is not null then
:pkg_vsnub4 :=
to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) ||
substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00'));
end if;
end; |
| 4c7hmydgjs1zw | select * from df_outwardpaymentdetails t
left join qfii_account_list a on '000000'||trim(t.ordering_cust_line1)=
trim(a.qtt_account)
where t.data_date = '2013-01-04'
|
| 4jsqz2txmvamg | SELECT (:B3 +COUNT(1)) FROM UPRR.U_BASE_HOLIDAY HD WHERE HD.HOLIDAY_TYPE = :B2 AND GETDATE(HD.HOLIDAY_VALUE) = :B1 |
| 4y5kg4hgqmknh | UPDATE DATACORE.T_BASE_MID_CHANGES S SET S.INSTCODE = (SELECT INSTCODE FROM (SELECT DISTINCT INSTCODE, ACCOUNT FROM ACC.T_BASE_ACCOUNT) T2 WHERE T2.ACCOUNT = S.ACCOUNT) |
| 5a543br7f9ym8 | SELECT * FROM u_base_login_ip WHERE login_id='Emerg_sit_fmo_m1' |
| 5mf0dy2urh9uf | select reasion from t_refuse_resion where 1=1 and busi_table_id = :1 and businessid = :2 and busi_type = :3 |
| 5s34t44u10q4g | SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1 |
| 65jwmqyffy99r | INSERT INTO DATACORE.T_BASE_MID_CHANGES (ACTIONTYPE, ACCOUNT, BRANCH_CODE, CURRENCE_CODE, DEAL_DATE, BALANCE, CREDIT, DEBT, INSTCODE, DATASTATUS, BUSINESSID, IMPORTDATE) SELECT 'A', T.DEALNO ACCOUNT_NO, D.EXPLANATION BRANCH_CODE, T.CURRENCYCODE CURRENCYCODE, GETDATE(:B2 ), CASE WHEN T.CURRENCYCODE = 'JPY' THEN ROUND(T.CCYDEALAMT, 0) ELSE T.CCYDEALAMT END BALANCE, CASE WHEN T.CCYDEALAMT > T1.CCYDEALAMT THEN TO_NUMBER(T.CCYDEALAMT) - TO_NUMBER(T1.CCYDEALAMT) ELSE 0 END CREDIT, CASE WHEN T.CCYDEALAMT < T1.CCYDEALAMT THEN TO_NUMBER(T1.CCYDEALAMT) - TO_NUMBER(T.CCYDEALAMT) ELSE 0 END DEBIT, GETCOSTCLASS(T.ACCOUNT_BRANCH, '2') || :B3 INSTCODE, 1 DATA_STATUS, T.DEALNO || T.CURRENCYCODE || :B2 , TO_DATE(:B2 , 'yyyy-mm-dd') FROM DF2_DEALDEPOSITS T LEFT JOIN DF2_DEALDEPOSITS T1 ON T.DEALNO = T1.DEALNO AND T1.DATA_DATE = :B1 LEFT JOIN DA_MID_ACC_GL_DIC D ON D.SOURCE = T.ACCOUNT_BRANCH WHERE T.CCYDEALAMT <> T1.CCYDEALAMT AND (T.ACCOUNT_BRANCH <> T1.ACCOUNT_BRANCH OR T.CURRENCYCODE <> T1.CURRENCYCODE OR T.DEALNO <> T1.DEALNO) AND EXISTS ( SELECT 1 FROM ACC.T_BASE_ACCOUNT T9 WHERE T9.ACCOUNT = T.DEALNO ) AND T.CURRENCYCODE <> 'CNY' AND T.DATA_DATE = :B2 |
| 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 |
| 6q8ggvpwq63f1 | SELECT f.job_id FROM D_JOB_DEFINE F WHERE FREQ LIKE '%freq%' and FREQ not like '%|D|%' AND effect_date < to_char(sysdate, 'yyyy-mm-dd') AND invalid_date > to_char(sysdate, 'yyyy-mm-dd') AND getprev_N_WorkDay(HOLIDAY_TYPE, TO_CHAR(SYSDATE, 'YYYY-MM-DD'), substr(freq, 10, 1)) = get_LAST_WorkDay(HOLIDAY_TYPE, getprev_N_WorkDay(HOLIDAY_TYPE, TO_CHAR(SYSDATE, 'YYYY-MM-DD'), substr(freq, 10, 1)), substr(freq, 6, 1)) and IS_WorkDay(HOLIDAY_TYPE, to_char(sysdate, 'yyyy-mm-dd'))='Y' union select t2.job_id from D_JOB_DEFINE t2 where t2.freq like '%freq%' and t2.freq like '%|D|%' and IS_WorkDay(t2.HOLIDAY_TYPE, to_char(sysdate, 'yyyy-mm-dd'))='Y' |
| 6xvp6nxs4a9n4 | select nvl(sum(space), 0) from recyclebin$ where ts# = :1 |
| 7c33bxxfgdwxg | INSERT INTO DATACORE.T_BASE_MID_CHANGES (ACTIONTYPE, ACCOUNT, BRANCH_CODE, CURRENCE_CODE, DEAL_DATE, BALANCE, CREDIT, DEBT, INSTCODE, DATASTATUS, BUSINESSID, IMPORTDATE) SELECT 'A', T.DEALNO ACCOUNT_NO, D.EXPLANATION BRANCH_CODE, T.CURRENCYCODE CURRENCYCODE, GETDATE(:B1 ), CASE WHEN T.CURRENCYCODE = 'JPY' THEN ROUND(T.CCYDEALAMT, 0) ELSE T.CCYDEALAMT END BALANCE, T.CCYDEALAMT CREDIT, 0 DEBIT, GETCOSTCLASS(T.ACCOUNT_BRANCH, '2') || :B2 INSTCODE, 1 DATA_STATUS, T.DEALNO || T.CURRENCYCODE || :B1 , TO_DATE(:B1 , 'yyyy-mm-dd') FROM DF2_DEALDEPOSITS T LEFT JOIN DA_MID_ACC_GL_DIC D ON D.SOURCE = T.ACCOUNT_BRANCH WHERE NOT EXISTS (SELECT 1 FROM DF2_DEALDEPOSITS T1 WHERE T1.DATA_DATE = :B3 AND T.DEALNO = T1.DEALNO) AND EXISTS ( SELECT 1 FROM ACC.T_BASE_ACCOUNT T9 WHERE T9.ACCOUNT = T.DEALNO ) AND T.CURRENCYCODE <> 'CNY' AND T.DATA_DATE = :B1 |
| 7p4kuns5u1hsm | select distinct data_date from DF_CUST t
|
| 7wwd9zjbvggmh | INSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, VERSION, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , SYSDATE, SYSDATE, :B4 , 0, :B3 , PRVT_ADVISOR.GET_DB_VERSION, NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 ) |
| 7xattpgwuk1x5 | SELECT * FROM u_base_login_ip WHERE login_id='Emerg20' |
| 894407t2fbpvw | select distinct a.id as ID, a.task_id as TASK_ID, b.task_name as TASK_NAME, a.report_date as REPORT_DATE, a.task_status as TASK_STATUS, rs.status_name as TASK_STATUS_CH, a.start_user as START_USER, aui.user_name as START_USER_CH, a.start_time as START_TIME, a.end_time as END_TIME, ci.code_label as FREQUENCY, b.remark as TOTAL_TYPE, a.need_recheck, a.need_sameaudit from task_instance a join task_define b on a.task_id = b.task_id inner join task_bank_status tbs on a.task_id=tbs.task_id and a.report_date=tbs.report_date inner join bank_basis bank on tbs.bank_id=bank.bank_id left join report_status rs on a.task_status=rs.status_id left join code_info ci on ci.code_value=b.frequency left join auth_user_info aui on a.start_user=aui.user_id inner join task_subject_relation tsr on a.task_id=tsr.task_id where tsr.subject_id = :1 and ci.code_type='report_freq' AND ( tbs.bank_status = :2 OR tbs.bank_status = :3 OR tbs.bank_status = :4 ) AND ( a.task_status = :5 ) order by a.report_date desc, b.task_name desc |
| 8x4w8frtmwkwc | UPDATE ACC.T_BASE_CHANGES T0 SET T0.DEBT = :B4 WHERE T0.ACCOUNT= :B3 AND T0.CURRENCE_CODE = :B2 AND T0.IMPORTDATE = TO_DATE(:B1 , 'YYYY-MM-DD') |
| 9m7787camwh4m | begin :id := sys.dbms_transaction.local_transaction_id; end;
|
| aktbxfjwnzgmu | update WRM$_DATABASE_INSTANCE set last_ash_sample_id = :last_ash_sample_id where instance_number = :instance_number and dbid = :dbid and startup_time = (select max(startup_time) from WRM$_DATABASE_INSTANCE where instance_number = :instance_number2 and dbid = :dbid2 ) |
| as3mpq97j8p0j | select * from df_outwardpaymentdetails t
|
| b0p2d61g45pys |
select 'A',
d.explanation, --金融机构标识码
c.account_no, --交易账号
to_date(a.batchentrydate, 'yyyy-mm-dd'), --发生日期
c.currencycode, --币种
SUM(decode(A.Creditdebit, 'C', a.transactionamount, 0)), --当日贷方发生额
SUM(decode(A.Creditdebit, 'D', a.transactionamount, 0)), --当日借方发生额
case
when C.Currencycode = 'JPY' Then
Round(c.Ccyledgerbalance, 0)
else
c.ccyledgerbalance
End Balance, --账户余额
--b.instcode instcode, --系统虚拟机构代号
1 datastatus, --前台对应的数据状态
c.account_no || c.currencycode || '2013-01-04',
to_date('2013-01-04', 'yyyy-mm-dd')
from df_cust C
left join (select distinct ACCOUNTBRANCH,
DESCRIPTION,
MASTERNO,
CURRENCYCODE,
ACCOUNT_NUMBER,
SEQNO,
ACCT_CLASS_CODE,
PRODUCTCODE,
VALUEDT_YYYY,
VALUEDT_MM,
VALUEDT_DD,
BATCHENTRYDATE,
VALUEDT_YYYYMMDD,
NARRATIONPOST,
TRANSACTIONAMOUNT,
CRE
DITDEBIT,
ACCOUNTBRANCH1,
SEGMENTCODE,
REFERENCENUMBER,
NARRATIONTRAN,
BATCHNUMBER,
GLDEPTID,
ARMCODE,
EXTREFNO,
MAKERID,
CHECKERID,
CHANNELID,
TRANSACTION_AMT_IN_USD,
ACCSHORTNAME,
ARMNAME,
SEGNAME,
TXNCODE,
REVERSALFLAG,
EBBSREFERENCE,
TRANSTYPECODE,
CUSTOMERRATE,
ADVTREASURYFLAG,
VA_FLAG
from df_acmov_today
where Creditdebit in ('C', 'D')) a on a.account_number =
c.account_no
Left Join Da_Mid_Acc_Gl_Dic D On D.Source = A.Accountbranch
Where exists (select 1
from acc.t_base_account b
where b.account = c.account_no
and b.currence_code = c.currencycode)
and a.account_number is not null
and c.account_no like '0%'
group by d.explanation, --金融机构标识码
c.account_no, --交易账号
a.batchentrydate, --发生日期
c.currencycode, --币种
C.Ccyledgerbalance--系统机构代号
|
| b2gnxm5z6r51n | lock table sys.col_usage$ in exclusive mode nowait |
| b306sbh0pwwuk | select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35, t.instcode from t_base_account t where t.instCode in ( :1 , :2 , :3 ) and t.datastatus in (5) and businessid in (select min(businessid) from t_base_account where datastatus in (5) group by branch_code, account, currence_code) order by t.instCode asc |
| bydf32qgqdwdu | begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
|
| c8gnrhxma4tas | SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1 |
| c8khjbn635s3c | select s.synonym_name object_name, o.object_type
from 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')
|
| cf06fwacdmgfk | select 'x' from dual
|
| ckvza1m0d3h54 | create table df_xref_20130219 as select * from df_xref
|
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| csnp95dz2r8ss | select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0 |
| cwg1p9x2f5xn8 | begin
-- Call the procedure
acc_etl_dm_base_changes(is_date => :is_date);
end;
|
| dh7h8nxgbnk8s | select t.tableId as tableId, t.businessId as businessId, t.packName as packName, t.fileName as fileName, t.is_receive as isReceive, t.is_sendmts as isSendMts from T_RPT_SEND_COMMIT t where 1=1 and packName = :1 |
| f52dfyprb48dv |
select distinct ACCOUNTBRANCH,
DESCRIPTION,
MASTERNO,
CURRENCYCODE,
ACCOUNT_NUMBER,
SEQNO,
ACCT_CLASS_CODE,
PRODUCTCODE,
VALUEDT_YYYY,
VALUEDT_MM,
VALUEDT_DD,
BATCHENTRYDATE,
VALUEDT_YYYYMMDD,
NARRATIONPOST,
TRANSACTIONAMOUNT,
CREDITDEBIT,
ACCOUNTBRANCH1,
SEGMENTCODE,
REFERENCENUMBER,
NARRATIONTRAN,
BATCHNUMBER,
GLDEPTID,
ARMCODE,
EXTREFNO,
MAKERID,
CHECKERID,
CHANNELID,
TRANSACTION_AMT_IN_USD,
ACCSHORTNAME,
ARMNAME,
SEGNAME,
TXNCODE,
REVERSALFLAG,
EBBSREFERENCE,
TRANSTYPECODE,
CUSTOMERRATE,
ADVTREASURYFLAG,
VA_FLAG
from df_acmov_today
where Creditdebit in ('C', 'D')
|
| f5kwz8jd7jbcy |
declare
t_owner varchar2(30);
t_name varchar2(30);
procedure check_mview is
dummy integer;
begin
if :object_type = 'TABLE' then
select /*+rule*/ 1 into dummy
from sys.dba_objects
where owner = :object_owner
and object_name = :object_name
and object_type = 'MATERIALIZED VIEW'
and rownum = 1;
:object_type := 'MATERIALIZED VIEW';
end if;
exception
when others then null;
end;
begin
:sub_object := null;
if :deep != 0 then
begin
if :part2 is null then
select /*+rule*/ constraint_type, owner, constraint_name
into :object_type, :object_owner, :object_name
from sys.dba_constraints c
where c.constraint_name = :part1 and c.owner = :cur_schema
and rownum = 1;
else
select /*+rule*/ constraint_type, owner, constraint_name, :part3
into :object_type, :object_owner, :object_name, :sub_object
from sys.dba_constraints c
where c.constraint_name = :part2 and c.owner = :part1
and rownum = 1;
end if;
if :object_type = 'P' then :object_type := 'PRIMARY KEY'; end if;
if :object_type = 'U' then :object_type := 'UNIQUE KEY'; end if;
if :object_type = 'R' then :object_type := 'FOREIGN KEY'; end if;
if :object_type = 'C' then :object_type := 'CHECK CONSTRAINT'; end if;
return;
exception
when no_data_found then null;
end;
end if;
:sub_object := :pa
rt2;
if (:part2 is null) or (:part1 != :cur_schema) then
begin
select /*+rule*/ object_type, :cur_schema, :part1
into :object_type, :object_owner, :object_name
from sys.dba_objects
where owner = :cur_schema
and object_name = :part1
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
if :object_type = 'SYNONYM' then
select /*+rule*/ s.table_owner, s.table_name
into t_owner, t_name
from dba_synonyms s
where s.synonym_name = :part1
and s.owner = :cur_schema
and rownum = 1;
select /*+rule*/ o.object_type, o.owner, o.object_name
into :object_type, :object_owner, :object_name
from sys.dba_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
end if;
:sub_object := :part2;
if :part3 is not null then
:sub_object := :sub_object || '.' || :part3;
end if;
check_mview;
return;
exception
when no_data_found then null;
end;
end if;
begin
select /*+rule*/ s.table_owner, s.table_name
into t_owner, t_name
from dba_synonyms s
where s.synonym_name =
:part1
and s.owner = 'PUBLIC'
and rownum = 1;
select /*+rule*/ o.object_type, o.owner, o.object_name
into :object_type, :object_owner, :object_name
from sys.dba_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
:sub_object := :part3;
begin
select /*+rule*/ o.object_type, o.owner, o.object_name
into :object_type, :object_owner, :object_name
from sys.dba_objects o
where o.owner = :part1
and o.object_name = :part2
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
begin
if :part2 is null and :part3 is null
then
select /*+rule*/ 'USER', null, :part1
into :object_type, :object_owner, :object_name
from sys.dba_users u
where u.username = :part1
and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
begin
if :part2 is null and :part3 is null and :deep != 0
then
select /*+rule*/ 'ROLE', null, :part1
into :object_type, :object_owner
, :object_name
from sys.session_roles r
where r.role = :part1
and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
:object_owner := null;
:object_type := null;
:object_name := null;
:sub_object := null;
end;
|
| f5yun5dynkskv |
select s.synonym_name as object_name, o.object_type
from all_synonyms s, sys.all_objects o
where s.owner in ('PUBLIC', :schema)
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')
|
| fmrbb1q5zsjuy | select uauthroler0_.OBJECT_ID as col_0_0_, uauthroler0_.RES_ID as col_1_0_, uauthroler0_.RES_DETAIL_VALUE as col_2_0_, uauthroler0_.RES_DETAIL_NAME as col_3_0_, uauthroler0_.SYSTEM_ID as col_4_0_ from U_AUTH_ROLE_RESOURCE uauthroler0_, U_AUTH_RES_MAP uauthresma1_ where uauthroler0_.RES_ID=uauthresma1_.RES_ID(+) and (uauthroler0_.OBJECT_ID in (select ubaseuserd2_.USER_ID from U_BASE_USER ubaseuserd2_ where ubaseuserd2_.USER_ENAME='Emerg20') or uauthroler0_.OBJECT_ID in (select uauthroleu3_.ROLE_ID from U_AUTH_ROLE_USER uauthroleu3_, U_AUTH_ROLE uauthroled4_ where uauthroleu3_.ROLE_ID=uauthroled4_.ROLE_ID and uauthroled4_.ENABLED='1' and uauthroleu3_.USER_ID='Emerg20')) and (uauthresma1_.RES_TYPE in ('PUB')) and uauthroler0_.SYSTEM_ID<>'00003' |
| fnj6cnubp1sau | begin
if :enable = 0 then
sys.dbms_output.disable;
else
sys.dbms_output.enable(:size);
end if;
end;
|
| 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 |
| g11df56up9sc6 |
select 'A',
d.explanation, --金融机构标识码
c.account_no, --交易账号
to_date(a.batchentrydate, 'yyyy-mm-dd'), --发生日期
c.currencycode, --币种
SUM(decode(A.Creditdebit, 'C', a.transactionamount, 0)), --当日贷方发生额
SUM(decode(A.Creditdebit, 'D', a.transactionamount, 0)), --当日借方发生额
case
when C.Currencycode = 'JPY' Then
Round(c.Ccyledgerbalance, 0)
else
c.ccyledgerbalance
End Balance, --账户余额
--b.instcode instcode, --系统虚拟机构代号
1 datastatus, --前台对应的数据状态
c.account_no || c.currencycode || '2013-01-04',
to_date('2013-01-04', 'yyyy-mm-dd')
from df_cust C
left join df_acmov_today a on a.account_number =
c.account_no
Left Join Da_Mid_Acc_Gl_Dic D On D.Source = A.Accountbranch
Where exists (select 1
from acc.t_base_account b
where b.account = c.account_no
and b.currence_code = c.currencycode)
and a.account_number is not null
and c.account_no like '0%'
group by d.explanation, --金融机构标识码
c.account_no, --交易账号
a.batchentrydate, --发生日期
c.currencycode, --币种
C.Ccyledgerbalance --系统机构代号
|
| g4rx9bg577su4 | SELECT /*+rule*/ CONSTRAINT_TYPE, OWNER, CONSTRAINT_NAME FROM SYS.DBA_CONSTRAINTS C WHERE C.CONSTRAINT_NAME = :B2 AND C.OWNER = :B1 AND ROWNUM = 1 |
| g8zccsxka2bh1 | select distinct data_date from Df2_Dealdeposits t
|
| gdn3ysuyssf82 | SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1 |
| grwydz59pu6mc | select text from view$ where rowid=:1 |
| Statistic | Total | per Second | per Trans |
|---|
| Batched IO (bound) vector count | 0 | 0.00 | 0.00 |
| Batched IO (full) vector count | 0 | 0.00 | 0.00 |
| Batched IO block miss count | 0 | 0.00 | 0.00 |
| Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
| Batched IO double miss count | 0 | 0.00 | 0.00 |
| Batched IO same unit count | 0 | 0.00 | 0.00 |
| Batched IO single block count | 0 | 0.00 | 0.00 |
| Batched IO vector block count | 0 | 0.00 | 0.00 |
| Batched IO vector read count | 0 | 0.00 | 0.00 |
| Block Cleanout Optim referenced | 2 | 0.00 | 0.00 |
| CCursor + sql area evicted | 20 | 0.01 | 0.00 |
| CPU used by this session | 6,618 | 1.84 | 1.21 |
| CPU used when call started | 6,517 | 1.81 | 1.19 |
| CR blocks created | 4 | 0.00 | 0.00 |
| Cached Commit SCN referenced | 13,353 | 3.71 | 2.44 |
| Commit SCN cached | 118 | 0.03 | 0.02 |
| DB time | 9,198 | 2.55 | 1.68 |
| DBWR checkpoint buffers written | 1,438 | 0.40 | 0.26 |
| DBWR checkpoints | 4 | 0.00 | 0.00 |
| DBWR object drop buffers written | 40 | 0.01 | 0.01 |
| DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR transaction table writes | 72 | 0.02 | 0.01 |
| DBWR undo block writes | 408 | 0.11 | 0.07 |
| HSC Heap Segment Block Changes | 14,322 | 3.98 | 2.62 |
| HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
| Heap Segment Array Inserts | 381 | 0.11 | 0.07 |
| Heap Segment Array Updates | 373 | 0.10 | 0.07 |
| IMU CR rollbacks | 0 | 0.00 | 0.00 |
| IMU Flushes | 35 | 0.01 | 0.01 |
| IMU Redo allocation size | 224,136 | 62.23 | 40.98 |
| IMU commits | 86 | 0.02 | 0.02 |
| IMU contention | 1 | 0.00 | 0.00 |
| IMU ktichg flush | 3 | 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 | 345,288 | 95.87 | 63.12 |
| IMU- failed to get a private strand | 0 | 0.00 | 0.00 |
| 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 | 10,442 | 2.90 | 1.91 |
| PX local messages recv'd | 0 | 0.00 | 0.00 |
| PX local messages sent | 0 | 0.00 | 0.00 |
| RowCR - row contention | 0 | 0.00 | 0.00 |
| RowCR attempts | 0 | 0.00 | 0.00 |
| RowCR hits | 0 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 20,231 | 5.62 | 3.70 |
| active txn count during cleanout | 123 | 0.03 | 0.02 |
| application wait time | 3 | 0.00 | 0.00 |
| background checkpoints completed | 0 | 0.00 | 0.00 |
| background checkpoints started | 0 | 0.00 | 0.00 |
| background timeouts | 32,498 | 9.02 | 5.94 |
| branch node splits | 0 | 0.00 | 0.00 |
| buffer is not pinned count | 197,401 | 54.81 | 36.09 |
| buffer is pinned count | 384,971 | 106.88 | 70.38 |
| bytes received via SQL*Net from client | 2,146,186 | 595.87 | 392.36 |
| bytes sent via SQL*Net to client | 14,532,405 | 4,034.76 | 2,656.75 |
| calls to get snapshot scn: kcmgss | 10,980 | 3.05 | 2.01 |
| calls to kcmgas | 2,063 | 0.57 | 0.38 |
| calls to kcmgcs | 45,307 | 12.58 | 8.28 |
| cell physical IO interconnect bytes | 16,598,016,000 | 4,608,257.15 | 3,034,372.21 |
| change write time | 24 | 0.01 | 0.00 |
| cleanout - number of ktugct calls | 245 | 0.07 | 0.04 |
| cleanouts and rollbacks - consistent read gets | 2 | 0.00 | 0.00 |
| cleanouts only - consistent read gets | 122 | 0.03 | 0.02 |
| cluster key scan block gets | 8,105 | 2.25 | 1.48 |
| cluster key scans | 5,173 | 1.44 | 0.95 |
| 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 | 6 | 0.00 | 0.00 |
| commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 5 | 0.00 | 0.00 |
| commit cleanout failures: cannot pin | 1 | 0.00 | 0.00 |
| commit cleanouts | 1,765 | 0.49 | 0.32 |
| commit cleanouts successfully completed | 1,753 | 0.49 | 0.32 |
| commit immediate performed | 0 | 0.00 | 0.00 |
| commit immediate requested | 0 | 0.00 | 0.00 |
| commit txn count during cleanout | 146 | 0.04 | 0.03 |
| concurrency wait time | 44 | 0.01 | 0.01 |
| consistent changes | 114 | 0.03 | 0.02 |
| consistent gets | 7,130,142 | 1,979.61 | 1,303.50 |
| consistent gets - examination | 111,109 | 30.85 | 20.31 |
| consistent gets direct | 1,329,304 | 369.07 | 243.02 |
| consistent gets from cache | 5,800,838 | 1,610.54 | 1,060.48 |
| consistent gets from cache (fastpath) | 5,662,903 | 1,572.24 | 1,035.27 |
| cursor authentications | 115 | 0.03 | 0.02 |
| data blocks consistent reads - undo records applied | 4 | 0.00 | 0.00 |
| db block changes | 38,398 | 10.66 | 7.02 |
| db block gets | 31,002 | 8.61 | 5.67 |
| db block gets direct | 1,405 | 0.39 | 0.26 |
| db block gets from cache | 29,597 | 8.22 | 5.41 |
| db block gets from cache (fastpath) | 5,593 | 1.55 | 1.02 |
| deferred (CURRENT) block cleanout applications | 1,040 | 0.29 | 0.19 |
| dirty buffers inspected | 0 | 0.00 | 0.00 |
| enqueue conversions | 32 | 0.01 | 0.01 |
| enqueue releases | 5,558 | 1.54 | 1.02 |
| enqueue requests | 5,580 | 1.55 | 1.02 |
| enqueue timeouts | 0 | 0.00 | 0.00 |
| enqueue waits | 6 | 0.00 | 0.00 |
| exchange deadlocks | 0 | 0.00 | 0.00 |
| execute count | 11,634 | 3.23 | 2.13 |
| failed probes on index block reclamation | 0 | 0.00 | 0.00 |
| file io service time | 0 | 0.00 | 0.00 |
| file io wait time | 9,947,683 | 2,761.87 | 1,818.59 |
| free buffer inspected | 622,752 | 172.90 | 113.85 |
| free buffer requested | 615,750 | 170.96 | 112.57 |
| heap block compress | 1,431 | 0.40 | 0.26 |
| hot buffers moved to head of LRU | 91 | 0.03 | 0.02 |
| immediate (CR) block cleanout applications | 124 | 0.03 | 0.02 |
| immediate (CURRENT) block cleanout applications | 187 | 0.05 | 0.03 |
| index crx upgrade (positioned) | 11 | 0.00 | 0.00 |
| index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 8 | 0.00 | 0.00 |
| index fetch by key | 112,101 | 31.12 | 20.49 |
| index scans kdiixs1 | 88,625 | 24.61 | 16.20 |
| leaf node 90-10 splits | 18 | 0.00 | 0.00 |
| leaf node splits | 24 | 0.01 | 0.00 |
| lob reads | 2 | 0.00 | 0.00 |
| lob writes | 27 | 0.01 | 0.00 |
| lob writes unaligned | 27 | 0.01 | 0.00 |
| logons cumulative | 66 | 0.02 | 0.01 |
| max cf enq hold time | 0 | 0.00 | 0.00 |
| messages received | 3,641 | 1.01 | 0.67 |
| messages sent | 3,641 | 1.01 | 0.67 |
| min active SCN optimization applied on CR | 0 | 0.00 | 0.00 |
| no buffer to keep pinned count | 6 | 0.00 | 0.00 |
| no work - consistent read gets | 6,972,528 | 1,935.85 | 1,274.69 |
| non-idle wait count | 81,441 | 22.61 | 14.89 |
| non-idle wait time | 2,156 | 0.60 | 0.39 |
| opened cursors cumulative | 10,321 | 2.87 | 1.89 |
| parse count (describe) | 0 | 0.00 | 0.00 |
| parse count (failures) | 19 | 0.01 | 0.00 |
| parse count (hard) | 314 | 0.09 | 0.06 |
| parse count (total) | 7,340 | 2.04 | 1.34 |
| parse time cpu | 664 | 0.18 | 0.12 |
| parse time elapsed | 692 | 0.19 | 0.13 |
| physical read IO requests | 35,725 | 9.92 | 6.53 |
| physical read bytes | 15,934,988,288 | 4,424,174.78 | 2,913,160.56 |
| physical read total IO requests | 46,738 | 12.98 | 8.54 |
| physical read total bytes | 16,115,564,544 | 4,474,309.79 | 2,946,172.68 |
| physical read total multi block requests | 14,900 | 4.14 | 2.72 |
| physical reads | 1,945,189 | 540.06 | 355.61 |
| physical reads cache | 614,541 | 170.62 | 112.35 |
| physical reads cache prefetch | 589,267 | 163.60 | 107.73 |
| physical reads direct | 1,330,648 | 369.44 | 243.26 |
| physical reads direct (lob) | 1 | 0.00 | 0.00 |
| physical reads direct temporary tablespace | 1 | 0.00 | 0.00 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 2,310 | 0.64 | 0.42 |
| physical write bytes | 379,699,200 | 105,419.32 | 69,414.84 |
| physical write total IO requests | 7,500 | 2.08 | 1.37 |
| physical write total bytes | 482,451,456 | 133,947.36 | 88,199.53 |
| physical write total multi block requests | 1,524 | 0.42 | 0.28 |
| physical writes | 46,350 | 12.87 | 8.47 |
| physical writes direct | 44,867 | 12.46 | 8.20 |
| physical writes direct (lob) | 7 | 0.00 | 0.00 |
| physical writes direct temporary tablespace | 43,463 | 12.07 | 7.95 |
| physical writes from cache | 1,483 | 0.41 | 0.27 |
| physical writes non checkpoint | 45,674 | 12.68 | 8.35 |
| pinned buffers inspected | 1 | 0.00 | 0.00 |
| pinned cursors current | 4 | 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 | 3,902 | 1.08 | 0.71 |
| recovery blocks read | 0 | 0.00 | 0.00 |
| recursive calls | 70,201 | 19.49 | 12.83 |
| recursive cpu usage | 3,969 | 1.10 | 0.73 |
| redo blocks checksummed by FG (exclusive) | 26,401 | 7.33 | 4.83 |
| redo blocks read for recovery | 0 | 0.00 | 0.00 |
| redo blocks written | 38,904 | 10.80 | 7.11 |
| redo buffer allocation retries | 0 | 0.00 | 0.00 |
| redo entries | 21,658 | 6.01 | 3.96 |
| redo k-bytes read for recovery | 0 | 0.00 | 0.00 |
| redo k-bytes read total | 0 | 0.00 | 0.00 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 368 | 0.10 | 0.07 |
| redo size | 19,078,348 | 5,296.89 | 3,487.81 |
| redo size for direct writes | 11,552,596 | 3,207.45 | 2,111.99 |
| redo subscn max counts | 830 | 0.23 | 0.15 |
| redo synch time | 11 | 0.00 | 0.00 |
| redo synch writes | 204 | 0.06 | 0.04 |
| redo wastage | 180,156 | 50.02 | 32.94 |
| redo write time | 39 | 0.01 | 0.01 |
| redo writes | 658 | 0.18 | 0.12 |
| rollback changes - undo records applied | 0 | 0.00 | 0.00 |
| rollbacks only - consistent read gets | 2 | 0.00 | 0.00 |
| root node splits | 0 | 0.00 | 0.00 |
| rows fetched via callback | 78,362 | 21.76 | 14.33 |
| scheduler wait time | 0 | 0.00 | 0.00 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 7,569 | 2.10 | 1.38 |
| session logical reads | 7,161,144 | 1,988.21 | 1,309.17 |
| shared hash latch upgrades - no wait | 1,755 | 0.49 | 0.32 |
| shared hash latch upgrades - wait | 0 | 0.00 | 0.00 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 8,516 | 2.36 | 1.56 |
| sorts (rows) | 453,228 | 125.83 | 82.86 |
| sql area evicted | 480 | 0.13 | 0.09 |
| sql area purged | 23 | 0.01 | 0.00 |
| summed dirty queue length | 0 | 0.00 | 0.00 |
| switch current to new buffer | 685 | 0.19 | 0.13 |
| table fetch by rowid | 189,506 | 52.61 | 34.64 |
| table fetch continued row | 144 | 0.04 | 0.03 |
| table scan blocks gotten | 6,904,820 | 1,917.05 | 1,262.31 |
| table scan rows gotten | 246,230,721 | 68,363.26 | 45,014.76 |
| table scans (direct read) | 27 | 0.01 | 0.00 |
| table scans (long tables) | 59 | 0.02 | 0.01 |
| table scans (rowid ranges) | 0 | 0.00 | 0.00 |
| table scans (short tables) | 12,072 | 3.35 | 2.21 |
| temp space allocated (bytes) | 368,050,176 | 102,185.10 | 67,285.22 |
| total cf enq hold time | 50 | 0.01 | 0.01 |
| total number of cf enq holders | 184 | 0.05 | 0.03 |
| 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 | 2,432,724 | 675.42 | 444.74 |
| user I/O wait time | 1,580 | 0.44 | 0.29 |
| user calls | 24,396 | 6.77 | 4.46 |
| user commits | 122 | 0.03 | 0.02 |
| user rollbacks | 5,348 | 1.48 | 0.98 |
| workarea executions - onepass | 0 | 0.00 | 0.00 |
| workarea executions - optimal | 8,424 | 2.34 | 1.54 |
| write clones created in background | 3 | 0.00 | 0.00 |
| write clones created in foreground | 0 | 0.00 | 0.00 |