BR0970W Database administration alert - level: WARNING, type: CRITICAL_SEGM

[prasad_sure]

Hi,

In DB13-----> Check DB option. It's showing these warnings.

BR0970W Database administration alert - level: WARNING, type: CRITICAL_SEGMENT, object: (table) SAPR3.AMRFC, value: 40960 KB * 2 / PSAPPROTD ( > 71552/38448/19736/10656/560 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_SEGMENT, object: (table) SAPR3.AMSSU, value: 40960 KB * 2 / PSAPPROTD ( > 71552/38448/19736/10656/560 KB)

Please check it and suggest me.

Regards

S.Prasad

[Former Member · Accepted solution]

Prasad,

Tablespace PSAPPROTD is not big enough . Use brtools and add/increase datafile.You can also check note 435290 .

Thanks

Prince Jose

PS: Please assign points if its helpful

[former_member204746 · Accepted solution]

Prince is right, PSAPPROTD is not big enough,

you can extend an existing datafile with:

brspace -c -u/ -f dfalter

or create a new datafile:

brspace -c -u / -f tsextend

last option is to decrease the next_extent size of tables AMRFC and AMSSU... but this is just a very temporary solution,

<b>the best option is to extend an existing datafile.</b>

[prasad_sure · Accepted solution]

Hi,

Problem was solved. Thanks for the help.

After Check DB it's showing these error.

Please check it and suggest me.

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.DDXTF

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.DDXTT

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.TATAF

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.TRBAT

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.TRBAT2

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.TRBATC

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.DDXTF~0

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.DDXTT~0

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.TATAF^0

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.TRBAT~0

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.TRBAT2~0

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.TRBATC~0

Regards

S.Prasad

[madhukara_shenoy · Accepted solution]

Hi,

Please run the below mentioned command and see whether you can eliminate the above warnings

brconnect -u / -f stats -t missing

Regards,

Madhukar