You can list the number of archivelogs generated this way:
SELECT trunc(COMPLETION_TIME,'DDD') DAY, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB, COUNT(*) "NB_Files" FROM V$ARCHIVED_LOG GROUP BY trunc (COMPLETION_TIME,'DDD') ORDER BY 1;
List blocking sessions
Below is a query that list all the blocking sessions in an oracle instance
Lire la suite!