Disable Rollback Segments

Advertisement
November 30

Hello friends,
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
Regards,
Kumar

Advertisement

Replay

Hi,
You can make a PL/SQL with a commit interval, for example :
========================================================
declare
i number := 0;
cursor s1 is SELECT * FROM tab1 WHERE col1 = 'value1'
FOR UPDATE;
begin
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
commit;
i := 0;
end if;
end loop;
commit;
end;
========================================================
Before this, you can force to use a big rollback segment like this :
SQL>set transaction use rollback segment rbsbig;
Hope that help you.
gnom92.

View 8 Replies

Tags:

  1. hp 2000-2313tu clean install os
  2. iphoto 8.1.2 hanging delete plist
  3. ba amex cli when bad credit
  4. SAP PI CPIC-CALL: ThSAPCMRCV
  5. how to include fcaregul in idoc
  6. cisco ise authentication failure
  7. DCD5
  8. reviewrwz
  9. dollar6oc
  10. rsm340 0material_attr
Copyrights 2019 Fcffair BigData Resource, All rights reserved