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 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