Wednesday, January 23, 2013

Oracle Database Spaces (Reserved / User / Free)

Login as oracle system user.
sqlplus / as sysdba


select
"Reserved_Space(MB)", "Reserved_Space(MB)" - "Free_Space(MB)" "Used_Space(MB)","Free_Space(MB)"
from(
select
(select sum(bytes/(1014*1024)) from dba_data_files) "Reserved_Space(MB)",
(select sum(bytes/(1024*1024)) from dba_free_space) "Free_Space(MB)"
from dual
)
Posted by at

1 comment:

  1. Anugraha JainJuly 6, 2015 at 4:53 AM

    Hello WEI,

    We have developed a new gen developer friendly BI framework with some extremely unique features. Would like to give you early access & love to hear your opinion. Please do let me know of how to reach out to you. Would be launching product in 1 week from now.

    Also could you please share your email details for further communication.

    Regards,
    Anugraha

    ReplyDelete

Subscribe to: Post Comments (Atom)