-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|