Separate File System Question

[saw15]

Question about Unix File Systems:

If running multiple applications on Unix HP 11.0 and Oracle, each with their own file system,

Would or could there be:

1. Processing issues where each application confilcts with others appliations?
2. Memory issue's where one file system uses another area's temp space?
3. If one application was to bomb due to lack of disk space etc, would this impact the other applications?

It was my understanding that using a separate file system would prevent all of this.

Help or comments are much appreciated.

 

[bi]

Here are my thoughts:

1. If the filesystems are on the same physical disk or are on separate disks but those disks are accessed through the same controller, yes, there could be some conflicts between the two applications/databases. By conflicts, I mean performance issues. You need to pay attention not only to filesystems, but the disks they are on and the controllers that are being used. And some filesystems for Oracle databases really need to be totally separated and on the fastest disks you have.

2. Yes. If your kernel isn't large enough to handle two Oracle databases running at the same time, one of the applications/databases could, for example, grab memory or all the semaphores, preventing the other application from running efficiently. You may need to change some of the kernel parms when you add databases (and users) to a system.

3. If in bombing out the application holds on to memory (or even causes Oracle to come to a complete stop -- not usually a problem, though), yes, it would affect the other application. However, if it is simply the filesystem filling up with data (as opposed to filling up because you threw a core file), I've never seen that stop another database that was running on the system. The possible exception would be if you are writing log files to the same filesystem (for example, where Oracle is installed).

 

[greenpau]

If I may add to Bi's thoughts,

If you are concerned about the memory, you may want to look into using "Memory Windowing". This will allow you to isolate the Oracle instances to separate "Memory Windows".

This is used primarily to overcome the 2GB limit found in
Oracle 32bit.

Regards