Thanks for answerring.
Command line is like exp system/... full=y log=... file=... statistics=none
compress=n.
Important points, once again:
- 8.1.7.0.0 exp with SAME database (9.2 was created with import of that
database) is faster,
- lots of cpu time is spent selecting EXU9RLS, EXU9SYN, EXU9TAB. Part of export
that deals with data (exporting schemas) is fast. When it comes to "..
exporting synonyms" it behaves weird.
Here is tkprof of 9.2.0.2 export session (part of it):
SELECT OBJID, NAME, OWNER, OWNERID, TABLESPACE, TSNO, FILENO, BLOCKNO,
AUDIT$, COMMENT$, CLUSTERFLAG, PCTFREE$, PCTUSED$, INITRANS,
MAXTRANS, DEGREE, INSTANCES, CACHE, PROPERTY, DEFLOG, TSDEFLOG,
ROID, ROWCNT, BLKCNT, AVGRLEN, TFLAGS, TRIGFLAG, OBJSTATUS
FROM
SYS.EXU9TAB T$ WHERE OWNERID = :1 AND NOT EXISTS (
SELECT NAME FROM SYS.EXU8NXP N$
WHERE N$.OWNERID = T$.OWNERID AND N$.NAME = T$.NAME
AND N$.TYPE = 2) ORDER BY T$.NAME
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 275 0.03 0.06 1 2 0 0
Execute 275 0.26 0.26 0 0 0 0
Fetch 1483 15.43 16.87 47 1093674 0 1208
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2033 15.73 17.20 48 1093676 0 1208
SELECT POLGRP, POLICY, POLOWN, POLSCH, POLFUN, STMT, CHKOPT, ENABLED,
SPOLICY
FROM
SYS.EXU9RLS WHERE OBJOWN = :1 AND OBJNAM = :2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 49160 0.35 0.91 0 0 0 0
Execute 49160 43.29 47.72 0 0 0 0
Fetch 49160 3.06 3.97 0 562890 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 147480 46.71 52.60 0 562890 0 0
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
