DBA_SEGMENTS invalid? or slow?
- From: "Kline.Michael" <Michael.Kline@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 8 Sep 2005 23:43:14 -0400
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
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@xxxxxxxxxxxx> michael.kline@xxxxxxxxxxxx
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]
Other related posts:
