Prev: Oracle releases AWR report for free
Next: Oracle Database 11g Release 2 for Windows, experience?
From: zigzagdna on 4 Apr 2010 15:01

I am using Oracle 11.1.0.7.1 on HP UNIX 11.0. I ma using expdp and
find it extremely slow. However. Most of the waiting time is during
metadata (see below) where it waits for several hours. When it starts
exporting the rows, it progresses reasonably fast.
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/
INDEX
I have seen some threads on Metalink as well as on Google. All otf
tem point to these problems in Oracle 10.2 expdp version, but I see
same problem in Oracle 11.1.0.7.1 as well. A suggestion to exclude
STAITISTICS has not helped me:
expdp system/password directory=expdp_dir dumpfile=$BackupExportFile
logfile=$TLOGFILE \
full=Y compression=all exclude=STATISTICS TRACE=480300
I have turned on expdp tracing and I see statements like following for
various indexes and do not give me any clue to speed things up.
KUPW:14:48:25.668: 1: Base Process info: 6122 and processing status: C
and processing state: R
KUPW:14:48:25.668: 1: new state: R
KUPW:14:48:25.668: 1: new status: C
KUPW:14:48:25.668: 1: In procedure BUILD_SUBNAME_LIST with
INDEX:MAXDEMO71.CONTRACT_NDX2
KUPW:14:48:25.669: 1: In function NEXT_PO_NUMBER
KUPW:14:48:25.669: 1: FORALL called.
KUPW:14:48:25.676: 1: FORALL returned.
KUPW:14:48:25.678: 1: DBMS_LOB.TRIM called. v_md_xml_clob
KUPW:14:48:25.679: 1: DBMS_LOB.TRIM returned.
KUPW:14:48:25.679: 1: DBMS_METADATA.FETCH_XML_CLOB called. Handle:
200001


Is ether anyway to speed expdp.
From: javor on 4 Apr 2010 15:30
Try if adding this parameter helps: VERSION=10.2.0.2 (you may need to remove compression parameter since it's not supported in 10.2).
You can also try excluding index statistics exclude=index_statistics

---
frmsrcurl: http://compgroups.net/comp.databases.oracle.server/expdp-is-painfully-slow
From: zigzagdna on 4 Apr 2010 17:10
On Apr 4, 3:30 pm, javor <u...(a)compgroups.net/> wrote:
> Try if adding this parameter helps: VERSION=10.2.0.2 (you may need to remove compression parameter since it's not supported in 10.2).
> You can also try excluding index statistics exclude=index_statistics
>
> ---
> frmsrcurl:http://compgroups.net/comp.databases.oracle.server/expdp-is-painfully...

I cannot reduce version because I am using some partitioing fetaures
which are only in 11.1.
Problem seems to be doiman index (seraching on google). Does not look
like Oracle has fixe dthis problem/bug in 11.1 even though problem was
reported back in 10.x.
From: javor on 4 Apr 2010 17:49
There are multiple bugs related to datapump performance in 11.1. There are patches for some of them.
* Look at Metalink Note 984167.1
* You can also try PSU 11.1.0.7.2 (it may have some related bugs fixed)

---
frmsrcurl: http://compgroups.net/comp.databases.oracle.server/expdp-is-painfully-slow
From: John Hurley on 5 Apr 2010 10:59
On Apr 4, 3:01 pm, zigzagdna <zigzag...(a)yahoo.com> wrote:

snip

> I am using Oracle 11.1.0.7.1 on HP UNIX 11.0. I ma using expdp and

HPUX 11.0 and 11.1.0.7.1 ? Is that even possible?



 |  Next  |  Last
Pages: 1 2
Prev: Oracle releases AWR report for free
Next: Oracle Database 11g Release 2 for Windows, experience?