| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: expdp and clob ... any tricks to speed up?
Actually, it seems that the Xiotech device that I was trying
to write to has problems with supporting concurrent I/O.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paul
Drake
Sent: Wednesday, December 20, 2006 5:36 PM
To: mgogala_at_vmsinfo.com
Cc: rjamya_at_gmail.com; Oracle Discussion List
Subject: Re: expdp and clob ... any tricks to speed up?
Mladen,
I'd first blame workspace manager.
Seriously.
I hit this yesterday.
If this is a database upgraded from 9.2 or even one that was
created on a base release but which major patchsets have
been applied - there is an excellent chance that the version
of workspace manager is behind and is hosing expdp and/or
export.
Sorry that this has nothing to do with LOBs.
I'll bet that you're not sorry that this has nothing to do
with LONG RAWs.
No data dictionary scripts required here. All right, I'll use one:
col comp_id format a10
col comp_name format a35
col version format a10
select comp_id, comp_name, version, status
from dba_registry
order by 1;
COMP_ID COMP_NAME VERSIONSTATUS
---------- ----------------------------------- ---------- ------ CATALOG Oracle Database Catalog Views 10.1.0.4.0 VALID CATJAVA Oracle Database Java Packages 10.1.0.4.0VALID
CONTEXT Oracle Text 10.1.0.4.0 VALID EM Oracle Enterprise Manager 10.1.0.4.0 VALID EXF Oracle Expression Filter 10.1.0.4.0 VALID JAVAVM JServer JAVA Virtual Machine 10.1.0.4.0 VALID ORDIM Oracle interMedia 10.1.0.4.0 VALID OWM Oracle Workspace Manager 10.1.0.6.0 VALID XDB Oracle XML Database 10.1.0.4.0 VALID XML Oracle XDK 10.1.0.4.0VALID Paul
On 12/20/06, Mladen Gogala <mgogala_at_vmsinfo.com> wrote:
Funny thing is that the ordinary export works. The problem is that the schema is a bit fat (160GB), so the export and
Import would take until Christmas 2007. I believ that "data pump" is leaking all over the place and that it will become a
reliable tool in Oracle 12f.
From: oracle-l-bounce_at_freelists.org [mailto:
<mailto:oracle-l-bounce_at_freelists.org>
oracle-l-bounce_at_freelists.org] On Behalf Of rjamya
Sent: Wednesday, December 20, 2006 4:12 PM
To: Mladen Gogala
Cc: Oracle Discussion List
Subject: Re: expdp and clob ... any tricks to speed up?
Mladen,
come to think of it, it is an OS error, probably not Oracle.
Raj
On 12/20/06, Mladen Gogala < mgogala_at_vmsinfo.com
<mailto:mgogala_at_vmsinfo.com> > wrote:
ORA-19502: write error on file
"/ODATA/oradata/news/news_archive.dmp", blockno 5
(blocksize=4096)
ORA-27061: waiting for async I/Os failed
Linux Error: 6: No such device or address
Additional information: -1
Additional information: 4096
-- -- ALTER SESSION SET EVENTS 'immediate trace name hanganalyze level 4'; -- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 20 2006 - 17:25:48 CST
 |
 |