Datenbankgröße ermitteln (by Wolfgang Ganser)

wie gross ist meine DB, mein groesstes segment? in einer 10g DB auf einen blick ???

hi all,

klein aber fein ;-)
schoenen tag noch .......

ORACLE SQL
----------------------------------------------------------------
--
-- Author: Wolfgang Genser / Januar 2005
--
--
----------------------------------------------------------------
SELECT name,
             max(water)
FROM
             (SELECT name,
                        HIGHWATER water 
              FROM
                       dba_high_water_mark_statistics
             WHERE HIGHWATER > 0)  
GROUP  BY name
HAVING count(*) > 1;

Die Ausgabe kann wie folgt aussehen: 

NAME                                                      MAX(WATER)
--------------------------------------------------------- ----------
CPU_COUNT                                                          6
DATAFILES                                                          4
DB_SIZE                                                   2525757441
SEGMENT_SIZE                                               266338304
SERVICES                                                           4
SESSIONS                                                          25
TABLESPACES                                                        5
USER_INDEXES                                                     859
USER_TABLES                                                      399