Space Utilization Problems

From: <stuco_at_mailcity.com>
Date: Mon, 01 Jun 1998 20:54:29 GMT
Message-ID: <6kv4e4$cb$1@nnrp1.dejanews.com>

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 Received on Mon Jun 01 1998 - 15:54:29 CDT