Skip to Content
avatar image
Former Member

DBcheck warnings in DB13

Hello all,

We are running on ECC 5.0 Oracle 9.2.0.7 HP-UX platform and in DB13 checkdb operation gives below mentioned warnings. I have gone through note 435290 and estimated solutions for the same.

Please let me know what exactly i need to change in DB17

Warning 1 :

BR0970W Database administration alert - level: WARNING, type: CRITICAL_SEGMENT, object: (table) SAPR3.EDI40, value: 1310720 KB * 2 / PSAPCLUD (> 1728480/1041912/40944/38184/32248 KB)

Solution : Extend tablespace PSAPCLUD or change next entent value for EDI40 table

warning 2:

BR0978W Database profile alert - level: WARNING, parameter: DB_BLOCK_BUFFERS, value: 12288 (<> 0)

Solution : currently in DB17 value set as

Active Flag Yes

Condition Level Warning

Check Condition Not equal to 0

(Please let me know what exactly i need t change and to what value.)

Warning 3:

BR0978W Database profile alert - level: WARNING, parameter: LOG_CHECKPOINT_INTERVAL, value: 300000 (<> 0)

Solution : currently in DB17 value set as

Active Flag Yes

Condition Level Warning

Check Condition Not equal to 0

(Please let me know what exactly i need t change and to what value.)

Warning 4 :

BR0978W Database profile alert - level: WARNING, parameter: LOG_CHECKPOINT_TIMEOUT, value: 1800 (<> 0)

Solution : currently in DB17 value set as

Active Flag Yes

Condition Level Warning

Check Condition Not equal to 0

(Please let me know what exactly i need t change and to what value.)

Warning 5 :

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_FEATURES_ENABLE, value: 8.1.7 (<> 9.2.0)

Solution :

My database is 9.2.0.7 and value set in INITSID.ora is 9.2.0 still

> show parameter OPTIMIZER_FEATURES_ENABLE;

above query show 8.1.7

May be my database is running on Spfile mechanism.

How to indentify the same ... i know the procedure to change to Pfile mechanism.

But how to indentify whether current setting is Spfile mechanism.

Thanks in advance.

Regards,

RR

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 02, 2008 at 05:16 AM

    Note 601157 - Oracle9i: Server Parameter File

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

    • Hmm, are you use Dinamical SGA ? Try to check Note 617416 - Oracle9i: Dynamic SGA

      if you want to use this when DB_BLOCK_BUFFERS is obsolete....

      LOG_CHECKPOINT_INTERVAL 3000000000 (<= 8.0.6)

      0 (>= 8.1.5) per Note 124361.

      LOG_CHECKPOINT_TIMEOUT 0 (<= 8.0.6) per Note 124361. (not set for 9 oracle)

      Regards.