Hi everybody,
In Oracle I wanna know the current capacity of a log group, so I will know/estimate when it will be switched. For example, I have three log groups 1, 2 and 3, each log group has only 1 member of size 10MB. So I want to check how full the current log group is? 1MB, 3MB or 7MB... When it's 9MB I know it's going to switch.
But currently I can't find the solution. I see the LAST_REDO_BLOCK in v$thread. v$thread presents status of current log group. When I do 'alter system switch logfile', LAST_REDO_BLOCK resets to 0 and increase slowly. I try to create table and insert multi rows, and LAST_REDO_BLOCK increase fast. So anybody can tell me if LAST_REDO_BLOCK is the current number of blocks in the current log group, and I can calculate the current size of a log group? If not, any possible solutions?
Sorry for my bad English and thank you for reading.