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

Home -> Community -> Usenet -> c.d.o.server -> Re: when was extent created? or planning db growth

Re: when was extent created? or planning db growth

From: Richard Spee <rhpspee_at_wxs.nl>
Date: Mon, 3 Jun 2002 22:44:17 +0200
Message-ID: <adgks8$h0b$1@reader05.wxs.nl>


Maybe the view DBA_EXTENTS can help.
If you are willing to sacrifice some control, you could also consider having locally managed tablespaces with for instance small, medium and large extent sizes.

"NetComrade" <netcomrade_at_netscape.net> wrote in message news:ab810584.0206031129.61126f79_at_posting.google.com...
> Recently I had some failures on extending tables.
> I regularly check for space via joining dba_free_space and
> dba_segments, but I think multiple tables grabbed a new extent in
> between the check that I run.
> I'd like to come up w/ a way of easily predicting such growth via
> using dbms_space package and some historical data on how the table
> grew.. The thing is, I don't have such historical data besides backup
> logs. Is there a view I can look this up? I'd be particularly
> interested in a time stamp of creation of new extents.
>
> Thanx.
> --
> Oracle 8.1.7.3 on solaris 7.
Received on Mon Jun 03 2002 - 15:44:17 CDT

Original text of this message

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