Tablespace Monitoring
Oracle Segments Nearing Max Extents via dba_segments
Identify Oracle Database Segments Nearing Their Maximum Extent Limit Oracle ignores the MAXEXTENTS storage parameter for objects in a locally managed tablespace, unless the tablespace has ALLOCATION_TYPE set to USER. That one rule decides whether the query below is useful on your database. It is a real early warning in …
Read More