Resolving cursor: pin S wait on X using interesting column final_blocking_session in v$session
Recently I was having issue in our test environment, users were complaining that database is not responding for any queries, it appears to be in hanged state. After checking database for possible causes for performance issues, I found following: SQL> select event,count(0) from v$session where username is not null and […]