Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: hanged on import on undo segment

Re: hanged on import on undo segment

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


Thanks Jonathan

select SID from v$session where program='IMP.EXE'-- where username is not null; 11

SQL> EXEC PRINT_TABLE('select * from v$session where SID=11');

SADDR                         : **
UNPRINTABLE **
SID                           : 11
SERIAL#                       : 16
AUDSID                        : 51
PADDR                         : **
UNPRINTABLE **
USER#                         : 5
USERNAME                      : SYSTEM
COMMAND                       : 0
OWNERID                       : 2147483644
TADDR                         : 14AAD41C
LOCKWAIT                      :
STATUS                        : ACTIVE
SERVER                        : DEDICATED
SCHEMA#                       : 54
SCHEMANAME                    : CTB
OSUSER                        : Administrador
PROCESS                       : 1316:1404
MACHINE                       : DAZASOFTWARE\SRVDAZSC
TERMINAL                      : SRVDAZSC
PROGRAM                       : IMP.EXE
TYPE                          : USER
SQL_ADDRESS                   : **
UNPRINTABLE **
SQL_HASH_VALUE                : 1141231982
PREV_SQL_ADDR                 : **
UNPRINTABLE **
PREV_HASH_VALUE               : 1141231982
MODULE                        :
MODULE_HASH                   : 0
ACTION                        :
ACTION_HASH                   : 0
CLIENT_INFO                   :
FIXED_TABLE_SEQUENCE          : 323
ROW_WAIT_OBJ#                 : -1
ROW_WAIT_FILE#                : 0
ROW_WAIT_BLOCK#               : 0
ROW_WAIT_ROW#                 : 0
LOGON_TIME                    : 23 Nov 2005
09:47:31
LAST_CALL_ET                  : 19543
PDML_ENABLED                  : NO
FAILOVER_TYPE                 : NONE
FAILOVER_METHOD               : NONE
FAILED_OVER                   : NO
RESOURCE_CONSUMER_GROUP       : SYS_GROUP
PDML_STATUS                   : DISABLED
PDDL_STATUS                   : ENABLED
PQ_STATUS                     : ENABLED
CURRENT_QUEUE_DURATION        : 0
CLIENT_IDENTIFIER             :


How do you know that you are "hanging" - if you've done an import that needs to create a lot of indexes and it's doing it on parallel-enabled tables, maybe the display has stopped but the machine is busy.

firstI checked I didn't clicked in the cmd windows :), Second my database is abuot 4 G, and the import of the biggest tables already was done, it was in the last stage "importing objects" and there are few object to take as much time.

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US