Doubts on Parameters in Oracle 9.2, AIX5.3

[Former Member]

Does anyone know the correct settings for (1) log_checkpoint_timeout & (2) shared_pool_reserved_size for Oracle 9.2 on AIX 5.3?

(1) I have set log_checkpoint_timeout =0 but my EarlyWatch reflects that this is not correct and OSS Note 0124361 does not indicate any value for Oracle > 8.0.6.

Does that mean I just need to reset the value of the parameter?

--> alter system reset log_checkpoint_timeout scope=spfile sid='*';

(2) shared_pool_reserved_size

How do we know what value to set? OSS Note 0124361 only reflects Shared_Pool_Size value. Does that mean it is automatically determined by Shared_Pool_Size?

[former_member204746 · Accepted solution]

follow SAP note 124361 and ignore earlywatch alerts.

log_checkpoint_timout, and shared_pool_reserved_size :

take both out of initSID.ora