Saturday, 15 June 2019

WARNING OGG-02045 DB does not have streams_pool_size initialization parameter.


WARNING:

2019-06-15 06:40:03  WARNING OGG-02045  Database does not have streams_pool_size initialization
 parameter configured.

Solution :

set streams_pool_size:

SQL> show parameter streams_pool_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size                    big integer 0

---set paramter as per the system: 

SQL> alter system set streams_pool_size=1G scope=spfile;   

System altered.


No comments:

Post a Comment

kernel:watchdog: BUG: soft lockup - CPU#0 stuck for 22s! [sh:57366]

 Error:   kernel:watchdog: BUG: soft lockup - CPU#0 stuck for 22s! [sh:57366] Solution:  server1:~ # echo 20 > /proc/sys/kernel/watchdog_...