Generally running 'df' against a file will tell you
its filesystem
$ ls -l x
lrwxrwxrwx 1 oracle dba 25 Apr 18 15:56
x -> /export/home/oracle/admin
$ df x
/export/home (/dev/dsk/c0t1d0s0 ): 4491432
blocks 918387 files
Maybe just dump out v$datafile and df each one
hth
connor
- Jim Hawkins <VelvetMellocet_at_netscape.net> wrote:
> Anybody know the answer to this question? This is
> on HP-UX.
>
> "I am managing a database that has symbolic links
> for data files. On this instance, I am using
> STATSPACK to track performance. I need to tie IO
> rates back to real mount points so that I can work
> on balancing IO.
>
> How do I tie the names in DBA_DATA_FILES to actual
> mount points? I need this very quickly."
>
> Thanks in advance,
> Jim
>
>
> --
> _____________________________
> Jim Hawkins
> Oracle Database Administrator
> VelvetMellocet_at_netscape.net
> St. Louis, MO USA
>
>
>
>
> Your favorite stores, helpful shopping tools and
> great gift ideas. Experience the convenience of
> buying online with Shop_at_Netscape!
> http://shopnow.netscape.com/
>
> Get your own FREE, personal Netscape Mail account
> today at http://webmail.netscape.com/
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jim Hawkins
> INET: VelvetMellocet_at_netscape.net
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Apr 18 2002 - 10:58:24 CDT
