Re: hanged on import on undo segment

  • From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
  • To: jonathan@xxxxxxxxxxxxxxxxxx
  • Date: Wed, 23 Nov 2005 16:20:44 -0400

Sorry wrong view
Checking links I found my parameter
SQL> select value from v$parameter where name='open_links';
4

is to small I have more than 4 links, could be that the reason to hang up?
Thanks :)


SQL> exec print_table('select * from V$SESSION_WAIT where SID=11');
SID                           : 11
SEQ#                          : 34903
EVENT                         : SQL*Net message from dblink
P1TEXT                        : driver id
P1                            : 675562835
P1RAW                         : **
UNPRINTABLE **
P2TEXT                        : #bytes
P2                            : 1
P2RAW                         : **
UNPRINTABLE **
P3TEXT                        :
P3                            : 0
P3RAW                         : **
UNPRINTABLE **
WAIT_TIME                     : 0
SECONDS_IN_WAIT               : 20034
STATE                         : WAITING
-----------------

Procedimiento PL/SQL terminado con Úxito.
--
//www.freelists.org/webpage/oracle-l


Other related posts: