-
编辑 删除
about lock
1) Here is a small example showing how this happens. We will use three V$ tables in order to see how this works; V$TRANSACTION, V$SESSION, and V$LOCK. V$TRANSACTION contains an entry for every active transaction. V$LOCK contains an entry for all locks held as well as locks being waited on. V$SESSION shows us the sessions logged in. We'll start by starting a transaction in one session and looking at the state of the system at that point: tkyte@TKYTE816> update dept set deptno = de
-
编辑 删除
tom 就是tom
You Asked Good Morning Tom. I need your expertise in this regard. I got a table which contains millions or records. I want to update and commit every time for so many records ( say 10,000 records). I dont want to do in one stroke as I may end up in Rollback segment issue(s). Any suggestions please ! ! ! Murali and we said...If I had to update millions of records I would probably opt to NOT update. I would more likely do: CREATE TABLE new_table as select <do the update &
