IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
I got ” ORA-02097: parameter cannot be modified because specified value is invalid. ORA-04033: Insufficient memory to grow pool ” error in Oracle database.
ORA-21780: Maximum number of object durations exceeded
Details of error are as follows.
SQL> show parameter streams_pool_size NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ streams_pool_size big integer 15G SQL> SQL> alter system set streams_pool_size=20G scope=both sid='*'; alter system set streams_pool_size=20G scope=both sid='*' * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-04033: Insufficient memory to grow pool SQL> ORA-04033: Insufficient memory to grow pool Cause: The system had insufficient memory to grow the pool to the specified size. Action: Specify a smaller value to grow the pool.
Check your Physical RAM and SGA Max size value, then Specify a smaller value to grow the pool.
[root@msdbadm01 ~]# free -g total used free shared buff/cache available Mem: 256 160 96 0 3 2 Swap: 65 2 63 [root@msdbadm01 ~]# SQL> show parameter sga_max_size; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sga_max_size big integer 100G SQL>
To solve this error, Specify a smaller value to grow the pool.
SQL> alter system set streams_pool_size =10000M scope=both sid='*'; System altered. SQL> show parameter streams_pool_size; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ streams_pool_size big integer 10000M SQL>
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
