Leos Bitto wrote:
I have had a very similar problem some time ago and I have filed a
support request via metalink.oracle.com. The answer was that this was
a known bug affecting Oracle 10.2.0.1.0 and servers with high uptime.
The recommended solution was to either restart the server, or install
a special patch from Oracle, or wait until 10.2.0.2.0 comes out and
upgrade. In my case I have moved the application to another server
with lower uptime and that helped. After 10.2.0.2.0 was published I
have upgraded and now even the server with high uptime works fine. YMMV
the 10.2.0.2.0 README doesn't seem to mention this issue.
do you have any Metalink reference that would discuss this issue?