Quote Originally Posted by mahajanakhil198 View Post
seem
seems u haven't got it exactly. i want to find the blocking SQL, not the SQL to find the blocked sessions.
It gives you the sid of the blocking session which you can use to query v$session, which gives you the current sql id of what they are running which you can use to find the blocking sql.