Database Administration (MOSC)

MOSC Banner

Need Clarification about DB Storage

edited Apr 5, 2012 7:01AM in Database Administration (MOSC) 5 commentsAnswered
Hi ,

   I am just confused about the total database space usage.
   On my Oracle Enterprise Manager DB console home page, I see the Database Size (GB) : 535.97
   But when I goto tablespaces tab in OEM, I found Total_Size (MB):1,091,214.0  Total_Used (MB):938,198.0  Total_Free (MB): 153,016.0
   Why OEM db console space summary section on home page shows:535.97GB?

   If I run the below commands, I get the following results:
 SELECT SUM(bytes)/1024/1024/1024 AS Space(GB) FROM dba_data_files;

        Space(GB)
        -------------       
        982.963897705078

 SELECT SUM(bytes)/1024/1024/1024 AS Space(GB) FROM dba_segments;
 
        Space(GB)
        -------------       
        915.1826171875

   We have the above datafiles on ASM and if I run the following command: I get the below output:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center