I have 3,.000,000 plus rows to null out in my database. This will run
for quite a while if I do it in sqlplus and when I am done I will
commit. I am afraid of system slowdown unitl the commit is executed. I
am know going to write a pl/sql program to perform the update so I can
control how often the update stmt commits. What is a good rule of thumb
on commits. How many statements can I process before I commit and still
not hamper system performance.
--
Joseph P. Condle condle_at_mars-systems.com
Systems Analyst II Office
412-473-6542
Medical ARchival Systems, Inc. (MARS) Pager 412-572-9490
1370 Beulah Road Pgh. Pa. 15235 Fax 412-473-6538
Received on Fri Feb 23 2001 - 09:23:53 CST
