Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old November 21st, 2003, 09:07 PM
shankariyer shankariyer is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2003
Posts: 14 shankariyer User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 31 m 42 sec
Reputation Power: 0
Peculiar behaviour on a locally managed tablespace

Hello,

Oracle version is 8.1.7.4

I've a table sitting in a locally managed tablespace. The table has an extent size of 5m( uniform ). Every time the records are inserted after the HWM( high water mark ), even though there is a lot of space available ( with in the tablespace ) and the total volume of the table ( and those inserted are very small( in 100's ). This causes lot of fragmentation.

Here are some details...

SELECT COUNT(DISTINCT DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)) FROM SA_MAX_FISCAL_PERIOD;
COUNT(DISTINCTDBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID))
---------------------------------------------------
6
select count(*) from SA_MAX_FISCAL_PERIOD;
COUNT(*)
----------
297
select num_rows, blocks, empty_blocks from user_tables
where table_name='SA_MAX_FISCAL_PERIOD';
NUM_ROWS BLOCKS EMPTY_BLOCKS
---------- ---------- ---------------------
297 5119 0

Couldn't get much from oracle meta-link.

Any help is appreciated. Thanks.

Kramer.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > Peculiar behaviour on a locally managed tablespace

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap