Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: table disk usage?

Re: table disk usage?

From: Ryan <rgaffuri_at_cox.net>
Date: Mon, 23 Jun 2003 21:50:23 GMT
Message-ID: <zCKJa.11984$pH3.4171@news2.east.cox.net>

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3EF730EF.5FB131EF_at_exxesolutions.com...
> "Bob - Andover, MA" wrote:
>
> > 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
>
> I understand your sense of offense at Jim's remarks but there is something
there of great value.
>
> Why are you making managements bad decisions your problem? Why are you
expending effort
> covering for decisions made by people who at best were ignorant of
consequences and at worst
> figure you for the fall guy?
>
> I know this may sound cold and callous but you don't have enough fingers
to plug all of the holes
> in the dike yourself. Let it fail! Bad decisions have consequences. And
those consequences can
> happen to the bad managers or to your health and happiness.
>
> Make your actions professionally and concientiously but don't be
self-abusive. Tell them that there
> is a reason why good DBAs get paid in six figures and that if they can not
afford a full-time DBA
> they should hire one that looks things over on a regular schedule via a
remote connection. There
> are several companies I can recommend that do that well.
>
> You get paid to one job. Be prepared to pay the consequences if you try to
do two or more. And
> it is absolutely impossible for us, or anyone else, to quickly give you
enough information to keep you
> from making bigger mistakes than just doing nothing at all.
>
> Relax. Take a brisk walk at lunch. It is a nice day.
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>

well he probably doesnt want to get laid off either. BTW, most DBA jobs on the market these days pay under $80k, if not ALOT lower. Ive seen jobs out there looking for people with 5 years experience and paying $45k.

not sure its a good idea to tell a guy at a company who laid off a high skilled laborer to fail. if they can lay off the DBA, they can lay him off and replace him.

now to answer some of your questions

  o discover names of all tables in the oracle database files go otn.oracle.com go to documentation. Go to Library for Oracle 9i. You will see a link there for DATA DICTIONARY. There are views to give you this info. Look at DBA_TABLES. Dont you have a data model?   o monitor table space usage for all the discovered table names in that documentation list read: Concepts and Administrators document. How much space you use, is often based on how you store the data. Look into your PCTINCREASE value on the table. Set it to 0. Do an ALTER TABLE <TABLENAME> Move; set pctincrease = 0. do this for all tables.
  o drop one or more tables
drop table <tablename>
  o reclaim any space from dropped tables for new table growth depends on the type of tablespace you have.   o Resize disk space allocations for each table this has a naive level and requires more training  o perform these tasks using sqlplus command line

Bud, you really have to do ALOT of studying. Why would you lay off an Oracle person than spend time(which translates into money) training a novice.

Places to start learning:

Oracle Documentation:
Concepts
Adminstrators Document

Go buy Beginning Oracle Programming. Also get Freemans DBA Handbook. This one is dense, but will get you started.

You have ALOT of work to do. Now when you learn more and want to come back here and post specific questions, you will get better responses. Received on Mon Jun 23 2003 - 16:50:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US