Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: nextexent issue
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