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: nextexent issue

Re: nextexent issue

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Fri, 18 Jul 2003 10:54:36 -0700
Message-ID: <3F18345C.4A3611A8@exxesolutions.com>


Mark D Powell wrote:

> jamesyang_at_163.net (James) wrote in message news:<86815f22.0307171911.342eaf84_at_posting.google.com>...
> > We are running SAP based on Oracle database.
> >
> > There is table which is increased very quickly. The backgroud
> > statistic job calculated/updated the nextextent to 2G but the problem
> > is the maximum data file size is 2G and we can not ensure the free
> > space is continuous for the next exntent of this table. We can not
> > extent the table except change the nextextent parameter, example to
> > 500M, manually.
> >
> > So my question is:
> >
> > Can I set the parameter's property to "no changeable", sure can be
> > changed under some condition?
> >
> > If somebody know SAP very well, please advise can we check/update all
> > the objects except this table?
> >
> > Thanks
> > jamesyang_at_163.net
>
> James, I would like to suggest you consider rebuilding the Oracle
> tablespaces used to support your SAP application to being locally
> managed with uniform extents. This would mean that the database
> tablespace parameters would override any requested space allocation
> parameters: initial, next, pctincrease and allow the DBA to manage
> free space and growth easier. So SAP, which can run on many different
> databases should be happy and the DBA should be as happy as a DBA can
> be when running an application not designed for the database it is
> running on.
>
> HTH -- Mark D Powell --

I agree completely. An export followed by an import and much of the problem will be solved.

Also know that you can add a second 2GB datafile to the tablespace in just a minute too.

--
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)
Received on Fri Jul 18 2003 - 12:54:36 CDT

Original text of this message

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