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