About
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.
Articles Related
Example
select * from objects where object_name like '%TABLE%' and schema_name = 'PUBLIC'
Data
Note Many system views are available in two versions:
- one that shows the data gathered since a particular service was last started,
- and one that shows the data gathered since the time the view was last reset.
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.