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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Resolved - Random long times to connect using BEQ adapter

RE: Resolved - Random long times to connect using BEQ adapter

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Wed, 22 Nov 2006 10:38:51 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE088BE@EXCNYSM0A1AJ.nysemail.nyenet>


It might explain it if sys and system were connecting with the oracle_sid set. The connection then would not use sqlnet, but either an ipc or beq connection - memory to memory. Was the connection made on the database server itself?



This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale Sent: Wednesday, November 22, 2006 10:24 AM To: rjamya_at_gmail.com; oracle-l
Subject: Re: Resolved - Random long times to connect using BEQ adapter

That doesn't explain why SYS and SYSTEM were fast (instant !). Or were you using different Unix accounts (eg "oracle" for "sys" and "system"
but another account , even if or not in the "dba" group, for other database accounts) ?

Hemant

At 07:41 PM Wednesday, rjamya wrote:
>This was weird, the connect times were long for non-privileged (i.e.
>except sys/system) but for sys and system it was instant.
>
>Eventually we found the problem, it was a bad gigabit interconnect was
>really bad.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 22 2006 - 09:38:51 CST

Original text of this message

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