RE: dbms_xplan and Statspack 12c oops

> ==> Quick, dirty and most certainly unsupported workaround:
>
> alter table stats$sql_plan add (timestamp date);

My advice is to make what you propose less dirty... i.e.:

ALTER TABLE perfstat.stats$sql_plan ADD timestamp INVISIBLE AS (cast(NULL AS DATE))

I don't see how adding such an invisible virtual column could cause a problem.

HTH
Chris Antognini

Troubleshooting Oracle Performance, Apress 2008/2014 http://top.antognini.ch

†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Tue Jan 05 2016 - 17:33:09 CET