Board index Oracle

log buffer space vs. redo log space requests

log buffer space vs. redo log space requests

Post by Scott Watso » Thu, 31 May 2001 23:34:22



I am a little confused as to the values I am getting from these two
statistics.

log buffer space in V$SYSTEM_EVENT shows a value for waits which leads me to
believe that the log buffer is not large enough however the redo log space
requests from V$SYSSTAT shows a value of zero.

Therefore one stat tells me there is not enough space while the other tells
me everything is ok.  I think I am misinterpreting these statistics.  Can
someone set me straight.

Oracle 8.1.6 running on solaris.

thanks,
Scott.

 
 
 
Top

1. Determining space usage in redo log buffer

Hi,

Does anyone know of a method to determine how much space is
being used in the redo log buffer at a point in time?

Similarly, for the current redo log group.

thanks,
Nigel

2. Example of ADO connection with ORACLE 7 et 8

3. Contention for Space in the Redo Log Buffer

4. Documentation for Pulling Data from Sybase

5. Recapturing disk space from the transaction log after truncating the log space

6. Need Help With Formatting Text

7. data space vs. log space in 6.5

8. Records Will Not Delete

9. Redo Log Space ??

10. Dump database is not returning any data space or log space

11. after truncate log, log space avail is still 0

12. Mass Delete - Log Entries Kills Available Log Space

13. trancate log and shrink datafile doesn't work to reclaim transaction log space


All times are UTC
Board index