DBcheck warnings in DB13

[Former Member]

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

[Former Member]

Note 601157 - Oracle9i: Server Parameter File

Regards.

[Former Member]

Thanks Sergo for an update on Spfile ... could you also help me with my root issue of DB13 checkdb warnings.

Regards,

RR

[Former Member]

Try to read note Note 124361 - Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x) and the notes referenced.

If you have one parameters setting in Pfile, but you see other parameters in real system, it means you need correct your spfile, how do it read in note from my previous post ... Regards.

[Former Member]

Thanks Sergo,

I will definitely go through the note , could you please suggess any changes mentioned for transaction DB17 ... do i need to remove " equal to " operator to value " 0 " for mentioned warnings

DB_BLOCK_BUFFERS

LOG_CHECKPOINT_INTERVAL

LOG_CHECKPOINT_TIMEOUT

or should i deactivate these 3 checks.

[Former Member]

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.