Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Instance , what instance.
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote
> Here's an amusing little test you might like to try.
<snipped>
> From operating system:
> kill -9 pmon, dbwr, ckpt, smon etc, in order of PID.
What did a 'ps -ef | grep ora' showed afterwards?
Twisted logic (is there anything else?) says that if the system processes are dead, the local ones will no longer work. Session 3 should be hanging.. right? For it to access (some?) virtual views seem to imply that these are either kept locally within that process (does not make sense), or that some shareable memory are still available and accessible.. but then who is doing the writing to file 1? Who is that local process talking to? Who the hell really killed JFK!?
Er.. is there a detective in the house? ;-)
-- Billy PS. You've caused me to think and made my head hurt, damn it man! PPS. Do you think it is too early for my 3rd cup of coffee?Received on Tue Aug 14 2001 - 01:25:26 CDT