ExecMan wrote:
> Hi,
>
> I've just taken over a database. The database has 28 rollback
> segments. And, to my astonishment, these guys are not running their
> production database in archive log mode.
>
> Short term fix is to put it in archive log mode. but, I'm wondering if
> there is any way to estimate how large the archive log files will be,
> or, how often they will be created based on the number of wraps the
> rollback segments have........
>
> John
Try the following, assuming that the existing redo log files are
sufficiently large enough to provide a couple hours (or even days) of
history, and that you are not forcing log file switches on a regular
interval (not likely in your case):
SELECT
L.GROUP# GROUP_NUMBER,
LF.MEMBER FILENAME,
L.STATUS,
L.ARCHIVED,
L.BYTES,
L.FIRST_CHANGE#,
L.FIRST_TIME
FROM
V$LOG L,
V$LOGFILE LF
WHERE
LF.GROUP#=L.GROUP#
ORDER BY
L.GROUP#;
Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.
Received on Fri Dec 08 2006 - 04:01:01 CST
