How to increase no. of sessions in oracle database?

If you are increasing sessions parameter you should consider increasing processes and transactions parameter as well.

Here is the formula you can use to determine their values.

processes=x
sessions=x*1.1+5
transactions=sessions*1.1

E.g.

processes=500
sessions=555
transactions=610

Commands:-
sqlplus "/as sysdba"
or
sqlplus '/as sysdba'


show parameter sessions;
show parameter processes;
show parameter transactions;
alter system set processes=500 SCOPE=SPFILE; 
alter system set sessions=555 SCOPE=SPFILE; 
alter system set transactions=610 SCOPE=SPFILE; 

and restart the database.

Settings for higher performance:-

alter system set open_cursors=1500 scope=both;
alter system set processes=3000 scope=spfile;
alter system set undo_retention=10800 scope=both;
alter system set max_shared_servers=50 scope=both;
alter system set db_files=2000 scope=spfile; 
alter system set sessions=3305 SCOPE=SPFILE;  
alter system set transactions=3635 SCOPE=SPFILE; 

If you facing below issue while doing alter system
SQL> ALTER SYSTEM SET memory_target = 0 SCOPE=SPFILE;
ALTER SYSTEM SET memory_target = 0 SCOPE=SPFILE
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use

then perform 'CREATE SPFILE FROM PFILE' to create a SPFILE and do restart the database.

How to get the list of all users in Oracle Database?

1. Connect to sql using 'sqlplus / as sysdba'

2. Execute 'Select * from all_users;' to display all users in Oracle db.

Weblogic - MBean

Creation of MBean and register them with Weblogic server
http://blogs.oracle.com/WebLogicServer/2009/10/developing_custom_mbeans_to_ma.html


Modification of default attribute and parameter descriptions to custom info.
http://blogs.oracle.com/WebLogicServer/2009/11/developing_custom_mbeans_to_manage_j2ee_applications_part_ii.html


Localizing MBean's attribute and parameter description
http://blogs.oracle.com/WebLogicServer/2010/03/developing_custom_mbeans_to_ma_1.html

BPEL Useful links

Home Page

Sample code

Much more info

http://apps2fusion.com/at/gt/tc/252-what-is-oracle-bpel-for-developer-perspective

http://www.codeguru.com/cpp/sample_chapter/article.php/c10789/Oracle-BPEL-Process-Manager.htm

Webservices Useful links

http://java.sun.com/developer/technicalArticles/WebServices/jaxb/ - About JAXB API
http://en.wikipedia.org/wiki/Web_service - Basic Information
http://java.sun.com/javaee/technologies/webservices/ - Java Webservice Specification
http://www.roseindia.net/webservices/ - Webservices tutorial

Thomson Prometric Testing Centres, Hyderabad

PROMETRIC TESTING (P) LTD HYDERABAD, Andhra Pradesh 500034 Phone: 4023303903 Site Code: II001	AVENUE 1 STREET 20, ABOVE SBI PLOT 1672 ROAD 12 BANJARA HILLS
Telesis Technologies P Ltd. Hyderabad, Andhra Pradesh 500020 Phone: 27666894 Site Code: II412	1-1-162, III floor, Crystal building RTC X Raods Opp Big Bazaar
NIIT Ltd. Hyderabad, Andhra Pradesh 500063 Phone: 66622249 Site Code: IIC	2nd Floor Prashanti Complex Opp. to Old Gandhi Medical College Basheerbagh
CMS Info Systems Private Limited Hyderabad, Andhra Pradesh 500003 Phone: 40100088 Site Code: IIH50	CMS COMPUTERS LTD #19,2ND FLOOR,HARDY COMPLEX OPP.CHERMAS,M.G.ROAD, Paradise,Secunderabad
NIIT Ltd.-Ameerpet Hyderabad, Arunachal Pradesh 500016 Phone: 66747792 Site Code: IIN36	4th Floor Pavan Vanijya Vihar Beside R S Brothers Above Srikrishna Sweets
KARROX TECHNOLOGIES LTD Hyderabad, Andhra Pradesh 500016 Phone: 66625561 Site Code: II449	6-3-788/A/10 Opp. Lane Chandana Bros Durganagar Colony Ameerpet
HCL Infosystems Limited Hyderabad, Andhra Pradesh 500003 Phone: 27890520 Site Code: II582	503-504,5th Floor Minerva Complex S D Road Near Park Lane

Steps to Increase ulimit

Steps to Increase ulimit for RedHat Linux

for more info about ulimit:- http://uw713doc.sco.com/en/man/html.1/ulimit.1.html

Add below line to /etc/profile
ulimit -n 10000

Add below lines to /etc/security/limits.conf
GUID  hard    nofile  10000
GUID  hard    nofile  10000

& Restart the system.