How to solve Oracle Database Error 832 (ora-00832)

Oracle Error Code
   ora-00832

Description
   no streams pool created and cannot automatically create one

Cause
   A database feature which needs STREAMS SGA was being used, however, the streams_pool_size parameter was not defined and the value of db_cache_size was too small to permit an automatic transfer of SGA to the streams pool from the buffer cache.
How to Solve
   Please set the parameter streams_pool_size or set sga_target.

Do you have question or do you know about solution ?

Share with us. (No registration required)
  
Your Name
Question, comment or solution
Similar Errors
  ORA-00740    ORA-00741    ORA-00750    ORA-00832    ORA-00900    ORA-00901    ORA-00902  Others

Main Page      Contact Us      Tools & Softwares      Server Monitoring Softwares