Home » RDBMS Server » Server Administration » regarding SESSION parameter (Oracle 10.2, AIX 5.3)
regarding SESSION parameter [message #407079] Mon, 08 June 2009 06:34 Go to next message
rumman
Messages: 48
Registered: June 2007
Location: Bangladesh
Member
I am going to increase the SESSION parameter of the database from 720 to 1200.
Is there any chance that it makes any problem in the database?
Do I need to increase the process parameter as well with this?
Any suggestion please.
Re: regarding SESSION parameter [message #407084 is a reply to message #407079] Mon, 08 June 2009 06:50 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://oracle.basisconsultant.com/oracle_tuning_parameters.htm

This will help you

Sriram
Re: regarding SESSION parameter [message #407117 is a reply to message #407079] Mon, 08 June 2009 09:22 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>Is there any chance that it makes any problem in the database?
Depends upon your definition of problem.
The database may be prevented from STARTUP due to lack of OS resources.
Re: regarding SESSION parameter [message #408009 is a reply to message #407079] Fri, 12 June 2009 23:26 Go to previous message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
rumman wrote on Mon, 08 June 2009 18:34
I am going to increase the SESSION parameter of the database from 720 to 1200.
Is there any chance that it makes any problem in the database?
Do I need to increase the process parameter as well with this?
Any suggestion please.


1. You should follow BlackSwan's guide, it's most important to measure that how about enough session/process in your Database.

2. Oracle recommends:
Session:=(1.1*Processes)+5 

than, you've got 700 sessions, and your processes in DB is about 631.

Regard!
Previous Topic: ORA-03134: Connections to this server version are no longer supported.
Next Topic: Ora-03113 End of file on communication channel
Goto Forum:
  


Current Time: Wed Dec 07 07:01:26 CST 2016

Total time taken to generate the page: 0.08141 seconds