Oracle archivelog usage

WITH hours AS (
    SELECT trunc(sysdate) + ((LEVEL - 1) / 24) AS HOURS
    FROM DUAL
    CONNECT BY LEVEL < = 24
)
SELECT h.HOURS AS DATE_HOUR,
    round(sum(BLOCKS * BLOCK_SIZE) / 1e9, 2) SIZE_GB
FROM hours h
    LEFT OUTER JOIN V$ARCHIVED_LOG al ON h.HOURS = trunc(al.FIRST_TIME, 'HH24')
GROUP BY h.HOURS
ORDER BY h.HOURS;

Similar codes

7 votes112 views2 answers
Execute mysql file
SQL
1 vote94 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote137 views1 answer
Mysql where sum > 0
SQL
0 vote110 views1 answer
Search mysql database for column
SQL
1 vote125 views1 answer
Postgres power
SQL
0 vote113 views1 answer
SQL authentication error
SQL
10 votes108 views2 answers
Sql pagination offset
SQL
11 votes119 views2 answers
How to import mysql database command line
SQL
5 votes116 views1 answer
Get column name sql server
SQL
1 vote103 views1 answer
Display total number of tables in mysql
SQL