oracle insert 会锁表,行级锁引起insert操作超时 - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀...

CREATE TABLE "TMSTPOS"

( "MERC_ID" VARCHAR2(15),

"TRM_NO" VARCHAR2(8),

"TRM_SN" VARCHAR2(16) DEFAULT ' ',

"MFR_NO" VARCHAR2(3) DEFAULT ' ',

"MOD_NO" VARCHAR2(4) DEFAULT ' ',

"TRM_STS" VARCHAR2(1) DEFAULT 'Y',

"SGN_STS" VARCHAR2(1) DEFAULT '0',

"TRM_OWN" VARCHAR2(1) DEFAULT '0',

"TRM_TYP" VARCHAR2(1) DEFAULT '0',

"TRM_NM" VARCHAR2(30) DEFAULT ' ',

"INS_AD" VARCHAR2(100) DEFAULT ' ',

"INS_DT" VARCHAR2(8) DEFAULT ' ',

"BEG_DT" VARCHAR2(8) DEFAULT ' ',

"PM_DW_FLG" VARCHAR2(1) DEFAULT '0',

"EMV_DW_FLG" VARCHAR2(1) DEFAULT '0',

"PER_CCY" VARCHAR2(1) DEFAULT '0',

"DPS_AMT" NUMBER(13,2) DEFAULT 0,

"CONN_MOD" VARCHAR2(3) DEFAULT ' ',

"EMV_PM_MOD" VARCHAR2(2) DEFAULT ' ',

"PRV_FLG" VARCHAR2(1) DEFAULT '0',

"RARD_CD" VARCHAR2(4) DEFAULT ' ',

"BAT_NO" VARCHAR2(6) DEFAULT ' ',

"ORG_NO" VARCHAR2(10) DEFAULT ' ',

"TRM_KEY" VARCHAR2(64) DEFAULT ' ',

"TRM_TEK" VARCHAR2(64) DEFAULT ' ',

"TRM_SEK" VARCHAR2(64) DEFAULT ' ',

"MAC_KEY" VARCHAR2(64) DEFAULT ' ',

"PIN_KEY" VARCHAR2(64) DEFAULT ' ',

"RFD_FLG" VARCHAR2(1) DEFAULT '1',

"SFT_VER" VARCHAR2(20) DEFAULT ' ',

"OFF_FLG" VARCHAR2(1) DEFAULT '0',

"SIG_DT" VARCHAR2(8) DEFAULT ' ',

"RSV_DAT" VARCHAR2(50) DEFAULT ' ',

"UPD_DT" VARCHAR2(8) DEFAULT ' ',

"UPD_TLR" VARCHAR2(10) DEFAULT ' ',

"TM_SMP" VARCHAR2(26) DEFAULT ' ',

"REG_DT" VARCHAR2(8),

"INS_TLR" VARCHAR2(30) DEFAULT '',

"OPER_MGR" VARCHAR2(30) DEFAULT '',

"MEM_DLD_TYP" VARCHAR2(2),

"CONN_TY" VARCHAR2(10) DEFAULT '',

"SIM_SN" VARCHAR2(16) DEFAULT '',

"LAI" VARCHAR2(10) DEFAULT '',

"CID" VARCHAR2(10) DEFAULT '',

"LONGITUDE" VARCHAR2(30) DEFAULT '',

"LATITUDE" VARCHAR2(30) DEFAULT '',

"ADDRESS" VARCHAR2(100) DEFAULT '',

"TEL_NO" VARCHAR2(20) DEFAULT '',

"TEL_CITY" VARCHAR2(50) DEFAULT '',

"MAC_ADDR" VARCHAR2(30) DEFAULT '',

"IP_ADDR" VARCHAR2(30) DEFAULT '',

"IP_CITY" VARCHAR2(50) DEFAULT '',

"RMK" VARCHAR2(500) DEFAULT '',

"DATA_KEY_TS" VARCHAR2(32),

"SATTLE_SMP" VARCHAR2(32),

"DATA_KEY" VARCHAR2(32),

SUPPLEMENTAL LOG GROUP "GGS_TMSTPOS_12801" ("MERC_ID", "TRM_NO", "TRM_SN") ALWAYS

)    TABLESPACE "TBS_POSP" ;

CREATE UNIQUE INDEX  "TMSTPOS_PK" ON "POSP"."TMSTPOS" ("MERC_ID", "TRM_NO", "TRM_SN")

TABLESPACE "TBS_POSP_IDX" ;

CREATE UNIQUE INDEX "TMSTPOS_UI1" ON "POSP"."TMSTPOS" ("ORG_NO", "TRM_NO")

TABLESPACE "TBS_POSP_IDX" ;

GRANT SELECT ON "TMSTPOS" TO "RPTADM";

GRANT SELECT ON "TMSTPOS" TO "VAS_PLATFORM";

GRANT SELECT ON "TMSTPOS" TO "BMP_USER";