Monitor tablespaces and datafiles
Track free space and growth
Setup in Germain Workspace
Start the Oracle wizard
Add DB Credentials
Store the database login
Enter Database details
Connection details for the database
Monitor tablespaces and datafiles
Monitor the usage and growth of tablespaces and datafiles within the Oracle database. Track free space, growth rate, and ensure that tablespaces are properly managed to prevent space-related issues. For basic monitoring of a single instance, Germain uses a regular database user account with CONNECT permissions. In the case of Oracle RAC, it is possible to monitor the status of the cluster as a whole or individual instances. To perform more in-depth monitoring, the database user needs to be granted additional permissions to execute queries against a series of system views. Please note that Germain can monitor any other Oracle tables, whether they are system tables or data tables. The requirements mentioned below are the bare minimum, but they can be extended to include monitoring of any other tables as well.Required Views and Permissions
Setup in Germain Workspace
Log on to Germain Workspace > left menu > Wizards > Oracle Database Server
Add Database as Data Source
Germain workspace > Left Menu > Data Sources > Database > Add New Configuration
Add DB Credentials
Germain Workspace > Left Menu > Data Sources > Credentials
Add Database Query Monitor
Germain Workspace > Left Menu > Wizards > Database Query Monitor Deployment
Enter Database details
Add KPI
Add SLA
Alert Template: SLA.Choose one or more of your actions (Alerts, Reports, Scripts, ect..)
Set KPI
Deployment details
Monitoring Node: The Node that the Engine runs from Engine: The engine you want to run the Monitor on Fill in the schedule you would like the Monitor to run on
Verify the Monitor
Verify the Monitor by finding in “Germain State”
Get Help
Contact GermainUX Support
The Germain Team can help you set this up.
Can't find what you need?
Search all GermainUX docs with Ctrl + K, or use the feedback buttons at the bottom of this page to tell us what is missing.
The content of this document is proprietary to GERMAIN SOFTWARE.