Tablespaces that do not obey the uniform extent size rules
                                                 Last update (2008-02-21 10:57:09)
                                                                                                                   Date added (2008-02-20 16:00:29)

Summary
The number one rule to avoid tablespace fragmentation is Uniform extend size. You can find the tablespaces that do not obey the uniform extent size rules with the script following.
SELECT tablespace_name, initial_extent, next_extent, pct_increase, min_extlen
FROM dba_tablespaces
WHERE (initial_extent NOT IN (160*1024, 5120*1024, 160*1024*1024)
OR next_extent != initial_extent
OR pct_increase != 0
OR min_extlen != initial_extent)
AND CONTENTS = 'PERMANENT'
AND tablespace_name NOT IN ('SYSTEM', 'SYSAUX')
AND tablespace_name NOT IN (SELECT tablespace_name FROM dba_rollback_segs);
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search