16 Metrics install automatically if you have Redgate Monitor installed.
If you are using Redgate’s SQL Server monitoring tool, Redgate Monitor, you can instantly install and run this metric on your servers.
A permanent tablespace that fills up forces Oracle to throw ORA-01653 / ORA-01654 and halts the operations that need space. This metric tracks the used percentage of a tablespace, already accounting for the autoextend maximum, so it reflects true remaining headroom rather than just current file size. Create one instance of this metric per permanent tablespace you want to monitor, substituting the tablespace name in the WHERE clause; the metric automatically returns one value per container (PDB) that has the tablespace.
Required permissions:
GRANT SELECT ON CDB_TABLESPACE_USAGE_METRICS TO redgate_monitor_user CONTAINER=ALL;
These are covered by Redgate Monitor’s standard Oracle monitoring user — if it was set up as described in the product documentation, no additional grants are needed.
Metric definition
Name
Tablespace Used % – USERS
Description
Tracks the used percentage of the USERS tablespace, measured against the maximum size it can reach (autoextend-aware). Create one instance of this metric per permanent tablespace you want to monitor, substituting the tablespace name in the WHERE clause; the metric automatically returns one value per container (PDB) that has the tablespace.
Supported database engine
- Oracle
The T-SQL query that will collect data
Instances to collect from
Select all monitored Oracle instances
Databases to collect from
Not applicable - Oracle custom metrics collect once per instance, and values are stored per container (PDB) via the con_id column
Collection frequency
300
seconds (collected every 5 minutes)
Use collected or calculated values
Leave the Use a calculated rate of change between collections check box unchecked
Metric collection
Enabled
Alert definition
Alert name
Tablespace Used % – USERS
Description
Raise an alert when the metric value goes
Above the defined threshholds
Default threshold values
| High: | 90 |
| Medium: | 80 |
| Low: |
Raise an alert when the threshold is passed for
1 collection
Alert is
Enabled
