Transaction table in rollback segments
Advertisement
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 transactions that use the associated rollback segment and the rollback entries for each change performed by these transactions.
Advertisement
Replay
First of all, the statement is talking about old manual undo management using rollback segment.
If you check the preceding two paragraph of the statement then it's easier to understand,
It basically says, Rollback segment hold rollback entries of transaction. To make it easier to track transactions and undo entries, Oracle maintain a table to save such info.
Rollback segment , transaction and undo entries are one to many relationships.
Rollback Segment --< Transactions --< Undo Entries
http://download.oracle.com/docs/cd/B10501_01/server.920/a96524/b_deprec.htm
Contents of a Rollback Segment
Information in a rollback segment consists of several rollback entries. Among other information, a rollback entry includes block information (the file number and block ID corresponding to the data that was changed) and the data as it existed before an operation in a transaction. Oracle links rollback entries for the same transaction, so the entries can be found easily if necessary for transaction rollback.
Neither database users nor administrators can access or read rollback segments. Only Oracle can write to or read them. (They are owned by the user SYS, no matter which user creates them.)
How Rollback Entries Are Logged
Rollback entries change data blocks in the rollback segment, and Oracle records all changes to data blocks, including rollback entries, in the redo log. This second recording of the rollback information is very important for active transactions (not yet committed or rolled back) at the time of a system crash. If a system crash occurs, then Oracle automatically restores the rollback segment information, including the rollback entries for active transactions, as part of instance or media recovery. When recovery is complete, Oracle performs the actual rollbacks of transactions that had been neither committed nor rolled back at the time of the system crash.
When Rollback Information Is Required
For each rollback segment, Oracle maintains a transaction table--a list of all transactions that use the associated rollback segment and the rollback entries for each change performed by these transactions. Oracle uses the rollback entries in a rollback segment to perform a transaction rollback and to create read-consistent results for queries.
View 6 Replies
November 30
Hi, Anyone try before converting from UNDO management to using rollback segment....What are the procedures for the conversion... Thank You...Hi, Follow these steps to convert from Auto UNDO to Rollback Segs.... 1. With the database opened, create a r
View All Replies
November 30
I have the following queries to find information about rollback segments. I want the sql to find % of rollback segment used. --rollsegs.sql select SEGMENT_NAME, OWNER, TABLESPACE_NAME, SEGMENT_ID, status from dba_rollback_segs order by segment_name;
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
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
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 p
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
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
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
We have an oracle 7.3 database on solaris(sparc) 2.6. In the midddle of the transactions, the following error message occured: ORA 1578 Data block corrupted(file #2, block#8274) ORA-1110 Datafile 2:'/user1/oradb/rbstbl.dbf' (this datafile corresponds
View All Replies
November 30
We have an oracle 7.3 database on solaris(sparc) 2.6. In the midddle of the transactions, the following error message occured: ORA 1578 Data block corrupted(file #2, block#8274) ORA-1110 Datafile 2:'/user1/oradb/rbstbl.dbf' (this datafile corresponds
View All Replies
November 30
Hi , Just a wonder....!!!! Why Oracle10g uses System Rollback Segment....and not System undo tablespace... since rollback segment as a method to rollback transactions has been depreciated.....????? Thanks..... SimSystem Rollback Segment is reserved f
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
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
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
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
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
Hello Everyone This is the first time I am a forum member and I'm figuring out how it works because I have a very big problem Look, I'm a support engineer and, as you know, the code of the application is not own by me. Three weeks ago I received a re
View All Replies
October 11
Hello experts, please help. I have the following error when importing table data to my Oracle 8.1.7 database. IMP-00058: ORACLE error 1562 encountered ORA-01562: failed to extend rollback segment number 16 ORA-01237: cannot extend datafile 3 kind reg
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