oracle參數查看和修改方法：
root#sqlplus sys@orcl as sysdba
SQL>show parameter spfile;
SQL>show parameter pfile;
SQL>show parameter sessions;
SQL>show parameter transaction;
SQL>show parameter processes;
SQL>alter system set processes=500 scope=spfile;
SQL>alter system set sessions=1000 scope=spfile;
SQL>shutdown immediate;
SQL>startup;



|----------------------------------------------------------------------------------------|
                           版權聲明  版權所有 @zhyiwww
            引用請注明來源 http://www.aygfsteel.com/zhyiwww   
|----------------------------------------------------------------------------------------|