Performance slowness of database issues
1, Check the load on the database server , identify the process which are taking high resources. 2, check the application services are running preffered node or not 3, Check for FRA usage on the database and ask for users are getting any error codes in the application logs. 4, Check for locks and Blockings in the database. 5, check for Active and Inactive count. 6, Check for ongoing transactions in the database. 7, Check for alert log file for any errors . 8, Get more information from application for any new code deplyoment or any load in the database. 9, Check for archive generation growth in the database and check for tablespace usage and also undo and Temp. 10, open the OEM for ongoing transcations and Locks and Blockings in the database. 11, check for queries which are taking long time check the plan hash value. 12, Prepare steps for apply the best plan hash value to sql_id 13, Apply the SQLT to get more recommendations. 14 ...