Browse source of some Materialized views very slow (11g)

[-dRn-]

I got problem with viewing source of some Materialized views. It's very slow.
And I found that the root of the problem is quering from DBA_MVIEWs, it's very slow in 11g.

Via My Oracle Support:

Select from DBA_MVIEWs is very slow in 11g. [ID 1322308.1]

When the columns NUM_FRESH_PCT_REGIONS & NUM_STALE_PCT_REGIONS are included, the tables TABPART$, TABSUBPART$ and TABCOMPART$ are queried internally. If the data volume is high in these internal tables, then the query will be very slow.
This can is expected behaviour with high volumes of data in these tables.

Solution
If there is no specific reason for querying the columns NUM_FRESH_PCT_REGIONS and NUM_STALE_PCT_REGIONS then create an view on DBA_MVIEWS excluding these columns and query the new view.