Re: OFA on a single disk system

As far as I know the reason for OFA is to avoid disk contention. I'm not sure that partitioning the disk will make a difference, because all the io still goes through the same disk controller. I may be wrong about that.

I had a similar dilema, until I read that you could get away with a single disk installation in a development enviroment with less than 5 users(can't recall exactly where I read that).

In the end I created 3 partitions : the operating system(linux), oracle program files(8.1.6) and the database. I don't have a major problem, but then it is just me connecting to the database. I have repository and the application tables in the same database. I noticed that when working with Designer 6i, the performance is terrible, but doing stuff from Forms 6i and SQL*Plus is not a problem. I recently upgraded the memory to 512mb(It was 128mb without repository). This did make a difference.

It may be worth your while to not use the second disk as a mirror and keep the operating system and oracle program files one a seperate disk to the database files.

According to the Oracle 8i DBA Handbook, you should try to isolate the system tablespace if at all possible, because every query accesses the data dictionary which resides in the system tablespace. And of course make sure that no users can create tables in the system tablespace. The next step is put the indexes on a seperate device, then rollback segments ........

With 2 disks you could also spread the control files and redo logs across the disks.

Glenn

Jack" <whatdoesyourhearttellyou_at_yahoo.com> wrote in message news:9ee0fd4b.0109210711.260d05d_at_posting.google.com...
> Hi all,
> I'm trying to set up and OFA compliant Oracle system on a single disk
> system (well, two disks, but they are mirrored). Reading through the
> documentation, and some of the postings here, it seems like the four
> partition scheme that Oracle suggests doesn't make sense for me, and
> I'm thinking of the following scheme:
>
> /opt/oracle/d01
> on one partition (for the Oracle application) and,
>
> /opt/oracle/d02, /opt/oracle/d03, /opt/oracle/d04
> on another partition (Oracle data).
>
> I'm using d02, d03 and d04 instead of putting all the data in one
> directory for upgrade flexibility.
>
> I'd like to know if anyone sees a problem with this configuration, or
> have a better idea.
> One problem that I see right now is that because the Oracle data,
> index and rollback etc are on the same partition, the files might get
> fragmented. Can anyone comment on this?
> Thank you.
>
>
> Regards,
> Jack
Received on Fri Sep 21 2001 - 13:25:32 CDT