No question at this time
DBA Top 10
1 M. Cadot 3900
2 B. Vroman 700
2 P. Tsongayinwe 700
2 P. Wisse 700
5 M. Pagac 400
6 G. De Paep3 200
6 A. Deledda 200
6 D. Walgude 200
6 J. Schnackenberg 200
6 B. M 200
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48757
Total active users1320
Act. users last 24h0
Act. users last hour0
Registered user hits last week24
Registered user hits last month1443
Comment details
Date 05-APR-07
Type Suggestion
User Guy Lambregts
Message Geert,

In addition to my previous suggestion ... I wonder whether it is possible for the plato.processdetails to do a look up in v$sql for the associated sql_id' s (only for the select) and have done something like

define sql_id = 'abcxyz'
select * from table (dbms_xplan.DISPLAY_CURSOR('sql_id')) ;

We would get the sql plan without taking a look in v$sql_plan.

Regards
Guy