I notice on a data pump job it's taking awhile to gen stats. When I look it's actually doing ANALYZE TABLECOMPUTE STATISTICS.
Can I tell it to estimate stats or not gen stats at all?
impdp sysadm/pass full=y DIRECTORY=DATA_PUMP_DIR DUMPFILE=HR89%u.dmp PARALLEL=8 LOGFILE=HR89_IMP.log JOB_NAME=HR89_IMPORT_SYSADM
I'm using Oracle 10203 OEL 4.5
thanks
steve