Home » RDBMS Server » Server Utilities » Re: Oracle problem
Re: Oracle problem [message #71149] Mon, 16 September 2002 02:12
Abdullah Gilani
Messages: 18
Registered: October 2001
Junior Member
hi appajiy,
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.

Regards,
Abdullah Gilani
syedgilani@hotmail.com
Previous Topic: Copy tables procedure
Next Topic: Converting the character set of a database from WE8ISO8859P1
Goto Forum:
  


Current Time: Sat May 04 04:55:29 CDT 2024