Re: How does Oracle know if a program has crashed, so it can rollback?

On 8 Jun 2005 11:04:43 -0700, "deanbrown3d" <deanbrown3d_at_yahoo.com> wrote:

>Can anyone say a few words to a beginner on how Oracle server knows
>when a program or OS has crashed, so that it can free a resource for
>someone else?
>
>The simple example I have is in SQLPlus spreadsheet, if I insert a
>record into a table A, and don't commit, then no-one else can perform
>certain operations (such as truncate in this example) until the commit
>is performed, OR until that program (SQLPlus is terminated, or the OS
>is restarted. Are Oracle and the program sending periodic messages to
>each other to say "I'm still alive"?
>
>Many thanks,
>
>Dean

They are.
Also Oracle has a process called PMON to monitor running processes within Oracle.
Probably a good moment to start reading the Oracle Concepts manual (online at http://tahiti.oracle.com ) now, as it explains the basic architecture.

--
Sybrand Bakker, Senior Oracle DBA