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

1 vote152 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote155 views1 answer
Create or replace view postgress
SQL
3 votes137 views3 answers
Concatenation in sql
SQL
0 vote153 views2 answers
Sql update top 100
SQL
6 votes150 views1 answer
Sqlite foreign key
SQL
8 votes205 views1 answer
Insert a select statement into a table
SQL
1 vote165 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote158 views1 answer
How to check common records in 2 table
SQL
0 vote146 views3 answers
Sql all columns
SQL
4 votes171 views3 answers
NOT NULL SQL
SQL