> I am pretty new to Oracle DBA field. I just finished
installing ORACLE
> on AIX. Now I am ready to create database. Some are saying to
create the
> databse in File System, but some are saying to create it in
Raw device
> system. Anybody have any recommendations. What are the pros
and cons of
> each system.
>
> One more question, a consultant is supposed to come and
install couple
> of user software which will access the Oracle on Unix. He
gave me a call
> yesterday, and asked me whether the Oracle Client is ready in
a NT
> machine. What does Oracle Client mean ? Does he mean
Net8,sql Net, or
> Oracle on NT ?
Hi, the File System vs Raw Device question is one of trade-off
between convenience and performance. The file system has
more overhead than the raw device, but it is much easier to
deal with than raw devices.
However:
- the file system implementation in AIX (JFS) is not too
bad, so the performance hit will be acceptable, unless
the size of the DB is > +/- 10 GB
- unless your DB is already well optimized, the difference
of performance between file system and raw device will
be smaller than what you can gain by:
- choosing the right block size
- sizing and allocating the data cache correctly
- allocating separate disks for: data, indexes, redo log,
system segment, temporary
- and of course DB design, indexes, etc
In summary, go for file system unless performance is
critical and you have already (or will) optimize(d) all
the other aspects.
With respect to Oracle Client question, the consultant is
probably talking about Sql Net, unless he is talking about
the client part of one of Oracle applications (Oracle
Financials, ...).
I hope this helps
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=4883&cus_id=USENET&qtn_id=3659
Received on Tue Oct 12 1999 - 06:23:43 CDT
