Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Checking free space on a raw device

Re: Checking free space on a raw device

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Mon, 18 Sep 2006 23:39:13 +0800
Message-Id: <7.0.1.0.0.20060918233857.01bae8c0@singnet.com.sg>

One single Raw Device should be holding only one datafile. Normally, the datafile is created as the same size as the Raw Device [minus the header block overhead].

However, you can use
1. dd if=rawdevice of=/dev/null bs=1M

     and the count should show the size of the raw device. 2. query dba_data_files for the size of the Oracle Datafile in the raw device. The difference should be the "free space" -- space which you can resize/autoextend the datafile by.
Hemant

At 11:19 PM Monday, Hameed, Amir wrote:
>Folks,
>Is there an equivalent to "df -k" to check space usage for RAW devices?
>If not then how can one look at the free space available on the RAW
>device? I am using RHL ES 4.
>
>Thanks
>
>__
>Amir

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 18 2006 - 10:39:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US