Hello DBA Experts,Can you please explain how below statement will work?sqlplus -prelim / as sysdba
Thanks in Advance!
Prelim option is used as a last resort when you cannot login to the database (usually in a hang situation). It will not allow you to perform any activities apart from the ORADEBUG command through which you gather either hanganalyze or systemstate dump. The way prelim works is my having oracle start a process and this new process attaches to the shared memory segments of the SGA. However, there are no process or session state objects that get created due to which you will not be able to query any views or query any tables as we aren't logged on as such. This option is basically to gather traces for hanganalyze or systemstate dump for diagnostic purposes.
Sign up for STechies