How can i check if a materialized view is used by a query

[Orca777]

Oracle 8.1.7.3.50
Os : Z/OS

Thanks in advice

Orca

[pando]

look the explain plan?

[Orca777]

Thanks!
Orca

[tycho]

Hi,

There is a package dbms_summary with the proc RECOMMEND_SUMMARIES and RECOMMEND_SUMMARIES_W.

They will do the trick.

Tycho

[Orca777]

Hi
I want to modify my question a bit;

There a MVIEWS defined, everything is enabled for using them.
Many Applications run against the base-tables of the Mview.

Is there a possibilty to count the 'MView-Hits' ( SQL was rewritten, data accessed by the view ? )

Orca

[pando]

not in 8i as far as I know, in 9i you could enable fine grain auditing but that's all