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