Re: table disk usage?

From: kennedy-family_at_attbi.com , who wrote in message news:<DMwJa.78793$sm5.80175_at_rwcrnsc52.ops.asp.att.net>...

> Clearly management made a mistake getting rid of the DBA. Now you get to
> hire someone or pay a consultant. guess the data isn't that important.
> Jim

Brilliant post. It *never* occurred to me that management made a mistake. Thanks for the invaluable _technical_ advice.

-Bob

> Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> with family. Remove the negative part, keep the minus sign. You can figure
> it out.
> "Bob - Andover, MA" <tsreyb_at_yahoo.com> wrote in message
> news:a8cd904e.0306222130.7d25d0ec_at_posting.google.com...
> > My company uses oracle9i (solaris). unfortunately we've lost most of
> > our oracle expertise to layoffs. We're training someone to pick up the
> > slack, but it is slow going. In the meantime, we continually run into
> > problems filling up the disk partition containing the oracle database
> > files - but nobody knows how to determine which users and which tables
> > are consuming the space, nor how to reclaim that space.
> >
> > I'm wondering if there are any quick and dirty stop-gap hints anybody
> > can suggest. Ideally, we'd like to be able to perform the following
> > tasks:
> >
> > o discover names of all tables in the oracle database files
> > o monitor table space usage for all the discovered table names
> > o drop one or more tables
> > o reclaim any space from dropped tables for new table growth
> > o Resize disk space allocations for each table
> > o perform these tasks using sqlplus command line
> >
> > Part of the problem is, I just don't understand how the handful of
> > users connecting to this db server can consume its 18g of disk space
> > in just a matter of weeks. We have one application that does produce a
> > lot of data, but supposedly none of us are running that app. So part
> > skill we need is to be able to discover which tables are causing all
> > the problems.
> >
> > I realize oracle admin is a monumental task .. but if we just had a
> > few commands to hold us over until the expertise is acheived in house,
> > we'd breathe a lot easier!
> >
> > thanks,
> > -tsreyb
Received on Mon Jun 23 2003 - 09:52:15 CDT