Re: ORA-00018 issues

From: Maureen English <sxmte_at_email.alaska.edu>
Date: Thu, 26 Feb 2009 10:27:01 -0900
Message-ID: <49A6ED05.6070605_at_email.alaska.edu>

processes has been set to 300, sessions is at 335, though we should let Oracle determine this value instead of actually setting it.

select count(*) from v$session results in 16 and the highwater mark for sessions is 64...far below 335.

That's what's so confusing...the number of actual sessions has never come close to the maximum value.

Still testing the 'starting over' scenario....

Thanks,

• Maureen

Bobak, Mark wrote:
> Simple test:
>
> Reboot box, get back to ground zero.
> Now, login, do:
> Show parameter sessions
> Select count(*) from v$session;
>
>
> Do not give up your established connection!
> Now, have the consultant login/attempt to login.
>
> If he gets the error, repeat the two commands above:
> Show parameter sessions
> Select count(*) from v$session;
>
>
> Compare the results. I'd expect the value of sessions is not going to change. (I'm pretty sure it can't chance w/o a bounce.) However, I'd be interested to know what difference you see in the count(*) from v$session query results.
>
> -Mark
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 26 2009 - 13:27:01 CST