DB02:Space management/Segments/Most allocated extents in any segment

[Former Member]

Hi ,

in My SAP server: DB02 > Oracle Database Administration > Alerts > Alert monitor, there are few red alerts.

1. Space management > Segments >Most allocated extents in any segment 263 > 200 - 263 > 200: number of extents > threshold 03.03.2009 09:35:46

in RZ20 Most allocated extents in any segment having thersold value :200

Can anybody knows what it is about? How to fix this? And what are the risks if I ignore this?

with Regards

Harinatha Reddy M

[Former Member]

Harinath,

Please post you oracle version details. But you do not need to worry if it is 10g or locally managed tablespaces.

You can fix this by reorgnizing the segments (tables). To do this I would advise you to use BRTOOLS and can be done online. I believe there is no risk if you use BRTOOLS to do this. As always it is better to have good backup before we do any maintainance.

Hope this helps.

Manoj Chintawar

[Former Member]

Hi,

What is your Oracle database version.? If it is 9i or 10g then you can ignore this warning as from Oracle uses Localy managed Tablespaces.

Please check below mentioned SAP notes, it may help you.

Note 599694 - LMTS autoallocate: Extent allocation

Note 706625 - Oracle9i: Locally managed SYSTEM tablespace

Note 214995 - Oracle locally-managed tablespaces in the SAP environment

Thanks,

Sushil

[Former Member]

Hai,

Are you using Locally managed tablespace, if yes then you dont have to care about this warning.

High number of extents is not a problem in LMTS.

Please check the below link for cause and action:

http://help.sap.com/saphelp_nw70/helpdata/EN/25/5215e970077e4fb366e5ce25629aac/frameset.htm

Regards,

Yoganand.V