Re: V$SYSTEM_WAIT

From: Paul Linehan <plinehan__A_at_T__yahoo__D.OT__COM>
Date: Fri, 17 Aug 2007 17:41:34 GMT
Message-ID: <i5lxi.21594$j7.396508@news.indigo.ie>

dean wrote:

> I've read to the contrary several times. Consider what would happen if
> Oracle thought it saved a change to disk, and then there was a power
> failure before the cache was written to disk? It would then be in a
> corrupt state.

That's what things like UPS's are for, as well as a battery for the cache.

Oracle says "write" and the OS reports back "written" - its not up to Oracle to determine the nature of the "written" - it could be stone tablets for all Oracle cares.

Paul... Received on Fri Aug 17 2007 - 12:41:34 CDT

Re: V$SYSTEM_WAIT_CLASS