Home » RDBMS Server » Server Administration » Re: Oracle problems
Re: Oracle problems [message #51891] Thu, 20 June 2002 01:15
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: Adding Runtime Text Item
Next Topic: maximum records can be held in a cursor
Goto Forum:
  


Current Time: Tue Sep 17 20:33:25 CDT 2024