base-oracle-4(編輯修改稿)
2025-01-26 18:32 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 tiptop 3603 147 1906 ERP tiptop 3603 147 1906 ERP SQLq_datafile SQLalter system kill session ‘SID,SERIAL’。 TIPTOP相關(guān)腳本 ? 查詢當(dāng)前系統(tǒng)中的鎖 SQLq_datafile SQLq_lock OS_USER PID ORL_USR OID LOCK_TYPE LOCK_HELD LOCK_REQUEST STATUS OWNER OBJ_NAME tiptop 3603 DS1 147 Transaction Exclusive None Blocking DS1 OMA_FILE tiptop 3603 DS1 147 DML RowX (SX) None Not Blocking DS1 OMA_FILE tiptop 3603 DS1 147 DML RowX (SX) None Not Blocking DS1 OMA_FILE tiptop 3603 DS1 147 DML RowX (SX) None Not Blocking DS1 OMA_FILE tiptop 3603 DS1 147 Transaction None Exclusive Not Blocking DS1 OMA_FILE tiptop 3603 DS1 147 Transaction Exclusive None Blocking DS1 OGA_FILE tiptop 3603 DS1 147 DML RowX (SX) None Not Blocking DS1 OGA_FILE tiptop 3603 DS1 147 DML RowX (SX) None Not Blocking DS1 OGA_FILE tiptop 3603 DS1 147 DML RowX (SX) None Not Blocking DS1 OGA_FILE tiptop 3603 DS1 147 Transaction None Exclusive Not Blocking DS1 OGA_FILE tiptop 3491 DS1 146 Transaction Exclusive None Blocking DS1 OGA_FILE OS_USER PID ORL_USR OID LOCK_TYPE LOCK_HELD LOCK_REQUEST STATUS OWNER OBJ_NAME tiptop 3603 DS1 147 Transaction Exclusive None Blocking DS1 OMA_FILE tiptop 3603 DS1 147 DML RowX (SX) None Not Blocking DS1 OMA_FILE tiptop 3603 DS1 147 DML RowX (SX) None Not Blocking DS1 OMA_FILE tiptop 3603 DS1 147 DML RowX (SX) None Not Blocking DS1 OMA_FILE tiptop 3603 DS1 147 Transaction None Exclusive Not Blocking DS1 OMA_FILE tiptop 3603 DS1 147 Transaction Exclusive None Blocking DS1 OGA_FILE tiptop 3603 DS1 147 DML RowX (SX) None Not Blocking DS1 OGA_FILE tiptop 3603 DS1 147 DML RowX (SX) None Not Blocking DS1 OGA_FILE tiptop 3603 DS1 147 DML RowX (SX) None Not Blocking DS1 OGA_FILE tiptop 3603 DS1 147 Transaction None Exclusive Not Blocking DS1 OGA_FILE tiptop 3491 DS1 146 Transaction Exclusive None Blocking DS1 OGA_FILE TIPTOP相關(guān)腳本 ? 查詢引起鎖的 SQL語(yǔ)句 SQLq_datafile SQLq_lockSQL USERNAME SID SERIAL TY LOCK_TYPE LOCK_REQUESTE ID1 ID2 SQL_TEXT DS1 136 3727 TX None Exclusive 262184 4289 update ogb_file SET ogb63 DS1 136 3727 TX None Exclusive 262184 4289 = :p1,ogb64 = :p2 WHERE DS1 136 3727 TX None Exclusive 262184 4289 ogb01 = :p3 AND ogb03 = :p4 DS1 146 2543 TX Exclusive None 655372 4311 select sma124, smb04 from DS1 146 2543 TX Exclusive None 655372 4311 sma_file ,smb_file where DS1 146 2543 TX Exclusive None 655372 4311 sma00 = 39。039。 AND sma124 = DS1 146 2543 TX Exclusive None 655372 4311 smb01 AND smb02 = 39。039。 DS1 147 1906 TX Exclusive None 262184 4289 update oga_file SET oga10 = DS1 147 1906 TX Exclusive None 262184 4289 :p1 WHERE oga01 = :p2 USERNAME SID SERIAL TY LOCK_TYPE LOCK_REQUESTE ID1 ID2 SQL_TEXT DS1 136 3727 TX None Exclusive 262184 4289 update ogb_file SET ogb63 DS1 136 3727 TX None Exclusive 262184 4289 = :p1,
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1