Re: Cache Management on Storage Box

I assume that write behind means that when the write I/O request gets to the controller cache the controller returns ok to the computer and then write the data to the disk in its own time, like DASD fast write on the mainframe.

If this assumption is wrong don't read any more.

I think that it all depends on battery backed for the memory on the controller.
If the controller cache memory have a battery backup you will get faster response time with write behind and the battery assure you that in case of power failure you will not lose data.

If you do not have battery backup DO NOT use write behind as you will lose the data in case of power failure.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, September 23, 2002 6:53 PM

Cache Management on Storage Box :-

Qs Which is Better ? Write-Behind OR AUTO & Advantages of Each ?

Any Docs , Links on the Same ?

NOTE - Application is a Banking Product - Hybrid in Nature i.e. both OLTP & Batch Processing Operations Exist

Qs When Configured to AUTO is there an Overhead Within when Switching between Write-Behind
& Write-Through Modes ?

NOTE - Database in particular Exists on T3 Model SUN Storage Box . T3 Supports Hardware RAID & In-built Write-Behind Cache Management

Solaris 8
Oracle 8.1.7

Thanks

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).