SQL Performance (MOSC)

MOSC Banner

create table ..as select over dblink hangs with the wait event "sql*net more data from dblink"

edited Jul 19, 2013 4:14AM in SQL Performance (MOSC) 5 commentsAnswered
The query select COUNT(*)  from vw_move2_nl@link_ibis_loader takes 0.2 sec. The statement create table test as select * from vw_move2_nl@link_ibis_loader WHERE 1=2 hangs.SQL> set autotrace on statistics
SQL>  select COUNT(*)  from vw_move2_nl@link_ibis_loader;

  COUNT(*)
----------
        49

Statistiken
----------------------------------------------------------
          1  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
        350  bytes sent via SQL*Net to client
        435  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

SQL> create table test as select * from vw_move2_nl@link_ibis_loader WHERE 1=2;

The same problem I have with the direkt load insert into table over dblink. Coventional insert runs immediately, but the same insert with hint /*+ append */ hangs,

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