Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tracking Materialized View Usage
george_at_41donny.freeserve.co.uk (Gee) wrote in message news:<f7859e6f.0205090635.62a69cf7_at_posting.google.com>...
> Having got my set of MVs to work (thanks Mr Kyte for the advice a few
> weeks earlier) I'd like to track when Oracle is actually deciding to
> use each view.
>
> Do anybody have any advice / tips on how to do this without traversing
> the v$sql history and running and inspecting the explain plan for each
> SQL submitted to the DB over time ?
>
> Regards,
>
> George
There is a package called dbms_olap supposed to do that. Tom's book has covered it. I never use it myself, not sure if it works properly. Received on Thu May 09 2002 - 13:02:23 CDT