ias 10G application server, how do you do it?

[Victor BERRIDGE]

Hi Steven,
I unfortunatly cleaned up my mailbox so I have no info left and have to wait till a DBA will be kind enough to spare some time with me...
but here are some perf I collected with your famous script...
You will not see anything of the swinstall because using my own account (that still works... yes hard times lately...)

Sorry - previous post missed the click attachment..

All the best
Victor

[Alzhy]

Stephen,

I've polled all my Compadres in the industry and all those that have Oracle 10 Infrastructure have their Application server running on a separate boxen - another UNIX, Linux or Windows.

Although not impossible, it will be tricky to tune your environment so it is friendly to the Database as well as the Application server (IAS).

With 10G.. I think all tuning rules that applied to 9i still is valid and the deep division between cooked and raw still exists.

[Steven E. Protter]

Victor,

Well, maybe it shows you are getting decent peformance. Thats true.

When I ran these reports myself there was nothing on them. The performance issue seems somewhat related to shared memory performance.

I have yet to be able to measure that. I need an addition to my famous script set.

I am confused and frustrated.

We seem to be able to develop the performance problem, but we have not identified an exact trigger. Maybe its apache interference, but at least once we had the problem with apache shut. It appears 10G is based on apaceh 1.3, which directly contradicts what they told us in teleconference. Surprise.

SEP

[wayne_104]

Hi Steven

How did you eventually sort out your problem i have the same problem.

[Steven E. Protter]

It was pretty much oracle Q&A problems all the way. Installed fixes from Oracle, tried to keep our support calls out of certain inefficient call centers. Vanilla all the way.

SEP

[Eric Antunes]

Hi Steven,

Did you saw Metalink Note 260449.1?

Best Regards,

Eric Antunes

[wayne_104]

Thanks You are a star

[TwoProc]

Steven, I apologize for amount of different directions that this response it taking - but please allow me just to come up with possibles that have occured to me...

Just wondering, database 9.2.0.4 had a lot of problems with latch contention on HPUX (maybe others too) - which we got out of by patching up to 9.2.0.5. I'm guessing this could be it - although you said that this seems to slow down over time with nothing running...

As a point of reference - on a Linux box we've setup a test server to get a feel for Oracle's Portal product - it's got the same setup that you're describing - but I'm not seeing this performance problem.

Have you run a statspack set to see what the waits are for?

Also, in an effort to isolate whether or not it is the Apache Server or the database - why not just create a few tests that are going to hit the Apache Server only, then starting hitting individual modules - plsql module, portal module, etc. May with a bit of repetition you could identify it is Apache.

Another thought the portal runs in Java, and I'm counting four different ones running on our server right now. Isee that most start with a -Xmx256m ,and one starts with -Xmx512m. In an effort to rule out garbage collection in the java server (I've seen this tear up java servers and their associated servlets) can you increase all of the startup parameters for each one to -Xmx1024m ?

From what I've seen with out java servlets running on servers started with too little memory - you could be invoking garbage collection for memory issues at a heavy rate, and this could be causing your problem. I've noticed this type of behavior in Oracle Product Configurator when memory sizes were set too low. If this turns out to be part of your problem, then I would think that some process is repeatedly running in the java servlets and the servlet is slowly leaking/fragmenting memory.

[Steven E. Protter]

Good post.

I'll look into it.

SEP