91超碰碰碰碰久久久久久综合_超碰av人澡人澡人澡人澡人掠_国产黄大片在线观看画质优化_txt小说免费全本

溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

ORA-12838: cannot read/modify

發布時間:2020-02-22 23:10:40 來源:網絡 閱讀:305 作者:jsj_007 欄目:關系型數據庫

insert插入數據時報錯:

SCOTT@prod>insert?/*+?append?*/?into?scott.employee?select?*?from?scott.employee?;
3584?rows?created.
SCOTT@prod>/
insert?/*+?append?*/?into?scott.employee?select?*?from?scott.employee
????????????????????????????????*
ERROR?at?line?1:
ORA-12838:?cannot?read/modify?an?object?after?modifying?it?in?parallel

查看表并行度

SQL>?select?a.degree?from?dba_tables?a?where?a.table_name='EMPLOYEE';
DEGREE
-----------
1

查看鎖信息

SELECT?o.object_name,
???????o.owner,
???????l.locked_mode,
???????s.sid,
???????s.serial#,
???????s.logon_time
??FROM?v$locked_object?l,?dba_objects?o,?v$session?s
?WHERE?l.object_id ?=?o.object_id
???AND?l.session_id?=?s.sid
???AND?o.object_name?=?'EMPLOYEE';
???
OBJECT_NAME??????OWNER???LOCKED_MODE????????SID????SERIAL#?LOGON_TIME
----------------?-------?-----------?----------?----------?-----------
EMPLOYEE?????????SCOTT?????????????6?????????80???????5328?2019/11/24


ora-12838錯誤

SCOTT@prod>!oerr?ora?12838
12838,?00000,?"cannot?read/modify?an?object?after?modifying?it?in?parallel"
//?*Cause:?Within?the?same?transaction,?an?attempt?was?made?to?add?read?or?
//?modification?statements?on?a?table?after?it?had?been?modified?in?parallel
//?or?with?direct?load.?This?is?not?permitted.
//?*Action:?Rewrite?the?transaction,?or?break?it?up?into?two?transactions:
//?one?containing?the?initial?modification?and?the?second?containing?the
//?parallel?modification?operation.


append會在高水位之上插入數據并且生成較少的redo數據,加快速插入速度的同時會持有一個排它鎖,對于執行后未提交的事務容易引發該問題。


MOS相關文檔

ORA-12838?with?Direct?Load?Inserts?(文檔?ID?116494.1)
PARALLEL?RESTRICTIONS:A?transaction?can?contain?multiple?parallel?DML?statements?that?modilydifferent?tables,?but?after?a?parallel?DML?statement?modifies?a?table,
NO?subsequent?serial?or?Parallel?statment?(DML?or?QUERY)?can?access?thesame?table?again?in?that?transaction.***Each?insert?in?SQL*plus?is?considered?a?transaction,?
while?the?wholePL/SQL?BLOCK?is?considered?a?transation.



向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

镇原县| 武定县| 南平市| 筠连县| 濮阳县| 澄迈县| 文昌市| 建湖县| 灵丘县| 河西区| 绥宁县| 方城县| 永康市| 大埔区| 六安市| 维西| 漳浦县| 峡江县| 府谷县| 五大连池市| 大姚县| 温宿县| 磴口县| 遂川县| 阜南县| 抚州市| 义马市| 淄博市| 南平市| 富锦市| 清河县| 格尔木市| 吴桥县| 太白县| 湘阴县| 汤原县| 平邑县| 太原市| 怀集县| 高淳县| 得荣县|