select * from objects where object_name like '%TABLE%' and schema_name = 'PUBLIC'
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.