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

From: deanbrown3d <deanbrown3d_at_yahoo.com>
Date: 8 Jun 2005 11:04:43 -0700
Message-ID: <1118253883.869035.151200@g44g2000cwa.googlegroups.com>

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 Received on Wed Jun 08 2005 - 13:04:43 CDT