Check Redo Log Size

SELECT

    l.GROUP#,

    l.THREAD#,

    l.SEQUENCE#,

    l.ARCHIVED,

    l.STATUS,

    lf.MEMBER    AS REDOLOG_FILE_NAME,

    (l.BYTES/1024/1024) AS SIZE_MB

FROM v$log l

JOIN v$logfile lf ON l.Group#=lf.Group#

ORDER BY l.GROUP# ASC;


Output:

GROUP#

THREAD#

SEQUENCE#

ARCHIVED

STATUS

REDOLOG_FILE_NAME

SIZE_MB

1

1

18194

YES

INACTIVE

=+DATA/rep_db/onlinelog/group_1.282.636829083

400

1

1

18194

YES

INACTIVE

=+RECOVER/rep_db/onlinelog/group_1.677.636829089

400

2

1

18197

YES

INACTIVE

=+DATA/rep_db/onlinelog/group_2.283.636829095

400

2

1

18197

YES

INACTIVE

=+RECOVER/rep_db/onlinelog/group_2.678.636829101

400

3

1

18198

NO

CURRENT

=+RECOVER/rep_db/onlinelog/group_3.679.636829113

400

3

1

18198

NO

CURRENT

=+DATA/rep_db/onlinelog/group_3.274.636829107

400

4

1

18195

YES

INACTIVE

=+DATA/rep_db/onlinelog/group_4.295.641817961

400

4

1

18195

YES

INACTIVE

=+RECOVER/rep_db/onlinelog/group_4.620.641817975

400

5

1

18196

YES

INACTIVE

=+RECOVER/rep_db/onlinelog/group_5.619.641818021

400

5

1

18196

YES

INACTIVE

=+DATA/rep_db/onlinelog/group_5.304.641818009

400


Comments