Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle.exe=high CPU utilization on database logoff? Yes, logoff!

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

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 5 Feb 2004 08:20:54 -0800
Message-ID: <1ac7c7b3.0402050820.1d518fdf@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 Received on Thu Feb 05 2004 - 10:20:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US