increase the no. of sessions

[anandkl]

i want to increase the no of session for my database..
How do i do it...

regards
anandkl

[ggnanaraj]

Increase the value of processes in your parameter file.

This will increase your sessions as will be evident with the show paramter.

sessions = (1.1 * PROCESSES) + 5

HTH



[Edited by ggnanaraj on 07-22-2002 at 05:31 AM]

[anandkl]

thanks nagaraj..one more question

how do i know the database is approching max sessions..

regards
anandkl

[soniaarora]

U can do count(*) in the v$session table to know the number of sessions

[SANJAY_G]

SELECT SESSIONS_HIGHWATER FROM V$LICENSE;

Sanjay