Modern Oracle DBA

We frequently encounter issues with concurrent programs running long and concurrent requests not picking up jobs. These problems are often expected from the development and functional team we need to address this issue To solve this, we should take the following steps: Collect below basis level of information to development team 1 Oracle seeded program/Custom program? 2 How much time it used earlier? 3 Is there any recent code change done in concurrent program? 4 Is this program fetching higher data compare to last run? 5 Does this job running any specific time/ It can be run any time? 6 Does this job fetching data using DB link? 7 Does the problem happen on both the test and production instance?   Troubleshooting Steps for Concurrent Requests Check for Locks and Blocking sessions Identify if the request is running but blocked by database locks/Blocking sessions. Use DBA tools or queries to identify and release locks if necessary. Review Parameters and Data ...

Top Command Analysis Top command is used to show the Linux process This command shows the summary information of the system and the list of process which are currently managed by the kernel Top command we need to check two session summery session and task session Summery session System Time, Up time and user session Load average Tasks CPU usage Memory Usage System Time, Up time and user session top - 11:59:39 up 225 days, 22:31, 136 users, System time: 11:59:39 Up time: up 225 days, 22hrs:31min User session: 136 users connected. Load average Load average is the system load calculated over given period 1,5 and 15 minutes Load average have 3 sessions Load average: 4.43, 4.14, 4.03 Load average over last 1 minutes is 4.43 Load average over last 5 minutes is 4.14 Load average over last 15 minutes is 4.03 The high load average that system is overloaded many processes are waiting for CPU time Tasks Tasks session showing how many processes runni...