DBA_TABLESPACE_USAGE_METRICS is empty

Question

For one of my 11.2g databases, select * from dba_tablespace_usage_metrics returns no rows.

Why is that and how can I fix it?

Thank you in advance.

How many tablespaces are in the database? There is a bug where that view stops working if there's too many rows in dba_tablespaces. — Andrew Brennan, Commented Sep 11, 2017 at 15:39

Balazs Papp · Accepted Answer · 2017-09-11 15:46:21Z

2

Typically caused by:

To verify:

show parameter db_files

select count(*) from v$datafile;

Then increase db_files if needed or upgrade to a newer version where it is fixed.

Another possible cause:

Also fixed in newer version, and one-off patch is also available.

answered Sep 11, 2017 at 15:46

Balazs Papp

41.1k2 gold badges28 silver badges47 bronze badges

1

Increasing the db_files parameter fixed the issue. The parameter was actually one higher than the count returned by select count(*) from v$datafile; However, I upped the db_files parameter by 5 just to see what would happen and it fixed the issue.
– Jeff Bauersfeld
Commented Sep 11, 2017 at 16:19

Add a comment |

1 Answer 1