Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool Unanswered: Determind database size command

    Is there a command that will give you ruffle how big you full database repository is? Like:
    select sum(bytes)/1024/1024 from dba_data_files;


    --------------------

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >select sum(bytes)/1024/1024 from dba_data_files;
    I prefer
    select round(sum(bytes)/(1024/1024)) from dba_data_files;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Smile Determind database size command

    Determind database size command

    This is just what I was looking for

  4. #4
    Join Date
    Jan 2009
    Location
    Dhaka, Bangladesh
    Posts
    51
    Quote Originally Posted by anacedent
    >select sum(bytes)/1024/1024 from dba_data_files;
    I prefer
    select round(sum(bytes)/(1024/1024)) from dba_data_files;
    you can use the above one. Some people use EXPDP with ESTIMATE_ONLY=Y parameter
    Mohammad Hasan Shaharear
    E-mail
    Blog: http://shaharear.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •