Re: nextexent issue

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 -- Received on Fri Jul 18 2003 - 07:59:40 CDT