System views are located in the SYS schema. However, as public synonyms of all views exist, it is not necessary to specify the schema name when you query these views.
select * from objects where object_name like '%TABLE%' and schema_name = 'PUBLIC'
Note Many system views are available in two versions:
For example, the view M_VOLUME_IO_TOTAL_STATISTICS shows the total read size and the total write size for each volume since a service was last started.
Example: The below RESET SQL statement initializes the statistics shown by this view.
ALTER SYSTEM RESET MONITORING VIEW SYS.M_VOLUME_IO_TOTAL_STATISTICS
The view M_VOLUME_IO_STATISTICS_RESET now shows the statistics since the reset time.