Discrepancy with Oracle DB Tablespace information shown in Applications Manager
By default, Oracle DB Tablespace statistics is calculated along with its auto-extensible size in Applications Manager.
If you want to calculate Tablespace statistics without considering the Auto Extend option, navigate to Settings -> Performance polling -> Optimize data collection -> Choose Metric Name as 'Tablespace statistics'.
Then, disable the 'Calculate Tablespace statistics along with it's autoextensible size' option. (This will be enabled by default, so you have to disable it manually).
Tablespace statistics will be now be calculated without considering the Auto Extend behavior.
Tablespace statistics will be now be calculated without considering the Auto Extend behavior.
New to ADSelfService Plus?
Related Articles
How to import certificates for monitoring Oracle database with SSL authentication?
For users using Applications Manager version 14250 and below: One-way SSL: (Client authentication disabled) 1. Open the command prompt using 'Run as administrator' option and navigate to the Applications Manager installation directory. 2. Import your ...Integrating Applications Manager DB with Grafana
Grafana is an open-source data visualization tool that collects data across multiple software platforms and retrieves them altogether in a single dashboard. It provides advanced analytics by connecting to various data sources in different platforms, ...Monitoring Oracle standby databases in Applications Manager
Do we support Oracle Standby Database monitoring? Yes, we do. How to connect to the Standby/Standalone Oracle database which is in MOUNTED mode? To connect to an Oracle database in STANDBY MOUNTED or normal MOUNTED mode, you must use the sysdba user ...Why are Oracle Tablespace(s) being reported as down even when they are no longer available?
If data is not available for the current poll in the Oracle Tablespace monitor, this is the behavior exhibited by default: Data (including threshold) is retained Health is reported as down For Applications Manager version 173800 and above Go to ...I have set up monitoring of an Oracle database. The 'Tablespace Details' and 'Tablespace Status' areas show no data or error.
Solution: You can execute the TABLESPACE STATUS query in your Oracle and check the data. Go to <Appmanager/working/conf/application> directory. Then open the <Oracle.xml> file and check for the string "TABLESPACESTATUS". Below that you will find the ...