Database Networking (MOSC)

MOSC Banner

Why is data retrieval so slow over network compared to locally?

edited Apr 22, 2015 10:05AM in Database Networking (MOSC) 1 commentAnswered

Oracle 11gR2 11.2.0.3 Patch 21 on Windows 2008R2 x86_64  Both EE and SE

When I run the following test case within SQL Developer 4.x or in sqlplus at the command prompt, on the actual database server, then the response time to get all the rows is under 6s.

drop table bak_itest;
create table bak_itest (dummy varchar2(100));
alter table bak_itest add (dummy2 varchar2(100));  
alter table bak_itest add (dummy3 varchar2(100)); 
alter table bak_itest add (dummy4 varchar2(100));  
alter table bak_itest add (dummy5 varchar2(100));

begin
  for v_i in 1..100000 loop
     insert into bak_itest values(v_i,v_i,v_i,v_i,v_i);
  end loop;
  commit;
end;
/

select * from bak_itest;
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center