Modern Oracle DBA

Web logic stuck threads Overview   What is stuck threads in weblogic server? Stuck threads are  long running threads and It means thread has been running longer predefined timeout.   What stuck threads will do? A thread might get stuck for various reasons.   Example :  When an SQL query is running and the time it takes to complete is say 800 seconds, then, as the default stuck thread timing is 600 seconds in WebLogic Server, the thread allocated for that query waits for 600 seconds and goes to stuck state. Then managed server status showing waning state   How to troubleshoot the stuck threads in EBS instance? Stuck threads will reduce the ebs performance and it’s very important activity to DBA’s Step 1: Go to the weblogic console and check for managed server status like oacore Step 2: if It will show the oacore server in “warning state” then we need to check   Scenario 1: Every alert we need to check the log file and investigate based on the log ...

SQL tuning adviser introduced in 10G SQL Tuning adviser is replacing the manual tuning SQL tuning process. It will be providing advice for increasing the SQL query performance. Tuning adviser script is complete analysis for the SQL query and given detailed reports. Tuning Adviser Recommendation below Find the missing statics Find the index Find the SQL Profile Find the better execution plan Restructuring the SQL Identify the high load SQL statements How to run Tuning Adviser Using OEM: Step 1: Fins the SQL_D Step2: Click Performance tab à SQL à Search SQL Step3: Enter the username and password Step4: Place the SQL_ID for under filter condition tab and click search. It will show the sql_text, Plan hash value, Schema name and Elapsed time Step5: Top of the tab showing the Actions tab choice sql_tuning_adviser and click GO button Step6: It will show the tuning task name and click submit button Step7: It will generate tuning adviser report. U...