Re: Space Utilization Problems

We all started some time and learned. And forgot.

I have been working with Oracle for 11 years, but spent the last 24 hours trying to figure out why an index rebuild was running out of room. It finally dawned on me 2 hours ago to check the default pctincrease parm of the temporary tablespace.

I wish the Elisonians had decided to set the defaults to 0 or 1 instead of 50.

In article <6l5pr4$igo$1_at_news01.iafrica.com>,   "Tony de Lange" <tony.delange_at_alusaf.com> wrote:
>
> Scary, Isn't it ?
>
> Jonathan Lewis wrote in message <01bd8e5e$8998e290$0300a8c0_at_WORKSTATION>...
> >
> >
> >Should this type of question come from someone with this type of job
> >description ?
> >
> >
> >stuco_at_mailcity.com wrote in article
> ><6kv4e4$cb$1_at_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 Thu Jun 04 1998 - 17:00:33 CDT