prelim connection

From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Tue, 30 Oct 2007 16:26:15 -0700
Message-ID: <4727BD97.8020109@ora-600.net>

I just started a blog to track some of my hacking around in 11g.

My first post is on a little known feature of SQL*Plus, actually introduced in 10g, called the 'prelim' connection. Prelim allows you to connect to an Oracle instance's SGA without allocating a session. This is very handy when you are dealing with a completely hung instance that is no longer accepting logins, even as SYSDBA.

http://oradeblog.blogspot.com

Thanks,

Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net

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

Received on Tue Oct 30 2007 - 18:26:15 CDT