Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: V$SYSTEM_WAIT_CLASS

Re: V$SYSTEM_WAIT_CLASS

From: <sybrandb_at_hccnet.nl>
Date: Tue, 14 Aug 2007 07:30:14 +0200
Message-ID: <4cf2c39qa8e121v7k7hd3jfum3auaf5n28@4ax.com>


On Mon, 13 Aug 2007 21:16:17 -0700, dean <deanbrown3d_at_yahoo.com> 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.

Consider there is redolog, which is always written *before* the data files are written.
Consider these redologs are multiplexed and on mirrored drives. So how likely is the fairy tale you describe above. Consider you are in dire need to revise your policy of not reading any manual.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Tue Aug 14 2007 - 00:30:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US