aravindhreturns

 Profile Answers by aravindhreturns 

• Apr 23rd, 2010

 

To find the ORACLE database size, you need to make a small calculation.

The result of these two syntaxes below can be used to find the total allocated size of the database:-

select sum(bytes)/1073741824 from v$datafile;
select sum(bytes)/1073741824 from v$tempfile;

The space which is used at present can be found through this syntax:-

select sum(bytes)/1073741824 from dba_segments;

Add the first two (datafile and tempfile) and subtract it with the last one (segments) to get the current free space. That’s on the space front.

To find the current ORACLE version, Use this simple query below:-

Select * from v$version;

For RMAN’s Version,
Go to Start Menu, Then RUN. Type “cmd” and Get inside the command prompt.
Then type RMAN, It will automatically display its current version.

Regarding RMAN size,
There is nothing called RMAN size. It is just a utility provided by ORACLE to take backups and restore whenever necessary.

If you’re referring to the size of the backups,
For windows, Go to the concerned backup folder and see the space for yourself. It is not a big deal.

For Unix/Linux, Use “df –h” to see the current space allocated for the backups. (Please note that you must be in the backup/concerned folder before executing this command).