rick AT oyarsa.com (rlr1031) wrote in message news:<978df3d.0106290244.61c7eaee AT posting.google.com>...
> Has anyone experienced a problem with contention on the file oraus.msg in a
> high volume, OLTP, OCI-based application?  I know the file is used to
> translate messages, but how is it being opened and used by Oracle?  And when
> in the processing of an OCI statement is this being hit?  On the client?  On
> the server?  Prior to sending the response?
> Our internal database execution times look good, but we have occasional slow
> downs in the response from the OCI statements.
> 
> tia,
> Oracle 8.1.7.x, single Unix platform with clustered disks (sorry cannot be
> more specific at this time)

Are you sure it's oraus.msg, not oraus.msb? All Oracle processes, background or foreground, open $ORACLE_HOME/rdbms/mesg/oraus.msb (note msb, not msg) with a file descriptor 9 (I only checked 8.1.6 and 8.1.7 for Sparc Solaris 2.6, UFS filesystem). The file is kept open during the lifetime of the Oracle process. Your observation is interesting and I've never seen anyone mention this contention. But posting a little more details should help. What OS or ORA error do you get if any? Can you show us a screen shot with no or very little editing?

There's nothing you can do to alleviate the problem. Actually, do you really have contention problem on the message file? How many errors do you get and how often? There may be a bug in 8i that almost every SQL command results in reading these words in oraus.msb: "column %s, specified in logmnr.opt file, does not exist in table..."

Yong Huang
yong321 AT yahoo.com