Explain how to prevent tablespace fragmentation in oracle.

Explain how to prevent tablespace fragmentation in oracle.Tablespace fragmentation can be prevented by using PCTINCREASE command. PCTINCREASE is the percentage a new subsequent extent will grow. This value should be ideally set to 0 or 100 to avoid tablespace fragmentation. Alternate and strange values for PCTINCREASE results in strange sizes of extents. Same size of each extent of all segments must be used.
How are extents allocated to a segment in oracle?
An extent is stored some specific information. This information is stored using specific number of adjoining data blocks...
Describe the use of Roles in oracle.
Roles in Oracle can be used to grant privileges to a specific group of users for security.......
What is a SNAPSHOT LOG? Options to refresh snapshots in oracle.
A snapshot log is a copy of the master table. The snapshot table is updated using batch updates....
Post your comment

Related Content

Follow us

▲