RE: dbms_xplan and Statspack 12c oops
- From: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
- To: "uwe@xxxxxxxxxxxx" <uwe@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 5 Jan 2016 16:33:09 +0000
Hi Uwe
==> 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
Other related posts:
