From oracle-l-bounce@freelists.org Fri Sep 9 12:15:14 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j89HFE4Q011796 for ; Fri, 9 Sep 2005 12:15:14 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j89HF3IP011748 for ; Fri, 9 Sep 2005 12:15:04 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1F5431EB394; Fri, 9 Sep 2005 12:14:55 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06416-09; Fri, 9 Sep 2005 12:14:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8BFD11EB4A4; Fri, 9 Sep 2005 12:14:54 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5B561.AAA2987F" Subject: RE: DBA_SEGMENTS invalid? or slow? Date: Fri, 9 Sep 2005 13:12:32 -0400 Message-ID: <5A14AF34CFF8AD44A44891F7C9FF41050395BAA3@usahm236.amer.corp.eds.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: DBA_SEGMENTS invalid? or slow? Thread-Index: AcW0eziZV6THQLKyTh6HGy+h8yQ7egA5i4kw From: "Powell, Mark D" To: X-OriginalArrivalTime: 09 Sep 2005 17:12:34.0596 (UTC) FILETIME=[ABA2DE40:01C5B561] X-archive-position: 25230 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-To: mark.powell@eds.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.3 required=5.0 tests=AWL,BAYES_00,HTML_50_60, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5B561.AAA2987F Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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. =20 HTH -- Mark D Powell -- ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Kline.Michael Sent: Thursday, September 08, 2005 11:43 PM To: oracle-l@freelists.org Subject: DBA_SEGMENTS invalid? or slow? When I query dba_segments I get: =20 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 REPADMIN T_INSTRU_LDGR T_INSTRU_LDGR_200504 TABLE PARTITION TS_LDGR_M2 71 1289 2212495360 270080 211 10485760 10485760 1 2147483645 0 1 1 71 DEFAULT =20 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. =20 What's up with this? =20 Database is 9.2.0.6 HP-UX. =20 =20 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@suntrust.com =20 =20 Seeing beyond Money(sm) =20 =20 =20 LEGAL DISCLAIMER 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. =20 Seeing Beyond Money is a service mark of SunTrust Banks, Inc. [ST:XCL]=20 ------_=_NextPart_001_01C5B561.AAA2987F Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
The truncate command never releases the = initial extent=20 of the table or its associated indexes if any.  In the future I = have heard=20 Oracle is going to support defining tables and indexes without = allocating=20 storage.  But at present if the table/index exists it takes at = least one=20 extent.
 
HTH -- Mark D Powell = --

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

When I query = dba_segments I=20 get:

 

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

REPADMIN  = T_INSTRU_LDGR=20 T_INSTRU_LDGR_200504    TABLE = PARTITION    =20 TS_LDGR_M2    71   1289 = 2212495360   =20 270080    211  10485760    =20 10485760  1    2147483645   =20 0    1    1    = 71  =20 DEFAULT

 

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

 

What’s up = with=20 this?

 

Database is=20 9.2.0.6

HP-UX.

 

 

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

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

Cell:=20 804.744.1545
michael.kline@suntrust.com

 

Seeing beyond = Money(sm)

 

 
 
LEGAL DISCLAIMER
The information=20 transmitted is intended solely for the individual or entity to which it = is=20 addressed and may contain confidential and/or privileged material. Any = review,=20 retransmission, dissemination or other use of or taking action in = reliance upon=20 this information by persons or entities other than the intended = recipient is=20 prohibited. If you have received this email in error please contact the = sender=20 and delete the material from any computer.
 
Seeing Beyond = Money is a=20 service mark of SunTrust Banks, Inc.
[ST:XCL]=20
------_=_NextPart_001_01C5B561.AAA2987F-- -- http://www.freelists.org/webpage/oracle-l