Slow impdp

select v.status, v.sid, v.serial#, io.block_changes, v.event, v.module from v$sess_io io, v$session v where io.sid = v.sid and v.saddr in ( select saddr from dba_datapump_sessions) order by sid; STATUS SID SERIAL# BLOCK_CHANGES EVENT MODULE ——– ———- ———- ————- ————————————————– ————————- ACTIVE 151 54669 5488 wait for unread message on broadcast channel udi@PDWHDBS01 (TNS V1-V3) ACTIVE 414… Continue reading Slow impdp

Consistent export with expdp using flashback_scn (cont)

Q: Will flashback_scn help to avoid primary key conflict during export and import of data pump? A: Yes. DB: 11.2.0.3 OS:Redhat Linux 5.4 Here is my test case. SQL> select current_scn from v$database; CURRENT_SCN ———– 1800301 SQL> select seq_test.currval from dual; CURRVAL ———- 102 SQL> begin 2 for i in 1..100 loop 3 insert into… Continue reading Consistent export with expdp using flashback_scn (cont)

Useful docs encountered lately

Encountering ora-00955 when trying to create primary key on an imported table in 10g (Doc ID 292096.1) Dropping constraints does not drop index simultaneously on 10.1.0.2. Error ORA-00955 may occur. ——— ‘Apparent Deadlock’ Errors Occurring in Threadpoolworker (文档 ID 1163103.1) ||AP||2016-10-13 00:09:11:500||RMBSCM||bea||WARN||WEB-APP||com.mchange.v2.async.ThreadPoolAsynchronousRunner||run||com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1704f50a — APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks! ||AP||2016-10-13 00:09:11:513||RMBSCM||bea||WARN||WEB-APP||com.mchange.v2.async.ThreadPoolAsynchronousRunner||run||com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1704f50a –… Continue reading Useful docs encountered lately

Consistent export using expdp with flashback_scn

The exp utility used the CONSISTENT=Y parameter to indicate the export should be consistent to a point in time. By default the expdp utility exports are only consistent on a per table basis. If you want all tables in the export to be consistent to the same point in time, you need to use the… Continue reading Consistent export using expdp with flashback_scn