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. B8000_A422_000_085_140402_WW_WIFI
  2. how to post miro for zero grn value
  3. macbook pro periodic sound
  4. itunes error code 13014 mac os 10.5.8
  5. logic 9 for windows 7 200mbs
  6. Neha jpx pothos
  7. claiming primary bt id status
  8. does STATUS_CHANGE_EXTERN COMMIT WORK
  9. dsccsetup ads-create no ejectur nathing
  10. throughoutrpq
Copyrights 2019 Fcffair BigData Resource, All rights reserved