Home » RDBMS Server » Server Utilities » Re: Oracle problem
Re: Oracle problem [message #70485] Wed, 19 June 2002 23:48
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
Previous Topic: What am I missing
Next Topic: SQLLoading with Comma Delimiter and Quoted Strings
Goto Forum:
  


Current Time: Mon Apr 29 05:06:03 CDT 2024