-
1. SQL Plus SQL> set linesize 300 SQL> set pagesize 100 종료시에 초기화된다. 2. glogin.sql set linesize 300 set pagesize 100 OraHome/sqlplus/admin/glogin.sql 영구적으로 설정
SQL> show parameter open_cursors; SQL> alter system set open_cursors=500 scope=spfile; SQL> alter system register; SQL> conn / as sysdba; SQL> shutdown immediate; SQL> startup;
SQL> show parameter processes; SQL> alter system set processes=500 scope=spfile; SQL> alter system register; SQL> conn / as sysdba; SQL> shutdown immediate; SQL> startup;