RE: expdp and clob ... any tricks to speed up?
- From: "Mladen Gogala" <mgogala@xxxxxxxxxxx>
- To: <bdbafh@xxxxxxxxx>
- Date: Wed, 20 Dec 2006 18:25:48 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Paul
Drake
Sent: Wednesday, December 20, 2006 5:36 PM
To: mgogala@xxxxxxxxxxx
Cc: rjamya@xxxxxxxxx; 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 VERSION
STATUS
---------- ----------------------------------- ----------
------
CATALOG Oracle Database Catalog Views 10.1.0.4.0
VALID
CATJAVA Oracle Database Java Packages 10.1.0.4.0
VALID
CATPROC Oracle Database Packages and Types 10.1.0.4.0
VALID
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.0
VALID
Paul
On 12/20/06, Mladen Gogala <mgogala@xxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxx
<mailto:mgogala@xxxxxxxxxxx> > 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';
Other related posts:
