| Re: How to fix ORA-00018 maximum number of sessions exceeded [message #20780] |
Wed, 19 June 2002 23:11 |
Abdullah Gilani
Messages: 18
Registered: October 2001
|
Junior Member |
|
|
hi,
SQL> alter system set license_max_sessions = 200;
If you want permanant solution, you have to change in initialization parameter file(init.ora).
File name is : init.ora
Parameter are:
processes = 400
sessions = 450
# or increase as yours requirement and fine tune it according to perfomance of your hardware.
Note: For apply these changes in init.ora file you Must be Restart Oracle Instance.
Thanks,
Abdullah Gilani
syedgilani@hotmail.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
