No question at this time
DBA Top 10
1 M. Cadot 6500
2 B. Vroman 2700
3 J. PĂ©ran 1600
4 P. Tsongayinwe 1500
5 P. Wisse 1200
6 A. Kavsek 1100
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48695
Total active users1323
Act. users last 24h3
Act. users last hour0
Registered user hits last week79
Registered user hits last month345
Comment details
Date 03-APR-07
Type Suggestion
User Guy Lambregts
Message Hi Geert,

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

Kind Regards
Guy