Sql

Search

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;

Comment

PREVIOUS	NEXT

Code Example
Sql :: wildcard in sql
Sql :: SELECT exists sql
Sql :: how to run mysql on terminal mac
Sql :: install mysql 5.7
Sql :: referential integrity constraint
Sql :: mysql current time
Sql :: select milliseconds mysql
Sql :: joomla execute raw sql
Sql :: temp table vs variable table in sql server
Sql :: sql find duplicate records in two tables
Sql :: postgres select as csv
Sql :: how to select one row in mysql
Sql :: how to extract only year and month from date in sql
Sql :: t-sql create trigger
Sql :: ascending order and where in sql
Sql :: oracle difference between two dates in years
Sql :: postgresql Create a new role with a username and password
Sql :: show column names in sql table
Sql :: test the postgresql db connection
Sql :: if in mysql
Sql :: sql extract from mail
Sql :: for json path sql server
Sql :: python uuid sqlalchemy
Sql :: Write an SQL query to print details of the Workers who have joined in Feb’2014
Sql :: if column value is null then in mysql
Sql :: mysql 8 geo to json
Sql :: drop CHECK constraint sql
Sql :: how to find special characters in sql
Sql :: postgres integer to serial
Sql :: mysql dump with table query

Search

SQL

oracle log files

ADD CONTENT