Any Suggestions On Disk Space Allocation for Oracle DB

From: Mirwais Qader <mq_at_wohl.slh.wisc.edu>
Date: 1996/12/31
Message-ID: <32C975A0.35F0@wohl.slh.wisc.edu>#1/1

Our System info:	Oracle 7.2.2.4
			HP-UX 9.04 on HP9000
			256MB RAM; 5.9GB HD [3-1.3GB and 1-2.0GB disks]
			currently 1 controller; getting another one

Current disk "map":	[using an OFA structure]
	-software installed in /users/oracle
	-/oracleDB = a 290MB partition used for rollbacks etc..
	-control files stored in /oracleDB, /chem/oracle, /labux/oracle
	-datafiles are stored in /users/oracle and /labux/oracle
	-Using UNIX 'Logical Volume Manager'
	-oracle Discoverer/2000 installed in /chem/oracle/orawin
	
	[I don't like this layout at all!!]

Running 3 instances:	-production (main one)
			-test (all testing done on this instance)
			-sample (used for training etc...)

Note:  these instances don't have a lot of data in them right now
       (maybe 300MB); later they will have up to 4GB+ data.

We are in the process of acquiring 4-2GB disks (8GB total) and have an opportunity to distribute the database in a more organized manner.

How would someone recommend we do this?

1. should we (I think) move the software into a /software directory? i.e., /software/SAS, /software/oracle, /software/inhouse, /software/other...

	(stupid question:	if we do it like above, does the 
				oracle "user" home directory have
				to be changed to /software/oracle
				or can we keep it /users/oracle?)

2) should we continue to use the Logical Volume Manager to control our

   disk space management or get away from it because individual disks    cannot be identified? Currently, our sys-admin is unable to tell    which disk a particular volume contains and with 2 controllers, he    may not be able to properly distribute the files amongst them.

	-should we go to using just plain disk devices, therefore,
	 knowing where files are located etc....

3) should our root /tmp directory be increased in size since oracle

   uses it for some of its processes?

Filesystem           kbytes     used    avail  capacity Mounted on


/dev/vg00/lvol1      199610   101840    77809     57%   /

/dev/vg00/lvol5      243578   134292    84928     61%   /oracleDB

/dev/vg01/lvol3     1585562   969780   457225     68%   /users

/dev/vg01/lvol2     1226170   944747   158806     86%   /labux

/dev/vg01/lvol1     1797210  1040662   576827     64%   /chem

/dev/vg00/lvol3      383402   242665   102396     70%   /usr

/dev/vg00/lvol4      199610    66755   112894     37%   /usr/lib

/dev/dsk/c1d0s2      416692   416692        0    100%   /cdrom


	vg00=1-1.3GB disk
	vg01=3 disks [2-1.3GB and 1-2.0GB]

My own opinion is like this:

*install oracle in /software/oracle
*under this strucure/directory, mount /dev/dsk/1, /dev/dsk/2, /dev/dsk/3 (for easy setup and maintenance) and setup software under the OFA structure.
*Have the files distributed between the 2 controllers:

	ex. ctlr1 ->/dev/dsk/1 and 2	= core oracle files
	    ctlr2 ->/dev/dsk/3 and others = core other files; backup/mirror
	    image of stuff on ctlr1

*remove /oracleDB and assign it to something else, like /=root, therefore,
 being able to increase the size of /tmp if need be.

---

Our sys-admin/DBA wants me to give him some suggestions by 16Jan97, but I am not sure exactly what to tell him.

Any suggestions will be greatly appreciated!! Please respond by email - Thank You!
-Mir.

---

Received on Tue Dec 31 1996 - 00:00:00 CST