Re: too many session open and you can't log in?

make sure you add "oradebug call ksmcpg" as per note *417879.1 if applicable.

rjamya
*
On 3/16/07, A. Coskan Gundogar <gundogar_at_gmail.com> wrote:
>
> If you are on 10G and you cant log in with "sqlplus / as sysdba" you
> can try the -prelim option
> it is a 'lightweight' session, you cant execute a sql command but take a
> system state dump
>
> sqlplus -prelim / as sysdba
> oradebug setmypid
> oradebug unlimit;
> oradebug dump systemstate 10
>
> for more info
>
> http://el-caro.blogspot.com/search/label/systemstate%20dump
> http://www.dbasupport.com/oracle/ora10g/crisis.shtml
>
>

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