Re: Oracle.exe=high CPU utilization on database logoff? Yes, logoff!

drak0nian_at_yahoo.com (Paul Drake) wrote in message news:<1ac7c7b3.0402050820.1d518fdf_at_posting.google.com>...
> "Thomas T" <T_at_T> wrote in message news:<40213344_at_rutgers.edu>...
> > Hey everyone, I've got a question that I can't seem to figure out; maybe you
> > can help? I've got an Oracle 8i database on a Windows 2000 Server o/s. For
> > a while, when I was done with an SQL Plus session on my workstation, if I
> > did a "disconnect", it took about 9 seconds for me to get the SQL prompt
> > back. I just thought my system was slow...
> <snip>
> > -Thomas
>
> you aren't running a patchset such as 8.1.7.4.10, are you?
> did you check the bdump and udump folders?
>
> you may have processes leaking large amounts of memory at disconnect.
>
> we hit this issue, the solution was to sit back on 8.1.7.4.6.
>
> Pd

sorry - I forgot to mention, that the parameter cursor_sharing=FORCE with 8.1.7.4.10 causes memory leaks. setting cursor_sharing back to EXACT caused the memory leaks to stop.

Pd Received on Sat Feb 07 2004 - 10:46:42 CST