Re: Slow connection to Oracle 10
From: Palooka <nobody_at_nowhere.com>
Date: Mon, 08 Sep 2008 22:21:36 +0100
Message-ID: <cHgxk.165201$W71.8946@newsfe12.ams2>
>
> Some of the problems were due to java version issues, especially with
> the EM agent. The more "sophisticated" your technology stack, the
> bigger the argument to keep Oracle on the latest patch of the latest
> version. Other times it's just as simple as Shakespeare showed.
>
> We can still laugh at Oracle for saying four years ago that "Oracle
> will work just fine" on hyperthreading. (Note: 205089.1)
>
The thing which bothers me is that OP appears to have taken Shakespeare's solution (undoubtedly the correct one here) as a silver bullet, and edited his sqlnet.ora, without actually trying to understand what is going on (hint: it's going all over the Windoze network trying to find a database which is probably on the same box).
Date: Mon, 08 Sep 2008 22:21:36 +0100
Message-ID: <cHgxk.165201$W71.8946@newsfe12.ams2>
joel garry wrote:
> On Sep 4, 7:48 pm, Michael Austin <maus..._at_firstdbasource.com> wrote:
>
>> Also, make sure you in your BIOS that you have hyperthreading turned >> OFF. As of 10.2.0.2, it was almost twice as fast turning this off. Not >> sure why this occurred, but it was consistent on more than 15 different >> x86 servers (HP, Dell, Compaq (it was ~2 years ago) NT2000/2003/XP)
>
> Some of the problems were due to java version issues, especially with
> the EM agent. The more "sophisticated" your technology stack, the
> bigger the argument to keep Oracle on the latest patch of the latest
> version. Other times it's just as simple as Shakespeare showed.
>
> We can still laugh at Oracle for saying four years ago that "Oracle
> will work just fine" on hyperthreading. (Note: 205089.1)
>
The thing which bothers me is that OP appears to have taken Shakespeare's solution (undoubtedly the correct one here) as a silver bullet, and edited his sqlnet.ora, without actually trying to understand what is going on (hint: it's going all over the Windoze network trying to find a database which is probably on the same box).
IMHO, this attitude is unfortunate; it won't aid him in thinking through his next problem.
Palooka Received on Mon Sep 08 2008 - 16:21:36 CDT