Oracle9i RAC: RAW capacity devices

[Frank Gomes]

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

Regards,

Frank

[Steven E. Protter]

If you run sam

Choose

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.

SEP

[Brian Crabtree]

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

Brian

[Yogeeraj_1]

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-nvl(kbytes_free,0))/
kbytes_alloc)*100 pct_used,
nvl(largest,0) largest
from ( select sum(bytes)/1024 Kbytes_free,
max(bytes)/1024 largest,
tablespace_name
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
Yogeeraj

[CCIL]

Hi
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