Danh mục

Manually Managing Undo Data (Rollback Segments)

Số trang: 22      Loại file: ppt      Dung lượng: 244.00 KB      Lượt xem: 12      Lượt tải: 0    
Thu Hiền

Xem trước 2 trang đầu tiên của tài liệu này:

Thông tin tài liệu:

Allocation of a Rollback SegmentWhen a transaction begins, a rollback segment must be assigned to this transaction. A transaction can request a specific rollback segment using the following command:SET TRANSACTION USE ROLLBACK SEGMENT rollback_segmentIf no such request is made, the Oracle server chooses the rollback segment with the fewest transactions and assigns it to the transaction.Using ExtentsTransactions use extents of a rollback segment in a sequential, circular fashion, moving from one to the next after the current extent is full. A transaction writes an entry to its current location in the rollback segment and advances the current pointer by the...
Nội dung trích xuất từ tài liệu:
Manually Managing Undo Data (Rollback Segments)

Tài liệu được xem nhiều: