Skip to Content
0
Former Member
Dec 02, 2008 at 02:19 AM

DBcheck warnings in DB13

30 Views

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