In standard Oracle databases are operated 24x7 without having the will need of executing normal administrative chores.
QueryAdvisor is a universal tool for Monitoring Oracle Table Performance supporting the database administrators. A free of charge community version is available.