oracle參數(shù)查看和修改方法:
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;
|----------------------------------------------------------------------------------------|
版權(quán)聲明 版權(quán)所有 @zhyiwww
引用請(qǐng)注明來(lái)源 http://www.aygfsteel.com/zhyiwww
|----------------------------------------------------------------------------------------|