Hi,
Recently, Application team has reported the performance issues on our oracle database. When I checked, I have noticed the SYSTEM tablespace is heavily fragmented. Can anyone tell how far the fragmentation affect the performance of the database.
Database Version : 11.2.0.3.7
Size : 1.5 TB
SQL> select sum(bytes/1024/1024/1024) from dba_segments where tablespace_name='SYSTEM';
SUM(BYTES/1024/1024/1024)
-------------------------
4.93933105
SQL> select sum(bytes/1024/1024/1024) from dba_data_files where tablespace_name='SYSTEM';
SUM(BYTES/1024/1024/1024)
-------------------------
64.0976257
Thanks in advance,
Kesav.