Space Used

Show the ten largest oracle objects in the database using dba_segments Capacity planning starts with knowing which segments hold the most space. DBA_SEGMENTS describes the storage allocated for all segments in the database, so one sorted query shows the ten biggest consumers. SQL Code 1col owner format a15 2col …