Category Archives: oracle

Setting Oracle Parameters: processes, sessions, open_cursors

Posted on April 9, 2009 by Jianming Li

Processes SQL> show parameter processes; NAME TYPE VALUE ———————————— ———– ——– processes integer 1000 SQL> select count(*) from v$process; COUNT(*) ———- 20 Sessions Sessions = (Processes * 1.1) + 5 SQL> SHOW parameter sessions; NAME TYPE VALUE ———————————— ———– ——– … Continue reading →

Posted in oracle | Leave a comment