Home  Easy-Code   Forum    Updater 


Not signed in (Sign In)
    • CommentAuthorbrother2
    • CommentTimeApr 2nd 2012
     
    Query to get the total space (used + free) in GB under each tablespace,
    select TABLESPACES_NAME ,bytes/1024/1024/1024 TOTALGB from dba_data_files ;

    Query to get the free space in GB under each tablespace,
    SELECT TABLESPACE_NAME,SUM(BYTES)/1024/1024/1024 FREEGB FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME;