Re: A strange variant of ORA-02391.

Dexter wrote:

> 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.

No version number.
No code.
No idea.

But why did you seemingly reinvent the wheel?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---