SET TRANSACTION USE ROLLBACK SEGMENT rbs_name.
A free extent is a collection of continuous free blocks in tablespace. When a segment is dropped its extents are reallocated and are marked as free.
Free extents cannot be merged together in Ver 6.0.Free extents are periodically coalesces with the neighboring free extent inVer 7.0
PCTFREE parameter Row size also reduces no of rows per block.
We can plan the storage for a table as how much initial extents are required, how much can be extended next, how much % should leave free
Each block contains entries as followsFixed block headerVariable block headerRow Header,row date (multiple rows may exists)PCTEREE (% of free space for row updation in future)
Latest Answer: A block is divided into1. Header2.free space3.data spaceThe free space is in the middle shrinks as header and data space grow.Space usage in the data space :The data space is managed with 2 parametersa.pctused b.pctfreesuppose pctused=40 ...
This is used to reserve certain amount of space in a block for expansion of rows.
It is used to set the optimal length of a rollback segment.
To manage the database level transactions such as modifications of the data dictionary table that record information about the free space usage.
Latest Answer: 1.System tablespace is required in all databases.2.It is created with the database.3.Contains the data dictionary and stored program units.4.Contains SYSTEM undo segment. ...
Create a database which implicitly creates a SYSTEM Rollback Segment in a SYSTEM tablespace. Create a Second Rollback Segment name R0 in the SYSTEM tablespace. Make
Latest Answer: Create rollback segment by using command likecreate rollback segment rbs01 tablespace tbs1 storage (initial 1M next 1M optimal 5M minextents 20 maxextents 100)Edit the database initialization file to include the name of the new rollback segmentROLLBACK_SEGMENTS = ...
View page << Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
Go Top
