DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: calculate amount of meomory on each instance

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    calculate amount of meomory on each instance

    Sorry,

    this is going my first time to do this. How can we calcuate the amount of memory/diskspace on one database. Another word, the requirement to run one database. Am I looking at the physical side of the database for disk amount??? I am just not sure what the correct way of doing this.

    thanks a bunch.

  2. #2
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    For rough and ready estimate of database size run this..(as system)

    set heading off
    set feedback off
    select 'Total Size of Database Files is '||
    round (sum(bytes/1024/1024/1024),1)||' GB'||chr(10)
    from dba_data_files;
    select 'Total Size of Redo Logs is '||
    round (sum(bytes/1024/1024),1)||' MB'
    from v$log;
    select chr(10) from dual;
    set heading on
    set feedback on

    Database memory is linked directly to the amount you have available on the server. Assuming a single instance box.

    HTH

Posting Permissions

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


Click Here to Expand Forum to Full Width