The "Vimal Mohan" Blog

Oracle, Unix basics & tricks for all those interested in discovering…

Posts Tagged ‘hung’

A backdoor entry to the Oracle Instance

Posted by Vimal Mohan on December 7, 2010

Many of us are not aware of an option in SQL Plus, “-prelim”. This backdoor entry to the instance, connects us to the SGA, but doesn’t open a session. Such a backdoor entry allows us to reach the instance when there is a total freeze [if the number of sessions max’d out or if there is is hung situation (ie: when sysdba connections are also hanging)].

sqlplus -prelim


Posted in Oracle | Tagged: , , , , , , | Leave a Comment »