querying CLOBs

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Thu, 3 Aug 2000 13:16:48 -0700 (PDT)
Message-Id: <10578.113791@fatcity.com>

--0-719885386-965333808=:10814

Content-Type: text/plain; charset=us-ascii

I've noticed a significant difference in the time it takes to query a CLOB datatype if I connect to the database with a Net8 service name (i.e. sqlplus user/password_at_Service) instead of connecting via the BEQ protocol (ORACLE_SID=sidname ; sqlplus user/password ). The same thing happens during an export. If I set the ORACLE_SID and connect as user/password, the table exports in about 2 seconds. If I connect as user/password_at_service_name it takes over a minute to export. Why is this? Both client and server are on the same machine.

---

Do You Yahoo!?
Kick off your party with Yahoo! Invites.
--0-719885386-965333808=:10814

Content-Type: text/html; charset=us-ascii

I've noticed a significant difference in the time it takes to query a CLOB datatype if I connect to the database with a Net8 service name (i.e. sqlplus user/password_at_Service) instead of connecting via the BEQ protocol (ORACLE_SID=sidname ; sqlplus user/password ). The same thing happens during an export. If I set the ORACLE_SID and connect as user/password, the table exports in about 2 seconds. If I connect as user/password_at_service_name it takes over a minute to export. Why is this? Both client and server are on the same machine.<BR><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br> Kick off your party with Yahoo! Invites.
--0-719885386-965333808=:10814--
Received on Thu Aug 03 2000 - 15:16:48 CDT