To see all schemas in a monitoring Oracle instance, perform the following steps:
- On the Databases dashboard, click on the Home icon for the monitoring Oracle instance
- Navigate to Storage | Invalid Objects - the Invalid Objects panel displays all of the database’s schemas. However, the Invalid Objects panel would only display data if there is invalid objects.
In addition, there is another way to see the schema listing in the data browser by navigating to Configuration | Data | Management Sever | All Data | DBO_Data_Model | Oracle Data Model | Clusters | select the Oracle RAC | Database | Invalid Objects - it will list all the schemas.
