Re: READ-ONLY Tables and Views
Date: 1996/01/30
Message-ID: <4ek1fb$akm_at_inet-nntp-gw-1.us.oracle.com>#1/1
"Eduardo Díaz" <ediaz_at_dgf.uchile.cl> wrote:
>When a Tablespace is read only, what's about the performance?
>Thanks
>Eduardo Diaz
The performance of the read only tablespace = the performance of the medium it is stored on.
A read only tablespace works no faster/slower then a regular tablespace..
Main benefit of read only tablespace is when used in conjunction with WORM or slow devices. Normally, upon startup/checkpoint, datafile headers are updated. If a tablespace is RO, then this does not take place. Startup/checkpoint is sppeded up for RO tablespaces, especially when the underlying medium either does not allow writes or it very slow.
Read the Server doc addendum (for 7.1) for further information.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Received on Tue Jan 30 1996 - 00:00:00 CET