Warnings In Check DB

[Former Member]

In our test server we are facing a problem in check DB Job ( T-Code - DB13 )

BR0970W Database administration alert - level: WARNING, type: CRITICAL_SEGMENT, object: (table) SAPR3.SOC3, value: 2047960 KB * 2 / PSAPBTABD (> 2047992/2045392/2045392/2045392/2045392 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_SEGMENT, object: (table) SAPR3.TST03, value: 2047960 KB * 2 / PSAPBTABD (> 2047992/2045392/2045392/2045392/2045392 KB)

while investigating we found that tablespace - PSAPBTABD -

Tablespace Size (kb) Free (kb) Used (%)

PSAPBTABD 580.123.272 33.058.624 94

In RZ20

Segments w. too few allocatable extents -

Tablespace Exts.left Owner Segment Segm.type Next (KB)

PSAPBTABD 1 SAPR3 SOC3 TABLE 2047.960

PSAPBTABD 1 SAPR3 TST03 TABLE 2047.960

Fewest allocatable extents for a segment

Tablespace Exts.left Owner Segment Segm.type Next (KB)

PSAPBTABD 1 SAPR3 SOC3 TABLE 2047.960

PSAPBTABD 1 SAPR3 TST03 TABLE 2047.960

Can somebody guide what should I do so that we can rectified this warnings

Thanks & Regards

Shishir

[former_member204746]

possible solutions:

1. increase datafile

2. add a datafile

3. change next_extent size to a smaller value

4. reorg tablespace

[Former Member]

Hi,

As per your query your tablespace size is 94% , in this case the db check do not places some logs .

First observe that you have to to keep any tablespace that should not exceed 90% if that exceeds the database performance is slow...

Regards

Pavan

[former_member72237]

Hi,

Extend the tablespace PSAPBTABD with file size more then 2047960 KB will remove the alert message from DB13.

regards

Virendra

[Former Member]

This means that for the next extend of the table SOC3 and TST03 you need contiguously 2047960 KB but you only have 2047992/2045392/2045392/2045392/2045392 KB.

Either increase the more space in the datafiles or decrease the next extent value of those two tables.

Rgds,

SK

[Former Member]

Hello SK

relevent information

select MAX_EXTENTS,MIN_EXTENTS,MAX_EXTENTS from dba_tablespaces

2 where TABLESPACE_NAME='PSAPBTABD';

MAX_EXTENTS MIN_EXTENTS MAX_EXTENTS

-

---

-

---

-

---

2147483645 1 2147483645

Tablespace Size (kb) Free (kb) Used (%) Tab/ind Extents AutoExt (kb)

PSAPBTABD 580.123.272 31.741.104 94 8.684 31.121 Off

Edited by: Shishir Bajpai on Feb 17, 2009 12:58 PM

[Former Member]

One more point to look at: Once a tablespace is more than 90% full, the db-check is sending an alert. In your case, PSAPBTABD is 94% full.

Edited by: Ulf Brinkmeier on Feb 17, 2009 8:46 AM

[Former Member]

Looks like you have almost reached your maxentents value. Can you please let me know the following values.

maxextents

minextents

maxsize

You will get all the info from DB02.

Rgds,

SK