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
November 30
Got a problem... We are trying to move data from one database to another using: INSERT INTO table1 (SELECT a,b,c FROM [email protected]). The problem we are having is that the amount of data being moved with this in sert command is too great - we are gettin
View All Replies
November 30
Greetings HELP!! We are using oracle 8.0.5 ... The database will not open because it says the system rollback segment does not exist. The database mounts but won't open. from the file system checks, the dbf file that contains the system rollback segm
View All Replies
November 30
i have a database 9i and it using rollback segment and i would like to convert to undotablespace. question is there is anyway i can find it out what size undo i need to created base on the database right now i have it. the database is very critical i
View All Replies
October 11
I have two users, one makes some inserts in a table. The other makes a select which visits many rows. I have a big rollback-segment. To ensure, both users use this rollback-segment I created a logon-trigger: CREATE OR REPLACE TRIGGER a_logon AFTER LO
View All Replies
November 30
hi guys, I have read the following, but am still having a little difficulty conceptualising. Would someone be kind enough to give me a very brief example? thanks For each rollback segment, Oracle maintains a transaction table--a list of all transacti
View All Replies
October 11
Using Oracle 8i, on Windows platform - The question - receive an error ORA-01556 when performing a sql "ALTER TABLESPACE MY_TBS_LT OFFLINE IMMEDIATE"; ============================================= First off I created a tablespace and table on an
View All Replies
October 11
Hi guys. Am using oracle 8i and am having problems with rollbackup segment. My rbs tablespace is 35GB and will like to shrink it! Its a production db, so my question is shoudl I fire the below query? alter rollback segment SYSTEM shrink; alter rollba
View All Replies
November 30
hi i have created locally managed tablesspace and in init.ora file i have sent unto management as manual as our application needs to specify rollback segments when i created rollback segments and attached to a locally managed tablespace i am getting
View All Replies
November 30
1.Can rollback segments span one datafile like data segments? For e.g we have undo tablespace with 2 data files We have one active transaction in rbs01,now when rollback segment grows and extents are allocated to it ,if all the extents will be alloca
View All Replies
October 11
Hello all, I am hoping someone can help me. I have a dev and prod instance, with identical rollback segment specs. The problem I have is that I am running out of space on one of my instances (dev). The prod instances rbs's are all the same size while
View All Replies
November 30
I have been noticing for a few days that my UNDO tablespace has been growing in size for no apparent reason. My datafiles have only increased by 400 Meg over last 4 days, but UNDO tablespace has grown from 100 Meg - 5.6 Gig.... I decided to create a
View All Replies
October 11
Hi! We're using Oracle 9.2.0.5.0 on Sun Solaris and we're still configured to use Rollback Segments. We have an issue with Snapshot too old due to RBS too small on a long query I attach below for reference: set heading off set pagesize 0 set feedback
View All Replies
November 30
System Error: Unknown Database error (type qqdb_ResourceException) on WMS_WH1: Execute failed for SQL statement ............... error from database is: ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small... Any
View All Replies
November 30
We had an eval license of Contribute 3 which was working fine. Users could edit and publish pages without any problem. I then purchased Contribute 4 (which was just out) and installed. Now users got "Access Denied. The file may not exist, or the coul
View All Replies
November 30
I would like to know how to create the perfect rollback segments. I currently have a database that is up and running, but I feel that the rollback segments, are not running at there best. I know that the minextents should be set to 20 extents, inital
View All Replies
November 30
Hi. I am trying to use rollback segment RB6 in a delete process in a stored procedure using SET TRANSACTION USE ROLLBACK SEGMENT RB6; However, when the procedure is called and performed, an error is thrown: ORA-01562: failed to extend rollback segmen
View All Replies
November 30
How to check/find the size of current ROLLBACK segment in oracle 10g ? Kindly helpA rollback segment name like "_SYSSMU231$" is used when you have Automatic Undo Management enabled. The only relevant parameters are : 1. UNDO_MANAGEMENT=AUTO 2. U
View All Replies
November 30
Hi All i have and 11gR1(11.1.0.6) DB source instance in wich i have i a partitioned table of 1TB size. I want to IMPDP this table using NETWORK_LINK in a 11gR2(11.2.0.3) destination RAC instance. when a try to import a get the following error message
View All Replies
November 30
Hi, I use oracle database 9.2.0.1 and I try to install SCM repository but when I run ckcreate I saw an error message in the log file that Illegal rollback Segment operation in Automatic Undo mode because oracle 9.2 use automatic undo mode .So how can
View All Replies