Oracle Applications Release 11i version 11.5.8

[Jason_309]

Is anyone running this version of oracle on a HP-UX 11.11? If so i have some questions about disk stripping and memoery allocation.

[Steven E. Protter]

I am running similar products.

1) These products are memory hogs. Oracle is recommending 4 GB of Ram for HP-UX based servers. The more users you have the more memory you will need.

2) The binaries can sit on raid 5 disk without any real problems. The back end database, which is oracle needs its data, index and redo logs on raid 1 or raid 10 for decent performance.

SEP

[Jason_309]

I have 8 GB of physical memory and the user memory is going up to about 4GB when two instances are running. Also my buff Cache is 2GB.

So what you are sayiong is that you do not need to strip the disks? As of now they are not stripped.

[TwoProc]

More important the version (11.5.8 vs 11.5.6 vs 11.5.9, etc) - is the loads and number of users and the amount of data I/O throughput needed.

Let's just say it this way - are you having trouble keeping up with the servers you've got? Striping - do you mean "data striping" or actual disk striping (like Raid 0/1) .

Yes, I use striped data Raid 0/1.

Memory - I'd think that 8G for two instances is kind of small - but it's very possible for a well tuned app - that's all you need.

What do you statistics tell you? Is your cache hit ratio for the shared pool high (like 97%). Are you getting data via consistent gets instead of disk reads 97% of the time or so? If so, then you're probably OK.

Are you running many Raid 5 areas? I'd recommend that you have at least redo logs, undo, rollback, temp and archive logs on R 0/1 - and each of those on separate stripe sets.

Is this kind of what you're asking about?

[Jason_309]

How do i tell what amount of my buff cache is being used? In glance it always shows me the 3 GB number.

[TwoProc]

Well, since we're apparently starting at the basics (and that's OK - no problem) - I think the easiest thing for you to do is load the Oracle Enterprise Manager tool on your PC and point it at your database. This has a whole lot of good information for you to start having a look at things. Also, search otn.oracle.com and look for information on a package called "statspack". This will help you a lot also.
But, let's just start with the gui tools, and answer questions from there. Got access to the Oracle Client software for Windows? If not, you need to see about getting it from otn.oracle.com (downloads tab).
If you don't want the gui - you'll need to get started with statspack or the utlbstat/utlestat packages.