Subject: Re: About DBA_SEGMENTS From: Ruudboy Sender: Ruudboy Newsgroups: comp.databases.oracle.server User-Agent: forums@dbforums.com References: <9flms3$so51@imsp212.netvigator.com> Organization: forums@dbforums.com X-Newsreader: forums@dbforums.com X-References: 67978|222829 Lines: 20 Message-ID: X-Complaints-To: abuse@usenetserver.com X-Abuse-Info: Please be sure to forward a copy of ALL headers X-Abuse-Info: Otherwise we will be unable to process your complaint properly. NNTP-Posting-Date: Wed, 06 Jun 2001 18:29:44 EDT Date: Wed, 06 Jun 2001 22:29:44 GMT 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@home.nl ICQ : 397543 Posted via dBforums, http://dbforums.com