Re: OS, file system information in Oracle

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Mon, 7 Apr 2003 20:50:53 +0100
Message-ID: <3e91e2b5_2@mk-nntp-1.news.uk.worldonline.com>

"chenna" <member27732_at_dbforums.com> wrote in message news:2737025.1049706952_at_dbforums.com...
>
> I would like to know the the OS, and File system using Oracle sql
> query. Is it possible.
> How to find which file system oracle is using?
>

I just tried this:

G:\Documents and Settings\Dad\Documents>sqlplus brewerp_at_dad

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Apr 7 20:29:20 2003

Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

SQL> select banner from v$version;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production

Note the TNS bit; it gives a hint I might be running on Windoze (XP in fact). The dba_data_files view would doubtless confirm that the slashes are in the wrong direction (this is home, not work)....;-)

But I suggest that this may not be the best way to look at things; essentially IMHO, the Oracle database should be independent of the underlying OS.

Despite all the recent Java stuff I would urge against trying to play with the filesystem from the database unless absolutely necessary; this may well be a mistake under most circumstances. In general, if you want to interrogate the database, do it from the database. If you want to interrogate the OS, do it from the OS.

Simplistic I know, but just my two cents. YMMV.

Regards,
Paul Received on Mon Apr 07 2003 - 14:50:53 CDT