Thursday, November 10, 2016

Post DB Installation Tasks :

Post Installation Tasks : sqlplus "/as sysdba" SQL> alter system set session_cached_cursors=100 scope=spfile; System altered. SQL> SQL> alter system set processes=500 scope=spfile; System altered. SQL> SQL> alter system set aq_tm_processes=1 scope=both; System altered. SQL> alter system set db_cache_size=150994944 scope=both System altered. SQL> alter system set java_pool_size=125829120 scope=both; System altered. SQL> alter system set shared_pool_size=183500800 scope=both; System altered. SQL> alter system set open_cursors=800 scope=both; System altered.

No comments:

Post a Comment