I need a pl/sql script to gather statistics from a particular view. The view takes a long time to execute.
Printable View
I need a pl/sql script to gather statistics from a particular view. The view takes a long time to execute.
Is it a view or a materialized view?
It is a regular view.
A regular view is nothing but a query saved in a catalog, you don't gather performance stats on views but in base tables.
Use DBMS_STATS package.