RE: Type of FS being used
From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Wed, 9 Feb 2011 17:35:26 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F644CF827_at_AAPQMAILBX02V.proque.st>
Select file_name from dba_data_files;
Date: Wed, 9 Feb 2011 17:35:26 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F644CF827_at_AAPQMAILBX02V.proque.st>
Select file_name from dba_data_files;
If any file names start with a '+', you're using ASM.
-Mark
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alex List
Sent: Wednesday, February 09, 2011 5:16 PM
To: Oracle I List
Subject: Type of FS being used
Hi there,
I was trying to figure out how I can see if my storage system is FS or ASM instance. For Asm instance, I know that i can check on v$asm_diskgroup view for more info, but I was wondering if there is a parameter that means which file system the instance is being used. Does anybody know, or I really have to check the view above?
Thanks in advance.
Alex
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 09 2011 - 16:35:26 CST