Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is database using File system, RAW devices or ASM?

837193Mar 21 2012 — edited Mar 21 2012

Hi there

Is is possible to find out if the database is using File system, RAW devices or ASM for storage?

I think for ASM, we can tell by querying the V$DATAFILE view if it has ' DATA ' or something like that (a name that has ' ' prefixed to it). Is this the only way? How about other sotrage types (RAW and Filesystem)?

Thanks in advance!

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2012

Added on Mar 21 2012

#general-database-discussions

4 comments

505 views