Tuning Check list

1. 1.        Check the database status
2. 2.        Check listener status
3. 3.        Check alert log files
4. 4.       Check listener log file
5. 5.       Make sure the connections are going fine in the listener log file.
6. 6.       Check the space in /var directory and check any file system reached 100%
7. 7.       CPU utilization
8. 8.       Memory details
9. 9.       Any indexes are in UNUSABLE state
10. 10.   Locked objects
11. 11.   Invalid objects
12. 12.   Blocking sessions
13. 13.   Identify database idle sessions
14. 14.   Any errors in alert log
15. 15.   UNUSABLE indexes
16. 16.   Max sessions reached/process reached/ Check the status and no of connections present in the database
17. 17.   Outstanding alerts
18. 18.   Check the last analyzed date
19. 19.   FRA utilization
20. 20.   Long running queries
21. 21.   List Of Users Currently Waiting
22. 22.   Top CPU Consuming SQL During A Certain Time Period
23. 23.   Which Database Objects Experienced the Most Number of Waits in the Past One Hour
24. 24.   What Wait Events Are Sessions Waiting On
25. 25.   List Of Users Currently Waiting
26. 26.   Top 5 SQL statements in the past one hour
27. 27.   Top 5 Queries for past week based on ADDM recommendations
28. 28.   Recently modified objects