Databases
cancel
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?

Regards,

Frank
4 REPLIES
Steven E. Protter
Exalted Contributor

Re: Oracle9i RAC: RAW capacity devices

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
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.

Brian
Yogeeraj_1
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-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

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

Re: Oracle9i RAC: RAW capacity devices

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
Amit Vichare