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

4 votes127 views2 answers
Oracle drop job
SQL
0 vote130 views1 answer
Grant privileges mysql to database 1064
SQL
4 votes130 views1 answer
Mac install mysql
SQL
0 vote131 views1 answer
Sub query in linq
SQL
1 vote128 views2 answers
Sql convert datetime to year month
SQL
0 vote137 views1 answer
Select insert new table sql server
SQL
11 votes200 views1 answer
Oracle insert from select
SQL
0 vote128 views1 answer
PostgreSQL types and C# types
SQL
0 vote121 views1 answer
Insert or update sql query
SQL
0 vote122 views4 answers
Best data type to represent money in mysql
SQL