BR0970W

[Former Member]

Experts,

I have this warning in DB13

<b>BR0970W Database administration alert - level: WARNING, type: MANY_EXTENTS, object: (index) SAPR3.GVD_OBJECT_DEPEN~0, value: 100.00% (> 80%)</b>

SAP Release 4.6c

Oracle 9.2

Windows NT

Thanks

Hesham

[markus_doehr2 · Accepted solution]

This means, that the Index 0 on table GVD_OBJECT_DEPEN has many extents and should be reorganized (dropped and re-created).

--

Markus

[Former Member]

Thank you

[former_member204746]

the tablespace that contains this index is not locally mamanged, so, you are still using the old dictionary managed tablespace.

<b>SHORT TERM SOLUTION:</b>

so, go into SE14, chose table GVD_OBJECT_DEPEN

click on INDEXES

choose index 0

click on STORAGE PARAMETERS

press F5

change maximum extents to a higher value like 500.

also change NEXT EXTENT to a bigger value such as 1024.

click on APPLY.

<b>LONG TERM SOLUTION:</b>

after applying short term solution, reorg the index:

so, go into SE14, chose table GVD_OBJECT_DEPEN

click on INDEXES

choose index 0

click on DELETE DATABASE INDEX

click on CREATE DATABASE INDEX

Hopewthis helps.