Re: hanged on import on undo segment

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Wed, 23 Nov 2005 16:20:44 -0400
Message-ID: <cd4305c10511231220i21040654n5038cb496b0a2982@mail.gmail.com>

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.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 23 2005 - 14:22:48 CST