Query to check history of SQL from AWR

Find Tablespace Growth History In Oracle

Oracle jobs to start and stop

Find oracle shared pool usage

Oracle table statistics via the operating system crontab

Oracle database for long running queries

Compile in Oracle Invalid Objects

Oracle Dataguard DGMGRL Commands

Find oracle alertlog Errors With SQL Query

Enable Oracle Listener Trace to the detailed log Information