1.

Explain About Segments? Types Of Segments?

Answer»

Segments : A segment is a set of EXTENTS that contain all the data for a specific logical storage structure within a tablespace. For example, for each table, Oracle allocates ONE or more extents to form that table’s data segment, and, for each index, Oracle allocates one or more extents to form its index segment.

There are FOUR types of segments used in Oracle DATABASES:

  1. data segments.
  2. index segments.
  3. rollback segments.
  4. temporary segments.

Segments : A segment is a set of extents that contain all the data for a specific logical storage structure within a tablespace. For example, for each table, Oracle allocates one or more extents to form that table’s data segment, and, for each index, Oracle allocates one or more extents to form its index segment.

There are four types of segments used in Oracle databases:


Discussion

No Comment Found

Related InterviewSolutions