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

work on autovacuum postgreSQL parameter

 In This blog, we are discussing the auto vacuum parameter on a small scale. we will understand the below parameters and will see how to mod...