Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is a segment in Oracle? Explain the different types?

April 26, 2017different explain Oracle segment types

0

Posted

What is a segment in Oracle? Explain the different types?

1 Answer

0

Posted

The place where the datas are stored in the alloted tablespace are called as segments. The data may be a table or index data required by DBMS to operate.Segments are the next logical level of a storage tablespace. There are basically 5 types of segments * Data segment : Contains all the data of each table * Index segment : Contains all the index data for one or more indexes created for a table. * Rollback segment : Contains the recorded actions which should be undone under certain circumstances like * Transaction rollback * Read consistency * Temporary segment : Whenever a processing occurs Oracle often requires temporary work space for intermediate stages of statement processing. These area are known as temporary segments. * Bootstrap segment : Contains information of the data dictionary definition for the tables to be loaded whenever a databases opened.