I am learning performance tuning concept from youtube videos in that i had some doubts.
scott user update the row sal=950+2 of empno 7900
as the hr use have rights select ,update on scott.emp so he also trying to update the row sal=950-5 of empno 7900
so i check problem (wait event) occurred through dynamic views through V$Session,V$sysstat,V$sql i found user scott only having row lock of emp table where empno=7900 and hr is waiting for that table row
What should i do? And what is our next step in real time?
Doubt 2: What are the real time performance tuning issues?
Please guide me.
Thanks in advance.