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 votes280 views1 answer
Mysql store ip address
SQL
0 vote243 views1 answer
Sql delete caracter list
SQL
1 vote185 views1 answer
Postgres convert date to string
SQL
0 vote171 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote183 views1 answer
Less than and between in sql query
SQL
0 vote143 views1 answer
Import sql file in mysql linux
SQL
0 vote169 views1 answer
Sql string length postgresql
SQL
1 vote179 views10 answers
Stack overflow
SQL
0 vote177 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote195 views1 answer
Sql put two columns into one
SQL