Re: Diff. between Redo Log Allocation Latch and Redo Log Copy Latch

I got the info.

Redo Copy latch
The redo copy latch is acquired for the whole duration of the process described above. The init.ora LOG_SIMULTANEOUS_COPIES determines the number of redo copy latches. It is only released when a log switch is generated to release free space and re-acquired once the log switch ends.
Redo allocation latch
The redo allocation latch is acquired to allocate memory space in the log buffer. Before Oracle9.2, the redo allocation latch is unique and thus serializes the writing of entries to the log buffer cache of the SGA. In Oracle 9.2. Entreprise Edition, the number of redo allocation latches is determined by init.ora LOG_PARALLELISM. The redo allocation latch allocates space in the log buffer cache for each transaction entry. If transactions are small, or if there is only one CPU on the server, then the redo allocation latch also copies the transaction data into the log buffer cache. If a logswitch is needed to get free space this latch is released as well with the redo copy latch.

wagen123_at_yahoo.com wrote:
> Hi,
>
> Can someone explain the Diff. between Redo Log Allocation Latch and
> Redo Log Copy Latch.
>
> Thanks in advance.
Received on Thu Dec 30 2004 - 11:50:28 CST