Skip to Content
avatar image
Former Member

Warnings In Check DB

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Feb 17, 2009 at 07:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 17, 2009 at 07:21 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Feb 17, 2009 at 07:41 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 17, 2009 at 07:50 AM

    Hi,

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

    regards

    Virendra

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 17, 2009 at 11:27 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 17, 2009 at 12:56 PM

    possible solutions:

    1. increase datafile

    2. add a datafile

    3. change next_extent size to a smaller value

    4. reorg tablespace

    Add comment
    10|10000 characters needed characters exceeded