RE: DBA_SEGMENTS invalid? or slow?

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 9 Sep 2005 13:12:32 -0400

The truncate command never releases the initial extent of the table or
its associated indexes if any.  In the future I have heard Oracle is
going to support defining tables and indexes without allocating storage.
But at present if the table/index exists it takes at least one extent.
HTH -- Mark D Powell --


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kline.Michael
Sent: Thursday, September 08, 2005 11:43 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: DBA_SEGMENTS invalid? or slow?

When I query dba_segments I get:


owner     segment_name  partition_name segment_type  tablespace_name
header_file   header_block  bytes     blocks    extents
initial_extent next_extent   min_extents   max_extents   pct_increase
freelists freelist_groups    relative_fno  buffer_pool

TS_LDGR_M2    71   1289 2212495360    270080    211  10485760
10485760  1    2147483645    0    1    1    71   DEFAULT


Yet, when I map the tablespace, there are no extents. We have done a
truncate of the partition with a drop storage, and it shows storage.


What's up with this?


Database is




Michael Kline
Database Administration
SunTrust Banks, Inc.
Mail Code TOC-7505

1030 Wilmer Avenue
Richmond, Va.  23227
Tel: 804.261.9446  Net: 643.9446

Cell: 804.744.1545
michael.kline@xxxxxxxxxxxx <mailto:michael.kline@xxxxxxxxxxxx> 


Seeing beyond Money(sm)


The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or other
use of or taking action in reliance upon this information by persons or
entities other than the intended recipient is prohibited. If you have
received this email in error please contact the sender and delete the
material from any computer.
Seeing Beyond Money is a service mark of SunTrust Banks, Inc.

Other related posts: