Re: truncate partition not happening
Rick James Wrote:
-------------------------------------------------------
> Ouch! Could there be other ALTER statements that
> fail to notify the QC?
I have not found any other ALTER statement missing invalidating the QC.
> A side question...
> The QC purges all entries for a "table" upon any
> write -- but in the case of PARTITION, is "table"
> the entire table, or just the one sub-table
> (partition) that was modified?
The QC works on table level only. So any write to the table should invalidate the whole table (all partitions).
Also bug#53775 is known with QC + partitioning. And the best solution would be to change the API for the query cache which would also allow support for 'partition pruning aware' QC.
Subject
Views
Written By
Posted
3852
January 09, 2012 08:06AM
2179
January 12, 2012 05:02AM
1740
January 13, 2012 09:58AM
Re: truncate partition not happening
2210
January 13, 2012 10:13AM
1660
January 13, 2012 10:37PM
1917
January 16, 2012 12:41AM
1703
January 16, 2012 04:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.