Re: Space Utilization Problems

stuco_at_mailcity.com wrote:

> When I query my DBA_FREE_SPACE and DBA_DATA_FILES, I notice that my free
> space and space used has not changed in byte count in a week in all
> tablespaces, save for SYSTEM and an index tablespace, where I explicitly
> created a new index late last week.
>
> These loads occur every morning through a Pro*C application via an
> application server and we INSERT approx 20,000 new rows daily into a
> particular tablespace.
>
> I am running Oracle 7.3.3 on NT 4.0. My machine is an HP Netserver LX Pro
> with two 200Mhz Pentium Processors, 128MB memory and their corresponding
> Model 1 Raid Array.
>
> Do you think I have to totally rebuild my database???
>
> Thanking you in advance for your help.
>
> Stuart Cowen
> DBA Consultant
> Paladin Consulting, Inc. - Dallas
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

  Hi
   Analyzing table where U insert 20K rows everyday will give U more info that why your dba_free_space view is not changed. Well my guess is you have created table with enough initial ... this is just a guess.. . 'cause
in one instance some one did mentioned same problem and it happened to be a table with initial of 64M and total row length was 40 bytes only. Hope this will help
Good luck

Pradhan Received on Tue Jun 02 1998 - 01:32:41 CDT