A strange variant of ORA-02391.

From: Dexter <vikram_ramakrishnan_at_ieee.org>
Date: 12 Jan 2005 01:52:36 -0800
Message-ID: <1105523556.548305.79880@c13g2000cwb.googlegroups.com>

Hi,

I have a program that runs daily and merges two tables in different DBs using DB links.
This program SOMETIMES errors out saying..

DBD::Oracle::db do failed: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
ORA-02063: preceding line from DW_TO_AD (DBD ERROR: OCIStmtExecute) [for Statement

The "SESSIONS_PER_USER" limit is set to "UNLIMITED" for this user and the maximum allowed sessions for this DB is 350. I could see that the total session at the time this error happended was 104.

What could be causing this problem?
Pls. share your thoughts on this.

-Dexter. Received on Wed Jan 12 2005 - 03:52:36 CST