Basic Performance tuning tips reference
Performance Tuning for overall system performance goes down ============================================================== 1) first look at the top processes. using TOP command 2) ps -ef| grep says the database to which the session belongs. or take strace -p < pid> , it will generate trace file for the PID, you can get the instance name for which this pid belongs to. 3) From the TOP command know the process id and match the paddr in v$session with addr in v$process where spid = process number that you see in the top command In the select clause, you project,sid, 3)After finding the sid we need to get the sql text select sql_text from v$sqltext where sid=153; wait for few minutes and see if it the correct one. 4)select event,total_waits from v$session where sid=153 order by total_waits; 5) see the two tables how much time the session is waiting for the event to occur v$session_event, is the what event the session is waiting. 6) Then go to attain a trac...