Segment size collector (all segments — aggregate)


Job details

Name: Segment size collector (all segments — aggregate)
Platform: Oracle
Category: Capacity
Description: Collects size and number totals on all segment types per segment-owner and tablespace_name.
Long description: Task collects size and number total statistics on Oracle 10g or higher for all – (aggregate) type of segments per segment-owner and tablespace_name.
Version: 3.1
Default schedule: 50 6 1,5 *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & ten_and_above = ‘1′ & _priv_read_dba_segments = ‘1′ & _priv_read_dba_free_space = ‘1′ & _priv_read_dba_tablespaces = ‘1′ & _priv_read_dba_temp_files = ‘1′]

Parameters

Name Default value Description

Job Summary

SELECT tablespace_name, owner, segment_type, COUNT(*), SUM(bytes) FROM dba_segments GROUP BY tablespace_name, owner, segment_type

Specifics of Implementation

Scheduled Operations

Outcome and Use of Data

Overall, this dbWatch job plays a crucial role in the monitoring and management of Oracle database segments, providing vital information for database administrators and IT departments focused on maintaining optimal database performance and capacity.