Answers for "oracle logs"

SQL

2

oracle log files

SELECT l.THREAD#, lf.GROUP#, lf.MEMBER,
       trunc(l.BYTES / 1e6) AS SIZE_MB,
       l.STATUS, l.ARCHIVED, lf.TYPE,
       lf.IS_RECOVERY_DEST_FILE AS RDF,
       l.SEQUENCE#, l.FIRST_CHANGE#,
       l.NEXT_CHANGE#
FROM V$LOGFILE lf JOIN V$LOG l ON l.GROUP# = lf.GROUP#
ORDER BY l.THREAD#, lf.GROUP#, lf.MEMBER;

Posted by: Guest on September-01-2021

Source

Code answers related to "oracle logs"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#