Re: ORA-00018 issues
- From: Maureen English <sxmte@xxxxxxxxxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxx
- Date: Thu, 26 Feb 2009 10:27:01 -0900
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
