Disable Rollback Segments
1) can I say to Oracle not to use the Rollback segments since I am updating huge Number of records.
2) Is it possible to cache a huge table (say with 10 million records) using dbms_...keep.
Please let me know your response as soon as possible
You can make a PL/SQL with a commit interval, for example :
i number := 0;
cursor s1 is SELECT * FROM tab1 WHERE col1 = 'value1'
for c1 in s1 loop
update tab1 set col1 = 'value2'
where current of s1;
i := i + 1; -- Commit after every X records
if i > 1000 then
i := 0;
Before this, you can force to use a big rollback segment like this :
SQL>set transaction use rollback segment rbsbig;
Hope that help you.