Oracle limit on simultaneous connections per user

Question

I want to connect Oracle DB with same user several time at the same time on java app. Is there any limitations? I want to connect db and read bulk data from same user.

Answer 1

In general there are not unless there is a limit specifically configured through the user profile, which can limit sessions_per_user.

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6010.htm

Answer 2

The number of sessions is limited by the "sessions" configuration parameter of the database instance. According to the Oracle documentation the default value is (1.5 * PROCESSES) + 22.

See also http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams232.htm#REFRN10197

Other related parameters are "processes" and "transactions".

In general it's not a problem to open several connection in an application to the same database user/schema at the same time. This is what application servers like JBoss are doing all the time.