If database is slow and giving performance issues, how to check this from weblogic application server

=================================================================================

Following the below troubleshooting tips

(1) Analyze the application server logs to confirm if any logs is showing ORA or database relevant errors

(2) Monitor the application server thoroughly to check if AS is working fine

(3) Take the thread dumps and check what is causing slowness. Thread dumps can give you a hint if it is because of DB.

(4) Try to ping the database server from application server to check if there is any RTO to confirm the network connectivity between DB and AS

(5) Try to establish a telnet session of database server from application server to verify if it is active (run an 'uname' or 'uptime' OS command from telnet session and keep it idle for an hour)

(6) Try to establish a SQL session of database server from application server to check for how long session is established to confirm database connectivity from DB to AS

If these things are working fine, we should go for DB AWR/AADM reports and monitor the DB. We can't exactly figure out what is happening on database server from application server.