Re: hanged on import on undo segment
- From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
- To: jonathan@xxxxxxxxxxxxxxxxxx
- Date: Wed, 23 Nov 2005 16:09:15 -0400
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
