No question at this time
The DBA-Village forum
|Ever registered users||48695|
|Total active users||1323|
|Act. users last 24h||3|
|Act. users last hour||0|
|Registered user hits last week||79|
|Registered user hits last month||345||
I sometimes use plato.processdetails
It is interesting since it lists the current sql running -as well as the previous ones - in a user session this with sql address and hash value. I can then map it with v$sql and v$sql plan.
I think Geert, it could be an improvement if you would add the v$sql.plan_hash_value. Since cursors can have child cursors, multiple plans are possible. Which one is used by the session ? If you would add the v$sql.plan_hash_value we would be able to find the right plan very easily.
Correct me if am wrong