| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBA_SEGMENTS invalid? or slow?
I knew that, but the problem here is that it says the current bytes is
2,212,495,360. The table has an initial extent of 10M. I may have missed
one extent as the only difference is the last digit. It seems this has
happened to me before since the upgrade to 9.2.0.6.
What I would expect is bytes to be roughly 2GB, Truncate table drop storage, and bytes drop to 10M.
Guess I'm going to have to run some more tests. Also, it appears it doesn't happen all the time. Hmmm, maybe it's only on partitions. I'll have to watch it closer.
Michael Kline
Database Administration
Outside 804.261.9446
Cell 804.744.1545
3-9446
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark D
Sent: Friday, September 09, 2005 1:13 PM
To: oracle-l_at_freelists.org
Subject: RE: DBA_SEGMENTS invalid? or slow?
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kline.Michael
Sent: Thursday, September 08, 2005 11:43 PM
To: oracle-l_at_freelists.org
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 extentsinitial_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 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 9.2.0.6
HP-UX.
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
<mailto:michael.kline_at_suntrust.com> michael.kline_at_suntrust.com
Seeing beyond Money(sm)
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.
Seeing Beyond Money is a service mark of SunTrust Banks, Inc.
[ST:XCL]
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 09 2005 - 12:47:13 CDT
 |
 |