Re: Oracle file managerCLOSE

From: Joel Garry <tumidity_at_netlink.cts.com>
Date: Thu, 01 Oct 92 11:25:38 PDT
Message-ID: <FDaZRB1w165w_at_netlink.cts.com>


sstephen_at_us.oracle.com writes:
>
> The database is stored in a set of UNIX files. When you issue "create
> database", it does a "creat" system call to create unix files in the
> $ORACLE_HOME/dbs directory. If ORACLE created it's own file structure, you
> wouldn't be able to back them up using normal UNIX commands. So, yes, inodes
> and dnodes are created for these files, they are stored and accessed the same
> as any other filesystem. If Oracle kept a directory of contiguosly allocated
> disk pointers, you would never be able to recover from disk crashes or restor
> from backups. The drawbacks of using unix files for data storage are
> relatively small since both Oracle and UNIX depend on memory caching frequent
> accessed data. I don't know if the files are contiguous anymore. In Oracle
> you used to have to manually create your data files with a utility called
> "ccf", (create contiguous file). I know that those datafile contain some
> internal indexes into the rest of the file but I don't know what the structur
> of these indexes are.
>
> Scott Stephens -- representing my own rantings.

I seem to recall reading that you can mount the oracle database "raw" on a unix system, and it would run faster. Anybody have any actual experience with this? And is it in ORACLE7?

--
INTERNET: tumidity_at_netlink.cts.com (Joel Garry) UUCP: ...!ryptyde!netlink!tumidity
NetLink Online Communications * Public Access in San Diego, CA (619) 453-1115
Received on Thu Oct 01 1992 - 19:25:38 CET

Original text of this message