Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: About DBA_SEGMENTS

Re: About DBA_SEGMENTS

From: Ruudboy <ruud.schilders_at_home.nl>
Date: Wed, 06 Jun 2001 22:29:44 GMT
Message-ID: <s9yT6.48314$w4.1210069@e420r-sjo3.usenetserver.com> 






Hi,



a segment is the collection of extents that belong to an object. For
example , if you have a table EMP with 6 extents of 1MB, those extents
together are 1 segment of 6MB, with the name EMP. Also if you have an
index EMP_IDX, you will also have a segment EMP_IDX which consists of
all extents of that index.







--



Ruud Schilders




Oracle DBA


e-mail : ruud.schilders_at_home.nl


ICQ : 397543


Posted via dBforums, http://dbforums.com
Received on Wed Jun 06 2001 - 17:29:44 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US