Tags

, , , , ,

The SYSMAN schema in your OEM repository contains near-real time data from all of your EM targets.  You can leverage this data to create valuable reports for your DBA team.   These two queries provide insight your tablespaces and datafiles.

When you create views to display these in Information Publisher reports to data can be sorted on any of the columns for a quick, accurate look at  related systems or simply satisfy your curiousity (or settle bets) about the largest tablespaces and datafiles in your enterprise.

Image

Image