Data Base Crashes

[omegamark]

Hi,
i have a problem with my database,
it crashes frequently,
application is a 3 tier architecture based application(web based application),we use COM and DCOM objects and the database crashes frequently saying unspecified errors,and some one told m ethat this might be due to memory leakage issue in 8.1.7.
is this true,please let me know the fix fo rthis,
my version is 8.1.7.

[marist89]

What's the alert.log say? Any Trace files dumped?

[marist89]

Platform?

[mike73]

What version of ORacle are you running on ??? you are right about the memory leak on 8.1.7 but Memory leak won't cause your database crashed. It will dergrade your performance. 8.1.7.3.0 should take care of the memory leak problem.

[pravin]

Does this usually happen when u run/ execute a front end application with backend data

[omegamark]

yes this does happen when we execute front end application,
Version is 8.1.7 and platform is NT,
thanks,

[julian]

8.1.7.3.0 should take care of the memory leak problem.

Having in mind that 8.1.7.3.0 has its own memory leak bugs :-)

[omegamark]

Does oracle 8.1.7.3.0 has also leaks ,
pls let me know,
thanks,

[julian]

Yes, it has, the workaround is:

event="10262 trace name context forever, level 10000"

You can replace 10000 with 1 if you want to neglect all leaks, not only the ones below 10000 bytes.