Size of Oracle Database

Read More

Display the columns related to redaction in Oracle 12c

Read More

Number of archived redo by day

SELECT TRUNC(first_time) AS day, ROUND(SUM(blocks * block_size)/1024/1024/1024,2) size_gb FROM v$archived_log WHERE TRUNC(first_time) >= TRUNC(SYSDATE) – &1 GROUP BY TRUNC(first_time) ORDER BY TRUNC(first_time);

Read More

Shows differences in table structures

Read More

Query shows clients connected to all the Flex ASM instances

Read More

Displays contents of the registry history

Read More

Top Sql in Exadata

Read More

Show Exadata cell versions

Read More