Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Oracle9i RAC: RAW capacity devices

Frank Gomes
Occasional Advisor

Oracle9i RAC: RAW capacity devices

Oracle9i requires RAW devices. Once installed and working, how can we find out the capacity of RAW device?


Steven E. Protter
Exalted Contributor

Re: Oracle9i RAC: RAW capacity devices

If you run sam


SAM Disks and File Systems ->

SAM Logical Volumes ->

This will show you the total capacity of the raw disk area.

For actual use on the area, you'll need to use sqlplus internal and run a query.

Steven E Protter
Owner of ISN Corporation
Brian Crabtree
Honored Contributor

Re: Oracle9i RAC: RAW capacity devices

/sbin/lvdisplay will also show information on logical volumes, and /sbin/vgdisplay will show information on Volume Groups.

Honored Contributor

Re: Oracle9i RAC: RAW capacity devices

hi frank,

the following query should give you the desired results:

-- free.sql
-- This SQL Plus script lists freespace by tablespace
column dummy noprint
column pct_used format 999.9 heading "%|Used"
column name format a16 heading "Tablespace Name"
column filename format a30 heading "File Name"
column Kbytes format 999,999,999 heading "KBytes"
column used format 999,999,999 heading "Used"
column free format 999,999,999 heading "Free"
break on report
compute sum of kbytes on report
compute sum of free on report
compute sum of used on report

select nvl(b.tablespace_name,
nvl(a.tablespace_name,'UNKOWN')) name,
kbytes_alloc kbytes,
kbytes_alloc-nvl(kbytes_free,0) used,
nvl(kbytes_free,0) free,
kbytes_alloc)*100 pct_used,
nvl(largest,0) largest
from ( select sum(bytes)/1024 Kbytes_free,
max(bytes)/1024 largest,
from sys.dba_free_space
group by tablespace_name ) a,
( select sum(bytes)/1024 Kbytes_alloc,
tablespace_name, file_name
from sys.dba_data_files
group by tablespace_name )b
where a.tablespace_name (+) = b.tablespace_name
order by &1

Best regards

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Frequent Advisor

Re: Oracle9i RAC: RAW capacity devices

at OS level you can not monitor the RAW volumes as OS do not recognise the same, unsless it has some file system. You will require to monitor by connecting to database , or some sql scripts is required to monitor
Amit Vichare