Re: Any comments on 7.2.3?

In article <4chies$2af_at_atlas.tus.ssi1.com>, Andrew Zitelli <zitelli_at_tus.ssi1.com> writes:
|> I upgraded several HP/UX systems from 7.1.6 to 7.2.2.3. The systems
|> running HP/UX 9.04 (9000/715's and 9000/735's) seem to be running fine.
|> I have one HP 9000-K200 with dual processors, running HP/UX 10.01. The
|> K200 has serious performance problems on large transactions. The
|> identical transactions on the other systems cause no problems.
|>
|> The basic symptom of the problem is that during or after certain large
|> transactions (e.g., insert 8000+ records), the SMON process uses 99%
|> of the CPU for several minutes. It seems to be coalescing free space
|> but it is unclear why. This hinders all system users including
|> non-Oracle users.
|>
|> After several weeks of talking with Oracle support, they have indicated
|> it may be a bug. Numerous changes to our init.ora file have yielded no
|> improvement with this problem.
|>
|>

Have a look at my article on the Shared memory Leak. It looks like you may also need bug fix 312953. We had to upgrade to 7.2.2.4 plus the bug fix. We still have several serious problems which we can provide short-term work-arounds for:

1. MTS doesn't work worth a D***. We had to turn off MTS and go to strictly dedicated servers, taking a memory paging & swapping hit as a result.
2. SQL*NET database links will not work from releases prior to 7.0.16 to 7.2.2.4. We can get around this by having a dedicated machine running 7.0.16, and having the machines that can't do V2 reference it in their database links, and having it use a V2 connection to the 7.2.2.4 machine (taking a hit in extra network traffic).
3. 7.2.2.4 doesn't like V1 database links from other instances. We had to do emergency program maintenance changing V1 strings to V2 strings.

(BTW, connect using V1 strings is fine ... just DB links crap out)

Bill Beaton

-- 
Names:	Bill Beaton			beatonb_at_cadvision.com
					Bill_Beaton_at_digitech.ab.ca
Phone:	(403) 295-3254 (Home)		(403) 266-8622 (work)