Interestingly when i queried one of the sql address
for a user session which is hanged (the sessions is inactive but the
user session is hanged), I found 3 sql lines for the
same sql address in gv$sql table. The sql text also same for the three records but the stats are different.
Frequently I used to search this sql but rarely I am getting these kind of multiple entries (normally duplications) at this area. What could tbe reason for this?
