| SQL Id | SQL Text |
|---|
| 063412ux1n026 | select RADA_CHN_DOR_L3_ST_VW_F_seq.nextval from dual |
| 0v6s91manuhz8 | /* OracleOEM */
SELECT blocking_sid, num_blocked
FROM ( SELECT blocking_sid, SUM(num_blocked) num_blocked
FROM ( SELECT l.id1, l.id2,
MAX(DECODE(l.block, 1, i.instance_name||'-'||l.sid,
2, i.instance_name||'-'||l.sid, 0 )) blocking_sid,
SUM(DECODE(l.request, 0, 0, 1 )) num_blocked
FROM gv$lock l, gv$instance i
WHERE ( l.block!= 0 OR l.request > 0 ) AND
l.inst_id = i.inst_id
GROUP BY l.id1, l.id2)
GROUP BY blocking_sid
ORDER BY num_blocked DESC)
WHERE num_blocked != 0
AND blocking_sid != '0'
|
| 0zha71gxcgdvd | insert into UPAR_ARD_GLB_MUL_MUT_AMD_TAB(V_BBB, V04001_02, V04002_02, V04003_02, V04004_02, V04005_02, V01301, V05001, V06001, V04001, V04002, V04003, V04004, V04005, V04006, V07010, V07002, V08009, V12001, V12003, V13003, V11001, V11002, V11031, V02061, V02062, V02005, V11036, Q07010, Q07002, Q08009, Q12001, Q12003, Q13003, Q11001, Q11002, Q11031, Q02061, Q02062, Q02005, Q11036, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , sysdate, to_date(:43 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:44 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :45 ) |
| 15nn3d1zm3sg0 | SELECT D_STORAGE_SITE, D_FILE_SIZE FROM RADA_CHN_DOR_L3_ST_PD_F_TAB_P WHERE V_FILE_NAME ='RADA_CHN_DOR_L3_ST_PD_CAP.20130330-Z9417-SA.tar' AND D_DATA_ID = 'J.0004.0016.S002' |
| 1814ubjt3w9vh | SELECT D_STORAGE_SITE, D_FILE_SIZE FROM RADA_CHN_DOR_L3_ST_PD_F_TAB_P WHERE V_FILE_NAME ='RADA_CHN_DOR_L3_ST_PD_CAP.20130330-Z9579-SB.tar' AND D_DATA_ID = 'J.0004.0016.S002' |
| 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)) |
| 1j3gndsbfx355 | select UPAR_ARD_G_REP_seq.nextval from dual |
| 1nx1518vff191 | UPDATE MGMT_COLLECTION_TASKS SET TASK_TYPE=NVL(:B14 , TASK_TYPE), PRIORITY=NVL(:B13 , PRIORITY), NEXT_COLLECTION_TIMESTAMP=NVL(:B12 , NEXT_COLLECTION_TIMESTAMP), LAST_COLLECTION_TIMESTAMP=NVL(:B11 , LAST_COLLECTION_TIMESTAMP), ERROR_MESSAGE=:B10 , FAILURES=NVL(:B9 , FAILURES), TOTAL_RUNS=NVL(:B8 , TOTAL_RUNS), MIN_WAIT_TIME=NVL(:B7 , MIN_WAIT_TIME), MAX_WAIT_TIME=NVL(:B6 , MAX_WAIT_TIME), AVG_WAIT_TIME=NVL(:B5 , AVG_WAIT_TIME), MIN_RUN_TIME=NVL(:B4 , MIN_RUN_TIME), MAX_RUN_TIME=NVL(:B3 , MAX_RUN_TIME), AVG_RUN_TIME=NVL(:B2 , AVG_RUN_TIME) WHERE TASK_ID = :B1 RETURNING FREQUENCY_CODE, PRIORITY, TASK_TYPE, NEXT_COLLECTION_TIMESTAMP, TASK_CLASS INTO :O0 , :O1 , :O2 , :O3 , :O4 |
| 1rnmj1y7wwjbv | delete from OCEN_TSC_GLB_MUL_TAB where D_RECORD_ID=:1 |
| 1t9gwmb77gkpu |
insert into SURF_WEA_CHN_MUL_HOR_TAB(V01301, V01300, V05001, V06001, V07001, V07031, V07032_04, V02001, V02301, V_ACODE, V04001, V04002, V04003, V04004, V10004, V10051, V10061, V10062, V10301, V10301_052, V10302, V10302_052, V12001, V12011, V12011_052, V12012, V12012_052, V12405, V12016, V12017, V12003, V13003, V13007, V13007_052, V13004, V13019, V13020, V13021, V13022, V13023, V04080_04, V13011, V13033, V11290, V11291, V11292, V11293, V11296, V11042, V11042_052, V11201, V11202, V11211, V11046, V11046_052, V11503_06, V11504_06, V11503_12, V11504_12, V12120, V12311, V12311_052, V12121, V12121_052, V12013, V12030_005, V12030_010, V12030_015, V12030_020, V12030_040, V12030_080, V12030_160, V12030_320, V12314, V12315, V12315_052, V12316, V12316_052, V20001_701_01, V20001_701_10, V20059, V20059_052, V20001, V20010, V20051, V20011, V20013, V20350_01, V20350_02, V20350_03, V20350_04, V20350_05, V20350_06, V20350_07, V20350_08, V20350_11, V20350_12, V20350_13, V20003, V04080_05, V20004, V20005, V20062, V13013, V13330, V20330_01, V20331_01, V20330_02, V20331_02, Q10004, Q10051, Q10061, Q10062, Q10301, Q10301_052, Q10302, Q10302_052, Q12001, Q12011, Q12011_052, Q12012, Q12012_052, Q12405, Q12016, Q12017, Q12003, Q13003, Q13007, Q13007_052, Q13004, Q13019, Q13020, Q13021, Q13022, Q13023, Q04080_04, Q13011, Q13033, Q11290, Q11291, Q11292, Q11293, Q11296, Q11042, Q11042_052, Q11201, Q11202, Q11211, Q11046, Q11046_052, Q11503_06, Q11504_06, Q11503_12, Q11504_12, Q12120, Q12311, Q12311_052,
Q12121, Q12121_052, Q12013, Q12030_005, Q12030_010, Q12030_015, Q12030_020, Q12030_040, Q12030_080, Q12030_160, Q12030_320, Q12314, Q12315, Q12315_052, Q12316, Q12316_052, Q20001_701_01, Q20001_701_10, Q20059, Q20059_052, Q20001, Q20010, Q20051, Q20011, Q20013, Q20350_01, Q20350_02, Q20350_03, Q20350_04, Q20350_05, Q20350_06, Q20350_07, Q20350_08, Q20350_11, Q20350_12, Q20350_13, Q20003, Q04080_05, Q20004, Q20005, Q20062, Q13013, Q13330, Q20330_01, Q20331_01, Q20330_02, Q20331_02, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 ,
:150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , :177 , :178 , :179 , :180 , :181 , :182 , :183 , :184 , :185 , :186 , :187 , :188 , :189 , :190 , :191 , :192 , :193 , :194 , :195 , :196 , :197 , :198 , :199 , :200 , :201 , :202 , :203 , :204 , :205 , sysdate, to_date(:206 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:207 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :208 ) |
| 1vf5khff1g7dy | select D_FILE_ID from SATE_ORB_RAW_F_TAB where V04001=:1 and V04002=:2 and V04003=:3 and V04004=:4 and V04005=:5 and V04006=:6 and V05040=:7 and V05301=:8 and V05310=:9 and V_CCCC=:10 and V_FILE_FORMAT=:11 and D_DATA_ID=:12 |
| 2h3h5j29r9zhw | insert into RADA_CHN_DOR_L3_ST_PD_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V07021, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , sysdate, to_date(:14 , 'yyyy-mm-dd HH24:MI:SS'), :15 , :16 , :17 , :18 , to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), :20 ) |
| 2j0fw19fph49j |
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 |
| 2skwhauh2cwky | select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user# |
| 2zs9b7qy9qbvy | SELECT D_STORAGE_SITE, D_FILE_SIZE FROM RADA_CHN_DOR_L3_ST_PD_F_TAB_P WHERE V_FILE_NAME ='RADA_CHN_DOR_L3_ST_PD_CAP.20130330-Z9574-SA.tar' AND D_DATA_ID = 'J.0004.0016.S002' |
| 3972rvxu3knn3 | delete from sdo_geor_ddl__table$$ |
| 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 |
| 4krbsq67bv7tj | SELECT D_STORAGE_SITE, D_FILE_SIZE FROM RADA_CHN_DOR_L3_ST_PD_F_TAB_P WHERE V_FILE_NAME ='RADA_CHN_DOR_L3_ST_PD_CAP.20130330-Z9592-SA.tar' AND D_DATA_ID = 'J.0004.0016.S002' |
| 4m4fbgysj8p1u |
/* OracleOEM */ --
-- $Header: dfltAccPwd.sql 05-apr-2007.05:40:10 manosing Exp $
--
-- dfltAccPwd.sql
--
-- Copyright (c) 2006, 2007, Oracle. All rights reserved.
--
-- NAME
-- dfltAccPwd.sql - <one-line expansion of the name>
--
-- DESCRIPTION
-- This script is used by the defaultAccountPasswords metric
-- in the database.xmlp. The sql checks for default accounts
-- with default passwords with the default account left
-- unlocked.
--
-- NOTES
-- <other useful comments, qualifications, etc.>
--
-- MODIFIED (MM/DD/YY)
-- manosing 04/05/07 - modifing query to use sys.user$ table instead of
-- sys.dba_users view
-- rmadampa 07/16/06 - This list has been copied from the DPS
-- tool released in April 2006 CPU to fix
-- bug 5257531.
-- rmadampa 07/16/06 - Created
--
SELECT
'Default account uid/pwd', name
FROM sys.user$
WHERE (name, password) IN (
('AASH', '9B52488370BB3D77'),
('ABA1', '30FD307004F350DE'),
('ABM', 'D0F2982F121C7840'),
('AD_MONITOR', '54F0C83F51B03F49'),
('ADAMS', '72CDEF4A3483F60D'),
('ADS', 'D23F0F5D871EB69F'),
('ADSEUL_US', '4953B2EB6FCB4339'),
('AHL', '7910AE63C9F7EEEE'),
('AHM', '33C2E27CF5E401A4'),
('AK', '8FCB78BBA8A59515'),
('AL', '384B2C568DE4C2B5'),
('ALA1', '90AAC5BD7981A3BA'),
('ALLUSERS', '42F7CD03B7D2CA0F'),
('ALR', 'BE89B24F
9F8231A9'),
('AMA1', '585565C23AB68F71'),
('AMA2', '37E458EE1688E463'),
('AMA3', '81A66D026DC5E2ED'),
('AMA4', '194CCC94A481DCDE'),
('AMF', 'EC9419F55CDC666B'),
('AMS', 'BD821F59270E5F34'),
('AMS1', 'DB8573759A76394B'),
('AMS2', 'EF611999C6AD1FD7'),
('AMS3', '41D1084F3F966440'),
('AMS4', '5F5903367FFFB3A3'),
('AMSYS', '4C1EF14ECE13B5DE'),
('AMV', '38BC87EB334A1AC4'),
('AMW', '0E123471AACA2A62'),
('ANNE', '1EEA3E6F588599A6'),
('ANONYMOUS', '94C33111FD9C66F3'),
('AOLDEMO', 'D04BBDD5E643C436'),
('AP', 'EED09A552944B6AD'),
('APA1', 'D00197BF551B2A79'),
('APA2', '121C6F5BD4674A33'),
('APA3', '5F843C0692560518'),
('APA4', 'BF21227532D2794A'),
('APPLEAD', '5331DB9C240E093B'),
('APPLSYS', '0F886772980B8C79'),
('APPLSYS', 'E153FFF4DAE6C9F7'),
('APPLSYSPUB', 'D2E3EF40EE87221E'),
('APPS', 'D728438E8A5925E0'),
('APS1', 'F65751C55EA079E6'),
('APS2', '5CACE7B928382C8B'),
('APS3', 'C786695324D7FB3B'),
('APS4', 'F86074C4F4F82D2C'),
('AQDEMO', '5140E342712061DD'),
('AQJAVA', '8765D2543274B42E'),
('AQUSER', '4CF13BDAC1D7511C'),
('AR', 'BBBFE175688DED7E'),
('ARA1', '4B9F4E0667857EB8'),
('ARA2', 'F4E52BFBED4652CD'),
('ARA3', 'E3D8D73AE399F7FE'),
('ARA4', '758FD31D826E9143'),
('ARS1', '433263ED08C7A4FD'),
('ARS2', 'F3AF9F26D0213538'),
('ARS3', 'F6755F08CC1E7831'),
('ARS4', '452B5A381CABB241
'),
('ART', '665168849666C4F3'),
('ASF', 'B6FD427D08619EEE'),
('ASG', '1EF8D8BD87CF16BE'),
('ASL', '03B20D2C323D0BFE'),
('ASN', '1EE6AEBD9A23D4E0'),
('ASO', 'F712D80109E3C9D8'),
('ASP', 'CF95D2C6C85FF513'),
('AST', 'F13FF949563EAB3C'),
('AUC_GUEST', '8A59D349DAEC26F7'),
('AURORA$ORB$UNAUTHENTICATED', '80C099F0EADF877E'),
('AUTHORIA', 'CC78120E79B57093'),
('AX', '0A8303530E86FCDD'),
('AZ', 'AAA18B5D51B0D5AC'),
('B2B', 'CC387B24E013C616'),
('BAM', '031091A1D1A30061'),
('BCA1', '398A69209360BD9D'),
('BCA2', '801D9C90EBC89371'),
('BEN', '9671866348E03616'),
('BIC', 'E84CC95CBBAC1B67'),
('BIL', 'BF24BCE2409BE1F7'),
('BIM', '6026F9A8A54B9468'),
('BIS', '7E9901882E5F3565'),
('BIV', '2564B34BE50C2524'),
('BIX', '3DD36935EAEDE2E3'),
('BLAKE', '9435F2E60569158E'),
('BMEADOWS', '2882BA3D3EE1F65A'),
('BNE', '080B5C7EE819BF78'),
('BOM', '56DB3E89EAE5788E'),
('BP01', '612D669D2833FACD'),
('BP02', 'FCE0C089A3ECECEE'),
('BP03', '0723FFEEFBA61545'),
('BP04', 'E5797698E0F8934E'),
('BP05', '58FFC821F778D7E9'),
('BP06', '2F358909A4AA6059'),
('BSC', 'EC481FD7DCE6366A'),
('BUYACCT', 'D6B388366ECF2F61'),
('BUYAPPR1', 'CB04931693309228'),
('BUYAPPR2', '3F98A3ADC037F49C'),
('BUYAPPR3', 'E65D8AD3ACC23DA3'),
('BUYER', '547BDA4286A2ECAE'),
('BUYMTCH', '0DA5E3B504CC7497'),
('CAMRON', '4384E3F9C9C9B
8F1'),
('CANDICE', 'CF458B3230215199'),
('CARL', '99ECCC664FFDFEA2'),
('CARLY', 'F7D90C099F9097F1'),
('CARMEN', '46E23E1FD86A4277'),
('CARRIECONYERS', '9BA83B1E43A5885B'),
('CATADMIN', 'AF9AB905347E004F'),
('CE', 'E7FDFE26A524FE39'),
('CEASAR', 'E69833B8205D5DD7'),
('CENTRA', '63BF5FFE5E3EA16D'),
('CFD', '667B018D4703C739'),
('CHANDRA', '184503FA7786C82D'),
('CHARLEY', 'E500DAA705382E8D'),
('CHRISBAKER', '52AFB6B3BE485F81'),
('CHRISTIE', 'C08B79CCEC43E798'),
('CINDY', '3AB2C717D1BD0887'),
('CLARK', '74DF527800B6D713'),
('CLARK', '7AAFE7D01511D73F'),
('CLAUDE', 'C6082BCBD0B69D20'),
('CLINT', '163FF8CCB7F11691'),
('CLN', 'A18899D42066BFCA'),
('CN', '73F284637A54777D'),
('CNCADMIN', 'C7C8933C678F7BF9'),
('CONNIE', '982F4C420DD38307'),
('CONNOR', '52875AEB74008D78'),
('CORY', '93CE4CCE632ADCD2'),
('CRM1', '6966EA64B0DFC44E'),
('CRM2', 'B041F3BEEDA87F72'),
('CRP', 'F165BDE5462AD557'),
('CRPB733', '2C9AB93FF2999125'),
('CRPCTL', '4C7A200FB33A531D'),
('CRPDTA', '6665270166D613BC'),
('CS', 'DB78866145D4E1C3'),
('CSADMIN', '94327195EF560924'),
('CSAPPR1', '47D841B5A01168FF'),
('CSC', 'EDECA9762A8C79CD'),
('CSD', '144441CEBAFC91CF'),
('CSDUMMY', '7A587C459B93ACE4'),
('CSE', 'D8CC61E8F42537DA'),
('CSF', '684E28B3C899D42C'),
('CSI', '71C2B12C28B79294'),
('CSL', 'C4D7FE062EFB85AB'),
(
'CSM', '94C24FC0BE22F77F'),
('CSMIG', '09B4BB013FBD0D65'),
('CSP', '5746C5E077719DB4'),
('CSR', '0E0F7C1B1FE3FA32'),
('CSS', '3C6B8C73DDC6B04F'),
('CTXDEMO', 'CB6B5E9D9672FE89'),
('CTXSYS', '24ABAB8B06281B4C'),
('CTXSYS', '71E687F036AD56E5'),
('CTXTEST', '064717C317B551B6'),
('CUA', 'CB7B2E6FFDD7976F'),
('CUE', 'A219FE4CA25023AA'),
('CUF', '82959A9BD2D51297'),
('CUG', '21FBCADAEAFCC489'),
('CUI', 'AD7862E01FA80912'),
('CUN', '41C2D31F3C85A79D'),
('CUP', 'C03082CD3B13EC42'),
('CUS', '00A12CC6EBF8EDB8'),
('CZ', '9B667E9C5A0D21A6'),
('DAVIDMORGAN', 'B717BAB262B7A070'),
('DBSNMP', 'E066D214D5421CCC'),
('DCM', '45CCF86E1058D3A5'),
('DD7333', '44886308CF32B5D4'),
('DD7334', 'D7511E19D9BD0F90'),
('DD810', '0F9473D8D8105590'),
('DD811', 'D8084AE609C9A2FD'),
('DD812', 'AB71915CF21E849E'),
('DD9', 'E81821D03070818C'),
('DDB733', '7D11619CEE99DE12'),
('DDD', '6CB03AF4F6DD133D'),
('DEMO8', '0E7260738FDFD678'),
('DES', 'ABFEC5AC2274E54D'),
('DES2K', '611E7A73EC4B425A'),
('DEV2000_DEMOS', '18A0C8BD6B13BEE2'),
('DEVB733', '7500DF89DC99C057'),
('DEVUSER', 'C10B4A80D00CA7A5'),
('DGRAY', '5B76A1EB8F212B85'),
('DIP', 'CE4A36B8E06CA59C'),
('DISCOVERER5', 'AF0EDB66D914B731'),
('DKING', '255C2B0E1F0912EA'),
('DLD', '4454B932A1E0E320'),
('DMADMIN', 'E6681A8926B40826'),
('DMATS', '8C692701A453128
6'),
('DMS', '1351DC7ED400BD59'),
('DMSYS', 'BFBA5A553FD9E28A'),
('DOM', '51C9F2BECA78AE0E'),
('DPOND', '79D6A52960EEC216'),
('DSGATEWAY', '6869F3CFD027983A'),
('DV7333', '36AFA5CD674BA841'),
('DV7334', '473B568021BDB428'),
('DV810', '52C38F48C99A0352'),
('DV811', 'B6DC5AAB55ECB66C'),
('DV812', '7359E6E060B945BA'),
('DV9', '07A1D03FD26E5820'),
('DVP1', '0559A0D3DE0759A6'),
('EAA', 'A410B2C5A0958CDF'),
('EAM', 'CE8234D92FCFB563'),
('EC', '6A066C462B62DD46'),
('ECX', '0A30645183812087'),
('EDR', '5FEC29516474BB3A'),
('EDWEUL_US', '5922BA2E72C49787'),
('EDWREP', '79372B4AB748501F'),
('EGC1', 'D78E0F2BE306450D'),
('EGD1', 'DA6D6F2089885BA6'),
('EGM1', 'FB949D5E4B5255C0'),
('EGO', 'B9D919E5F5A9DA71'),
('EGR1', 'BB636336ADC5824A'),
('END1', '688499930C210B75'),
('ENG', '4553A3B443FB3207'),
('ENI', '05A92C0958AFBCBC'),
('ENM1', '3BDABFD1246BFEA2'),
('ENS1', 'F68A5D0D6D2BB25B'),
('ENTMGR_CUST', '45812601EAA2B8BD'),
('ENTMGR_PRO', '20002682991470B3'),
('ENTMGR_TRAIN', 'BE40A3BE306DD857'),
('EOPP_PORTALADM', 'B60557FD8C45005A'),
('EOPP_PORTALMGR', '9BB3CF93F7DE25F1'),
('EOPP_USER', '13709991FC4800A1'),
('EUL_US', '28AEC22561414B29'),
('EVM', '137CEDC20DE69F71'),
('EXA1', '091BCD95EE112EE3'),
('EXA2', 'E4C0A21DBD06B890'),
('EXA3', '40DC4FA801A73560'),
('EXA4', '953885D52BDF5C86'),
(
'EXFSYS', '66F4EF5650C20355'),
('EXS1', 'C5572BAB195817F0'),
('EXS2', '8FAA3AC645793562'),
('EXS3', 'E3050174EE1844BA'),
('EXS4', 'E963BFE157475F7D'),
('FA', '21A837D0AED8F8E5'),
('FEM', 'BD63D79ADF5262E7'),
('FIA1', '2EB76E07D3E094EC'),
('FII', 'CF39DE29C08F71B9'),
('FLM', 'CEE2C4B59E7567A3'),
('FNI1', '308839029D04F80C'),
('FNI2', '05C69C8FEAB4F0B9'),
('FPA', '9FD6074B9FD3754C'),
('FPT', '73E3EC9C0D1FAECF'),
('FRM', '9A2A7E2EBE6E4F71'),
('FTA1', '65FF9AB3A49E8A13'),
('FTE', '2FB4D2C9BAE2CCCA'),
('FUN', '8A7055CA462DB219'),
('FV', '907D70C0891A85B1'),
('FVP1', '6CC7825EADF994E8'),
('GALLEN', 'F8E8ED9F15842428'),
('GCA1', '47DA9864E018539B'),
('GCA2', 'FD6E06F7DD50E868'),
('GCA3', '4A4B9C2E9624C410'),
('GCA9', '48A7205A4C52D6B5'),
('GCMGR1', '14A1C1A08EA915D6'),
('GCMGR2', 'F4F11339A4221A4D'),
('GCMGR3', '320F0D4258B9D190'),
('GCS', '7AE34CA7F597EBF7'),
('GCS1', '2AE8E84D2400E61D'),
('GCS2', 'C242D2B83162FF3D'),
('GCS3', 'DCCB4B49C68D77E2'),
('GEORGIAWINE', 'F05B1C50A1C926DE'),
('GL', 'CD6E99DACE4EA3A6'),
('GLA1', '86C88007729EB36F'),
('GLA2', '807622529F170C02'),
('GLA3', '863A20A4EFF7386B'),
('GLA4', 'DB882CF89A758377'),
('GLS1', '7485C6BD564E75D1'),
('GLS2', '319E08C55B04C672'),
('GLS3', 'A7699C43BB136229'),
('GLS4', '7C171E6980BE2DB9'),
('GM_AWDA', '4A06A107E7A3BB
10'),
('GM_COPI', '03929AE296BAAFF2'),
('GM_DPHD', '0519252EDF68FA86'),
('GM_MLCT', '24E8B569E8D1E93E'),
('GM_PLADMA', '2946218A27B554D8'),
('GM_PLADMH', '2F6EDE96313AF1B7'),
('GM_PLCCA', '7A99244B545A038D'),
('GM_PLCCH', '770D9045741499E6'),
('GM_PLCOMA', '91524D7DE2B789A8'),
('GM_PLCOMH', 'FC1C6E0864BF0AF2'),
('GM_PLCONA', '1F531397B19B1E05'),
('GM_PLCONH', 'C5FE216EB8FCD023'),
('GM_PLNSCA', 'DB9DD2361D011A30'),
('GM_PLNSCH', 'C80D557351110D51'),
('GM_PLSCTA', '3A778986229BA20C'),
('GM_PLSCTH', '9E50865473B63347'),
('GM_PLVET', '674885FDB93D34B9'),
('GM_SPO', 'E57D4BD77DAF92F0'),
('GM_STKH', 'C498A86BE2663899'),
('GMA', 'DC7948E807DFE242'),
('GMD', 'E269165256F22F01'),
('GME', 'B2F0E221F45A228F'),
('GMF', 'A07F1956E3E468E1'),
('GMI', '82542940B0CF9C16'),
('GML', '5F1869AD455BBA73'),
('GMP', '450793ACFCC7B58E'),
('GMS', 'E654261035504804'),
('GR', 'F5AB0AA3197AEE42'),
('GUEST', '1C0A090E404CECD0'),
('HCC', '25A25A7FEFAC17B6'),
('HHCFO', '62DF37933FB35E9F'),
('HR', '4C6D73C3E8B0F0DA'),
('HRI', '49A3A09B8FC291D0'),
('HXC', '4CEA0BF02214DA55'),
('HXT', '169018EB8E2C4A77'),
('IA', '42C7EAFBCEEC09CC'),
('IBA', '0BD475D5BF449C63'),
('IBC', '9FB08604A30A4951'),
('IBE', '9D41D2B3DD095227'),
('IBP', '840267B7BD30C82E'),
('IBU', '0AD9ABABC74B3057'),
('IBY', 'F483A48F6A8C51EC'),
('
ICX', '7766E887AF4DCC46'),
('IEB', 'A695699F0F71C300'),
('IEC', 'CA39F929AF0A2DEC'),
('IEM', '37EF7B2DD17279B5'),
('IEO', 'E93196E9196653F1'),
('IES', '30802533ADACFE14'),
('IEU', '5D0E790B9E882230'),
('IEX', '6CC978F56D21258D'),
('IGC', 'D33CEB8277F25346'),
('IGF', '1740079EFF46AB81'),
('IGI', '8C69D50E9D92B9D0'),
('IGS', 'DAF602231281B5AC'),
('IGW', 'B39565F4E3CF744B'),
('IMC', 'C7D0B9CDE0B42C73'),
('IMT', 'E4AAF998653C9A72'),
('INS1', '2ADC32A0B154F897'),
('INS2', 'EA372A684B790E2A'),
('INTERNET_APPSERVER_REGISTRY', 'A1F98A977FFD73CD'),
('INV', 'ACEAB015589CF4BC'),
('IP', 'D29012C144B58A40'),
('IPA', 'EB265A08759A15B4'),
('IPD', '066A2E3072C1F2F3'),
('ISC', '373F527DC0CFAE98'),
('ISTEWARD', '8735CA4085DE3EEA'),
('ITG', 'D90F98746B68E6CA'),
('JA', '9AC2B58153C23F3D'),
('JD7333', 'FB5B8A12AE623D52'),
('JD7334', '322810FCE43285D9'),
('JD9', '9BFAEC92526D027B'),
('JDE', '7566DC952E73E869'),
('JDEDBA', 'B239DD5313303B1D'),
('JE', 'FBB3209FD6280E69'),
('JG', '37A99698752A1CF1'),
('JL', '489B61E488094A8D'),
('JOHNINARI', 'B3AD4DA00F9120CE'),
('JONES', 'B9E99443032F059D'),
('JTF', '5C5F6FC2EBB94124'),
('JTI', 'B8F03D3E72C96F71'),
('JTM', '6D79A2259D5B4B5A'),
('JTR', 'B4E2BE38B556048F'),
('JTS', '4087EE6EB7F9CD7C'),
('JUNK_PS', 'BBC38DB05D2D3A7A'),
('JUSTOSHUM', '53369CD639
02FAAA'),
('KELLYJONES', 'DD4A3FF809D2A6CF'),
('KEVINDONS', '7C6D9540B45BBC39'),
('KPN', 'DF0AED05DE318728'),
('LADAMS', 'AE542B99505CDCD2'),
('LBA', '18E5E15A436E7157'),
('LBACSYS', 'AC9700FD3F1410EB'),
('LDQUAL', '1274872AB40D4FCD'),
('LHILL', 'E70CA2CA0ED555F5'),
('LNS', 'F8D2BC61C10941B2'),
('LQUINCY', '13F9B9C1372A41B6'),
('LSA', '2D5E6036E3127B7E'),
('MDDATA', 'DF02A496267DEE66'),
('MDSYS', '72979A94BAD2AF80'),
('MDSYS', '9AAEB2214DCC9A31'),
('ME', 'E5436F7169B29E4D'),
('MFG', 'FC1B0DD35E790847'),
('MGR1', 'E013305AB0185A97'),
('MGR2', '5ADE358F8ACE73E8'),
('MGR3', '05C365C883F1251A'),
('MGR4', 'E229E942E8542565'),
('MIKEIKEGAMI', 'AAF7A168C83D5C47'),
('MJONES', 'EE7BB3FEA50A21C5'),
('MLAKE', '7EC40274AC1609CA'),
('MM1', '4418294570E152E7'),
('MM2', 'C06B5B28222E1E62'),
('MM3', 'A975B1BD0C093DA3'),
('MM4', '88256901EB03A012'),
('MM5', '4CEA62CBE776DCEC'),
('MMARTIN', 'D52F60115FE87AA4'),
('MOBILEADMIN', '253922686A4A45CC'),
('MRP', 'B45D4DF02D4E0C85'),
('MSC', '89A8C104725367B2'),
('MSD', '6A29482069E23675'),
('MSO', '3BAA3289DB35813C'),
('MSR', 'C9D53D00FE77D813'),
('MST', 'A96D2408F62BE1BC'),
('MWA', '1E2F06BE2A1D41A6'),
('NEILKATSU', '1F625BB9FEBC7617'),
('OBJ7333', 'D7BDC9748AFEDB52'),
('OBJ7334', 'EB6C5E9DB4643CAC'),
('OBJB733', '61737A9F7D54EF5F'),
('OCA', '
9BC450E4C6569492'),
('ODM', 'C252E8FA117AF049'),
('ODM_MTR', 'A7A32CD03D3CE8D5'),
('ODS', '89804494ADFC71BC'),
('ODSCOMMON', '59BBED977430C1A8'),
('OE', 'D1A2DFC623FDA40A'),
('OKB', 'A01A5F0698FC9E31'),
('OKC', '31C1DDF4D5D63FE6'),
('OKE', 'B7C1BB95646C16FE'),
('OKI', '991C817E5FD0F35A'),
('OKL', 'DE058868E3D2B966'),
('OKO', '6E204632EC7CA65D'),
('OKR', 'BB0E28666845FCDC'),
('OKS', 'C2B4C76AB8257DF5'),
('OKX', 'F9FDEB0DE52F5D6B'),
('OL810', 'E2DA59561CBD0296'),
('OL811', 'B3E88767A01403F8'),
('OL812', 'AE8C7989346785BA'),
('OL9', '17EC83E44FB7DB5B'),
('OLAPSYS', '3FB8EF9DB538647C'),
('ONT', '9E3C81574654100A'),
('OPI', '1BF23812A0AEEDA0'),
('ORABAM', 'D0A4EA93EF21CE25'),
('ORABAMSAMPLES', '507F11063496F222'),
('ORABPEL', '26EFDE0C9C051988'),
('ORAESB', 'CC7FCCB3A1719EDA'),
('ORAOCA_PUBLIC', 'FA99021634DDC111'),
('ORASAGENT', '234B6F4505AD8F25'),
('ORASSO', 'F3701A008AA578CF'),
('ORASSO_DS', '17DC8E02BC75C141'),
('ORASSO_PA', '133F8D161296CB8F'),
('ORASSO_PS', '63BB534256053305'),
('ORASSO_PUBLIC', 'C6EED68A8F75F5D3'),
('ORDPLUGINS', '88A2B2C183431F00'),
('ORDSYS', '7EFA02EC7EA6B86F'),
('OSM', '106AE118841A5D8C'),
('OTA', 'F5E498AC7009A217'),
('OUTLN', '4A3BA55E08595C81'),
('OWAPUB', '6696361B64F9E0A9'),
('OWF_MGR', '3CBED37697EB01D1'),
('OZF', '970B962D942D0C75'),
('OZP', 'B
650B1BB35E86863'),
('OZS', '0DABFF67E0D33623'),
('PA', '8CE2703752DB36D8'),
('PABLO', '5E309CB43FE2C2FF'),
('PAIGE', '02B6B704DFDCE620'),
('PAM', '1383324A0068757C'),
('PARRISH', '79193FDACFCE46F6'),
('PARSON', 'AE28B2BD64720CD7'),
('PAT', 'DD20769D59F4F7BF'),
('PATORILY', '46B7664BD15859F9'),
('PATRICKSANCHEZ', '47F74BD3AD4B5F0A'),
('PATSY', '4A63F91FEC7980B7'),
('PAUL', '35EC0362643ADD3F'),
('PAULA', 'BB0DC58A94C17805'),
('PAXTON', '4EB5D8FAD3434CCC'),
('PCA1', '8B2E303DEEEEA0C0'),
('PCA2', '7AD6CE22462A5781'),
('PCA3', 'B8194D12FD4F537D'),
('PCA4', '83AD05F1D0B0C603'),
('PCS1', '2BE6DD3D1DEA4A16'),
('PCS2', '78117145145592B1'),
('PCS3', 'F48449F028A065B1'),
('PCS4', 'E1385509C0B16BED'),
('PD7333', '5FFAD8604D9DC00F'),
('PD7334', 'CDCF262B5EE254E1'),
('PD810', 'EB04A177A74C6BCB'),
('PD811', '3B3C0EFA4F20AC37'),
('PD812', 'E73A81DB32776026'),
('PD9', 'CACEB3F9EA16B9B7'),
('PDA1', 'C7703B70B573D20F'),
('PEARL', 'E0AFD95B9EBD0261'),
('PEG', '20577ED9A8DB8D22'),
('PENNY', 'BB6103E073D7B811'),
('PEOPLE', '613459773123B38A'),
('PERCY', 'EB9E8B33A2DDFD11'),
('PERRY', 'D62B14B93EE176B6'),
('PETE', '4040619819A9C76E'),
('PEYTON', 'B7127140004677FC'),
('PHIL', '181446AE258EE2F6'),
('PJI', '5024B1B412CD4AB9'),
('PJM', '021B05DBB892D11F'),
('PMI', 'A7F7978B21A6F65E'),
('PN', 'D40
D0FEF9C8DC624'),
('PO', '355CBEC355C10FEF'),
('POA', '2AB40F104D8517A0'),
('POLLY', 'ABC770C112D23DBE'),
('POM', '123CF56E05D4EF3C'),
('PON', '582090FD3CC44DA3'),
('PORTAL', 'A96255A27EC33614'),
('PORTAL_APP', '831A79AFB0BD29EC'),
('PORTAL_DEMO', 'A0A3A6A577A931A3'),
('PORTAL_PUBLIC', '70A9169655669CE8'),
('PORTAL30', '969F9C3839672C6D'),
('PORTAL30_DEMO', 'CFD1302A7F832068'),
('PORTAL30_PUBLIC', '42068201613CA6E2'),
('PORTAL30_SSO', '882B80B587FCDBC8'),
('PORTAL30_SSO_PS', 'F2C3DC8003BC90F8'),
('PORTAL30_SSO_PUBLIC', '98741BDA2AC7FFB2'),
('POS', '6F6675F272217CF7'),
('PPM1', 'AA4AE24987D0E84B'),
('PPM2', '4023F995FF78077C'),
('PPM3', '12F56FADDA87BBF9'),
('PPM4', '84E17CB7A3B0E769'),
('PPM5', '804C159C660F902C'),
('PRISTB733', '1D1BCF8E03151EF5'),
('PRISTCTL', '78562A983A2F78FB'),
('PRISTDTA', '3FCBC379C8FE079C'),
('PRODB733', '9CCD49EB30CB80C4'),
('PRODCTL', 'E5DE2F01529AE93C'),
('PRODDTA', '2A97CD2281B256BA'),
('PRODUSER', '752E503EFBF2C2CA'),
('PROJMFG', '34D61E5C9BC7147E'),
('PRP', 'C1C4328F8862BC16'),
('PS', '0AE52ADF439D30BD'),
('PS810', '90C0BEC7CA10777E'),
('PS810CTL', 'D32CCE5BDCD8B9F9'),
('PS810DTA', 'AC0B7353A58FC778'),
('PS811', 'B5A174184403822F'),
('PS811CTL', '18EDE0C5CCAE4C5A'),
('PS811DTA', '7961547C7FB96920'),
('PS812', '39F0304F007D92C8'),
('PS812CTL', 'E39B1CE3456
ECBE5'),
('PS812DTA', '3780281C933FE164'),
('PSA', 'FF4B266F9E61F911'),
('PSB', '28EE1E024FC55E66'),
('PSBASS', 'F739804B718D4406'),
('PSEM', '40ACD8C0F1466A57'),
('PSFT', '7B07F6F3EC08E30D'),
('PSFTDBA', 'E1ECD83073C4E134'),
('PSP', '4FE07360D435E2F0'),
('PTADMIN', '4C35813E45705EBA'),
('PTCNE', '463AEFECBA55BEE8'),
('PTDMO', '251D71390034576A'),
('PTE', '380FDDB696F0F266'),
('PTESP', '5553404C13601916'),
('PTFRA', 'A360DAD317F583E3'),
('PTG', '7AB0D62E485C9A3D'),
('PTGER', 'C8D1296B4DF96518'),
('PTJPN', '2159C2EAF20011BF'),
('PTUKE', 'D0EF510BCB2992A3'),
('PTUPG', '2C27080C7CC57D06'),
('PTWEB', '8F7F509D4DC01DF6'),
('PTWEBSERVER', '3C8050536003278B'),
('PV', '76224BCC80895D3D'),
('PY7333', '2A9C53FE066B852F'),
('PY7334', 'F3BBFAE0DDC5F7AC'),
('PY810', '95082D35E94B88C2'),
('PY811', 'DC548D6438E4D6B7'),
('PY812', '99C575A55E9FDA63'),
('PY9', 'B8D4E503D0C4FCFD'),
('QA', 'C7AEAA2D59EB1EAE'),
('QOT', 'B27D0E5BA4DC8DEA'),
('QP', '10A40A72991DCA15'),
('QRM', '098286E4200B22DE'),
('QS', '4603BCD2744BDE4F'),
('QS_ADM', '3990FB418162F2A0'),
('QS_CB', '870C36D8E6CD7CF5'),
('QS_CBADM', '20E788F9D4F1D92C'),
('QS_CS', '2CA6D0FC25128CF3'),
('QS_ES', '9A5F2D9F5D1A9EF4'),
('QS_OS', '0EF5997DC2638A61'),
('QS_WS', '0447F2F756B4F460'),
('RENE', '9AAD141AB0954CF0'),
('REPADMIN', '915C93F
34954F5F8'),
('REPORTS', '0D9D14FE6653CF69'),
('REPORTS_USER', '635074B4416CD3AC'),
('RESTRICTED_US', 'E7E67B60CFAFBB2D'),
('RG', '0FAA06DA0F42F21F'),
('RHX', 'FFDF6A0C8C96E676'),
('RLA', 'C1959B03F36C9BB2'),
('RLM', '4B16ACDA351B557D'),
('RM1', 'CD43500DAB99F447'),
('RM2', '2D8EE7F8857D477E'),
('RM3', '1A95960A95AC2E1D'),
('RM4', '651BFD4E1DE4B040'),
('RM5', 'FDCC34D74A22517C'),
('RMAN', 'E7B5D92911C831E1'),
('ROB', '94405F516486CA24'),
('RPARKER', 'CEBFE4C41BBCC306'),
('RWA1', 'B07E53895E37DBBB'),
('SALLYH', '21457C94616F5716'),
('SAM', '4B95138CB6A4DB94'),
('SARAHMANDY', '60BE21D8711EE7D9'),
('SCM1', '507306749131B393'),
('SCM2', 'CBE8D6FAC7821E85'),
('SCM3', '2B311B9CDC70F056'),
('SCM4', '1FDF372790D5A016'),
('SCOTT', 'F894844C34402B67'),
('SDAVIS', 'A9A3B88C6A550559'),
('SECDEMO', '009BBE8142502E10'),
('SEDWARDS', '00A2EDFD7835BC43'),
('SELLCM', '8318F67F72276445'),
('SELLER', 'B7F439E172D5C3D0'),
('SELLTREAS', '6EE7BA85E9F84560'),
('SERVICES', 'B2BE254B514118A5'),
('SETUP', '9EA55682C163B9A3'),
('SH', '54B253CBBAAA8C48'),
('SI_INFORMTN_SCHEMA', '84B8CBCA4D477FA3'),
('SID', 'CFA11E6EBA79D33E'),
('SKAYE', 'ED671B63BDDB6B50'),
('SKYTETSUKA', 'EB5DA777D1F756EC'),
('SLSAA', '99064FC6A2E4BBE8'),
('SLSMGR', '0ED44093917BE294'),
('SLSREP', '847B6AAB9471B0A5'),
('SRABBITT', '85
F734E71E391DF5'),
('SRALPHS', '975601AA57CBD61A'),
('SRAY', 'C233B26CFC5DC643'),
('SRIVERS', '95FE94ADC2B39E08'),
('SSA1', 'DEE6E1BEB962AA8B'),
('SSA2', '96CA278B20579E34'),
('SSA3', 'C3E8C3B002690CD4'),
('SSC1', '4F7AC652CC728980'),
('SSC2', 'A1350B328E74AE87'),
('SSC3', 'EE3906EC2DA586D8'),
('SSOSDK', '7C48B6FF3D54D006'),
('SSP', '87470D6CE203FB4D'),
('SSS1', 'E78C515C31E83848'),
('SUPPLIER', '2B45928C2FE77279'),
('SVM7333', '04B731B0EE953972'),
('SVM7334', '62E2A2E886945CC8'),
('SVM810', '0A3DCD8CA3B6ABD9'),
('SVM811', '2B0CD57B1091C936'),
('SVM812', '778632974E3947C9'),
('SVM9', '552A60D8F84441F1'),
('SVMB733', 'DD2BFB14346146FE'),
('SVP1', 'F7BF1FFECE27A834'),
('SY810', 'D56934CED7019318'),
('SY811', '2FDC83B401477628'),
('SY812', '812B8D7211E7DEF1'),
('SY9', '3991E64C4BC2EC5D'),
('SYS', '43CA255A7916ECFE'),
('SYS', '5638228DAF52805F'),
('SYS', 'D4C5016086B2DC6A'),
('SYS7333', 'D7CDB3124F91351E'),
('SYS7334', '06959F7C9850F1E3'),
('SYSADMIN', 'DC86E8DEAA619C1A'),
('SYSB733', '7A7F5C90BEC02F0E'),
('SYSMAN', 'EB258E708132DD2D'),
('SYSTEM', '4D27CA6E3E3066E6'),
('SYSTEM', 'D4DF7931AB130E37'),
('TDEMARCO', 'CAB71A14FA426FAE'),
('TDOS_ICSAP', '7C0900F751723768'),
('TESTCTL', '205FA8DF03A1B0A6'),
('TESTDTA', 'EEAF97B5F20A3FA3'),
('TRA1', 'BE8EDAE6464BA413'),
('TRACESVR', 'F9D
A8977092B7B81'),
('TRBM1', 'B10ED16CD76DBB60'),
('TRCM1', '530E1F53715105D0'),
('TRDM1', 'FB1B8EF14CF3DEE7'),
('TRRM1', '4F29D85290E62EBE'),
('TWILLIAMS', '6BF819CE663B8499'),
('UDDISYS', 'BF5E56915C3E1C64'),
('VEA', 'D38D161C22345902'),
('VEH', '72A90A786AAE2914'),
('VIDEO31', '2FA72981199F9B97'),
('VIDEO4', '9E9B1524C454EEDE'),
('VIDEO5', '748481CFF7BE98BB'),
('VP1', '3CE03CD65316DBC7'),
('VP2', 'FCCEFD28824DFEC5'),
('VP3', 'DEA4D8290AA247B2'),
('VP4', 'F4730B0FA4F701DC'),
('VP5', '7DD67A696734AE29'),
('VP6', '45660DEE49534ADB'),
('WAA1', 'CF013DC80A9CBEE3'),
('WAA2', '6160E7A17091741A'),
('WCRSYS', '090263F40B744BD8'),
('WEBDB', 'D4C4DCDD41B05A5D'),
('WEBSYS', '54BA0A1CB5994D64'),
('WENDYCHO', '7E628CDDF051633A'),
('WH', '91792EFFCB2464F9'),
('WIP', 'D326D25AE0A0355C'),
('WIRELESS', '1495D279640E6C3A'),
('WIRELESS', 'EB9615631433603E'),
('WK_TEST', '29802572EB547DBF'),
('WKPROXY', 'AA3CB2A4D9188DDB'),
('WKSYS', '545E13456B7DDEA0'),
('WMS', 'D7837F182995E381'),
('WMSYS', '7C9BA362F8314299'),
('WPS', '50D22B9D18547CF7'),
('WSH', 'D4D76D217B02BD7A'),
('WSM', '750F2B109F49CC13'),
('XDB', '88D8364765FCE6AF'),
('XDO', 'E9DDE8ACFA7FE8E4'),
('XDP', 'F05E53C662835FA2'),
('XLA', '2A8ED59E27D86D41'),
('XLE', 'CEEBE966CC6A3E39'),
('XNB', '03935918FA35C993'),
('XNC', 'BD8EA41168F
6C664'),
('XNI', 'F55561567EF71890'),
('XNM', '92776EA17B8B5555'),
('XNP', '3D1FB783F96D1F5E'),
('XNS', 'FABA49C38150455E'),
('XTR', 'A43EE9629FA90CAE'),
('YCAMPOS', 'C3BBC657F099A10F'),
('YSANCHEZ', 'E0C033C4C8CC9D84'),
('ZFA', '742E092A27DDFB77'),
('ZPB', 'CAF58375B6D06513'),
('ZSA', 'AFD3BD3C7987CBB6'),
('ZX', '7B06550956254585'))
AND astatus NOT IN (9, 8)
AND type# = 1
AND rownum <= decode(:1, '-1', 2147483647, :1)
ORDER BY name |
| 4m7g0041v4jtj | select SURF_WEA_GLB_MUL_HOR_O_seq.nextval from dual |
| 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 |
| 4m9bapf9sj3sf |
SELECT mgmt_metric_value_obj.new(target_guid, null, null,
mgmt_namevalue_array(mgmt_namevalue_obj.new('privTransferRate', privTransferRate))) from ( SELECT ta.source_target_guid target_guid, SUM(c.value) privTransferRate
FROM mgmt_current_metrics c, mgmt_current_availability a,
mgmt_targets t2,
mgmt_target_assocs ta, mgmt_target_assoc_defs td,
mgmt_ha_cls_intr_conn i, mgmt_ecm_gen_snapshot s
WHERE c.metric_guid = HEXTORAW('F77CC469F1DBA385991ACF69FEB4E329')
AND c.target_guid = t2.target_guid
AND a.target_guid = t2.target_guid
AND a.current_status > 0
AND t2.target_guid = ta.assoc_target_guid
AND ta.assoc_guid = td.assoc_guid
AND td.assoc_def_name = 'contains'
AND td.scope_target_type = ' '
AND (i.ic_node = 'global' or i.ic_node = t2.target_name)
AND i.ic_public = 'NO'
AND i.ecm_snapshot_id = s.snapshot_guid
AND s.snapshot_type = 'ha_cls_intrconn'
AND s.is_current = 'Y'
AND s.target_guid = ta.source_target_guid
AND i.ic_name
= c.key_value
AND t2.target_type = 'host'
GROUP BY ta.source_target_guid ) WHERE target_guid IN (SELECT target_guid
FROM MGMT_COLLECTION_METRIC_TASKS
WHERE TASK_ID = :task_id) order by target_guid |
| 51bbkcd9zwsjw |
/* OracleOEM */
with max1 as (select :1 as select_tab, :2 as select_priv from dual)
select 'select_any_table',
substr(SYS_CONNECT_BY_PATH(c, '->'), 3, 512) path, c
from
(
select
null p,
name c
from
system_privilege_map
where
name = 'SELECT ANY TABLE'
union
select
granted_role p,
grantee c
from
dba_role_privs
union
select
privilege p, grantee c
from
dba_sys_privs
) where ((c = 'PUBLIC') or (exists (select 'w' from dba_users where username=c))) and rownum <= decode((select select_tab from max1), '-1', 2147483647, (select select_tab from max1))
start with p is null
connect by p = prior c
union
select 'select_privilege',
substr(SYS_CONNECT_BY_PATH(c, '->'), 3, 512) path, c
from
(
select
null p,
view_name c
from
dba_views
where
view_name like 'DBA_%'
union
select
granted_role p,
grantee c
from
dba_role_privs
union
select
table_name p, grantee c
from
dba_tab_privs where privilege = 'SELECT'
) where ((c = 'PUBLIC') or (exists (select 'w' from dba_users where username=c))) and rownum <= decode((select select_priv from max1), '-1', 2147483647, (select select_priv from max1))
start with p is null
connect by p = prior c
|
| 55dn7dk4cmcwk | select Q10004, Q10051, Q10061, Q10062, Q10301, Q10301_052, Q10302, Q10302_052, Q12001, Q12011, Q12011_052, Q12012, Q12012_052, Q12405, Q12016, Q12017, Q12003, Q13003, Q13007, Q13007_052, Q13004, Q13019, Q13020, Q13021, Q13022, Q13023, Q04080_04, Q13011, Q13033, Q11290, Q11291, Q11292, Q11293, Q11296, Q11042, Q11042_052, Q11201, Q11202, Q11211, Q11046, Q11046_052, Q11503_06, Q11504_06, Q11503_12, Q11504_12, Q12120, Q12311, Q12311_052, Q12121, Q12121_052, Q12013, Q12030_005, Q12030_010, Q12030_015, Q12030_020, Q12030_040, Q12030_080, Q12030_160, Q12030_320, Q12314, Q12315, Q12315_052, Q12316, Q12316_052, Q20001_701_01, Q20001_701_10, Q20059, Q20059_052, Q20001, Q20010, Q20051, Q20011, Q20013, Q20350_01, Q20350_02, Q20350_03, Q20350_04, Q20350_05, Q20350_06, Q20350_07, Q20350_08, Q20350_11, Q20350_12, Q20350_13, Q20003, Q04080_05, Q20004, Q20005, Q20062, Q13013, Q13330, Q20330_01, Q20331_01, Q20330_02, Q20331_02, D_RECORD_ID from SURF_WEA_CHN_MUL_HOR_TAB where V01301=:1 and V05001=:2 and V06001=:3 and V04001=:4 and V04002=:5 and V04003=:6 and V04004=:7 for update |
| 5ba4r4a9s15h1 | select SURF_WEA_C_MUL_MIN_OTH_seq.nextval from dual |
| 5fk0v8km2f811 | select propagation_name, 'BUFFERED', num_msgs ready, 0 from gv$buffered_subscribers b, dba_propagation p, dba_queues q, dba_queue_tables t where b.subscriber_name = p.propagation_name and b.subscriber_address = p.destination_dblink and b.queue_schema = p.source_queue_owner and b.queue_name = p.source_queue_name and p.source_queue_name = q.name and p.source_queue_owner = q.owner and q.queue_table = t.queue_table and b.inst_id=t.owner_instance |
| 5kww3jkrxgd2y |
/* OracleOEM */
with pwd as (select :1 as life_time, :2 as reuse_max, :3 as reuse_time, :4 as lock_time, :5 as grace_time, :6 as pwd_cmplx_fn from dual)
select 'password_life_time', limit, profile
from (
SELECT 'password_life_time', limit, profile
FROM dba_profiles
WHERE resource_name = 'PASSWORD_LIFE_TIME' AND limit <>'DEFAULT'
union
select 'password_life_time', def.limit, up.profile
FROM dba_profiles up, dba_profiles def
where up.resource_name = 'PASSWORD_LIFE_TIME' AND up.resource_name = def.resource_name
AND up.limit=def.profile AND up.limit='DEFAULT'
)
where rownum <= decode((select life_time from pwd), '-1', 2147483647, (select life_time from pwd))
union
select 'password_reuse_max', limit, profile
from (
SELECT 'password_reuse_max', limit, profile
FROM dba_profiles
WHERE resource_name = 'PASSWORD_REUSE_MAX' AND limit <>'DEFAULT'
union
select 'password_reuse_max', def.limit, up.profile
FROM dba_profiles up, dba_profiles def
where up.resource_name = 'PASSWORD_REUSE_MAX' AND up.resource_name = def.resource_name
AND up.limit=def.profile AND up.limit='DEFAULT'
)
where rownum <= decode((select reuse_max from pwd), '-1', 2147483647, (select reuse_max from pwd))
union
select 'password_reuse_time', limit, profile
from(
SELECT 'password_reuse_time', limit, profile
FROM dba_profiles
WHERE resource_name = 'PASSWORD_REUSE_TIME' AND limit <>'DEFAULT'
union
select 'password_reuse_time', def.limit, up.profile
FROM dba_profiles up, dba_profiles def
where up.resource_name = 'PASSWORD_REUSE_TIME' AND up.resource_name = def.resource_name
AND up.limit=def.profile AND up.limit='DEFAULT'
)
where rownum <= decode((select reuse_time from pwd), '-1', 2147483647, (select reuse_time from pwd))
union
select 'password_lock_time', limit, profile
from (
SELECT 'password_lock_time', limit, profile
FROM dba_profiles
WHERE resource_name = 'PASSWORD_LOCK_TIME' AND limit <>'DEFAULT'
union
select 'password_lock_time', def.limit, up.profile
FROM dba_profiles up, dba_profiles def
where up.resource_name = 'PASSWORD_LOCK_TIME' AND up.resource_name = def.resource_name
AND up.limit=def.profile AND up.limit='DEFAULT'
)
where rownum <= decode((select lock_time from pwd), '-1', 2147483647, (select lock_time from pwd))
union
SELECT 'password_grace_time', limit, profile
from(
SELECT 'password_grace_time', limit, profile
FROM dba_profiles
WHERE resource_name = 'PASSWORD_GRACE_TIME' AND limit <>'DEFAULT'
union
select 'password_grace_time', def.limit, up.profile
FROM dba_profiles up, dba_profiles def
where up.resource_name = '
PASSWORD_GRACE_TIME' AND up.resource_name = def.resource_name
AND up.limit=def.profile AND up.limit='DEFAULT'
)
where rownum <= decode((select grace_time from pwd), '-1', 2147483647, (select grace_time from pwd))
union
select 'password_complexity_fn', limit, profile
from(
SELECT 'password_complexity_fn', limit, profile
FROM sys.dba_profiles
WHERE resource_name = 'PASSWORD_VERIFY_FUNCTION'
AND limit <>'DEFAULT'
UNION
SELECT 'password_complexity_fn', def.limit, up.profile
FROM dba_profiles up, dba_profiles def
WHERE up.resource_name = 'PASSWORD_VERIFY_FUNCTION'
AND up.resource_name = def.resource_name
AND up.limit=def.profile AND up.limit='DEFAULT'
)
where rownum <= decode((select pwd_cmplx_fn from pwd), '-1', 2147483647, (select pwd_cmplx_fn from pwd))
|
| 5ms6rbzdnq16t | 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 |
| 5qudjs1nkny1r | select D_FILE_ID from SATE_ORB_RAW_F_TAB where V04001=:1 and V04002=:2 and V04003=:3 and V04004=:4 and V04005=:5 and V04006=:6 and V05301=:7 and V05310=:8 and V_FILE_FORMAT=:9 and D_DATA_ID=:10 |
| 5r8jah3jm5au2 | SELECT TARGETS.TARGET_NAME, TARGETS.TARGET_TYPE, TARGETS.TIMEZONE_REGION, TARGETS.EMD_URL, NVL(CAST(SYSTIMESTAMP AT TIME ZONE TARGETS.TIMEZONE_REGION AS DATE), :B2 ) FROM MGMT_TARGETS TARGETS WHERE TARGETS.TARGET_GUID = :B1 |
| 5rygsj4dbw6jt | insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7) |
| 61tn3mam0vq0b |
SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMB
ERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
|
| 7duj5j208p6ad | insert into RADA_CHN_DOR_L3_ST_PD_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , sysdate, to_date(:13 , 'yyyy-mm-dd HH24:MI:SS'), :14 , :15 , :16 , :17 , to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), :19 ) |
| 7gtztzv329wg0 | select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user# |
| 7msxd2qjtsw05 | SELECT /*+ INDEX(tasks mgmt_collection_tasks_pk) */ * FROM MGMT_COLLECTION_TASKS TASKS WHERE TASK_ID = :B1 FOR UPDATE |
| 7v922w0gt4jsc | select SURF_WEA_CHN_MUL_HOR_seq.nextval from dual |
| 7xz67tyjpuzf0 | select a.tablespace_name, trunc(a.totalspace / 1024 / 1024 / 1024, 2) totalspace, trunc(1-b.freespace/a.totalspace, 2) usepert from (select tablespace_name, sum(bytes) totalspace from dba_data_files ddf where tablespace_name not in ('SYSTEM', 'SYSAUX') group by tablespace_name) a, (select tablespace_name, sum(bytes) freespace from dba_free_space dfs where tablespace_name not in ('SYSTEM', 'SYSAUX') group by tablespace_name) b where a.tablespace_name = b.tablespace_name |
| 8j25anyg2szau | select D_FILE_ID from SATE_OTHERS_F_TAB where V01007_01=:1 and V02019_01=:2 and V04001=:3 and V04002=:4 and V04003=:5 and V04004=:6 and V04005=:7 and V04006=:8 and V_CCCC=:9 and V_FILE_FORMAT=:10 and V_LEVEL=:11 and D_DATA_ID=:12 |
| 8ynj1nfjyy4qu |
insert into SURF_WEA_CHN_MUL_HOR_I_TAB(I10004, I10051, I10061, I10062, I10301, I10301_052, I10302, I10302_052, I12001, I12011, I12011_052, I12012, I12012_052, I12405, I12016, I12017, I12003, I13003, I13007, I13007_052, I13004, I13019, I13020, I13021, I13022, I13023, I04080_04, I13011, I13033, I11290, I11291, I11292, I11293, I11296, I11042, I11042_052, I11201, I11202, I11211, I11046, I11046_052, I11503_06, I11504_06, I11503_12, I11504_12, I12120, I12311, I12311_052, I12121, I12121_052, I12013, I12030_005, I12030_010, I12030_015, I12030_020, I12030_040, I12030_080, I12030_160, I12030_320, I12314, I12315, I12315_052, I12316, I12316_052, I20001_701_01, I20001_701_10, I20059, I20059_052, I20001, I20010, I20051, I20011, I20013, I20350_01, I20350_02, I20350_03, I20350_04, I20350_05, I20350_06, I20350_07, I20350_08, I20350_11, I20350_12, I20350_13, I20003, I04080_05, I20004, I20005, I20062, I13013, I13330, I20330_01, I20331_01, I20330_02, I20331_02, D_DATETIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87
, :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , to_date(:96 , 'yyyy-mm-dd HH24:MI:SS'), :97 ) |
| 921wc95x40hk2 | select SURF_WEA_CHN_PRE_MIN_seq.nextval from dual |
| 94f6hjkrhq3j5 |
insert into SURF_WEA_GLB_MUL_HOR_O_TAB(V_BBB, V04001_02, V04002_02, V04003_02, V04004_02, V01301, V01300, V05001, V06001, V07001, V07031, V07032_01, V07032_02, V07032_03, V07032_04, V02002, V02004, V02001, V_NCODE, V01015, V04001, V04002, V04003, V04004, V04005, V20013, V20001, V20010, V11001, V11002, V12001, V12003, V13003, V10004, V10051, V07004, V10009, V10063, V10061, V13019, V13011_02, V13020, V13021, V13011_09, V13022, V13011_15, V13011_18, V13023, V20003, V20004, V20005, V20011, V20350_11, V20350_12, V20350_13, V10062, V12405, V12014, V12016, V12015, V12017, V12013, V20062, V13013, V13340, V14032_01, V14032_24, V14016_01, V14015, V14021_01, V14020, V14023_01, V14022, V14002_01, V14001, V14004_01, V14003, V14025_01, V14024, V20054_01, V20054_02, V20054_03, V20012, V05021, V07021, V20012_01, V20011_01, V20013_01, V20012_02, V20011_02, V20013_02, V20012_03, V20011_03, V20013_03, V20012_04, V20011_04, V20013_04, V20063_01, V20063_02, V20063_03, Q20013, Q20001, Q20010, Q11001, Q11002, Q12001, Q12003, Q13003, Q10004, Q10051, Q07004, Q10009, Q10063, Q10061, Q13019, Q13011_02, Q13020, Q13021, Q13011_09, Q13022, Q13011_15, Q13011_18, Q13023, Q20003, Q20004, Q20005, Q20011, Q20350_11, Q20350_12, Q20350_13, Q10062, Q12405, Q12014, Q12016, Q12015, Q12017, Q12013, Q20062, Q13013, Q13340, Q14032_01, Q14032_24, Q14016_01, Q14015, Q14021_01, Q14020, Q14023_01, Q14022, Q14002_01, Q14001, Q14004_01, Q14003, Q14025_01, Q14024, Q20054_01, Q20054_02, Q20054_03, Q20012, Q05021, Q07021, Q200
12_01, Q20011_01, Q20013_01, Q20012_02, Q20011_02, Q20013_02, Q20012_03, Q20011_03, Q20013_03, Q20012_04, Q20011_04, Q20013_04, Q20063_01, Q20063_02, Q20063_03, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , sysdate, to_date(:177 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:178 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :179 )
|
| 9mwkmwryanwkn |
/* 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 propagation_name streams_name, 'propagation' streams_type, last_lcr_latency latency , total_msgs total_messages
from gv$propagation_sender where propagation_name is not null
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 * FROM (
SELECT distinct 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 (PA
RTITION 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' )
WHERE rownum = 1) 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
|
| 9tcvnq0hdspsa | select RADA_CHN_DOR_L3_ST_PD_F_seq.nextval from dual |
| 9tgj4g8y4rwy8 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
| 9vt6njn4h1wf1 | SELECT TRIM(B.METRIC_NAME) FROM MGMT_TARGETS A, MGMT_METRICS B WHERE B.METRIC_GUID = :B2 AND A.TARGET_TYPE = B.TARGET_TYPE AND A.TYPE_META_VER = B.TYPE_META_VER AND (B.CATEGORY_PROP_1 = A.CATEGORY_PROP_1 OR B.CATEGORY_PROP_1 = ' ') AND (B.CATEGORY_PROP_2 = A.CATEGORY_PROP_2 OR B.CATEGORY_PROP_2 = ' ') AND (B.CATEGORY_PROP_3 = A.CATEGORY_PROP_3 OR B.CATEGORY_PROP_3 = ' ') AND (B.CATEGORY_PROP_4 = A.CATEGORY_PROP_4 OR B.CATEGORY_PROP_4 = ' ') AND (B.CATEGORY_PROP_5 = A.CATEGORY_PROP_5 OR B.CATEGORY_PROP_5 = ' ') AND A.TARGET_GUID=:B1 |
| a5vw0yk0gpkjp | select RADA_CHN_DOR_L3_PUP_F_seq.nextval from dual |
| a90mvyvbmpys6 |
insert into SURF_WEA_GLB_MUL_HOR_TAB(V04001_02, V04002_02, V04003_02, V04004_02, V01301, V01300, V05001, V06001, V07001, V07031, V07032_01, V07032_02, V07032_03, V07032_04, V02002, V02004, V02001, V_NCODE, V01015, V04001, V04002, V04003, V04004, V04005, V20013, V20001, V20010, V11001, V11002, V12001, V12003, V13003, V10004, V10051, V07004, V10009, V10063, V10061, V13019, V13011_02, V13020, V13021, V13011_09, V13022, V13011_15, V13011_18, V13023, V20003, V20004, V20005, V20011, V20350_11, V20350_12, V20350_13, V10062, V12405, V12014, V12016, V12015, V12017, V12013, V20062, V13013, V13340, V14032_01, V14032_24, V14016_01, V14015, V14021_01, V14020, V14023_01, V14022, V14002_01, V14001, V14004_01, V14003, V14025_01, V14024, V20054_01, V20054_02, V20054_03, V20012, V05021, V07021, V20012_01, V20011_01, V20013_01, V20012_02, V20011_02, V20013_02, V20012_03, V20011_03, V20013_03, V20012_04, V20011_04, V20013_04, V20063_01, V20063_02, V20063_03, Q20013, Q20001, Q20010, Q11001, Q11002, Q12001, Q12003, Q13003, Q10004, Q10051, Q07004, Q10009, Q10063, Q10061, Q13019, Q13011_02, Q13020, Q13021, Q13011_09, Q13022, Q13011_15, Q13011_18, Q13023, Q20003, Q20004, Q20005, Q20011, Q20350_11, Q20350_12, Q20350_13, Q10062, Q12405, Q12014, Q12016, Q12015, Q12017, Q12013, Q20062, Q13013, Q13340, Q14032_01, Q14032_24, Q14016_01, Q14015, Q14021_01, Q14020, Q14023_01, Q14022, Q14002_01, Q14001, Q14004_01, Q14003, Q14025_01, Q14024, Q20054_01, Q20054_02, Q20054_03, Q20012, Q05021, Q07021, Q20012_01, Q2
0011_01, Q20013_01, Q20012_02, Q20011_02, Q20013_02, Q20012_03, Q20011_03, Q20013_03, Q20012_04, Q20011_04, Q20013_04, Q20063_01, Q20063_02, Q20063_03, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , sysdate, to_date(:176 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:177 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :178 )
|
| ab3swhv5g138y |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY'
)) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob
j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj#
and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID |
| awfzp9zc8swfu | insert into RADA_CHN_DOR_L3_PUP_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V07021, V_COVERING_AREA, V_DPI, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , sysdate, to_date(:16 , 'yyyy-mm-dd HH24:MI:SS'), :17 , :18 , :19 , :20 , to_date(:21 , 'yyyy-mm-dd HH24:MI:SS'), :22 ) |
| axmdf8vq7k1rh | select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1 |
| b9yah4avy5n3c | insert into SURF_WEA_CHN_PRE_MIN_TAB(V_BBB, V01301, V01300, V05001, V06001, V07001, V02001, V02301, V_ACODE, V04001, V04002, V04003, V04004, V04005, V13011, Q13011, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , sysdate, to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :20 ) |
| bn4b3vjw2mj3u |
SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s
chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR
BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1 |
| bus15hb5g04y0 | select UPAR_ARD_GLB_MUL_MUT_AMD_seq.nextval from dual |
| bwpu9pfgcw4s9 |
insert into OCEN_SHB_GLB_MUL_TAB(V04001_02, V04002_02, V04003_02, V04004_02, V04005_02, V01301, V01300, V05001, V06001, V07031, V07032_01, V07033_01, V07032_04, V07310, V07033_04, V02169, V02039, V02038, V02030, V02001, V04001, V04002, V04003, V04004, V04005, V11001, V11002, V12001, V12003, V13003, V10004, V10051, V10063, V10061, V01012, V01013, V22049, V22320, V12002, V22059, V22321, V22005, V22032, V22322, V22001, V22011, V22021, V22002, V22012, V22022, V22003_01, V22013_01, V22023_01, V22003_02, V22013_02, V22023_02, V20033, V20031, V20032, V20034, V20037, V20035, V20038, V20036, V33302, V33301, V33027, V33291, V33300, V33290, V33292, V33022, V33023, V02149, V02034, V02442_01, V02442_02, V02442_03, V33323, V33310, V33311, V33313, V33316, V33317, V33318, V33312, V33322, I_INTG, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , sysdate, to_date(:90 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:91 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :92 )
|
| c03fnsf4g4nwt | SELECT D_STORAGE_SITE, D_FILE_SIZE FROM RADA_CHN_DOR_L3_ST_PD_F_TAB_P WHERE V_FILE_NAME ='RADA_CHN_DOR_L3_ST_PD_CAP.20130330-Z9731-SA.tar' AND D_DATA_ID = 'J.0004.0016.S002' |
| cn58bhkggqvj4 |
/* OracleOEM */
SELECT dtp.tablespace_name "TABLESPACE_NAME",
dtp.status "STATUS",
dtp.contents "CONTENTS",
dtp.extent_management "EXTENT MANAGEMENT",
dtp.allocation_type "ALLOCATION TYPE",
dtp.logging "LOGGING",
NVL(ts.bytes, 0) "SIZE (M)",
dtp.initial_extent "INITIAL EXT SIZE (K)",
dtp.next_extent "Next Extent",
dtp.pct_increase "INCREMENT PCT",
dtp.max_extents "MAX EXTENTS",
NVL(ts.bytes - NVL(f.bytes, 0), 0) "USED BYTES",
dtp.min_extents,
dtp.min_extlen,
dtp.segment_space_management "SEGMENT SPACE MANAGEMENT",
dtp.block_size,
dtp.bigfile
FROM sys.dba_tablespaces dtp,
(SELECT tablespace_name,
sum(bytes) bytes
FROM dba_data_files
GROUP BY tablespace_name) ts,
(SELECT tablespace_name, sum(bytes) bytes from dba_free_space GROUP BY tablespace_name) f
WHERE dtp.tablespace_name = ts.tablespace_name (+) AND
dtp.tablespace_name = f.tablespace_name (+) AND
NOT (dtp.extent_management LIKE 'LOCAL' AND
dtp.contents LIKE 'TEMPORARY')
UNION ALL
SELECT dtp.tablespace_name "TABLESPACE_NAME",
dtp.status "STATUS",
dtp.contents "CONTENTS",
dtp.extent_management "EXTENT MANAGEMENT",
dtp.allocation_type "ALLOCATION TYPE",
dtp.logging "LOGGING",
NVL(a.bytes, 0) "SIZE (M)",
dtp.initial_extent "INITIAL EXT SIZE (K)",
dtp.next_extent "Next Extent",
dtp.pct_increase "INCREMENT PCT",
dtp.max_extents "MAX EXTENTS",
NVL(t.bytes, 0) "USED BYTES",
dtp.min_extents,
dtp.min_extlen,
dtp.segment_space_management "SEGMENT SPACE MANAGEMENT",
dtp.block_size,
dtp.bigfile
FROM sys.dba_tablespaces dtp,
(SELECT tablespace_name,
sum(bytes) bytes
FROM dba_temp_files
GROUP BY tablespace_name) a,
(select ss.tablespace_name , sum((ss.used_blocks*ts.blocksize)) bytes
from gv$sort_segment ss, sys.ts$ ts where ss.tablespace_name = ts.name
group by ss.tablespace_name) t
WHERE dtp.tablespace_name = a.tablespace_name (+) AND
dtp.tablespace_name = t.tablespace_name (+) AND
dtp.extent_management LIKE 'LOCAL' AND
dtp.contents LIKE 'TEMPORARY'
|
| cvgsn62smwawg | SELECT D_STORAGE_SITE, D_FILE_SIZE FROM RADA_CHN_DOR_L3_ST_PD_F_TAB_P WHERE V_FILE_NAME ='RADA_CHN_DOR_L3_ST_PD_CAP.20130330-Z9535-SA.tar' AND D_DATA_ID = 'J.0004.0016.S002' |
| d93zvfq19vj9c | select SURF_WEA_CHN_REP_seq.nextval from dual |
| d972cwyzqpk6a | /* OracleOEM */
select 'insert_failure', obj.owner || '.' || obj.object_name , 'NA' from dba_objects obj, DBA_OBJ_AUDIT_OPTS aud
where aud.object_name=obj.object_name and
aud.owner = obj.owner and
obj.OBJECT_TYPE in ('VIEW', 'TABLE', 'MATERIALIZED VIEW') AND
AUD.INS not like '%/S' AND
ROWNUM <= :1
|
| davq1msn9b8kd | UPDATE MGMT_POLICY_ASSOC_EVAL_DETAILS SET CRIT_COUNTER = NVL(:B9 , CRIT_COUNTER), WARN_COUNTER = NVL(:B8 , WARN_COUNTER), INFO_COUNTER = NVL(:B7 , INFO_COUNTER), LAST_ERROR_MESSAGE = :B6 , LAST_EVALUATION_DATE = :B5 WHERE TARGET_GUID = :B4 AND POLICY_GUID = :B3 AND COLL_NAME = :B2 AND RESULT_KEY_VALUE = :B1 |
| dma0vxbwh325p | update smon_scn_time set time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4, scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where scn = (select min(scn) from smon_scn_time) |
| dqbhc9r7gz0a5 | SELECT DECODE(COUNT(CLIENT_INFO), 0, 'down', 'up') FROM GV$SESSION WHERE CLIENT_INFO = :B1 |
| faf45qdmw5k1j | insert into SURF_WEA_CHN_REP_TAB(V_BBB, V_CCCC, V_TT, V01301, V01300, V05001, V06001, V_NCODE, V_ACODE, V04001, V04002, V04003, V04004, V04005, V_LEN, V_REPORT, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , sysdate, to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :20 ) |
| fcb5u7n0r523m | SELECT NVL(AVG((VALUE*1000.0)/DURATION), 0), NVL((((SUM(DURATION)/(60*1000))/60)*100), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG A, MGMT_PERFORMANCE_NAMES B WHERE :B1 = B.DISPLAY_NAME AND A.JOB_NAME = B.JOB_NAME AND A.TIME > (SYSDATE-(1/24)) AND A.IS_TOTAL='Y' AND A.DURATION > 0 |
| fpxk90ad86u1q | insert into RADA_CHN_DOR_L3_ST_VW_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , sysdate, to_date(:13 , 'yyyy-mm-dd HH24:MI:SS'), :14 , :15 , :16 , :17 , to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), :19 ) |
| fq3ws1wmh1kpn | select Q20013, Q20001, Q20010, Q11001, Q11002, Q12001, Q12003, Q13003, Q10004, Q10051, Q07004, Q10009, Q10063, Q10061, Q13019, Q13011_02, Q13020, Q13021, Q13011_09, Q13022, Q13011_15, Q13011_18, Q13023, Q20003, Q20004, Q20005, Q20011, Q20350_11, Q20350_12, Q20350_13, Q10062, Q12405, Q12014, Q12016, Q12015, Q12017, Q12013, Q20062, Q13013, Q13340, Q14032_01, Q14032_24, Q14016_01, Q14015, Q14021_01, Q14020, Q14023_01, Q14022, Q14002_01, Q14001, Q14004_01, Q14003, Q14025_01, Q14024, Q20054_01, Q20054_02, Q20054_03, Q20012, Q05021, Q07021, Q20012_01, Q20011_01, Q20013_01, Q20012_02, Q20011_02, Q20013_02, Q20012_03, Q20011_03, Q20013_03, Q20012_04, Q20011_04, Q20013_04, Q20063_01, Q20063_02, Q20063_03, D_RECORD_ID from SURF_WEA_GLB_MUL_HOR_TAB where V01301=:1 and V05001=:2 and V06001=:3 and V04001=:4 and V04002=:5 and V04003=:6 and V04004=:7 and V04005=:8 for update |
| fsbqktj5vw6n9 |
select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca
st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1 |
| ftkm7d7htf0wf | SELECT D_STORAGE_SITE, D_FILE_SIZE FROM RADA_CHN_DOR_L3_ST_PD_F_TAB_P WHERE V_FILE_NAME ='RADA_CHN_DOR_L3_ST_PD_CAP.20130330-Z9898-SA.tar' AND D_DATA_ID = 'J.0004.0016.S002' |
| fwyn24jw5wjm4 |
/* OracleOEM */
SELECT /*+first_rows */
d.tablespace_name,
NVL(a.bytes / 1024 / 1024, 0) allocated_space,
DECODE(d.contents, 'UNDO', NVL(u.bytes, 0)/1024/1024, NVL(a.bytes - NVL(f.bytes, 0), 0)/1024/1024) used_space
FROM
sys.dba_tablespaces d,
(SELECT tablespace_name, SUM(bytes) bytes, COUNT(file_id) count
from dba_data_files GROUP BY tablespace_name) a,
(select tablespace_name, sum(bytes) bytes
from dba_free_space group by tablespace_name) f,
(SELECT tablespace_name, SUM(bytes) bytes
FROM (SELECT tablespace_name, sum (bytes) bytes, status from dba_undo_extents
WHERE status ='ACTIVE' group by tablespace_name, status
UNION ALL
SELECT tablespace_name, sum(bytes) bytes, status from dba_undo_extents
WHERE status ='UNEXPIRED' group by tablespace_name, status )
group by tablespace_name ) u
WHERE
d.tablespace_name = a.tablespace_name(+)
AND d.tablespace_name = f.tablespace_name(+)
AND d.tablespace_name = u.tablespace_name(+)
AND NOT (d.extent_management = 'LOCAL' AND d.contents = 'TEMPORARY')
UNION ALL
SELECT
d.tablespace_name,
NVL(a.bytes / 1024 / 1024, 0) allocated_space,
NVL(t.bytes, 0)/1024/1024 used_space
FROM
sys.dba_tablespaces d,
(select tablespace_name, sum(bytes) bytes, count(file_id) count
from dba_temp_files group by tablespace_name) a,
(select ss.tablespace_name , sum((ss.used_blocks*ts.bl
ocksize)) bytes
from gv$sort_segment ss, sys.ts$ ts where ss.tablespace_name = ts.name
group by ss.tablespace_name) t
WHERE
d.tablespace_name = a.tablespace_name(+)
AND d.tablespace_name = t.tablespace_name(+)
AND d.extent_management like 'LOCAL'
AND d.contents like 'TEMPORARY'
ORDER BY 1
|
| fxs3jmauhy220 | select SURF_WEA_C_MUL_MIN_MAIN_seq.nextval from dual |
| g2qckpurz2mqk | insert into RADA_CHN_DOR_L3_ST_VW_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V07021, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , sysdate, to_date(:14 , 'yyyy-mm-dd HH24:MI:SS'), :15 , :16 , :17 , :18 , to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), :20 ) |
| gb5bz699407pf |
update SURF_WEA_GLB_MUL_HOR_TAB set Q20013=:1 , V20013=:2 , Q20001=:3 , V20001=:4 , Q20010=:5 , V20010=:6 , Q11001=:7 , V11001=:8 , Q11002=:9 , V11002=:10 , Q12001=:11 , V12001=:12 , Q12003=:13 , V12003=:14 , Q13003=:15 , V13003=:16 , Q10004=:17 , V10004=:18 , Q10051=:19 , V10051=:20 , Q07004=:21 , V07004=:22 , Q10009=:23 , V10009=:24 , Q10063=:25 , V10063=:26 , Q10061=:27 , V10061=:28 , Q13019=:29 , V13019=:30 , Q13011_02=:31 , V13011_02=:32 , Q13020=:33 , V13020=:34 , Q13021=:35 , V13021=:36 , Q13011_09=:37 , V13011_09=:38 , Q13022=:39 , V13022=:40 , Q13011_15=:41 , V13011_15=:42 , Q13011_18=:43 , V13011_18=:44 , Q13023=:45 , V13023=:46 , Q20003=:47 , V20003=:48 , Q20004=:49 , V20004=:50 , Q20005=:51 , V20005=:52 , Q20011=:53 , V20011=:54 , Q20350_11=:55 , V20350_11=:56 , Q20350_12=:57 , V20350_12=:58 , Q20350_13=:59 , V20350_13=:60 , Q10062=:61 , V10062=:62 , Q12405=:63 , V12405=:64 , Q12014=:65 , V12014=:66 , Q12016=:67 , V12016=:68 , Q12015=:69 , V12015=:70 , Q12017=:71 , V12017=:72 , Q12013=:73 , V12013=:74 , Q20062=:75 , V20062=:76 , Q13013=:77 , V13013=:78 , Q13340=:79 , V13340=:80 , Q14032_01=:81 , V14032_01=:82 , Q14032_24=:83 , V14032_24=:84 , Q14016_01=:85 , V14016_01=:86 , Q14015=:87 , V14015=:88 , Q14021_01=:89 , V14021_01=:90 , Q14020=:91 , V14020=:92 , Q14023_01=:93 , V14023_01=:94 , Q14022=:95 , V14022=:96 , Q14002_01=:97 , V14002_01=:98 , Q14001=:99 , V14001=:100 , Q14004_01=:101 , V14004_01=:102 , Q14003=:103 , V14003=:104 , Q14025_01=:105 , V14025_01=:106
, Q14024=:107 , V14024=:108 , Q20054_01=:109 , V20054_01=:110 , Q20054_02=:111 , V20054_02=:112 , Q20054_03=:113 , V20054_03=:114 , Q20012=:115 , V20012=:116 , Q05021=:117 , V05021=:118 , Q07021=:119 , V07021=:120 , Q20012_01=:121 , V20012_01=:122 , Q20011_01=:123 , V20011_01=:124 , Q20013_01=:125 , V20013_01=:126 , Q20012_02=:127 , V20012_02=:128 , Q20011_02=:129 , V20011_02=:130 , Q20013_02=:131 , V20013_02=:132 , Q20012_03=:133 , V20012_03=:134 , Q20011_03=:135 , V20011_03=:136 , Q20013_03=:137 , V20013_03=:138 , Q20012_04=:139 , V20012_04=:140 , Q20011_04=:141 , V20011_04=:142 , Q20013_04=:143 , V20013_04=:144 , Q20063_01=:145 , V20063_01=:146 , Q20063_02=:147 , V20063_02=:148 , Q20063_03=:149 , V20063_03=:150 , D_UPDATE_TIME=sysdate where D_RECORD_ID=:151 |
| gdc07yrmhcwat | select SURF_WEA_CHN_MUL_HOR_O_seq.nextval from dual |
| gfxfu9fgsy7bj |
insert into SURF_WEA_CHN_MUL_HOR_O_TAB(V_BBB, V01301, V01300, V05001, V06001, V07001, V07031, V07032_04, V02001, V02301, V_ACODE, V04001, V04002, V04003, V04004, V10004, V10051, V10061, V10062, V10301, V10301_052, V10302, V10302_052, V12001, V12011, V12011_052, V12012, V12012_052, V12405, V12016, V12017, V12003, V13003, V13007, V13007_052, V13004, V13019, V13020, V13021, V13022, V13023, V04080_04, V13011, V13033, V11290, V11291, V11292, V11293, V11296, V11042, V11042_052, V11201, V11202, V11211, V11046, V11046_052, V11503_06, V11504_06, V11503_12, V11504_12, V12120, V12311, V12311_052, V12121, V12121_052, V12013, V12030_005, V12030_010, V12030_015, V12030_020, V12030_040, V12030_080, V12030_160, V12030_320, V12314, V12315, V12315_052, V12316, V12316_052, V20001_701_01, V20001_701_10, V20059, V20059_052, V20001, V20010, V20051, V20011, V20013, V20350_01, V20350_02, V20350_03, V20350_04, V20350_05, V20350_06, V20350_07, V20350_08, V20350_11, V20350_12, V20350_13, V20003, V04080_05, V20004, V20005, V20062, V13013, V13330, V20330_01, V20331_01, V20330_02, V20331_02, Q10004, Q10051, Q10061, Q10062, Q10301, Q10301_052, Q10302, Q10302_052, Q12001, Q12011, Q12011_052, Q12012, Q12012_052, Q12405, Q12016, Q12017, Q12003, Q13003, Q13007, Q13007_052, Q13004, Q13019, Q13020, Q13021, Q13022, Q13023, Q04080_04, Q13011, Q13033, Q11290, Q11291, Q11292, Q11293, Q11296, Q11042, Q11042_052, Q11201, Q11202, Q11211, Q11046, Q11046_052, Q11503_06, Q11504_06, Q11503_12, Q11504_12, Q12120, Q12311, Q1
2311_052, Q12121, Q12121_052, Q12013, Q12030_005, Q12030_010, Q12030_015, Q12030_020, Q12030_040, Q12030_080, Q12030_160, Q12030_320, Q12314, Q12315, Q12315_052, Q12316, Q12316_052, Q20001_701_01, Q20001_701_10, Q20059, Q20059_052, Q20001, Q20010, Q20051, Q20011, Q20013, Q20350_01, Q20350_02, Q20350_03, Q20350_04, Q20350_05, Q20350_06, Q20350_07, Q20350_08, Q20350_11, Q20350_12, Q20350_13, Q20003, Q04080_05, Q20004, Q20005, Q20062, Q13013, Q13330, Q20330_01, Q20331_01, Q20330_02, Q20331_02, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148
, :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , :177 , :178 , :179 , :180 , :181 , :182 , :183 , :184 , :185 , :186 , :187 , :188 , :189 , :190 , :191 , :192 , :193 , :194 , :195 , :196 , :197 , :198 , :199 , :200 , :201 , :202 , :203 , :204 , :205 , :206 , sysdate, to_date(:207 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:208 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :209 ) |