-
Same Address - Same Sql -- 3 records in GV$SQL
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|