I just copied from oracle forum to keep it here as well for reference. Here is the original https://forums.oracle.com/ords/apexds/post/oracle-dba-daily-weekly-monthly-or-quarterly-checklist-task-9948 Daily Activity Oracle Database instance is running or not Database Listener is running or not. Check any session blocking the other session Check the alert log for an error Check is there any dbms jobs running & check the status of the same Check the Top session using more Physical I/O Check the number of log switch per hour How_much_redo_generated_per_hour.sql Run the statpack report Detect lock objects Check the SQL query consuming lot of resources. Check the usage of SGA Display database sessions using rollback segments State of all the…