| SQL Id | SQL Text |
|---|
| 09tsz603hv128 | select opseno, ordnum from sbds_log where userflag = 'ORA$PIPE$09A80A7F0001' |
| 0jc9p8pgzafwa | UPDATE ABE8 A SET FLAG ='3', AAE113='¸öÈ˵Ľð¶î²»ÕýÈ·' WHERE AAE063 =:B1 AND EXISTS( SELECT 1 FROM SBDI_JJBMDETAIL B WHERE A.AAB400=B.JJXLBM AND B.SSLX='1') |
| 0s4pt2jb2b6an | SELECT REPEXECBATCHITEM.*, REPEXECBATCHITEM.ROWID FROM REPEXECBATCHITEM |
| 12tj2qjp3w0gb | SELECT REPEXECBATCH.*, REPEXECBATCH.ROWID FROM REPEXECBATCH |
| 16g838gdn6xdy | UPDATE ABE8_IN SET AAE140 =(SELECT AAA103 FROM AA10 WHERE AAA100 ='AAE141' AND AAA102=AAB400) WHERE EXISTS(SELECT 1 FROM AA10 WHERE AAA100 ='AAE141' AND AAA102=AAB400 ) |
| 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)) |
| 1y4ngq95rxz9k | DELETE FROM ABE8_IN |
| 2rrt6smth6s2q | select count(*) from (select distinct n.eac001, n.aac157, n.aac003, (select a.aaa103 aac004 from v_AA10 a where a.aaa100 = 'AAC004' and a.aaa102=aac004), (select a.aaa103 aac008 from v_AA10 a where a.aaa100 = 'AAC008' and a.aaa102=aac008) , (select a.aaa103 eac067 from v_AA10 a where a.aaa100 = 'EAC067' and a.aaa102=eac067), n.aac039, to_char(aae030, 'yyyy-mm-dd') from net_ac03 n , net_ac15 m where n.aac001=m.aac001 and n.aab001='00002979' and m.aae140= '04') |
| 3506cmc7jj5hh | SELECT COUNT(*) FROM NET_AC01 T, AC02 B WHERE T.AAC001=B.AAC001 AND B.AAE140 IN(01, 04)AND T.AAB001= :B2 AND T.AAC157=:B1 AND TO_CHAR(B.EAC020, 'yyyy-mm')=TO_CHAR(SYSDATE, 'yyyy-mm') |
| 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 |
| 3gs90x9qzhdk7 | SELECT COUNT(*) FROM LQSI.AC02 A WHERE A.AAC001=:B1 AND AAE140='01' AND AAC031 IN ('1', '2') |
| 44mwxbkuxcrsa | SELECT /*+rule*/ S.TABLE_OWNER, S.TABLE_NAME FROM ALL_SYNONYMS S WHERE S.SYNONYM_NAME = :B1 AND S.OWNER = 'PUBLIC' AND ROWNUM = 1 |
| 4b3drb3axu8yx | BEGIN NET_CHECK_PERSONXUBAONEW(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12); END; |
| 4fgq951m9utwd | UPDATE SBDI_TAXRETDT A SET RZBZ =1 WHERE EXISTS (SELECT 1 FROM ABE8 B WHERE A.DSWYM=B.DSWYBM) AND RZBZ =0 |
| 4m7m0t6fjcs5x | update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1 |
| 4nxg9z3812rhh | SELECT LTRIM(RTRIM(AAA005)) FROM AA01 WHERE AAA001 = UPPER(:B2 ) AND (AAA027 IS NULL OR AAA027=:B1 ) |
| 4tjkfpvytby84 | SELECT MIN(ITEM_ID) FROM REPEXECBATCHITEM WHERE BATCH_ID='*' AND ITEM_STATUS='NEW'
|
| 502f1gzuv557b | INSERT INTO SBDI_TAXRETDT VALUES (:B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , :B20 , :B21 , :B22 , :B23 , :B24 , :B25 , :B26 , :B27 , :B28 , :B29 ) |
| 5cpzwnqrzmauq | Select aae008 ίÍз¢·Å»ú¹¹,
eac046 ·¢·Å×ܶî,
rs ·¢·ÅÈËÊý
from ( select f_getcodename('AAE008', a.aae008, '331004') aae008,
sum(a.eac046) eac046,
count(distinct(aac001)) rs
from acd8 a
where a.aae145 in ('1', '2')
and a.aaa027= '331004'
and a.aae002=SBP_COMMON.F_AddMonths(201311, 0-SBP_COMMON.F_GetSysOperParam('RULE_PAY', '331004'))
group by a.aae008
union all
select 'ÓÊÕþ»ã¿î' aae008,
sum(a.eac046) eac046,
count(distinct(aac001)) rs
from acd8 a
where a.aae145='3'
and a.aaa027= '331004'
and a.aae002=SBP_COMMON.F_AddMonths(201311, 0-SBP_COMMON.F_GetSysOperParam('RULE_PAY', '331004'))
having count(*)>0
)
|
| 5j7kf3yf7sg26 | UPDATE IC02 SET AAE120='0' WHERE AAC001 =:B2 AND AAE001 >=:B1 AND EAC042 =0 AND AAE140 ='01' |
| 5v4bnb370hpqr | select * from (select null table_catalog, idx.table_owner table_schema, idx.table_name table_name, null index_catalog, idx.owner index_schema, idx.index_name index_name, null primary_key, decode(idx.uniqueness, 'UNIQUE', 65535, 0) unique_, decode(idx.index_type, 'CLUSTER', 65535, 0) clustered, null type, null fill_factor, idx.initial_extent initial_size, null nulls, null sort_bookmarks, 65535 auto_update, 2 null_collation, col.column_position ordinal_position, col.column_name column_name, null column_guid, null column_propid, 1 collation, null cardinality, null pages, null filter_condition, decode(idx.index_type, 'CLUSTER', 65535, 0) integrated from all_indexes idx, all_ind_columns col where idx.owner = col.index_owner and idx.index_name = col.index_name and idx.table_owner = col.table_owner and idx.table_name = col.table_name) indexes where table_schema = 'LQSI' and table_name = 'ACA6' order by 8, 10, 5, 6, 17 |
| 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; |
| 6r0hbmkzyn8h7 |
select * from (
select
a.eae003||'00' mxh,
(select aaa103 from aa10 where aaa100 ='AAE140' and aaa102 =a.aae140) "ÏÕÖÖ",
a.eae003 "Ó¦½ÉÄêÔÂ",
a.eac029 "ÈËÊý",
a.eac018 "½É·Ñ»ùÊý",
a.eac031 "Ó¦½É½ð¶î",
a.eac032 "µ¥Î»²¿·Ö",
kpsj "µ½Õ˽ð¶î",
b.eac031 "ÒѲ¹½ð¶î",
eac032-nvl(kpsj, 0)-nvl(b.eac031, 0) "²¹½É½ð¶î",
0 "Äê¶È"
from
(
select x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029,
sum(eac018) eac018 , sum(eac031) eac031 , sum(eac032) eac032 , kpsj from
(SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032,
b.aab030, b.aab004
FROM ACA6 a , ab01 b WHERE a.aab001=b.aab001 and a.aab033 ='2' and
a.AAB001 ='00020366' AND AAE140 ='01'
AND EAE003 >=200707 AND AAE109 ='0') X ,
(
SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8
WHERE aae140 ='01' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140
) Y
WHERE x.aab030=y.AAB030(+) and x.eae003=y.eae003(+)
group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj
) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b
where a.aab001=b.aab001(+) and a.aae140=b.aae140(+) and a.eae003=b.eae003(+)
and substr(a.eae003, 0, 4)>='2007' and substr(a.eae003, 0, 4)<='2013'
union
select
a.yearno||'1300' mxh,
'С¼Æ' "ÏÕÖÖ",
0 "Ó¦½ÉÄêÔÂ",
sum(a.eac029) "ÈËÊý",
sum(a.eac018) "½É·Ñ»ùÊý",
sum(a.eac031) "Ó¦½É½ð¶î",
sum(a.eac032) "µ¥Î»²¿·Ö",
sum(kpsj) "µ½Õ˽ð¶î",
sum(b.eac031) "ÒѲ¹½ð¶î",
sum(eac032-nvl(kpsj, 0)-nvl(b.eac031, 0)) "²¹½É½ð¶î",
0 "Äê¶È"
from
(
select substr(x.eae003, 0, 4) yearno, x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029,
sum(eac018) eac018 , sum(eac031) eac031 , sum(eac032) eac032 , kpsj from
(SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032,
b.aab030, b.aab004
FROM ACA6 a , ab01 b WHERE a.aab001=b.aab001 and a.aab033 ='2' and
a.AAB001 ='00020366' AND AAE140 ='01'
AND EAE003 >=200707 AND AAE109 ='0') X ,
(
SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8
WHERE aae140 ='01' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140
) Y
WHERE x.aab030=y.AAB030(+) and x.eae003=y.eae003(+)
group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj
) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b
where a.aab001=
b.aab001(+) and a.aae140=b.aae140(+) and a.eae003=b.eae003(+)
and substr(a.eae003, 0, 4)>='2007' and substr(a.eae003, 0, 4)<='2013'
group by a.aae140 , a.yearno
union
select mxh,
"ÏÕÖÖ",
"Ó¦½ÉÄêÔÂ",
sum(ÈËÊý) "ÈËÊý",
sum("½É·Ñ»ùÊý") "½É·Ñ»ùÊý",
sum("Ó¦½É½ð¶î") "Ó¦½É½ð¶î",
sum("µ¥Î»²¿·Ö") "µ¥Î»²¿·Ö",
sum("µ½Õ˽ð¶î") "µ½Õ˽ð¶î",
sum("ÒѲ¹½ð¶î") "ÒѲ¹½ð¶î",
sum("²¹½É½ð¶î") "²¹½É½ð¶î",
0 "Äê¶È"
from (select '99991900' mxh,
'ºÏ¼Æ' "ÏÕÖÖ",
0 "Ó¦½ÉÄêÔÂ",
sum(a.eac029) "ÈËÊý",
sum(a.eac018) "½É·Ñ»ùÊý",
sum(a.eac031) "Ó¦½É½ð¶î",
sum(a.eac032) "µ¥Î»²¿·Ö",
sum(kpsj) "µ½Õ˽ð¶î",
sum(b.eac031) "ÒѲ¹½ð¶î",
sum(eac032 - nvl(kpsj, 0) - nvl(b.eac031, 0)) "²¹½É½ð¶î",
a.yearno "Äê¶È"
from (select substr(x.eae003, 0, 4) yearno,
x.aab001,
x.aab004,
x.aae140,
x.eae003,
sum(eac029) eac029,
sum(eac018) eac018,
sum(eac031) eac031,
sum(eac032) eac032,
kpsj
from (SELECT a.AAB001,
aae140,
eac029,
EAE003,
EAC018,
EAC031,
EAC032,
b.aab030,
b.aab004
FROM ACA6 a, ab01 b
WHERE a.aab001 = b.aab001
and a.aab033 = '2'
and a.AAB001 ='00020366'
AND AAE140 = '01'
AND EAE003 >= 200707
AND AAE109 = '0') X,
(SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj
FROM ABE8
WHERE aae140 = '01'
and aab400 not in
('2940200', '2940201', '2940501', '2940500')
GROUP BY AAB030, EAE003, aae140) Y
WHERE x.aab030 = y.AAB030(+)
and x.eae003 = y.eae003(+)
group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj) a,
(select aae140, aab001, eae003, sum(eac031) eac031
from abe9
group by aae140, aab001, eae003) b
where a.aab001 = b.aab001(+)
and a.aae140 = b.aae140
(+)
and a.eae003 = b.eae003(+)
and substr(a.eae003, 0, 4) >= '2007'
and substr(a.eae003, 0, 4) <= '2013'
group by a.aae140, a.yearno
having sum(eac032 - nvl(kpsj, 0) - nvl(b.eac031, 0)) > 0)
group by mxh, "ÏÕÖÖ", "Ó¦½ÉÄêÔÂ"
) order by mxh
|
| 6rxn7z9hvwzdr | select output from table(dbms_workload_repository.awr_global_report_html( :dbid,
:instl,
:bid, :eid,
:rpt_options )) |
| 94j0sq5fby1m2 | UPDATE ABE8_IN SET AAB001 =:B2 WHERE SENOXH=:B1 |
| 9z7g3nw6ggjtn | select count(*) from (select distinct n.eac001, n.aac157, n.aac003, (select a.aaa103 aac004 from v_AA10 a where a.aaa100 = 'AAC004' and a.aaa102=aac004), (select a.aaa103 aac008 from v_AA10 a where a.aaa100 = 'AAC008' and a.aaa102=aac008) , (select a.aaa103 eac067 from v_AA10 a where a.aaa100 = 'EAC067' and a.aaa102=eac067), n.aac039, to_char(aae030, 'yyyy-mm-dd') from net_ac03 n , net_ac15 m where n.aac001=m.aac001 and n.aab001='00032153' and n.eac067='0' and m.aae140= '04') |
| af43g452zvqnj | SELECT COUNT(*) FROM LQ_AC02 A , LQ_AC01 T WHERE (T.AAC157 =:B2 OR T.AAC157=:B1 ) AND F_CEB_ZTZD(T.AAC001)>0 AND T.AAC001 =A.AAC001 AND A.AAE140 ='01' |
| ah5nvjbnnvh6y |
select * from (
select
a.eae003||'00' mxh,
(select aaa103 from aa10 where aaa100 ='AAE140' and aaa102 =a.aae140) "ÏÕÖÖ",
a.eae003 "Ó¦½ÉÄêÔÂ",
a.eac029 "ÈËÊý",
a.eac018 "½É·Ñ»ùÊý",
a.eac031 "Ó¦½É½ð¶î",
a.eac032 "µ¥Î»²¿·Ö",
kpsj "µ½Õ˽ð¶î",
b.eac031 "ÒѲ¹½ð¶î",
eac032-nvl(kpsj, 0)-nvl(b.eac031, 0) "²¹½É½ð¶î",
0 "Äê¶È"
from
(
select x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029,
sum(eac018) eac018 , sum(eac031) eac031 , sum(eac032) eac032 , kpsj from
(SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032,
b.aab030, b.aab004
FROM ACA6 a , ab01 b WHERE a.aab001=b.aab001 and a.aab033 ='2' and
a.AAB001 ='00020750' AND AAE140 ='04'
AND EAE003 >=200707 AND AAE109 ='0') X ,
(
SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8
WHERE aae140 ='04' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140
) Y
WHERE x.aab030=y.AAB030(+) and x.eae003=y.eae003(+)
group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj
) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b
where a.aab001=b.aab001(+) and a.aae140=b.aae140(+) and a.eae003=b.eae003(+)
and substr(a.eae003, 0, 4)>='2007' and substr(a.eae003, 0, 4)<='2013'
union
select
a.yearno||'1300' mxh,
'С¼Æ' "ÏÕÖÖ",
0 "Ó¦½ÉÄêÔÂ",
sum(a.eac029) "ÈËÊý",
sum(a.eac018) "½É·Ñ»ùÊý",
sum(a.eac031) "Ó¦½É½ð¶î",
sum(a.eac032) "µ¥Î»²¿·Ö",
sum(kpsj) "µ½Õ˽ð¶î",
sum(b.eac031) "ÒѲ¹½ð¶î",
sum(eac032-nvl(kpsj, 0)-nvl(b.eac031, 0)) "²¹½É½ð¶î",
0 "Äê¶È"
from
(
select substr(x.eae003, 0, 4) yearno, x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029,
sum(eac018) eac018 , sum(eac031) eac031 , sum(eac032) eac032 , kpsj from
(SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032,
b.aab030, b.aab004
FROM ACA6 a , ab01 b WHERE a.aab001=b.aab001 and a.aab033 ='2' and
a.AAB001 ='00020750' AND AAE140 ='04'
AND EAE003 >=200707 AND AAE109 ='0') X ,
(
SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8
WHERE aae140 ='04' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140
) Y
WHERE x.aab030=y.AAB030(+) and x.eae003=y.eae003(+)
group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj
) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b
where a.aab001=
b.aab001(+) and a.aae140=b.aae140(+) and a.eae003=b.eae003(+)
and substr(a.eae003, 0, 4)>='2007' and substr(a.eae003, 0, 4)<='2013'
group by a.aae140 , a.yearno
union
select mxh,
"ÏÕÖÖ",
"Ó¦½ÉÄêÔÂ",
sum(ÈËÊý) "ÈËÊý",
sum("½É·Ñ»ùÊý") "½É·Ñ»ùÊý",
sum("Ó¦½É½ð¶î") "Ó¦½É½ð¶î",
sum("µ¥Î»²¿·Ö") "µ¥Î»²¿·Ö",
sum("µ½Õ˽ð¶î") "µ½Õ˽ð¶î",
sum("ÒѲ¹½ð¶î") "ÒѲ¹½ð¶î",
sum("²¹½É½ð¶î") "²¹½É½ð¶î",
0 "Äê¶È"
from (select '99991900' mxh,
'ºÏ¼Æ' "ÏÕÖÖ",
0 "Ó¦½ÉÄêÔÂ",
sum(a.eac029) "ÈËÊý",
sum(a.eac018) "½É·Ñ»ùÊý",
sum(a.eac031) "Ó¦½É½ð¶î",
sum(a.eac032) "µ¥Î»²¿·Ö",
sum(kpsj) "µ½Õ˽ð¶î",
sum(b.eac031) "ÒѲ¹½ð¶î",
sum(eac032 - nvl(kpsj, 0) - nvl(b.eac031, 0)) "²¹½É½ð¶î",
a.yearno "Äê¶È"
from (select substr(x.eae003, 0, 4) yearno,
x.aab001,
x.aab004,
x.aae140,
x.eae003,
sum(eac029) eac029,
sum(eac018) eac018,
sum(eac031) eac031,
sum(eac032) eac032,
kpsj
from (SELECT a.AAB001,
aae140,
eac029,
EAE003,
EAC018,
EAC031,
EAC032,
b.aab030,
b.aab004
FROM ACA6 a, ab01 b
WHERE a.aab001 = b.aab001
and a.aab033 = '2'
and a.AAB001 ='00020750'
AND AAE140 = '04'
AND EAE003 >= 200707
AND AAE109 = '0') X,
(SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj
FROM ABE8
WHERE aae140 = '04'
and aab400 not in
('2940200', '2940201', '2940501', '2940500')
GROUP BY AAB030, EAE003, aae140) Y
WHERE x.aab030 = y.AAB030(+)
and x.eae003 = y.eae003(+)
group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj) a,
(select aae140, aab001, eae003, sum(eac031) eac031
from abe9
group by aae140, aab001, eae003) b
where a.aab001 = b.aab001(+)
and a.aae140 = b.aae140
(+)
and a.eae003 = b.eae003(+)
and substr(a.eae003, 0, 4) >= '2007'
and substr(a.eae003, 0, 4) <= '2013'
group by a.aae140, a.yearno
having sum(eac032 - nvl(kpsj, 0) - nvl(b.eac031, 0)) > 0)
group by mxh, "ÏÕÖÖ", "Ó¦½ÉÄêÔÂ"
) order by mxh
|
| b1yr7by0yxh8g | UPDATE SBDI_TAXRETDT A SET MEMO =(SELECT AAE113||'*'||FLAG FROM ABE8_IN B WHERE A.DSWYM=B.DSWYBM AND B.FLAG='1') WHERE EXISTS(SELECT 1 FROM ABE8_IN B WHERE A.DSWYM=B.DSWYBM AND B.FLAG='1') |
| b3nb968007tch | INSERT INTO DB04 VALUES (:B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , :B20 , :B21 , :B22 , :B23 , :B24 , :B25 , :B26 , :B27 , :B28 , :B29 , :B30 , :B31 , :B32 ) |
| bdhjwbdzr8h56 | INSERT INTO ABE8_IN(SENOXH, AAB034, AAB030, AAB400, AAE002, AAB401, EAC031, AAB162, AAB128, AAB402, AAB403, AAB404, AAE063, AAB004, DSWYBM, FLAG) SELECT SEQ_LINKID.NEXTVAL, ZGSBBM, SBBM, JJXLBM, SSNF||SSYF, SPH, KPSJ, ZNJ, LX, KPRQ, SJRQ, JSBJ, '', '', DSWYM, '' FROM SBDI_TAXRETDT WHERE ZTLB =0 AND RZBZ =0 AND SBBM =NVL(:B1 , SBBM) |
| bfk9r60dafz4c | select * from (select rownum as numrow, c.* from (select distinct n.eac001, n.aac157, n.aac003, (select a.aaa103 aac004 from v_AA10 a where a.aaa100 = 'AAC004' and a.aaa102=aac004), (select a.aaa103 aac008 from v_AA10 a where a.aaa100 = 'AAC008' and a.aaa102=aac008) , (select a.aaa103 eac067 from v_AA10 a where a.aaa100 = 'EAC067' and a.aaa102=eac067), n.aac039, to_char(aae030, 'yyyy-mm-dd') from net_ac03 n , net_ac15 m where n.aac001=m.aac001 and n.aab001='00032153' and n.eac067='0' and m.aae140= '04') c) where numrow>=1 and numrow<=5000 |
| bjqcvk0khru4h | SELECT T.AAC001 FROM LQ_AC02 A , LQ_AC01 T WHERE (T.AAC157 =:B2 OR T.AAC157=:B1 ) AND F_CEB_ZTZD(T.AAC001)>0 AND T.AAC001 =A.AAC001 AND ROWNUM=1 |
| c8jq3xd9s7wfw | BEGIN NET_CHECK_PERSONZHONGDUAN(:1, :2, :3, :4); END; |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| cxn009qhp21hs | select smtfunctio0_.FUNCTIONID as FUNCTIONID59_, smtfunctio0_.LOCATION as LOCATION59_, smtfunctio0_.TITLE as TITLE59_, smtfunctio0_.PARENT as PARENT59_, smtfunctio0_.ORDERNO as ORDERNO59_, smtfunctio0_.TYPE as TYPE59_, smtfunctio0_.DESCRIPTION as DESCRIPT7_59_, smtfunctio0_.LOG as LOG59_, smtfunctio0_.DEVELOPER as DEVELOPER59_, smtfunctio0_.ACTIVE as ACTIVE59_, smtfunctio0_.FUNCTIONDESC as FUNCTIO11_59_, smtfunctio0_.AUFLAG as AUFLAG59_, smtfunctio0_.RPFLAG as RPFLAG59_, smtfunctio0_.UPTYPE as UPTYPE59_, smtfunctio0_.PUBLICFLAG as PUBLICFLAG59_, smtfunctio0_.PRSOURCE as PRSOURCE59_, smtfunctio0_.RBFLAG as RBFLAG59_, smtfunctio0_.PARAM1 as PARAM18_59_, smtfunctio0_.PARAM2 as PARAM19_59_, smtfunctio0_.VSCLASS as VSCLASS59_, smtfunctio0_.SYSID as SYSID59_, smtfunctio0_.FIRSTOPEN as FIRSTOPEN59_, smtfunctio0_.FOCANCLOSE as FOCANCLOSE59_, smtfunctio0_.REAUFLAG as REAUFLAG59_, smtfunctio0_.CREATEDATE as CREATEDATE59_, smtfunctio0_.OWNER as OWNER59_, smtfunctio0_.RESOURCEID as RESOURCEID59_, smtfunctio0_.APPID as APPID59_, smtfunctio0_.ISPROXY as ISPROXY59_ from SMT_FUNCTION smtfunctio0_ where smtfunctio0_.LOCATION=:1 |
| cz6n4s53dxfnw | select count(*) from (select distinct n.eac001, n.aac157, n.aac003, (select a.aaa103 aac004 from v_AA10 a where a.aaa100 = 'AAC004' and a.aaa102=aac004), (select a.aaa103 aac008 from v_AA10 a where a.aaa100 = 'AAC008' and a.aaa102=aac008) , (select a.aaa103 eac067 from v_AA10 a where a.aaa100 = 'EAC067' and a.aaa102=eac067), n.aac039, to_char(aae030, 'yyyy-mm-dd') from net_ac03 n , net_ac15 m where n.aac001=m.aac001 and n.aab001='00033228' and m.aae140= '01') |
| d2svfdrr4cnz0 | Insert Into Link_TradeData(ID, LinkID, TRADETYPE, ROWSNO, TEXTMsg, DoFLAG)
values(SEQ_TRADEDATAID.NEXTVAL, :V00001, :V00002, :V00003, :V00004, '0')
|
| dc9bdxa7xpv8s |
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.all_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.all_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.all_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.all_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 all_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.all_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 all_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.all_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.all_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.all_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;
|
| dun49xt413hb4 |
select * from (
select
a.eae003||'00' mxh,
(select aaa103 from aa10 where aaa100 ='AAE140' and aaa102 =a.aae140) "ÏÕÖÖ",
a.eae003 "Ó¦½ÉÄêÔÂ",
a.eac029 "ÈËÊý",
a.eac018 "½É·Ñ»ùÊý",
a.eac031 "Ó¦½É½ð¶î",
a.eac032 "µ¥Î»²¿·Ö",
kpsj "µ½Õ˽ð¶î",
b.eac031 "ÒѲ¹½ð¶î",
eac032-nvl(kpsj, 0)-nvl(b.eac031, 0) "²¹½É½ð¶î",
0 "Äê¶È"
from
(
select x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029,
sum(eac018) eac018 , sum(eac031) eac031 , sum(eac032) eac032 , kpsj from
(SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032,
b.aab030, b.aab004
FROM ACA6 a , ab01 b WHERE a.aab001=b.aab001 and a.aab033 ='2' and
a.AAB001 ='00032185' AND AAE140 ='01'
AND EAE003 >=200707 AND AAE109 ='0') X ,
(
SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8
WHERE aae140 ='01' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140
) Y
WHERE x.aab030=y.AAB030(+) and x.eae003=y.eae003(+)
group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj
) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b
where a.aab001=b.aab001(+) and a.aae140=b.aae140(+) and a.eae003=b.eae003(+)
and substr(a.eae003, 0, 4)>='2007' and substr(a.eae003, 0, 4)<='2013'
union
select
a.yearno||'1300' mxh,
'С¼Æ' "ÏÕÖÖ",
0 "Ó¦½ÉÄêÔÂ",
sum(a.eac029) "ÈËÊý",
sum(a.eac018) "½É·Ñ»ùÊý",
sum(a.eac031) "Ó¦½É½ð¶î",
sum(a.eac032) "µ¥Î»²¿·Ö",
sum(kpsj) "µ½Õ˽ð¶î",
sum(b.eac031) "ÒѲ¹½ð¶î",
sum(eac032-nvl(kpsj, 0)-nvl(b.eac031, 0)) "²¹½É½ð¶î",
0 "Äê¶È"
from
(
select substr(x.eae003, 0, 4) yearno, x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029,
sum(eac018) eac018 , sum(eac031) eac031 , sum(eac032) eac032 , kpsj from
(SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032,
b.aab030, b.aab004
FROM ACA6 a , ab01 b WHERE a.aab001=b.aab001 and a.aab033 ='2' and
a.AAB001 ='00032185' AND AAE140 ='01'
AND EAE003 >=200707 AND AAE109 ='0') X ,
(
SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8
WHERE aae140 ='01' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140
) Y
WHERE x.aab030=y.AAB030(+) and x.eae003=y.eae003(+)
group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj
) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b
where a.aab001=
b.aab001(+) and a.aae140=b.aae140(+) and a.eae003=b.eae003(+)
and substr(a.eae003, 0, 4)>='2007' and substr(a.eae003, 0, 4)<='2013'
group by a.aae140 , a.yearno
union
select mxh,
"ÏÕÖÖ",
"Ó¦½ÉÄêÔÂ",
sum(ÈËÊý) "ÈËÊý",
sum("½É·Ñ»ùÊý") "½É·Ñ»ùÊý",
sum("Ó¦½É½ð¶î") "Ó¦½É½ð¶î",
sum("µ¥Î»²¿·Ö") "µ¥Î»²¿·Ö",
sum("µ½Õ˽ð¶î") "µ½Õ˽ð¶î",
sum("ÒѲ¹½ð¶î") "ÒѲ¹½ð¶î",
sum("²¹½É½ð¶î") "²¹½É½ð¶î",
0 "Äê¶È"
from (select '99991900' mxh,
'ºÏ¼Æ' "ÏÕÖÖ",
0 "Ó¦½ÉÄêÔÂ",
sum(a.eac029) "ÈËÊý",
sum(a.eac018) "½É·Ñ»ùÊý",
sum(a.eac031) "Ó¦½É½ð¶î",
sum(a.eac032) "µ¥Î»²¿·Ö",
sum(kpsj) "µ½Õ˽ð¶î",
sum(b.eac031) "ÒѲ¹½ð¶î",
sum(eac032 - nvl(kpsj, 0) - nvl(b.eac031, 0)) "²¹½É½ð¶î",
a.yearno "Äê¶È"
from (select substr(x.eae003, 0, 4) yearno,
x.aab001,
x.aab004,
x.aae140,
x.eae003,
sum(eac029) eac029,
sum(eac018) eac018,
sum(eac031) eac031,
sum(eac032) eac032,
kpsj
from (SELECT a.AAB001,
aae140,
eac029,
EAE003,
EAC018,
EAC031,
EAC032,
b.aab030,
b.aab004
FROM ACA6 a, ab01 b
WHERE a.aab001 = b.aab001
and a.aab033 = '2'
and a.AAB001 ='00032185'
AND AAE140 = '01'
AND EAE003 >= 200707
AND AAE109 = '0') X,
(SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj
FROM ABE8
WHERE aae140 = '01'
and aab400 not in
('2940200', '2940201', '2940501', '2940500')
GROUP BY AAB030, EAE003, aae140) Y
WHERE x.aab030 = y.AAB030(+)
and x.eae003 = y.eae003(+)
group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj) a,
(select aae140, aab001, eae003, sum(eac031) eac031
from abe9
group by aae140, aab001, eae003) b
where a.aab001 = b.aab001(+)
and a.aae140 = b.aae140
(+)
and a.eae003 = b.eae003(+)
and substr(a.eae003, 0, 4) >= '2007'
and substr(a.eae003, 0, 4) <= '2013'
group by a.aae140, a.yearno
having sum(eac032 - nvl(kpsj, 0) - nvl(b.eac031, 0)) > 0)
group by mxh, "ÏÕÖÖ", "Ó¦½ÉÄêÔÂ"
) order by mxh
|
| f711myt0q6cma | insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22) |
| fhw2qjm168nwy | SELECT SB_PRSENO.NEXTVAL FROM DUAL |
| fknbhyzkvjzv3 | begin LinkConsole.Ora_Trade4211_Update(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006); end; |
| ftj9uawt4wwzb | select condition from cdef$ where rowid=:1 |
| g8parww8h2a2x | SELECT A.SBBM, A.YWLSH, A.YWOPLSH, B.JZRQ, '01' PDCODE , A.SSNF, A.SSYF FROM (SELECT SBBM, SSNF, SSYF, YWLSH, SUM(YZJE) YZJE, YWOPLSH FROM SBDI_TAXEXP A WHERE A.OPFLAG='1' AND A.DZBZ ='0' AND A.ZTLB='1' AND A.EAE024='0' AND A.CSBZ='1' AND A.SBBM=NVL(:B1 , A.SBBM) AND A.YWOPLSH IS NOT NULL AND A.YWOPLSH<>0 AND A.JJXLBM IN ('2940502', '2940503') GROUP BY SBBM, SSNF, SSYF, YWLSH, YWOPLSH) A, (SELECT SBBM, SSNF, SSYF, YWLSH, SUM(KPSJ) SJJE, MAX(SJRQ) JZRQ FROM SBDI_TAXRETDT A WHERE ZTLB =1 AND RZBZ =0 AND YWLSH IS NOT NULL AND A.SBBM=NVL(:B1 , A.SBBM) AND A.JJXLBM IN ('2940502', '2940503') GROUP BY SBBM, SSNF, SSYF, YWLSH) B WHERE A.SBBM=B.SBBM AND A.SSNF=B.SSNF AND A.SSYF=B.SSYF AND A.YWLSH=B.YWLSH AND A.YZJE=B.SJJE |
| g9mf5tc7a85kr | SELECT MIN(BATCH_ID) FROM REPEXECBATCH WHERE BATCH_STATUS='BEGIN'
|
| grwydz59pu6mc | select text from view$ where rowid=:1 |
| Statistic | Total | per Second | per Trans |
|---|
| Batched IO (bound) vector count | 29 | 0.01 | 0.02 |
| Batched IO (full) vector count | 2 | 0.00 | 0.00 |
| Batched IO block miss count | 1,043 | 0.29 | 0.72 |
| Batched IO buffer defrag count | 2 | 0.00 | 0.00 |
| Batched IO double miss count | 17 | 0.00 | 0.01 |
| Batched IO same unit count | 420 | 0.12 | 0.29 |
| Batched IO single block count | 10 | 0.00 | 0.01 |
| Batched IO slow jump count | 0 | 0.00 | 0.00 |
| Batched IO vector block count | 614 | 0.17 | 0.42 |
| Batched IO vector read count | 31 | 0.01 | 0.02 |
| Block Cleanout Optim referenced | 180 | 0.05 | 0.12 |
| CCursor + sql area evicted | 0 | 0.00 | 0.00 |
| CPU used by this session | 37,716 | 10.58 | 25.87 |
| CPU used when call started | 36,546 | 10.25 | 25.07 |
| CR blocks created | 40 | 0.01 | 0.03 |
| Cached Commit SCN referenced | 0 | 0.00 | 0.00 |
| Clusterwide global transactions | 5 | 0.00 | 0.00 |
| Clusterwide global transactions spanning RAC nodes | 0 | 0.00 | 0.00 |
| Commit SCN cached | 3 | 0.00 | 0.00 |
| DB time | 426,129 | 119.49 | 292.27 |
| DBWR checkpoint buffers written | 2,544 | 0.71 | 1.74 |
| DBWR checkpoints | 0 | 0.00 | 0.00 |
| DBWR fusion writes | 294 | 0.08 | 0.20 |
| DBWR object drop buffers written | 0 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR transaction table writes | 166 | 0.05 | 0.11 |
| DBWR undo block writes | 632 | 0.18 | 0.43 |
| DFO trees parallelized | 65 | 0.02 | 0.04 |
| DX/BB enqueue lock background get time | 0 | 0.00 | 0.00 |
| DX/BB enqueue lock background gets | 10 | 0.00 | 0.01 |
| DX/BB enqueue lock foreground requests | 6,537 | 1.83 | 4.48 |
| DX/BB enqueue lock foreground wait time | 18 | 0.01 | 0.01 |
| Effective IO time | 659,728 | 184.99 | 452.49 |
| GTX processes spawned by autotune | 0 | 0.00 | 0.00 |
| GTX processes stopped by autotune | 0 | 0.00 | 0.00 |
| HSC Heap Segment Block Changes | 13,512 | 3.79 | 9.27 |
| HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
| Heap Segment Array Inserts | 123 | 0.03 | 0.08 |
| Heap Segment Array Updates | 16 | 0.00 | 0.01 |
| LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
| Number of read IOs issued | 442 | 0.12 | 0.30 |
| PX local messages recv'd | 390 | 0.11 | 0.27 |
| PX local messages sent | 390 | 0.11 | 0.27 |
| PX remote messages recv'd | 1,575 | 0.44 | 1.08 |
| PX remote messages sent | 172 | 0.05 | 0.12 |
| Parallel operations not downgraded | 65 | 0.02 | 0.04 |
| RowCR - row contention | 2 | 0.00 | 0.00 |
| RowCR attempts | 157 | 0.04 | 0.11 |
| RowCR hits | 683 | 0.19 | 0.47 |
| SMON posted for undo segment recovery | 1 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 1 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 414,776 | 116.31 | 284.48 |
| SQL*Net roundtrips to/from dblink | 161 | 0.05 | 0.11 |
| active txn count during cleanout | 376 | 0.11 | 0.26 |
| application wait time | 1 | 0.00 | 0.00 |
| background checkpoints completed | 0 | 0.00 | 0.00 |
| background checkpoints started | 0 | 0.00 | 0.00 |
| background timeouts | 27,903 | 7.82 | 19.14 |
| branch node splits | 0 | 0.00 | 0.00 |
| buffer is not pinned count | 15,009,958 | 4,208.93 | 10,294.90 |
| buffer is pinned count | 18,483,914 | 5,183.06 | 12,677.58 |
| bytes received via SQL*Net from client | 32,381,724 | 9,080.14 | 22,209.69 |
| bytes received via SQL*Net from dblink | 21,994 | 6.17 | 15.09 |
| bytes sent via SQL*Net to client | 91,643,785 | 25,697.78 | 62,855.82 |
| bytes sent via SQL*Net to dblink | 87,991 | 24.67 | 60.35 |
| calls to get snapshot scn: kcmgss | 3,270,850 | 917.18 | 2,243.38 |
| calls to kcmgas | 9,372 | 2.63 | 6.43 |
| calls to kcmgcs | 24,245 | 6.80 | 16.63 |
| cell physical IO interconnect bytes | 916,441,088 | 256,978.71 | 628,560.42 |
| change write time | 80 | 0.02 | 0.05 |
| cleanout - number of ktugct calls | 823 | 0.23 | 0.56 |
| cleanouts and rollbacks - consistent read gets | 1 | 0.00 | 0.00 |
| cleanouts only - consistent read gets | 404 | 0.11 | 0.28 |
| cluster key scan block gets | 682,233 | 191.30 | 467.92 |
| cluster key scans | 473,382 | 132.74 | 324.68 |
| cluster wait time | 4,740 | 1.33 | 3.25 |
| commit batch performed | 1 | 0.00 | 0.00 |
| commit batch requested | 1 | 0.00 | 0.00 |
| commit batch/immediate performed | 33 | 0.01 | 0.02 |
| commit batch/immediate requested | 33 | 0.01 | 0.02 |
| commit cleanout failures: block lost | 0 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 85 | 0.02 | 0.06 |
| commit cleanout failures: cannot pin | 0 | 0.00 | 0.00 |
| commit cleanouts | 11,276 | 3.16 | 7.73 |
| commit cleanouts successfully completed | 11,191 | 3.14 | 7.68 |
| commit immediate performed | 32 | 0.01 | 0.02 |
| commit immediate requested | 32 | 0.01 | 0.02 |
| commit txn count during cleanout | 1,797 | 0.50 | 1.23 |
| concurrency wait time | 478 | 0.13 | 0.33 |
| consistent changes | 170,790 | 47.89 | 117.14 |
| consistent gets | 21,149,348 | 5,930.48 | 14,505.73 |
| consistent gets - examination | 1,030,487 | 288.96 | 706.78 |
| consistent gets direct | 53,742 | 15.07 | 36.86 |
| consistent gets from cache | 21,095,606 | 5,915.41 | 14,468.87 |
| consistent gets from cache (fastpath) | 19,636,093 | 5,506.15 | 13,467.83 |
| cursor authentications | 882 | 0.25 | 0.60 |
| data blocks consistent reads - undo records applied | 8,428 | 2.36 | 5.78 |
| db block changes | 238,264 | 66.81 | 163.42 |
| db block gets | 573,604 | 160.84 | 393.42 |
| db block gets direct | 299 | 0.08 | 0.21 |
| db block gets from cache | 573,305 | 160.76 | 393.21 |
| db block gets from cache (fastpath) | 21,477 | 6.02 | 14.73 |
| deferred (CURRENT) block cleanout applications | 5,650 | 1.58 | 3.88 |
| dirty buffers inspected | 4 | 0.00 | 0.00 |
| enqueue conversions | 987 | 0.28 | 0.68 |
| enqueue releases | 58,657 | 16.45 | 40.23 |
| enqueue requests | 59,877 | 16.79 | 41.07 |
| enqueue timeouts | 1,217 | 0.34 | 0.83 |
| enqueue waits | 1,414 | 0.40 | 0.97 |
| exchange deadlocks | 0 | 0.00 | 0.00 |
| execute count | 3,083,315 | 864.59 | 2,114.76 |
| file io service time | 0 | 0.00 | 0.00 |
| file io wait time | 17,681,965 | 4,958.19 | 12,127.55 |
| free buffer inspected | 132,481 | 37.15 | 90.86 |
| free buffer requested | 198,508 | 55.66 | 136.15 |
| gc blocks compressed | 1,511 | 0.42 | 1.04 |
| gc cr block flush time | 2 | 0.00 | 0.00 |
| gc cr block receive time | 9,216 | 2.58 | 6.32 |
| gc cr blocks received | 28,084 | 7.88 | 19.26 |
| gc cr blocks served | 1,248 | 0.35 | 0.86 |
| gc current block flush time | 5 | 0.00 | 0.00 |
| gc current block receive time | 21,541 | 6.04 | 14.77 |
| gc current blocks received | 106,614 | 29.90 | 73.12 |
| gc current blocks served | 2,178 | 0.61 | 1.49 |
| gc kbytes saved | 7,344 | 2.06 | 5.04 |
| gc kbytes sent | 20,064 | 5.63 | 13.76 |
| gc local grants | 14,367 | 4.03 | 9.85 |
| gc remote grants | 10,320 | 2.89 | 7.08 |
| gcs messages sent | 229,951 | 64.48 | 157.72 |
| ges messages sent | 6,241 | 1.75 | 4.28 |
| global enqueue get time | 384 | 0.11 | 0.26 |
| global enqueue gets async | 2,538 | 0.71 | 1.74 |
| global enqueue gets sync | 142,966 | 40.09 | 98.06 |
| global enqueue releases | 139,286 | 39.06 | 95.53 |
| heap block compress | 4,689 | 1.31 | 3.22 |
| hot buffers moved to head of LRU | 43,003 | 12.06 | 29.49 |
| immediate (CR) block cleanout applications | 405 | 0.11 | 0.28 |
| immediate (CURRENT) block cleanout applications | 904 | 0.25 | 0.62 |
| index crx upgrade (positioned) | 229 | 0.06 | 0.16 |
| index fast full scans (full) | 219 | 0.06 | 0.15 |
| index fetch by key | 996,629 | 279.46 | 683.56 |
| index scans kdiixs1 | 1,080,079 | 302.86 | 740.79 |
| leaf node 90-10 splits | 25 | 0.01 | 0.02 |
| leaf node splits | 105 | 0.03 | 0.07 |
| lob reads | 55,150 | 15.46 | 37.83 |
| lob writes | 45,110 | 12.65 | 30.94 |
| lob writes unaligned | 45,089 | 12.64 | 30.93 |
| logons cumulative | 870 | 0.24 | 0.60 |
| max cf enq hold time | 0 | 0.00 | 0.00 |
| messages received | 10,702 | 3.00 | 7.34 |
| messages sent | 10,702 | 3.00 | 7.34 |
| min active SCN optimization applied on CR | 20 | 0.01 | 0.01 |
| no buffer to keep pinned count | 225 | 0.06 | 0.15 |
| no work - consistent read gets | 20,022,251 | 5,614.43 | 13,732.68 |
| non-idle wait count | 707,146 | 198.29 | 485.01 |
| non-idle wait time | 64,536 | 18.10 | 44.26 |
| opened cursors cumulative | 3,081,593 | 864.11 | 2,113.58 |
| parse count (describe) | 19 | 0.01 | 0.01 |
| parse count (failures) | 933 | 0.26 | 0.64 |
| parse count (hard) | 3,243 | 0.91 | 2.22 |
| parse count (total) | 147,005 | 41.22 | 100.83 |
| parse time cpu | 2,234 | 0.63 | 1.53 |
| parse time elapsed | 2,178 | 0.61 | 1.49 |
| physical read IO requests | 9,767 | 2.74 | 6.70 |
| physical read bytes | 650,444,800 | 182,390.85 | 446,121.26 |
| physical read total IO requests | 18,876 | 5.29 | 12.95 |
| physical read total bytes | 799,496,192 | 224,186.26 | 548,351.30 |
| physical read total multi block requests | 604 | 0.17 | 0.41 |
| physical reads | 79,400 | 22.26 | 54.46 |
| physical reads cache | 23,234 | 6.52 | 15.94 |
| physical reads cache prefetch | 16,181 | 4.54 | 11.10 |
| physical reads direct | 56,166 | 15.75 | 38.52 |
| physical reads direct (lob) | 21 | 0.01 | 0.01 |
| physical reads direct temporary tablespace | 2,424 | 0.68 | 1.66 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 2,473 | 0.69 | 1.70 |
| physical write bytes | 45,162,496 | 12,663.99 | 30,975.65 |
| physical write total IO requests | 13,005 | 3.65 | 8.92 |
| physical write total bytes | 116,944,896 | 32,792.45 | 80,209.12 |
| physical write total multi block requests | 102 | 0.03 | 0.07 |
| physical writes | 5,513 | 1.55 | 3.78 |
| physical writes direct | 2,723 | 0.76 | 1.87 |
| physical writes direct (lob) | 291 | 0.08 | 0.20 |
| physical writes direct temporary tablespace | 2,428 | 0.68 | 1.67 |
| physical writes from cache | 2,790 | 0.78 | 1.91 |
| physical writes non checkpoint | 3,685 | 1.03 | 2.53 |
| pinned buffers inspected | 7 | 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 | 7 | 0.00 | 0.00 |
| prefetch warmup blocks flushed out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 1 | 0.00 | 0.00 |
| process last non-idle time | 3,601 | 1.01 | 2.47 |
| queries parallelized | 64 | 0.02 | 0.04 |
| recursive calls | 3,315,254 | 929.63 | 2,273.84 |
| recursive cpu usage | 20,705 | 5.81 | 14.20 |
| redo KB read | 0 | 0.00 | 0.00 |
| redo blocks checksummed by FG (exclusive) | 4,777 | 1.34 | 3.28 |
| redo blocks written | 30,455 | 8.54 | 20.89 |
| redo entries | 41,916 | 11.75 | 28.75 |
| redo ordering marks | 194 | 0.05 | 0.13 |
| redo size | 13,970,204 | 3,917.38 | 9,581.76 |
| redo size for direct writes | 15,184 | 4.26 | 10.41 |
| redo subscn max counts | 614 | 0.17 | 0.42 |
| redo synch long waits | 325 | 0.09 | 0.22 |
| redo synch time | 384 | 0.11 | 0.26 |
| redo synch time (usec) | 4,485,614 | 1,257.81 | 3,076.55 |
| redo synch writes | 2,790 | 0.78 | 1.91 |
| redo wastage | 1,050,468 | 294.56 | 720.49 |
| redo write broadcast ack count | 3,504 | 0.98 | 2.40 |
| redo write broadcast ack time | 987,531 | 276.91 | 677.32 |
| redo write time | 598 | 0.17 | 0.41 |
| redo writes | 4,024 | 1.13 | 2.76 |
| rollback changes - undo records applied | 34 | 0.01 | 0.02 |
| rollbacks only - consistent read gets | 229 | 0.06 | 0.16 |
| rows fetched via callback | 250,036 | 70.11 | 171.49 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 59,679 | 16.73 | 40.93 |
| session logical reads | 21,722,952 | 6,091.32 | 14,899.14 |
| shared hash latch upgrades - no wait | 10,990 | 3.08 | 7.54 |
| shared hash latch upgrades - wait | 0 | 0.00 | 0.00 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 54,275 | 15.22 | 37.23 |
| sorts (rows) | 3,402,965 | 954.22 | 2,334.00 |
| sql area evicted | 0 | 0.00 | 0.00 |
| sql area purged | 937 | 0.26 | 0.64 |
| summed dirty queue length | 4 | 0.00 | 0.00 |
| switch current to new buffer | 676 | 0.19 | 0.46 |
| table fetch by rowid | 16,016,621 | 4,491.21 | 10,985.34 |
| table fetch continued row | 39,176 | 10.99 | 26.87 |
| table scan blocks gotten | 4,791,178 | 1,343.49 | 3,286.13 |
| table scan rows gotten | 281,177,458 | 78,844.81 | 192,851.48 |
| table scans (direct read) | 1 | 0.00 | 0.00 |
| table scans (long tables) | 3 | 0.00 | 0.00 |
| table scans (short tables) | 9,514 | 2.67 | 6.53 |
| temp space allocated (bytes) | 0 | 0.00 | 0.00 |
| total cf enq hold time | 10 | 0.00 | 0.01 |
| total number of cf enq holders | 13 | 0.00 | 0.01 |
| total number of times SMON posted | 8 | 0.00 | 0.01 |
| transaction lock background gets | 0 | 0.00 | 0.00 |
| transaction lock foreground requests | 0 | 0.00 | 0.00 |
| transaction lock foreground wait time | 0 | 0.00 | 0.00 |
| transaction rollbacks | 33 | 0.01 | 0.02 |
| 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 | 4,253,544 | 1,192.73 | 2,917.38 |
| user I/O wait time | 1,790 | 0.50 | 1.23 |
| user calls | 427,998 | 120.01 | 293.55 |
| user commits | 1,454 | 0.41 | 1.00 |
| user rollbacks | 4 | 0.00 | 0.00 |
| workarea executions - onepass | 10 | 0.00 | 0.01 |
| workarea executions - optimal | 49,813 | 13.97 | 34.17 |
| write clones created in foreground | 0 | 0.00 | 0.00 |